Datadictionary OpenWave 3.1.25

Table: tbzaakproducten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel met gekoppelde producten/klantbetalers/werkpakketten bij omgevingzaken, of apv.overig of handhaving of horeca of milieu/gebruik

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbzaakproducten

Rules

There are no rules for table tbzaakproducten

Policies

There are no policies for table tbzaakproducten

Referenced

There are no tables referenced by table tbzaakproducten

Properties

Definition

CREATE TABLE public.tbzaakproducten (
 dnkey SERIAL,
 dnkeyomgvergunningen INTEGER,
 dnkeyhandhavingen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhorecavergunningen INTEGER,
 dnkeyinfoaanvragen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeyproducten INTEGER,
 dnkeyproductklanten INTEGER,
 dnkeyproductwkp INTEGER,
 dvcodemuteerder CHAR(5),
 ddmutatie DATE,
 ddopgeleverd TIMESTAMP WITHOUT TIME ZONE,
 dnkeysubproducten INTEGER,
 dvcodegerealiseerddoor CHAR(5),
 CONSTRAINT cpk_tbzaakproducten PRIMARY KEY(dnkey),
 CONSTRAINT cnn_zaakproducten_keyverg CHECK (((dnkeyinfoaanvragen IS NOT NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NOT NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhandhavingen IS NOT NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL))),
 CONSTRAINT cfk_tbzaakprod_keysubprod FOREIGN KEY (dnkeysubproducten)
   REFERENCES public.tbsubproducten(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyhandhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyhorvergun FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyinfoaanvragen FOREIGN KEY (dnkeyinfoaanvragen)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keymilvergun FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyomgvergun FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyovvergunningen FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyproducten FOREIGN KEY (dnkeyproducten)
   REFERENCES public.tbproducten(dnkey)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyproductklanten FOREIGN KEY (dnkeyproductklanten)
   REFERENCES public.tbproductklanten(dnkey)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakprod_keyproductwkp FOREIGN KEY (dnkeyproductwkp)
   REFERENCES public.tbproductwerkpakketten(dnkey)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakproducten_codegerealdoor FOREIGN KEY (dvcodegerealiseerddoor)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_zaakproducten_dvcodemut FOREIGN KEY (dvcodemuteerder)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbzaakproducten
IS 'Tabel met gekoppelde producten/klantbetalers/werkpakketten bij omgevingzaken, of apv.overig of handhaving of horeca of milieu/gebruik';

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

COMMENT ON COLUMN public.tbzaakproducten.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyhandhavingen
IS 'Foreign key naar tbomgvergunning.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyovvergunningen
IS 'Foreign key naar tbovvergunningen.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyhorecavergunningen
IS 'Foreign key naar tbohorecavergunningen.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyinfoaanvragen
IS 'Foreign key naar tbinfoaanvragen.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeymilvergunningen
IS 'Foreign key naar tbmilvergunningen.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyproducten
IS 'Foreign key naar tbproducten.dnkey: dus de dnkey van de koppeling tussen zaaktype en een producddefinitie (tbrpridctdef).';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyproductklanten
IS 'Foreign key naar tbproductklanten.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dnkeyproductwkp
IS 'Foreign key naar tbproductwerkpakketten.dnkey.';

COMMENT ON COLUMN public.tbzaakproducten.dvcodemuteerder
IS 'Foreign key naar tbmedewerkers.dvcode. We heeft kaart aangemaakt/gewijsigd';

COMMENT ON COLUMN public.tbzaakproducten.ddmutatie
IS 'Datum dat kaart is aangemaakt/ startdatum van product';

COMMENT ON COLUMN public.tbzaakproducten.ddopgeleverd
IS 'Datum dat product is opgeleverd';

COMMENT ON COLUMN public.tbzaakproducten.dnkeysubproducten
IS 'Foreign key naar tbsubproducten.dnkey';

COMMENT ON COLUMN public.tbzaakproducten.dvcodegerealiseerddoor
IS 'Foreign key naar tbmedewerkers.dvcode. Wie heeft kaart gerealiseerd';

CREATE INDEX idx_zaakprod_ddmutatie ON public.tbzaakproducten
 USING btree (ddmutatie);

CREATE INDEX idx_zaakprod_ddopgeleverd ON public.tbzaakproducten
 USING btree (ddopgeleverd);

CREATE INDEX idx_zaakprod_keyhandh ON public.tbzaakproducten
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_zaakprod_keyhorverg ON public.tbzaakproducten
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_zaakprod_keyinfavrg ON public.tbzaakproducten
 USING btree (dnkeyinfoaanvragen);

CREATE INDEX idx_zaakprod_keymilverg ON public.tbzaakproducten
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_zaakprod_keyomgvergun ON public.tbzaakproducten
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_zaakprod_keyovverg ON public.tbzaakproducten
 USING btree (dnkeyovvergunningen);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13