When a new friendship is created two records are inserted into friendships table. Can't we avoid that? Any particular reason for adopting this approach?
We need two records because we need to know who initiated the friendship request, and who received it (otherwise someone could initial and accept their own friendship request).
When a new friendship is created two records are inserted into friendships table. Can't we avoid that? Any particular reason for adopting this approach?