Datadictionary OpenWave 3.1.21 |
|
Table: tbmilafvalstoffen
Datadictionary OpenWave 3.1.21 |
|
Table: tbmilafvalstoffen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel waarin per inrichting de afvalstofregistraties vast te leggen zijn
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilafvalstoffen_dnkey_seq'::regclass) |
Primary key van de tabel |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar tbmilinrichtingen.dnkey |
|
|
dvnaamafvalstof |
varchar(60) |
|
|
|
|
Omschrijving waaronder de afvalstofregistratie bekend staat |
|
|
dfvolume |
double precision |
|
|
|
|
Hoeveelheid van de afvalstof |
|
|
dveenheid |
varchar(40) |
|
|
|
|
Eenheid waarin volume wordt uitgedrukt. Keuze uit m3, kilo en liter |
|
|
dveuralcode |
varchar(40) |
|
|
|
|
Euralcode van de afvalstof |
|
|
dvvervoerder |
varchar(200) |
|
|
|
|
Vervoerder van de afvalstof |
|
|
dnkeymilsrtopslag |
integer |
|
|
|
|
Foreign key naar tbmilsrtopslag.dnkey |
|
|
dnkeymilsrtafvstof |
integer |
|
|
|
|
Foreign key naar tbmilsrtafvalstof.dnkey. |
|
|
dvopmerking |
varchar(500) |
|
|
|
|
Vrij notitieveld |
|
|
dvxcrd |
varchar(20) |
|
|
|
|
X-coordinaat van locatie afvalstof |
|
|
dvycrd |
varchar(20) |
|
|
|
|
Y-coordinaat van locatie afvalstof |
|
|
dvzcrd |
varchar(20) |
|
|
|
|
Z-coordinaat van locatie afvalstof |
|
|
dfgmlradius |
double precision |
|
|
|
|
Radius in meters rondom het punt dvxcrd, dvycrd |
|
|
dvgmlpolygoon |
varchar(4000) |
|
|
|
|
Contour van de opslag conform een gml polygoon |
|
|
dnkeyomsradius |
integer |
|
|
|
|
Foreign key naar tbmilomsradius.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilafv_dnkeymilsrtafstof |
dnkeymilsrtafvstof |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilafv_dnkeymilsrtopsl |
dnkeymilsrtopslag |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilafv_dnkeyomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilafval_dnkeymil |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milafval_dnkey |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_milafval_naam |
dvnaamafvalstof IS NOT NULL |
|
cnn_milafval_srtstof |
dnkeymilsrtafvstof IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilafvalstoffen |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilafvalstoffen
Rules
There are no rules for table tbmilafvalstoffen
Referenced
There are no tables referenced by table tbmilafvalstoffen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER,
dvnaamafvalstof VARCHAR(60),
dfvolume DOUBLE PRECISION,
dveenheid VARCHAR(40),
dveuralcode VARCHAR(40),
dvvervoerder VARCHAR(200),
dnkeymilsrtopslag INTEGER,
dnkeymilsrtafvstof INTEGER,
dvopmerking VARCHAR(500),
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvzcrd VARCHAR(20),
dfgmlradius DOUBLE PRECISION,
dvgmlpolygoon VARCHAR(4000),
dnkeyomsradius INTEGER,
CONSTRAINT cpk_tbmilafvalstoffen PRIMARY KEY(dnkey),
CONSTRAINT cnn_milafval_dnkey CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_milafval_naam CHECK (dvnaamafvalstof IS NOT NULL),
CONSTRAINT cnn_milafval_srtstof CHECK (dnkeymilsrtafvstof IS NOT NULL),
CONSTRAINT cfk_tbmilafv_dnkeymilsrtafstof FOREIGN KEY (dnkeymilsrtafvstof)
REFERENCES public.tbmilsrtafvalstof(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilafv_dnkeymilsrtopsl FOREIGN KEY (dnkeymilsrtopslag)
REFERENCES public.tbmilsrtopslag(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilafv_dnkeyomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilafval_dnkeymil FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilafvalstoffen
IS 'Tabel waarin per inrichting de afvalstofregistraties vast te leggen zijn';
COMMENT ON COLUMN public.tbmilafvalstoffen.dnkey
IS 'Primary key van de tabel';
COMMENT ON COLUMN public.tbmilafvalstoffen.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvnaamafvalstof
IS 'Omschrijving waaronder de afvalstofregistratie bekend staat';
COMMENT ON COLUMN public.tbmilafvalstoffen.dfvolume
IS 'Hoeveelheid van de afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dveenheid
IS 'Eenheid waarin volume wordt uitgedrukt. Keuze uit m3, kilo en liter';
COMMENT ON COLUMN public.tbmilafvalstoffen.dveuralcode
IS 'Euralcode van de afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvvervoerder
IS 'Vervoerder van de afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dnkeymilsrtopslag
IS 'Foreign key naar tbmilsrtopslag.dnkey';
COMMENT ON COLUMN public.tbmilafvalstoffen.dnkeymilsrtafvstof
IS 'Foreign key naar tbmilsrtafvalstof.dnkey.';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvopmerking
IS 'Vrij notitieveld';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvxcrd
IS 'X-coordinaat van locatie afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvycrd
IS 'Y-coordinaat van locatie afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvzcrd
IS 'Z-coordinaat van locatie afvalstof';
COMMENT ON COLUMN public.tbmilafvalstoffen.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd';
COMMENT ON COLUMN public.tbmilafvalstoffen.dvgmlpolygoon
IS 'Contour van de opslag conform een gml polygoon';
COMMENT ON COLUMN public.tbmilafvalstoffen.dnkeyomsradius
IS 'Foreign key naar tbmilomsradius.dnkey';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-10-2020 12:10 |
|