pirate

Tables (6)

Game (게임)

  • 게임ID (game_id) — bigint — Primary key — NOT NULL — autoincrement
  • 상태 (status) — int(3) — NOT NULL — 0 : waiting, 1 : playing, 2 : ended
  • 총 라운드 (total_round) — int — NOT NULL
  • 시작한 시간 (started_at) — datetme — NOT NULL
  • 끝난 시간 (ended_at) — datetime — NOT NULL
  • 생성날짜 (created_at) — datetime — NOT NULL
  • 상태ID (state) — int — Foreign key → GameState.상태ID — NOT NULL

GameRound (라운드)

  • 게임라운드id (game_round_id) — bigint — Primary key — NOT NULL — autoincrement
  • 게임ID (game_id) — bigint — Foreign key → Game.게임ID — NOT NULL
  • 라운드 (round) — int — NOT NULL
  • 카드 수 (cards) — int — NOT NULL
  • 생성날짜 (created_at) — datetime — NOT NULL

GameState (게임상태)

  • 상태ID (state_id) — bigint — Primary key — NOT NULL
  • 게임 상태 (state) — varchar(20) — NOT NULL

GameUser (Untitled)

  • 게임유저ID (game_user_id) — bigint — Primary key — NOT NULL — autoincrement
  • 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
  • 게임ID (game_id) — bigint — Foreign key → Game.게임ID — NOT NULL
  • 점수 (score) — int — NOT NULL
  • 생성날짜 (created_at) — datetime — NOT NULL

GameUserRound (게임유저별 라운드 정보)

  • 게임유저ID (game_user_id) — bigint — Foreign key → GameUser.게임유저ID — NOT NULL
  • 게임라운드id (game_round_id) — bigint — Foreign key → GameRound.게임라운드id — NOT NULL
  • 라운드 (round) — int — NOT NULL
  • 베팅 수 (bid) — int — NOT NULL
  • 승수 (trick) — int — NOT NULL
  • 보너스 점수 (bonus) — int — NOT NULL
  • 생성날짜 (created_at) — datetime — NOT NULL

User (사용자)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL — autoincrement
  • 로그인ID (login_id) — varchar(20) — NOT NULL — unique
  • 비밀번호 (password) — varchar(4) — NOT NULL
  • 닉네임 (nickname) — varchar(10) — NOT NULL
  • 생성날짜 (created_at) — datetime — NOT NULL