SQL
CREATE TABLE "chat_hub_sessions" (
"id" varchar PRIMARY KEY NOT NULL,
"title" varchar(256) NOT NULL,
"ownerId" varchar NOT NULL,
"lastMessageAt" datetime(3),
"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),
"tools" text NOT NULL DEFAULT ('[]'),
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 | |
tools |
TEXT |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
ownerId |
user.id |
credentialId |
credentials_entity.id |
workflowId |
workflow_entity.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_chat_hub_sessions_1 |
id
|
✓ | SQL | Drop |