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