SNS

Tables (8)

Comment (Untitled3)

  • coment_id (PK) — int — Primary key — NOT NULL
  • member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
  • post_id (PK3) — int — Foreign key → Post.post_id — NOT NULL
  • Follow_id (PK223) — int — Foreign key — NOT NULL
  • comment_contents (Field) — String
  • Field2

Follow (Untitled5)

  • follower_id (PK22) — int — Foreign key — NOT NULL
  • following_id (PK222) — int — Foreign key — NOT NULL
  • Field2

Hashtag (Untitled4)

  • hashtag_id (PK) — int — Primary key — NOT NULL
  • hashtag_comment (Field) — String
  • Field2

Image (Untitled7)

  • image_id (PK) — int — Primary key — NOT NULL
  • post_id (PK2) — int — Foreign key → Post.post_id — NOT NULL
  • member_id (PK22) — int — Foreign key → Post.member_id — NOT NULL
  • image_count (Field) — int
  • Field2

Like (Untitled2)

  • like_id (PK) — int — Primary key — NOT NULL
  • member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
  • post_id (PK3) — int — Foreign key → Post.post_id — NOT NULL
  • Field2

Memeber (Untitled6)

  • member_id (PK) — int — Primary key — NOT NULL
  • member_name (Field) — String
  • password (Field2) — String
  • Field3

Post (Untitled)

  • post_id (PK) — int — Primary key — NOT NULL
  • member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
  • post_date (Field) — date
  • post_contents (Field3) — String
  • Field4
  • Field2

Post_Hashtag (Untitled8)

  • Post_Hashtag_id (PK) — int — Primary key — NOT NULL
  • post_id (PK2) — int — Foreign key → Post.post_id — NOT NULL
  • member_id (PK22) — int — Foreign key → Post.member_id — NOT NULL
  • hashtag_id (PK3) — int — Foreign key → Hashtag.hashtag_id — NOT NULL
  • Field