SQL

CREATE TABLE scan_events  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  event_type TEXT NOT NULL,
  created_at TEXT NOT NULL,
  payload TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
event_type TEXT Rename | Drop
created_at TEXT Rename | Drop
payload TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?