home

bibliothek

Custom SQL query

Queries

  • Regal (Daten für die Regal-Ansicht)
  • Zuletzt ausgelesen

Tables

comment

id, uuid, copy_id, body, created_at, updated_at, deleted_at

0 rows

copy

id, uuid, media_id, location_id, ownership, read_status, notes, updated_at, deleted_at, rating, read_at, progress_page, progress_chapter

145 rows

genre

id, uuid, name, updated_at

30 rows

loan

id, uuid, copy_id, person_id, direction, start_date, due_date, returned_date, updated_at, deleted_at

3 rows

location

id, uuid, room, shelf, slot, updated_at, deleted_at

29 rows

media

id, uuid, media_type, title, creator, barcode, isbn13, publisher, year, cover_path, meta_status, updated_at, deleted_at, language, series, series_no, pages, pages_source

150 rows

media_genre

media_id, genre_id

185 rows

person

id, uuid, name, updated_at, deleted_at

2 rows

reading

id, uuid, copy_id, state, started_at, finished_at, updated_at, deleted_at

52 rows

wish

id, uuid, media_id, note, created_at, updated_at, deleted_at

0 rows

... and 1 hidden table

Powered by Datasette · Queries took 8.701ms