simple
Tables (4)
board (Untitled)
- board_id (Key) — int(AUTO) — Primary key — NOT NULL
- category_id (Key2) — Int(AUTO) — Foreign key → category.category_id — NOT NULL
- category (Field) — varchar
- name (Field2) — varchar
- password (Field3) — varchar
- title (Field4) — varchar
- content (Field5) — text
- created_at (Field6) — TimeStamp
- modifieded_at (Field7) — TimeStamp
- view (Field8) — int
category (Untitled4)
- category_id (Key) — Int(AUTO) — Primary key — NOT NULL
- category (Field) — varchar
comment (Untitled2)
- comment_id (Key) — int(AUTO) — Primary key — NOT NULL
- board_id (Key2) — int — Foreign key → board.board_id — NOT NULL
- category_id (Key22) — Int(AUTO) — Foreign key → board.category_id — NOT NULL
- content (Field) — text
- created_at (Field2) — TimeStamp
file (Untitled3)
- file_id (Key) — int(AUTO) — Primary key — NOT NULL
- board_id (Key2) — int — Foreign key → board.board_id — NOT NULL
- category_id (Key22) — Int(AUTO) — Foreign key → board.category_id — NOT NULL
- original_name (Field) — varchar
- name (Field2) — varchar
- path (Field3) — varchar
- extension (Field4) — varchar