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')),
  CONSTRAINT "FK_d6870d3b6e4c185d33926f423c8" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE
)

+ 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

Foreign Keys

Column Destination
workflowId workflow_entity.id

+ Add index

Indexes

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