Constraints

13 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_ASS_5
OPERATION_ORGANIZATION.OPERATION_OBJECT_ID
OPERATION.OBJECT_ID
Restrict delete
FK_ASS_6
OPERATION_ORGANIZATION.ORGANIZATION_OBJECT_ID
ORGANIZATION.OBJECT_ID
Restrict delete
FK_ASS_7
PROFILE_ORGANIZATION.PROFILE_OBJECT_ID
PROFILE.OBJECT_ID
Restrict delete
FK_ASS_8
PROFILE_ORGANIZATION.ORGANIZATION_OBJECT_ID
ORGANIZATION.OBJECT_ID
Restrict delete
ORGANIZATION_COUNTRY_FK
ORGANIZATION.COUNTRY_ID
COUNTRY.OBJECT_ID
Restrict delete
FK_ASS_10
ROLE_PROVISIONING.PROVISIONING_OBJECT_ID
PROVISIONING_ENDPOINT.OBJECT_ID
Restrict delete
FK_ASS_9
ROLE_PROVISIONING.ROLE_OBJECT_ID
ROLE.OBJECT_ID
Restrict delete
ORG_PARENT_ORGANIZATION_FKV1
ORGANIZATION_PARENT.PARENT_ID
ORGANIZATION.OBJECT_ID
Restrict delete
ORG_PARENT_ORGANIZATION_FK
ORGANIZATION_PARENT.ORGANIZATION_ID
ORGANIZATION.OBJECT_ID
Restrict delete
FK_ASS_11
SERVICE_ROLE.SERVICE_OBJECT_ID
SERVICE.OBJECT_ID
Restrict delete
FK_ASS_12
SERVICE_ROLE.ROLE_OBJECT_ID
ROLE.OBJECT_ID
Restrict delete
FK_ASS_13
PROFILE_ROLE.PROFILE_OBJECT_ID
PROFILE.OBJECT_ID
Restrict delete
FK_ASS_14
PROFILE_ROLE.ROLE_OBJECT_ID
ROLE.OBJECT_ID
Restrict delete

Check Constraints

Table Constraint Name Constraint
SERVICE NNC_SERVICE_OBJECT_ID "OBJECT_ID" IS NOT NULL