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

Likes (Untitled4)

  • Key — 기본 키 — NOT NULL

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