avito.sqlite — seen_listings

CREATE TABLE seen_listings  (
  fingerprint_hash TEXT PRIMARY KEY,
  listing_id TEXT NOT NULL,
  source_url TEXT NOT NULL,
  canonical_url TEXT NOT NULL,
  title TEXT NOT NULL,
  price_text TEXT,
  location_text TEXT,
  published_text TEXT,
  thumbnail_url TEXT,
  image_urls TEXT NOT NULL,
  seller_name TEXT,
  seller_url TEXT,
  description_preview TEXT,
  collected_at TEXT NOT NULL,
  first_seen_at TEXT NOT NULL,
  last_seen_at TEXT NOT NULL,
  seen_count INTEGER NOT NULL DEFAULT 1,
  monitor_last_checked_at TEXT,
  monitor_check_count INTEGER NOT NULL DEFAULT 0,
  monitor_last_price_text TEXT,
  monitor_last_price_value REAL,
  monitor_status TEXT NOT NULL DEFAULT 'active',
  monitor_sold_at TEXT,
  monitor_last_notification_at TEXT,
  monitor_last_price_change_at TEXT,
  monitor_price_change_count INTEGER NOT NULL DEFAULT 0,
  monitor_next_check_at TEXT
)