132 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_variablerangeitem_datavariable_id |
|
|
Restrict delete | ||
| fk_dataverse_defaulttemplate_id |
|
|
Restrict delete | ||
| fk_dataverse_id |
|
|
Restrict delete | ||
| fk_dataverse_defaultcontributorrole_id |
|
|
Restrict delete | ||
| fk_ingestreport_datafile_id |
|
|
Restrict delete | ||
| fk_datasetversion_dataset_id |
|
|
Restrict delete | ||
| fk_datasetversion_termsofuseandaccess_id |
|
|
Restrict delete | ||
| fk_metadatablock_owner_id |
|
|
Restrict delete | ||
| fk_filemetadata_datafilecategory_filemetadatas_id |
|
|
Restrict delete | ||
| fk_filemetadata_datafilecategory_filecategories_id |
|
|
Restrict delete | ||
| fk_fileaccessrequests_datafile_id |
|
|
Restrict delete | ||
| fk_fileaccessrequests_authenticated_user_id |
|
|
Restrict delete | ||
| fk_datafilecategory_dataset_id |
|
|
Restrict delete | ||
| fk_passwordresetdata_builtinuser_id |
|
|
Restrict delete | ||
| fk_workflowstepdata_stepparameters_workflowstepdata_id |
|
|
Restrict delete | ||
| fk_dataversetheme_dataverse_id |
|
|
Restrict delete | ||
| fk_roleassignment_role_id |
|
|
Restrict delete | ||
| fk_roleassignment_definitionpoint_id |
|
|
Restrict delete | ||
| fk_dataverse_citationdatasetfieldtypes_dataverse_id |
|
|
Restrict delete | ||
| dataverse_citationdatasetfieldtypes_citationdatasetfieldtype_id |
|
|
Restrict delete | ||
| explicitgroup_authenticateduser_containedauthenticatedusers_id |
|
|
Restrict delete | ||
| fk_explicitgroup_authenticateduser_explicitgroup_id |
|
|
Restrict delete | ||
| fk_bannermessagetext_bannermessage_id |
|
|
Restrict delete | ||
| fk_datasetmetrics_dataset_id |
|
|
Restrict delete | ||
| fk_dataverserole_owner_id |
|
|
Restrict delete | ||
| fk_datasetfielddefaultvalue_defaultvalueset_id |
|
|
Restrict delete | ||
| fk_datasetfielddefaultvalue_datasetfield_id |
|
|
Restrict delete | ||
| fk_datasetfielddefaultvalue_parentdatasetfielddefaultvalue_id |
|
|
Restrict delete | ||
| fk_workflowstepdata_stepsettings_workflowstepdata_id |
|
|
Restrict delete | ||
| fk_datasetversionuser_authenticateduser_id |
|
|
Restrict delete | ||
| fk_datasetversionuser_datasetversion_id |
|
|
Restrict delete | ||
| fk_confirmemaildata_authenticateduser_id |
|
|
Restrict delete | ||
| fk_userbannermessage_bannermessage_id |
|
|
Restrict delete | ||
| fk_userbannermessage_user_id |
|
|
Restrict delete | ||
| fk_dataversecontact_dataverse_id |
|
|
Restrict delete | ||
| fk_datasetfieldcompoundvalue_parentdatasetfield_id |
|
|
Restrict delete | ||
| fk_datafiletag_datafile_id |
|
|
Restrict delete | ||
| fk_dataversesubjects_dataverse_id |
|
|
Restrict delete | ||
| fk_dataversesubjects_controlledvocabularyvalue_id |
|
|
Restrict delete | ||
| fk_explicitgroup_containedroleassignees_explicitgroup_id |
|
|
Restrict delete | ||
| fk_summarystatistic_datavariable_id |
|
|
Restrict delete | ||
| fk_variablerange_datavariable_id |
|
|
Restrict delete | ||
| fk_alternativepersistentidentifier_dvobject_id |
|
|
Restrict delete | ||
| fk_ingestrequest_datafile_id |
|
|
Restrict delete | ||
| fk_datasetfieldvalue_datasetfield_id |
|
|
Restrict delete | ||
| fk_dataversefieldtypeinputlevel_dataverse_id |
|
|
Restrict delete | ||
| fk_dataversefieldtypeinputlevel_datasetfieldtype_id |
|
|
Restrict delete | ||
| fk_apitoken_authenticateduser_id |
|
|
Restrict delete | ||
| fk_variablecategory_datavariable_id |
|
|
Restrict delete | ||
| fk_harvestingclient_dataverse_id |
|
|
Restrict delete | ||
| fk_customquestionresponse_customquestion_id |
|
|
Restrict delete | ||
| fk_customquestionresponse_guestbookresponse_id |
|
|
Restrict delete | ||
| fk_datafile_id |
|
|
Restrict delete | ||
| fk_filemetadata_datasetversion_id |
|
|
Restrict delete | ||
| fk_filemetadata_datafile_id |
|
|
Restrict delete | ||
| fk_datasetexternalcitations_dataset_id |
|
|
Restrict delete | ||
| fk_ipv6range_owner_id |
|
|
Restrict delete | ||
| fk_controlledvocabalternate_datasetfieldtype_id |
|
|
Restrict delete | ||
| fk_controlledvocabalternate_controlledvocabularyvalue_id |
|
|
Restrict delete | ||
| pndngwrkflwinvocationlocaldatapndngwrkflwinvocationinvocationid |
|
|
Restrict delete | ||
| fk_controlledvocabularyvalue_datasetfieldtype_id |
|
|
Restrict delete | ||
| fk_dataset_id |
|
|
Restrict delete | ||
| fk_dataset_guestbook_id |
|
|
Restrict delete | ||
| fk_dataset_thumbnailfile_id |
|
|
Restrict delete | ||
| fk_dataset_harvestingclient_id |
|
|
Restrict delete | ||
| fk_dataset_citationdatedatasetfieldtype_id |
|
|
Restrict delete | ||
| fk_foreignmetadatafieldmapping_foreignmetadataformatmapping_id |
|
|
Restrict delete | ||
| fk_foreignmetadatafieldmapping_parentfieldmapping_id |
|
|
Restrict delete | ||
| fk_guestbook_dataverse_id |
|
|
Restrict delete | ||
| fk_explicitgroup_owner_id |
|
|
Restrict delete | ||
| fk_clientharvestrun_harvestingclient_id |
|
|
Restrict delete | ||
| fk_datasetlinkingdataverse_dataset_id |
|
|
Restrict delete | ||
| fk_datasetlinkingdataverse_linkingdataverse_id |
|
|
Restrict delete | ||
| fk_template_termsofuseandaccess_id |
|
|
Restrict delete | ||
| fk_template_dataverse_id |
|
|
Restrict delete | ||
| fk_dataverselinkingdataverse_dataverse_id |
|
|
Restrict delete | ||
| fk_dataverselinkingdataverse_linkingdataverse_id |
|
|
Restrict delete | ||
| fk_auxiliaryfile_datafile_id |
|
|
Restrict delete | ||
| fk_datasetfield_datasetfieldtype_id |
|
|
Restrict delete | ||
| fk_datasetfield_template_id |
|
|
Restrict delete | ||
| fk_datasetfield_datasetversion_id |
|
|
Restrict delete | ||
| fk_datasetfield_parentdatasetfieldcompoundvalue_id |
|
|
Restrict delete | ||
| fk_authenticateduserlookup_authenticateduser_id |
|
|
Restrict delete | ||
| fk_dataverse_metadatablock_metadatablocks_id |
|
|
Restrict delete | ||
| fk_dataverse_metadatablock_dataverse_id |
|
|
Restrict delete | ||
| fk_customquestionvalue_customquestion_id |
|
|
Restrict delete | ||
| fk_datasetlock_dataset_id |
|
|
Restrict delete | ||
| fk_datasetlock_user_id |
|
|
Restrict delete | ||
| fk_vargroup_filemetadata_id |
|
|
Restrict delete | ||
| fk_ipv4range_owner_id |
|
|
Restrict delete | ||
| fk_pendingworkflowinvocation_workflow_id |
|
|
Restrict delete | ||
| fk_pendingworkflowinvocation_dataset_id |
|
|
Restrict delete | ||
| fk_customquestion_guestbook_id |
|
|
Restrict delete | ||
| fk_oauth2tokendata_user_id |
|
|
Restrict delete | ||
| fk_datavariable_datatable_id |
|
|
Restrict delete | ||
| fk_explicitgroup_explicitgroup_containedexplicitgroups_id |
|
|
Restrict delete | ||
| fk_explicitgroup_explicitgroup_explicitgroup_id |
|
|
Restrict delete | ||
| fk_datatable_datafile_id |
|
|
Restrict delete | ||
| fk_filedownload_guestbookresponse_id |
|
|
Restrict delete | ||
| fk_vargroup_datavariable_varsingroup_id |
|
|
Restrict delete | ||
| fk_vargroup_datavariable_vargroup_id |
|
|
Restrict delete | ||
| fk_dataversefeatureddataverse_dataverse_id |
|
|
Restrict delete | ||
| fk_dataversefeatureddataverse_featureddataverse_id |
|
|
Restrict delete | ||
| fk_workflowcomment_authenticateduser_id |
|
|
Restrict delete | ||
| fk_workflowcomment_datasetversion_id |
|
|
Restrict delete | ||
| fk_datasetfieldtype_parentdatasetfieldtype_id |
|
|
Restrict delete | ||
| fk_datasetfieldtype_metadatablock_id |
|
|
Restrict delete | ||
| fk_workflowstepdata_parent_id |
|
|
Restrict delete | ||
| fk_categorymetadata_variablemetadata_id |
|
|
Restrict delete | ||
| fk_categorymetadata_category_id |
|
|
Restrict delete | ||
| fk_usernotification_user_id |
|
|
Restrict delete | ||
| fk_usernotification_requestor_id |
|
|
Restrict delete | ||
| fk_savedsearch_definitionpoint_id |
|
|
Restrict delete | ||
| fk_savedsearch_creator_id |
|
|
Restrict delete | ||
| fk_harvestingdataverseconfig_dataverse_id |
|
|
Restrict delete | ||
| fk_dataversefacet_datasetfieldtype_id |
|
|
Restrict delete | ||
| fk_dataversefacet_dataverse_id |
|
|
Restrict delete | ||
| fk_externaltooltype_externaltool_id |
|
|
Restrict delete | ||
| fk_savedsearchfilterquery_savedsearch_id |
|
|
Restrict delete | ||
| fk_dvobject_creator_id |
|
|
Restrict delete | ||
| fk_dvobject_releaseuser_id |
|
|
Restrict delete | ||
| fk_dvobject_owner_id |
|
|
Restrict delete | ||
| fk_guestbookresponse_datafile_id |
|
|
Restrict delete | ||
| fk_guestbookresponse_datasetversion_id |
|
|
Restrict delete | ||
| fk_guestbookresponse_guestbook_id |
|
|
Restrict delete | ||
| fk_guestbookresponse_authenticateduser_id |
|
|
Restrict delete | ||
| fk_guestbookresponse_dataset_id |
|
|
Restrict delete | ||
| fk_variablemetadata_datavariable_id |
|
|
Restrict delete | ||
| fk_variablemetadata_filemetadata_id |
|
|
Restrict delete | ||
| fk_variablemetadata_weightvariable_id |
|
|
Restrict delete | ||
| dtasetfieldcontrolledvocabularyvaluecntrolledvocabularyvaluesid |
|
|
Restrict delete | ||
| fk_datasetfield_controlledvocabularyvalue_datasetfield_id |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| setting | non_empty_lang | ((lang <> ''::text)) |