omok

Tables (5)

Game (게임정보)

  • Gid (gid) — INT(11) — Primary key — NOT NULL
  • Rid (rid) — INT(11) — Foreign key → Room.Rid — NOT NULL
  • Mid (mid) — INT(11) — Foreign key → Room.Mid — NOT NULL
  • Id (id2) — INT(11) — Foreign key → Room.Id — NOT NULL
  • Data (data) — LONGTEXT(4294967295)
  • Auid (auid) — INT(11)
  • Turn (turn) — INT(11)
  • Date (date) — DATETIME(6)

Myosu (묘수 데이터)

  • Mid (mid) — INT(11) — Primary key — NOT NULL
  • Data (data) — LONGTEXT(4294967295)
  • Round (round) — INT(11)

Room (방)

  • Rid (rid) — INT(11) — Primary key — NOT NULL
  • Mid (mid) — INT(11) — Foreign key → Myosu.Mid — NOT NULL
  • Id (id2) — INT(11) — Foreign key → User.Id — NOT NULL
  • Uid (uid) — INT(11)
  • Att_turn (att_turn) — INT(11)
  • Level (level) — INT(11)

Tricksolving (묘수풀이 단계)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Id (id2) — INT(11) — Foreign key → User.Id — NOT NULL
  • Game1 (game1_1~5) — INT(11)
  • Game2 (game2_1~5) — INT(11)
  • Game3 (game3_1~5) — INT(11)
  • User_id (user_id) — INT(11)

User (회원정보)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Password (password) — VARCHAR(128)
  • Email (email) — VARCHAR(254)
  • Play (play) — INT(11)
  • Win (win) — INT(11)
  • Rate (rate) — FLOAT(12)
  • Score (score) — INT(11)