home / bibliothek

reading

0 rows where copy_id = 24

✎ View and edit SQL

This data as json

0 records

CREATE TABLE reading (
  id          INTEGER PRIMARY KEY,
  uuid        TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  copy_id     INTEGER NOT NULL REFERENCES copy(id),
  state       TEXT NOT NULL DEFAULT 'reading' CHECK (state IN ('reading','finished','dropped')),
  started_at  TEXT,   -- JJJJ-MM-TT, NULL = unbekannt
  finished_at TEXT,   -- JJJJ-MM-TT (beendet oder abgebrochen), NULL = unbekannt bzw. läuft noch
  updated_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at  TEXT
);
CREATE INDEX ix_reading_copy ON reading(copy_id);
Powered by Datasette · Queries took 5.718ms