SQL
CREATE TABLE "chat_hub_sessions" (
"id" varchar PRIMARY KEY NOT NULL,
"title" varchar(256) NOT NULL,
"ownerId" varchar NOT NULL,
"lastMessageAt" datetime(3) NOT NULL,
"credentialId" varchar(36),
"provider" varchar(16),
"model" varchar(64),
"workflowId" varchar(36),
"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')),
"agentId" varchar(36),
"agentName" varchar(128),
"type" varchar(16) NOT NULL DEFAULT ('production'),
CONSTRAINT "CHK_chat_hub_sessions_type" CHECK ("type" IN ('production', 'manual')),
CONSTRAINT "FK_chat_hub_sessions_agentId" FOREIGN KEY ("agentId") REFERENCES "chat_hub_agents" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_9f9293d9f552496c40e0d1a8f80" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_7bc13b4c7e6afbfaf9be326c189" FOREIGN KEY ("credentialId") REFERENCES "credentials_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_e9ecf8ede7d989fcd18790fe36a" 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 | |
title |
varchar(256) |
Rename | Drop | ||
ownerId |
varchar |
Rename | Drop | ||
lastMessageAt |
datetime(3) |
Rename | Drop | ||
credentialId |
varchar(36) |
✓ | Rename | Drop | |
provider |
varchar(16) |
✓ | Rename | Drop | |
model |
varchar(64) |
✓ | Rename | Drop | |
workflowId |
varchar(36) |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop | ||
agentId |
varchar(36) |
✓ | Rename | Drop | |
agentName |
varchar(128) |
✓ | Rename | Drop | |
type |
varchar(16) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
ownerId |
user.id |
credentialId |
credentials_entity.id |
workflowId |
workflow_entity.id |
agentId |
chat_hub_agents.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_chat_hub_sessions_1 |
id
|
✓ | SQL | Drop |