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