Tables


SchemaSpy Analysis of oskaridb

Generated on Fri Sep 18 18:58 EEST 2020

XML Representation
Insertion Order Deletion Order
TABLES 36
VIEWS 5
COLUMNS 263

Database Properties

Database Type: PostgreSQL - 10.14

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
oskari_users_credentials 0 0 3 3 Table

Credentials for users when using built-in login

oskari_statistical_indicator 1 1 6 0 Table

Metadata for statistical indicators created by users

oskari_appsetup 1 0 17 6 Table

Map views/appsetups

spatial_ref_sys 0 0 5 5757 Table
oskari_ratings 0 0 8 0 Table

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

oskari_roles_external_mapping 0 1 3 0 Table

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

user_layer_data 0 1 8 0 Table

User imported layer features

oskari_statistical_datasource_regionsets 0 2 3 6 Table

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

oskari_wfs_search_channels 0 0 6 0 Table

Configuration for using WFS-services as search services

oskari_users 2 0 7 3 Table

Oskari instance user accounts

oskari_resource_permission 0 1 5 42 Table

Permissions for resources

user_layer 1 0 11 0 Table

Vector layer imported by user

oskari_maplayer_externalid 0 1 2 0 Table

Legacy “external id” associated with map layer

portti_layer_keywords 0 2 2 0 Table

Bridge table linking map layers and keywords describing them

oskari_users_pending 0 0 5 0 Table

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

oskari_resource 1 0 3 9 Table

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

oskari_capabilities_cache 0 0 7 2 Table

Cache of GetCapabilities results for WMS/WMTS layers

oskari_maplayer_group 1 0 5 3 Table

Logical group for layers

my_places 0 0 11 1 Table

User generated place marks (myplaces)

oskari_maplayer_group_link 0 2 3 9 Table

Bridge table between map layer and its group

oskari_bundle 1 0 4 59 Table

List of available front-end functionality modules

oskari_users_roles 0 2 3 4 Table

Bridge table connecting role and user

oskari_appsetup_bundles 0 2 6 92 Table

Bundles present in a view/appsetup and their loading order

oskari_backendstatus 0 1 5 0 Table

Results of layer data source availability probes

oskari_roles 2 0 3 3 Table

Roles that have associated permissions

portti_keywords 3 0 5 0 Table

Keywords that can be associated with resources

oskari_statistical_datasource 1 0 4 6 Table

Data source for statistical data (thematic maps)

categories 0 0 6 1 Table

Layers including styles for user generated myplaces data

oskari_maplayer_projections 0 1 3 0 Table

Supported projections (EPSG-codes) for map layers

gt_pk_metadata_table 0 0 6 1 Table

Defines user layer data tables

oskari_dataprovider 1 0 2 4 Table

Layer data provider name localizations

oskari_statistical_indicator_data 0 2 5 0 Table

Data for statistical indicators created by users

oskari_maplayer 7 1 32 11 Table

Map layers configuration

oskari_terms_of_use_for_publishing 0 0 3 0 Table

Approval of terms for publishing by user

portti_keyword_association 0 2 3 0 Table

Conceptual linking of keywords

oskari_maplayer_metadata 0 0 5 0 Table

Metadata about map layers

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
raster_columns 0 0 17 0 View
raster_overviews 0 0 9 0 View