Datadictionary OpenWave 3.1.34 |
|
Table: tbmilemlucht
Datadictionary OpenWave 3.1.34 |
|
Table: tbmilemlucht
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met luchtemissiepunten per inrichting
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilemlucht_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilinrichtingen.dnkey. |
|
|
dvnaamlucht |
varchar(60) |
|
|
|
|
Naam van LuchtEmissiepunt. |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
|
|
|
dvxcrd |
varchar(20) |
|
|
|
|
X-coordinaat lozingspunt. |
|
|
dvycrd |
varchar(20) |
|
|
|
|
Y-coordinaat lozingspunt. |
|
|
dvzcrd |
varchar(20) |
|
|
|
|
Z-coordinaat lozingspunt. |
|
|
dlvos |
char(1) |
|
|
|
'F'::bpchar |
Is VOS (vluchtige organische stroffen) van toepassing, T of F. |
|
|
dlbeems |
char(1) |
|
|
|
'F'::bpchar |
Voorheen BEEMS (besluit emissie-eisen middelgrote stookinstallaties), nu: § 3.2.1 (Ab) van toepassing, T of F. |
|
|
dldrempelvos |
char(1) |
|
|
|
'F'::bpchar |
Overschrijding van de drempelwaarde VOS, T of F. |
|
|
dldrempelbeems |
char(1) |
|
|
|
'F'::bpchar |
Overschrijding van de drempelwaarde § 3.2.1 (Ab), T of F. |
|
|
dvgmlpolygoon |
text |
|
|
|
|
Contour van emissiepunt conform een gml polygoon. |
|
|
dfgmlradius |
double precision |
|
|
|
|
Radius in meters rondom het punt dvxcrd, dvycrd. |
|
|
dvbetekenisradius |
char(1) |
|
|
|
|
Heeft geen betekenis meer. Overgenomen door dnkeyomsradius. |
|
|
dnkeyomsradius |
integer |
|
|
|
|
Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend). |
|
|
dnkeymilzzsklasse |
integer |
|
|
|
|
Foreign key naar tbmilzzsklasse.dnkey. |
|
|
dddateringzzs |
timestamp |
|
|
|
|
Laatste datum waarop is geconstateerd dat het luchtemissiepunt zeer zorgwekkende stoffen vrijgeeft. |
|
|
dvrefdms |
varchar(40) |
|
|
|
|
Referentie naar externe zaak of dms waar een en ander is geboekstaafd omtrent de ZZS-constatering. |
|
|
dnkeymilrubriek |
integer |
|
|
|
|
Referentie naar tbmilrubriek.dnkey. |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilemlct_dnkeyomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilemlct_keymilzzskl |
dnkeymilzzsklasse |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilemlucht_keymilrubriek |
dnkeymilrubriek |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbmilemlucht_tbmilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milemlucht_dlbeems |
dlbeems = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milemlucht_dldrempbeems |
dldrempelbeems = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milemlucht_dldrempvos |
dldrempelvos = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milemlucht_dlvos |
dlvos = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_milemlucht_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_milemlucht_naam |
dvnaamlucht IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilemlucht |
btree |
|
dnkey |
|
|
|
idx_milemlucht_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilemlucht
Rules
There are no rules for table tbmilemlucht
Policies
There are no policies for table tbmilemlucht
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilemlctst_tbmilemlucht |
dnkeymilemlucht |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilemlctvz_tbmilemlucht |
dnkeymilemlucht |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER STORAGE PLAIN,
dvnaamlucht VARCHAR(60),
dvopmerking VARCHAR(100),
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvzcrd VARCHAR(20),
dlvos CHAR(1) DEFAULT 'F'::bpchar,
dlbeems CHAR(1) DEFAULT 'F'::bpchar,
dldrempelvos CHAR(1) DEFAULT 'F'::bpchar,
dldrempelbeems CHAR(1) DEFAULT 'F'::bpchar,
dvgmlpolygoon TEXT,
dfgmlradius DOUBLE PRECISION STORAGE PLAIN,
dvbetekenisradius CHAR(1),
dnkeyomsradius INTEGER STORAGE PLAIN,
dnkeymilzzsklasse INTEGER STORAGE PLAIN,
dddateringzzs TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvrefdms VARCHAR(40),
dnkeymilrubriek INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbmilemlucht PRIMARY KEY(dnkey),
CONSTRAINT chk_milemlucht_dlbeems CHECK (dlbeems = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milemlucht_dldrempbeems CHECK (dldrempelbeems = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milemlucht_dldrempvos CHECK (dldrempelvos = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milemlucht_dlvos CHECK (dlvos = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_milemlucht_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_milemlucht_naam CHECK (dvnaamlucht IS NOT NULL),
CONSTRAINT cfk_tbmilemlct_dnkeyomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemlct_keymilzzskl FOREIGN KEY (dnkeymilzzsklasse)
REFERENCES public.tbmilzzsklasse(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemlucht_keymilrubriek FOREIGN KEY (dnkeymilrubriek)
REFERENCES public.tbmilrubriek(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemlucht_tbmilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilemlucht
IS 'Tabel met luchtemissiepunten per inrichting';
COMMENT ON COLUMN public.tbmilemlucht.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilemlucht.dnkeymilinrichtingen
IS 'Foreign key naar TbMilinrichtingen.dnkey.';
COMMENT ON COLUMN public.tbmilemlucht.dvnaamlucht
IS 'Naam van LuchtEmissiepunt.';
COMMENT ON COLUMN public.tbmilemlucht.dvxcrd
IS 'X-coordinaat lozingspunt.';
COMMENT ON COLUMN public.tbmilemlucht.dvycrd
IS 'Y-coordinaat lozingspunt.';
COMMENT ON COLUMN public.tbmilemlucht.dvzcrd
IS 'Z-coordinaat lozingspunt.';
COMMENT ON COLUMN public.tbmilemlucht.dlvos
IS 'Is VOS (vluchtige organische stroffen) van toepassing, T of F.';
COMMENT ON COLUMN public.tbmilemlucht.dlbeems
IS 'Voorheen BEEMS (besluit emissie-eisen middelgrote stookinstallaties), nu: § 3.2.1 (Ab) van toepassing, T of F.';
COMMENT ON COLUMN public.tbmilemlucht.dldrempelvos
IS 'Overschrijding van de drempelwaarde VOS, T of F.';
COMMENT ON COLUMN public.tbmilemlucht.dldrempelbeems
IS 'Overschrijding van de drempelwaarde § 3.2.1 (Ab), T of F.';
COMMENT ON COLUMN public.tbmilemlucht.dvgmlpolygoon
IS 'Contour van emissiepunt conform een gml polygoon.';
COMMENT ON COLUMN public.tbmilemlucht.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd.';
COMMENT ON COLUMN public.tbmilemlucht.dvbetekenisradius
IS 'Heeft geen betekenis meer. Overgenomen door dnkeyomsradius.';
COMMENT ON COLUMN public.tbmilemlucht.dnkeyomsradius
IS 'Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend).';
COMMENT ON COLUMN public.tbmilemlucht.dnkeymilzzsklasse
IS 'Foreign key naar tbmilzzsklasse.dnkey.';
COMMENT ON COLUMN public.tbmilemlucht.dddateringzzs
IS 'Laatste datum waarop is geconstateerd dat het luchtemissiepunt zeer zorgwekkende stoffen vrijgeeft.';
COMMENT ON COLUMN public.tbmilemlucht.dvrefdms
IS 'Referentie naar externe zaak of dms waar een en ander is geboekstaafd omtrent de ZZS-constatering.';
COMMENT ON COLUMN public.tbmilemlucht.dnkeymilrubriek
IS 'Referentie naar tbmilrubriek.dnkey.';
CREATE INDEX idx_milemlucht_keymilinr ON public.tbmilemlucht
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|