Databases

Social Network Followers and Friendship Graph

ER Diagrams · made in Skemio

ER diagram modeling a central users entity linking to follows, friendships, and user blocks tables.
ER diagram modeling a central users entity linking to follows, friendships, and user blocks tables.
Open it in SkemioMake your own

What it shows

  • Unidirectional follows need a simple composite key on follower and target.
  • Bidirectional friendships enforce user_a < user_b to eliminate duplicate rows.
  • Block lists precede follow lookups in read queries to prevent data leaks.

The takeaway

Enforce ordered pairs on symmetric relationships to guarantee unique friendship records in SQL.

More er diagrams