home / bibliothek

reading

1 row where copy_id = 155

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: finished_at (date), updated_at (date)

id ▼ uuid copy_id state started_at finished_at updated_at deleted_at
32 8fb0042a740ad5612fbb5fa0a6d545fa 155 155 finished   2024-11-16 2026-11-16T13:55:17.936Z  

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 4.756ms