How to model database tables for implementing Friend relationship? [closed]

July 27, 2023 by Tarik

UserRelationship
====
RelatingUserID
RelatedUserID
Type[friend, block, etc]

Agree that mutuality doesn’t belong as a column; breaks normalization.