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