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 key
  • equipment key
  • count
• meeting_pending, participants_pending, equipment_needed_pending (may combine with _final tables)

• calendar_inclusion
• calendar_exclusion
• calendar_preference
• appointments_inclusion
• appointments_exclusion
• appointments_preference

Todo

• location
• room
• equipment (available)