Query

app.db — phone_receptionists

SQL

CREATE TABLE phone_receptionists  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  name TEXT NOT NULL,
  phone_number TEXT,
  instructions TEXT,
  stt_provider TEXT NOT NULL DEFAULT 'deepgram',
  tts_provider TEXT NOT NULL DEFAULT 'elevenlabs',
  llm_provider TEXT NOT NULL DEFAULT 'openai',
  llm_model TEXT NOT NULL DEFAULT 'gpt-4.1',
  voice_id TEXT,
  greeting TEXT,
  status TEXT NOT NULL DEFAULT 'inactive',
  created_at TEXT NOT NULL,
  updated_at TEXT,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  UNIQUE(chatbot_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
name TEXT Rename | Drop
phone_number TEXT ✓ Rename | Drop
instructions TEXT ✓ Rename | Drop
stt_provider TEXT Rename | Drop
tts_provider TEXT Rename | Drop
llm_provider TEXT Rename | Drop
llm_model TEXT Rename | Drop
voice_id TEXT ✓ Rename | Drop
greeting TEXT ✓ Rename | Drop
status 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_phone_receptionists_chatbot_id chatbot_id SQL 
CREATE INDEX idx_phone_receptionists_chatbot_id
ON phone_receptionists(chatbot_id)
Drop
sqlite_autoindex_phone_receptionists_1 chatbot_id ✓ SQL
-- no sql found --
 Drop