Changes between Version 2 and Version 3 of Database


Ignore:
Timestamp:
11/07/2007 08:07:01 PM (17 years ago)
Author:
ejona
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Database

    v2 v3  
    33== Tables ==
    44 * user
    5  * group->usergroup
     5   * id (key)
     6   * username
     7   * passhash (use id as salt - as if we had time)
     8   * fullname
     9   * admin bit
    610 * meeting_final
    7  * meeting_pending (may combine both meeting tables)
     11   * id (key)
     12   * name
     13   * begin (Datetime)
     14   * end (Datetime)
     15   * description
     16 * participants_final
     17   * id (key) (? - see equipment_needed_final)
     18   * user key
     19   * meeting key
     20   * active bit
     21   * important bit
     22 * equipment_needed_final
     23   * participants key (use this instead of user and meeting keys?)
     24   * user key
     25   * meeting key
     26   * equipment key
     27   * count
     28 * meeting_pending, participants_pending, equipment_needed_pending (may combine with _final tables)
     29
    830 * calendar_inclusion
    931 * calendar_exclusion
    … …  
    1234 * appointments_exclusion
    1335 * appointments_preference
    14  * schedule
    15  * equipment
    16  * participants (has active and important bits)
    1736
    18 todo:
     37== Todo ==
    1938 * location
    2039 * room