Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
submission_contact_contact_type_code_fk
submission_contact.contact_type_code
contact_type_code.contact_type_code
Restrict delete
submission_id_fk
submission_contact.submission_id
submission.submission_id
Restrict delete
submission_contact_id_fk
submission_location_contact_xref.submission_contact_id
submission_contact.submission_contact_id
Restrict delete
submission_location_id_fk
submission_location_contact_xref.submission_location_id
submission_location.submission_location_id
Restrict delete
submission_id_fk
submission_matching_detail.submission_id
submission.submission_id
Restrict delete
submission_submission_status_code_fk
submission.submission_status_code
submission_status_code.submission_status_code
Restrict delete
submission_submission_type_code_fk
submission.submission_type_code
submission_type_code.submission_type_code
Restrict delete
submission_location_country_code_fk
submission_location.country_code
country_code.country_code
Restrict delete
submission_location_province_code_fk
submission_location.country_code
submission_location.province_code
province_code.country_code
province_code.province_code
Restrict delete
submission_id_fk
submission_location.submission_id
submission.submission_id
Restrict delete
province_code_country_code_fk
province_code.country_code
country_code.country_code
Restrict delete
submission_detail_district_code_fk
submission_detail.district_code
district_code.district_code
Restrict delete
submission_detail_client_type_code_fk
submission_detail.client_type_code
client_type_code.client_type_code
Restrict delete
submission_id_fk
submission_detail.submission_id
submission.submission_id
Restrict delete
submission_detail_business_type_code_fk
submission_detail.business_type_code
business_type_code.business_type_code
Restrict delete
province_code_fk
submission_detail.identification_country_code
submission_detail.identification_province_code
province_code.country_code
province_code.province_code
Restrict delete
identification_type_code_fk
submission_detail.identification_type_code
identification_type_code.identification_type_code
Restrict delete

Check Constraints

Table Constraint Name Constraint