Insta ERD

Tables (3)

follower_map (Untitled)

  • user_id (id) — BIGINT — Primary key — NOT NULL
  • user_id (target_id) — BIGINT
  • user_id (follower_id) — BIGINT

likes (Untitled2)

  • like_id (id) — BIGINT — Primary key — NOT NULL
  • like_id — BIGINT
  • timestamp — TIMESTAMP
  • target_id — BIGINT
  • target_type — INTEGER

users (Untitled3)

  • users_id (id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(50)
  • name — VARCHAR(50)