Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbinbehandelingbij

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Koppelingstabel tussen tbmedewerkers en de vergunningsaanvragen uit de verschillende modules: welke medewerker is dossierbehandelaar bij welke zaak

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbinbehandelingbij_dnkey_seq'::regclass)

Primary key.

 

dvcodemedewerker

char(5)

 

 

 

 

Foreign key naar TbMedewerkers.dvcode

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar TbHandhavingen.dnkey

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dbkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.dnkey

 

 

dlactief

char(1)

 

 

 

 

Actieve behandelaar (T/F).

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign Key naar tabel TbHorecaVergunningen.dnkey

 

dnkeybestemmingsplannen

integer

 

 

 

 

Foreign Key naar tabel TbBestemmingsplannen.dnkey

 

dnkeyinfoaanvraag

integer

 

 

 

 

Foreign Key naar tabel TbInfoAanvragen.dnkey.

 

 

ddeinddatum

timestamp

 

 

 

 

Datum waarop een andere behandelaar de actieve behandelaar is geworden.

 

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_inbehandelingbij_bestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehandelingbij_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehandelingbij_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehandelingbij_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehbij_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehbij_handh

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehbij_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_inbehbij_medewerkers

dvcodemedewerker

public.tbmedewerkers

dvcode

No Action

No Action

 

Immediate

 

cfk_inbehbij_ovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_inbehbij_codmedw

dvcodemedewerker IS NOT NULL

 

cnn_inbehbij_keyverg

((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen 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 (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbinbehandelingbij

btree

 

dnkey

 

idx_inbehandbij_codemedewerker

btree

 

dvcodemedewerker

 

 

 

idx_inbehandbij_keybouwvergun

btree

 

dnkeybouwvergunningen

 

 

 

idx_inbehandbij_keyhandhaving

btree

 

dnkeyhandhavingen

 

 

 

idx_inbehandbij_keymilverg

btree

 

dnkeymilvergunningen

 

 

 

idx_inbehandbij_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_inbehandbij_keyovvergunnin

btree

 

dnkeyovvergunningen

 

 

 

idx_inbehandelingbij_horecaver

btree

 

dnkeyhorecavergunningen

 

 

 

idx_inbehbij_einddatum

btree

 

ddeinddatum

 

 

 

idx_inbehbij_keybestplan

btree

 

dnkeybestemmingsplannen

 

 

 

idx_inbehbij_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

 

Triggers

There are no triggers for table tbinbehandelingbij

 

Rules

There are no rules for table tbinbehandelingbij

 

Referenced

There are no tables referenced by table tbinbehandelingbij

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbinbehandelingbij (
 dnkey SERIAL,
 dvcodemedewerker CHAR(5),
 dnkeyhandhavingen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dlactief CHAR(1),
 dnkeyhorecavergunningen INTEGER,
 dnkeybestemmingsplannen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 ddeinddatum TIMESTAMP WITHOUT TIME ZONE,
 dnkeymilvergunningen INTEGER,
 dnkeyomgvergunningen INTEGER,
 CONSTRAINT cpk_tbinbehandelingbij PRIMARY KEY(dnkey),
 CONSTRAINT cnn_inbehbij_codmedw CHECK (dvcodemedewerker IS NOT NULL),
 CONSTRAINT cnn_inbehbij_keyverg CHECK (((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR ((((((((dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen 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 (dnkeybestemmingsplannen 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 (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))),
 CONSTRAINT cfk_inbehandelingbij_bestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehandelingbij_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehandelingbij_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehandelingbij_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehbij_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehbij_handh FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehbij_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehbij_medewerkers FOREIGN KEY (dvcodemedewerker)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_inbehbij_ovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbinbehandelingbij
IS 'Koppelingstabel tussen tbmedewerkers en de vergunningsaanvragen uit de verschillende modules: welke medewerker is dossierbehandelaar bij welke zaak';

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

COMMENT ON COLUMN public.tbinbehandelingbij.dvcodemedewerker
IS 'Foreign key naar TbMedewerkers.dvcode';

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

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dbkey';

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

COMMENT ON COLUMN public.tbinbehandelingbij.dlactief
IS 'Actieve behandelaar (T/F).';

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeyhorecavergunningen
IS 'Foreign Key naar tabel TbHorecaVergunningen.dnkey';

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeybestemmingsplannen
IS 'Foreign Key naar tabel TbBestemmingsplannen.dnkey';

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeyinfoaanvraag
IS 'Foreign Key naar tabel TbInfoAanvragen.dnkey.';

COMMENT ON COLUMN public.tbinbehandelingbij.ddeinddatum
IS 'Datum waarop een andere behandelaar de actieve behandelaar is geworden.';

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeymilvergunningen
IS 'Foreign Key naar tabel TbMilvergunningen.dnkey';

COMMENT ON COLUMN public.tbinbehandelingbij.dnkeyomgvergunningen
IS 'Foreign Key naar tabel TbOmgvergunning.dnkey';

CREATE INDEX idx_inbehandbij_codemedewerker ON public.tbinbehandelingbij
 USING btree (dvcodemedewerker COLLATE pg_catalog."default");

CREATE INDEX idx_inbehandbij_keybouwvergun ON public.tbinbehandelingbij
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_inbehandbij_keyhandhaving ON public.tbinbehandelingbij
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_inbehandbij_keymilverg ON public.tbinbehandelingbij
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_inbehandbij_keyomgverg ON public.tbinbehandelingbij
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_inbehandbij_keyovvergunnin ON public.tbinbehandelingbij
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_inbehandelingbij_horecaver ON public.tbinbehandelingbij
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_inbehbij_einddatum ON public.tbinbehandelingbij
 USING btree (ddeinddatum);

CREATE INDEX idx_inbehbij_keybestplan ON public.tbinbehandelingbij
 USING btree (dnkeybestemmingsplannen);

CREATE INDEX idx_inbehbij_keyinfo ON public.tbinbehandelingbij
 USING btree (dnkeyinfoaanvraag); 


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