Query

database.sqlite — chat_hub_messages

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),
  "model" varchar(64),
  "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'),
  CONSTRAINT "FK_6afb260449dd7a9b85355d4e0c9" FOREIGN KEY ("executionId") REFERENCES "execution_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT "FK_1f4998c8a7dec9e00a9ab15550e" FOREIGN KEY ("revisionOfMessageId") REFERENCES "chat_hub_messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_25c9736e7f769f3a005eef4b372" FOREIGN KEY ("retryOfMessageId") 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_e5d1fa722c5a8d38ac204746662" FOREIGN KEY ("previousMessageId") REFERENCES "chat_hub_messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_e22538eb50a71a17954cd7e076c" FOREIGN KEY ("sessionId") REFERENCES "chat_hub_sessions" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ Add column

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
model varchar(64) ✓ 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

Foreign Keys

Column Destination
sessionId chat_hub_sessions.id
previousMessageId chat_hub_messages.id
workflowId workflow_entity.id
retryOfMessageId chat_hub_messages.id
revisionOfMessageId chat_hub_messages.id
executionId execution_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_chat_hub_messages_1 id ✓ SQL
-- no sql found --
 Drop