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 |
| ||||||
|
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 | ||
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 | ||
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 | |
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 | varchar | 40 | √ | null | ||
appgroup | id | varchar | 40 | |||
appuser | id | varchar | 40 | |||
br_validation | id | varchar | 40 | uuid_generate_v1() | ||
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 | |
attachment_mime_type | varchar | 250 | √ | null | ||
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 | |||
subject | varchar | 250 | ||||
appuser | description | varchar | 255 | √ | null | |
recipient | varchar | 255 | ||||
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 | |
bcc | varchar | 5000 | √ | null | ||
cc | varchar | 5000 | √ | null | ||
approle | description | varchar | 5000 | √ | null | |
br_validation_target_type | description | varchar | 5000 | √ | null | |
error | varchar | 5000 | √ | null | ||
body | varchar | 8000 |