eSoft
Tables (4)
tb_board
- board_id — INT — Primary key — NOT NULL
- category_id — INT — Foreign key → tb_category.category_id — NOT NULL
- title — VARCHAR(99) — NOT NULL
- views — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
- content — VARCHAR(3999) — NOT NULL
- user_name — VARCHAR(10) — NOT NULL
- password — VARCHAR(64) — NOT NULL
tb_category
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(20) — NOT NULL
tb_comment
- comment_id — INT — Primary key — NOT NULL
- board_id — INT — NOT NULL
- comment — VARCHAR(300) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_file
- file_id — INT — Primary key — NOT NULL
- board_id — INT — NOT NULL
- original_name — VARCHAR(100) — NOT NULL
- physical_name — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(15) — NOT NULL
- extension — VARCHAR(10) — NOT NULL
- size — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP