미니싸피천국 ERD

테이블 (6)

Untitled (rooms)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (title) — varchar(30) — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field (capacity) — INT — NOT NULL

Untitled (room_players)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (score) — INT — NOT NULL
  • Field (role) — varchar(10) — NOT NULL
  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (room_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (room_games)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (current_round) — int — NOT NULL
  • Field (round_limit) — int — NOT NULL
  • Key (room_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (game_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (members)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (username) — varchar(30) — NOT NULL
  • Field (password) — varchar(100) — NOT NULL
  • Field (nickname) — varchar(30) — NOT NULL
  • Field (role) — varchar(10) — NOT NULL
  • Field (score) — int — NOT NULL

Untitled (games)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (title) — varchar(10) — NOT NULL
  • Field (description) — varchar(1024) — NOT NULL
  • Field (max_round) — int — NOT NULL

Untitled (room_chat)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (message) — VARCHAR(100) — NOT NULL
  • Key (room_player_id) — INT — 외래 키 → Untitled.Key — NOT NULL