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