SchemaSpy Analysis of sola.cadastre - ConstraintsThe SOLA implementation of the LADM Spatial Unit Package. Represents parcels of land and water that can be associated to rights (a.k.a. Cadastre Objects) as well as general spatial or geographic features such as roads, hydro and place names, etc. General spatial features are also known as Spatial Units in SOLA. Generated by
SchemaSpy
29 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
cadastre_object_building_unit_type_code_fk64 cadastre_object.building_unit_type_code building_unit_type.code Restrict delete 
cadastre_object_id_fk61 cadastre_object.id spatial_unit.id Cascade on delete 
cadastre_object_node_target_transaction_id_fk102 cadastre_object_node_target.transaction_id transaction.id Cascade on delete 
cadastre_object_status_code_fk63 cadastre_object.status_code reg_status_type.code Restrict delete 
cadastre_object_target_cadastre_object_id_fk97 cadastre_object_target.cadastre_object_id cadastre_object.id Cascade on delete 
cadastre_object_target_transaction_id_fk98 cadastre_object_target.transaction_id transaction.id Cascade on delete 
cadastre_object_transaction_id_fk65 cadastre_object.transaction_id transaction.id Cascade on delete 
cadastre_object_type_code_fk62 cadastre_object.type_code cadastre_object_type.code Restrict delete 
legal_space_utility_network_id_fk94 legal_space_utility_network.id cadastre_object.id Cascade on delete 
legal_space_utility_network_status_code_fk95 legal_space_utility_network.status_code utility_network_status_type.code Restrict delete 
legal_space_utility_network_type_code_fk96 legal_space_utility_network.type_code utility_network_type.code Restrict delete 
level_config_map_layer_level_id_fk level_config_map_layer.level_id level.id Cascade on delete 
level_config_map_layer_name_fk level_config_map_layer.config_map_layer_name config_map_layer.name Cascade on delete 
level_register_type_code_fk58 level.register_type_code register_type.code Restrict delete 
level_structure_code_fk59 level.structure_code structure_type.code Restrict delete 
level_type_code_fk60 level.type_code level_content_type.code Restrict delete 
spatial_unit_address_address_id_fk90 spatial_unit_address.address_id address.id Cascade on delete 
spatial_unit_address_spatial_unit_id_fk89 spatial_unit_address.spatial_unit_id spatial_unit.id Cascade on delete 
spatial_unit_dimension_code_fk55 spatial_unit.dimension_code dimension_type.code Restrict delete 
spatial_unit_group_found_in_spatial_unit_group_id_fk91 spatial_unit_group.found_in_spatial_unit_group_id spatial_unit_group.id Restrict delete 
spatial_unit_in_group_spatial_unit_group_id_fk92 spatial_unit_in_group.spatial_unit_group_id spatial_unit_group.id Cascade on delete 
spatial_unit_in_group_spatial_unit_id_fk93 spatial_unit_in_group.spatial_unit_id spatial_unit.id Cascade on delete 
spatial_unit_land_use_code_fk66 spatial_unit.land_use_code land_use_type.code Restrict delete 
spatial_unit_level_id_fk57 spatial_unit.level_id level.id Restrict delete 
spatial_unit_surface_relation_code_fk56 spatial_unit.surface_relation_code surface_relation_type.code Restrict delete 
spatial_unit_transaction_id_fk67 spatial_unit.transaction_id transaction.id Cascade on delete 
spatial_value_area_spatial_unit_id_fk87 spatial_value_area.spatial_unit_id spatial_unit.id Cascade on delete 
spatial_value_area_type_code_fk88 spatial_value_area.type_code area_type.code Cascade on delete 
survey_point_transaction_id_fk99 survey_point.transaction_id transaction.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected