Query

app.db — bookings

SQL

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
)

+ 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
name TEXT Rename | Drop
email TEXT Rename | Drop
company TEXT ✓ Rename | Drop
date TEXT Rename | Drop
time TEXT Rename | Drop
datetime TEXT Rename | Drop
message TEXT ✓ Rename | Drop
type TEXT ✓ Rename | Drop
source TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
booking_id TEXT Rename | Drop
calendar_event_id TEXT ✓ Rename | Drop
airtable_record_id TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at 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_bookings_booking_id booking_id SQL 
CREATE INDEX idx_bookings_booking_id
ON bookings(booking_id)
Drop
idx_bookings_chatbot_id chatbot_id SQL 
CREATE INDEX idx_bookings_chatbot_id
ON bookings(chatbot_id)
Drop
idx_bookings_datetime datetime SQL 
CREATE INDEX idx_bookings_datetime
ON bookings(datetime)
Drop
idx_bookings_widget_connection_id widget_connection_id SQL 
CREATE INDEX idx_bookings_widget_connection_id
ON bookings(widget_connection_id)
Drop
sqlite_autoindex_bookings_1 booking_id ✓ SQL
-- no sql found --
 Drop