Constraints

89 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
community2community_child_comm_id_fkey
community2community.child_comm_id
community.uuid
Restrict delete
community2community_parent_comm_id_fkey
community2community.parent_comm_id
community.uuid
Restrict delete
collection_admin_fkey
collection.admin
epersongroup.uuid
Restrict delete
collection_uuid_fkey
collection.uuid
dspaceobject.uuid
Restrict delete
collection_submitter_fkey
collection.submitter
epersongroup.uuid
Restrict delete
epersongroup_uuid_fkey
epersongroup.uuid
dspaceobject.uuid
Restrict delete
process2bitstream_bitstream_id_fkey
process2bitstream.bitstream_id
bitstream.uuid
Restrict delete
process2bitstream_process_id_fkey
process2bitstream.process_id
process.process_id
Restrict delete
resourcepolicy_dspace_object_fkey
resourcepolicy.dspace_object
dspaceobject.uuid
Cascade on delete
resourcepolicy_epersongroup_id_fkey
resourcepolicy.epersongroup_id
epersongroup.uuid
Restrict delete
resourcepolicy_eperson_id_fkey
resourcepolicy.eperson_id
eperson.uuid
Restrict delete
community_uuid_fkey
community.uuid
dspaceobject.uuid
Restrict delete
community_logo_bitstream_id_fkey
community.logo_bitstream_id
bitstream.uuid
Restrict delete
community_admin_fkey
community.admin
epersongroup.uuid
Restrict delete
orcid_queue_entity_id_fkey
orcid_queue.entity_id
item.uuid
Restrict delete
orcid_queue_owner_id_fkey
orcid_queue.owner_id
item.uuid
Restrict delete
community2collection_collection_id_fkey
community2collection.collection_id
collection.uuid
Restrict delete
community2collection_community_id_fkey
community2collection.community_id
community.uuid
Restrict delete
doi_dspace_object_fkey
doi.dspace_object
dspaceobject.uuid
Restrict delete
versionitem_item_id_fkey
versionitem.item_id
item.uuid
Restrict delete
versionitem_eperson_id_fkey
versionitem.eperson_id
eperson.uuid
Restrict delete
versionitem_versionhistory_id_fkey
versionitem.versionhistory_id
versionhistory.versionhistory_id
Restrict delete
group2group_child_id_fkey
group2group.child_id
epersongroup.uuid
Restrict delete
group2group_parent_id_fkey
group2group.parent_id
epersongroup.uuid
Restrict delete
item2bundle_item_id_fkey
item2bundle.item_id
item.uuid
Restrict delete
item2bundle_bundle_id_fkey
item2bundle.bundle_id
bundle.uuid
Restrict delete
metadatavalue_dspace_object_id_fkey
metadatavalue.dspace_object_id
dspaceobject.uuid
Cascade on delete
metadatavalue_metadata_field_id_fkey
metadatavalue.metadata_field_id
metadatafieldregistry.metadata_field_id
Restrict delete
cwf_pooltask_eperson_id_fkey
cwf_pooltask.eperson_id
eperson.uuid
Restrict delete
cwf_pooltask_group_id_fkey
cwf_pooltask.group_id
epersongroup.uuid
Restrict delete
cwf_pooltask_workflowitem_id_fkey
cwf_pooltask.workflowitem_id
cwf_workflowitem.workflowitem_id
Restrict delete
subscription_parameter_subscription_fkey
subscription_parameter.subscription_id
subscription.subscription_id
Cascade on delete
cwf_workflowitem_collection_id_fkey
cwf_workflowitem.collection_id
collection.uuid
Restrict delete
cwf_workflowitem_item_id_fkey
cwf_workflowitem.item_id
item.uuid
Restrict delete
item_uuid_fkey
item.uuid
dspaceobject.uuid
Restrict delete
item_owning_collection_fkey
item.owning_collection
collection.uuid
Restrict delete
item_submitter_id_fkey
item.submitter_id
eperson.uuid
Restrict delete
orcid_token_profile_item_id_fkey
orcid_token.profile_item_id
item.uuid
Restrict delete
orcid_token_eperson_id_fkey
orcid_token.eperson_id
eperson.uuid
Restrict delete
relationship_type_right_type_fkey
relationship_type.right_type
entity_type.id
Restrict delete
relationship_type_left_type_fkey
relationship_type.left_type
entity_type.id
Restrict delete
cwf_workflowitemrole_group_id_fkey
cwf_workflowitemrole.group_id
epersongroup.uuid
Restrict delete
cwf_workflowitemrole_workflowitem_id_fkey
cwf_workflowitemrole.workflowitem_id
cwf_workflowitem.workflowitem_id
Restrict delete
cwf_workflowitemrole_eperson_id_fkey
cwf_workflowitemrole.eperson_id
eperson.uuid
Restrict delete
relationship_left_id_fkey
relationship.left_id
item.uuid
Restrict delete
relationship_type_id_fkey
relationship.type_id
relationship_type.id
Restrict delete
relationship_right_id_fkey
relationship.right_id
item.uuid
Restrict delete
handle_resource_id_fkey
handle.resource_id
dspaceobject.uuid
Restrict delete
group2groupcache_child_id_fkey
group2groupcache.child_id
epersongroup.uuid
Restrict delete
group2groupcache_parent_id_fkey
group2groupcache.parent_id
epersongroup.uuid
Restrict delete
checksum_history_result_fkey
checksum_history.result
checksum_results.result_code
Restrict delete
checksum_history_bitstream_id_fkey
checksum_history.bitstream_id
bitstream.uuid
Restrict delete
cwf_in_progress_user_workflowitem_id_fkey
cwf_in_progress_user.workflowitem_id
cwf_workflowitem.workflowitem_id
Restrict delete
cwf_in_progress_user_user_id_fkey
cwf_in_progress_user.user_id
eperson.uuid
Restrict delete
cwf_claimtask_owner_id_fkey
cwf_claimtask.owner_id
eperson.uuid
Restrict delete
cwf_claimtask_workflowitem_id_fkey
cwf_claimtask.workflowitem_id
cwf_workflowitem.workflowitem_id
Restrict delete
eperson_uuid_fkey
eperson.uuid
dspaceobject.uuid
Restrict delete
harvested_collection_collection_id_fkey
harvested_collection.collection_id
collection.uuid
Restrict delete
site_uuid_fkey
site.uuid
dspaceobject.uuid
Restrict delete
fileextension_bitstream_format_id_fkey
fileextension.bitstream_format_id
bitstreamformatregistry.bitstream_format_id
Restrict delete
process2group_process_id_fkey
process2group.process_id
process.process_id
Restrict delete
process2group_group_id_fkey
process2group.group_id
epersongroup.uuid
Cascade on delete
bitstream_bitstream_format_id_fkey
bitstream.bitstream_format_id
bitstreamformatregistry.bitstream_format_id
Restrict delete
bitstream_uuid_fkey
bitstream.uuid
dspaceobject.uuid
Restrict delete
bundle2bitstream_bitstream_id_fkey
bundle2bitstream.bitstream_id
bitstream.uuid
Restrict delete
bundle2bitstream_bundle_id_fkey
bundle2bitstream.bundle_id
bundle.uuid
Restrict delete
requestitem_bitstream_id_fkey
requestitem.bitstream_id
bitstream.uuid
Restrict delete
requestitem_item_id_fkey
requestitem.item_id
item.uuid
Restrict delete
subscription_eperson_id_fkey
subscription.eperson_id
eperson.uuid
Restrict delete
subscription_dspaceobject_fkey
subscription.dspace_object_id
dspaceobject.uuid
Restrict delete
workspaceitem_item_id_fkey
workspaceitem.item_id
item.uuid
Restrict delete
workspaceitem_collection_id_fkey
workspaceitem.collection_id
collection.uuid
Restrict delete
workspaceitem_collection_id_fk
workspaceitem.collection_id
collection.uuid
Restrict delete
epersongroup2eperson_eperson_id_fkey
epersongroup2eperson.eperson_id
eperson.uuid
Restrict delete
epersongroup2eperson_eperson_group_id_fkey
epersongroup2eperson.eperson_group_id
epersongroup.uuid
Restrict delete
metadatafieldregistry_metadata_schema_id_fkey
metadatafieldregistry.metadata_schema_id
metadataschemaregistry.metadata_schema_id
Restrict delete
bundle_uuid_fkey
bundle.uuid
dspaceobject.uuid
Restrict delete
bundle_primary_bitstream_id_fkey
bundle.primary_bitstream_id
bitstream.uuid
Restrict delete
cwf_collectionrole_group_id_fkey
cwf_collectionrole.group_id
epersongroup.uuid
Restrict delete
cwf_collectionrole_collection_id_fkey
cwf_collectionrole.collection_id
collection.uuid
Restrict delete
collection2item_collection_id_fkey
collection2item.collection_id
collection.uuid
Restrict delete
collection2item_item_id_fkey
collection2item.item_id
item.uuid
Restrict delete
supervision_orders_item_id_fkey
supervision_orders.item_id
item.uuid
Cascade on delete
supervision_orders_eperson_group_id_fkey
supervision_orders.eperson_group_id
epersongroup.uuid
Cascade on delete
harvested_item_item_id_fkey
harvested_item.item_id
item.uuid
Restrict delete
orcid_history_entity_id_fkey
orcid_history.entity_id
item.uuid
Restrict delete
orcid_history_owner_id_fkey
orcid_history.owner_id
item.uuid
Restrict delete
most_recent_checksum_bitstream_id_fkey
most_recent_checksum.bitstream_id
bitstream.uuid
Restrict delete
most_recent_checksum_result_fkey
most_recent_checksum.result
checksum_results.result_code
Restrict delete

Check Constraints

Table Constraint Name Constraint