11 lines
469 B
SQL
11 lines
469 B
SQL
-- CreateTable
|
|
CREATE TABLE "WorkflowTemplateStepGroup" (
|
|
"id" TEXT NOT NULL,
|
|
"group" TEXT NOT NULL,
|
|
"workflowTemplateStepId" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "WorkflowTemplateStepGroup_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "WorkflowTemplateStepGroup" ADD CONSTRAINT "WorkflowTemplateStepGroup_workflowTemplateStepId_fkey" FOREIGN KEY ("workflowTemplateStepId") REFERENCES "WorkflowTemplateStep"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|