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