src/db/sql/1-init.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE IF NOT EXISTS cards (
  question VARCHAR PRIMARY KEY,
  responses VARCHAR NOT NULL,
  state VARCHAR NOT NULL,
  created TIMESTAMP NOT NULL,
  updated TIMESTAMP NULL,
  deleted TIMESTAMP NULL,
  deck_read TIMESTAMP NOT NULL,
  ready TIMESTAMP NOT NULL
)