Database
Tables
- user
- id (key)
- username
- passhash (use id as salt - as if we had time)
- fullname
- admin bit
- meeting_final
- id (key)
- name
- begin (Datetime)
- end (Datetime)
- description
- participants_final
- id (key) (? - see equipment_needed_final)
- user key
- meeting key
- active bit
- important bit
- equipment_needed_final
- participants key (use this instead of user and meeting keys?)
- user key
- meeting_final key
- equipment key
- count
- meeting_pending, participants_pending, equipment_needed_pending (may combine with _final tables)
- calendar_inclusion
- id (key)
- name
- url
- last_update
- calendar_exclusion (see calendar_inclusion)
- calendar_preference (see calendar_inclusion)
- appointments_inclusion
- calendar_inclusion key
- begin (Datetime)
- end (Datetime)
- name
- description
- appointments_exclusion (see appointments_inclusion)
- appointments_preference (see appointments_inclusion)
Todo == DONE
- location
- room
- equipment (available)
Last modified
17 years ago
Last modified on 11/20/2007 08:52:59 PM
Attachments (1)
-
SynergyDatabase.sql
(3.9 KB
) - added by 17 years ago.
Inicial Synergy Database
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.