Add Column
Current Schema
CREATE TABLE knowledge_base_documents (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER,
voice_agent_config_id INTEGER,
collection_type TEXT NOT NULL,
document_id TEXT NOT NULL,
filename TEXT,
source_type TEXT,
file_path TEXT,
created_at TEXT NOT NULL,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (voice_agent_config_id) REFERENCES voice_agent_configs(id) ON DELETE CASCADE,
CHECK ((chatbot_id IS NOT NULL) OR (voice_agent_config_id IS NOT NULL))
)