SQL
CREATE TABLE chatbot_tools (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
tool_name TEXT NOT NULL,
is_enabled INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
UNIQUE(chatbot_id, tool_name)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | Rename | Drop |
chatbot_id |
INTEGER |
Rename | Drop | ||
tool_name |
TEXT |
Rename | Drop | ||
is_enabled |
INTEGER |
✓ | Rename | Drop | |
created_at |
TEXT |
Rename | Drop | ||
updated_at |
TEXT |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
chatbot_id |
chatbots.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_chatbot_tools_1 |
|
✓ | SQL | Drop |