MyBlog

Tables (3)

board (게시판)

  • board_id (게시글ID) — int, auto_increment, PK — Primary key — NOT NULL
  • 제목 (title) — varchar(50) — NOT NULL
  • 내용 (contents) — text
  • 작성자 (writer) — varchar(30) — NOT NULL
  • 등록일 (created_date) — datetime — NOT NULL
  • 수정일 (updated_date) — datetime — NOT NULL
  • 삭제일 (deleted_date) — datetime — NOT NULL

comment (댓글)

  • comment_id (댓글ID) — int, auto_increment, PK — Primary key — NOT NULL
  • board_id (게시글ID) — int, FK — NOT NULL
  • writer (작성자) — varchar(30) — NOT NULL
  • created_date (등록일) — datetime — NOT NULL

file (파일)

  • file_id (파일ID) — int, auto_increment, PK — Primary key — NOT NULL
  • board_id (게시글ID) — int, FK — NOT NULL
  • comment_id (댓글ID) — int, FK
  • file_name (파일명) — varchar(255) — NOT NULL
  • file_path (파일경로) — varchar(500) — NOT NULL
  • file_size (파일사이즈) — bigint — NOT NULL
  • file_type (파일타입(확장자)) — varchar(100) — NOT NULL
  • created_date (등록일) — datetime — NOT NULL
  • updated_date (수정일) — datetime — NOT NULL — CURRENT_TIMESTAMP
  • deleted_date (삭제일) — datetime — NOT NULL