LibMonitor
Tables (6)
book
- book_id — SERIAL — Primary key — NOT NULL
- isbn — VARCHAR(13) — NOT NULL
- title — TEXT — NOT NULL
- author — TEXT
- publisher — TEXT
- pub_year — DATE
- category — TEXT
- is_tracked — INTEGER — NOT NULL
fetch_history
- fetch_id — SERIAL — Primary key — NOT NULL
- status — INTEGER — NOT NULL
- started — TIMESTAMPZ — NOT NULL
- finished — TIMESTAMPZ
- note — TEXT
library
- library_id — SERIAL — Primary key — NOT NULL
- library_name — TEXT — NOT NULL
- address — TEXT
- address_gu — VARCHAR(10)
- phone — TEXT
- homepage — TEXT
- lat_y — DOUBLE
- lon_x — DOUBLE
- is_tracked — INTEGER — NOT NULL
ranking
- rank_id — SERIAL — Primary key
- period — INTEGER — NOT NULL
- target_type — INTEGER — NOT NULL
- target_id — INTEGER
- target_date — DATE — NOT NULL
- top_k — INTEGER — NOT NULL
- rank_json — JSONB — NOT NULL
- created — TIMESTAMPZ — NOT NULL
snapshot
- snapshot_id — SERIAL — Primary key — NOT NULL
- created — TIMESTAMPZ — NOT NULL
- total_count — INTEGER — NOT NULL
- available_count — INTEGER — NOT NULL
- book_id — INTEGER — Foreign key → book.book_id — NOT NULL
- library_id — INTEGER — Foreign key → library.library_id — NOT NULL
- fetch_id — INTEGER — Foreign key → fetch_history.fetch_id — NOT NULL
stock
- stock_id — SERIAL — Primary key
- total_count — INTEGER — NOT NULL
- updated — TIMESTAMPZ — NOT NULL
- book_id — INTEGER — Foreign key → book.book_id — NOT NULL
- library_id — INTEGER — Foreign key → library.library_id — NOT NULL