nomoney ERD ver0
Tables (4)
availability_vote
- id (Key) — UUID — Primary key — NOT NULL
- participant_id — CHAR(36) — NOT NULL
- date_option_id — CHAR(36) — NOT NULL
- is_available — BOOLEAN — NOT NULL
- voted_at — DATETIME — NOT NULL
date_option
- id (Key) — UUID — Primary key — NOT NULL
- id — CHAR(36)
- meeting_id — CHAR(36) — NOT NULL
- date — DATE — NOT NULL
- start_time — TIME
- end_time — TIME
- created_by — CHAR(36) — NOT NULL
- created_at — DATETIME — NOT NULL
meeting
- id (Key) — UUID — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- access_token — VARCHAR(100) — NOT NULL
- host_name — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME
participant
- id (Key) — UUID — Primary key — NOT NULL
- meeting_id — CHAR(36) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- is_host — BOOLEAN — NOT NULL
- joined_at — DATETIME — NOT NULL