webGame
테이블 (4)
게임방 (Untitled9)
- room_id (Key) — BIGINT — 기본 키 — NOT NULL
- created_at (Field) — DATETIME
- updated_at (Field2) — DATETIME
- title (Field3) — TEXT
- gameType (Field4) — TEXT
- difficulty (Field5) — TEXT
- maxParticipants (Field6) — BIGINT
대기방-유저 (Untitled3)
- room_user_id (Key) — BIGINT — 기본 키 — NOT NULL
- room_id (Key3) — BIGINT — 외래 키 → 게임방.room_id — NOT NULL
- user_id (Key2) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
유저 (Untitled)
- user_id (Key) — BIGINT — 기본 키 — NOT NULL
- password (Field2) — VARCHAR(20)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
- name (Field5) — VARCHAR(20)
- dob (Field) — DATETIME
- character (Field6) — TEXT
- correctAnswer (Field7) — BIGINT
퀴즈 (Untitled2)
- quiz_id (Key) — BIGINT — 기본 키 — NOT NULL
- room_id (Key3) — BIGINT — 외래 키 → 게임방.room_id — NOT NULL
- question (Field) — TEXT
- answer (Field2) — TEXT
- choices (Field3) — TEXT