10 lines
536 B
SQL
10 lines
536 B
SQL
--------------------------------------------------------
|
|
-- Constraints for Table SYSTEM_ROLE
|
|
--------------------------------------------------------
|
|
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_ROLE" MODIFY ("ID_APEX_ROLE" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_ROLE" MODIFY ("ID_ROLE" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_ROLE" MODIFY ("IDM_GROUP" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_ROLE" ADD CONSTRAINT "PK_SYSTEM_ROLE" PRIMARY KEY ("ID_ROLE")
|
|
USING INDEX "ENVX_OPER"."PK_SYSTEM_ROLE" ENABLE;
|