Datadictionary OpenWave 3.1.25 |
|
Table: tbvrijeveldenbetekenissen
Datadictionary OpenWave 3.1.25 |
|
Table: tbvrijeveldenbetekenissen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Depricated sinds versie 3.1.15. Tabel met vrije veld labels per module
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbvrijeveldenbetekenissen_dnkey_seq'::regclass) |
Primary key. |
|
|
dvomschrijving |
varchar(30) |
|
|
|
|
Wordt overgenomen in TbVrijeVelden. |
|
|
dvsoort |
char(1) |
|
|
|
'T'::bpchar |
Alleen T,D,L of N toegestaan. (T)ekst, (D)atum, (N)umeriek of (L)ogisch. Wordt overgenomen in TbVrijeVelden. |
|
|
dvvantoepop |
char(1) |
|
|
|
'B'::bpchar |
Alleen B,O,H,C,S,I,E,V,W toegestaan. (B)ouwverguning, (O)verig verg. (H)andhaving Horeca verg, Be(S)temmings-plannen (I)nfo-aanvragen. E = Milieu/gebruiksvergunning V = Inrichting W = Omgevingvergunning. |
|
|
dnvolgorde |
integer |
|
|
|
|
Volgorde op scherm in werkmodule. Wordt overgenomen in TbVrijeVelden. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
In de werkapplicatie worden geen vrije velden aangemaakt waarvan de vervaldatum gevuld is en kleiner dan de systeemdatum. |
Foreign Keys
There are no foreign keys for table tbvrijeveldenbetekenissen
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_vvbet_soort |
dvsoort = ANY (ARRAY['T'::bpchar, 'D'::bpchar, 'L'::bpchar, 'N'::bpchar]) |
|
chk_vvbet_vantoepop |
dvvantoepop = ANY (ARRAY['B'::bpchar, 'O'::bpchar, 'H'::bpchar, 'S'::bpchar, 'I'::bpchar, 'C'::bpchar, 'E'::bpchar, 'V'::bpchar, 'W'::bpchar]) |
|
cnn_vvbet_omschr |
dvomschrijving IS NOT NULL |
|
cnn_vvbet_volgorde |
dnvolgorde IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbvrijeveldenbetekenissen |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbvrijeveldenbetekenissen
Rules
There are no rules for table tbvrijeveldenbetekenissen
Policies
There are no policies for table tbvrijeveldenbetekenissen
Referenced
There are no tables referenced by table tbvrijeveldenbetekenissen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvomschrijving VARCHAR(30),
dvsoort CHAR(1) DEFAULT 'T'::bpchar,
dvvantoepop CHAR(1) DEFAULT 'B'::bpchar,
dnvolgorde INTEGER,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbvrijeveldenbetekenissen PRIMARY KEY(dnkey),
CONSTRAINT chk_vvbet_soort CHECK (dvsoort = ANY (ARRAY['T'::bpchar, 'D'::bpchar, 'L'::bpchar, 'N'::bpchar])),
CONSTRAINT chk_vvbet_vantoepop CHECK (dvvantoepop = ANY (ARRAY['B'::bpchar, 'O'::bpchar, 'H'::bpchar, 'S'::bpchar, 'I'::bpchar, 'C'::bpchar, 'E'::bpchar, 'V'::bpchar, 'W'::bpchar])),
CONSTRAINT cnn_vvbet_omschr CHECK (dvomschrijving IS NOT NULL),
CONSTRAINT cnn_vvbet_volgorde CHECK (dnvolgorde IS NOT NULL)
) ;
COMMENT ON TABLE public.tbvrijeveldenbetekenissen
IS 'Depricated sinds versie 3.1.15. Tabel met vrije veld labels per module';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.dvomschrijving
IS 'Wordt overgenomen in TbVrijeVelden.';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.dvsoort
IS 'Alleen T,D,L of N toegestaan. (T)ekst, (D)atum, (N)umeriek of (L)ogisch. Wordt overgenomen in TbVrijeVelden.';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.dvvantoepop
IS 'Alleen B,O,H,C,S,I,E,V,W toegestaan. (B)ouwverguning, (O)verig verg. (H)andhaving Horeca verg, Be(S)temmings-plannen (I)nfo-aanvragen. E = Milieu/gebruiksvergunning V = Inrichting W = Omgevingvergunning.';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.dnvolgorde
IS 'Volgorde op scherm in werkmodule. Wordt overgenomen in TbVrijeVelden.';
COMMENT ON COLUMN public.tbvrijeveldenbetekenissen.ddvervaldatum
IS 'In de werkapplicatie worden geen vrije velden aangemaakt waarvan de vervaldatum gevuld is en kleiner dan de systeemdatum.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|