Skip to content

Instantly share code, notes, and snippets.

View bfeif's full-sized avatar

Ben Feifke bfeif

View GitHub Profile
@bfeif
bfeif / gist:886063494a6d42e83b530923a199c2f6
Created January 23, 2021 23:24 — forked from sartak/a.md
Anki 2 annotated schema
-- 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)