9 lines
541 B
SQL
9 lines
541 B
SQL
--------------------------------------------------------
|
|
-- Ref Constraints for Table ENVIROMENT
|
|
--------------------------------------------------------
|
|
|
|
ALTER TABLE "ENVX_OPER"."ENVIROMENT" ADD CONSTRAINT "ENVIROMENTS_ENV_TYPE" FOREIGN KEY ("ID_ENVIROMENT_TYPE")
|
|
REFERENCES "ENVX_OPER"."ENVIROMENT_TYPE" ("ID_ENVIROMENT_TYPE") ENABLE;
|
|
ALTER TABLE "ENVX_OPER"."ENVIROMENT" ADD CONSTRAINT "ENVIROMENT_HIERARCHY" FOREIGN KEY ("ID_PARENT_ENVIROMENT")
|
|
REFERENCES "ENVX_OPER"."ENVIROMENT" ("ID_ENVIROMENT") ON DELETE SET NULL ENABLE;
|