미니블로그

테이블 (3)

Member (members)

  • member (idx) — INT — 기본 키 — NOT NULL
  • email — VARCHAR(30)
  • password — VARCHAR(30)
  • name — VARCHAR(30)

게시글 (posts)

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

댓글 (comments)

  • comment (idx) — INT — 기본 키 — NOT NULL
  • member (member_id) — INT — 외래 키 → Member.member — NOT NULL
  • post (post_id) — INT — 외래 키 → 게시글.post — NOT NULL
  • content — TEXT