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 |
---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbportalcol_keyprtalnms |
dnkeyportalnames |
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 |
![]() ![]() ![]() |