SchemaSpy Analysis of petascopedb.public - Constraints Generated by
SchemaSpy
21 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
ps_celldomain_coverage_fkey ps_celldomain.coverage ps_coverage.id Cascade on delete 
ps_coverage_interpolationtypedefault_fkey ps_coverage.interpolationtypedefault ps_interpolationtype.id Restrict delete 
ps_coverage_nullresistancedefault_fkey ps_coverage.nullresistancedefault ps_nullresistance.id Restrict delete 
ps_crsdetails_coverage_fkey ps_crsdetails.coverage ps_coverage.id Cascade on delete 
ps_crsset_axis_fkey ps_crsset.axis ps_domain.id Cascade on delete 
ps_crsset_crs_fkey ps_crsset.crs ps_crs.id Cascade on delete 
ps_descriptions_coverage_fkey ps_descriptions.coverage ps_coverage.id Cascade on delete 
ps_domain_coverage_fkey ps_domain.coverage ps_coverage.id Cascade on delete 
ps_domain_type_fkey ps_domain.type ps_axistype.id Cascade on delete 
ps_interpolationset_coverage_fkey ps_interpolationset.coverage ps_coverage.id Cascade on delete 
ps_interpolationset_interpolationtype_fkey ps_interpolationset.interpolationtype ps_interpolationtype.id Cascade on delete 
ps_interpolationset_nullresistance_fkey ps_interpolationset.nullresistance ps_nullresistance.id Cascade on delete 
ps_metadata_coverage_fkey ps_metadata.coverage ps_coverage.id Cascade on delete 
ps_nullset_coverage_fkey ps_nullset.coverage ps_coverage.id Cascade on delete 
ps_pyramidlevels_layerid_fkey ps_pyramidlevels.layerid ps_layers.layerid Restrict delete 
ps_range_coverage_fkey ps_range.coverage ps_coverage.id Cascade on delete 
ps_range_type_fkey ps_range.type ps_datatype.id Cascade on delete 
ps_servicelayer_layerid_fkey ps_servicelayer.layerid ps_layers.layerid Restrict delete 
ps_servicelayer_serviceid_fkey ps_servicelayer.serviceid ps_services.serviceid Restrict delete 
ps_styles_layerid_fkey ps_styles.layerid ps_layers.layerid Restrict delete 
uom_fk ps_domain.uom ps_uom.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected