167 Foreign Key Constraints:

Constraint Name	Child Column	Parent Column	Delete Rule
fk_coll_adv_search_fields_study_field_id	coll_adv_search_fields.study_field_id	studyfield.id	Restrict delete
fk_coll_adv_search_fields_vdc_collection_id	coll_adv_search_fields.vdc_collection_id	vdccollection.id	Restrict delete
fk_coll_any_search_fields_study_field_id	coll_any_search_fields.study_field_id	studyfield.id	Restrict delete
fk_coll_any_search_fields_vdc_collection_id	coll_any_search_fields.vdc_collection_id	vdccollection.id	Restrict delete
fk_coll_search_result_fields_study_field_id	coll_search_result_fields.study_field_id	studyfield.id	Restrict delete
fk_coll_search_result_fields_vdc_collection_id	coll_search_result_fields.vdc_collection_id	vdccollection.id	Restrict delete
fk_coll_studies_study_id	coll_studies.study_id	study.id	Restrict delete
fk_coll_studies_vdc_collection_id	coll_studies.vdc_collection_id	vdccollection.id	Restrict delete
fk_contactsubject_vdc_id	contactsubject.vdc_id	vdc.id	Restrict delete
fk_controlledvocabularyvalue_controlledvocabulary_id	controlledvocabularyvalue.controlledvocabulary_id	controlledvocabulary.id	Restrict delete
fk_customquestion_guestbookquestionnaire_id	customquestion.guestbookquestionnaire_id	guestbookquestionnaire.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_customquestionvalue_customquestion_id	customquestionvalue.customquestion_id	customquestion.id	Restrict delete
fk_datatable_studyfile_id	datatable.studyfile_id	studyfile.id	Restrict delete
fk_datavariable_datatable_id	datavariable.datatable_id	datatable.id	Restrict delete
fk_datavariable_variableformattype_id	datavariable.variableformattype_id	variableformattype.id	Restrict delete
fk_datavariable_variableintervaltype_id	datavariable.variableintervaltype_id	variableintervaltype.id	Restrict delete
fk_datavariablemapping_datatable_id	datavariablemapping.datatable_id	datatable.id	Restrict delete
fk_datavariablemapping_datavariable_id	datavariablemapping.datavariable_id	datavariable.id	Restrict delete
fk_datavariablemapping_vargroup_id	datavariablemapping.vargroup_id	vargroup.id	Restrict delete
fk_datavariablemapping_vargrouping_id	datavariablemapping.vargrouping_id	vargrouping.id	Restrict delete
fk_filemetadata_studyfile_id	filemetadata.studyfile_id	studyfile.id	Restrict delete
fk_filemetadata_studyversion_id	filemetadata.studyversion_id	studyversion.id	Restrict delete
fk_filemetadatafieldvalue_filemetadatafield_id	filemetadatafieldvalue.filemetadatafield_id	filemetadatafield.id	Restrict delete
fk_filemetadatafieldvalue_studyfile_id	filemetadatafieldvalue.studyfile_id	studyfile.id	Restrict delete
fk_flagged_study_comments_study_comment_id	flagged_study_comments.study_comment_id	studycomment.id	Restrict delete
fk_flagged_study_comments_user_id	flagged_study_comments.user_id	vdcuser.id	Restrict delete
fk_group_grouptypes_group_id	group_grouptypes.group_id	vargroup.id	Restrict delete
fk_group_grouptypes_group_type_id	group_grouptypes.group_type_id	vargrouptype.id	Restrict delete
fk_guestbookquestionnaire_vdc_id	guestbookquestionnaire.vdc_id	vdc.id	Restrict delete
fk_guestbookresponse_guestbookquestionnaire_id	guestbookresponse.guestbookquestionnaire_id	guestbookquestionnaire.id	Restrict delete
fk_guestbookresponse_study_id	guestbookresponse.study_id	study.id	Restrict delete
fk_guestbookresponse_studyfile_id	guestbookresponse.studyfile_id	studyfile.id	Restrict delete
fk_guestbookresponse_studyversion_id	guestbookresponse.studyversion_id	studyversion.id	Restrict delete
fk_guestbookresponse_vdcuser_id	guestbookresponse.vdcuser_id	vdcuser.id	Restrict delete
fk_harvestingdataverse_handleprefix_id	harvestingdataverse.handleprefix_id	handleprefix.id	Restrict delete
fk_harvestingdataverse_harvestformattype_id	harvestingdataverse.harvestformattype_id	harvestformattype.id	Restrict delete
fk_linked_network_studies_study_id	linked_network_studies.study_id	study.id	Restrict delete
fk_linked_network_studies_vdcnetwork_id	linked_network_studies.vdcnetwork_id	vdcnetwork.id	Restrict delete
fk_lockssconfig_licensetype_id	lockssconfig.licensetype_id	licensetype.id	Restrict delete
fk_lockssconfig_vdc_id	lockssconfig.vdc_id	vdc.id	Restrict delete
fk_lockssserver_lockssconfig_id	lockssserver.lockssconfig_id	lockssconfig.id	Restrict delete
fk_loginaffiliate_usergroup_id	loginaffiliate.usergroup_id	usergroup.id	Restrict delete
fk_logindomain_usergroup_id	logindomain.usergroup_id	usergroup.id	Restrict delete
fk_networkcontactsubject_vdcnetwork_id	networkcontactsubject.vdcnetwork_id	vdcnetwork.id	Restrict delete
fk_networkrolerequest_networkrole_id	networkrolerequest.networkrole_id	networkrole.id	Restrict delete
fk_networkrolerequest_vdcuser_id	networkrolerequest.vdcuser_id	vdcuser.id	Restrict delete
fk_oaiset_lockssconfig_id	oaiset.lockssconfig_id	lockssconfig.id	Restrict delete
fk_pagedef_networkrole_id	pagedef.networkrole_id	networkrole.id	Restrict delete
fk_pagedef_role_id	pagedef.role_id	role.id	Restrict delete
fk_rolerequest_role_id	rolerequest.role_id	role.id	Restrict delete
fk_rolerequest_vdc_id	rolerequest.vdc_id	vdc.id	Restrict delete
fk_rolerequest_vdcuser_id	rolerequest.vdcuser_id	vdcuser.id	Restrict delete
fk_search_result_fields_study_field_id	search_result_fields.study_field_id	studyfield.id	Restrict delete
fk_search_result_fields_vdc_id	search_result_fields.vdc_id	vdc.id	Restrict delete
fk_study_creator_id	study.creator_id	vdcuser.id	Restrict delete
fk_study_lastupdater_id	study.lastupdater_id	vdcuser.id	Restrict delete
fk_study_owner_id	study.owner_id	vdc.id	Restrict delete
fk_study_reviewer_id	study.reviewer_id	vdcuser.id	Restrict delete
fk_study_studyfield_studies_id	study_studyfield.studies_id	study.id	Restrict delete
fk_study_studyfield_summaryfields_id	study_studyfield.summaryfields_id	studyfield.id	Restrict delete
fk_study_template_id	study.template_id	template.id	Restrict delete
fk_study_usergroup_allowedgroups_id	study_usergroup.allowedgroups_id	usergroup.id	Restrict delete
fk_study_usergroup_studies_id	study_usergroup.studies_id	study.id	Restrict delete
fk_study_vdcuser_allowedusers_id	study_vdcuser.allowedusers_id	vdcuser.id	Restrict delete
fk_study_vdcuser_studies_id	study_vdcuser.studies_id	study.id	Restrict delete
fk_studyabstract_metadata_id	studyabstract.metadata_id	metadata.id	Restrict delete
fk_studyaccessrequest_study_id	studyaccessrequest.study_id	study.id	Restrict delete
fk_studyaccessrequest_studyfile_id	studyaccessrequest.studyfile_id	studyfile.id	Restrict delete
fk_studyaccessrequest_vdcuser_id	studyaccessrequest.vdcuser_id	vdcuser.id	Restrict delete
fk_studyauthor_metadata_id	studyauthor.metadata_id	metadata.id	Restrict delete
fk_studycomment_commentcreator_id	studycomment.commentcreator_id	vdcuser.id	Restrict delete
fk_studycomment_studyversion_id	studycomment.studyversion_id	studyversion.id	Restrict delete
fk_studydistributor_metadata_id	studydistributor.metadata_id	metadata.id	Restrict delete
fk_studydownload_study_id	studydownload.study_id	study.id	Restrict delete
fk_studyfield_parentstudyfield_id	studyfield.parentstudyfield_id	studyfield.id	Restrict delete
fk_studyfieldvalue_metadata_id	studyfieldvalue.metadata_id	metadata.id	Restrict delete
fk_studyfieldvalue_studyfield_id	studyfieldvalue.studyfield_id	studyfield.id	Restrict delete
fk_studyfile_study_id	studyfile.study_id	study.id	Restrict delete
fk_studyfile_usergroup_allowedgroups_id	studyfile_usergroup.allowedgroups_id	usergroup.id	Restrict delete
fk_studyfile_usergroup_studyfiles_id	studyfile_usergroup.studyfiles_id	studyfile.id	Restrict delete
fk_studyfile_vdcuser_allowedusers_id	studyfile_vdcuser.allowedusers_id	vdcuser.id	Restrict delete
fk_studyfile_vdcuser_studyfiles_id	studyfile_vdcuser.studyfiles_id	studyfile.id	Restrict delete
fk_studyfileactivity_study_id	studyfileactivity.study_id	study.id	Restrict delete
fk_studyfileactivity_studyfile_id	studyfileactivity.studyfile_id	studyfile.id	Restrict delete
fk_studygeobounding_metadata_id	studygeobounding.metadata_id	metadata.id	Restrict delete
fk_studygrant_metadata_id	studygrant.metadata_id	metadata.id	Restrict delete
fk_studykeyword_metadata_id	studykeyword.metadata_id	metadata.id	Restrict delete
fk_studylock_study_id	studylock.study_id	study.id	Restrict delete
fk_studylock_user_id	studylock.user_id	vdcuser.id	Restrict delete
fk_studynote_metadata_id	studynote.metadata_id	metadata.id	Restrict delete
fk_studyotherid_metadata_id	studyotherid.metadata_id	metadata.id	Restrict delete
fk_studyotherref_metadata_id	studyotherref.metadata_id	metadata.id	Restrict delete
fk_studyproducer_metadata_id	studyproducer.metadata_id	metadata.id	Restrict delete
fk_studyrelmaterial_metadata_id	studyrelmaterial.metadata_id	metadata.id	Restrict delete
fk_studyrelpublication_metadata_id	studyrelpublication.metadata_id	metadata.id	Restrict delete
fk_studyrelstudy_metadata_id	studyrelstudy.metadata_id	metadata.id	Restrict delete
fk_studyrequest_study_id	studyrequest.study_id	study.id	Restrict delete
fk_studyrequest_vdcuser_id	studyrequest.vdcuser_id	vdcuser.id	Restrict delete
fk_studysoftware_metadata_id	studysoftware.metadata_id	metadata.id	Restrict delete
fk_studytopicclass_metadata_id	studytopicclass.metadata_id	metadata.id	Restrict delete
fk_studyversion_metadata_id	studyversion.metadata_id	metadata.id	Restrict delete
fk_studyversion_study_id	studyversion.study_id	study.id	Restrict delete
fk_summary_fields_study_field_id	summary_fields.study_field_id	studyfield.id	Restrict delete
fk_summary_fields_vdc_id	summary_fields.vdc_id	vdc.id	Restrict delete
fk_summarystatistic_datavariable_id	summarystatistic.datavariable_id	datavariable.id	Restrict delete
fk_summarystatistic_type_id	summarystatistic.type_id	summarystatistictype.id	Restrict delete
fk_template_metadata_id	template.metadata_id	metadata.id	Restrict delete
fk_template_vdc_id	template.vdc_id	vdc.id	Restrict delete
fk_template_vdcnetwork_id	template.vdcnetwork_id	vdcnetwork.id	Restrict delete
fk_templatefield_controlledvocabulary_id	templatefield.controlledvocabulary_id	controlledvocabulary.id	Restrict delete
fk_templatefield_studyfield_id	templatefield.studyfield_id	studyfield.id	Restrict delete
fk_templatefield_template_id	templatefield.template_id	template.id	Restrict delete
fk_templatefilecategory_template_id	templatefilecategory.template_id	template.id	Restrict delete
fk_termsofuse_vdc_id	termsofuse.vdc_id	vdc.id	Restrict delete
fk_twittercredentials_vdc_id	twittercredentials.vdc_id	vdc.id	Restrict delete
fk_vargroup_vargrouping_id	vargroup.vargrouping_id	vargrouping.id	Restrict delete
fk_vargrouping_datatable_id	vargrouping.datatable_id	datatable.id	Restrict delete
fk_vargrouptype_vargrouping_id	vargrouptype.vargrouping_id	vargrouping.id	Restrict delete
fk_variablecategory_datavariable_id	variablecategory.datavariable_id	datavariable.id	Restrict delete
fk_variablerange_beginvaluetype_id	variablerange.beginvaluetype_id	variablerangetype.id	Restrict delete
fk_variablerange_datavariable_id	variablerange.datavariable_id	datavariable.id	Restrict delete
fk_variablerange_endvaluetype_id	variablerange.endvaluetype_id	variablerangetype.id	Restrict delete
fk_variablerangeitem_datavariable_id	variablerangeitem.datavariable_id	datavariable.id	Restrict delete
fk_vdc_adv_search_fields_study_field_id	vdc_adv_search_fields.study_field_id	studyfield.id	Restrict delete
fk_vdc_adv_search_fields_vdc_id	vdc_adv_search_fields.vdc_id	vdc.id	Restrict delete
fk_vdc_any_search_fields_study_field_id	vdc_any_search_fields.study_field_id	studyfield.id	Restrict delete
fk_vdc_any_search_fields_vdc_id	vdc_any_search_fields.vdc_id	vdc.id	Restrict delete
fk_vdc_creator_id	vdc.creator_id	vdcuser.id	Restrict delete
fk_vdc_defaulttemplate_id	vdc.defaulttemplate_id	template.id	Restrict delete
fk_vdc_fileuser_allowedfileusers_id	vdc_fileuser.allowedfileusers_id	vdcuser.id	Restrict delete
fk_vdc_fileuser_vdc_id	vdc_fileuser.vdc_id	vdc.id	Restrict delete
fk_vdc_fileusergroup_allowedfilegroups_id	vdc_fileusergroup.allowedfilegroups_id	usergroup.id	Restrict delete
fk_vdc_fileusergroup_vdc_id	vdc_fileusergroup.vdc_id	vdc.id	Restrict delete
fk_vdc_harvestingdataverse_id	vdc.harvestingdataverse_id	harvestingdataverse.id	Restrict delete
fk_vdc_linked_collections_linked_collection_id	vdc_linked_collections.linked_collection_id	vdccollection.id	Restrict delete
fk_vdc_linked_collections_vdc_id	vdc_linked_collections.vdc_id	vdc.id	Restrict delete
fk_vdc_reviewer_id	vdc.reviewer_id	vdcuser.id	Restrict delete
fk_vdc_rootcollection_id	vdc.rootcollection_id	vdccollection.id	Restrict delete
fk_vdc_usergroup_allowedgroups_id	vdc_usergroup.allowedgroups_id	usergroup.id	Restrict delete
fk_vdc_usergroup_vdcs_id	vdc_usergroup.vdcs_id	vdc.id	Restrict delete
fk_vdc_vdcnetwork_id	vdc.vdcnetwork_id	vdcnetwork.id	Restrict delete
fk_vdcactivity_vdc_id	vdcactivity.vdc_id	vdc.id	Restrict delete
fk_vdccollection_owner_id	vdccollection.owner_id	vdc.id	Restrict delete
fk_vdccollection_parentcollection_id	vdccollection.parentcollection_id	vdccollection.id	Restrict delete
fk_vdcgroup_vdcs_vdc_id	vdcgroup_vdcs.vdc_id	vdc.id	Restrict delete
fk_vdcgroup_vdcs_vdcgroup_id	vdcgroup_vdcs.vdcgroup_id	vdcgroup.id	Restrict delete
fk_vdcgrouprelationship_group_id	vdcgrouprelationship.group_id	vdcgroup.id	Restrict delete
fk_vdcgrouprelationship_subgroup_id	vdcgrouprelationship.subgroup_id	vdcgroup.id	Restrict delete
fk_vdcnetwork_creator_id	vdcnetwork.creator_id	vdcuser.id	Restrict delete
fk_vdcnetwork_defaultnetworkadmin_id	vdcnetwork.defaultnetworkadmin_id	vdcuser.id	Restrict delete
fk_vdcnetwork_defaulttemplate_id	vdcnetwork.defaulttemplate_id	template.id	Restrict delete
fk_vdcnetworkstats_vdcnetwork_id	vdcnetworkstats.vdcnetwork_id	vdcnetwork.id	Restrict delete
fk_vdcrole_role_id	vdcrole.role_id	role.id	Restrict delete
fk_vdcrole_vdc_id	vdcrole.vdc_id	vdc.id	Restrict delete
fk_vdcrole_vdcuser_id	vdcrole.vdcuser_id	vdcuser.id	Restrict delete
fk_vdcuser_networkrole_id	vdcuser.networkrole_id	networkrole.id	Restrict delete
fk_vdcuser_studycomment_flaggedstudycomments_id	vdcuser_studycomment.flaggedstudycomments_id	studycomment.id	Restrict delete
fk_vdcuser_studycomment_vdcuser_id	vdcuser_studycomment.vdcuser_id	vdcuser.id	Restrict delete
fk_vdcuser_usergroup_usergroups_id	vdcuser_usergroup.usergroups_id	usergroup.id	Restrict delete
fk_vdcuser_usergroup_users_id	vdcuser_usergroup.users_id	vdcuser.id	Restrict delete
fk_versioncontributor_contributor_id	versioncontributor.contributor_id	vdcuser.id	Restrict delete
fk_versioncontributor_studyversion_id	versioncontributor.studyversion_id	studyversion.id	Restrict delete
fk_visualizationdisplay_datatable_id	visualizationdisplay.datatable_id	datatable.id	Restrict delete
fk_weightedvarrelationship_variable_id	weightedvarrelationship.variable_id	datavariable.id	Restrict delete
fk_weightedvarrelationship_weighted_variable_id	weightedvarrelationship.weighted_variable_id	datavariable.id	Restrict delete

Check Constraints:

Table	Constraint Name	Constraint
None detected