Datadictionary OpenWave 3.1.11

Table: tblegesregels

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel van legesbedragen per vergunning (bouw/sloop, overig, omgeving, info-aanvraag, horeca)

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tblegesregels

Rules

There are no rules for table tblegesregels

Referenced

There are no tables referenced by table tblegesregels

Properties

Definition

CREATE TABLE public.tblegesregels (
 dnkey SERIAL,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeylegessoort INTEGER,
 dlautoberekening CHAR(1) DEFAULT 'T'::bpchar,
 dflegesbedrag DOUBLE PRECISION,
 dvomschrijving VARCHAR(50),
 dvnotanummer VARCHAR(20),
 ddexportdatum TIMESTAMP WITHOUT TIME ZONE,
 dnkeyhorecavergunningen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeyomgvergunningen INTEGER,
 dnkeytoestemmingen INTEGER,
 dnlegesmoment INTEGER,
 ddcontrole TIMESTAMP WITHOUT TIME ZONE,
 dvcodemwcontrole CHAR(5),
 CONSTRAINT cpk_tblegesregels PRIMARY KEY(dnkey),
 CONSTRAINT cnn_legesreg_keyleges CHECK (dnkeylegessoort IS NOT NULL),
 CONSTRAINT cnn_legesreg_keytoest CHECK (((dnkeytoestemmingen IS NOT NULL) AND (dnkeyomgvergunningen IS NOT NULL)) OR (dnkeytoestemmingen IS NULL)),
 CONSTRAINT cnn_legesreg_keyverg CHECK (((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL)) OR (((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL))),
 CONSTRAINT cfk_legesregels_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_codemwcontr FOREIGN KEY (dvcodemwcontrole)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_keyomgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_keytoest FOREIGN KEY (dnkeytoestemmingen)
   REFERENCES public.tbtoestemmingen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_legessoort FOREIGN KEY (dnkeylegessoort)
   REFERENCES public.tblegessoort(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_legesregels_ovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tblegesregels
IS 'Tabel van legesbedragen per vergunning (bouw/sloop, overig, omgeving, info-aanvraag, horeca)';

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

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

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

COMMENT ON COLUMN public.tblegesregels.dnkeylegessoort
IS 'Foreign key naar TblegesSoort.dnkey';

COMMENT ON COLUMN public.tblegesregels.dlautoberekening
IS 'T of F.  Indien T dan gaat Wave ervanuit dat de berekening van de leges  automatisch kan plaatsvinden op grond van het uitgangsbedrag en de tabel TbLegesBerekening.';

COMMENT ON COLUMN public.tblegesregels.dflegesbedrag
IS 'LegesBedrag (euro).';

COMMENT ON COLUMN public.tblegesregels.dvomschrijving
IS 'Extra omschrijving van het legesbedrag.';

COMMENT ON COLUMN public.tblegesregels.dvnotanummer
IS 'Veld t.b.v. doorsluizen naar financieel systeem: eigen nummering.';

COMMENT ON COLUMN public.tblegesregels.ddexportdatum
IS 'Exportdatum dat legesregel geexporteerd is. Blokkeert tevens de legesregel.';

COMMENT ON COLUMN public.tblegesregels.dnkeyhorecavergunningen
IS 'Foreign key naar tabel TbHorecavergunningen.dnkey.';

COMMENT ON COLUMN public.tblegesregels.dnkeyinfoaanvraag
IS 'Foreign key naar tabel TbInfoAanvragen.dnkey.';

COMMENT ON COLUMN public.tblegesregels.dnkeyomgvergunningen
IS 'Foreign key naar tabel TbOmgvergunning.dnkey. Indien dnkeytoestemmingen is gevuld dan moet ook DnkeyOmgVergunningen zijn gevuld.';

COMMENT ON COLUMN public.tblegesregels.dnkeytoestemmingen
IS 'Foreign key naar tabel TbToestemmingen.dnkey. Indien dnkeytoestemmingen is gevuld dan moet ook DnkeyOmgVergunningen zijn gevuld.';

COMMENT ON COLUMN public.tblegesregels.dnlegesmoment
IS 'Behandelingsfase waarin legesregel is gecreerd: 1 = indiening, 2 = behandeling, 3  = besluit, andere waardes: onbekend';

COMMENT ON COLUMN public.tblegesregels.ddcontrole
IS 'Datum, dat legesregel is goedgekeurd om bijv. te worden geexporteerd naar financieeel systeem';

COMMENT ON COLUMN public.tblegesregels.dvcodemwcontrole
IS 'Foreign key naar de medewerker (tbmedewerker.dvcode) die legesregel heeft goedgekeurd om bijv. te worden geexporteerd naar financieeel systeem';

CREATE INDEX idx_legesregels_horecaverg ON public.tblegesregels
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_legesregels_keybouwverg ON public.tblegesregels
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_legesregels_keyinfo ON public.tblegesregels
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_legesregels_keylegessoort ON public.tblegesregels
 USING btree (dnkeylegessoort);

CREATE INDEX idx_legesregels_keyomgverg ON public.tblegesregels
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_legesregels_keyovvergunnin ON public.tblegesregels
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_legesregels_keytoest ON public.tblegesregels
 USING btree (dnkeytoestemmingen);

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