sns

Tables (8)

Comment (Untitled5)

  • comment_id (PK) — Primary key — NOT NULL
  • Post_id (Key) — Foreign key → Post.Post_id — NOT NULL
  • member_id (PK2) — Foreign key → Member.member_id — NOT NULL
  • comment_write (Field)

Follwing (Untitled9)

  • follow_id (PK) — Primary key — NOT NULL
  • follow (PK2) — Foreign key → Member.member_id — NOT NULL
  • follwing (PK3) — Foreign key → Member.member_id — NOT NULL

HashTag (Untitled4)

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

Like (Untitled3)

  • like_id (PK) — Primary key — NOT NULL
  • Post_id (Key) — Foreign key → Post.Post_id — NOT NULL
  • member_id (PK2) — Foreign key → Member.member_id — NOT NULL
  • count (Field)

Member (Untitled)

  • member_id (PK) — Primary key — NOT NULL
  • member_name (Field)
  • member_password (Field2)

Picture (Untitled6)

  • picture_id (Key) — Primary key — NOT NULL
  • Post_id (Key2) — Foreign key → Post.Post_id — NOT NULL
  • picture_count (Field)

Post (Untitled2)

  • Post_id (Key) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • write (Field2)

Post_hashtag (Untitled10)

  • post_hashtag_id (Key) — Primary key — NOT NULL
  • hashtag_id (PK) — Foreign key → HashTag.hashtag_id — NOT NULL
  • Post_id (Key2) — Foreign key → Post.Post_id — NOT NULL