Instagram Schema

Tables (3)

hashtags

  • hashtag_id — integer — Primary key — NOT NULL
  • hashtag — Text

photos

  • photo_id — integer — Primary key — NOT NULL

photos_hashtags

  • photo_id — integer — Foreign key → photos.photo_id — NOT NULL
  • hashtag_id — integer — Foreign key → hashtags.hashtag_id — NOT NULL