게시글 좋아요 기능 설계

테이블 (3)

Like (likes)

  • Post (post_id) — BIGINT — 외래 키 → Post.Post — NOT NULL
  • member (user_id) — INT — 외래 키 → Member.member — NOT NULL
  • Like (state) — BOOLEAN

Member (members)

  • member (idx) — INT — 기본 키 — NOT NULL
  • email — VARCHER(30)
  • Name (name) — VARCHER(30)

Post (posts)

  • Post (idx) — BIGINT — 기본 키 — NOT NULL
  • member (member_id) — INT — 외래 키 → Member.member — NOT NULL
  • Title (title) — VARCHAR(30)
  • Content (content) — TEXT