sns 2

Tables (8)

Comment (Untitled3)

  • comment_id (PK) — Primary key — NOT NULL
  • commnet_content (Field)
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • post_id (F.K) — Foreign key → Post.post_id — NOT NULL

Hashtag (Untitled5)

  • hashtag_id (Key) — Primary key — NOT NULL
  • hasgtag_title (Field)

Like (Untitled4)

  • like_id (PK) — Primary key — NOT NULL
  • post_id (FK) — Foreign key → Post.post_id — NOT NULL
  • member_id (F.K) — Foreign key → Member.member_id — NOT NULL

Member (Untitled)

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

Member_member (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • src_member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • dst_member2_id (F.K) — Foreign key → Member.member_id — NOT NULL

Photo (Untitled7)

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

Post (Untitled2)

  • post_id (PK) — Primary key — NOT NULL
  • post_comment (Field)
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL

Post_hashtag (Untitled6)

  • post_hashtag_id (PK) — Primary key — NOT NULL
  • hashtag_id (FK) — Foreign key → Hashtag.hashtag_id — NOT NULL
  • post_id (F.K) — Foreign key → Post.post_id — NOT NULL