Datadictionary OpenWave 3.1.11 |
|
Table: tbzaaktypedoctype
Datadictionary OpenWave 3.1.11 |
|
Table: tbzaaktypedoctype
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen zaaktypes (tbsoortomgverg, tbsoorthhzaak etcerera) en tbdocumenttype
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbzaaktypedoctype_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeydocumenttype |
integer |
|
|
|
|
Foreign key naar tbdocumenttype.dnkey |
|
|
dnkeysoortplan |
integer |
|
|
|
|
Foreign key naar tbsoortplan.dnkey |
|
|
dvcodesoortovverg |
char(5) |
|
|
|
|
Foreign key naar tbsoortovverg.dvcode |
|
|
dnkeysoortmilverg |
integer |
|
|
|
|
Foreign key naar tbsoortmilverg.dnkey |
|
|
dnkeysoortomgverg |
integer |
|
|
|
|
Foreign key naar tbdsoortomgverg.dnkey |
|
|
dnkeysoorthhzaak |
integer |
|
|
|
|
Foreign key naar tbsoorthhzaak.dnkey |
|
|
dnkeyinspaanleiding |
integer |
|
|
|
|
Foreign key naar tbinspaanleiding.dnkey |
|
|
dnkeysoortinfoaanvraag |
integer |
|
|
|
|
Foreign key naar tbsoortinfoaanvraag.dnkey |
|
|
dnkeysoorthorverg |
integer |
|
|
|
|
Foreign key naar tbsoorthorverg.dnkey |
|
|
dvcodeadviesinstanties |
char(4) |
|
|
|
|
Foreign key naar tbadviesinstanties.dvcode |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbzaaktdoctype_codeadvies |
dvcodeadviesinstanties |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_codeovvg |
dvcodesoortovverg |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keydoctype |
dnkeydocumenttype |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keyhhzaak |
dnkeysoorthhzaak |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keyhor |
dnkeysoorthorverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keyinfo |
dnkeysoortinfoaanvraag |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keyinspaan |
dnkeyinspaanleiding |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keymilvg |
dnkeysoortmilverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keyomgvg |
dnkeysoortomgverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbzaaktdoctype_keysrtpl |
dnkeysoortplan |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbzaaktdoctype_keydoctype |
dnkeydocumenttype IS NOT NULL |
|
cnn_tbzaaktdoctype_keyzaak |
((((((((((((((((dnkeysoortplan IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL)) OR (((((((((dvcodesoortovverg IS NOT NULL) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortmilverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortomgverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoorthhzaak IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeyinspaanleiding IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortinfoaanvraag IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dvcodeadviesinstanties IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dnkeyinspaanleiding IS NULL))) OR (((((((((dnkeysoorthorverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dvcodeadviesinstanties IS NULL)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbzaaktypedoctype |
btree |
|
dnkey |
|
|
|
idu_tbzaaktdoctype_keyzaak |
btree |
|
dnkeydocumenttype, dnkeysoortplan, dvcodesoortovverg, dnkeysoortmilverg, dnkeysoortomgverg, dnkeysoorthhzaak, dnkeyinspaanleiding, dnkeysoortinfoaanvraag, dnkeysoorthorverg, dvcodeadviesinstanties |
|
|
|
Triggers
There are no triggers for table tbzaaktypedoctype
Rules
There are no rules for table tbzaaktypedoctype
Referenced
There are no tables referenced by table tbzaaktypedoctype
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeydocumenttype INTEGER,
dnkeysoortplan INTEGER,
dvcodesoortovverg CHAR(5),
dnkeysoortmilverg INTEGER,
dnkeysoortomgverg INTEGER,
dnkeysoorthhzaak INTEGER,
dnkeyinspaanleiding INTEGER,
dnkeysoortinfoaanvraag INTEGER,
dnkeysoorthorverg INTEGER,
dvcodeadviesinstanties CHAR(4),
CONSTRAINT cpk_tbzaaktypedoctype PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbzaaktdoctype_keydoctype CHECK (dnkeydocumenttype IS NOT NULL),
CONSTRAINT cnn_tbzaaktdoctype_keyzaak CHECK (((((((((((((((((dnkeysoortplan IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL)) OR (((((((((dvcodesoortovverg IS NOT NULL) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortmilverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortomgverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoorthhzaak IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeyinspaanleiding IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dnkeysoortinfoaanvraag IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))) OR (((((((((dvcodeadviesinstanties IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoorthorverg IS NULL)) AND (dnkeyinspaanleiding IS NULL))) OR (((((((((dnkeysoorthorverg IS NOT NULL) AND (dvcodesoortovverg IS NULL)) AND (dnkeysoortmilverg IS NULL)) AND (dnkeysoortplan IS NULL)) AND (dnkeysoorthhzaak IS NULL)) AND (dnkeyinspaanleiding IS NULL)) AND (dnkeysoortinfoaanvraag IS NULL)) AND (dnkeysoortomgverg IS NULL)) AND (dvcodeadviesinstanties IS NULL))),
CONSTRAINT cfk_tbzaaktdoctype_codeadvies FOREIGN KEY (dvcodeadviesinstanties)
REFERENCES public.tbadviesinstanties(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_codeovvg FOREIGN KEY (dvcodesoortovverg)
REFERENCES public.tbsoortovverg(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keydoctype FOREIGN KEY (dnkeydocumenttype)
REFERENCES public.tbdocumenttype(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keyhhzaak FOREIGN KEY (dnkeysoorthhzaak)
REFERENCES public.tbsoorthhzaak(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keyhor FOREIGN KEY (dnkeysoorthorverg)
REFERENCES public.tbsoorthorverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keyinfo FOREIGN KEY (dnkeysoortinfoaanvraag)
REFERENCES public.tbsoortinfoaanvraag(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keyinspaan FOREIGN KEY (dnkeyinspaanleiding)
REFERENCES public.tbinspaanleiding(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keymilvg FOREIGN KEY (dnkeysoortmilverg)
REFERENCES public.tbsoortmilverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keyomgvg FOREIGN KEY (dnkeysoortomgverg)
REFERENCES public.tbsoortomgverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbzaaktdoctype_keysrtpl FOREIGN KEY (dnkeysoortplan)
REFERENCES public.tbsoortplan(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbzaaktypedoctype
IS 'Koppeltabel tussen zaaktypes (tbsoortomgverg, tbsoorthhzaak etcerera) en tbdocumenttype';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeydocumenttype
IS 'Foreign key naar tbdocumenttype.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoortplan
IS 'Foreign key naar tbsoortplan.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dvcodesoortovverg
IS 'Foreign key naar tbsoortovverg.dvcode';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoortmilverg
IS 'Foreign key naar tbsoortmilverg.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoortomgverg
IS 'Foreign key naar tbdsoortomgverg.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoorthhzaak
IS 'Foreign key naar tbsoorthhzaak.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeyinspaanleiding
IS 'Foreign key naar tbinspaanleiding.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoortinfoaanvraag
IS 'Foreign key naar tbsoortinfoaanvraag.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dnkeysoorthorverg
IS 'Foreign key naar tbsoorthorverg.dnkey';
COMMENT ON COLUMN public.tbzaaktypedoctype.dvcodeadviesinstanties
IS 'Foreign key naar tbadviesinstanties.dvcode';
CREATE UNIQUE INDEX idu_tbzaaktdoctype_keyzaak ON public.tbzaaktypedoctype
USING btree (dnkeydocumenttype, dnkeysoortplan, dvcodesoortovverg COLLATE pg_catalog."default", dnkeysoortmilverg, dnkeysoortomgverg, dnkeysoorthhzaak, dnkeyinspaanleiding, dnkeysoortinfoaanvraag, dnkeysoorthorverg, dvcodeadviesinstanties COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|