yolpsoftware

-- see https://github.com/ankidroid/Anki-Android/wiki/Database-Structure for a more maintained version of this

-- cards are what you review. easy!
CREATE TABLE cards (
    id              integer primary key,
      -- the epoch milliseconds of when the card was created
    nid             integer not null,
      -- notes.id
    did             integer not null,
      -- deck id (available in col table)