SchemaSpy Analysis of sola_cs.application - ConstraintsExtension to the LADM used by SOLA to implement Case Management functionality. Generated by
SchemaSpy
24 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
application_action_code_fk16 application.action_code application_action_type.code Restrict delete 
application_action_type_status_to_set_fk17 application_action_type.status_to_set application_status_type.code Restrict delete 
application_agent_id_fk8 application.agent_id party.id Restrict delete 
application_assignee_id_fk15 application.assignee_id appuser.id Restrict delete 
application_contact_person_id_fk14 application.contact_person_id party.id Restrict delete 
application_property_application_id_fk123 application_property.application_id application.id Restrict delete 
application_property_ba_unit_id_fk124 application_property.ba_unit_id ba_unit.id Restrict delete 
application_property_land_use_code_fk125 application_property.land_use_code land_use_type.code Restrict delete 
application_spatial_unit_application_id_fk130 application_spatial_unit.application_id application.id Cascade on delete 
application_spatial_unit_spatial_unit_id_fk131 application_spatial_unit.spatial_unit_id cadastre_object.id Cascade on delete 
application_status_code_fk18 application.status_code application_status_type.code Restrict delete 
application_uses_source_application_id_fk126 application_uses_source.application_id application.id Cascade on delete 
application_uses_source_source_id_fk127 application_uses_source.source_id source.id Cascade on delete 
request_type_config_panel_launcher_fkey request_type.service_panel_code config_panel_launcher.code Restrict delete 
request_type_request_category_code_fk20 request_type.request_category_code request_category_type.code Restrict delete 
request_type_requires_source_type_request_type_code_fk129 request_type_requires_source_type.request_type_code request_type.code Cascade on delete 
request_type_requires_source_type_source_type_code_fk128 request_type_requires_source_type.source_type_code administrative_source_type.code Cascade on delete 
request_type_rrr_type_code_fk21 request_type.rrr_type_code rrr_type.code Restrict delete 
request_type_type_action_code_fk23 request_type.type_action_code type_action.code Restrict delete 
service_action_code_fk25 service.action_code service_action_type.code Restrict delete 
service_action_type_status_to_set_fk26 service_action_type.status_to_set service_status_type.code Restrict delete 
service_application_id_fk7 service.application_id application.id Restrict delete 
service_request_type_code_fk19 service.request_type_code request_type.code Restrict delete 
service_status_code_fk24 service.status_code service_status_type.code Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected