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)