TicTacToe Game

Tables (3)

game_kde (게임 상태)

  • seq (Primary Key) — int(11) — Primary key — NOT NULL
  • title (Field) — varchar(20)
  • board (Field2) — varchar(100)
  • player1 (Field3) — varchar(20)
  • player2 (Field4) — varchar(20)
  • status (Field5) — char(2)
  • lastUpdate (Field6) — varchar(25)

game_user_kde (게임 회원 정보)

  • userid (Primary Key) — varchar(20) — Primary key — NOT NULL
  • userpw (Field) — varchar(100)
  • playername (Field2) — varchar(20)

user_record_kde (게임 전적 기록)

  • userid (Primary Key) — varchar(20) — Foreign key → game_user_kde.userid — NOT NULL
  • total (Field) — int(11)
  • win (Field2) — int(11)
  • lose (Field3) — int(11)