Datadictionary OpenWave 3.1.25

Table: tbvolgzaak

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel waarin volgperiode van medewerker voor een zaak wordt vastgelegd

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbvolgzaak

Rules

There are no rules for table tbvolgzaak

Policies

There are no policies for table tbvolgzaak

Referenced

There are no tables referenced by table tbvolgzaak

Properties

Definition

CREATE TABLE public.tbvolgzaak (
 dnkey SERIAL,
 dvcodemw CHAR(5),
 dnkeyomgvergunningen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyhandhavingen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhorecavergunningen INTEGER,
 dnkeyinfoaanvragen INTEGER,
 dnkeymilvergunningen INTEGER,
 ddstartdatum TIMESTAMP WITHOUT TIME ZONE,
 ddeinddatum TIMESTAMP WITHOUT TIME ZONE,
 CONSTRAINT cpk_tbvolgzaak PRIMARY KEY(dnkey),
 CONSTRAINT cnn_volgzaak_codemw CHECK (dvcodemw IS NOT NULL),
 CONSTRAINT cnn_volgzaak_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) AND (dnkeybouwvergunningen 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) AND (dnkeybouwvergunningen 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) AND (dnkeybouwvergunningen 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) AND (dnkeybouwvergunningen 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) AND (dnkeybouwvergunningen 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) AND (dnkeybouwvergunningen IS NULL)) OR ((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyinfoaanvragen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL))),
 CONSTRAINT cfk_volgzaak_codemw FOREIGN KEY (dvcodemw)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keybouwvergunning FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keyhandhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keyhorvergun FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keyinfoaanvragen FOREIGN KEY (dnkeyinfoaanvragen)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keymilvergun FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keyomgvergun FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_volgzaak_keyovvergunningen FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbvolgzaak
IS 'Tabel waarin volgperiode van medewerker voor een zaak wordt vastgelegd';

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

COMMENT ON COLUMN public.tbvolgzaak.dvcodemw
IS 'Foreign key naar tbmedewerkers.dvcode. Medewerker die de zaak volgt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey. Omgevingszaak die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeybouwvergunningen
IS 'Foreign key naar Tbbouwvergunningen. Bouwvergunning die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeyhandhavingen
IS 'Foreign key naar Tbhandhavingen. Handhavingszaak die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeyovvergunningen
IS 'Foreign key naar Tbovvergunningen. APV/Overige zaak die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeyhorecavergunningen
IS 'Foreign key naar Tbhorecavergunningen. Horeca-vergunning die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeyinfoaanvragen
IS 'Foreign key naar Tbinfoaanvragen. Infoaanvraag die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.dnkeymilvergunningen
IS 'Foreign key naar Tbmilvergunningen. Milieuzaak die gevolgd wordt';

COMMENT ON COLUMN public.tbvolgzaak.ddstartdatum
IS 'Startdatum volgperiode.';

COMMENT ON COLUMN public.tbvolgzaak.ddeinddatum
IS 'Einddatum volgperiode.';

CREATE INDEX idx_volgzaak_keybouw ON public.tbvolgzaak
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_volgzaak_keyhandh ON public.tbvolgzaak
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_volgzaak_keyhorverg ON public.tbvolgzaak
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_volgzaak_keyinfavrg ON public.tbvolgzaak
 USING btree (dnkeyinfoaanvragen);

CREATE INDEX idx_volgzaak_keymilverg ON public.tbvolgzaak
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_volgzaak_keyomgvergun ON public.tbvolgzaak
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_volgzaak_keyovverg ON public.tbvolgzaak
 USING btree (dnkeyovvergunningen);

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