Constraints

26 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
reffam_user10
fam_user_role_xref.user_id
fam_user.user_id
Restrict delete
reffam_role12
fam_user_role_xref.role_id
fam_role.role_id
Restrict delete
reffam_user_terms_conditions_user
fam_user_terms_conditions.user_id
fam_user.user_id
Restrict delete
reffam_application20
fam_application_group_xref.application_id
fam_application.application_id
Restrict delete
reffam_group19
fam_application_group_xref.group_id
fam_group.group_id
Restrict delete
reffam_application22
fam_role.application_id
fam_application.application_id
Restrict delete
reffam_forest_client24
fam_role.client_number_id
fam_forest_client.client_number_id
Restrict delete
reffam_role23
fam_role.parent_role_id
fam_role.role_id
Restrict delete
reffam_role_type
fam_role.role_type_code
fam_role_type.role_type_code
Restrict delete
reffam_application31
fam_application_client.application_id
fam_application.application_id
Restrict delete
reffam_role17
fam_group_role_xref.role_id
fam_role.role_id
Restrict delete
reffam_group18
fam_group_role_xref.group_id
fam_group.group_id
Restrict delete
reffam_user29
fam_user_group_xref.user_id
fam_user.user_id
Restrict delete
reffam_group30
fam_user_group_xref.group_id
fam_group.group_id
Restrict delete
reffam_access_control_privilege_role
fam_access_control_privilege.role_id
fam_role.role_id
Restrict delete
reffam_access_control_privilege_user
fam_access_control_privilege.user_id
fam_user.user_id
Restrict delete
reffam_user_type
fam_user.user_type_code
fam_user_type_code.user_type_code
Restrict delete
fk_change_target_user
fam_privilege_change_audit.change_target_user_id
fam_user.user_id
Restrict delete
fk_application
fam_privilege_change_audit.application_id
fam_application.application_id
Restrict delete
fk_privilege_change_type
fam_privilege_change_audit.privilege_change_type_code
fam_privilege_change_type.privilege_change_type_code
Restrict delete
fk_change_performer_user
fam_privilege_change_audit.change_performer_user_id
fam_user.user_id
Restrict delete
reffam_application_admin_application
fam_application_admin.application_id
fam_application.application_id
Restrict delete
reffam_application_admin_user
fam_application_admin.user_id
fam_user.user_id
Restrict delete
reffam_app_env
fam_application.app_environment
fam_app_environment.app_environment
Restrict delete
reffam_forest_client25
fam_group.client_number_id
fam_forest_client.client_number_id
Restrict delete
reffam_group16
fam_group.parent_group_id
fam_group.group_id
Restrict delete

Check Constraints

Table Constraint Name Constraint