home / bibliothek

copy

4 rows where location_id = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: read_status, updated_at (date), read_at (date)

id ▼ uuid media_id location_id ownership read_status notes updated_at deleted_at rating read_at progress_page progress_chapter
18 b18acc4494e8ca846fa59df2a9004f52 City of trees 7 19 19 own read   2026-11-12T08:57:09.695Z   5 2024-07-12    
19 9fa413c4fdae13645d9141c7f18a6680 Level 4: Die Stadt der Kinder 8 19 19 own unread   2026-11-11T17:01:50.096Z          
20 c8a1ee3fc6b241ab2db5b59e2f3d146d Die Mitte der Welt: Roman 9 19 19 own read   2026-11-12T08:57:51.071Z   5 2024-06-12    
21 e22ff2d7d8716cb28b61699972257e5e Corpus Delicti: Ein Prozess 10 19 19 own read   2026-11-11T17:02:47.461Z          

Advanced export

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

CSV options:

CREATE TABLE "copy" (
  id          INTEGER PRIMARY KEY,
  uuid        TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  media_id    INTEGER NOT NULL REFERENCES media(id),
  location_id INTEGER REFERENCES location(id),
  ownership   TEXT NOT NULL DEFAULT 'own' CHECK (ownership IN ('own','borrowed_in','returned')),
  read_status TEXT NOT NULL DEFAULT 'unread'
              CHECK (read_status IN ('unread','next','reading','read','dropped')),
  notes       TEXT,
  updated_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at  TEXT,
  rating      INTEGER CHECK (rating BETWEEN 0 AND 7),
  read_at     TEXT
, progress_page INTEGER, progress_chapter TEXT);
CREATE INDEX ix_copy_media    ON copy(media_id);
CREATE INDEX ix_copy_location ON copy(location_id);
Powered by Datasette · Queries took 9.389ms