Designing a Like / Reaction System (Facebook / LinkedIn) - Database Modelling

Modern platforms (Reddit, LinkedIn, YouTube) support multiple reaction types per entity. Core Requirements ✅ One user → one reaction per entity ✅ Reaction can change over time ✅ Extremely write-heavy ✅ Reads need fast aggregated counts ✅ Prevent...