Query

database.sqlite — instance_ai_run_snapshots

SQL

CREATE TABLE "instance_ai_run_snapshots"  (
  "threadId" varchar NOT NULL,
  "runId" varchar(36) NOT NULL,
  "messageGroupId" varchar(36),
  "runIds" text,
  "tree" text NOT NULL,
  "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')),
  "langsmithRunId" varchar(36),
  "langsmithTraceId" varchar(36),
  "traceId" varchar(64),
  "spanId" varchar(64),
  CONSTRAINT "FK_2f63fa21d09d7918f347ddbdf70" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  PRIMARY KEY ("threadId", "runId")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
threadId varchar ✓ Rename | Drop
runId varchar(36) ✓ Rename | Drop
messageGroupId varchar(36) ✓ Rename | Drop
runIds TEXT ✓ Rename | Drop
tree TEXT Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
langsmithRunId varchar(36) ✓ Rename | Drop
langsmithTraceId varchar(36) ✓ Rename | Drop
traceId varchar(64) ✓ Rename | Drop
spanId varchar(64) ✓ Rename | Drop

Foreign Keys

Column Destination
threadId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_d3a2bc880e7a8626802e5474ad
  • threadId
  • createdAt
 SQL 
CREATE INDEX "IDX_d3a2bc880e7a8626802e5474ad"
ON "instance_ai_run_snapshots" ("threadId", "createdAt")
Drop
IDX_d926c16c2ad9728cb9a81790c0
  • threadId
  • messageGroupId
 SQL 
CREATE INDEX "IDX_d926c16c2ad9728cb9a81790c0"
ON "instance_ai_run_snapshots" ("threadId", "messageGroupId")
Drop
sqlite_autoindex_instance_ai_run_snapshots_1
  • threadId
  • runId
 ✓ SQL
-- no sql found --
 Drop