Query

app.db — smile_preview_leads

SQL

CREATE TABLE smile_preview_leads  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  job_id INTEGER NOT NULL UNIQUE,
  name TEXT NOT NULL,
  email TEXT NOT NULL,
  phone TEXT,
  consent_at TEXT NOT NULL,
  page_url TEXT,
  referrer TEXT,
  FOREIGN KEY (job_id) REFERENCES smile_preview_jobs(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
job_id INTEGER Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
phone TEXT ✓ Rename | Drop
consent_at TEXT Rename | Drop
page_url TEXT ✓ Rename | Drop
referrer TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
job_id smile_preview_jobs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_smile_preview_leads_1 job_id ✓ SQL
-- no sql found --
 Drop