Create
Query
avito.sqlite
—
seen_listings
app_state
blacklist_entries
listing_monitor_events
notification_queue
proxy_ratings
scan_events
search_url_history
seen_listings
session_profiles
sqlite_sequence
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 08167f3a0e679568e66e47c88090556ce70c42ded69a10e8eda37ef2bced8b0a in seen_listings
fingerprint_hash
08167f3a0e679568e66e47c88090556ce70c42ded69a10e8eda37ef2bced8b0a
Primary key.
TEXT
listing_id
7972576306
TEXT NOT NULL
source_url
https://www.avito.ru/all/noutbuki?cd=1&f=ASgCAQECAUCq5A00iNlmitlm9thmAkXGmgwVeyJmcm9tIjowLCJ0byI6MTUwMDB9nKEUFXsiZnJvbSI6MTIsInRvIjpudWxsfQ&s=104
TEXT NOT NULL
canonical_url
https://www.avito.ru/novosibirsk/noutbuki/apple_macbook_12_2016_7972576306
TEXT NOT NULL
title
Apple macbook 12 2016
TEXT NOT NULL
price_text
17 500 ₽
TEXT
location_text
NULL
TEXT
published_text
1 час назад
TEXT
thumbnail_url
https://30.img.avito.st/image/1/1.mupH7raANgNRTpQCf-iFz3dONAf1WTID9T5XB_XtN6HyTTIZUU6UAvE.qxirE76fKY10k65jqf-tduoJ5p08ARr3UraOR-0GtKY?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1
TEXT
image_urls
["https://30.img.avito.st/image/1/1.mupH7raANgNRTpQCf-iFz3dONAf1WTID9T5XB_XtN6HyTTIZUU6UAvE.qxirE76fKY10k65jqf-tduoJ5p08ARr3UraOR-0GtKY?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1","https://20.img.avito.st/image/1/1.AeXsy7aArQz6aw8N4s8DwNxrrwhefKkMXhvMCF7IrK5ZaKkW-msPDVo.dmfLOoZ0VqJBKJTUc0UYT6MNBgpeHPYwBPATbnS_rqg?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1","https://00.img.avito.st/image/1/1.HBwR47aAsPUHQxL0JZMUOyFDsvGjVLT1ozPR8aPgsVekQLTvB0MS9Kc.tIk7tWGsv-zzEhyUf94Vm2kaP61FGg99_Vz493rBWNY?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1","https://20.img.avito.st/image/1/1.5juLcLaAStKd0OjTy2vvHLvQSNY5x07SOaAr1jlzS3A-007IndDo0z0.rli2UEDTuW9iG_DfUbgM6gH5dKHHRK-O63NYB54IyqM?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1","https://20.img.avito.st/image/1/1.zjuLVbaAYtKd9cDTm1rGHLv1YNY54mbSOYUD1jlWY3A-9mbInfXA0z0.FCxOA2z3Cqo37Np8eQPJXleksLTUpMkePZ6tjAwlLb8?cqp=2.31EmCLg6ik3oatt1ttbFq_ajuGsz9wCshVqsaNgtLVVqtiwIcdxsWidTBGP4W2gjZpwuVqcdzwQCR5DnUbaoBbU1"]
TEXT NOT NULL
seller_name
Александр
TEXT
seller_url
https://www.avito.ru/brands/721fa4d926b971296fa9d7578f55bd64
TEXT
description_preview
Заказ для клиента.1 час назад
TEXT
collected_at
2026-04-04T15:27:23.918Z
TEXT NOT NULL
first_seen_at
2026-04-04T15:27:23.963Z
TEXT NOT NULL
last_seen_at
2026-04-04T15:27:23.963Z
TEXT NOT NULL
seen_count
INTEGER NOT NULL (default 1
monitor_last_checked_at
NULL
TEXT
monitor_check_count
INTEGER NOT NULL (default 0
monitor_last_price_text
NULL
TEXT
monitor_last_price_value
REAL
monitor_status
active
TEXT NOT NULL (default 'active'
monitor_sold_at
NULL
TEXT
monitor_last_notification_at
NULL
TEXT
monitor_last_price_change_at
NULL
TEXT
monitor_price_change_count
INTEGER NOT NULL (default 0
monitor_next_check_at
NULL
TEXT
Update
Cancel