Query

app.db — form_submissions

SQL

CREATE TABLE form_submissions  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  widget_connection_id INTEGER NOT NULL,
  chatbot_id INTEGER NOT NULL,
  form_type TEXT NOT NULL CHECK(form_type IN ('contact', 'quote_request')),
  name TEXT NOT NULL,
  email TEXT NOT NULL,
  company TEXT,
  message TEXT,
  source TEXT DEFAULT 'website',
  created_at TEXT NOT NULL,
  processed INTEGER DEFAULT 0,
  notes TEXT,
  phone TEXT,
  custom_fields TEXT,
  FOREIGN KEY (widget_connection_id) REFERENCES widget_connections(id) ON DELETE CASCADE,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
widget_connection_id INTEGER Rename | Drop
chatbot_id INTEGER Rename | Drop
form_type TEXT Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
company TEXT ✓ Rename | Drop
message TEXT ✓ Rename | Drop
source TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
processed INTEGER ✓ Rename | Drop
notes TEXT ✓ Rename | Drop
phone TEXT ✓ Rename | Drop
custom_fields TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id
widget_connection_id widget_connections.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_form_submissions_chatbot_id chatbot_id SQL 
CREATE INDEX idx_form_submissions_chatbot_id
ON form_submissions(chatbot_id)
Drop
idx_form_submissions_created_at created_at SQL 
CREATE INDEX idx_form_submissions_created_at
ON form_submissions(created_at)
Drop
idx_form_submissions_form_type form_type SQL 
CREATE INDEX idx_form_submissions_form_type
ON form_submissions(form_type)
Drop
idx_form_submissions_processed processed SQL 
CREATE INDEX idx_form_submissions_processed
ON form_submissions(processed)
Drop