A506 ERD
Tables (6)
Audio_Message (Audio)
- audio_message_id — int — Primary key — NOT NULL
- audio_data — varchar
- timestamp — timestamp
- participant_id — int — Foreign key → Participant.participant_id — NOT NULL
- message_data — text
- meeting_id — int
Meeting
- meeting_id — int — Primary key — NOT NULL
- meeting_name — varchar
- host_id — int
- start_time — timestamp
- end_time — timestamp
Participant
- participant_id — int — Primary key — NOT NULL
- participant_name
- role — varchar
- user_id — int — Foreign key → User.user_id — NOT NULL
- meeting_id — int — Foreign key → Meeting.meeting_id — NOT NULL
Report
- report_id — int — Primary key — NOT NULL
- summary — text
- meeting_id — int — Foreign key → Meeting.meeting_id — NOT NULL
Reservation
- reservation_id — int — Primary key — NOT NULL
- start_time — timestamp
- user_id — int — Foreign key → User.user_id — NOT NULL
- meeting_id — int — Foreign key → Meeting.meeting_id — NOT NULL
User
- user_id — int — Primary key — NOT NULL
- password — varchar
- name — varchar
- id — varchar
- email — varchar