Query

database.sqlite — workflow_dependency

SQL

CREATE TABLE "workflow_dependency"  (
  "id" integer PRIMARY KEY NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "workflowVersionId" integer NOT NULL,
  "dependencyType" varchar(32) NOT NULL,
  "dependencyKey" varchar(255) NOT NULL,
  "indexVersionId" smallint NOT NULL DEFAULT (1),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "dependencyInfo" TEXT CONSTRAINT workflow_dependency_chk_dependency_info_is_json CHECK("dependencyInfo" IS NULL OR json_valid("dependencyInfo")),
  CONSTRAINT "FK_a4ff2d9b9628ea988fa9e7d0bf8" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
workflowId varchar(36) Rename | Drop
workflowVersionId INTEGER Rename | Drop
dependencyType varchar(32) Rename | Drop
dependencyKey varchar(255) Rename | Drop
indexVersionId smallint Rename | Drop
createdAt datetime(3) Rename | Drop
dependencyInfo TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
workflowId workflow_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_a4ff2d9b9628ea988fa9e7d0bf workflowId SQL 
CREATE INDEX "IDX_a4ff2d9b9628ea988fa9e7d0bf"
ON "workflow_dependency" ("workflowId")
Drop
IDX_e48a201071ab85d9d09119d640 dependencyKey SQL 
CREATE INDEX "IDX_e48a201071ab85d9d09119d640"
ON "workflow_dependency" ("dependencyKey")
Drop
IDX_e7fe1cfda990c14a445937d0b9 dependencyType SQL 
CREATE INDEX "IDX_e7fe1cfda990c14a445937d0b9"
ON "workflow_dependency" ("dependencyType")
Drop