Test project
Tables (5)
board
- board_id — NOT NULL — Primary key — NOT NULL
- bo_cat unique id (bo_cat_id) — NOT NULL — Foreign key → board_category.bo_cat unique id — NOT NULL — 게시판 카테고리 아이디
- user_id — int — Foreign key → user.user_id — NOT NULL
- bo_file_id (board_file_id) — null — Foreign key → board file.file_id — NOT NULL
- user_nickname — NOT NULL
- user_email — NOT NULL
- board_title (bo_cat_key) — NOT NULL
- board_content — NOT NULL
- created_at — CURRENT_TIMESTAMP
- updated_at — CURRENT_TIMESTAMP
- board_ip — NOTNULL
- board_hit (board_blame) — 0
- board_like — 0
- board_dislike — 0
- board_blame (Field) — 0
- board_del — 0
- comment_cnt (comment_count) — 0
board comment
- comment_id — NOT NULL — Primary key — NOT NULL
- board_id — NOT NULL — Foreign key → board.board_id — NOT NULL
- bo_cat unique id (bo_cat_id) — NOT NULL — Foreign key → board.bo_cat unique id — NOT NULL — 게시판 카테고리 아이디
- user_id — int — Foreign key → board.user_id — NOT NULL
- bo_file_id (board_file_id) — null — Foreign key → board.bo_file_id — NOT NULL
- user_id (user_id2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- file_id (file_id2) — NOT NULL — Foreign key → board file.file_id — NOT NULL
- comment_text — NOT NULL
- created_at — CURRENT_TIMESTAMP
- updated_at — CURRENT_TIMESTAMP
board file
- file_id — NOT NULL — Primary key — NOT NULL
- board_id — null
- comment_id — null
- file_path — NOT NULL
- created_at — CURRENT_TIMESTAMP
- updated_at — CURRENT_TIMESTAMP
board_category (board category)
- bo_cat unique id (bo_cat_id) — NOT NULL — Primary key — NOT NULL
- bo_cat key value (bo_cat_key) — NOT NULL — category 테이블의 키값, like 검색을 쉽게하기 위한 키값
- bo_cat name value (bo_cat_value) — NOT NULL — 카테고리명
- bo_cat order value (bo_cat_order) — NOT NULL — 카테고리 정렬 순서
- created_at — CURRENT_TIMESTAMP
- updated_at — CURRENT_TIMESTAMP
- bo_cat unique id (bo_cat_parent) — NOT NULL — Foreign key → board_category.bo_cat unique id — NOT NULL — 부모 카테고리의 bo_cat_key가 저장됨
user
- user_id — NOT NULL — Primary key — NOT NULL
- email — NOT NULL
- nickname — NOT NULL
- password — NOT NULL
- created_at — CURRENT_TIMESTAMP
- updated_at — CURRENT_TIMESTAMP