DD
Tables (7)
CHAT_MSG
- msg_id — BIGINT
- room_id — BIGINT — Foreign key → WATCH_ROOM.room_id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- msg_type — ENUM( 'TEXT', 'SYSTEM' ) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- INDEX — idx_chat_room_time
PLAYBACK_SYNC
- sync_id — BIGINT
- room_id — BIGINT — Foreign key → WATCH_ROOM.room_id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- action_type — ENUM( 'PLAY', 'PAUSE', 'SEEK', 'SPEED' ) — NOT NULL
- position_sec — FLOAT — NOT NULL
- playback_rate — FLOAT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- INDEX — idx_sync_room_time
PLAYLIST_VIDEO
- pv_id — BIGINT
- room_id — BIGINT — Foreign key → WATCH_ROOM.room_id — NOT NULL
- video_id — BIGINT — Foreign key → VIDEO.video_id — NOT NULL
- order_num — INT — NOT NULL
- added_by — BIGINT — Foreign key → USERS.user_id — NOT NULL
- added_at — DATETIME — NOT NULL
- INDEX — idx_pv_room_order
ROOM_MEMBER
- member_id — BIGINT
- room_id — BIGINT — Foreign key → WATCH_ROOM.room_id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- role — ENUM('HOST', 'GUEST') — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
- is_active — BOOLEAN — NOT NULL
- INDEX — idx_room_active
- INDEX — idx_user_rooms
USERS
- user_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_email
- INDEX — idx_username
VIDEO
- video_id — BIGINT
- youtube_url — VARCHAR(500) — NOT NULL
- youtube_key — VARCHAR(20) — NOT NULL
- title — VARCHAR(300)
- thumbnail_url — VARCHAR(500)
- duration — INT
- channel_name — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- INDEX — idx_youtube_key
WATCH_ROOM
- room_id — BIGINT
- host_user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- current_video_id — BIGINT — Foreign key → VIDEO.video_id
- room_name — VARCHAR(100) — NOT NULL
- room_code — VARCHAR(20) — NOT NULL
- max_members — INT — NOT NULL
- is_private — BOOLEAN — NOT NULL
- password — VARCHAR(100)
- status — ENUM( 'WAITING', 'PLAYING', 'ENDED' ) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_room_code
- INDEX — idx_room_status
- INDEX — idx_host_user