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