Query

avito.sqlite — listing_monitor_events

SQL

CREATE TABLE listing_monitor_events  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  canonical_url TEXT NOT NULL,
  listing_id TEXT,
  event_type TEXT NOT NULL,
  title TEXT,
  previous_price_text TEXT,
  current_price_text TEXT,
  price_delta_value REAL,
  created_at TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
canonical_url TEXT Rename | Drop
listing_id TEXT ✓ Rename | Drop
event_type TEXT Rename | Drop
title TEXT ✓ Rename | Drop
previous_price_text TEXT ✓ Rename | Drop
current_price_text TEXT ✓ Rename | Drop
price_delta_value REAL ✓ Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?