게시판
테이블 (4)
t_board (Untitled)
- board_id (Key) — int - auto_increment — 기본 키 — NOT NULL
- category_id (Key2) — int — 외래 키 → t_category.category_id — NOT NULL
- comment_id (Key3) — int — 외래 키 → t_comment.comment_id — NOT NULL
- password (Field7) — int
- title (Field) — varchar(100)
- content (Field2) — longtext
- hit_cnt (Field3) — smallint(10)
- created_datetime (Field4) — datetime
- creator_id (Field5) — varchar(100)
- file (Field6) — longblob
t_category (Untitled2)
- category_id (Key) — int - auto_increment — 기본 키 — NOT NULL
- category_name (Field) — varchar(100)
t_comment (Untitled3)
- comment_id (Key) — int - auto_increment — 기본 키 — NOT NULL
- board_id (Field) — int
- comment_datetime (Field2) — datetime
- comment_content (Field3) — longtext
t_file (Untitled4)
- file_id (Key) — int - auto_increment — 기본 키 — NOT NULL
- board_id (Key2) — int — 외래 키 → t_board.board_id — NOT NULL
- file_name (Field2) — varchar(100)
- file_path (Field3) — varchar(100)