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 — 등록일