Tables


SchemaSpy Analysis of oskaridb

Generated on Mon Oct 28 18:34 EET 2019

XML Representation
Insertion Order Deletion Order
TABLES 42
VIEWS 7
COLUMNS 394

Database Properties

Database Type: PostgreSQL - 9.3.25

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
oskari_permission 0 1 5 -1 Table

Permissions for resources

portti_bundle 1 0 5 -1 Table

List of available front-end functionality modules

oskari_role_oskari_user 0 2 3 -1 Table

Bridge table connecting role and user

spatial_ref_sys 0 0 5 3911 Table
user_layer_data 0 1 8 -1 Table

User imported layer features

oskari_jaas_users 0 0 3 -1 Table

Credentials for users when using built-in login

oskari_wfs_search_channels 0 0 6 -1 Table

Configuration for using WFS-services as search services

oskari_users 2 0 7 -1 Table

Oskari instance user accounts

oskari_role_external_mapping 0 1 3 -1 Table

For mapping roles from external system to Oskari roles (requires custom code to use)

portti_view_bundle_seq 0 2 7 -1 Table

Bundles present in a view/appsetup and their loading order

user_layer 1 1 11 -1 Table

Vector layer imported by user

portti_wfs_layers_styles 0 2 3 -1 Table

Bridge table between style and “transport” vector layer

oskari_maplayer_externalid 0 1 2 -1 Table

Legacy “external id” associated with map layer

portti_layer_keywords 0 2 2 -1 Table

Bridge table linking map layers and keywords describing them

oskari_user_indicator_data 0 2 5 -1 Table

Data for statistical indicators created by users

oskari_users_pending 0 0 5 -1 Table

Users that have started registration process but not completed it yet (used when end-user registration is enabled)

user_layer_style 1 0 15 -1 Table

Styles for user imported layer

oskari_resource 1 0 3 -1 Table

Declares resources representing a map layer or functionality that permissions are linked to

oskari_capabilities_cache 0 0 7 -1 Table

Cache of GetCapabilities results for WMS/WMTS layers

oskari_wfs_parser_config 0 0 8 -1 Table

Configuration for WFS parser describing parsing instructions for complex features

oskari_maplayer_group 1 0 5 -1 Table

Logical group for layers

my_places 0 0 11 -1 Table

User generated place marks (myplaces)

oskari_maplayer_group_link 0 2 3 -1 Table

Bridge table between map layer and its group

oskari_backendstatus 0 1 5 -1 Table

Results of layer data source availability probes

oskari_statistical_layer 0 2 3 -1 Table

Link map layers with region geometry to statistical data sources (based on data available on the data source)

oskari_roles 2 0 3 -1 Table

Roles that have associated permissions

portti_wfs_template_model 0 0 7 -1 Table

Templates for oskari_wfs_parser_config

portti_keywords 3 0 5 -1 Table

Keywords that can be associated with resources

oskari_statistical_datasource 1 0 4 -1 Table

Data source for statistical data (thematic maps)

categories 0 0 19 -1 Table

Layers including styles for user generated myplaces data

oskari_maplayer_projections 0 1 3 -1 Table

Supported projections (EPSG-codes) for map layers

oskari_user_indicator 1 1 6 -1 Table

Metadata for statistical indicators created by users

gt_pk_metadata_table 0 0 6 -1 Table

Defines user layer data tables

oskari_dataprovider 1 0 2 -1 Table

Layer data provider name localizations

portti_wfs_layer 1 0 28 -1 Table

Additional information about WFS-services for the “transport” vector layer implementation

oskari_maplayer 7 1 32 -1 Table

Map layers configuration

oskari_terms_of_use_for_publishing 0 0 3 -1 Table

Approval of terms for publishing by user

ratings 0 0 8 -1 Table

Table for rating metadata/anything really (not used currently)

portti_wfs_layer_style 1 0 3 -1 Table

Style SLD for “transport” vector layers

portti_keyword_association 0 2 3 -1 Table

Conceptual linking of keywords

oskari_maplayer_metadata 0 0 5 -1 Table

Metadata about map layers

portti_view 1 0 19 -1 Table

Map views/appsetups

geography_columns 0 0 7 0 View
vuser_layer_data 0 0 8 0 View

WFS-service view for user layer data (for GeoServer converting properties column type from JSON to TEXT)

geometry_columns 0 0 7 0 View
my_places_categories 0 0 28 0 View

View linking style used with users’ saved place marks

user_layer_data_style 0 0 23 0 View

View linking style used with user imported layer

raster_columns 0 0 16 0 View
raster_overviews 0 0 9 0 View