Mutualy owned bi directional relations (friends)

Question

I am writing an ORM. I am curious how friend relations are generally modeled. Are they duplicated relations in a link table with each user an owner of his friend relations, or is there an introduction of a mutually owned relation, where the orm looks up relation links where the relation owner's id can be in the child field of the relation link table?

An example might be helpful to understand what you mean – jeff Jul 14 '12 at 21:37 — jeff, Jul 14 '12 at 21:37

score 1 · Accepted Answer · edited May 23 '17 at 12:20

1

I've never seen an ORM doing your "mutually owned relation" because it would only work for readonly scenarios but ORM is typically for readwrite. i would model them like this

edited May 23 '17 at 12:20

Community

1
1

answered Jul 15 '12 at 16:43

Firo

30,626
4
55
94

Mutualy owned bi directional relations (friends)

1 Answers1