Constraints

37 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
mstr_contacts_owning_entity_fk
mstr_contacts.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_contacts_contact_states_fk
mstr_contacts.contact_state_id
syst_enum_items.id
Restrict delete
mstr_contacts_contact_types_fk
mstr_contacts.contact_type_id
syst_enum_items.id
Restrict delete
mstr_entity_bank_entities_entity_fk
mstr_entity_bank_entities.entity_id
mstr_entities.id
Cascade on delete
mstr_entity_bank_entities_owning_entity_fk
mstr_entity_bank_entities.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_persons_entities_fk
mstr_persons.owning_entity_id
mstr_entities.id
Restrict delete
mstr_persons_person_types_fk
mstr_persons.person_type_id
syst_enum_items.id
Restrict delete
mstr_persons_person_states_fk
mstr_persons.person_state_id
syst_enum_items.id
Restrict delete
mstr_places_place_states_fk
mstr_places.place_state_id
syst_enum_items.id
Restrict delete
mstr_places_entities_fk
mstr_places.owning_entity_id
mstr_entities.id
Restrict delete
mstr_places_place_types_fk
mstr_places.place_type_id
syst_enum_items.id
Restrict delete
mstr_country_phone_format_assocs_phone_formats_fk
mstr_country_phone_format_assocs.phone_format_id
syst_complex_format_values.id
Restrict delete
mstr_country_phone_format_assocs_countries_fk
mstr_country_phone_format_assocs.country_id
mstr_countries.id
Restrict delete
mstr_entity_purchasing_entities_owning_entity_fk
mstr_entity_purchasing_entities.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_entity_purchasing_entities_entity_fk
mstr_entity_purchasing_entities.entity_id
mstr_entities.id
Cascade on delete
mstr_person_contact_roles_enum_person_contact_role_fk
mstr_person_contact_roles.person_contact_role_id
syst_enum_items.id
Restrict delete
mstr_person_contact_roles_contact_fk
mstr_person_contact_roles.contact_id
mstr_contacts.id
Cascade on delete
mstr_person_contact_roles_place_fk
mstr_person_contact_roles.place_id
mstr_places.id
Restrict delete
mstr_person_contact_roles_person_fk
mstr_person_contact_roles.person_id
mstr_persons.id
Cascade on delete
mstr_entities_entity_types_fk
mstr_entities.entity_type_id
syst_enum_items.id
Restrict delete
mstr_entities_entities_fk
mstr_entities.owning_entity_id
mstr_entities.id
Restrict delete
mstr_entities_entity_states_fk
mstr_entities.entity_state_id
syst_enum_items.id
Restrict delete
mstr_entity_selling_entities_owning_entity_fk
mstr_entity_selling_entities.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_entity_selling_entities_entity_fk
mstr_entity_selling_entities.entity_id
mstr_entities.id
Cascade on delete
mstr_country_address_format_assocs_countries_fk
mstr_country_address_format_assocs.country_id
mstr_countries.id
Cascade on delete
mstr_country_address_format_assocs_address_formats_fk
mstr_country_address_format_assocs.address_format_id
syst_complex_format_values.id
Cascade on delete
mstr_entity_facility_places_owning_entity_fk
mstr_entity_facility_places.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_entity_facility_places_place_fk
mstr_entity_facility_places.place_id
mstr_places.id
Cascade on delete
mstr_entity_staff_entities_entity_fk
mstr_entity_staff_entities.entity_id
mstr_entities.id
Cascade on delete
mstr_entity_staff_entities_owning_entity_fk
mstr_entity_staff_entities.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_country_name_format_assocs_countries_fk
mstr_country_name_format_assocs.country_id
mstr_countries.id
Restrict delete
mstr_country_name_format_assocs_name_formats_fk
mstr_country_name_format_assocs.name_format_id
syst_complex_format_values.id
Restrict delete
mstr_entity_person_roles_entity_fk
mstr_entity_person_roles.entity_id
mstr_entities.id
Cascade on delete
mstr_entity_person_roles_enum_entity_person_role_fk
mstr_entity_person_roles.entity_person_role_id
syst_enum_items.id
Restrict delete
mstr_entity_person_roles_person_fk
mstr_entity_person_roles.person_id
mstr_persons.id
Cascade on delete
mstr_entity_inventory_places_owning_entity_fk
mstr_entity_inventory_places.owning_entity_id
mstr_entities.id
Cascade on delete
mstr_entity_inventory_places_place_fk
mstr_entity_inventory_places.place_id
mstr_places.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint