home / bibliothek

copy

6 rows where location_id = 4

✎ 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
22 6420fa6dce1229173b6bbd6087486668 Wortschatzblock Englisch: [222 spannende Lektionen ; für Anfänger und Wiedereinsteiger ; so macht Englisch lernen Spaß] 11 4 4 own unread   2026-11-11T16:30:22.690Z          
23 c2edf9a7a3991cce809569dc35b55e98 Digitale Fotografie: Grundlagen und Fotopraxis 12 4 4 own unread   2026-11-11T16:30:37.044Z          
24 ff6d68b3ded4c188b9eec203bf59c7c2 Die Sonnenfinsternis am 11. August 1999: das Phänomen und seine spirituelle Dimension 13 4 4 own unread   2026-11-11T16:31:44.238Z          
25 fcab5e09541b51368be69a9130049fa1 Der Kleine Prinz - Le Petit Prince: Zweisprachig: Französisch-Deutsch 14 4 4 own reading   2026-11-12T12:28:27.567Z       10  
26 bd9bfa6d69d23683df2aa41ccf96a8d5 Schiller und die Freiheit des Geistes 15 4 4 own read   2026-11-16T14:07:19.802Z     2020-07-06    
27 639811f6ad24fc4dfb57ad5f5769ed29 Karate kinderleicht erklärt 16 4 4 own unread   2026-11-11T16:36:54.896Z          

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