Datadictionary OpenWave 3.1.25 |
|
Table: tbbestmaatreg
Datadictionary OpenWave 3.1.25 |
|
Table: tbbestmaatreg
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met bestuurlijke maatregelen bij handhaving (vervangt tbhandhdwangsom)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbbestmaatreg_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign Key naar Tbhandhavingen.DnKey. |
|
|
dnkeysrtbestmaatr |
integer |
|
|
|
|
Foreign Key naar Tbsrtbestmaatr.DnKey. |
|
|
ddbesluit |
timestamp |
|
|
|
|
Datum besluit bestuurlijke maatregel |
|
|
ddeindetermijn |
timestamp |
|
|
|
|
Datum einde bestuurlijke maatregel |
|
|
ddoptreden |
timestamp |
|
|
|
|
Datum optreden |
|
|
dfbedrag |
double precision |
|
|
|
|
Bedrag per eenheid. Euro |
|
|
dfmaxbedrag |
double precision |
|
|
|
|
Maximun bedrag |
|
|
dveenheid |
varchar(40) |
|
|
|
|
Eenheid zoals dag, vierkante meter |
|
|
dvkorteoms |
varchar(100) |
|
|
|
|
Korte omschrijivng |
|
|
dvlangeoms |
varchar(4000) |
|
|
|
|
Lange omschrijivng |
|
|
dvlink |
varchar(300) |
|
|
|
|
Link naar document |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_bestmaatreg_keyhandh |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_bestmaatreg_keysrtbest |
dnkeysrtbestmaatr |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbbestmaatreg
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbbestmaatreg |
btree |
|
dnkey |
|
|
|
idx_bestmaatreg_keyhandh |
btree |
|
dnkeyhandhavingen |
|
|
|
idx_bestmaatreg_keysrtbest |
btree |
|
dnkeysrtbestmaatr |
|
|
|
Triggers
There are no triggers for table tbbestmaatreg
Rules
There are no rules for table tbbestmaatreg
Policies
There are no policies for table tbbestmaatreg
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_handhinvord_keybestmaatreg |
dnkeybestmaatreg |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhandhavingen INTEGER,
dnkeysrtbestmaatr INTEGER,
ddbesluit TIMESTAMP WITHOUT TIME ZONE,
ddeindetermijn TIMESTAMP WITHOUT TIME ZONE,
ddoptreden TIMESTAMP WITHOUT TIME ZONE,
dfbedrag DOUBLE PRECISION,
dfmaxbedrag DOUBLE PRECISION,
dveenheid VARCHAR(40),
dvkorteoms VARCHAR(100),
dvlangeoms VARCHAR(4000),
dvlink VARCHAR(300),
CONSTRAINT cpk_tbbestmaatreg PRIMARY KEY(dnkey),
CONSTRAINT cfk_bestmaatreg_keyhandh FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_bestmaatreg_keysrtbest FOREIGN KEY (dnkeysrtbestmaatr)
REFERENCES public.tbsrtbestmaatr(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbbestmaatreg
IS 'Tabel met bestuurlijke maatregelen bij handhaving (vervangt tbhandhdwangsom)';
COMMENT ON COLUMN public.tbbestmaatreg.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbbestmaatreg.dnkeyhandhavingen
IS 'Foreign Key naar Tbhandhavingen.DnKey.';
COMMENT ON COLUMN public.tbbestmaatreg.dnkeysrtbestmaatr
IS 'Foreign Key naar Tbsrtbestmaatr.DnKey.';
COMMENT ON COLUMN public.tbbestmaatreg.ddbesluit
IS 'Datum besluit bestuurlijke maatregel';
COMMENT ON COLUMN public.tbbestmaatreg.ddeindetermijn
IS 'Datum einde bestuurlijke maatregel';
COMMENT ON COLUMN public.tbbestmaatreg.ddoptreden
IS 'Datum optreden';
COMMENT ON COLUMN public.tbbestmaatreg.dfbedrag
IS 'Bedrag per eenheid. Euro';
COMMENT ON COLUMN public.tbbestmaatreg.dfmaxbedrag
IS 'Maximun bedrag';
COMMENT ON COLUMN public.tbbestmaatreg.dveenheid
IS 'Eenheid zoals dag, vierkante meter';
COMMENT ON COLUMN public.tbbestmaatreg.dvkorteoms
IS 'Korte omschrijivng';
COMMENT ON COLUMN public.tbbestmaatreg.dvlangeoms
IS 'Lange omschrijivng';
COMMENT ON COLUMN public.tbbestmaatreg.dvlink
IS 'Link naar document';
CREATE INDEX idx_bestmaatreg_keyhandh ON public.tbbestmaatreg
USING btree (dnkeyhandhavingen);
CREATE INDEX idx_bestmaatreg_keysrtbest ON public.tbbestmaatreg
USING btree (dnkeysrtbestmaatr);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|