Constraints

67 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_workflow_step_2_fkey
collection.workflow_step_2
epersongroup.uuid
Restrict delete
collection_admin_fkey
collection.admin
epersongroup.uuid
Restrict delete
collection_workflow_step_3_fkey
collection.workflow_step_3
epersongroup.uuid
Restrict delete
collection_uuid_fkey
collection.uuid
dspaceobject.uuid
Restrict delete
collection_submitter_fkey
collection.submitter
epersongroup.uuid
Restrict delete
collection_workflow_step_1_fkey
collection.workflow_step_1
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
epersongroup_uuid_fkey
epersongroup.uuid
dspaceobject.uuid
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
community2collection_collection_id_fkey
community2collection.collection_id
collection.uuid
Restrict delete
community2collection_community_id_fkey
community2collection.community_id
community.uuid
Restrict delete
eperson_uuid_fkey
eperson.uuid
dspaceobject.uuid
Restrict delete
harvested_collection_collection_id_fkey
harvested_collection.collection_id
collection.uuid
Restrict delete
doi_dspace_object_fkey
doi.dspace_object
dspaceobject.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
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
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
subscription_eperson_id_fkey
subscription.eperson_id
eperson.uuid
Restrict delete
subscription_collection_id_fkey
subscription.collection_id
collection.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
tasklistitem_workflow_id_fkey
tasklistitem.workflow_id
workflowitem.workflow_id
Restrict delete
tasklistitem_eperson_id_fkey
tasklistitem.eperson_id
eperson.uuid
Restrict delete
epersongroup2workspaceitem_workspace_item_id_fkey
epersongroup2workspaceitem.workspace_item_id
workspaceitem.workspace_item_id
Restrict delete
epersongroup2workspaceitem_eperson_group_id_fkey
epersongroup2workspaceitem.eperson_group_id
epersongroup.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
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
collection2item_collection_id_fkey
collection2item.collection_id
collection.uuid
Restrict delete
collection2item_item_id_fkey
collection2item.item_id
item.uuid
Restrict delete
harvested_item_item_id_fkey
harvested_item.item_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
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
workflowitem_collection_id_fkey
workflowitem.collection_id
collection.uuid
Restrict delete
workflowitem_item_id_fkey
workflowitem.item_id
item.uuid
Restrict delete
workflowitem_owner_fkey
workflowitem.owner
eperson.uuid
Restrict delete

Check Constraints

Table Constraint Name Constraint