Query

database.sqlite — insights_metadata

SQL

CREATE TABLE "insights_metadata"  (
  "metaId" integer PRIMARY KEY NOT NULL,
  "workflowId" varchar(16),
  "projectId" varchar(36),
  "workflowName" varchar(128) NOT NULL,
  "projectName" varchar(255) NOT NULL,
  CONSTRAINT "FK_1d8ab99d5861c9388d2dc1cf733" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE SET NULL,
  CONSTRAINT "FK_2375a1eda085adb16b24615b69c" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
metaId INTEGER ✓ Rename | Drop
workflowId varchar(16) ✓ Rename | Drop
projectId varchar(36) ✓ Rename | Drop
workflowName varchar(128) Rename | Drop
projectName varchar(255) Rename | Drop

Foreign Keys

Column Destination
projectId project.id
workflowId workflow_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_1d8ab99d5861c9388d2dc1cf73 workflowId ✓ SQL 
CREATE UNIQUE INDEX "IDX_1d8ab99d5861c9388d2dc1cf73"
ON "insights_metadata" ("workflowId")
Drop