DULM
Tables (4)
playlist_items
- id — UUID
- room_id — UUID — Foreign key → rooms.id — NOT NULL
- video_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- thumbnail — VARCHAR(255)
- duration — INT
- order_index — INT — NOT NULL
room_members
- id — UUID
- room_id — UUID — Foreign key → rooms.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
rooms
- id — UUID
- title — VARCHAR(255) — NOT NULL
- host_id — UUID — Foreign key → users.id — NOT NULL
- is_private — BOOLEAN — NOT NULL
- invite_code — VARCHAR(20)
- current_video_id — VARCHAR(50)
- position — INT
- is_playing — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL