23-2 Web System Team Project

Tables (3)

Meet (meetings)

  • Key (meeting_id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR — NOT NULL
  • Field (admin_password) — VARCHAR — NOT NULL
  • Field (purpose) — VARCHAR — NOT NULL — ENUM
  • Field (num_of_participants) — VARCHAR
  • Field (vote_expires_at) — DATETIME

Untitled (users)

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Key (meeting_vote_id) — BIGINT — Foreign key → Meet.Key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (password) — VARCHAR
  • Field (email) — VARCHAR

Untitled (schedule_votes)

  • Key (schedule_votes_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (available_date) — DATE — NOT NULL
  • Field (available_times) — VARCHAR — NOT NULL