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

Constraint Name Child Column Parent Column Delete Rule
ps9_bounding_box_coverage_id_fkey ps_bounding_box.coverage_id ps_coverage.id Cascade on delete 
ps9_coverage_gml_type_id_fkey ps_coverage.gml_type_id ps_gml_subtype.id Restrict delete 
ps9_coverage_native_format_id_fkey ps_coverage.native_format_id ps_mime_type.id Restrict delete 
ps9_domain_set_coverage_id_fkey ps_domain_set.coverage_id ps_coverage.id Cascade on delete 
ps9_extra_metadata_coverage_id_fkey ps_extra_metadata.coverage_id ps_coverage.id Cascade on delete 
ps9_extra_metadata_metadata_type_id_fkey ps_extra_metadata.metadata_type_id ps_extra_metadata_type.id Restrict delete 
ps9_format_gdal_id_fkey ps_format.gdal_id ps_gdal_format.id Restrict delete 
ps9_format_mime_type_id_fkey ps_format.mime_type_id ps_mime_type.id Restrict delete 
ps9_gml_subtype_subtype_parent_fkey ps_gml_subtype.subtype_parent ps_gml_subtype.id Restrict delete 
ps9_grid_axis_gridded_coverage_id_fkey ps_grid_axis.gridded_coverage_id ps_gridded_domain_set.coverage_id Cascade on delete 
ps9_gridded_domain_set_coverage_id_fkey ps_gridded_domain_set.coverage_id ps_domain_set.coverage_id Cascade on delete 
ps9_quantity_interval_interval_id_fkey ps_quantity_interval.interval_id ps_interval.id Restrict delete 
ps9_quantity_interval_quantity_id_fkey ps_quantity_interval.quantity_id ps_quantity.id Restrict delete 
ps9_quantity_uom_id_fkey ps_quantity.uom_id ps_uom.id Restrict delete 
ps9_range_set_coverage_id_fkey ps_range_set.coverage_id ps_coverage.id Cascade on delete 
ps9_range_type_component_coverage_id_fkey ps_range_type_component.coverage_id ps_coverage.id Cascade on delete 
ps9_range_type_component_data_type_id_fkey ps_range_type_component.data_type_id ps_range_data_type.id Cascade on delete 
ps9_rectilinear_axis_grid_axis_id_fkey ps_rectilinear_axis.grid_axis_id ps_grid_axis.id Cascade on delete 
ps9_service_identification_description_id_fkey ps_service_identification.description_id ps_description.id Restrict delete 
ps9_vector_coefficients_grid_axis_id_fkey ps_vector_coefficients.grid_axis_id ps_rectilinear_axis.grid_axis_id Cascade on delete 
ps_coverage_description_id_fkey ps_coverage.description_id ps_description.id Restrict delete 
ps_pyramidlevels_layerid_fkey ps_pyramidlevels.layerid ps_layers.layerid Restrict delete 
ps_service_provider_contact_phone_id_fkey ps_service_provider.contact_phone_id ps_telephone.id Restrict delete 
ps_service_provider_contact_role_id_fkey ps_service_provider.contact_role_id ps_role_code.id Restrict 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 

Check Constraints:

Table Constraint Name Constraint
None detected