wiki:Database

Version 4 (modified by ejona, 17 years ago) ( diff )

--

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)

Attachments (1)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.