퀴즈게임
테이블 (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