Query

database.sqlite — test_run

SQL

CREATE TABLE "test_run"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "status" varchar NOT NULL,
  "errorCode" varchar,
  "errorDetails" text,
  "runAt" datetime(3),
  "completedAt" datetime(3),
  "metrics" text,
  "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')),
  "runningInstanceId" varchar(255),
  "cancelRequested" boolean NOT NULL DEFAULT (FALSE),
  "workflowVersionId" varchar(36),
  "evaluationConfigId" varchar(36),
  "evaluationConfigSnapshot" text,
  "collectionId" varchar(36),
  CONSTRAINT "FK_test_run_evaluation_config_id" FOREIGN KEY ("evaluationConfigId") REFERENCES "evaluation_config" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT "FK_d6870d3b6e4c185d33926f423c8" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_test_run_collection_id" FOREIGN KEY ("collectionId") REFERENCES "evaluation_collection" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
workflowId varchar(36) Rename | Drop
status varchar Rename | Drop
errorCode varchar ✓ Rename | Drop
errorDetails TEXT ✓ Rename | Drop
runAt datetime(3) ✓ Rename | Drop
completedAt datetime(3) ✓ Rename | Drop
metrics TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
runningInstanceId varchar(255) ✓ Rename | Drop
cancelRequested boolean Rename | Drop
workflowVersionId varchar(36) ✓ Rename | Drop
evaluationConfigId varchar(36) ✓ Rename | Drop
evaluationConfigSnapshot TEXT ✓ Rename | Drop
collectionId varchar(36) ✓ Rename | Drop

Foreign Keys

Column Destination
collectionId evaluation_collection.id
workflowId workflow_entity.id
evaluationConfigId evaluation_config.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_d6870d3b6e4c185d33926f423c workflowId SQL 
CREATE INDEX "IDX_d6870d3b6e4c185d33926f423c"
ON "test_run" ("workflowId")
Drop
IDX_test_run_collectionId collectionId SQL 
CREATE INDEX "IDX_test_run_collectionId"
ON "test_run" ("collectionId")
Drop
IDX_test_run_evaluationConfigId evaluationConfigId SQL 
CREATE INDEX "IDX_test_run_evaluationConfigId"
ON "test_run" ("evaluationConfigId")
Drop
sqlite_autoindex_test_run_1 id ✓ SQL
-- no sql found --
 Drop