Datadictionary OpenWave 3.1.34 |
|
Table: tbzgwzaakobjecttypen
Datadictionary OpenWave 3.1.34 |
|
Table: tbzgwzaakobjecttypen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
ZGW-zaakobjecttypen tabel (zoals adres en medewerker) bij tbsoortomgverg en tbsoortovverg
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbzgwzaakobjecttypen_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeysoortomgverg |
integer |
|
|
|
|
Foreign key naar tbsoortomgverg.dnkey |
|
|
dvcodesoortovverg |
char(5) |
|
|
|
|
Foreign key naar tbsoortovverg.dvcode |
|
|
dvzgwuuid |
varchar(40) |
|
|
|
|
Unieke UUID code voor combinatie zaaktype en adressoort |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarvanaf objecttype niet meer gebruikt kan vorden |
|
|
dvobjecttype |
varchar(40) |
|
|
|
|
Objecttype zoals adres of medewerker |
|
|
dvobjecttypeoms |
varchar(200) |
|
|
|
|
Nadere omschrijving objecttype in samenhang zaaktype |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbzgwzaakobjecttypen_dnkeysoortomgverg |
dnkeysoortomgverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzgwzaakobjecttypen_dvcodesoortovverg |
dvcodesoortovverg |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbzgwzaakobjecttypen_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_tbzgwzaakobjecttypen |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbzgwzaakobjecttypen
Rules
There are no rules for table tbzgwzaakobjecttypen
Policies
There are no policies for table tbzgwzaakobjecttypen
Referenced
There are no tables referenced by table tbzgwzaakobjecttypen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeysoortomgverg INTEGER STORAGE PLAIN,
dvcodesoortovverg CHAR(5),
dvzgwuuid VARCHAR(40),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvobjecttype VARCHAR(40),
dvobjecttypeoms VARCHAR(200),
CONSTRAINT cpk_tbzgwzaakobjecttypen PRIMARY KEY(dnkey),
CONSTRAINT chk_tbzgwzaakobjecttypen_keyverg CHECK (((dnkeysoortomgverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) OR ((dnkeysoortomgverg IS NULL) AND (dvcodesoortovverg IS NOT NULL))),
CONSTRAINT cfk_tbzgwzaakobjecttypen_dnkeysoortomgverg FOREIGN KEY (dnkeysoortomgverg)
REFERENCES public.tbsoortomgverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzgwzaakobjecttypen_dvcodesoortovverg FOREIGN KEY (dvcodesoortovverg)
REFERENCES public.tbsoortovverg(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbzgwzaakobjecttypen
IS 'ZGW-zaakobjecttypen tabel (zoals adres en medewerker) bij tbsoortomgverg en tbsoortovverg';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dnkeysoortomgverg
IS 'Foreign key naar tbsoortomgverg.dnkey';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dvcodesoortovverg
IS 'Foreign key naar tbsoortovverg.dvcode';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dvzgwuuid
IS 'Unieke UUID code voor combinatie zaaktype en adressoort ';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.ddvervaldatum
IS 'Datum waarvanaf objecttype niet meer gebruikt kan vorden';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dvobjecttype
IS 'Objecttype zoals adres of medewerker';
COMMENT ON COLUMN public.tbzgwzaakobjecttypen.dvobjecttypeoms
IS 'Nadere omschrijving objecttype in samenhang zaaktype';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|