SQL
CREATE TABLE "chat_hub_agents" (
"id" varchar PRIMARY KEY NOT NULL,
"name" varchar(256) NOT NULL,
"description" varchar(512),
"systemPrompt" text NOT NULL,
"ownerId" varchar NOT NULL,
"credentialId" varchar(36),
"provider" varchar(16) NOT NULL,
"model" varchar(64) NOT NULL,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"tools" text NOT NULL DEFAULT ('[]'),
CONSTRAINT "FK_9c61ad497dcbae499c96a6a78ba" FOREIGN KEY ("credentialId") REFERENCES "credentials_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_441ba2caba11e077ce3fbfa2cd8" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar |
✓ | Rename | Drop | |
name |
varchar(256) |
Rename | Drop | ||
description |
varchar(512) |
✓ | Rename | Drop | |
systemPrompt |
TEXT |
Rename | Drop | ||
ownerId |
varchar |
Rename | Drop | ||
credentialId |
varchar(36) |
✓ | Rename | Drop | |
provider |
varchar(16) |
Rename | Drop | ||
model |
varchar(64) |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop | ||
tools |
TEXT |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
ownerId |
user.id |
credentialId |
credentials_entity.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_chat_hub_agents_1 |
id
|
✓ | SQL | Drop |