sgam
Tables (5)
participated_user (참여 유저)
- participatedUserNo (participated_user_no) — INT — Primary key — NOT NULL
- participatedUserName (participated_user_name) — VARCHAR(10)
- userNo (user_no) — VARCHAR(10) — Foreign key → user.Key — NOT NULL
- roomNo (room_no) — VARCHAR(10) — Foreign key → room.Key — NOT NULL
- isMaster (is_master) — INT
quiz (퀴즈)
- Key — Primary key — NOT NULL
- quizContent (quiz_content) — VARCHAR(100)
- answer — INT
- score — INT
room (방)
- Key — Primary key — NOT NULL
- roomNo (room_no) — INT
- roomName (room_name) — VARCHAR(10)
tier (등급)
- tierNo (tier_no) — INT — Primary key — NOT NULL
- tierName (tier_name) — VARCHAR(10)
- tierScore (tier_score) — INT
user (유저)
- Key — Primary key — NOT NULL
- userNo (user_no) — INT
- userName (user_name) — VARCHAR(10)
- tierNo (tier_no) — INT — Foreign key → tier.tierNo — NOT NULL
- score — INT