13 lines
376 B
SQL
13 lines
376 B
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
|
|
);
|