Constraints

141 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_variablerangeitem_datavariable_id
variablerangeitem.datavariable_id
datavariable.id
Restrict delete
fk_dataverse_defaulttemplate_id
dataverse.defaulttemplate_id
template.id
Restrict delete
fk_dataverse_id
dataverse.id
dvobject.id
Restrict delete
fk_dataverse_defaultcontributorrole_id
dataverse.defaultcontributorrole_id
dataverserole.id
Restrict delete
fk_ingestreport_datafile_id
ingestreport.datafile_id
dvobject.id
Restrict delete
fk_datasetversion_dataset_id
datasetversion.dataset_id
dvobject.id
Restrict delete
fk_datasetversion_termsofuseandaccess_id
datasetversion.termsofuseandaccess_id
termsofuseandaccess.id
Restrict delete
fk_metadatablock_owner_id
metadatablock.owner_id
dvobject.id
Restrict delete
fk_fileaccessrequests_datafile_id
fileaccessrequests.datafile_id
dvobject.id
Restrict delete
fk_fileaccessrequests_authenticated_user_id
fileaccessrequests.authenticated_user_id
authenticateduser.id
Restrict delete
fk_filemetadata_datafilecategory_filemetadatas_id
filemetadata_datafilecategory.filemetadatas_id
filemetadata.id
Restrict delete
fk_filemetadata_datafilecategory_filecategories_id
filemetadata_datafilecategory.filecategories_id
datafilecategory.id
Restrict delete
fk_datafilecategory_dataset_id
datafilecategory.dataset_id
dvobject.id
Restrict delete
fk_passwordresetdata_builtinuser_id
passwordresetdata.builtinuser_id
builtinuser.id
Restrict delete
fk_workflowstepdata_stepparameters_workflowstepdata_id
workflowstepdata_stepparameters.workflowstepdata_id
workflowstepdata.id
Restrict delete
fk_dataversetheme_dataverse_id
dataversetheme.dataverse_id
dvobject.id
Restrict delete
fk_roleassignment_role_id
roleassignment.role_id
dataverserole.id
Restrict delete
fk_roleassignment_definitionpoint_id
roleassignment.definitionpoint_id
dvobject.id
Restrict delete
fk_dataverse_citationdatasetfieldtypes_dataverse_id
dataverse_citationdatasetfieldtypes.dataverse_id
dvobject.id
Restrict delete
dataverse_citationdatasetfieldtypes_citationdatasetfieldtype_id
dataverse_citationdatasetfieldtypes.citationdatasetfieldtype_id
datasetfieldtype.id
Restrict delete
explicitgroup_authenticateduser_containedauthenticatedusers_id
explicitgroup_authenticateduser.containedauthenticatedusers_id
authenticateduser.id
Restrict delete
fk_explicitgroup_authenticateduser_explicitgroup_id
explicitgroup_authenticateduser.explicitgroup_id
explicitgroup.id
Restrict delete
fk_bannermessagetext_bannermessage_id
bannermessagetext.bannermessage_id
bannermessage.id
Restrict delete
fk_datasetmetrics_dataset_id
datasetmetrics.dataset_id
dvobject.id
Restrict delete
fk_dataverserole_owner_id
dataverserole.owner_id
dvobject.id
Restrict delete
fk_datasetfielddefaultvalue_defaultvalueset_id
datasetfielddefaultvalue.defaultvalueset_id
defaultvalueset.id
Restrict delete
fk_datasetfielddefaultvalue_datasetfield_id
datasetfielddefaultvalue.datasetfield_id
datasetfieldtype.id
Restrict delete
fk_datasetfielddefaultvalue_parentdatasetfielddefaultvalue_id
datasetfielddefaultvalue.parentdatasetfielddefaultvalue_id
datasetfielddefaultvalue.id
Restrict delete
fk_workflowstepdata_stepsettings_workflowstepdata_id
workflowstepdata_stepsettings.workflowstepdata_id
workflowstepdata.id
Restrict delete
fk_datasetversionuser_authenticateduser_id
datasetversionuser.authenticateduser_id
authenticateduser.id
Restrict delete
fk_datasetversionuser_datasetversion_id
datasetversionuser.datasetversion_id
datasetversion.id
Restrict delete
fk_confirmemaildata_authenticateduser_id
confirmemaildata.authenticateduser_id
authenticateduser.id
Restrict delete
fk_userbannermessage_bannermessage_id
userbannermessage.bannermessage_id
bannermessage.id
Restrict delete
fk_userbannermessage_user_id
userbannermessage.user_id
authenticateduser.id
Restrict delete
fk_dataversecontact_dataverse_id
dataversecontact.dataverse_id
dvobject.id
Restrict delete
fk_datafiletag_datafile_id
datafiletag.datafile_id
dvobject.id
Restrict delete
fk_datasetfieldcompoundvalue_parentdatasetfield_id
datasetfieldcompoundvalue.parentdatasetfield_id
datasetfield.id
Restrict delete
fk_dataversesubjects_dataverse_id
dataversesubjects.dataverse_id
dvobject.id
Restrict delete
fk_dataversesubjects_controlledvocabularyvalue_id
dataversesubjects.controlledvocabularyvalue_id
controlledvocabularyvalue.id
Restrict delete
fk_explicitgroup_containedroleassignees_explicitgroup_id
explicitgroup_containedroleassignees.explicitgroup_id
explicitgroup.id
Restrict delete
fk_summarystatistic_datavariable_id
summarystatistic.datavariable_id
datavariable.id
Restrict delete
fk_variablerange_datavariable_id
variablerange.datavariable_id
datavariable.id
Restrict delete
fk_dataversemetadatablockfacet_metadatablock_id
dataversemetadatablockfacet.metadatablock_id
metadatablock.id
Restrict delete
fk_dataversemetadatablockfacet_dataverse_id
dataversemetadatablockfacet.dataverse_id
dvobject.id
Restrict delete
fk_alternativepersistentidentifier_dvobject_id
alternativepersistentidentifier.dvobject_id
dvobject.id
Restrict delete
fk_termsofuseandaccess_license_id
termsofuseandaccess.license_id
license.id
Restrict delete
fk_termsofuseandcesss_license_id
termsofuseandaccess.license_id
license.id
Restrict delete
fk_ingestrequest_datafile_id
ingestrequest.datafile_id
dvobject.id
Restrict delete
fk_datasetfieldvalue_datasetfield_id
datasetfieldvalue.datasetfield_id
datasetfield.id
Restrict delete
fk_dataversefieldtypeinputlevel_dataverse_id
dataversefieldtypeinputlevel.dataverse_id
dvobject.id
Restrict delete
fk_dataversefieldtypeinputlevel_datasetfieldtype_id
dataversefieldtypeinputlevel.datasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_apitoken_authenticateduser_id
apitoken.authenticateduser_id
authenticateduser.id
Restrict delete
fk_variablecategory_datavariable_id
variablecategory.datavariable_id
datavariable.id
Restrict delete
fk_harvestingclient_dataverse_id
harvestingclient.dataverse_id
dvobject.id
Restrict delete
fk_customquestionresponse_customquestion_id
customquestionresponse.customquestion_id
customquestion.id
Restrict delete
fk_customquestionresponse_guestbookresponse_id
customquestionresponse.guestbookresponse_id
guestbookresponse.id
Restrict delete
fk_datafile_embargo_id
datafile.embargo_id
embargo.id
Restrict delete
fk_datafile_id
datafile.id
dvobject.id
Restrict delete
fk_filemetadata_datasetversion_id
filemetadata.datasetversion_id
datasetversion.id
Restrict delete
fk_filemetadata_datafile_id
filemetadata.datafile_id
dvobject.id
Restrict delete
fk_datasetexternalcitations_dataset_id
datasetexternalcitations.dataset_id
dvobject.id
Restrict delete
fk_ipv6range_owner_id
ipv6range.owner_id
persistedglobalgroup.id
Restrict delete
fk_controlledvocabalternate_datasetfieldtype_id
controlledvocabalternate.datasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_controlledvocabalternate_controlledvocabularyvalue_id
controlledvocabalternate.controlledvocabularyvalue_id
controlledvocabularyvalue.id
Restrict delete
pndngwrkflwinvocationlocaldatapndngwrkflwinvocationinvocationid
pendingworkflowinvocation_localdata.pendingworkflowinvocation_invocationid
pendingworkflowinvocation.invocationid
Restrict delete
fk_controlledvocabularyvalue_datasetfieldtype_id
controlledvocabularyvalue.datasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_dataset_id
dataset.id
dvobject.id
Restrict delete
fk_dataset_trsa_id
dataset.trsa_id
trsa.id
Restrict delete
fx_dataset_template_id
dataset.template_id
template.id
Restrict delete
fk_dataset_guestbook_id
dataset.guestbook_id
guestbook.id
Restrict delete
fk_dataset_thumbnailfile_id
dataset.thumbnailfile_id
dvobject.id
Restrict delete
fk_dataset_harvestingclient_id
dataset.harvestingclient_id
harvestingclient.id
Restrict delete
fk_dataset_template_id
dataset.template_id
template.id
Restrict delete
fk_dataset_citationdatedatasetfieldtype_id
dataset.citationdatedatasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_foreignmetadatafieldmapping_foreignmetadataformatmapping_id
foreignmetadatafieldmapping.foreignmetadataformatmapping_id
foreignmetadataformatmapping.id
Restrict delete
fk_foreignmetadatafieldmapping_parentfieldmapping_id
foreignmetadatafieldmapping.parentfieldmapping_id
foreignmetadatafieldmapping.id
Restrict delete
fk_guestbook_dataverse_id
guestbook.dataverse_id
dvobject.id
Restrict delete
fk_explicitgroup_owner_id
explicitgroup.owner_id
dvobject.id
Restrict delete
fk_clientharvestrun_harvestingclient_id
clientharvestrun.harvestingclient_id
harvestingclient.id
Restrict delete
fk_datasetlinkingdataverse_dataset_id
datasetlinkingdataverse.dataset_id
dvobject.id
Restrict delete
fk_datasetlinkingdataverse_linkingdataverse_id
datasetlinkingdataverse.linkingdataverse_id
dvobject.id
Restrict delete
fk_template_termsofuseandaccess_id
template.termsofuseandaccess_id
termsofuseandaccess.id
Restrict delete
fk_template_dataverse_id
template.dataverse_id
dvobject.id
Restrict delete
fk_dataverselinkingdataverse_dataverse_id
dataverselinkingdataverse.dataverse_id
dvobject.id
Restrict delete
fk_dataverselinkingdataverse_linkingdataverse_id
dataverselinkingdataverse.linkingdataverse_id
dvobject.id
Restrict delete
fk_auxiliaryfile_datafile_id
auxiliaryfile.datafile_id
dvobject.id
Restrict delete
fk_datasetfield_datasetfieldtype_id
datasetfield.datasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_datasetfield_template_id
datasetfield.template_id
template.id
Restrict delete
fk_datasetfield_datasetversion_id
datasetfield.datasetversion_id
datasetversion.id
Restrict delete
fk_datasetfield_parentdatasetfieldcompoundvalue_id
datasetfield.parentdatasetfieldcompoundvalue_id
datasetfieldcompoundvalue.id
Restrict delete
fk_authenticateduserlookup_authenticateduser_id
authenticateduserlookup.authenticateduser_id
authenticateduser.id
Restrict delete
fk_dataverse_metadatablock_metadatablocks_id
dataverse_metadatablock.metadatablocks_id
metadatablock.id
Restrict delete
fk_dataverse_metadatablock_dataverse_id
dataverse_metadatablock.dataverse_id
dvobject.id
Restrict delete
fk_customquestionvalue_customquestion_id
customquestionvalue.customquestion_id
customquestion.id
Restrict delete
fk_datasetlock_dataset_id
datasetlock.dataset_id
dvobject.id
Restrict delete
fk_datasetlock_user_id
datasetlock.user_id
authenticateduser.id
Restrict delete
fk_vargroup_filemetadata_id
vargroup.filemetadata_id
filemetadata.id
Restrict delete
fk_ipv4range_owner_id
ipv4range.owner_id
persistedglobalgroup.id
Restrict delete
fk_pendingworkflowinvocation_workflow_id
pendingworkflowinvocation.workflow_id
workflow.id
Restrict delete
fk_pendingworkflowinvocation_dataset_id
pendingworkflowinvocation.dataset_id
dvobject.id
Restrict delete
fk_customquestion_guestbook_id
customquestion.guestbook_id
guestbook.id
Restrict delete
fk_oauth2tokendata_user_id
oauth2tokendata.user_id
authenticateduser.id
Restrict delete
fk_datavariable_datatable_id
datavariable.datatable_id
datatable.id
Restrict delete
fk_explicitgroup_explicitgroup_containedexplicitgroups_id
explicitgroup_explicitgroup.containedexplicitgroups_id
explicitgroup.id
Restrict delete
fk_explicitgroup_explicitgroup_explicitgroup_id
explicitgroup_explicitgroup.explicitgroup_id
explicitgroup.id
Restrict delete
fk_datatable_datafile_id
datatable.datafile_id
dvobject.id
Restrict delete
fk_filedownload_guestbookresponse_id
filedownload.guestbookresponse_id
guestbookresponse.id
Restrict delete
fk_vargroup_datavariable_varsingroup_id
vargroup_datavariable.varsingroup_id
datavariable.id
Restrict delete
fk_vargroup_datavariable_vargroup_id
vargroup_datavariable.vargroup_id
vargroup.id
Restrict delete
fk_dataversefeatureddataverse_dataverse_id
dataversefeatureddataverse.dataverse_id
dvobject.id
Restrict delete
fk_dataversefeatureddataverse_featureddataverse_id
dataversefeatureddataverse.featureddataverse_id
dvobject.id
Restrict delete
fk_workflowcomment_authenticateduser_id
workflowcomment.authenticateduser_id
authenticateduser.id
Restrict delete
fk_workflowcomment_datasetversion_id
workflowcomment.datasetversion_id
datasetversion.id
Restrict delete
fk_datasetfieldtype_parentdatasetfieldtype_id
datasetfieldtype.parentdatasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_datasetfieldtype_metadatablock_id
datasetfieldtype.metadatablock_id
metadatablock.id
Restrict delete
fk_workflowstepdata_parent_id
workflowstepdata.parent_id
workflow.id
Restrict delete
fk_categorymetadata_variablemetadata_id
categorymetadata.variablemetadata_id
variablemetadata.id
Restrict delete
fk_categorymetadata_category_id
categorymetadata.category_id
variablecategory.id
Restrict delete
fk_usernotification_user_id
usernotification.user_id
authenticateduser.id
Restrict delete
fk_usernotification_requestor_id
usernotification.requestor_id
authenticateduser.id
Restrict delete
fk_savedsearch_definitionpoint_id
savedsearch.definitionpoint_id
dvobject.id
Restrict delete
fk_savedsearch_creator_id
savedsearch.creator_id
authenticateduser.id
Restrict delete
fk_harvestingdataverseconfig_dataverse_id
harvestingdataverseconfig.dataverse_id
dvobject.id
Restrict delete
fk_dataversefacet_datasetfieldtype_id
dataversefacet.datasetfieldtype_id
datasetfieldtype.id
Restrict delete
fk_dataversefacet_dataverse_id
dataversefacet.dataverse_id
dvobject.id
Restrict delete
fk_metric_dataverse_id
metric.dataverse_id
dataverse.id
Restrict delete
fk_externaltooltype_externaltool_id
externaltooltype.externaltool_id
externaltool.id
Restrict delete
fk_savedsearchfilterquery_savedsearch_id
savedsearchfilterquery.savedsearch_id
savedsearch.id
Restrict delete
fk_dvobject_creator_id
dvobject.creator_id
authenticateduser.id
Restrict delete
fk_dvobject_releaseuser_id
dvobject.releaseuser_id
authenticateduser.id
Restrict delete
fk_dvobject_owner_id
dvobject.owner_id
dvobject.id
Restrict delete
fk_guestbookresponse_datafile_id
guestbookresponse.datafile_id
dvobject.id
Restrict delete
fk_guestbookresponse_datasetversion_id
guestbookresponse.datasetversion_id
datasetversion.id
Restrict delete
fk_guestbookresponse_guestbook_id
guestbookresponse.guestbook_id
guestbook.id
Restrict delete
fk_guestbookresponse_authenticateduser_id
guestbookresponse.authenticateduser_id
authenticateduser.id
Restrict delete
fk_guestbookresponse_dataset_id
guestbookresponse.dataset_id
dvobject.id
Restrict delete
fk_variablemetadata_datavariable_id
variablemetadata.datavariable_id
datavariable.id
Restrict delete
fk_variablemetadata_filemetadata_id
variablemetadata.filemetadata_id
filemetadata.id
Restrict delete
fk_variablemetadata_weightvariable_id
variablemetadata.weightvariable_id
datavariable.id
Restrict delete
dtasetfieldcontrolledvocabularyvaluecntrolledvocabularyvaluesid
datasetfield_controlledvocabularyvalue.controlledvocabularyvalues_id
controlledvocabularyvalue.id
Restrict delete
fk_datasetfield_controlledvocabularyvalue_datasetfield_id
datasetfield_controlledvocabularyvalue.datasetfield_id
datasetfield.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
setting non_empty_lang ((lang <> ''::text))
dvobject chk_dvobject_storageidentifier ((strpos((storageidentifier)::text, '..'::text) = 0))