Constraints

38 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_decision__discharge_code
decision.discharge_code
discharge_code.discharge_code
Restrict delete
fk_decision__lead_agency_code
decision.lead_agency_code
agency_code.agency_code
Restrict delete
fk_decision__ncdm_code
decision.non_compliance_decision_matrix_code
non_compliance_decision_matrix_code.non_compliance_decision_matrix_code
Restrict delete
fk_decision__case_file_guid
decision.case_file_guid
case_file.case_file_guid
Restrict delete
fk_decision__schedule_sector_xref_guid
decision.schedule_sector_xref_guid
schedule_sector_xref.schedule_sector_xref_guid
Restrict delete
fk_schedule_sector_xref__sector_code
schedule_sector_xref.sector_code
sector_code.sector_code
Restrict delete
fk_schedule_sector_xref__schedule_code
schedule_sector_xref.schedule_code
schedule_code.schedule_code
Restrict delete
FK_action_type_action_xref__action_type_code
action_type_action_xref.action_type_code
action_type_code.action_type_code
Restrict delete
FK_action_type_action_xref__action_code
action_type_action_xref.action_code
action_code.action_code
Restrict delete
fk_drug_administered__drug_remaining_outcome_code
drug_administered.drug_remaining_outcome_code
drug_remaining_outcome_code.drug_remaining_outcome_code
Restrict delete
fk_drug_administered__wildlife_guid
drug_administered.wildlife_guid
wildlife.wildlife_guid
Restrict delete
fk_drug_administered__drug_code
drug_administered.drug_code
drug_code.drug_code
Restrict delete
fk_drug_administered__drug_method_code
drug_administered.drug_method_code
drug_method_code.drug_method_code
Restrict delete
fk_equipment__equipment_code
equipment.equipment_code
equipment_code.equipment_code
Restrict delete
FK_inaction_reason_code__agency_code
inaction_reason_code.agency_code
agency_code.agency_code
Restrict delete
fk_ear_tag__wildlife_guid
ear_tag.wildlife_guid
wildlife.wildlife_guid
Restrict delete
fk_ear_tag__ear_code
ear_tag.ear_code
ear_code.ear_code
Restrict delete
fk_authorization_permit__case_file_guid
authorization_permit.case_file_guid
case_file.case_file_guid
Restrict delete
fk_site__case_file_guid
site.case_file_guid
case_file.case_file_guid
Restrict delete
FK_action__case_guid
action.case_guid
case_file.case_file_guid
Restrict delete
FK_action_action_type_action_xref
action.action_type_action_xref_guid
action_type_action_xref.action_type_action_xref_guid
Restrict delete
fk_action__wildlife_guid
action.wildlife_guid
wildlife.wildlife_guid
Restrict delete
FK_action__case_note_guid
action.case_note_guid
case_note.case_note_guid
Restrict delete
fk_action__decision_guid
action.decision_guid
decision.decision_guid
Restrict delete
fk_action__equipment_guid
action.equipment_guid
equipment.equipment_guid
Restrict delete
FK_case_note__case_file_guid
case_note.case_file_guid
case_file.case_file_guid
Restrict delete
fk_wildlife__case_file_guid
wildlife.case_file_guid
case_file.case_file_guid
Restrict delete
fk_wildlife__hwcr_outcome_code
wildlife.hwcr_outcome_code
hwcr_outcome_code.hwcr_outcome_code
Restrict delete
fk_wildlife__threat_level_code
wildlife.threat_level_code
threat_level_code.threat_level_code
Restrict delete
fk_wildlife__age_code
wildlife.age_code
age_code.age_code
Restrict delete
fk_wildlife__sex_code
wildlife.sex_code
sex_code.sex_code
Restrict delete
FK_case_file__inaction_reason_code
case_file.inaction_reason_code
inaction_reason_code.inaction_reason_code
Restrict delete
FK_case_file__owned_by_agency_code
case_file.owned_by_agency_code
agency_code.agency_code
Restrict delete
FK_case_file__case_code
case_file.case_code
case_code.case_code
Restrict delete
fk_case_file__case_threat_level_code
case_file.case_threat_level_code
threat_level_code.threat_level_code
Restrict delete
fk_case_file__case_conflict_history_code
case_file.case_conflict_history_code
conflict_history_code.conflict_history_code
Restrict delete
fk_case_file__case_location_code
case_file.case_location_code
case_location_code.case_location_code
Restrict delete
FK_lead__case_identifier
lead.case_identifier
case_file.case_file_guid
Restrict delete

Check Constraints

Table Constraint Name Constraint