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