Datadictionary OpenWave 3.1.25 |
|
Table: tblegesregels
Datadictionary OpenWave 3.1.25 |
|
Table: tblegesregels
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van legesbedragen per vergunning (bouw/sloop, overig, omgeving, info-aanvraag, horeca)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tblegesregels_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeybouwvergunningen |
integer |
|
|
|
|
Foreign key naar TbBouwvergunningen.dnkey |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar TbOvVergunningen.dnkey |
|
|
dnkeylegessoort |
integer |
|
|
|
|
Foreign key naar TblegesSoort.dnkey |
|
|
dlautoberekening |
char(1) |
|
|
|
'T'::bpchar |
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. |
|
|
dflegesbedrag |
double precision |
|
|
|
|
LegesBedrag (euro). |
|
|
dvomschrijving |
varchar(100) |
|
|
|
|
Extra omschrijving van het legesbedrag. |
|
|
dvnotanummer |
varchar(20) |
|
|
|
|
Veld t.b.v. doorsluizen naar financieel systeem: eigen nummering. |
|
|
ddexportdatum |
timestamp |
|
|
|
|
Exportdatum dat legesregel geexporteerd is. Blokkeert tevens de legesregel. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar tabel TbHorecavergunningen.dnkey. |
|
|
dnkeyinfoaanvraag |
integer |
|
|
|
|
Foreign key naar tabel TbInfoAanvragen.dnkey. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tabel TbOmgvergunning.dnkey. Indien dnkeytoestemmingen is gevuld dan moet ook DnkeyOmgVergunningen zijn gevuld. |
|
|
dnkeytoestemmingen |
integer |
|
|
|
|
Foreign key naar tabel TbToestemmingen.dnkey. Indien dnkeytoestemmingen is gevuld dan moet ook DnkeyOmgVergunningen zijn gevuld. |
|
|
dnlegesmoment |
integer |
|
|
|
|
Behandelingsfase waarin legesregel is gecreerd: 1 = indiening, 2 = behandeling, 3 = besluit, andere waardes: onbekend |
|
|
ddcontrole |
timestamp |
|
|
|
|
Datum, dat legesregel is goedgekeurd om bijv. te worden geexporteerd naar financieeel systeem |
|
|
dvcodemwcontrole |
char(5) |
|
|
|
|
Foreign key naar de medewerker (tbmedewerker.dvcode) die legesregel heeft goedgekeurd om bijv. te worden geexporteerd naar financieeel systeem |
|
|
ddmutatie |
timestamp |
|
|
|
|
Datum, dat legesregel is aangemaakt cq dat dflegesbedrag of dnkeylegessoort of dnkeytoestemmingen is gewijzigd |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_legesregels_bouwverg |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_legesregels_codemwcontr |
dvcodemwcontrole |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_legesregels_horecaverg |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_legesregels_info |
dnkeyinfoaanvraag |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_legesregels_keyomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_legesregels_keytoest |
dnkeytoestemmingen |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_legesregels_legessoort |
dnkeylegessoort |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_legesregels_ovverg |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_legesreg_keyleges |
dnkeylegessoort IS NOT NULL |
|
cnn_legesreg_keytoest |
((dnkeytoestemmingen IS NOT NULL) AND (dnkeyomgvergunningen IS NOT NULL)) OR (dnkeytoestemmingen IS NULL) |
|
cnn_legesreg_keyverg |
((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)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tblegesregels |
btree |
|
dnkey |
|
|
|
idx_legesregels_horecaverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_legesregels_keybouwverg |
btree |
|
dnkeybouwvergunningen |
|
|
|
idx_legesregels_keyinfo |
btree |
|
dnkeyinfoaanvraag |
|
|
|
idx_legesregels_keylegessoort |
btree |
|
dnkeylegessoort |
|
|
|
idx_legesregels_keyomgverg |
btree |
|
dnkeyomgvergunningen |
|
|
|
idx_legesregels_keyovvergunnin |
btree |
|
dnkeyovvergunningen |
|
|
|
idx_legesregels_keytoest |
btree |
|
dnkeytoestemmingen |
|
|
|
Triggers
There are no triggers for table tblegesregels
Rules
There are no rules for table tblegesregels
Policies
There are no policies for table tblegesregels
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tblegesexport_keylegregel |
dnkeylegesregels |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeybouwvergunningen INTEGER,
dnkeyovvergunningen INTEGER,
dnkeylegessoort INTEGER,
dlautoberekening CHAR(1) DEFAULT 'T'::bpchar,
dflegesbedrag DOUBLE PRECISION,
dvomschrijving VARCHAR(100),
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),
ddmutatie TIMESTAMP WITHOUT TIME ZONE,
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
) ;
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';
COMMENT ON COLUMN public.tblegesregels.ddmutatie
IS 'Datum, dat legesregel is aangemaakt cq dat dflegesbedrag of dnkeylegessoort of dnkeytoestemmingen is gewijzigd';
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 5-1-2022 14:13 |
|