Datadictionary OpenWave 3.1.25 |
|
Table: tbhandhdwangsom
Datadictionary OpenWave 3.1.25 |
|
Table: tbhandhdwangsom
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Depricated sinds versie 3.1.15. Zie tbbestmaatreg. Tabel met opgelegde dwangsommen per handhavingzaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhandhdwangsom_dnkey_seq'::regclass) |
Prmary key |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign key naar TbHandhavingen. |
|
|
dvdwangsomeenheid |
varchar(40) |
|
|
|
|
Eenheid waarop dwangsom gebaseerd is. Bijvoorbeeld dag of tak. |
|
|
ddstartdwangsom |
timestamp |
|
|
|
|
Datum waarop dwangsom-maatregel van kracht is. |
|
|
dfdwangsombedrag |
double precision |
|
|
|
|
Bedrag per eenheid. Euro. |
|
|
dfdwangsommax |
double precision |
|
|
|
|
Maximum invorderbaar bedrag aan dwangsom. Euro. |
|
|
dvomschrijving |
varchar(200) |
|
|
|
|
Beschrijving van de dwangsom. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_handhdwangsom_keyhandh |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbhandhdwangsom
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhandhdwangsom |
btree |
|
dnkey |
|
|
|
idx_handhdwangsom_keyhandh |
btree |
|
dnkeyhandhavingen |
|
|
|
Triggers
There are no triggers for table tbhandhdwangsom
Rules
There are no rules for table tbhandhdwangsom
Policies
There are no policies for table tbhandhdwangsom
Referenced
There are no tables referenced by table tbhandhdwangsom
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhandhavingen INTEGER,
dvdwangsomeenheid VARCHAR(40),
ddstartdwangsom TIMESTAMP WITHOUT TIME ZONE,
dfdwangsombedrag DOUBLE PRECISION,
dfdwangsommax DOUBLE PRECISION,
dvomschrijving VARCHAR(200),
CONSTRAINT cpk_tbhandhdwangsom PRIMARY KEY(dnkey),
CONSTRAINT cfk_handhdwangsom_keyhandh FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhandhdwangsom
IS 'Depricated sinds versie 3.1.15. Zie tbbestmaatreg. Tabel met opgelegde dwangsommen per handhavingzaak';
COMMENT ON COLUMN public.tbhandhdwangsom.dnkey
IS 'Prmary key';
COMMENT ON COLUMN public.tbhandhdwangsom.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.';
COMMENT ON COLUMN public.tbhandhdwangsom.dvdwangsomeenheid
IS 'Eenheid waarop dwangsom gebaseerd is. Bijvoorbeeld dag of tak.';
COMMENT ON COLUMN public.tbhandhdwangsom.ddstartdwangsom
IS 'Datum waarop dwangsom-maatregel van kracht is.';
COMMENT ON COLUMN public.tbhandhdwangsom.dfdwangsombedrag
IS 'Bedrag per eenheid. Euro.';
COMMENT ON COLUMN public.tbhandhdwangsom.dfdwangsommax
IS 'Maximum invorderbaar bedrag aan dwangsom. Euro.';
COMMENT ON COLUMN public.tbhandhdwangsom.dvomschrijving
IS 'Beschrijving van de dwangsom.';
CREATE INDEX idx_handhdwangsom_keyhandh ON public.tbhandhdwangsom
USING btree (dnkeyhandhavingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|