home / bibliothek

reading

1 row where copy_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_at (date)

id ▼ uuid copy_id state started_at finished_at updated_at deleted_at
7 e14132a57367c4d6bdaea0fb7d2f6dc7 54 54 finished     2026-11-12T09:14:17.068Z  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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.833ms