oskari_appsetup

6 rows


Description

Map views/appsetups

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uuid uuid 2147483647 null
id bigserial 19 nextval('portti_view_id_seq'::regclass)
oskari_appsetup_bundles.appsetup_id portti_view_bundle_seq_view_id_fkeyC
name text 2147483647 null
is_default bool 1 false
type varchar 16 'USER'::character varying
description text 2147483647 null
page varchar 128 'index'::character varying
application text 2147483647 'servlet'::character varying
only_uuid bool 1 false
creator int8 19 '-1'::integer
domain text 2147483647 ''::character varying
lang varchar 2 'en'::character varying
is_public bool 1 false
metadata text 2147483647 '{}'::text
created timestamp 29,6 CURRENT_TIMESTAMP
used timestamp 29,6 now()
usagecount int8 19 0

Indexes

Constraint Name Type Sort Column(s)
portti_view_pkey Primary key Asc id
portti_view_uuid_key Must be unique Asc uuid

Relationships