Query

app.db — leads

SQL

CREATE TABLE leads  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  phone_number TEXT NOT NULL,
  full_name TEXT,
  interests TEXT,
  purpose TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  UNIQUE(chatbot_id, phone_number)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
phone_number TEXT Rename | Drop
full_name TEXT ✓ Rename | Drop
interests TEXT ✓ Rename | Drop
purpose TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_leads_chatbot_id chatbot_id SQL 
CREATE INDEX idx_leads_chatbot_id
ON leads(chatbot_id)
Drop
idx_leads_phone_number phone_number SQL 
CREATE INDEX idx_leads_phone_number
ON leads(phone_number)
Drop
sqlite_autoindex_leads_1
  • chatbot_id
  • phone_number
 ✓ SQL
-- no sql found --
 Drop