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,
  "publishedVersionId" varchar(36),
  CONSTRAINT "FK_a4ff2d9b9628ea988fa9e7d0bf8" 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
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
publishedVersionId varchar(36) ✓ 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
IDX_workflow_dependency_publishedVersionId publishedVersionId SQL 
CREATE INDEX "IDX_workflow_dependency_publishedVersionId"
ON "workflow_dependency" ("publishedVersionId")
Drop