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
)