100 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| community2community_child_comm_id_fkey |
|
|
Restrict delete | ||
| community2community_parent_comm_id_fkey |
|
|
Restrict delete | ||
| collection_admin_fkey |
|
|
Restrict delete | ||
| collection_uuid_fkey |
|
|
Restrict delete | ||
| collection_submitter_fkey |
|
|
Restrict delete | ||
| epersongroup_uuid_fkey |
|
|
Restrict delete | ||
| process2bitstream_bitstream_id_fkey |
|
|
Restrict delete | ||
| process2bitstream_process_id_fkey |
|
|
Restrict delete | ||
| resourcepolicy_dspace_object_fkey |
|
|
Cascade on delete | ||
| resourcepolicy_epersongroup_id_fkey |
|
|
Restrict delete | ||
| resourcepolicy_eperson_id_fkey |
|
|
Restrict delete | ||
| community_uuid_fkey |
|
|
Restrict delete | ||
| community_logo_bitstream_id_fkey |
|
|
Restrict delete | ||
| community_admin_fkey |
|
|
Restrict delete | ||
| orcid_queue_entity_id_fkey |
|
|
Restrict delete | ||
| orcid_queue_owner_id_fkey |
|
|
Restrict delete | ||
| process_eperson |
|
|
Null on delete | ||
| item_uuid_fkey |
|
|
Restrict delete | ||
| eperson_uuid_fkey |
|
|
Restrict delete | ||
| community2collection_collection_id_fkey |
|
|
Restrict delete | ||
| community2collection_community_id_fkey |
|
|
Restrict delete | ||
| doi_dspace_object_fkey |
|
|
Restrict delete | ||
| versionitem_item_id_fkey |
|
|
Restrict delete | ||
| versionitem_eperson_id_fkey |
|
|
Restrict delete | ||
| versionitem_versionhistory_id_fkey |
|
|
Restrict delete | ||
| group2group_child_id_fkey |
|
|
Restrict delete | ||
| group2group_parent_id_fkey |
|
|
Restrict delete | ||
| item2bundle_item_id_fkey |
|
|
Restrict delete | ||
| item2bundle_bundle_id_fkey |
|
|
Restrict delete | ||
| metadatavalue_dspace_object_id_fkey |
|
|
Cascade on delete | ||
| metadatavalue_metadata_field_id_fkey |
|
|
Restrict delete | ||
| cwf_pooltask_eperson_id_fkey |
|
|
Restrict delete | ||
| cwf_pooltask_group_id_fkey |
|
|
Restrict delete | ||
| cwf_pooltask_workflowitem_id_fkey |
|
|
Restrict delete | ||
| subscription_parameter_subscription_fkey |
|
|
Cascade on delete | ||
| cwf_workflowitem_collection_id_fkey |
|
|
Restrict delete | ||
| cwf_workflowitem_item_id_fkey |
|
|
Restrict delete | ||
| item_uuid_fkey |
|
|
Restrict delete | ||
| item_owning_collection_fkey |
|
|
Restrict delete | ||
| item_submitter_id_fkey |
|
|
Restrict delete | ||
| notifyservice_inbound_pattern_service_id_fkey |
|
|
Cascade on delete | ||
| orcid_token_profile_item_id_fkey |
|
|
Restrict delete | ||
| orcid_token_eperson_id_fkey |
|
|
Restrict delete | ||
| relationship_type_right_type_fkey |
|
|
Restrict delete | ||
| relationship_type_left_type_fkey |
|
|
Restrict delete | ||
| cwf_workflowitemrole_group_id_fkey |
|
|
Restrict delete | ||
| cwf_workflowitemrole_workflowitem_id_fkey |
|
|
Restrict delete | ||
| cwf_workflowitemrole_eperson_id_fkey |
|
|
Restrict delete | ||
| relationship_left_id_fkey |
|
|
Restrict delete | ||
| relationship_type_id_fkey |
|
|
Restrict delete | ||
| relationship_right_id_fkey |
|
|
Restrict delete | ||
| handle_resource_id_fkey |
|
|
Restrict delete | ||
| group2groupcache_child_id_fkey |
|
|
Restrict delete | ||
| group2groupcache_parent_id_fkey |
|
|
Restrict delete | ||
| checksum_history_result_fkey |
|
|
Restrict delete | ||
| checksum_history_bitstream_id_fkey |
|
|
Restrict delete | ||
| notifypatterns_to_trigger_item_id_fkey |
|
|
Cascade on delete | ||
| notifypatterns_to_trigger_service_id_fkey |
|
|
Cascade on delete | ||
| cwf_in_progress_user_workflowitem_id_fkey |
|
|
Restrict delete | ||
| cwf_in_progress_user_user_id_fkey |
|
|
Restrict delete | ||
| cwf_claimtask_owner_id_fkey |
|
|
Restrict delete | ||
| cwf_claimtask_workflowitem_id_fkey |
|
|
Restrict delete | ||
| eperson_uuid_fkey |
|
|
Restrict delete | ||
| harvested_collection_collection_id_fkey |
|
|
Restrict delete | ||
| site_uuid_fkey |
|
|
Restrict delete | ||
| fileextension_bitstream_format_id_fkey |
|
|
Restrict delete | ||
| process2group_process_id_fkey |
|
|
Restrict delete | ||
| process2group_group_id_fkey |
|
|
Cascade on delete | ||
| bitstream_bitstream_format_id_fkey |
|
|
Restrict delete | ||
| bitstream_uuid_fkey |
|
|
Restrict delete | ||
| bundle2bitstream_bitstream_id_fkey |
|
|
Restrict delete | ||
| bundle2bitstream_bundle_id_fkey |
|
|
Restrict delete | ||
| requestitem_bitstream_id_fkey |
|
|
Restrict delete | ||
| requestitem_item_id_fkey |
|
|
Restrict delete | ||
| subscription_eperson_id_fkey |
|
|
Restrict delete | ||
| subscription_dspaceobject_fkey |
|
|
Restrict delete | ||
| workspaceitem_item_id_fkey |
|
|
Restrict delete | ||
| workspaceitem_collection_id_fkey |
|
|
Restrict delete | ||
| workspaceitem_collection_id_fk |
|
|
Restrict delete | ||
| epersongroup2eperson_eperson_id_fkey |
|
|
Restrict delete | ||
| epersongroup2eperson_eperson_group_id_fkey |
|
|
Restrict delete | ||
| metadatafieldregistry_metadata_schema_id_fkey |
|
|
Restrict delete | ||
| bundle_uuid_fkey |
|
|
Restrict delete | ||
| bundle_primary_bitstream_id_fkey |
|
|
Restrict delete | ||
| cwf_collectionrole_group_id_fkey |
|
|
Restrict delete | ||
| cwf_collectionrole_collection_id_fkey |
|
|
Restrict delete | ||
| collection2item_collection_id_fkey |
|
|
Restrict delete | ||
| collection2item_item_id_fkey |
|
|
Restrict delete | ||
| supervision_orders_item_id_fkey |
|
|
Cascade on delete | ||
| supervision_orders_eperson_group_id_fkey |
|
|
Cascade on delete | ||
| harvested_item_item_id_fkey |
|
|
Restrict delete | ||
| ldn_message_object_fkey |
|
|
Null on delete | ||
| ldn_message_inreplyto_fkey |
|
|
Null on delete | ||
| ldn_message_origin_fkey |
|
|
Null on delete | ||
| ldn_message_target_fkey |
|
|
Null on delete | ||
| ldn_message_context_fkey |
|
|
Null on delete | ||
| orcid_history_entity_id_fkey |
|
|
Restrict delete | ||
| orcid_history_owner_id_fkey |
|
|
Restrict delete | ||
| most_recent_checksum_bitstream_id_fkey |
|
|
Restrict delete | ||
| most_recent_checksum_result_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| resourcepolicy | resourcepolicy_eperson_and_epersongroup_not_nullobject_chk | (((eperson_id IS NOT NULL) OR (epersongroup_id IS NOT NULL))) |