SchemaSpy Analysis of sola_cs.system - ConstraintsExtension to the LADM that contains SOLA system configuration, business rules and user details. Generated by
SchemaSpy
22 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
approle_appgroup_appgroup_id_fk118 approle_appgroup.appgroup_id appgroup.id Cascade on delete 
approle_appgroup_approle_code_fk117 approle_appgroup.approle_code approle.code Cascade on delete 
appuser_appgroup_appgroup_id_fk120 appuser_appgroup.appgroup_id appgroup.id Cascade on delete 
appuser_appgroup_appuser_id_fk119 appuser_appgroup.appuser_id appuser.id Cascade on delete 
appuser_setting_user_id_fk103 appuser_setting.user_id appuser.id Cascade on delete 
br_definition_br_id_fk116 br_definition.br_id br.id Cascade on delete 
br_technical_type_code_fk107 br.technical_type_code br_technical_type.code Restrict delete 
br_validation_br_id_fk108 br_validation.br_id br.id Restrict delete 
br_validation_severity_code_fk109 br_validation.severity_code br_severity_type.code Restrict delete 
br_validation_target_application_moment_fk113 br_validation.target_application_moment application_action_type.code Restrict delete 
br_validation_target_code_fk110 br_validation.target_code br_validation_target_type.code Restrict delete 
br_validation_target_reg_moment_fk115 br_validation.target_reg_moment reg_status_type.code Restrict delete 
br_validation_target_request_type_code_fk111 br_validation.target_request_type_code request_type.code Restrict delete 
br_validation_target_rrr_type_code_fk112 br_validation.target_rrr_type_code rrr_type.code Restrict delete 
br_validation_target_service_moment_fk114 br_validation.target_service_moment service_action_type.code Restrict delete 
config_map_layer_metadata_name_fk config_map_layer_metadata.name_layer config_map_layer.name Cascade on delete 
config_map_layer_pojo_query_name_fk105 config_map_layer.pojo_query_name query.name Restrict delete 
config_map_layer_pojo_query_name_for_select_fk106 config_map_layer.pojo_query_name_for_select query.name Restrict delete 
config_map_layer_type_code_fk104 config_map_layer.type_code config_map_layer_type.code Restrict delete 
config_panel_launcher_launch_group_fkey config_panel_launcher.launch_group panel_launcher_group.code Restrict delete 
map_search_option_query_name_fk122 map_search_option.query_name query.name Restrict delete 
query_field_query_name_fk121 query_field.query_name query.name Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected