Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbverzendlijst

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met verwijzingen naar vergunningen, contactadressen en documentsjablonen die klaar staan om te verzenden als uitgaande correspondentie

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbverzendlijst_dnkey_seq'::regclass)

Primary key.

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dnkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.dnkey

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar TbHandhavingen.dnkey

 

dvcodemedewerkers

char(5)

 

 

 

 

Foreign key naar TbMedewerkers.dvcode.

 

dnkeycontactadressen

integer

 

 

 

 

Foreign key naar TbContactadressen.dnkey.

 

 

ddtoegevoegd

timestamp

 

 

 

 

Datum waarop regel in tbverzendlijst is aangemaakt.

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign key naar TbHorecaVergunningen.DnKey.

 

dnkeyinfoaanvraag

integer

 

 

 

 

Foreign key naar TbInfoAanvragen.DnKey.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign key naar tabel TbMilInrichtingen.Dnkey.

 

dnkeymilvergunningen

integer

 

 

 

 

Foreign key naar tabel TbMilVergunningen.Dnkey.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign key naar tabel TbOmgVergunning.Dnkey.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_verzend_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzend_contact

dnkeycontactadressen

public.tbcontactadressen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzend_handhavingen

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzend_medew

dvcodemedewerkers

public.tbmedewerkers

dvcode

Cascade

No Action

 

Immediate

 

cfk_verzend_ovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzendl_milinricht

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzendl_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzendl_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzendlijst_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_verzendlijst_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_verzlst_contadr

dnkeycontactadressen IS NOT NULL

 

cnn_verzlst_keyverg

((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL)) OR ((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL))

 

cnn_verzlst_medew

dvcodemedewerkers IS NOT NULL

 

cnn_verzlst_toegev

ddtoegevoegd IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbverzendlijst

btree

 

dnkey

 

idx_verzend_ddtoegevoegd

btree

 

ddtoegevoegd

 

 

 

idx_verzendl_keymilinr

btree

 

dnkeymilinrichtingen

 

 

 

idx_verzendl_keymilverg

btree

 

dnkeymilvergunningen

 

 

 

idx_verzendl_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_verzendlijst_contact

btree

 

dnkeycontactadressen

 

 

 

idx_verzendlijst_horecaverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_verzendlijst_keybouw

btree

 

dnkeybouwvergunningen

 

 

 

idx_verzendlijst_keyhandh

btree

 

dnkeyhandhavingen

 

 

 

idx_verzendlijst_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_verzendlijst_keyov

btree

 

dnkeyovvergunningen

 

 

 

idx_verzendlijst_medew

btree

 

dvcodemedewerkers

 

 

 

 

Triggers

There are no triggers for table tbverzendlijst

 

Rules

There are no rules for table tbverzendlijst

 

Referenced

There are no tables referenced by table tbverzendlijst

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbverzendlijst (
 dnkey SERIAL,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhandhavingen INTEGER,
 dvcodemedewerkers CHAR(5),
 dnkeycontactadressen INTEGER,
 ddtoegevoegd TIMESTAMP WITHOUT TIME ZONE,
 dnkeyhorecavergunningen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeymilinrichtingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeyomgvergunningen INTEGER,
 CONSTRAINT cpk_tbverzendlijst PRIMARY KEY(dnkey),
 CONSTRAINT cnn_verzlst_contadr CHECK (dnkeycontactadressen IS NOT NULL),
 CONSTRAINT cnn_verzlst_keyverg CHECK (((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL)) OR ((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL))),
 CONSTRAINT cnn_verzlst_medew CHECK (dvcodemedewerkers IS NOT NULL),
 CONSTRAINT cnn_verzlst_toegev CHECK (ddtoegevoegd IS NOT NULL),
 CONSTRAINT cfk_verzend_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzend_contact FOREIGN KEY (dnkeycontactadressen)
   REFERENCES public.tbcontactadressen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzend_handhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzend_medew FOREIGN KEY (dvcodemedewerkers)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzend_ovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzendl_milinricht FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzendl_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzendl_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzendlijst_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_verzendlijst_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbverzendlijst
IS 'Tabel met verwijzingen naar vergunningen, contactadressen en documentsjablonen die klaar staan om te verzenden als uitgaande correspondentie';

COMMENT ON COLUMN public.tbverzendlijst.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';

COMMENT ON COLUMN public.tbverzendlijst.dnkeyovvergunningen
IS 'Foreign key naar TbOvVergunningen.dnkey';

COMMENT ON COLUMN public.tbverzendlijst.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.dnkey';

COMMENT ON COLUMN public.tbverzendlijst.dvcodemedewerkers
IS 'Foreign key naar TbMedewerkers.dvcode.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeycontactadressen
IS 'Foreign key naar TbContactadressen.dnkey.';

COMMENT ON COLUMN public.tbverzendlijst.ddtoegevoegd
IS 'Datum waarop regel in tbverzendlijst is aangemaakt.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeyhorecavergunningen
IS 'Foreign key naar TbHorecaVergunningen.DnKey.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeyinfoaanvraag
IS 'Foreign key naar TbInfoAanvragen.DnKey.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeymilinrichtingen
IS 'Foreign key naar tabel TbMilInrichtingen.Dnkey.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeymilvergunningen
IS 'Foreign key naar tabel TbMilVergunningen.Dnkey.';

COMMENT ON COLUMN public.tbverzendlijst.dnkeyomgvergunningen
IS 'Foreign key naar tabel TbOmgVergunning.Dnkey.';

CREATE INDEX idx_verzend_ddtoegevoegd ON public.tbverzendlijst
 USING btree (ddtoegevoegd);

CREATE INDEX idx_verzendl_keymilinr ON public.tbverzendlijst
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_verzendl_keymilverg ON public.tbverzendlijst
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_verzendl_keyomgverg ON public.tbverzendlijst
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_verzendlijst_contact ON public.tbverzendlijst
 USING btree (dnkeycontactadressen);

CREATE INDEX idx_verzendlijst_horecaverg ON public.tbverzendlijst
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_verzendlijst_keybouw ON public.tbverzendlijst
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_verzendlijst_keyhandh ON public.tbverzendlijst
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_verzendlijst_keyinfo ON public.tbverzendlijst
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_verzendlijst_keyov ON public.tbverzendlijst
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_verzendlijst_medew ON public.tbverzendlijst
 USING btree (dvcodemedewerkers COLLATE pg_catalog."default"); 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50
 Previous topic Chapter index Next topic