I’m doing some debugging for a problem I’m experiencing here: https://forums.ankiweb.net/t/bug-all-text-imports-are-showing-up-as-duplicates
I’ve looked at the schema by running the command
sqlite3 collection.anki2 '.schema' but I can’t make out any table relationship information as there are no foreign keys defined.
How can I find information on the table relationships?
A bit of context: about myself, about many years ago, I was a MySQL DBA for about 10 years. I understand relational database theory and am trying to put my knowledge to work, but it’s difficult to dig in without understanding how the table relationships have been designed.