Datadictionary OpenWave 3.1.25 |
|
Table: tbhandhinvorderingen
Datadictionary OpenWave 3.1.25 |
|
Table: tbhandhinvorderingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met invorderingen n.a.v. een handhavingszaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhandhinvorderingen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign key naar TbHandhavingen. |
|
|
dnkeysoortinvordering |
integer |
|
|
|
|
Foreign key naar TbSoortInvorderingen. |
|
|
dvomschrijving |
varchar(50) |
|
|
|
|
Omschrijving van de invordering. |
|
|
dddatum |
timestamp |
|
|
|
|
Datum van invordering. |
|
|
dfbedrag |
double precision |
|
|
|
|
Bedrag in Euro van invordering. |
|
|
ddafgehandeld |
timestamp |
|
|
|
|
Datum dat invordering is afgehandeld. |
|
|
dnkeybestmaatreg |
integer |
|
|
|
|
Foreign key naar Tbbestmaatreg.dnkey. De bestuurlijke maatregel bij dezelfde handhavingzaak waar de invordering op is gebaseerd |
|
|
ddsluiting |
timestamp |
|
|
|
|
Sluitingsdatum invordering |
|
|
dlbegtermverlengd |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is begunstigingstermijn verlengd. |
|
|
dluitstelbetverl |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is uitstel tot betaling verleend. |
|
|
ddbegtermverltot |
timestamp |
|
|
|
|
Datum - indien bekend - tot wanneer begunstigingstermijn is verlengd |
|
|
dduitstbetverltot |
timestamp |
|
|
|
|
Datum - indien bekend - tot wanneer uitstel tot betaling is verleend |
|
|
ddinvorderingsbeschikking |
timestamp |
|
|
|
|
Datum van de beschikking van de invordering |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_handhinvord_keybestmaatreg |
dnkeybestmaatreg |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbhhinv_handh |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbhhinv_soortinv |
dnkeysoortinvordering |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbhandhinv_dlbegtermverl |
dlbegtermverlengd = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhandhinv_dluitstbetverl |
dluitstelbetverl = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_handhinv_dnkeyhandh |
dnkeyhandhavingen IS NOT NULL |
|
cnn_handhinv_dnkeysrtinv |
dnkeysoortinvordering IS NOT NULL |
|
cnn_tbhandhinv_dlbegtermverl |
dlbegtermverlengd IS NOT NULL |
|
cnn_tbhandhinv_dluitstbetverl |
dluitstelbetverl IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhandhinvorderingen |
btree |
|
dnkey |
|
|
|
idx_handhinvord_ddafgehandeld |
btree |
|
ddafgehandeld |
|
|
|
idx_tbhhinvord_handh |
btree |
|
dnkeyhandhavingen |
|
|
|
idx_tbhhinvord_soort |
btree |
|
dnkeysoortinvordering |
|
|
|
Triggers
There are no triggers for table tbhandhinvorderingen
Rules
There are no rules for table tbhandhinvorderingen
Policies
There are no policies for table tbhandhinvorderingen
Referenced
There are no tables referenced by table tbhandhinvorderingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhandhavingen INTEGER,
dnkeysoortinvordering INTEGER,
dvomschrijving VARCHAR(50),
dddatum TIMESTAMP WITHOUT TIME ZONE,
dfbedrag DOUBLE PRECISION,
ddafgehandeld TIMESTAMP WITHOUT TIME ZONE,
dnkeybestmaatreg INTEGER,
ddsluiting TIMESTAMP WITHOUT TIME ZONE,
dlbegtermverlengd CHAR(1) DEFAULT 'F'::bpchar,
dluitstelbetverl CHAR(1) DEFAULT 'F'::bpchar,
ddbegtermverltot TIMESTAMP WITHOUT TIME ZONE,
dduitstbetverltot TIMESTAMP WITHOUT TIME ZONE,
ddinvorderingsbeschikking TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbhandhinvorderingen PRIMARY KEY(dnkey),
CONSTRAINT chk_tbhandhinv_dlbegtermverl CHECK (dlbegtermverlengd = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_tbhandhinv_dluitstbetverl CHECK (dluitstelbetverl = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_handhinv_dnkeyhandh CHECK (dnkeyhandhavingen IS NOT NULL),
CONSTRAINT cnn_handhinv_dnkeysrtinv CHECK (dnkeysoortinvordering IS NOT NULL),
CONSTRAINT cnn_tbhandhinv_dlbegtermverl CHECK (dlbegtermverlengd IS NOT NULL),
CONSTRAINT cnn_tbhandhinv_dluitstbetverl CHECK (dluitstelbetverl IS NOT NULL),
CONSTRAINT cfk_handhinvord_keybestmaatreg FOREIGN KEY (dnkeybestmaatreg)
REFERENCES public.tbbestmaatreg(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhhinv_handh FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhhinv_soortinv FOREIGN KEY (dnkeysoortinvordering)
REFERENCES public.tbsoortinvordering(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhandhinvorderingen
IS 'Tabel met invorderingen n.a.v. een handhavingszaak';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkeysoortinvordering
IS 'Foreign key naar TbSoortInvorderingen.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dvomschrijving
IS 'Omschrijving van de invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dddatum
IS 'Datum van invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dfbedrag
IS 'Bedrag in Euro van invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.ddafgehandeld
IS 'Datum dat invordering is afgehandeld.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkeybestmaatreg
IS 'Foreign key naar Tbbestmaatreg.dnkey. De bestuurlijke maatregel bij dezelfde handhavingzaak waar de invordering op is gebaseerd';
COMMENT ON COLUMN public.tbhandhinvorderingen.ddsluiting
IS 'Sluitingsdatum invordering';
COMMENT ON COLUMN public.tbhandhinvorderingen.dlbegtermverlengd
IS 'T of F. Indien T dan is begunstigingstermijn verlengd.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dluitstelbetverl
IS 'T of F. Indien T dan is uitstel tot betaling verleend.';
COMMENT ON COLUMN public.tbhandhinvorderingen.ddbegtermverltot
IS 'Datum - indien bekend - tot wanneer begunstigingstermijn is verlengd';
COMMENT ON COLUMN public.tbhandhinvorderingen.dduitstbetverltot
IS 'Datum - indien bekend - tot wanneer uitstel tot betaling is verleend';
COMMENT ON COLUMN public.tbhandhinvorderingen.ddinvorderingsbeschikking
IS 'Datum van de beschikking van de invordering';
CREATE INDEX idx_handhinvord_ddafgehandeld ON public.tbhandhinvorderingen
USING btree (ddafgehandeld);
CREATE INDEX idx_tbhhinvord_handh ON public.tbhandhinvorderingen
USING btree (dnkeyhandhavingen);
CREATE INDEX idx_tbhhinvord_soort ON public.tbhandhinvorderingen
USING btree (dnkeysoortinvordering);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|