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

• location
• room
• equipment (available)