loan
1 row where copy_id = 69
This data as json, CSV (advanced)
Suggested facets: start_date (date), updated_at (date)
| id ▼ | uuid | copy_id | person_id | direction | start_date | due_date | returned_date | updated_at | deleted_at |
|---|---|---|---|---|---|---|---|---|---|
| 3 | 174ff1a9d07a7774690c8a21ced72ffc | 69 69 | Person 2 2 | in | 2026-11-16 | 2026-11-16T14:05:04.768Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE loan (
id INTEGER PRIMARY KEY,
uuid TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
copy_id INTEGER NOT NULL REFERENCES copy(id),
person_id INTEGER NOT NULL REFERENCES person(id),
direction TEXT NOT NULL CHECK (direction IN ('out','in')), -- out = verliehen, in = geliehen
start_date TEXT,
due_date TEXT,
returned_date TEXT,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
deleted_at TEXT
);
CREATE INDEX ix_loan_copy ON loan(copy_id);