SchemaSpy Analysis of mkt.corporate - Constraints Generated by
SchemaSpy
36 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
corporate_contact_fromprec_fkey corporate_contact.datefromtimeprecisionid timeprecision.id Restrict delete 
corporate_contact_toprec_fkey corporate_contact.datetotimeprecisionid timeprecision.id Restrict delete 
corporate_conteext_cont_fkey corporateusageincontext.contextid context.id Restrict delete 
corporate_context_corp_fkey corporateusageincontext.corporateid corporate.id Restrict delete 
corporate_corporate_fromprec_fkey corporate_corporate.datefromtimeprecisionid timeprecision.id Restrict delete 
corporate_corporate_rel_fkey corporate_corporate.relationid relation.id Restrict delete 
corporate_corporate_toprec_fkey corporate_corporate.datetotimeprecisionid timeprecision.id Restrict delete 
corporate_fromprec_fkey corporate.datefromtimeprecisionid timeprecision.id Restrict delete 
corporate_history_corp_fkey corporate_history.corporateid corporate.id Restrict delete 
corporate_location_venuetype_fkey corporate_location.venuetypeid concept_venuetype.id Restrict delete 
corporate_name_corp_fkey corporate_name.corporateid corporate.id Restrict delete 
corporate_name_nametype_fkey corporate_name.corporatenametypeid corporatenametype.id Restrict delete 
corporate_person_position_fromprec_fkey corporate_person_position.datefromtimeprecisionid timeprecision.id Restrict delete 
corporate_person_position_pers_fkey corporate_person_position.personnameid person_name.id Restrict delete 
corporate_person_position_posit_fkey corporate_person_position.positionid position.id Restrict delete 
corporate_person_position_toprec_fkey corporate_person_position.datetotimeprecisionid timeprecision.id Restrict delete 
corporate_pr_material_fromprec_fkey corporate_pr_material.datefromtimeprecisionid timeprecision.id Restrict delete 
corporate_pr_material_toprec_fkey corporate_pr_material.datetotimeprecisionid timeprecision.id Restrict delete 
corporate_profile_corp_fkey corporate_profile.corporateid corporate.id Restrict delete 
corporate_profile_role_fkey corporate_profile.roleid role.id Restrict delete 
corporate_toprec_fkey corporate.datetotimeprecisionid timeprecision.id Restrict delete 
corporate_type_fkey corporate.corporatetypeid corporatetype.id Restrict delete 
corporates_addresses_corp_fkey corporate_address.corporateid corporate.id Restrict delete 
corporates_addresses_fromprec_fkey corporate_address.datefromtimeprecisionid timeprecision.id Restrict delete 
corporates_addresses_locprec_fkey corporate_address.locationprecisionid locationprecision.id Restrict delete 
corporates_addresses_settlementname_fkey corporate_address.settlementnameid location_name.id Restrict delete 
corporates_addresses_streetname_fkey corporate_address.geographicaladdressnameid location_name.id Restrict delete 
corporates_addresses_toprec_fkey corporate_address.datetotimeprecisionid timeprecision.id Restrict delete 
corporates_contacts_contype_fkey corporate_contact.contacttypeid contacttype.id Restrict delete 
corporates_contacts_corp_fkey corporate_contact.corporateid corporate.id Restrict delete 
corporates_corporates_left_fkey corporate_corporate.corporateid corporate.id Restrict delete 
corporates_corporates_right_fkey corporate_corporate.relatedcorporatenameid corporate_name.id Restrict delete 
corporates_locations_corp_fkey corporate_location.corporateid corporate.id Restrict delete 
corporates_pr_materials_corp_fkey corporate_pr_material.corporateid corporate.id Restrict delete 
orporates_locations_locname_fkey corporate_location.locationnameid location_name.id Restrict delete 
orporates_locations_locprec_fkey corporate_location.locationprecisionid locationprecision.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected