--------------------------------------------------------
--  Constraints for Table DEPLOYMENT_PATTERN_STEP
--------------------------------------------------------

  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("EXEC_SEQUENCE" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("STEP_NAME" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("STEP_DESCRIPTION" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_STEP_TYPE" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_PATTERN_STEP" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_SCOPE" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_EXEC_CATEGORY" NOT NULL ENABLE);
  ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" ADD CONSTRAINT "PK_DEPLOYMENT_PATTERN_STEP" PRIMARY KEY ("ID_PATTERN_STEP", "ID_PATTERN")
  USING INDEX "ENVX_OPER"."PK_DEPLOYMENT_PATTERN_STEP"  ENABLE;