Instagram_answer

Tables (8)

comments (Untitled4)

  • comment_id — UUID — Primary key — NOT NULL
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL
  • body — VARCHAR(100)

followers (Untitled7)

  • follwoing_id (following_id) — UUID — Foreign key → users.user_id — NOT NULL
  • follower_id — UUID — Foreign key → users.user_id — NOT NULL

hashtags (Untitled5)

  • tag_id — UUID — Primary key — NOT NULL
  • title — VARCHAR(10)

likes (Untitled8)

  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL

photos (Untitled2)

  • photo_id — UUID — Primary key — NOT NULL
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL
  • image_uri — VARCHAR(255)

posts (Untitled3)

  • post_id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • content — TEXT

posts_hashtags (Untitled6)

  • post_id — UUID — Foreign key → posts.post_id — NOT NULL
  • tag_id — UUID — Foreign key → hashtags.tag_id — NOT NULL

users (Untitled)

  • user_id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100)
  • created_at — TIMESTAMP