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)
)