Omok
Tables (7)
BOARD (Untitled5)
- BOARD_NUM (PK) — INTEGER — Primary key — NOT NULL
- WRITER (PK2) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- TITLE (Field) — CHARACTER VARYING(255)
- TEXT (Field2) — CHARACTER VARYING(255)
- WRITE_DATE_TIME (Field3) — TIMESTAMP(6)
CHAT (Untitled2)
- CHAT_NUM (PK) — INTEGER — Primary key — NOT NULL
- USER_NUM (FK) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- CONTENT (Field) — CHARACTER VARYING(200)
- DATETIME (Field2) — TIMESTAMP(6)
COMMENT (Untitled7)
- COMMENT_NUM (PK) — INTEGER — Primary key — NOT NULL
- USER_NUM (FK) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- BOARD_NUM (PK2) — INTEGER — Foreign key → BOARD.BOARD_NUM — NOT NULL
- COMMENT (Field) — CHARACTER VARYING(255)
- WRITE_DATE_TIME (Field2) — TIMESTAMP(6)
HISTORY_COMMENT (결과창 댓글)
- HISTORY_COMMENT_NUM (PK) — Primary key — NOT NULL
- USER_NUM (FK) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- BOARD (FK2) — INTEGER — Foreign key → OMOK_SETTING.GAME_NUM — NOT NULL
- Field
OMOK_ORDER (오목 수순)
- ORDER_NUM (PK) — INTEGER — Primary key — NOT NULL
- GAME_NUM (FK) — INTEGER — Foreign key → OMOK_SETTING.GAME_NUM — NOT NULL
- USER_NUM (FK2) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- X_LINE (Field) — INTEGER
- Y_LINE (Field2) — INTEGER
- PROCEDURE (Field3) — INTEGER
OMOK_SETTING (Untitled3)
- GAME_NUM (PK) — INTEGER — Primary key — NOT NULL
- BLACK_STONE (FK) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- WHITE_STONE (FK2) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- ROOMID (Field) — CHARACTER VARYING(255)
- NAME (Field2) — CHARACTER VARYING(255)
- WINNER (FK3) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
- LOSER (FK4) — INTEGER — Foreign key → USER_TABLE.USER_NUM — NOT NULL
USER_TABLE (Untitled)
- USER_NUM (PK) — INTEGER — Primary key — NOT NULL
- USERNAME (Field) — CHARACTER VARYING(255)
- PASSWORD (Field2) — CHARACTER VARYING(255)
- NICKNAME (Field3) — CHARACTER VARYING(255)
- WIN_LATE (Field4) — INTEGER
- LOSE_NUM (Field5) — INTEGER
- LAST_LOGIN_DATE (Field6) — TIMESTAMP(6)