사전스터디

테이블 (5)

Comment

  • commentID — int — 기본 키 — NOT NULL
  • MemberID — int — 외래 키 → Member.MemberID — NOT NULL
  • postID — int — 외래 키 → Post.postID — NOT NULL
  • createdAt — date — NOT NULL
  • updatedAt — date
  • content — text

Image

  • ImageID — int — 기본 키 — NOT NULL
  • postID — int — 외래 키 → Post.postID — NOT NULL
  • imageURL — varchar — NOT NULL

Like

  • LikeID — varchar — 기본 키 — NOT NULL
  • MemberID — varchar — 외래 키 → Member.MemberID — NOT NULL
  • postID — int — 외래 키 → Post.postID — NOT NULL

Member

  • MemberID — varchar — 기본 키 — NOT NULL
  • profile_URL (profile) — varchar
  • date (joinDate) — date
  • name — varchar — NOT NULL
  • password — varchar — NOT NULL — ** 암호화 필요 **
  • is_deleted — bool

Post

  • postID — int — 기본 키 — NOT NULL
  • MemberID — int — 외래 키 → Member.MemberID — NOT NULL
  • title — varchar — NOT NULL
  • createdAt — date — NOT NULL
  • updatedAt — date
  • content — text
  • count_likes — number — NOT NULL
  • count_comments — number — NOT NULL