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