Skip to content

History / Database Structure

Edit page New page

Revisions

  • Updated Database Structure (markdown)

    @user1823 user1823 committed Aug 6, 2025
    4d07dea

  • Mention that FSRS difficulty is logged in place of factor in revlogs if FSRS is enabled

    @user1823 user1823 committed Jul 23, 2025
    d0be101

  • Added `md` (technically added later than the V11 schema, but forwards/backwards compatible, and useful to document)

    @david-allison david-allison committed Jul 10, 2025
    d3169db

  • Fix broken link

    @espertus espertus committed Jun 14, 2025
    5a7875e

  • due for cards in filtered decks. Ref: https://github.com/ankitects/anki/blob/c1fc45928dfa3fd12050c2bf254c2e3f33463830/rslib/src/scheduler/filtered/card.rs#L27

    @user1823 user1823 committed Jun 7, 2025
    dbe7872

  • Mention a new revlog type

    @markonm markonm committed Mar 29, 2025
    6c5f0da

  • Mention about the difference in how v2 and v3 schedulers store the value of ivl. See https://forums.ankiweb.net/t/details-about-the-database-structure/33457/6

    @user1823 user1823 committed Jul 19, 2024
    e986328

  • due => review

    @AlexErrant AlexErrant committed Jun 10, 2024
    8ec8702

  • minor clarifications to `due`

    @AlexErrant AlexErrant committed Jun 10, 2024
    ea5468b

  • update due's `new` description

    @AlexErrant AlexErrant committed Jun 9, 2024
    1a746d2

  • mention about type=4 in revlog table and change the term for type=3 to match the term Anki uses in card info

    @user1823 user1823 committed Jun 8, 2024
    e058894

  • Use absolute link. The relative link worked when ...wiki/Database-Structure was open but not when ...wiki/Database-Structure/ was open.

    @user1823 user1823 committed Apr 14, 2024
    4204d46

  • attempt 2

    @AlexErrant AlexErrant committed Feb 20, 2024
    06522a0

  • fixed broken link

    @AlexErrant AlexErrant committed Feb 20, 2024
    85231c9

  • Fix typos across the text

    @charlesribeiro charlesribeiro committed Nov 15, 2022
    fe73ff7

  • Correct milliseconds spelling

    @pockethook pockethook committed Jun 5, 2022
    c8fb83d

  • Add subheadings for each table

    @acbraith acbraith committed Feb 21, 2022
    92fa92d

  • I stuggled to understand the "left" value so I added an example

    @thiswillbeyourgithub thiswillbeyourgithub committed Dec 28, 2021
    319a344

  • Put extensions in code highlighting; capitalised SQLite; hyperlinked SQLite for people who haven't heard of it.

    @hiAndrewQuinn hiAndrewQuinn committed Dec 4, 2021
    219db55

  • split out the "cards" table - WIP: attempting something cool with documentation

    @david-allison david-allison committed Sep 5, 2021
    c3bd440

  • Updated Database Structure (markdown)

    @sudomain sudomain committed Jun 18, 2021
    a940e3b

  • wording change to clarify col.decks JSONObjects values

    @sudomain sudomain committed Jun 15, 2021
    3a39686

  • col.decks is a JSONObject containing other JSONObjects

    @sudomain sudomain committed Jun 15, 2021
    42d49ef

  • update description of `req` field in Models to indicate it is backwards-compatibility only now

    @mikehardy mikehardy committed May 25, 2021
    ad04558

  • Updated Database Structure (markdown)

    @Arthur-Milchior Arthur-Milchior committed Mar 21, 2021
    3066e77

  • Updated Database Structure (markdown)

    @Arthur-Milchior Arthur-Milchior committed Dec 31, 2020
    0c705c5

  • collapseTime

    @Arthur-Milchior Arthur-Milchior committed Aug 20, 2020
    b590ee7

  • consts.py defined a card with a 'queue' value of 2 is 'QUEUE_TYPE_REV'

    @sudomain sudomain committed Jun 11, 2020
    15f643d

  • add 'preview' queue value of 4 per consts.py

    @sudomain sudomain committed Jun 11, 2020
    a8adb1d

  • consts.py defined a card of type 2 is 'CARD_TYPE_REV'

    @sudomain sudomain committed Jun 11, 2020
    10f5b98