미니싸피천국 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