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)