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