jap_learn/sql/history.sql

create table history
(
    id        integer
        primary key autoincrement,
    deck_id   integer not null references decks on delete cascade,
    word_id   integer not null references words on delete cascade,
    timestamp integer not null,
    answer    integer not null,
    before    integer not null,
    after     integer not null,
    fsrs      integer not null
);