실습1

테이블 (4)

Comment (Untitled3)

  • id (comment_id) — char — 기본 키 — NOT NULL
  • contnent (comment_content) — char
  • id (post_id) — char — 외래 키 → Post.id — NOT NULL
  • id (member_id) — char — 외래 키 → Member.id — NOT NULL

Member (Untitled2)

  • id (member_id) — char — 기본 키 — NOT NULL
  • name (member_name) — char
  • email (member_email) — unique

Post (Untitled)

  • id (post_id) — char — 기본 키 — NOT NULL
  • title (post_title) — char
  • content (post_content) — char — NOT NULL
  • create_at (post_create_at) — int
  • id (member_id) — char — 외래 키 → Member.id — NOT NULL

UserPost (Untitled4)

  • id (post_id) — char — 외래 키 → Post.id — NOT NULL
  • id (member_id) — char — 외래 키 → Member.id — NOT NULL