solo project - 게시판
테이블 (4)
Comment (Untitled3)
- commentId (Key) — BigInt — 기본 키 — NOT NULL
- postId (Key2) — BigInt — 외래 키 → Question.postId — NOT NULL
- memberId (Key22) — BigInt — 외래 키 → Question.memberId — NOT NULL
- memberId (Key3) — BigInt — 외래 키 → Member.memberId — NOT NULL
- createdBy (Field) — Date
- createdAt (Field2) — Date
- Field3
Member (Untitled)
- memberId (Key) — BigInt — 기본 키 — NOT NULL
- email (Field) — varchar
- name (Field2) — varchar
- phone (Field3) — varchar
Question (Untitled2)
- postId (Key) — BigInt — 기본 키 — NOT NULL
- memberId (Key2) — BigInt — 외래 키 → Member.memberId — NOT NULL
- title (Field4) — varchar
- body (Field5) — text
- createdBy (Field) — varchar
- createdAt (Field2) — Date
- isSecret (Field3) — Boolean
- viewCount (Field6) — int
- isNew (Field7) — Boolean
- postStatus (Field8) — Enum