Tables


SchemaSpy Analysis of oskaridb

Generated on Fri Mar 15 14:09 EET 2024

XML Representation
Insertion Order Deletion Order
TABLES 37
VIEWS 3
COLUMNS 250

Database Properties

Database Type: PostgreSQL - 12.17

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 8 0 Table

Metadata for statistical indicators created by users

oskari_appsetup 1 0 18 7 Table

Map views/appsetups

spatial_ref_sys 0 0 5 8500 Table
oskari_roles_external_mapping 0 1 3 0 Table

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

oskari_ratings 0 0 8 0 Table

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

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_announcements 0 0 5 0 Table
oskari_users 3 0 9 3 Table

Oskari instance user accounts

oskari_wfs_search_channels 0 0 6 0 Table

Configuration for using WFS-services as search services

oskari_resource_permission 0 1 5 32 Table

Permissions for resources

user_layer 1 0 12 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 7 Table

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

oskari_maplayer_group 1 0 5 3 Table

Logical group for layers

my_places 0 0 11 0 Table

User generated place marks (myplaces)

oskari_bundle 1 0 4 69 Table

List of available front-end functionality modules

oskari_maplayer_group_link 0 2 3 7 Table

Bridge table between map layer and its group

oskari_users_roles 0 2 3 4 Table

Bridge table connecting role and user

oskari_appsetup_bundles 0 2 6 125 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 7 0 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 8 1 32 9 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

oskari_maplayer_style 0 2 8 4 Table

Style configurations for vector maplayers

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