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