Table sola.system.query
Defines SQL queries that can be executed dynamically by the Search EJB. Also defines queries to retrieve spatial features for each map layer.
Tags: FLOSS SOLA Extension, Reference Table, System Configuration

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
name varchar 100
config_map_layer.pojo_query_name config_map_layer_pojo_query_name_fk105 R
config_map_layer.pojo_query_name_for_select config_map_layer_pojo_query_name_for_select_fk106 R
map_search_option.query_name map_search_option_query_name_fk122 R
query_field.query_name query_field_query_name_fk121 C
Identifier/name for the query
sql varchar 4000 The SQL query definition. These SQL queries are executed using MyBatis, so it is possible to identify query parameters using the #{param} syntax.
description varchar 1000  √  null Technical description for the query.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
name Primary key Asc query_pkey

Close relationships  within of separation:

Excluded from diagram's relationships: approle_appgroup.change_action  user_pword_expiry.pword_change_user  appuser.change_action  appuser_appgroup.change_action  appuser.change_user  appuser_appgroup.change_time  appuser.rowidentifier  approle_appgroup.rowidentifier  appuser_appgroup.change_user  extracted_rows.rowidentifier  appuser_appgroup.rowversion  approle_appgroup.change_user  appuser_appgroup.rowidentifier  approle_appgroup.rowversion  appuser.rowversion  approle_appgroup.change_time  appuser.change_time