CLOV mysql
Tables (4)
background
- background_id — BIGINT — Primary key — NOT NULL
- background_url — TEXT — NOT NULL
- background_title — VARCHAR(16) — NOT NULL
files
- file_id — BIGINT — Primary key
- content_type — ENUM("PHOTO","VIDEO") — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- saved_at — DATETIME
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
room_participants
- participant_id — BIGINT — Primary key — NOT NULL
- client_id — VARCHAR(64) — NOT NULL
- is_host — BOOLEAN — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
rooms
- room_id — BIGINT — Primary key — NOT NULL
- status — ENUM('OPEN', 'CLOSED',)
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME
- room_code — VARCHAR(6) — NOT NULL