Question about anki schema

Hi, I was looking at my anki sqlite file and I was wondering if someone could tell me what the ‘due’ column is for? I guess it shows the number of days before a certain card is shown to the user, but what does a negative ‘due’ mean? I checked the id on the anki browser tab and the one in the red box is due today.

And can someone tell me how to count the number of days from the ‘due’ section?

I’ve never seen negative due values. How are you viewing the database?

For review cards, the value is the number of days relative to the collection’s creation date, which is stored as a timestamp in the crt colum of the col table.

This page has more details on the database schema: Database Structure · ankidroid/Anki-Android Wiki · GitHub

I used tableplus

Negative numbers are used to control the order in filtered decks.

1 Like

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