Query

database.sqlite — workflow_review_reque...

SQL

CREATE TABLE "workflow_review_request_workflow"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "workflowReviewRequestId" varchar(36) NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "workflowVersionId" varchar(36),
  CONSTRAINT "FK_e44b652e6dc99ef1364a2d85504" FOREIGN KEY ("workflowReviewRequestId") REFERENCES "workflow_review_request" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_619f5b0544bcec60c3387e82f2f" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_0f6f0f2c6d46b806fee02962ac2" FOREIGN KEY ("workflowVersionId") REFERENCES "workflow_history" ("versionId") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
workflowReviewRequestId varchar(36) Rename | Drop
workflowId varchar(36) Rename | Drop
workflowVersionId varchar(36) ✓ Rename | Drop

Foreign Keys

Column Destination
workflowVersionId workflow_history.versionId
workflowId workflow_entity.id
workflowReviewRequestId workflow_review_request.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_workflow_review_request_workflow_workflow_request
  • workflowId
  • workflowReviewRequestId
 SQL 
CREATE INDEX "IDX_workflow_review_request_workflow_workflow_request"
ON "workflow_review_request_workflow"("workflowId", "workflowReviewRequestId")
Drop
UQ_workflow_review_request_workflow_request_workflow
  • workflowReviewRequestId
  • workflowId
 ✓ SQL 
CREATE UNIQUE INDEX "UQ_workflow_review_request_workflow_request_workflow"
ON "workflow_review_request_workflow"("workflowReviewRequestId", "workflowId")
Drop
sqlite_autoindex_workflow_review_request_workflow_1 id ✓ SQL
-- no sql found --
 Drop