Datadictionary OpenWave 3.1.11 |
|
Table: tbgeowms
Datadictionary OpenWave 3.1.11 |
|
Table: tbgeowms
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van kaartlagen die getoond worden op de kaartjes van OWB
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbgeowms_dnkey_seq'::regclass) |
Primary key. |
|
|
dvsourcelink |
varchar(200) |
|
|
|
|
Url van service die kaartlaag levert |
|
|
dvlaagnaam |
varchar(200) |
|
|
|
|
Naam van de kaartlaag op de service die de laag levert |
|
|
dvlabel |
varchar(50) |
|
|
|
|
Label in OWB waaronder de laag is aan/uit te klikken. |
|
|
dlvisible |
char(1) |
|
|
|
'F'::bpchar |
Kaartlaag default aan of uitgevinkt. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarop kaartlaag is komen te vervallen |
|
|
dlisbasislaag |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is de kaartlaag een niet transparante basislaag |
|
|
dnvolgnr |
integer |
|
|
|
|
Volgordenummer kaartlaag |
|
|
dnopacity |
integer |
|
|
|
|
Percentage doorzichtigheid (geldt niet voor basislagen) |
Foreign Keys
There are no foreign keys for table tbgeowms
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbgeowms_dlisbasislaag |
dlisbasislaag = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbgeowms_dlvisible |
dlvisible = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_tbgeowms_dlisbasislaag |
dlisbasislaag IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbgeowms |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbgeowms
Rules
There are no rules for table tbgeowms
Referenced
There are no tables referenced by table tbgeowms
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvsourcelink VARCHAR(200),
dvlaagnaam VARCHAR(200),
dvlabel VARCHAR(50),
dlvisible CHAR(1) DEFAULT 'F'::bpchar,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dlisbasislaag CHAR(1) DEFAULT 'F'::bpchar,
dnvolgnr INTEGER,
dnopacity INTEGER,
CONSTRAINT cpk_tbgeowms PRIMARY KEY(dnkey),
CONSTRAINT chk_tbgeowms_dlisbasislaag CHECK (dlisbasislaag = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_tbgeowms_dlvisible CHECK (dlvisible = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_tbgeowms_dlisbasislaag CHECK (dlisbasislaag IS NOT NULL)
)
WITH (oids = false);
COMMENT ON TABLE public.tbgeowms
IS 'Tabel van kaartlagen die getoond worden op de kaartjes van OWB';
COMMENT ON COLUMN public.tbgeowms.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbgeowms.dvsourcelink
IS 'Url van service die kaartlaag levert';
COMMENT ON COLUMN public.tbgeowms.dvlaagnaam
IS 'Naam van de kaartlaag op de service die de laag levert';
COMMENT ON COLUMN public.tbgeowms.dvlabel
IS 'Label in OWB waaronder de laag is aan/uit te klikken.';
COMMENT ON COLUMN public.tbgeowms.dlvisible
IS 'Kaartlaag default aan of uitgevinkt.';
COMMENT ON COLUMN public.tbgeowms.ddvervaldatum
IS 'Datum waarop kaartlaag is komen te vervallen';
COMMENT ON COLUMN public.tbgeowms.dlisbasislaag
IS 'T of F. Indien T dan is de kaartlaag een niet transparante basislaag';
COMMENT ON COLUMN public.tbgeowms.dnvolgnr
IS 'Volgordenummer kaartlaag ';
COMMENT ON COLUMN public.tbgeowms.dnopacity
IS 'Percentage doorzichtigheid (geldt niet voor basislagen) ';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|