3 ms·
Agree its a bit unnatural, but it seems workable. My problem with the auxiliary table is, I wouldn't know how to implement the unique constraint.
by evv 4y ago
Agree its a bit unnatural, but it seems workable. My problem with the auxiliary table is, I wouldn't know how to implement the unique constraint.
- SnowHill9902 4y agoIn your current implementation you either have no unique constraint or it is a more particular case of UNIQUE(ancestor, descendant).