SQLite Web: avito.sqlite

fingerprint_hash

Primary key. TEXT

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

avito.sqlite — seen_listings

Insert row into seen_listings