게시판

테이블 (6)

MemberAgree (Untitled)

  • MA_id (PK) — bigint — 기본 키 — NOT NULL
  • user_id (PK2) — bigint — 외래 키 → 회원.user_id — NOT NULL
  • terms_id (PK3) — bigint — 외래 키 → 약관.terms_id — NOT NULL

게시글 (Board)

  • board_id (PK) — varchar — 기본 키 — NOT NULL
  • title (Field2) — varchar
  • content (Field) — text
  • view_count (Field3) — int
  • like_count (Field6) — int
  • updated_at (Field4) — datetime
  • created_at (Field5) — datetime

댓글 (comment)

  • comment_id (PK) — bigint — 기본 키 — NOT NULL
  • user_id (PK2) — bigint — 외래 키 → 회원.user_id — NOT NULL
  • board_id (PK3) — varchar — 외래 키 → 게시글.board_id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — datetime
  • Field3

약관 (terms)

  • terms_id (PK) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar
  • body (Field2) — text
  • optional (Field3) — boolean
  • Field4

좋아요 (boardLike)

  • BL_id (PK) — bigint — 기본 키 — NOT NULL
  • board_id (PK3) — varchar — 외래 키 → 게시글.board_id — NOT NULL
  • user_id (PK2) — bigint — 외래 키 → 회원.user_id — NOT NULL

회원 (user)

  • user_id (PK) — bigint — 기본 키 — NOT NULL
  • password (Field) — varchar
  • email (Field2) — varchar
  • name (Field3) — varchar
  • role (Field4) — enum
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime