Instagram

Tables (8)

Commet (Untitled7)

  • Key (comment_id) — Primary key — NOT NULL
  • Key (feed_id) — Foreign key → Feed.Key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL

Feed (Untitled2)

  • Key (feed_id) — Primary key — NOT NULL
  • Field (Hashtag)
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Field (comment)
  • Field (content)
  • Field (date)
  • Field (photo)

Feed_Hashtag (Untitled5)

  • Key (feed_hashtag_id) — Primary key — NOT NULL
  • Key (feed_id) — Foreign key → Feed.Key — NOT NULL
  • Key (hashtag_id) — Foreign key → Hashtag.Key — NOT NULL

Follow (Untitled8)

  • Key (follower_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL

Hashtag (Untitled4)

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

Like (Untitled6)

  • Key (like_id) — Primary key — NOT NULL
  • Key (feed_id) — Foreign key → Feed.Key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL

Member (Untitled)

  • Key (member_id) — Primary key — NOT NULL
  • Field (member_name)
  • Field (member_profile)
  • Field (introduce)
  • Field (follower)
  • Field (following)
  • Field (feed_count)

Photo (Untitled3)

  • Key (photo_id) — Primary key — NOT NULL
  • Key (feed_id) — Foreign key → Feed.Key — NOT NULL
  • Field (photo_url)