SQL
CREATE TABLE "chat_hub_messages" (
"id" varchar PRIMARY KEY NOT NULL,
"sessionId" varchar NOT NULL,
"previousMessageId" varchar,
"revisionOfMessageId" varchar,
"retryOfMessageId" varchar,
"type" varchar(16) NOT NULL,
"name" varchar(128) NOT NULL,
"content" text NOT NULL,
"provider" varchar(16),
"workflowId" varchar(36),
"executionId" integer,
"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),
"status" varchar(16) NOT NULL DEFAULT ('success'),
"attachments" text,
"model" VARCHAR(256),
CONSTRAINT "FK_e22538eb50a71a17954cd7e076c" FOREIGN KEY ("sessionId") REFERENCES "chat_hub_sessions" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_e5d1fa722c5a8d38ac204746662" FOREIGN KEY ("previousMessageId") REFERENCES "chat_hub_messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_acf8926098f063cdbbad8497fd1" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_25c9736e7f769f3a005eef4b372" FOREIGN KEY ("retryOfMessageId") REFERENCES "chat_hub_messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_1f4998c8a7dec9e00a9ab15550e" FOREIGN KEY ("revisionOfMessageId") REFERENCES "chat_hub_messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_6afb260449dd7a9b85355d4e0c9" FOREIGN KEY ("executionId") REFERENCES "execution_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
CONSTRAINT "FK_chat_hub_messages_agentId" FOREIGN KEY ("agentId") REFERENCES "chat_hub_agents" ("id") ON DELETE SET NULL
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar |
✓ | Rename | Drop | |
sessionId |
varchar |
Rename | Drop | ||
previousMessageId |
varchar |
✓ | Rename | Drop | |
revisionOfMessageId |
varchar |
✓ | Rename | Drop | |
retryOfMessageId |
varchar |
✓ | Rename | Drop | |
type |
varchar(16) |
Rename | Drop | ||
name |
varchar(128) |
Rename | Drop | ||
content |
TEXT |
Rename | Drop | ||
provider |
varchar(16) |
✓ | Rename | Drop | |
workflowId |
varchar(36) |
✓ | Rename | Drop | |
executionId |
INTEGER |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop | ||
agentId |
varchar(36) |
✓ | Rename | Drop | |
status |
varchar(16) |
Rename | Drop | ||
attachments |
TEXT |
✓ | Rename | Drop | |
model |
VARCHAR(256) |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
agentId |
chat_hub_agents.id |
executionId |
execution_entity.id |
revisionOfMessageId |
chat_hub_messages.id |
retryOfMessageId |
chat_hub_messages.id |
workflowId |
workflow_entity.id |
previousMessageId |
chat_hub_messages.id |
sessionId |
chat_hub_sessions.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_chat_hub_messages_sessionId |
sessionId
|
SQL | Drop | |
| sqlite_autoindex_chat_hub_messages_1 |
id
|
✓ | SQL | Drop |