Datadictionary OpenWave 3.1.25

Table: tburen

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel met urenregistratie per (deel)zaak

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tburen

Rules

There are no rules for table tburen

Policies

There are no policies for table tburen

Referenced

There are no tables referenced by table tburen

Properties

Definition

CREATE TABLE public.tburen (
 dnkey SERIAL,
 dnkeysoorturen INTEGER,
 dnkeyinspecties INTEGER,
 dnkeyadviezen INTEGER,
 dnkeybezwaarberoep INTEGER,
 dnkeyomgvergunningen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhandhavingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeymilinrichtingen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dfaantaluur DOUBLE PRECISION,
 ddurendatum TIMESTAMP WITHOUT TIME ZONE,
 dvtoelichting VARCHAR(4000),
 ddgefactureerd TIMESTAMP WITHOUT TIME ZONE,
 dlopdrachtgeverakkoord CHAR(1) DEFAULT 'F'::bpchar,
 dvcodeurengemaaktdoor CHAR(5),
 dvcodelaatstemuteerder CHAR(5),
 dnkeyhorecavergunningen INTEGER,
 CONSTRAINT cpk_tburen PRIMARY KEY(dnkey),
 CONSTRAINT chk_uren_dlopdrachtgeverakk CHECK (dlopdrachtgeverakkoord = ANY (ARRAY['F'::bpchar, 'T'::bpchar, 'N'::bpchar])),
 CONSTRAINT cnn_tburen_keyverg CHECK (((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NOT NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NOT NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyinfoaanvraag IS NOT NULL))),
 CONSTRAINT cnn_uren_codelaatstmut CHECK (dvcodelaatstemuteerder IS NOT NULL),
 CONSTRAINT cnn_uren_codeurengemaakt CHECK (dvcodeurengemaaktdoor IS NOT NULL),
 CONSTRAINT cnn_uren_dlopdrachtgeverakk CHECK (dlopdrachtgeverakkoord IS NOT NULL),
 CONSTRAINT cnn_uren_keysoorturen CHECK (dnkeysoorturen IS NOT NULL),
 CONSTRAINT cfk_uren_codelaatstmut FOREIGN KEY (dvcodelaatstemuteerder)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_codeurengemaakt FOREIGN KEY (dvcodeurengemaaktdoor)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyadviezen FOREIGN KEY (dnkeyadviezen)
   REFERENCES public.tbadviezen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keybezwaarberoep FOREIGN KEY (dnkeybezwaarberoep)
   REFERENCES public.tbbezwaarberoep(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keybouwvergunningen FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyhandavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyhorecavergunningen FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyinfoaanvraag FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyinspecties FOREIGN KEY (dnkeyinspecties)
   REFERENCES public.tbinspecties(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keymilinrichtingen FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keymilvergunningen FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyomgvergunningen FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keyovvergunningen FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_uren_keysoorturen FOREIGN KEY (dnkeysoorturen)
   REFERENCES public.tbsoorturen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tburen
IS 'Tabel met urenregistratie per (deel)zaak';

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

COMMENT ON COLUMN public.tburen.dnkeysoorturen
IS 'Foreign key naar tbsoorturen.dnkey';

COMMENT ON COLUMN public.tburen.dnkeyinspecties
IS 'Foreign key naar tbinspecties.dnkey';

COMMENT ON COLUMN public.tburen.dnkeyadviezen
IS 'Foreign key naar tbadviezen.dnkey';

COMMENT ON COLUMN public.tburen.dnkeybezwaarberoep
IS 'Foreign key naar tbbezwaarberoep.dnkey';

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

COMMENT ON COLUMN public.tburen.dnkeybouwvergunningen
IS 'Foreign key naar tbbouwvergunningen.dnkey';

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

COMMENT ON COLUMN public.tburen.dnkeyhandhavingen
IS 'Foreign key naar tbhandhavingen.dnkey';

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

COMMENT ON COLUMN public.tburen.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey';

COMMENT ON COLUMN public.tburen.dnkeyinfoaanvraag
IS 'Foreign key naar tbinfoaanvragen.dnkey';

COMMENT ON COLUMN public.tburen.dfaantaluur
IS 'Aantal uren gemaakt op ddurendatum (mag groter zijn dan 24, maar klainer dan 100)';

COMMENT ON COLUMN public.tburen.ddurendatum
IS 'Datum dat uren gemaakt zijn';

COMMENT ON COLUMN public.tburen.dvtoelichting
IS 'Toelichting';

COMMENT ON COLUMN public.tburen.ddgefactureerd
IS 'Datum dat uren klaargezet zijn tot facturatie';

COMMENT ON COLUMN public.tburen.dlopdrachtgeverakkoord
IS 'T, F of N. N = Nog niet bekend';

COMMENT ON COLUMN public.tburen.dvcodeurengemaaktdoor
IS 'Foreign key naar tbmedewerkers.dvcode voor degene die de uten gemakt heeft';

COMMENT ON COLUMN public.tburen.dvcodelaatstemuteerder
IS 'Foreign key naar tbmedewerkers.dvcode voor degene die als laatste de utenkaart heeft overschreven';

COMMENT ON COLUMN public.tburen.dnkeyhorecavergunningen
IS 'Foreign key naar tbhorecavergunningen.dnkey';

CREATE INDEX idx_tburen_codeurengem ON public.tburen
 USING btree (dvcodeurengemaaktdoor COLLATE pg_catalog."default");

CREATE INDEX idx_tburen_ddgefactureerd ON public.tburen
 USING btree (ddgefactureerd);

CREATE INDEX idx_tburen_keyadviezen ON public.tburen
 USING btree (dnkeyadviezen);

CREATE INDEX idx_tburen_keybezwaarberoep ON public.tburen
 USING btree (dnkeybezwaarberoep);

CREATE INDEX idx_tburen_keybouwverg ON public.tburen
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_tburen_keyhandhavingen ON public.tburen
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_tburen_keyhorverg ON public.tburen
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_tburen_keyinfoaanvr ON public.tburen
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_tburen_keyinspecties ON public.tburen
 USING btree (dnkeyinspecties);

CREATE INDEX idx_tburen_keymilinricht ON public.tburen
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_tburen_keymilverg ON public.tburen
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_tburen_keyomgverg ON public.tburen
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_tburen_keyovverg ON public.tburen
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_tburen_urendatum ON public.tburen
 USING btree (ddurendatum);

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