Janggi

Tables (4)

attendance (출석기록)

  • attendance_id (Key) — int — Primary key — NOT NULL — auto increment
  • crew_id (크루 식별자) — int — Foreign key → crew.crew_id — NOT NULL
  • attendance_date (출석일) — Date — NOT NULL
  • start_time (등교시간) — TIME
  • end_time (하교시간) — TIME

crew (크루)

  • crew_id (Key) — int — Primary key — NOT NULL
  • nickname (닉네임) — varchar — unique

game (장기 게임)

  • game_id (게임 아이디) — long — Primary key — NOT NULL — AUTO_INCREMENT
  • room_name (방 이름) — varchar(10) — NOT NULL
  • current_turn (마지막으로 둔 나라의 턴) — enum(CHO,HAN) — NOT NULL
  • last_played_at (마지막으로 플레이한 시간) — TimeStamp — NOT NULL

piece_position (기물위치)

  • piece_position (기물위치 아이디) — int — Primary key — NOT NULL
  • game_id (게임 아이디) — long — Foreign key → game.game_id — NOT NULL
  • piece_row (행) — int — NOT NULL
  • piece_column (열) — int — NOT NULL
  • piece_type (기물의 종류) — enum — NOT NULL
  • dynasty (나라) — enum(CHO,HAN) — NOT NULL