CREATE TABLE bookings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
widget_connection_id INTEGER NOT NULL,
chatbot_id INTEGER NOT NULL,
name TEXT NOT NULL,
email TEXT NOT NULL,
company TEXT,
date TEXT NOT NULL,
time TEXT NOT NULL,
datetime TEXT NOT NULL,
message TEXT,
type TEXT DEFAULT 'discovery_call',
source TEXT DEFAULT 'website',
status TEXT DEFAULT 'pending',
booking_id TEXT NOT NULL UNIQUE,
calendar_event_id TEXT,
airtable_record_id TEXT,
created_at TEXT NOT NULL,
updated_at TEXT,
FOREIGN KEY (widget_connection_id) REFERENCES widget_connections(id) ON DELETE CASCADE,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)