Constraints

29 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
log_entry_le_origin_fkey2
log_entry.le_origin
single_file_attachment.id
Restrict delete
log_entry_le_origin_fkey1
log_entry.le_origin
persistent_job.id
Restrict delete
log_entry_le_origin_fkey
log_entry.le_origin
kbart_import_job.id
Restrict delete
subscription_agreement_org_sao_owner_fk_fkey1
subscription_agreement_org.sao_owner_fk
subscription_agreement.sa_id
Restrict delete
subscription_agreement_org_sao_owner_fk_fkey
subscription_agreement_org.sao_owner_fk
erm_title_list.id
Restrict delete
subscription_agreement_org_sao_org_fk_fkey
subscription_agreement_org.sao_org_fk
org.org_id
Restrict delete
org_org_orgs_uuid_fkey
org.org_orgs_uuid
organizations__t.id
Restrict delete
agreement_relationship_ar_outward_fk_fkey1
agreement_relationship.ar_outward_fk
subscription_agreement.sa_id
Restrict delete
agreement_relationship_ar_outward_fk_fkey
agreement_relationship.ar_outward_fk
erm_title_list.id
Restrict delete
agreement_relationship_ar_inward_fk_fkey
agreement_relationship.ar_inward_fk
erm_title_list.id
Restrict delete
agreement_relationship_ar_inward_fk_fkey1
agreement_relationship.ar_inward_fk
subscription_agreement.sa_id
Restrict delete
remote_license_link_rol_remote_id_fkey
remote_license_link.rol_remote_id
license.lic_id
Restrict delete
remote_license_link_rll_owner_fkey
remote_license_link.rll_owner
erm_title_list.id
Restrict delete
remote_license_link_rll_owner_fkey1
remote_license_link.rll_owner
subscription_agreement.sa_id
Restrict delete
internal_contact_ic_owner_fk_fkey
internal_contact.ic_owner_fk
erm_title_list.id
Restrict delete
internal_contact_ic_owner_fk_fkey1
internal_contact.ic_owner_fk
subscription_agreement.sa_id
Restrict delete
internal_contact_ic_user_fk_fkey
internal_contact.ic_user_fk
users__t.id
Restrict delete
entitlement_ent_owner_fk_fkey1
entitlement.ent_owner_fk
subscription_agreement.sa_id
Restrict delete
entitlement_ent_owner_fk_fkey
entitlement.ent_owner_fk
erm_title_list.id
Restrict delete
subscription_agreement_org_role_saor_owner_fk_fkey
subscription_agreement_org_role.saor_owner_fk
subscription_agreement_org.sao_id
Restrict delete
order_line_pol_owner_fk_fkey
order_line.pol_owner_fk
entitlement.ent_id
Restrict delete
order_line_pol_orders_fk_fkey
order_line.pol_orders_fk
po_line__t.id
Restrict delete
file_upload_fu_owner_fkey2
file_upload.fu_owner
single_file_attachment.id
Restrict delete
file_upload_fu_owner_fkey
file_upload.fu_owner
kbart_import_job.id
Restrict delete
file_upload_file_object_id_fkey
file_upload.file_object_id
file_object.fo_id
Restrict delete
file_upload_fu_owner_fkey1
file_upload.fu_owner
persistent_job.id
Restrict delete
license_amendment_status_las_amendment_id_fkey
license_amendment_status.las_amendment_id
license.lic_id
Restrict delete
period_per_owner_fkey1
period.per_owner
subscription_agreement.sa_id
Restrict delete
period_per_owner_fkey
period.per_owner
erm_title_list.id
Restrict delete

Check Constraints

Table Constraint Name Constraint