bulletin_board

Tables (3)

BOARD

  • 番号 (BOARD_ID) — INT(10) — Primary key — NOT NULL
  • Field (TITLE) — VARCHAR(50) — NOT NULL
  • Field (CONTENT) — VARCHAR(500) — NOT NULL
  • Field (REG_DATE) — DATETIME
  • Field (HIT) — INT(10)
  • Key (WRITER_ID) — VARCHAR(25) — Foreign key → Untitled.Key — NOT NULL

Copy Of BOARD (COMMENT)

  • 番号 (COMMENT_ID) — INT(10) — Primary key
  • Field (CONTENT) — VARCHAR(500) — NOT NULL
  • Field (REG_DATE) — DATETIME(2) — NOT NULL
  • 番号 (BOARD_ID) — INT(10) — Foreign key → BOARD.番号 — NOT NULL
  • Field (WRITER_ID)

Untitled (USER_INFO)

  • Key (USER_ID) — VARCHAR(25) — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field2 (PW) — VARCHAR(20) — NOT NULL
  • Field (EMAIL) — VARCHAR(14)