SchemaSpy Analysis of sola.administrative - ConstraintsThe SOLA implementation of the LADM Administrative package. Models land use rights and restrictions how those rights and restrictions relate to property and people. Generated by
SchemaSpy
38 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
ba_unit_area_ba_unit_id_fk77 ba_unit_area.ba_unit_id ba_unit.id Cascade on delete 
ba_unit_area_type_code_fk78 ba_unit_area.type_code area_type.code Restrict delete 
ba_unit_as_party_ba_unit_id_fk71 ba_unit_as_party.ba_unit_id ba_unit.id Cascade on delete 
ba_unit_as_party_party_id_fk72 ba_unit_as_party.party_id party.id Cascade on delete 
ba_unit_contains_spatial_unit_ba_unit_id_fk68 ba_unit_contains_spatial_unit.ba_unit_id ba_unit.id Cascade on delete 
ba_unit_contains_spatial_unit_spatial_unit_id_fk69 ba_unit_contains_spatial_unit.spatial_unit_id spatial_unit.id Cascade on delete 
ba_unit_contains_spatial_unit_spatial_unit_id_fk70 ba_unit_contains_spatial_unit.spatial_unit_id cadastre_object.id Cascade on delete 
ba_unit_status_code_fk39 ba_unit.status_code reg_status_type.code Restrict delete 
ba_unit_target_ba_unit_id_fk83 ba_unit_target.ba_unit_id ba_unit.id Cascade on delete 
ba_unit_target_transaction_id_fk84 ba_unit_target.transaction_id transaction.id Cascade on delete 
ba_unit_transaction_id_fk40 ba_unit.transaction_id transaction.id Cascade on delete 
ba_unit_type_code_fk38 ba_unit.type_code ba_unit_type.code Restrict delete 
condition_for_rrr_condition_code_fk85 condition_for_rrr.condition_code condition_type.code Restrict delete 
condition_for_rrr_rrr_id_fk86 condition_for_rrr.rrr_id rrr.id Cascade on delete 
mortgage_isbased_in_rrr_mortgage_id_fk47 mortgage_isbased_in_rrr.mortgage_id rrr.id Cascade on delete 
mortgage_isbased_in_rrr_rrr_id_fk46 mortgage_isbased_in_rrr.rrr_id rrr.id Cascade on delete 
notation_ba_unit_id_fk75 notation.ba_unit_id ba_unit.id Cascade on delete 
notation_rrr_id_fk76 notation.rrr_id rrr.id Cascade on delete 
notation_status_code_fk74 notation.status_code reg_status_type.code Restrict delete 
notation_transaction_id_fk73 notation.transaction_id transaction.id Cascade on delete 
party_for_rrr_party_id_fk82 party_for_rrr.party_id party.id Cascade on delete 
party_for_rrr_rrr_id_fk80 party_for_rrr.rrr_id
party_for_rrr.share_id
rrr_share.rrr_id
rrr_share.id
Cascade on delete 
party_for_rrr_rrr_id_fk81 party_for_rrr.rrr_id rrr.id Cascade on delete 
required_relationship_baunit_from_ba_unit_id_fk52 required_relationship_baunit.from_ba_unit_id ba_unit.id Cascade on delete 
required_relationship_baunit_relation_code_fk54 required_relationship_baunit.relation_code ba_unit_rel_type.code Restrict delete 
required_relationship_baunit_to_ba_unit_id_fk53 required_relationship_baunit.to_ba_unit_id ba_unit.id Cascade on delete 
rrr_ba_unit_id_fk42 rrr.ba_unit_id ba_unit.id Cascade on delete 
rrr_mortgage_type_code_fk45 rrr.mortgage_type_code mortgage_type.code Restrict delete 
rrr_share_rrr_id_fk79 rrr_share.rrr_id rrr.id Cascade on delete 
rrr_status_code_fk43 rrr.status_code reg_status_type.code Restrict delete 
rrr_transaction_id_fk44 rrr.transaction_id transaction.id Cascade on delete 
rrr_type_code_fk41 rrr.type_code rrr_type.code Restrict delete 
rrr_type_config_panel_launcher_fkey rrr_type.rrr_panel_code config_panel_launcher.code Restrict delete 
rrr_type_rrr_group_type_code_fk22 rrr_type.rrr_group_type_code rrr_group_type.code Restrict delete 
source_describes_ba_unit_ba_unit_id_fk50 source_describes_ba_unit.ba_unit_id ba_unit.id Cascade on delete 
source_describes_ba_unit_source_id_fk51 source_describes_ba_unit.source_id source.id Cascade on delete 
source_describes_rrr_rrr_id_fk48 source_describes_rrr.rrr_id rrr.id Cascade on delete 
source_describes_rrr_source_id_fk49 source_describes_rrr.source_id source.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected