3 ms·
This works well for nodes with at most 1 parent and child, the post is aimed at supporting many to many relationships though
by TOMDM 4y ago
This works well for nodes with at most 1 parent and child, the post is aimed at supporting many to many relationships though
- ralusek 4y agoWhat I've described here supports many to many...
- fauigerzigerk 4y agoYes, but the downside of your schema is that the distinction between nodes and edges is somewhat muddled. Presumably, all nodes would have nulls in both fromId and toId, but the schema doesn't enforce that. The schema also allows linking edges to other edges. Don't you think this is a bit too much flexibility if the intention is to model a graph?