1
Tables (4)
Board
- board_id — bigint — Primary key — NOT NULL — 게시글 상세 ID
- user_id — varchar(20) — Foreign key → Member.user_id — NOT NULL — 회원ID
- title — varchar(100) — 제목
- content — text — 내용
- created_at — timestamp — 작성일
- updated_at — timestamp — 수정일
Member
- user_id — varchar(20) — Primary key — NOT NULL — 회원ID
- pass_word — varchar(255) — NOT NULL — 비밀번호
- nick_name — varchar(20) — 닉네임
- created_at — timestamp — 가입일
comment
- comment_id — bigint — Primary key — NOT NULL — 댓글 ID
- user_id — varchar(20) — Foreign key → Member.user_id — NOT NULL — 회원ID
- board_id — bigint — Foreign key → Board.board_id — NOT NULL — 게시글 상세 ID
- parent_id — bigint — Foreign key → comment.comment_id — 부모 댓글ID(대댓글)
- comment_text — varchar(500) — 댓글 내용
- comment_created_at — timestamp — 댓글 작성일
image
- image_id — bigint — Primary key — NOT NULL — 사진ID
- board_id — bigint — Foreign key → Board.board_id — NOT NULL — 게시글 상세 ID
- image_url — varchar(255) — 사진URL
- sort_order — int — NOT NULL — 표시 순서
- created_at — timestamp — 등록일