게시판
테이블 (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