Datadictionary OpenWave 3.1.11 |
|
Table: tbportalnames
Datadictionary OpenWave 3.1.11 |
|
Table: tbportalnames
Schema
public
Owner
waveuser005
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. |
|
|
dncolumnwidth |
integer |
|
|
|
210 |
Breedte van de kolommen in pixels. |
|
|
dvcolumnalignment |
char(1) |
|
|
|
'L'::bpchar |
L,R of C. Uitijning van tekst op kolomlables: Links, Rechts of Center |
|
|
dvtilealignment |
char(1) |
|
|
|
'L'::bpchar |
L,R of C. Uitijning van tekst op tegels: Links, Rechts of Center |
|
|
dnportaltype |
integer |
|
|
|
1 |
Type van portalscherm. Alleen 1 is vooralsnog mogelijk |
|
|
dnportalminwidth |
integer |
|
|
|
1000 |
(minimale) breedte van scherm in pixels. |
|
|
dnportalminheight |
integer |
|
|
|
500 |
(minimale) hoogte van scherm in pixels. |
|
|
dnportalheadertype |
integer |
|
|
|
1 |
Type van headergedeelte van portalscherm. Alleen 1 is vooralsnog mogelijk |
|
|
dlportalfastcontent |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan dan wordt de tegelcontent op basis van query in één keer opgehaald |
Foreign Keys
There are no foreign keys for table tbportalnames
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_portalnames_columnalign |
dvcolumnalignment = ANY (ARRAY['L'::bpchar, 'R'::bpchar, 'C'::bpchar]) |
|
chk_portalnames_dlportalfastc |
dlportalfastcontent = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_portalnames_dvtilealign |
dvtilealignment = ANY (ARRAY['L'::bpchar, 'R'::bpchar, 'C'::bpchar]) |
|
chk_tbportalnames_dlisbegin |
dlisbegin = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_portalnames_columnalign |
dvcolumnalignment IS NOT NULL |
|
cnn_portalnames_dlportalfastc |
dlportalfastcontent IS NOT NULL |
|
cnn_portalnames_tilealign |
dvtilealignment IS NOT NULL |
|
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 |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvname VARCHAR(40),
dlisbegin CHAR(1) DEFAULT 'F'::bpchar,
dncolumnwidth INTEGER DEFAULT 210,
dvcolumnalignment CHAR(1) DEFAULT 'L'::bpchar,
dvtilealignment CHAR(1) DEFAULT 'L'::bpchar,
dnportaltype INTEGER DEFAULT 1,
dnportalminwidth INTEGER DEFAULT 1000,
dnportalminheight INTEGER DEFAULT 500,
dnportalheadertype INTEGER DEFAULT 1,
dlportalfastcontent CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbportalnames PRIMARY KEY(dnkey),
CONSTRAINT chk_portalnames_columnalign CHECK (dvcolumnalignment = ANY (ARRAY['L'::bpchar, 'R'::bpchar, 'C'::bpchar])),
CONSTRAINT chk_portalnames_dlportalfastc CHECK (dlportalfastcontent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_portalnames_dvtilealign CHECK (dvtilealignment = ANY (ARRAY['L'::bpchar, 'R'::bpchar, 'C'::bpchar])),
CONSTRAINT chk_tbportalnames_dlisbegin CHECK (dlisbegin = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_portalnames_columnalign CHECK (dvcolumnalignment IS NOT NULL),
CONSTRAINT cnn_portalnames_dlportalfastc CHECK (dlportalfastcontent IS NOT NULL),
CONSTRAINT cnn_portalnames_tilealign CHECK (dvtilealignment IS NOT NULL)
)
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.';
COMMENT ON COLUMN public.tbportalnames.dncolumnwidth
IS 'Breedte van de kolommen in pixels.';
COMMENT ON COLUMN public.tbportalnames.dvcolumnalignment
IS 'L,R of C. Uitijning van tekst op kolomlables: Links, Rechts of Center';
COMMENT ON COLUMN public.tbportalnames.dvtilealignment
IS 'L,R of C. Uitijning van tekst op tegels: Links, Rechts of Center';
COMMENT ON COLUMN public.tbportalnames.dnportaltype
IS 'Type van portalscherm. Alleen 1 is vooralsnog mogelijk';
COMMENT ON COLUMN public.tbportalnames.dnportalminwidth
IS '(minimale) breedte van scherm in pixels.';
COMMENT ON COLUMN public.tbportalnames.dnportalminheight
IS '(minimale) hoogte van scherm in pixels.';
COMMENT ON COLUMN public.tbportalnames.dnportalheadertype
IS 'Type van headergedeelte van portalscherm. Alleen 1 is vooralsnog mogelijk';
COMMENT ON COLUMN public.tbportalnames.dlportalfastcontent
IS 'T of F. Indien T dan dan wordt de tegelcontent op basis van query in één keer opgehaald';
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 22-2-2017 10:50 |
|