Datadictionary OpenWave 3.1.33 |
|
Table: tbzgwroltypes
Datadictionary OpenWave 3.1.33 |
|
Table: tbzgwroltypes
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen zaaktypes (tbsoortomgverg en tbsoortovverg) en adressoorten (tbadressoort)
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbzgwroltypes_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeysoortomgverg |
integer |
|
|
|
|
Foreign key naar tbsoortomgverg.dnkey |
|
|
dvcodesoortovverg |
char(5) |
|
|
|
|
Foreign key naar tbsoortovverg.dvcode |
|
|
dvcodeadressoort |
char(3) |
|
|
|
|
Foreign key naar tbadressoort.dvcode |
|
|
dvzgwuuid |
varchar(40) |
|
|
|
|
Unieke UUID code voor combinatie zaaktype en adressoort |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbzgwroltypes_dnkeysoortomgverg |
dnkeysoortomgverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzgwroltypes_dvcodeadressoort |
dvcodeadressoort |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzgwroltypes_dvcodesoortovverg |
dvcodesoortovverg |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbzgwroltypes_dvcodeadressoort |
dvcodeadressoort IS NOT NULL |
|
cnn_tbzgwroltypes_keyverg |
((dnkeysoortomgverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) OR ((dnkeysoortomgverg IS NULL) AND (dvcodesoortovverg IS NOT NULL)) |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbzgwroltypes |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbzgwroltypes
Rules
There are no rules for table tbzgwroltypes
Policies
There are no policies for table tbzgwroltypes
Referenced
There are no tables referenced by table tbzgwroltypes
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeysoortomgverg INTEGER STORAGE PLAIN,
dvcodesoortovverg CHAR(5),
dvcodeadressoort CHAR(3),
dvzgwuuid VARCHAR(40),
CONSTRAINT cpk_tbzgwroltypes PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbzgwroltypes_dvcodeadressoort CHECK (dvcodeadressoort IS NOT NULL),
CONSTRAINT cnn_tbzgwroltypes_keyverg CHECK (((dnkeysoortomgverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) OR ((dnkeysoortomgverg IS NULL) AND (dvcodesoortovverg IS NOT NULL))),
CONSTRAINT cfk_tbzgwroltypes_dnkeysoortomgverg FOREIGN KEY (dnkeysoortomgverg)
REFERENCES public.tbsoortomgverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzgwroltypes_dvcodeadressoort FOREIGN KEY (dvcodeadressoort)
REFERENCES public.tbadressoort(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzgwroltypes_dvcodesoortovverg FOREIGN KEY (dvcodesoortovverg)
REFERENCES public.tbsoortovverg(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbzgwroltypes
IS 'Koppeltabel tussen zaaktypes (tbsoortomgverg en tbsoortovverg) en adressoorten (tbadressoort)';
COMMENT ON COLUMN public.tbzgwroltypes.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbzgwroltypes.dnkeysoortomgverg
IS 'Foreign key naar tbsoortomgverg.dnkey';
COMMENT ON COLUMN public.tbzgwroltypes.dvcodesoortovverg
IS 'Foreign key naar tbsoortovverg.dvcode';
COMMENT ON COLUMN public.tbzgwroltypes.dvcodeadressoort
IS 'Foreign key naar tbadressoort.dvcode';
COMMENT ON COLUMN public.tbzgwroltypes.dvzgwuuid
IS 'Unieke UUID code voor combinatie zaaktype en adressoort ';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|