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')),
  "storedAt" varchar(2) NOT NULL DEFAULT ('db'),
  "tracingContext" text,
  "deduplicationKey" varchar(255),
  "jsonSizeBytes" bigint NOT NULL DEFAULT (0),
  "workflowVersionId" varchar(36) DEFAULT (NULL),
  "binaryDataSizeBytes" bigint NOT NULL DEFAULT (0),
  "usedPrivateCredentials" BOOLEAN NOT NULL DEFAULT FALSE,
  CONSTRAINT "CHK_execution_entity_storedAt" CHECK ("storedAt" IN ('db', 'fs', 's3', 'az')),
  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
storedAt varchar(2) Rename | Drop
tracingContext TEXT ✓ Rename | Drop
deduplicationKey varchar(255) ✓ Rename | Drop
jsonSizeBytes bigint Rename | Drop
workflowVersionId varchar(36) ✓ Rename | Drop
binaryDataSizeBytes bigint Rename | Drop
usedPrivateCredentials BOOLEAN Rename | Drop

Foreign Keys

Column Destination
workflowId workflow_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_execution_entity_deduplicationKey deduplicationKey ✓ SQL 
CREATE UNIQUE INDEX "IDX_execution_entity_deduplicationKey"
ON "execution_entity" ("deduplicationKey") WHERE "deduplicationKey" IS NOT NULL
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