SchemaSpy Analysis of sola.system - ColumnsExtension to the LADM that contains SOLA system configuration, business rules and user details. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:59 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.system contains 190 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
approle_appgroup change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
appuser change_action bpchar 1 'i'::bpchar
appuser_appgroup change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
br_definition active_until date 13 'infinity'::date The date until this version of the rule is active.
config_panel_launcher status bpchar 1 't'::bpchar Status of this configuration record.
panel_launcher_group status bpchar 1 't'::bpchar Status of this panel launcher group
config_map_layer item_order int4 10 0 The order to use for display of layers in the layer control. The layer with the lowest number will be displayed at the bottom of the layer control.
br_validation order_of_execution int4 10 0 Number used to order the execution of business rules in the rule set.
approle_appgroup rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
appuser rowversion int4 10 0
appuser_appgroup rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
email attempt int4 10 1 Number of attempt of sending message.
language item_order int4 10 1 The order the langages should be displayed. The lowest order number will display the langage at the top of the language list. Also identifies the order that all localized string values must store their language translations.
map_search_option min_search_str_len int2 5 3 The minimum number of characters required for the search string.
map_search_option zoom_in_buffer numeric 20,2 50 The buffer distance to use when zooming the map to display the selected object. The units of this value are dependent on the coordinate system of the map (usually meters).
config_map_layer added_from_bulk_operation bool 1 false Flag to indicate the layer was added when using the SOLA Bulk Operation feature.
config_map_layer_metadata for_client bool 1  √  false Indicates whether an option is for use by the client or server. If true, it's supposed to be used by the client map control, otherwise option is sent to the server.
language is_default bool 1 false Indicates the default language used by SOLA. Only one record in the table should have is_default = true.
consolidation_config remove_before_insert bool 1 false True - The records in the destination will be removed if they are found in the new extract. The check is done in rowidentifier.
config_map_layer use_in_public_display bool 1 false Flag to indicate if the layer must be visible when printing the public display map. Not relevant for other kinds of map operations.
approle_appgroup change_time timestamp 29,6 now() The date and time the row was last modified.
appuser change_time timestamp 29,6 now()
appuser_appgroup change_time timestamp 29,6 now() The date and time the row was last modified.
email time_to_send timestamp 29,6 now() Date and time when to send the message.
appuser activation_code varchar 40  √  null
appuser activation_expiration timestamp 29,6  √  null Account activation timeout. It can be used to delete account if it was not activated in time.
br_definition active_from date 13 The date this version of the rule is active from.
approle_appgroup appgroup_id varchar 40 Identifier for the group the role is associated to.
appuser_appgroup appgroup_id varchar 40 Identifier for the group the user is associated to.
approle_appgroup approle_code varchar 20 Code for the security role.
appuser_appgroup appuser_id varchar 40 Identifier for the SOLA user.
email attachment bytea 2147483647  √  null Attachment file to send
email attachment_mime_type varchar 250  √  null attachment_mime_type
email attachment_name varchar 250  √  null Attachment file name
email bcc varchar 5000  √  null List of names and email address to send a blind copy of the message
br_current body varchar 4000  √  null
br_definition body varchar 4000 The definition of the rule. Either SQL commands or Drools XML.
br_report body varchar 4000  √  null
email body varchar 8000 Message body
br_definition br_id varchar 100 Identifier for the business rule
br_validation br_id varchar 100 The business rule referenced by this br validation record.
config_panel_launcher card_name varchar 50  √  null The MainContentPanel card name for the panel to launch
email cc varchar 5000  √  null List of names and email address to send a copy of the message
approle_appgroup change_user varchar 50  √  null The user id of the last person to modify the row.
appuser change_user varchar 50  √  null
appuser_appgroup change_user varchar 50  √  null The user id of the last person to modify the row.
approle code varchar 20 Code for the security role. Must match exactly the code value used within the SOLA source code to reference the role.
br_severity_type code varchar 20 Code for the severity type.
br_technical_type code varchar 20 Code for the technical type.
br_validation_target_type code varchar 20 Code for the validation target type.
config_map_layer_type code varchar 20 Code for the map layer type.
config_panel_launcher code varchar 20 The code for the panel to launch
language code varchar 7 Code for the langauge.
map_search_option code varchar 20 The code for the map search option.
panel_launcher_group code varchar 20 The code for the panel launcher group
consolidation_config condition_description varchar 1000 Description of the condition has to be applied to rows of the source table for extraction.
consolidation_config condition_sql varchar 1000  √  null The SQL implementation of the condition.
appgroup description varchar 1000  √  null Describes the purpose of the appgroup and should also indicate when it applies.
approle description varchar 5000  √  null Describes the purpose of the role and should also indicate when it applies.
appuser description varchar 255  √  null
br description varchar 1000  √  null A description of the business rule. Intended for system administrators and end users.
br_report description varchar 1000  √  null
br_severity_type description varchar 1000  √  null A description of the severity type.
br_technical_type description varchar 1000  √  null A description of the technical type.
br_validation_target_type description varchar 5000  √  null A description of the validation target type.
config_map_layer_type description varchar 555  √  null A description of the map layer type.
config_panel_launcher description varchar 1000  √  null Description for the panel to launch
map_search_option description varchar 500  √  null A description for the search option.
panel_launcher_group description varchar 1000  √  null Description for the panel launcher group
query description varchar 1000  √  null Technical description for the query.
setting description varchar 555 Description of the setting.
approle display_value varchar 500 The text value that will be displayed to the user.
br_severity_type display_value varchar 500 The text value that will be displayed to the user.
br_technical_type display_value varchar 500 The text value that will be displayed to the user.
br_validation_target_type display_value varchar 500 The text value that will be displayed to the user.
config_map_layer_type display_value varchar 250 The text value that will be displayed to the user.
config_panel_launcher display_value varchar 500 The user friendly name for the panel to launch
language display_value varchar 250 The text value that will be displayed to the user.
panel_launcher_group display_value varchar 500 The user friendly name for the panel launcher group
query_field display_value varchar 200  √  null The title to display for the query field when presenting results to the user. This value supports localization.
appuser email varchar 40  √  null
email error varchar 5000  √  null Error message received when sending the message.
br feedback varchar 2000  √  null The message that should be displayed to the user if the rule is not complied with.
br_current feedback varchar 2000  √  null
br_report feedback varchar 2000  √  null
appuser first_name varchar 30 The first name of the SOLA user.
crs from_long float8 17,17  √  null The longitude in WGS84 identifying the where the CRS is valid from.
appgroup id varchar 40 Identifier for the appgroup.
appuser id varchar 40 The SOLA user identifier.
br id varchar 100 The name of the business rule
br_current id varchar 100  √  null
br_report id varchar 100  √  null
consolidation_config id varchar 100
email id varchar 40 Unique identifier of the record.
query_field index_in_query int4 10 Indicates the position of the result field in the query result set. The index is zero based. The number must not exceed the number of fields in the select part of the query.
crs item_order int4 10 Identifies the order the CRS is displayed in the drop down menu on the Map Viewer. The CRS with the lowest item order will be used as the default CRS for the initial display of the map.
appuser last_name varchar 30 The last name of the SOLA user.
user_pword_expiry last_pword_change timestamp 29,6  √  null
config_panel_launcher launch_group varchar 20 The launch group for the panel.
config_panel_launcher message_code varchar 50  √  null The code of the message to display when opening the panel. See the ClientMessage class for a list of codes.
appuser mobile_number varchar 20  √  null
br_report moment_code varchar 20  √  null
appgroup name varchar 600 The name assigned to the appgroup.
appuser_setting name varchar 50 The name of the setting.
config_map_layer name varchar 50 Name assigned to the map layer.
config_map_layer_metadata name varchar 50
query name varchar 100 Identifier/name for the query
query_field name varchar 100 Identifier/name for the query field
setting name varchar 50 Identifier/name for the setting
config_map_layer_metadata name_layer varchar 50
user_pword_expiry no_pword_expiry bool 1  √  null
br_report order_of_execution int4 10  √  null
consolidation_config order_of_execution int4 10 Order of execution of the extract.
config_panel_launcher panel_class varchar 100  √  null The full package and class name for the panel to launch. e.g. org.sola.clients.swing.desktop.administrative.PropertyPanel
active_users passwd varchar 100  √  null
config_map_layer pojo_query_name varchar 100  √  null The name of the query (i.e. system.query) used to retrieve features for this layer.
config_map_layer pojo_query_name_for_select varchar 100  √  null The name of the query to use to select objects corresponding to the layer. Can be used for any layer type
config_map_layer pojo_structure varchar 500  √  null Plain old java object structure. Must be specified in the same format as requried by the Geotools featuretype definition. E.g. theGeom:Polygon,label:""
user_pword_expiry pword_change_user varchar 50  √  null
user_pword_expiry pword_expiry_days int4 10  √  null
map_search_option query_name varchar 100 The query (i.e. system.query) that will be used for retrieving the search results. The query requires only one parameter : search_string. Map search queries must be defined to use this parameter and return 3 fields; id - unique id for the matched item, label - the value to display to the user, the_geom: the WKB of the matched geometry.
query_field query_name varchar 100 Identifier/name for the query
email recipient varchar 255 Email address of recipient.
email recipient_name varchar 255  √  null Name of recipient.
user_roles rolename varchar 20  √  null
extracted_rows rowidentifier varchar 40 The rowidentifier of the record. Carefull: It is the rowidentifier and not the id.
consolidation_config schema_name varchar 100 Name of the source schema.
config_map_layer security_password varchar 30  √  null The password to access a secure wms layer. Not currently used.
config_map_layer security_user varchar 30  √  null The username to access a secure wms layer. Not currently used.
br_report severity_code varchar 20  √  null
br_validation severity_code varchar 20 The severity of the business rule failure.
config_map_layer shape_location varchar 500  √  null The location of the shapefile. Used for layers of type shape. THe client application must have access to the shape file location.
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.
crs srid int4 10 The Spatial Reference Identifier (SRID) for the CRS.
approle status bpchar 1 The status of the role.
br_severity_type status bpchar 1 The status of the severity type.
br_technical_type status bpchar 1 The status of the technical type.
br_validation_target_type status bpchar 1 The status of the validation target type.
config_map_layer_type status bpchar 1 The status of the map layer type.
config_map_layer style varchar 4000  √  null An SLD document representing the styles to use for display of the layer features in the map.
email subject varchar 250 Subject of the message
consolidation_config table_name varchar 100 Name of the source table.
extracted_rows table_name varchar 200 The table where the record has been found. It has to be absolute table name including the schema name.
br_validation target_application_moment varchar 20  √  null Identifies the application action the rule applies to. E.g. approve, validate, etc. Only valid if target_code is application.
br_report target_code varchar 20  √  null
br_validation target_code varchar 20 The entity that is the target of the validation E.g. application, service, rrr, etc.
br_validation target_reg_moment varchar 20  √  null Identifies the entity status the rule applies to. E.g. current, pending, etc. Only valid if target_code is one of ba_unit, cadastre_object, source, rrr or bulkOperationSpatial.
br_report target_request_type_code varchar 20  √  null
br_validation target_request_type_code varchar 20  √  null Used as an additional filter for the set of business rules to run by ensuring the rule is only executed if the service type (a.k.a. request_type) matches the specified value.
br_report target_rrr_type_code varchar 20  √  null
br_validation target_rrr_type_code varchar 20  √  null Used as an additional filter for the set of business rules to run by ensuring the rule is only executed if the rrr type matches the specified value.
br_validation target_service_moment varchar 20  √  null Identifies the service action the rule applies to. E.g. complete, start, cancel, etc. Only valid if the target_code is service.
br technical_description varchar 1000  √  null A technical description of the business rule including any parameters the rule expects. Intended for developers.
br technical_type_code varchar 20 Indicates which engine must be used to run the business rule (sql or drools). Note that SOLA does not currently implement any Drools rules.
br_current technical_type_code varchar 20  √  null
br_report technical_type_code varchar 20  √  null
config_map_layer title varchar 100 The title used for the layer when it is displayed in the map control.
map_search_option title varchar 50 The title displayed to the user for the map search option.
crs to_long float8 17,17  √  null The longitude in WGS84 identifying the where the CRS is valid to.
config_map_layer type_code varchar 20 Indicates the source of data for the map layer. One of pojo (Plain Old Java Object - SOLA specific), wms (Web Map Service), shape (Shapefile)
user_pword_expiry uname varchar 40  √  null
config_map_layer url varchar 500  √  null The URL identifying the data source for a WMS layer.
appuser_setting user_id varchar 40 Identifier of the user the setting applies to.
active_users username varchar 40  √  null
appuser username varchar 40 The user name assigned to the SOLA user.
user_roles username varchar 40  √  null
config_map_layer_metadata value varchar 100
version version_num varchar 50 The version number for the changeset.
appuser_setting vl varchar 2000 The value of the setting
setting vl varchar 2000 The value for the setting.
config_map_layer wms_data_source varchar 200  √  null Description to display in the Map when the WMS layer is turned on.
config_map_layer wms_format varchar 15  √  null Format of the output for the WMS layer. Allowed values are as defined by the WMS server capabilities. E.g. image/png or image/jpeg.
config_map_layer wms_layers varchar 500  √  null The names of the layers to request when obtaining data from a Web Map Service. Layer names must be separated with a comma.
config_map_layer wms_version varchar 10  √  null The version of the WMS server. Values can be one of 1.0.0, 1.1.0, 1.1.1, 1.3.0.
appuser active bool 1 true
appuser_setting active bool 1 true Flag to indicate if the setting is active or not.
config_map_layer active bool 1 true Flag to indicate if the layer is active. Inactive layers are not displayed in the map layer control.
language active bool 1 true Indicates if the language is current active or not.
map_search_option active bool 1 true Indicates the Map Search Option is active or not.
setting active bool 1 true Indicates if the setting is active or not. If not active, the default value for the setting will apply.
consolidation_config log_in_extracted_rows bool 1 true True - If the records has to be logged in the extracted rows table.
language ltr bool 1 true Indicates text direction. If true, then left to right should applied, otherwise right to left.
config_map_layer use_for_ot bool 1 true Flag to indicate if the layer must be visible on open tenure map.
config_map_layer visible_in_start bool 1 true Flag to indicate if the layer should be turned on and display when the map initially displays
br display_name varchar 250 uuid_generate_v1() The display name for the business rule.
br_validation id varchar 40 uuid_generate_v1() Identifier for the br validation
appuser passwd varchar 100 uuid_generate_v1()
approle_appgroup rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the system.approle_appgroup_historic table
appuser rowidentifier varchar 40 uuid_generate_v1()
appuser_appgroup rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the system.appuser_appgroup_historic table