oskari_maplayer

11 rows


Description

Map layers configuration

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('oskari_maplayer_id_seq'::regclass)
oskari_backendstatus.maplayer_id oskari_backendstatus_maplayer_id_fkeyC
oskari_maplayer_externalid.maplayerid oskari_maplayer_externalid_maplayerid_fkeyC
oskari_maplayer_group_link.maplayerid oskari_maplayer_id_fkeyC
oskari_maplayer_projections.maplayerid oskari_maplayer_id_fkeyC
oskari_statistical_datasource_regionsets.layer_id oskari_statistical_layer_layer_id_fkeyC
oskari_statistical_indicator_data.regionset_id oskari_user_indicator_regionset_fkeyR
portti_layer_keywords.layerid oskari_layer_keywords_layerid_fkeyC
parentid int4 10 '-1'::integer
type varchar 50 null
base_map bool 1 false
dataprovider_id int4 10 null
oskari_dataprovider.id oskari_maplayer_groupid_fkeyC
name varchar 2000 null
url varchar 2000 null
locale text 2147483647 null
opacity int4 10 100
style varchar 100 null
minscale float8 17,17 '-1'::integer
maxscale float8 17,17 '-1'::integer
legend_image varchar 2000 null
metadataid varchar 200 null
params text 2147483647 '{}'::text
options text 2147483647 '{}'::text
gfi_type varchar 200 null
gfi_xslt text 2147483647 null
gfi_content text 2147483647 null
realtime bool 1 false
refresh_rate int4 10 0
created timestamptz 35,6 CURRENT_TIMESTAMP
updated timestamptz 35,6 null
username varchar 256 null
password varchar 256 null
srs_name varchar 2147483647 null
version varchar 64 ''::character varying
attributes text 2147483647 '{}'::text
capabilities text 2147483647 '{}'::text
capabilities_last_updated timestamptz 35,6 null
capabilities_update_rate_sec int4 10 0
internal bool 1 false

Indexes

Constraint Name Type Sort Column(s)
oskari_maplayer_pkey Primary key Asc id
oskari_maplayer_q1 Performance Asc parentid
oskari_maplayer_q2 Performance Asc dataprovider_id

Relationships