Query

database.sqlite — execution_entity

SQL

CREATE TABLE "execution_entity"  (
  "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "finished" boolean NOT NULL,
  "mode" varchar NOT NULL,
  "retryOf" varchar,
  "retrySuccessId" varchar,
  "startedAt" datetime,
  "stoppedAt" datetime,
  "waitTill" datetime,
  "status" varchar NOT NULL,
  "deletedAt" datetime(3),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_c4d999a5e90784e8caccf5589de" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
workflowId varchar(36) Rename | Drop
finished boolean Rename | Drop
mode varchar Rename | Drop
retryOf varchar ✓ Rename | Drop
retrySuccessId varchar ✓ Rename | Drop
startedAt datetime ✓ Rename | Drop
stoppedAt datetime ✓ Rename | Drop
waitTill datetime ✓ Rename | Drop
status varchar Rename | Drop
deletedAt datetime(3) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
workflowId workflow_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_execution_entity_deletedAt deletedAt SQL 
CREATE INDEX "IDX_execution_entity_deletedAt"
ON "execution_entity" ("deletedAt")
Drop
IDX_execution_entity_stoppedAt stoppedAt SQL 
CREATE INDEX "IDX_execution_entity_stoppedAt"
ON "execution_entity" ("stoppedAt")
Drop