| additional_candidate__additional_id_fk |
additional_candidate.additional_id |
additional.additional_id |
Cascade on delete |
| additional_candidate__candidate_id_fk |
additional_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| additional_candidate_category_additional_candidate_id_fkey |
additional_candidate_category.additional_candidate_id |
additional_candidate.additional_candidate_id |
Cascade on delete |
| additional_candidate_category_category_id_fkey |
additional_candidate_category.category_id |
category.category_id |
Cascade on delete |
| additional_candidate_tag_additional_candidate_id_fkey |
additional_candidate_tag.additional_candidate_id |
additional_candidate.additional_candidate_id |
Cascade on delete |
| additional_candidate_tag_tag_id_fkey |
additional_candidate_tag.tag_id |
tag.tag_id |
Cascade on delete |
| additional_category_additional_id_fkey |
additional_category.additional_id |
additional.additional_id |
Cascade on delete |
| additional_category_category_id_fkey |
additional_category.category_id |
category.category_id |
Cascade on delete |
| additional_tag_additional_id_fkey |
additional_tag.additional_id |
additional.additional_id |
Cascade on delete |
| additional_tag_tag_id_fkey |
additional_tag.tag_id |
tag.tag_id |
Cascade on delete |
| auth_content_type_id_120912b3d709d1c8_fk_django_content_type_id |
auth_permission.content_type_id |
django_content_type.id |
Restrict delete |
| auth_group_permissio_group_id_13c4fb9ea0863629_fk_auth_group_id |
auth_group_permissions.group_id |
auth_group.id |
Restrict delete |
| auth_group_permission_id_24c00a3f86539eb0_fk_auth_permission_id |
auth_group_permissions.permission_id |
auth_permission.id |
Restrict delete |
| auth_user__permission_id_1995b8f6badfd4d0_fk_auth_permission_id |
auth_user_user_permissions.permission_id |
auth_permission.id |
Restrict delete |
| auth_user_groups_group_id_6d67c6c0caf10508_fk_auth_group_id |
auth_user_groups.group_id |
auth_group.id |
Restrict delete |
| auth_user_groups_user_id_5f10f6f3700250e5_fk_auth_user_id |
auth_user_groups.user_id |
auth_user.id |
Restrict delete |
| auth_user_user_permiss_user_id_368e4da9c3fd2182_fk_auth_user_id |
auth_user_user_permissions.user_id |
auth_user.id |
Restrict delete |
| biotext_category_biotext_id_fkey |
biotext_category.biotext_id |
biotext.biotext_id |
Cascade on delete |
| biotext_category_category_id_fkey |
biotext_category.category_id |
category.category_id |
Restrict delete |
| biotext_tag_biotext_id_fkey |
biotext_tag.biotext_id |
biotext.biotext_id |
Cascade on delete |
| biotext_tag_tag_id_fkey |
biotext_tag.tag_id |
tag.tag_id |
Cascade on delete |
| candidate__candidatepreferredname_id_fk |
candidate.candidatepreferredname_id |
candidatepreferredname.candidatepreferredname_id |
Restrict delete |
| candidate__candidatestatus_id_fk |
candidate.candidatestatus_id |
candidatestatus.candidatestatus_id |
Restrict delete |
| candidate__candidatetitle_id_fk |
candidate.candidatetitle_id |
candidatetitle.candidatetitle_id |
Restrict delete |
| candidate__release_id_fk |
candidate.release_id |
release.release_id |
Restrict delete |
| candidate__state_id_fk |
candidate.state_id |
state.state_id |
Restrict delete |
| candidate_election_candidate__candidate_id_fk |
candidate_election_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| candidate_election_candidate__election_candidate_id_fk |
candidate_election_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| catcode_category_category_id_fkey1 |
catcode_category.category_id |
category.category_id |
Cascade on delete |
| catcode_category_finance_catcode_id_fkey1 |
catcode_category.finance_catcode_id |
finance_catcode.finance_catcode_id |
Cascade on delete |
| category__release_id_fk |
category.release_id |
release.release_id |
Restrict delete |
| category_section__category_id_fk |
category_section.category_id |
category.category_id |
Cascade on delete |
| category_section__section_id_fk |
category_section.section_id |
section.section_id |
Cascade on delete |
| category_tag__category_fk |
category_tag.category_id |
category.category_id |
Cascade on delete |
| category_tag__tag_fk |
category_tag.tag_id |
tag.tag_id |
Cascade on delete |
| committee__committeetype_id_fk |
committee.committeetype_id |
committeetype.committeetype_id |
Restrict delete |
| committee__state_id_fk |
committee.state_id |
state.state_id |
Restrict delete |
| committee_candidate__committee_id_fk |
committee_candidate.committee_id |
committee.committee_id |
Cascade on delete |
| committee_candidate__committeeposition_id_fk |
committee_candidate.committeeposition_id |
committeeposition.committeeposition_id |
Cascade on delete |
| committee_candidate__office_candidate_id_fk |
committee_candidate.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| committee_category__category_id_fk |
committee_category.category_id |
category.category_id |
Cascade on delete |
| committee_category__committee_id_fk |
committee_category.committee_id |
committee.committee_id |
Cascade on delete |
| committee_tag_committee_id_fkey |
committee_tag.committee_id |
committee.committee_id |
Cascade on delete |
| committee_tag_tag_id_fkey |
committee_tag.tag_id |
tag.tag_id |
Cascade on delete |
| congaction__congactiontype_id_fk |
congaction.congactiontype_id |
congactiontype.congactiontype_id |
Restrict delete |
| congcategory_category__category_id |
congcategory_category.category_id |
category.category_id |
Cascade on delete |
| congcategory_category__congcategory_id |
congcategory_category.congcategory_id |
congcategory.congcategory_id |
Cascade on delete |
| congcategory_tag_congcategory_id_fkey |
congcategory_tag.congcategory_id |
congcategory.congcategory_id |
Cascade on delete |
| congcategory_tag_tag_id_fkey |
congcategory_tag.tag_id |
tag.tag_id |
Cascade on delete |
| congdoc__congdocgroup_id_fk |
congdoc.congdocgroup_id |
congdocgroup.congdocgroup_id |
Cascade on delete |
| congnote_congress__congnote_id_fk |
congnote_congress.congnote_id |
congnote.congnote_id |
Cascade on delete |
| congnote_congress__congress_id_fk |
congnote_congress.congress_id |
congress.congress_id |
Cascade on delete |
| congnote_stage__congnote_id_fk |
congnote_stage.congnote_id |
congnote.congnote_id |
Cascade on delete |
| congnote_stage__congstage_id_fk |
congnote_stage.congstage_id |
congstage.congstage_id |
Cascade on delete |
| congnote_state__congnote_id_fk |
congnote_state.congnote_id |
congnote.congnote_id |
Cascade on delete |
| congnote_state__state_id_fk |
congnote_state.state_id |
state.state_id |
Restrict delete |
| congnote_status__congnote_id_fk |
congnote_status.congnote_id |
congnote.congnote_id |
Cascade on delete |
| congnote_status__congstatus_id_fk |
congnote_status.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| congnote_type__congnote_id_fk |
congnote_type.congnote_id |
congnote.congnote_id |
Cascade on delete |
| congnote_type__congtype_id_fk |
congnote_type.congtype_id |
congtype.congtype_id |
Restrict delete |
| congprefix_state__congprefix_id_fk |
congprefix_state.congprefix_id |
congprefix.congprefix_id |
Cascade on delete |
| congprefix_state__state_id_fk |
congprefix_state.state_id |
state.state_id |
Restrict delete |
| congress__congtype_id_fk |
congress.congtype_id |
congtype.congtype_id |
Null on delete |
| congress__state_id_fk |
congress.state_id |
state.state_id |
Restrict delete |
| congstatus__congcategory_id_fk |
congstatus.congcategory_id |
congcategory.congcategory_id |
Null on delete |
| congstatus__congdocgroup_id_fk |
congstatus.congdocgroup_id |
congdocgroup.congdocgroup_id |
Null on delete |
| congstatus__conghighlight_id_fk |
congstatus.conghighlight_id |
conghighlight.conghighlight_id |
Null on delete |
| congstatus__conglevel_id_fk |
congstatus.conglevel_id |
conglevel.conglevel_id |
Restrict delete |
| congstatus__congofficialsynopsis_id_fk |
congstatus.congofficialsynopsis_id |
congofficialsynopsis.congofficialsynopsis_id |
Null on delete |
| congstatus__congofficialtitle_id_fk |
congstatus.congofficialtitle_id |
congofficialtitle.congofficialtitle_id |
Null on delete |
| congstatus__congoutcome_id_fk |
congstatus.congoutcome_id |
congoutcome.congoutcome_id |
Cascade on delete |
| congstatus__congress_id_fk |
congstatus.congress_id |
congress.congress_id |
Cascade on delete |
| congstatus__congstage_id_fk |
congstatus.congstage_id |
congstage.congstage_id |
Cascade on delete |
| congstatus__congsynopsis_id_fk |
congstatus.congsynopsis_id |
congsynopsis.congsynopsis_id |
Null on delete |
| congstatus__congtext_id_fk |
congstatus.congtext_id |
congtext.congtext_id |
Null on delete |
| congstatus__congtitle_id_fk |
congstatus.congtitle_id |
congtitle.congtitle_id |
Null on delete |
| congstatus_candidate__congaction_id_fk |
congstatus_candidate.congaction_id |
congaction.congaction_id |
Restrict delete |
| congstatus_candidate__congstatus_id_fk |
congstatus_candidate.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| congstatus_candidate__office_candidate_id_fk |
congstatus_candidate.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| congstatus_committee__committee_id |
congstatus_committee.committee_id |
committee.committee_id |
Cascade on delete |
| congstatus_committee__congaction_id_fk |
congstatus_committee.congaction_id |
congaction.congaction_id |
Restrict delete |
| congstatus_committee__congstatus_id |
congstatus_committee.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| congstatus_tag__congstatus_fk |
congstatus_tag.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| congstatus_tag__tag_fk |
congstatus_tag.tag_id |
tag.tag_id |
Cascade on delete |
| congstatus_vetotext__congstatus_id_fk |
congstatus_vetotext.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| congstatus_vetotext__congvetotext_id_fk |
congstatus_vetotext.congvetotext_id |
congvetotext.congvetotext_id |
Cascade on delete |
| congtools__conglevel_id_fk |
congtools.conglevel_id |
conglevel.conglevel_id |
Restrict delete |
| congtools__congoutcome_id_fk |
congtools.congoutcome_id |
congoutcome.congoutcome_id |
Restrict delete |
| congtools__congoutcometext_id_fk |
congtools.congoutcometext_id |
congoutcometext.congoutcometext_id |
Restrict delete |
| congtools__congstage_id_fk |
congtools.congstage_id |
congstage.congstage_id |
Restrict delete |
| congtools__congtype_id_fk |
congtools.congtype_id |
congtype.congtype_id |
Restrict delete |
| contact_candidate__candidate_id_fk |
contact_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| contact_candidate__contactmode_id_fk |
contact_candidate.contactmode_id |
contactmode.contactmode_id |
Cascade on delete |
| contact_candidate__contactoutcome_id_fk |
contact_candidate.contactoutcome_id |
contactoutcome.contactoutcome_id |
Cascade on delete |
| contact_candidate__contacttype_id_fk |
contact_candidate.contacttype_id |
contacttype.contacttype_id |
Cascade on delete |
| contact_candidate__election_candidate_id_fk |
contact_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| district__districtname_id_fk |
district.districtname_id |
districtname.districtname_id |
Restrict delete |
| district__office_id_fk |
district.office_id |
office.office_id |
Restrict delete |
| district__state_id_fk |
district.state_id |
state.state_id |
Restrict delete |
| djan_content_type_id_309afb94cacbcd48_fk_django_content_type_id |
django_admin_log.content_type_id |
django_content_type.id |
Restrict delete |
| django_admin_log_user_id_3b7cdee1951d4a29_fk_auth_user_id |
django_admin_log.user_id |
auth_user.id |
Restrict delete |
| education_candidate_id_fkey |
education.candidate_id |
candidate.candidate_id |
Cascade on delete |
| education_category_category_id_fkey |
education_category.category_id |
category.category_id |
Cascade on delete |
| education_category_education_id_fkey |
education_category.education_id |
education.education_id |
Cascade on delete |
| education_tag_education_id_fkey |
education_tag.education_id |
education.education_id |
Cascade on delete |
| education_tag_tag_id_fkey |
education_tag.tag_id |
tag.tag_id |
Cascade on delete |
| election__state_id_fk |
election.state_id |
state.state_id |
Restrict delete |
| election_address__addresstype_id_fk |
election_address.addresstype_id |
addresstype.addresstype_id |
Restrict delete |
| election_address__election_candidate_id_fk |
election_address.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| election_address__state_fk |
election_address.state |
state.state_id |
Restrict delete |
| election_candidate__candidate_id_fk |
election_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| election_candidate__districtname_id_fk |
election_candidate.districtname_id |
districtname.districtname_id |
Restrict delete |
| election_candidate__election_id_fk |
election_candidate.election_id |
election.election_id |
Cascade on delete |
| election_candidate__office_id_fk |
election_candidate.office_id |
office.office_id |
Restrict delete |
| election_candidate__state_id_fk |
election_candidate.state_id |
state.state_id |
Restrict delete |
| election_districtname__districtname_id_fk |
election_districtname.districtname_id |
districtname.districtname_id |
Restrict delete |
| election_districtname__election_id_fk |
election_districtname.election_id |
election.election_id |
Cascade on delete |
| election_districtname__state_id_fk |
election_districtname.state_id |
state.state_id |
Restrict delete |
| election_electionstage__candidaterelease_id |
election_electionstage.candidaterelease_id |
release.release_id |
Restrict delete |
| election_electionstage__election_id_fk |
election_electionstage.election_id |
election.election_id |
Cascade on delete |
| election_electionstage__npatrelease_id |
election_electionstage.npatrelease_id |
release.release_id |
Restrict delete |
| election_electionstage__release_id |
election_electionstage.release_id |
release.release_id |
Restrict delete |
| election_electionstage__resultrelease_id |
election_electionstage.resultrelease_id |
release.release_id |
Restrict delete |
| election_electionstage__state_id_fk |
election_electionstage.state_id |
state.state_id |
Restrict delete |
| election_webaddress__addresstype_id_fk |
election_webaddress.addresstype_id |
addresstype.addresstype_id |
Restrict delete |
| election_webaddress__election_candidate_id_fk |
election_webaddress.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| election_webaddress__webaddresstype_id_fk |
election_webaddress.webaddresstype_id |
webaddresstype.webaddresstype_id |
Restrict delete |
| electionstage_candidate__election_candidate_id_fk |
electionstage_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| electionstage_candidate__election_electionstage_id_fk |
electionstage_candidate.election_electionstage_id |
election_electionstage.election_electionstage_id |
Cascade on delete |
| electionstage_candidate__electioncandidatestatus_id_fk |
electionstage_candidate.electioncandidatestatus_id |
electioncandidatestatus.electioncandidatestatus_id |
Restrict delete |
| electionstage_candidate_party__electionstage_candidate_id_fk |
electionstage_candidate_party.electionstage_candidate_id |
electionstage_candidate.electionstage_candidate_id |
Cascade on delete |
| electionstage_candidate_party__party_id_fk |
electionstage_candidate_party.party_id |
party.party_id |
Restrict delete |
| endorse__election_id_fk |
endorse.election_id |
election.election_id |
Cascade on delete |
| endorse__release_id_fk |
endorse.release_id |
release.release_id |
Restrict delete |
| endorse__sig_id_fk |
endorse.sig_id |
sig.sig_id |
Cascade on delete |
| endorse_candidate__election_candidate_id_fk |
endorse_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| endorse_candidate__endorse_id_fk |
endorse_candidate.endorse_id |
endorse.endorse_id |
Cascade on delete |
| endorser__endorsertype_id_fk |
endorser.endorsertype_id |
endorsertype.endorsertype_id |
Restrict delete |
| endorser__party_id_fk |
endorser.party_id |
party.party_id |
Restrict delete |
| endorser__state_id_fk |
endorser.state_id |
state.state_id |
Restrict delete |
| endorser_candidate__election_candidate_id_fk |
endorser_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| endorser_candidate__endorser_id_fk |
endorser_candidate.endorser_id |
endorser.endorser_id |
Cascade on delete |
| endorsergroup__endorsertype_id_fk |
endorsergroup.endorsertype_id |
endorsertype.endorsertype_id |
Restrict delete |
| endorsergroup__state_id_fk |
endorsergroup.state_id |
state.state_id |
Restrict delete |
| endorsergroup_candidate__election_candidate_id_fk |
endorsergroup_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| endorsergroup_candidate__endorsergroup_id_fk |
endorsergroup_candidate.endorsergroup_id |
endorsergroup.endorsergroup_id |
Restrict delete |
| etl_file_etl_job_id_fkey |
etl_file.etl_job_id |
etl_job.etl_job_id |
Cascade on delete |
| etl_job_etl_status_id_fkey |
etl_job.etl_status_id |
etl_status.etl_status_id |
Restrict delete |
| etl_job_etl_type_id_fkey |
etl_job.etl_type_id |
etl_type.etl_type_id |
Restrict delete |
| etl_sigratings_files_etl_sigratings_harvest_jobs_id_fkey |
etl_sigratings_files.etl_sigratings_harvest_jobs_id |
etl_sigratings_harvest_jobs.etl_sigratings_harvest_jobs_id |
Cascade on delete |
| etl_sigratings_harvest_jobs_etl_status_id_fkey |
etl_sigratings_harvest_jobs.etl_status_id |
etl_status.etl_status_id |
Cascade on delete |
| experience__experiencetype_id_fk |
experience.experiencetype_id |
experiencetype.experiencetype_id |
Restrict delete |
| experience_candidate_id_fkey |
experience.candidate_id |
candidate.candidate_id |
Cascade on delete |
| experience_category_category_id_fkey |
experience_category.category_id |
category.category_id |
Cascade on delete |
| experience_category_experience_id_fkey |
experience_category.experience_id |
experience.experience_id |
Cascade on delete |
| experience_tag_experience_id_fkey |
experience_tag.experience_id |
experience.experience_id |
Cascade on delete |
| experience_tag_tag_id_fkey |
experience_tag.tag_id |
tag.tag_id |
Cascade on delete |
| factcheck_candidate_candidate_id_fkey |
factcheck_candidate.candidate_id |
candidate.candidate_id |
Restrict delete |
| factcheck_candidate_factcheck_id_fkey |
factcheck_candidate.factcheck_id |
factcheck.factcheck_id |
Restrict delete |
| factcheck_category_category_id_fkey |
factcheck_category.category_id |
category.category_id |
Restrict delete |
| factcheck_category_factcheck_id_fkey |
factcheck_category.factcheck_id |
factcheck.factcheck_id |
Restrict delete |
| factcheck_factchecker_id_fkey |
factcheck.factchecker_id |
factchecker.factchecker_id |
Cascade on delete |
| factcheck_speech_candidate_factcheck_id_fkey |
factcheck_speech_candidate.factcheck_id |
factcheck.factcheck_id |
Restrict delete |
| factcheck_speech_candidate_factcheckruling_id_fkey |
factcheck_speech_candidate.factcheckruling_id |
factcheckruling.factcheckruling_id |
Restrict delete |
| factcheck_speech_candidate_speech_candidate_id_fkey |
factcheck_speech_candidate.speech_candidate_id |
speech_candidate.speech_candidate_id |
Restrict delete |
| factcheck_speech_factcheck_id_fkey |
factcheck_speech.factcheck_id |
factcheck.factcheck_id |
Cascade on delete |
| factcheck_speech_factcheckruling_id_fkey |
factcheck_speech.factcheckruling_id |
factcheckruling.factcheckruling_id |
Cascade on delete |
| factcheck_speech_speech_id_fkey |
factcheck_speech.speech_id |
speech.speech_id |
Cascade on delete |
| factcheck_tag_factcheck_id_fkey |
factcheck_tag.factcheck_id |
factcheck.factcheck_id |
Restrict delete |
| factcheck_tag_tag_id_fkey |
factcheck_tag.tag_id |
tag.tag_id |
Restrict delete |
| featured_tag_tag_id_fkey |
featured_tag.tag_id |
tag.tag_id |
Restrict delete |
| finance_candidate__election_candidate_id_fk |
finance_candidate.election_candidate_id |
election_candidate.election_candidate_id |
Restrict delete |
| finance_candidate__finance_catcode_id_fk |
finance_candidate.finance_catcode_id |
finance_catcode.finance_catcode_id |
Restrict delete |
| finsource_candidate__candidate_id_fk |
finsource_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| finsource_candidate__finsource_id_fk |
finsource_candidate.finsource_id |
finsource.finsource_id |
Cascade on delete |
| leadership_candidate__leadership_id_fk |
leadership_candidate.leadership_id |
leadership.leadership_id |
Cascade on delete |
| leadership_candidate__office_candidate_id_fk |
leadership_candidate.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| leadership_office__leadership_id_fk |
leadership_office.leadership_id |
leadership.leadership_id |
Cascade on delete |
| leadership_office__office_id_fk |
leadership_office.office_id |
office.office_id |
Cascade on delete |
| leadership_office__state_id_fk |
leadership_office.state_id |
state.state_id |
Cascade on delete |
| leadership_state__leadership_id_fk |
leadership_state.leadership_id |
leadership.leadership_id |
Cascade on delete |
| leadership_state__state_id_fk |
leadership_state.state_id |
state.state_id |
Restrict delete |
| leadership_state_office__leadership_state_id_fk |
leadership_state_office.leadership_state_id |
leadership_state.leadership_state_id |
Cascade on delete |
| leadership_state_office__office_id_fk |
leadership_state_office.office_id |
office.office_id |
Restrict delete |
| local__localtype_id_fk |
local.localtype_id |
localtype.localtype_id |
Restrict delete |
| local__state_id_fk |
local.state_id |
state.state_id |
Restrict delete |
| local_districtname__districtname_id_fk |
local_districtname.districtname_id |
districtname.districtname_id |
Cascade on delete |
| local_districtname__local_id_fk |
local_districtname.local_id |
local.local_id |
Cascade on delete |
| local_leadership__fk |
local_leadership.leadership_id |
leadership.leadership_id |
Restrict delete |
| measure__congoutcome_id_fk |
measure.congoutcome_id |
congoutcome.congoutcome_id |
Cascade on delete |
| measure_category__category_id_fk |
measure_category.category_id |
category.category_id |
Restrict delete |
| measure_category__measure_id_fk |
measure_category.measure_id |
measure.measure_id |
Cascade on delete |
| measure_tag__measure_fk |
measure_tag.measure_id |
measure.measure_id |
Cascade on delete |
| measure_tag__tag_fk |
measure_tag.tag_id |
tag.tag_id |
Cascade on delete |
| npatanswer__npatcandidate_id_fk |
npatanswer.npatcandidate_id |
npatcandidate.npatcandidate_id |
Cascade on delete |
| npatanswer__npatmatrix_id_fk |
npatanswer.npatmatrix_id |
npatmatrix.npatmatrix_id |
Restrict delete |
| npatanswer__npatoption_id_fk |
npatanswer.npatoption_id |
npatoption.npatoption_id |
Cascade on delete |
| npatanswer__our_npatoption_id_fk |
npatanswer.our_npatoption_id |
npatoption.npatoption_id |
Cascade on delete |
| npatanswer_category_category_id_fkey |
npatanswer_category.category_id |
category.category_id |
Cascade on delete |
| npatanswer_category_npatanswer_id_fkey |
npatanswer_category.npatanswer_id |
npatanswer.npatanswer_id |
Cascade on delete |
| npatanswer_tag_npatanswer_id_fkey |
npatanswer_tag.npatanswer_id |
npatanswer.npatanswer_id |
Cascade on delete |
| npatanswer_tag_tag_id_fkey |
npatanswer_tag.tag_id |
tag.tag_id |
Cascade on delete |
| npatanswerlocking_npatanswer_id_fkey |
npatanswerlocking.npatanswer_id |
npatanswer.npatanswer_id |
Cascade on delete |
| npatcandidate__election_candidate_id_fk |
npatcandidate.election_candidate_id |
election_candidate.election_candidate_id |
Cascade on delete |
| npatcandidate__npatform_id_fk |
npatcandidate.npatform_id |
npatform.npatform_id |
Cascade on delete |
| npatcandidate__npatgroup_id_fk |
npatcandidate.npatgroup_id |
npatgroup.npatgroup_id |
Restrict delete |
| npatcandidate__npatstatus_id_fk |
npatcandidate.npatstatus_id |
npatstatus.npatstatus_id |
Restrict delete |
| npatcitation__npatcandidate_id |
npatcitation.npatcandidate_id |
npatcandidate.npatcandidate_id |
Cascade on delete |
| npatcitation__npatrow_id |
npatcitation.npatrow_id |
npatrow.npatrow_id |
Cascade on delete |
| npatcitation_congstatus__congstatus_id |
npatcitation_congstatus.congstatus_id |
congstatus.congstatus_id |
Cascade on delete |
| npatcitation_congstatus__npatcitation_id |
npatcitation_congstatus.npatcitation_id |
npatcitation.npatcitation_id |
Cascade on delete |
| npatcitation_rating__npatcitation_id |
npatcitation_rating.npatcitation_id |
npatcitation.npatcitation_id |
Cascade on delete |
| npatcitation_speech_candidate__npatcitation_id |
npatcitation_speech_candidate.npatcitation_id |
npatcitation.npatcitation_id |
Cascade on delete |
| npatform_criteria__npatform_id_fk |
npatform_criteria.npatform_id |
npatform.npatform_id |
Cascade on delete |
| npatform_election__election_id_fk |
npatform_election.election_id |
election.election_id |
Cascade on delete |
| npatform_election__npatform_id_fk |
npatform_election.npatform_id |
npatform.npatform_id |
Cascade on delete |
| npatfrom_criteria__npatform_id_fk |
npatform_criteria.npatform_id |
npatform.npatform_id |
Cascade on delete |
| npatgroup__electionstage_id_fk |
npatgroup.electionstage_id |
electionstage.electionstage_id |
Restrict delete |
| npatgroup__npatgrouptype_id_fk |
npatgroup.npatgrouptype_id |
npatgrouptype.npatgrouptype_id |
Restrict delete |
| npatgroup_state__npatgroup_id_fk |
npatgroup_state.npatgroup_id |
npatgroup.npatgroup_id |
Restrict delete |
| npatgroup_state__state_id_fk |
npatgroup_state.state_id |
state.state_id |
Restrict delete |
| npatmatrix__npatrow_id_fk |
npatmatrix.npatrow_id |
npatrow.npatrow_id |
Restrict delete |
| npatmatrix_category_category_id_fkey |
npatmatrix_category.category_id |
category.category_id |
Cascade on delete |
| npatmatrix_category_npatmatrix_id_fkey |
npatmatrix_category.npatmatrix_id |
npatmatrix.npatmatrix_id |
Cascade on delete |
| npatmatrix_npatform_id_fkey |
npatmatrix.npatform_id |
npatform.npatform_id |
Cascade on delete |
| npatmessage__npatmessagetype_id_fk |
npatmessage.npatmessagetype_id |
npatmessagetype.npatmessagetype_id |
Restrict delete |
| npatoption__npatoptiongroup_id_fk |
npatoption.npatoptiongroup_id |
npatoptiongroup.npatoptiongroup_id |
Restrict delete |
| npatoption__npatoptiontext_id_fk |
npatoption.npatoptiontext_id |
npatoptiontext.npatoptiontext_id |
Restrict delete |
| npatproblem_npatcandidate__npatcandidate_id_fk |
npatproblem_npatcandidate.npatcandidate_id |
npatcandidate.npatcandidate_id |
Restrict delete |
| npatproblem_npatcandidate__npatproblem_id_fk |
npatproblem_npatcandidate.npatproblem_id |
npatproblem.npatproblem_id |
Restrict delete |
| npatrow_category__category_id_fkey |
npatrow_category.category_id |
category.category_id |
Restrict delete |
| npatrow_category__npatrow_id_fkey |
npatrow_category.npatrow_id |
npatrow.npatrow_id |
Restrict delete |
| npatrow_congstatus__congstatus_id_fkey |
npatrow_congstatus.congstatus_id |
congstatus.congstatus_id |
Restrict delete |
| npatrow_congstatus__npatrow_id_fkey |
npatrow_congstatus.npatrow_id |
npatrow.npatrow_id |
Restrict delete |
| npatrow_npatrowtext_id_fkey |
npatrow.npatrowtext_id |
npatrowtext.npatrowtext_id |
Cascade on delete |
| npatrow_npatrowtype_id_fkey |
npatrow.npatrowtype_id |
npatrowtype.npatrowtype_id |
Restrict delete |
| npatrow_sig__npatoption_id_fkey |
npatrow_sig.npatoption_id |
npatoption.npatoption_id |
Restrict delete |
| npatrow_sig__npatrow_id_fkey |
npatrow_sig.npatrow_id |
npatrow.npatrow_id |
Restrict delete |
| npatrow_sig__sig_id_fkey |
npatrow_sig.sig_id |
sig.sig_id |
Restrict delete |
| npatrowshorttext__npatrow_id_fk |
npatrowshorttext.npatrow_id |
npatrow.npatrow_id |
Restrict delete |
| npatrowtext_category__category_id_fk |
npatrowtext_category.category_id |
category.category_id |
Cascade on delete |
| npatrowtext_category__npatrowtext_id_fk |
npatrowtext_category.npatrowtext_id |
npatrowtext.npatrowtext_id |
Cascade on delete |
| npatrowtext_tag__npatrowtext_fk |
npatrowtext_tag.npatrowtext_id |
npatrowtext.npatrowtext_id |
Cascade on delete |
| npatrowtext_tag__tag_fk |
npatrowtext_tag.tag_id |
tag.tag_id |
Cascade on delete |
| office__officetype_id_fk |
office.officetype_id |
officetype.officetype_id |
Restrict delete |
| office__release_id_fk |
office.release_id |
release.release_id |
Restrict delete |
| office_address__addresstype_id_fk |
office_address.addresstype_id |
addresstype.addresstype_id |
Restrict delete |
| office_address__office_candidate_id_fk |
office_address.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| office_address__state_fk |
office_address.state |
state.state_id |
Restrict delete |
| office_candidate__candidate_id_fk |
office_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| office_candidate__districtname_id_fk |
office_candidate.districtname_id |
districtname.districtname_id |
Restrict delete |
| office_candidate__local_id_fk |
office_candidate.local_id |
local.local_id |
Cascade on delete |
| office_candidate__office_id_fk |
office_candidate.office_id |
office.office_id |
Restrict delete |
| office_candidate__officecandidatestatus_id_fk |
office_candidate.officecandidatestatus_id |
officecandidatestatus.officecandidatestatus_id |
Restrict delete |
| office_candidate__state_id_fk |
office_candidate.state_id |
state.state_id |
Restrict delete |
| office_candidate_party__office_candidate_id_fk |
office_candidate_party.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| office_candidate_party__party_id_fk |
office_candidate_party.party_id |
party.party_id |
Restrict delete |
| office_category__category_id_fk |
office_category.category_id |
category.category_id |
Cascade on delete |
| office_category__office_id_fk |
office_category.office_id |
office.office_id |
Cascade on delete |
| office_webaddress__addresstype_id_fk |
office_webaddress.addresstype_id |
addresstype.addresstype_id |
Cascade on delete |
| office_webaddress__office_candidate_id_fk |
office_webaddress.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| office_webaddress__webaddresstype_id_fk |
office_webaddress.webaddresstype_id |
webaddresstype.webaddresstype_id |
Cascade on delete |
| officetype__officebranch_id_fk |
officetype.officebranch_id |
officebranch.officebranch_id |
Restrict delete |
| officetype__officelevel_id_fk |
officetype.officelevel_id |
officelevel.officelevel_id |
Restrict delete |
| party_category__category_id_fk |
party_category.category_id |
category.category_id |
Cascade on delete |
| party_category__party_id_fk |
party_category.party_id |
party.party_id |
Cascade on delete |
| party_tag_party_id_fkey |
party_tag.party_id |
party.party_id |
Cascade on delete |
| party_tag_tag_id_fkey |
party_tag.tag_id |
tag.tag_id |
Cascade on delete |
| primarytype_state_party_id_fkey |
primarytype_state.party_id |
party.party_id |
Restrict delete |
| primarytype_state_primarytype_id_fkey |
primarytype_state.primarytype_id |
primarytype.primarytype_id |
Restrict delete |
| primarytype_state_state_id_fkey |
primarytype_state.state_id |
state.state_id |
Restrict delete |
| profession_candidate_id_fkey |
profession.candidate_id |
candidate.candidate_id |
Cascade on delete |
| pyadmin_tasks_user_id_fkey |
pyadmin_tasks.user_id |
user.user_id |
Restrict delete |
| rating__ratingformat_id_fk |
rating.ratingformat_id |
ratingformat.ratingformat_id |
Restrict delete |
| rating__ratingsession_id_fk |
rating.ratingsession_id |
ratingsession.ratingsession_id |
Restrict delete |
| rating__release_id_fk |
rating.release_id |
release.release_id |
Restrict delete |
| rating__sig_id_fk |
rating.sig_id |
sig.sig_id |
Cascade on delete |
| rating_candidate__candidate_id_fk |
rating_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| rating_candidate__rating_id_fk |
rating_candidate.rating_id |
rating.rating_id |
Cascade on delete |
| rating_category__category_id_fk |
rating_category.category_id |
category.category_id |
Restrict delete |
| rating_category__rating_id_fk |
rating_category.rating_id |
rating.rating_id |
Cascade on delete |
| rating_tag__rating_fk |
rating_tag.rating_id |
rating.rating_id |
Cascade on delete |
| rating_tag__tag_fk |
rating_tag.tag_id |
tag.tag_id |
Cascade on delete |
| religion_category_category_id_fkey |
religion_category.category_id |
category.category_id |
Cascade on delete |
| religion_tag_religion_id_fkey |
religion_tag.religion_id |
religion.religion_id |
Cascade on delete |
| religion_tag_tag_id_fkey |
religion_tag.tag_id |
tag.tag_id |
Cascade on delete |
| resource__resourcetype_id_fk |
resource.resourcetype_id |
resourcetype.resourcetype_id |
Restrict delete |
| resource__state_id_fk |
resource.state_id |
state.state_id |
Restrict delete |
| sig__release_id_fk |
sig.release_id |
release.release_id |
Restrict delete |
| sig__state__fk |
sig.state |
state.state_id |
Restrict delete |
| sig__state_id_fk |
sig.state_id |
state.state_id |
Restrict delete |
| sig_category__category_id_fk |
sig_category.category_id |
category.category_id |
Cascade on delete |
| sig_category__sig_id_fk |
sig_category.sig_id |
sig.sig_id |
Cascade on delete |
| sig_tag__sig_fk |
sig_tag.sig_id |
sig.sig_id |
Cascade on delete |
| sig_tag__tag_fk |
sig_tag.tag_id |
tag.tag_id |
Cascade on delete |
| speech__release_id_fk |
speech.release_id |
release.release_id |
Restrict delete |
| speech__speechtype_id_fk |
speech.speechtype_id |
speechtype.speechtype_id |
Restrict delete |
| speech_candidate__candidate_id_fk |
speech_candidate.candidate_id |
candidate.candidate_id |
Cascade on delete |
| speech_candidate__speech_id_fk |
speech_candidate.speech_id |
speech.speech_id |
Cascade on delete |
| speech_category__category_id_fk |
speech_category.category_id |
category.category_id |
Restrict delete |
| speech_category__speech_id_fk |
speech_category.speech_id |
speech.speech_id |
Cascade on delete |
| speech_tag__speech_fk |
speech_tag.speech_id |
speech.speech_id |
Cascade on delete |
| speech_tag__tag_fk |
speech_tag.tag_id |
tag.tag_id |
Cascade on delete |
| speechlocking__fkey |
speechlocking.speech_id |
speech.speech_id |
Cascade on delete |
| state__statetype_id_fk |
state.statetype_id |
statetype.statetype_id |
Restrict delete |
| tagalias_tag_id_fkey |
tagalias.tag_id |
tag.tag_id |
Cascade on delete |
| user_role_user_id_fkey |
user_role.user_id |
user.user_id |
Cascade on delete |
| vacancy__election_id_fk |
vacancy.election_id |
election.election_id |
Cascade on delete |
| vacancy__o_c_id_fk |
vacancy.office_candidate_id |
office_candidate.office_candidate_id |
Cascade on delete |
| zipcode__local_id_fk |
zipcode_local.local_id |
local.local_id |
Cascade on delete |