Sqlite3 collection.anki2 schema


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.

Delving into the DB schema is unlikely to be helpful. The problem is probably happening at a higher level.

Here’s a summary of the database schema anyway (incomplete): Database Structure · ankidroid/Anki-Android Wiki · GitHub

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.