loan
3 rows
This data as json, CSV (advanced)
Suggested facets: person_id, direction, start_date, start_date (date), updated_at (date)
| id ▼ | uuid | copy_id | person_id | direction | start_date | due_date | returned_date | updated_at | deleted_at |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 906a039d3bf16dd7b7c0253b4b14490a | 80 80 | Person 1 1 | out | 2026-11-12 | 2026-11-12T12:35:43.376Z | |||
| 2 | 045a5a9742384f4ae40de7b5763fdae8 | 45 45 | Person 2 2 | in | 2026-11-16 | 2026-11-16T14:04:40.566Z | |||
| 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);