Database Properties
Database Type: PostgreSQL - 12.16
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_wfs_search_channels | 0 | 0 | 6 | 0 | Table | Configuration for using WFS-services as search services |
| oskari_users | 3 | 0 | 7 | 3 | Table | Oskari instance user accounts |
| oskari_resource_permission | 0 | 1 | 5 | 42 | 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 | 9 | 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_maplayer_group_link | 0 | 2 | 3 | 9 | Table | Bridge table between map layer and its group |
| oskari_bundle | 1 | 0 | 4 | 68 | 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 | 122 | 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 | 2 | 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 | 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 |
| oskari_maplayer_style | 0 | 2 | 8 | 5 | 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 |