reading
1 row where copy_id = 76
This data as json, CSV (advanced)
Suggested facets: started_at (date), finished_at (date), updated_at (date)
| id ▼ | uuid | copy_id | state | started_at | finished_at | updated_at | deleted_at |
|---|---|---|---|---|---|---|---|
| 29 | 5f4be9451fb9f8bcc33b808c31215706 | 76 76 | finished | 2026-08-31 | 2026-10-12 | 2026-11-12T12:31:07.465Z |
Advanced export
JSON shape: default, array, newline-delimited, object
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);