SchemaSpy Analysis of mkt.person - Constraints Generated by
SchemaSpy
16 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
person_biography_cont_fkey person_biography.contextid context.id Restrict delete 
person_biography_pers_fkey person_biography.personid person.id Restrict delete 
person_birthlname_fkey person.birthlocationnameid location_name.id Restrict delete 
person_birthtprec_fkey person.datebirthtimeprecisionid timeprecision.id Restrict delete 
person_contact_ctype_fkey person_contact.contacttypeid contacttype.id Restrict delete 
person_contact_fkey person_contact.personid person.id Restrict delete 
person_contact_fromprec_fkey person_contact.datefromtimeprecisionid timeprecision.id Restrict delete 
person_contact_tospec_fkey person_contact.datetotimeprecisionid timeprecision.id Restrict delete 
person_context_con_fkey personusageincontext.contextid context.id Restrict delete 
person_context_fkey personusageincontext.personid person.id Restrict delete 
person_deathlname_fkey person.deathlocationnameid location_name.id Restrict delete 
person_deathtprec_fkey person.datedeathtimeprecisionid timeprecision.id Restrict delete 
person_gender_fkey person.genderid gender.id Restrict delete 
person_name_fkey person_name.personid person.id Restrict delete 
person_name_nametype_fkey person_name.nametypeid personnametype.id Restrict delete 
person_personimportance_fkey person.personimportanceid personimportance.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected