omok

Tables (3)

games (경기)

  • gamesid (pk) — NUMBER — Primary key — NOT NULL
  • user1 (유저1 pk) — VARCHAR
  • user2 (유저2 pk) — VARCHAR
  • gameDate (게임한 날짜) — DATE
  • winner (승리한 유저) — VARCHAR
  • gamemode (모드) — VARCHAR

logging (로깅)

  • loggingid (pk) — NUMBER — Primary key — NOT NULL
  • gamepk (경기 pk) — NUMBER
  • x (x좌표) — NUMBER
  • y (y좌표) — NUMBER
  • stone (돌 색깔) — VARCHAR

users (회원)

  • usersid (pk) — VARCHAR — Primary key — NOT NULL
  • id (회원 아이디) — VARCHAR
  • pwd (비밀번호) — VARCHAR
  • nickname (닉네임) — VARCHAR
  • wincnt (승리횟수) — NUMBER
  • gamecnt (전체게임횟수) — NUMBER
  • point (포인트) — NUMBER