게시판

테이블 (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)