Datadictionary OpenWave 3.1.6
Previous topic Chapter index Next topic

Table: tbportalnames

 

 

Schema

public

 

Owner

waveuser002

 

Tablespace

(default)

 

Descriptions

Tabel met portaalnamen (OWB). Er is maximaal één rij met eigenschap dlisbegin = T.

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbportalnames_dnkey_seq'::regclass)

Primary key.

 

 

dvname

varchar(40)

 

 

 

 

Naam (identifier) van een portaal.

 

 

dlisbegin

char(1)

 

 

'F'::bpchar

F of T. Indien T dan gaat het om het openingsportal.

 

Foreign Keys

There are no foreign keys for table tbportalnames

 

Checks

Name

Condition

Description

chk_tbportalnames_dlisbegin

dlisbegin = ANY (ARRAY['F'::bpchar, 'T'::bpchar])

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbportalnames

btree

 

dnkey

 

idu_portalnames_idbegin

btree

 

dlisbegin

 

 

 

Triggers

There are no triggers for table tbportalnames

 

Rules

There are no rules for table tbportalnames

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbportalcolumns

public

cfk_tbportalcol_keyprtalnms

dnkeyportalnames

public.tbportalnames

dnkey

Cascade

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbportalnames (
 dnkey SERIAL,
 dvname VARCHAR(40),
 dlisbegin CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbportalnames PRIMARY KEY(dnkey),
 CONSTRAINT chk_tbportalnames_dlisbegin CHECK (dlisbegin = ANY (ARRAY['F'::bpchar, 'T'::bpchar]))
)
WITH (oids = false);

COMMENT ON TABLE public.tbportalnames
IS 'Tabel met portaalnamen (OWB). Er is maximaal één rij met eigenschap dlisbegin = T.';

COMMENT ON COLUMN public.tbportalnames.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tbportalnames.dvname
IS 'Naam (identifier) van een portaal.';

COMMENT ON COLUMN public.tbportalnames.dlisbegin
IS 'F of T. Indien T dan gaat het om het openingsportal.';

CREATE UNIQUE INDEX idu_portalnames_idbegin ON public.tbportalnames
 USING btree (dlisbegin COLLATE pg_catalog."default")
 WHERE (dlisbegin = 'T'::bpchar);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 11-3-2015 13:51
Previous topic Chapter index Next topic