Instagram1

Tables (9)

Comment (Untitled3)

  • comment_id (PK) — Primary key — NOT NULL
  • post_id (FK1) — Foreign key → Post.post_id — NOT NULL
  • member1_id (FK2) — Foreign key → Member1.member1_id — NOT NULL
  • Field

Hashtag (Untitled4)

  • hashtag_id (PK) — Primary key — NOT NULL
  • hasktag_title (Field)

Like (Untitled5)

  • like_id (PK) — Primary key — NOT NULL
  • member1_id (FK1) — Foreign key → Member1.member1_id — NOT NULL
  • post_id (FK2) — Foreign key → Post.post_id — NOT NULL

Member1 (Untitled)

  • member1_id (PK) — Primary key — NOT NULL
  • nickname (Field)
  • email (Field2)
  • phone (Field3)

Member2 (CopyOfUntitled)

  • member_id (PK) — Primary key — NOT NULL
  • nickname (Field)
  • email (Field2)
  • phone (Field3)

Member_member (Untitled8)

  • member_member_id (PK) — Primary key — NOT NULL
  • src_member_id (FK1) — Foreign key → Member1.member1_id — NOT NULL
  • dst_member_id (FK2) — Foreign key → Member2.member_id — NOT NULL

Photo (Untitled7)

  • photo_id (PK) — Primary key — NOT NULL
  • post_id (FK1) — Foreign key → Post.post_id — NOT NULL
  • url (Field)

Post (Untitled2)

  • post_id (PK) — Primary key — NOT NULL
  • member1_id (FK) — Foreign key → Member1.member1_id — NOT NULL
  • post_contents (Field)

Post_hashtag (Untitled6)

  • post_hashtag_id (PK) — Primary key — NOT NULL
  • post_id (FK1) — Foreign key → Post.post_id — NOT NULL
  • hashtag_id (FK2) — Foreign key → Hashtag.hashtag_id — NOT NULL
  • member_id (PK2) — Foreign key → Post.member1_id — NOT NULL