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
appuser active bool 1 true
appuser_setting active bool 1 true
config_map_layer active bool 1 true
language active bool 1 true
map_search_option active bool 1 true
setting active bool 1 true
config_map_layer added_from_bulk_operation bool 1 false
config_map_layer_metadata for_client bool 1  √  false
language is_default bool 1 false
consolidation_config log_in_extracted_rows bool 1 true
language ltr bool 1 true
user_pword_expiry no_pword_expiry bool 1  √  null
consolidation_config remove_before_insert bool 1 false
config_map_layer use_for_ot bool 1 true
config_map_layer use_in_public_display bool 1 false
config_map_layer visible_in_start bool 1 true
approle_appgroup change_action bpchar 1 'i'::bpchar
appuser change_action bpchar 1 'i'::bpchar
appuser_appgroup change_action bpchar 1 'i'::bpchar
approle status bpchar 1
br_severity_type status bpchar 1
br_technical_type status bpchar 1
br_validation_target_type status bpchar 1
config_map_layer_type status bpchar 1
config_panel_launcher status bpchar 1 't'::bpchar
panel_launcher_group status bpchar 1 't'::bpchar
email attachment bytea 2147483647  √  null
br_definition active_from date 13
br_definition active_until date 13 'infinity'::date
crs from_long float8 17,17  √  null
crs to_long float8 17,17  √  null
map_search_option min_search_str_len int2 5 3
email attempt int4 10 1
query_field index_in_query int4 10
config_map_layer item_order int4 10 0
crs item_order int4 10
language item_order int4 10 1
br_report order_of_execution int4 10  √  null
br_validation order_of_execution int4 10 0
consolidation_config order_of_execution int4 10
user_pword_expiry pword_expiry_days int4 10  √  null
approle_appgroup rowversion int4 10 0
appuser rowversion int4 10 0
appuser_appgroup rowversion int4 10 0
crs srid int4 10
map_search_option zoom_in_buffer numeric 20,2 50
appuser activation_expiration timestamp 29,6  √  null
approle_appgroup change_time timestamp 29,6 now()
appuser change_time timestamp 29,6 now()
appuser_appgroup change_time timestamp 29,6 now()
user_pword_expiry last_pword_change timestamp 29,6  √  null
email time_to_send timestamp 29,6 now()
language code varchar 7
config_map_layer wms_version varchar 10  √  null
config_map_layer wms_format varchar 15  √  null
approle_appgroup approle_code varchar 20
approle code varchar 20
br_severity_type code varchar 20
br_technical_type code varchar 20
br_validation_target_type code varchar 20
config_map_layer_type code varchar 20
config_panel_launcher code varchar 20
map_search_option code varchar 20
panel_launcher_group code varchar 20
config_panel_launcher launch_group varchar 20
appuser mobile_number varchar 20  √  null
br_report moment_code varchar 20  √  null
user_roles rolename varchar 20  √  null
br_report severity_code varchar 20  √  null
br_validation severity_code varchar 20
br_validation target_application_moment varchar 20  √  null
br_report target_code varchar 20  √  null
br_validation target_code varchar 20
br_validation target_reg_moment varchar 20  √  null
br_report target_request_type_code varchar 20  √  null
br_validation target_request_type_code varchar 20  √  null
br_report target_rrr_type_code varchar 20  √  null
br_validation target_rrr_type_code varchar 20  √  null
br_validation target_service_moment varchar 20  √  null
br technical_type_code varchar 20
br_current technical_type_code varchar 20  √  null
br_report technical_type_code varchar 20  √  null
config_map_layer type_code varchar 20
appuser first_name varchar 30
appuser last_name varchar 30
config_map_layer security_password varchar 30  √  null
config_map_layer security_user varchar 30  √  null
appuser activation_code varchar 40  √  null
approle_appgroup appgroup_id varchar 40
appuser_appgroup appgroup_id varchar 40
appuser_appgroup appuser_id varchar 40
appuser email varchar 40  √  null
appgroup id varchar 40
appuser id varchar 40
br_validation id varchar 40 uuid_generate_v1()
email id varchar 40
approle_appgroup rowidentifier varchar 40 uuid_generate_v1()
appuser rowidentifier varchar 40 uuid_generate_v1()
appuser_appgroup rowidentifier varchar 40 uuid_generate_v1()
extracted_rows rowidentifier varchar 40
user_pword_expiry uname varchar 40  √  null
appuser_setting user_id varchar 40
active_users username varchar 40  √  null
appuser username varchar 40
user_roles username varchar 40  √  null
config_panel_launcher card_name varchar 50  √  null
approle_appgroup change_user varchar 50  √  null
appuser change_user varchar 50  √  null
appuser_appgroup change_user varchar 50  √  null
config_panel_launcher message_code varchar 50  √  null
appuser_setting name varchar 50
config_map_layer name varchar 50
config_map_layer_metadata name varchar 50
setting name varchar 50
config_map_layer_metadata name_layer varchar 50
user_pword_expiry pword_change_user varchar 50  √  null
map_search_option title varchar 50
version version_num varchar 50
br_definition br_id varchar 100
br_validation br_id varchar 100
br id varchar 100
br_current id varchar 100  √  null
br_report id varchar 100  √  null
consolidation_config id varchar 100
query name varchar 100
query_field name varchar 100
config_panel_launcher panel_class varchar 100  √  null
active_users passwd varchar 100  √  null
appuser passwd varchar 100 uuid_generate_v1()
config_map_layer pojo_query_name varchar 100  √  null
config_map_layer pojo_query_name_for_select varchar 100  √  null
map_search_option query_name varchar 100
query_field query_name varchar 100
consolidation_config schema_name varchar 100
consolidation_config table_name varchar 100
config_map_layer title varchar 100
config_map_layer_metadata value varchar 100
query_field display_value varchar 200  √  null
extracted_rows table_name varchar 200
config_map_layer wms_data_source varchar 200  √  null
email attachment_mime_type varchar 250  √  null
email attachment_name varchar 250  √  null
br display_name varchar 250 uuid_generate_v1()
config_map_layer_type display_value varchar 250
language display_value varchar 250
email subject varchar 250
appuser description varchar 255  √  null
email recipient varchar 255
email recipient_name varchar 255  √  null
map_search_option description varchar 500  √  null
approle display_value varchar 500
br_severity_type display_value varchar 500
br_technical_type display_value varchar 500
br_validation_target_type display_value varchar 500
config_panel_launcher display_value varchar 500
panel_launcher_group display_value varchar 500
config_map_layer pojo_structure varchar 500  √  null
config_map_layer shape_location varchar 500  √  null
config_map_layer url varchar 500  √  null
config_map_layer wms_layers varchar 500  √  null
config_map_layer_type description varchar 555  √  null
setting description varchar 555
appgroup name varchar 600
consolidation_config condition_description varchar 1000
consolidation_config condition_sql varchar 1000  √  null
appgroup description varchar 1000  √  null
br description varchar 1000  √  null
br_report description varchar 1000  √  null
br_severity_type description varchar 1000  √  null
br_technical_type description varchar 1000  √  null
config_panel_launcher description varchar 1000  √  null
panel_launcher_group description varchar 1000  √  null
query description varchar 1000  √  null
br technical_description varchar 1000  √  null
br feedback varchar 2000  √  null
br_current feedback varchar 2000  √  null
br_report feedback varchar 2000  √  null
appuser_setting vl varchar 2000
setting vl varchar 2000
br_current body varchar 4000  √  null
br_definition body varchar 4000
br_report body varchar 4000  √  null
query sql varchar 4000
config_map_layer style varchar 4000  √  null
email bcc varchar 5000  √  null
email cc varchar 5000  √  null
approle description varchar 5000  √  null
br_validation_target_type description varchar 5000  √  null
email error varchar 5000  √  null
email body varchar 8000