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)