Back
Relations within the same table
Hello, I'm currently building a sort of dictionary (a literal one) and thus I need words (which is one single table of words in my database) to be able to have relations to eachother. Things like x is derived from y and if z is also derived from y than x and z could be cognates etc. However im finding out that I cannot have relations within the same table.
TL;DR
Developers are trying to create a dictionary where words in the same table can have relations like derivation or cognates, but are having trouble establishing these relations within the table itself.