Databases

Polymorphic Comments and Reactions Schema

ER Diagrams · made in Skemio

ER diagram illustrating entity supertype pattern linking base entities to posts, photos, comments, and reactions.
ER diagram illustrating entity supertype pattern linking base entities to posts, photos, comments, and reactions.
Open it in SkemioMake your own

What it shows

  • A base entity supertype maintains referential integrity across types.
  • Composite unique indexes stop users from reacting more than once.
  • Eliminates ALTER TABLE migrations when introducing new content formats.

The takeaway

Use base entity inheritance instead of loose string types to preserve foreign key constraints.

More er diagrams