퀴즈게임

테이블 (4)

CHABOT (Chatbot)

  • ChatBotID (Key) — INT — 기본 키 — NOT NULL
  • MemberID (Key2) — INT — 외래 키 → MEMBER.MemberID — NOT NULL
  • Question (Field2) — TEXT
  • Answer (Field3) — TEXT

CONSUMPTION (Consumption)

  • ConsumptionID (Key) — INT — 기본 키 — NOT NULL
  • MemberID (Field) — INT
  • Date (Field2) — DATE
  • ConsumptionHistory (Field3) — VARCHAR(50)
  • Field4

GAME (Game)

  • GameID (Key) — INT — 기본 키 — NOT NULL
  • MemberID (Key2) — INT — 외래 키 → MEMBER.MemberID — NOT NULL
  • GameRound (Field2) — INT
  • Quiz (Field3) — TEXT
  • Answer (Field4) — VARCHAR(50)
  • CorrectAnswer (Field5) — VARCHAR(50)

MEMBER (Member)

  • MemberID (Key) — INT — 기본 키 — NOT NULL
  • UserName (Field) — VARCHAR(50)
  • Gender (Field2) — VARCHART(10)
  • Birth (Field3) — VARCHAR(20)
  • Point (Field4) — INT