| SchemaSpy Analysis of sola.systemExtension 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 | |
| Database Type: PostgreSQL - 9.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Comments |
|---|---|---|---|---|
| active_users | 2 | Identifies the users currently active in the system. If the users password has expired, then they are treated as inactive users, unless they are System Administrators. This view is intended to replace the system.appuser table in the SolaRealm configuration in Glassfish. | ||
| appgroup | 2 | 3 | Groups application security roles to simplify assignment of roles to individual system users. Tags: FLOSS SOLA Extension, User Admin |
|
| approle | 1 | 4 | Contains the list of application security roles used to restrict access to different parts of the application, both on the server and client side. Tags: FLOSS SOLA Extension, Reference Table, User Admin |
|
| approle_appgroup | 2 | 7 | Associates the application security roles to the groups. One role can exist in many groups. Tags: FLOSS SOLA Extension, User Admin |
|
| appuser | 3 | 16 | The list of users that can have access to the SOLA application. Tags: FLOSS SOLA Extension, User Admin |
|
| appuser_appgroup | 2 | 7 | Associates users to groups. Each user can be assigned multiple groups. Tags: FLOSS SOLA Extension, User Admin |
|
| appuser_setting | 1 | 4 | Software settings specific for a user within the SOLA application. Not used by SOLA. Tags: FLOSS SOLA Extension, User Admin, Not Used |
|
| br | 2 | 1 | 6 | Provides a description of the business rules used by SOLA. Tags: FLOSS SOLA Extension, Business Rules |
| br_current | 4 | Determines the currently active business rules based on the active_from, active_to date range | ||
| br_definition | 1 | 4 | Contains the code definition for business rules used by SOLA. These rules can be assigned an active date range allowing new rules to superseed old rules at specific dates. Tags: FLOSS SOLA Extension, Business Rules |
|
| br_report | 11 | Used in the generation of the Admin Business Rules Report that presents summary details for all active business rules in the system. | ||
| br_severity_type | 1 | 4 | The severity types applicable to the SOLA business rules. Tags: FLOSS SOLA Extension, Reference Table, Business Rules |
|
| br_technical_type | 1 | 4 | Codes use for each type of rule implementation supported by SOLA. Curently SQL and Drools, however no Drools rules have been developed. Tags: FLOSS SOLA Extension, Reference Table, Business Rules |
|
| br_validation | 8 | 10 | Identifies the set of rules to execute based on the user action being peformed. E.g. approval of an application, cancellation of a service, etc. Tags: FLOSS SOLA Extension, Business Rules |
|
| br_validation_target_type | 1 | 4 | Lists potential targets for the business rules. Tags: FLOSS SOLA Extension, Reference Table, Business Rules |
|
| config_map_layer | 2 | 3 | 21 | Identifies the layers available for display in the SOLA Map Viewer. Tags: FLOSS SOLA Extension, Reference Table, Map Configuration |
| config_map_layer_metadata | 1 | 4 | ||
| config_map_layer_type | 1 | 4 | Lists the map layer types for the config_map_layer table. Tags: FLOSS SOLA Extension, Reference Table, Map Configuration |
|
| config_panel_launcher | 2 | 1 | 8 | Configuration data used by the PanelLauncher to determine the appropriate panel or form to display to the user when starting a Service or opening an RRR. Tags: FLOSS SOLA Extension, Reference Table |
| consolidation_config | 8 | This table contains the list of instructions to run the consolidation process. | ||
| crs | 4 | Identifies the coordinate reference system(s) (CRS) available to the Map Viewer. If there is more than one CRS defined, the user has the option to select the CRS to use for displaying features in the Map Viewer. The CRS with the lowest item_order will be the default CRS and used for the initial display of the map. The extent values defined in the system.setting table must be in the context of the default CRS. The from_long, to_long values define valid longitude values for each CRS in WGS84. These values can be used for various purposes such as assigning or transforming geometries into the appropraite storage CRS before being saved to the database. Tags: FLOSS SOLA Extension, Reference Table, Map Configuration |
||
| 13 | Table for email messages to be sent. | |||
| extracted_rows | 2 | It logs every record that has been extracted from this database for consolidation purposes. | ||
| Function: consolidation_consolidate | 0 | Moves records from the temporary consolidation schema into the main SOLA tables. Used by the bulk consolidation process. | ||
| Function: consolidation_extract | 0 | Extracts records from SOLA that are marked for transfer to another SOLA database. | ||
| Function: get_setting | 0 | Returns the value for a specified system setting. | ||
| Function: get_text_from_schema | 0 | Generates a script representing the named SOLA database schema including data held in any tables. Used by the bulk consolidation process | ||
| Function: script_to_schema | 0 | Used to convert a script generated by get_text_from_schema into a database schema as well as load data into it. | ||
| Function: setpassword | 0 | Changes the users password. | ||
| language | 6 | Lists the languages configured for the SOLA application Tags: FLOSS SOLA Extension, Reference Table, System Configuration |
||
| map_search_option | 1 | 7 | Identifies the map search options supported in the Map Viewer along with their configuration details. Tags: FLOSS SOLA Extension, Reference Table, Map Configuration |
|
| panel_launcher_group | 1 | 4 | Used to group the panel launcher configuration values to make the PanelLancher logic flexible. Tags: FLOSS SOLA Extension, Reference Table |
|
| query | 4 | 3 | 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 |
|
| query_field | 1 | 4 | Optionally defines the fields returned by the queries listed in the system.query table. It is not necessary to specify query fields for every dynamic query. Query fields are only required where the results displayed to the user will vary and localization of the field titles is required. For example the Information Tool in the map displays different result fields for each map layer in the same form. Tags: FLOSS SOLA Extension, Reference Table, System Configuration |
|
| setting | 4 | Contains global settings for the SOLA application. Refer to the Administration Guide or the ConfigConstants class in the Common Utilities project for a list of the recognized settings. Note that not all possible settings are listed in the settings table. Settings may be omitted from this table if the default value applies. Tags: FLOSS SOLA Extension, Reference Table, System Configuration |
||
| user_pword_expiry | 5 | Determines the number of days until the users password expires. Once the number of days reaches 0, users will not be able to log into SOLA unless they have the ManageSecurity role (i.e. role to change manage user accounts) or the NoPasswordExpiry role. To configure the number of days before a password expires, set the pword-expiry-days setting in system.setting table. If this setting is not in place, then a password expiry does not apply. | ||
| user_roles | 2 | Determines the application security roles assigned to each user. Referenced by the SolaRealm security configuration in Glassfish. | ||
| version | 1 | Identifies all changesets that have been applied to the SOLA database. The latest changeset applied to the database will indicate the current version of the SOLA database and code. Changesets are named using the year, month and a sequence character. E.g. The first changeset in Feb 2014 is 1402a, the second changeset in Feb 2014 is 1402b, etc. The sequence character must restart for each new month. E.g. in March 2014 the first changeset is 1403a. Tags: FLOSS SOLA Extension, System Configuration |
||
| 33 Tables | 166 | |||
| 5 Views | 24 |