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
)