SchemaSpy Analysis of mkt.location - Constraints Generated by
SchemaSpy
9 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
location_fkey location_name.locationid location.id Restrict delete 
location_image_imagetype_fkey location_image.imagetypeid imagetype.id Restrict delete 
location_image_locid_fkey location_image.locationid location.id Restrict delete 
location_name_fromprec_fkey location_name.datefromtimeprecisionid timeprecision.id Restrict delete 
location_name_geoaddresstype_fkey location_name.geographicaladdresstypeid geographicaladdresstype.id Restrict delete 
location_name_inmaxprec_fkey location_name.dateinmaxtimeprecisionid timeprecision.id Restrict delete 
location_name_inminprec_fkey location_name.dateinmintimeprecisionid timeprecision.id Restrict delete 
location_name_locnametype_fkey location_name.locationnametypeid locationnametype.id Restrict delete 
location_name_toprec_fkey location_name.datetotimeprecisionid timeprecision.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected