Sqlite3 collection.anki2 schema

Anki Desktop
1

Greetings,

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.

2

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
3

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