Schema
public
Owner
waveuser002
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 |
Foreign Keys
There are no foreign keys for table tbgeowms
Checks
Name | Condition | Description |
---|---|---|
chk_tbgeowms_dlvisible |
dlvisible = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
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
Options
Option | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbgeowms (
dnkey SERIAL,
dvsourcelink VARCHAR(200),
dvlaagnaam VARCHAR(200),
dvlabel VARCHAR(50),
dlvisible CHAR(1) DEFAULT 'F'::bpchar,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbgeowms PRIMARY KEY(dnkey),
CONSTRAINT chk_tbgeowms_dlvisible CHECK (dlvisible = ANY (ARRAY['F'::bpchar, 'T'::bpchar]))
)
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';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 11-3-2015 13:51 |
![]() ![]() ![]() |