example01

테이블 (8)

Comment (Untitled3)

  • comment_id (Key) — 기본 키 — NOT NULL
  • Post_id (Key2) — 외래 키 → Post(게시글).Post_id — NOT NULL
  • member_id (Key3) — 외래 키 → Member.member_id — NOT NULL
  • comment_coment (Field)

Hashtag (Untitled6)

  • hashtag_id (Key) — 기본 키 — NOT NULL
  • hashtag_tittle (Field)

Like (Untitled4)

  • like_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → Member.member_id — NOT NULL
  • Post_id (Key3) — 외래 키 → Post(게시글).Post_id — NOT NULL

Member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • nickname (Field)
  • email (Field2)
  • phone (Field3)

Member_member (Untitled8)

  • member_member_id (Key) — 기본 키 — NOT NULL
  • member_id (FK) — 외래 키 → Member.member_id — NOT NULL
  • member_id (FK1)

Photo (Untitled7)

  • photo_id (Key) — 기본 키 — NOT NULL
  • Post_id (Key2) — 외래 키 → Post(게시글).Post_id — NOT NULL
  • url (Field)

Post(게시글) (Untitled2)

  • Post_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → Member.member_id — NOT NULL
  • post_comment (Field)

Post_Hashtag (Untitled5)

  • Post_hashtag_id (Key) — 기본 키 — NOT NULL
  • Post_id (Key2) — 외래 키 → Post(게시글).Post_id — NOT NULL
  • hashtag_id (Key3) — 외래 키 → Hashtag.hashtag_id — NOT NULL