meeter

Tables (4)

Available Days (available_days)

  • Meeting ID (meeting_id) — INT(11) — Foreign key → meeting.Meeting ID — NOT NULL
  • Day (day) — DATE

Available Time Slots (available_timeslots)

  • Timeslot ID (timeslot_id) — INT(11) — Primary key — NOT NULL
  • Participant ID (participant_id) — INT(11) — Foreign key → Participant.Participant ID — NOT NULL
  • Time start (time_start) — DATETIME
  • Time end (time_end) — DATETIME

Participant (participant)

  • Participant ID (participant_id) — INT(11) — Primary key — NOT NULL
  • Meeting ID (meeting_id) — INT(11) — Foreign key → meeting.Meeting ID — NOT NULL
  • Name (name) — VARCHAR(12)

meeting

  • Meeting ID (meeting_id) — INT(11) — Primary key — NOT NULL
  • Time Range Start (time_range_start) — TIME
  • Time Range End (time_range_end) — TIME
  • Schedule Start (schedule_start) — DATETIME — NOT NULL
  • Schedule End (schedule_end) — DATETIME — NOT NULL
  • Meeting Title (meeting_title) — VARCHAR(12)
  • Meeting Description (meeting_desc) — TEXT — NOT NULL
  • Meeting URL (meeting_url) — TEXT