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