Files
oper/DB/CONSTRAINTS/DEPLOYMENT_REQ_ENV.sql
2023-06-08 11:55:59 -03:00

11 lines
694 B
SQL

--------------------------------------------------------
-- Constraints for Table DEPLOYMENT_REQ_ENV
--------------------------------------------------------
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_ENV" MODIFY ("ID_DEP_REQ_ENV" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_ENV" MODIFY ("ID_ENVIROMENT" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_ENV" MODIFY ("ID_DEPLOYING_TECH" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_ENV" MODIFY ("ID_REQUEST" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_ENV" ADD CONSTRAINT "DEPLOYMENT_REQ_ENV_PK" PRIMARY KEY ("ID_DEP_REQ_ENV")
USING INDEX "ENVX_OPER"."DEPLOYMENT_REQ_ENV_PK" ENABLE;