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