14 lines
1023 B
SQL
14 lines
1023 B
SQL
--------------------------------------------------------
|
|
-- Constraints for Table TMP_OBJECTS_REQUEST
|
|
--------------------------------------------------------
|
|
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" ADD CONSTRAINT "TMP_OBJECTS_REQUEST_PK" PRIMARY KEY ("ID_OBJECT_REPO", "OBJECT_NAME", "ID_REQUEST", "OBJECT_SOURCE_PATH")
|
|
USING INDEX "ENVX_OPER"."TMP_OBJECTS_REQUEST_PK" ENABLE;
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("OBJECT_SOURCE_PATH" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("OBJECT_NAME" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("ID_OBJECT_REPO" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("ID_REQ_HGROUP" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("ID_REQUEST" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_OBJECTS_REQUEST" MODIFY ("ID_DEP_REQ_OBJECT" NOT NULL ENABLE);
|