I am trying to conduct a quantitative survey of Anki use, and I have collected several databases from the desktop version of Anki which I am trying to analyze. I have successfully extracted information from the
notes table, but I cannot figure out where information on decks is located.
Specifically, I am hoping to identify, based on a deck ID
did gotten from the
cards table, the name of the deck and the learning options associated with that deck (for example, the steps, new cards/day, graduating interval, maximum reviews/day, and other settings in the options menu for the deck)
I saw online that this information might be stored in the
col table, however I was unable to locate it there in the database I am working with. Any information on this would be very helpful! I have a background in computer science and have used Anki, but have no experience with the Anki codebase beyond what I’ve seen opening up the database with the SQLite Browser.
I’m working with a database from Anki version 2.1.33