Datadictionary OpenWave 3.1.11 |
|
Table: tbmilcodestaldier
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilcodestaldier
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met combinaties stal en dier met de milieubelasting in mestverwerkingseenheden, ammoniak, fijnstof en odeurunits conform RAV (Regeling Ammoniak en Veehouderij) en RGV (Regeling geurhinder en veehouderij)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilcodestaldier_dnkey_seq'::regclass) |
Primary Key. |
|
|
dvcodedier |
varchar(10) |
|
|
|
|
Samen met dvDierrichtlijn foreign key naar TbMilCodeDier. |
|
|
dvcodestal |
varchar(15) |
|
|
|
|
Samen met dvstalrichtlijn Foreign key naar TbMilCodeStal. |
|
|
dfdierenpermve |
double precision |
|
|
|
|
Aantal dieren in de stal die zorg dragen voor 1 MVE. |
|
|
dfnh3factor |
double precision |
|
|
|
|
Amminiakuitstoot in Kg per jaar per dier. |
|
|
dfodeurfactor |
double precision |
|
|
|
|
Odeurunitaantallen per seconde per jaar per dier. |
|
|
dvrichtlijn |
varchar(10) |
|
|
|
|
Richtlijnduiding. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum van combinatie stal/dier. |
|
|
dvstalrichtlijn |
varchar(10) |
|
|
|
|
Richtlijnduiding van stal. Samen met dvcodestal foreign key naar TbMilCodeStal. |
|
|
dvdierrichtlijn |
varchar(10) |
|
|
|
|
Richtlijnduiding van dier. Samen met dvcodedier foreign key naar TbMilCodeDier. |
|
|
dffijnstof |
double precision |
|
|
|
|
Fijnstof in gram per jaar per dier. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilcodestaldier_codedier |
dvcodedier, dvdierrichtlijn |
dvcode, dvrichtlijn |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilcodestaldier_codestal |
dvcodestal, dvstalrichtlijn |
dvcode, dvrichtlijn |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_codestaldier_dvdierrln |
dvdierrichtlijn IS NOT NULL |
|
cnn_codestaldier_dvstalrln |
dvstalrichtlijn IS NOT NULL |
|
cnn_milcodestaldier_codedier |
dvcodedier IS NOT NULL |
|
cnn_milcodestaldier_codestal |
dvcodestal IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcodestaldier |
btree |
|
dnkey |
|
|
|
idx_milcodestaldier_codedier |
btree |
|
dvcodedier |
|
|
|
idx_milcodestaldier_codestal |
btree |
|
dvcodestal |
|
|
|
idx_milcodestaldier_dvdierrln |
btree |
|
dvdierrichtlijn |
|
|
|
idx_milcodestaldier_dvstalrln |
btree |
|
dvstalrichtlijn |
|
|
|
idx_milcodestaldier_richtlijn |
btree |
|
dvrichtlijn |
|
|
|
idx_milcodestaldier_vervaldat |
btree |
|
ddvervaldatum |
|
|
|
Triggers
There are no triggers for table tbmilcodestaldier
Rules
There are no rules for table tbmilcodestaldier
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilemstal_tbmilcdstldr |
dnkeymilcodestaldier |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodedier VARCHAR(10),
dvcodestal VARCHAR(15),
dfdierenpermve DOUBLE PRECISION,
dfnh3factor DOUBLE PRECISION,
dfodeurfactor DOUBLE PRECISION,
dvrichtlijn VARCHAR(10),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dvstalrichtlijn VARCHAR(10),
dvdierrichtlijn VARCHAR(10),
dffijnstof DOUBLE PRECISION,
CONSTRAINT cpk_tbmilcodestaldier PRIMARY KEY(dnkey),
CONSTRAINT cnn_codestaldier_dvdierrln CHECK (dvdierrichtlijn IS NOT NULL),
CONSTRAINT cnn_codestaldier_dvstalrln CHECK (dvstalrichtlijn IS NOT NULL),
CONSTRAINT cnn_milcodestaldier_codedier CHECK (dvcodedier IS NOT NULL),
CONSTRAINT cnn_milcodestaldier_codestal CHECK (dvcodestal IS NOT NULL),
CONSTRAINT cfk_tbmilcodestaldier_codedier FOREIGN KEY (dvcodedier, dvdierrichtlijn)
REFERENCES public.tbmilcodedier(dvcode, dvrichtlijn)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilcodestaldier_codestal FOREIGN KEY (dvcodestal, dvstalrichtlijn)
REFERENCES public.tbmilcodestal(dvcode, dvrichtlijn)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilcodestaldier
IS 'Tabel met combinaties stal en dier met de milieubelasting in mestverwerkingseenheden, ammoniak, fijnstof en odeurunits conform RAV (Regeling Ammoniak en Veehouderij) en RGV (Regeling geurhinder en veehouderij)';
COMMENT ON COLUMN public.tbmilcodestaldier.dnkey
IS 'Primary Key.';
COMMENT ON COLUMN public.tbmilcodestaldier.dvcodedier
IS 'Samen met dvDierrichtlijn foreign key naar TbMilCodeDier.';
COMMENT ON COLUMN public.tbmilcodestaldier.dvcodestal
IS 'Samen met dvstalrichtlijn Foreign key naar TbMilCodeStal.';
COMMENT ON COLUMN public.tbmilcodestaldier.dfdierenpermve
IS 'Aantal dieren in de stal die zorg dragen voor 1 MVE.';
COMMENT ON COLUMN public.tbmilcodestaldier.dfnh3factor
IS 'Amminiakuitstoot in Kg per jaar per dier.';
COMMENT ON COLUMN public.tbmilcodestaldier.dfodeurfactor
IS 'Odeurunitaantallen per seconde per jaar per dier.';
COMMENT ON COLUMN public.tbmilcodestaldier.dvrichtlijn
IS 'Richtlijnduiding.';
COMMENT ON COLUMN public.tbmilcodestaldier.ddvervaldatum
IS 'Vervaldatum van combinatie stal/dier.';
COMMENT ON COLUMN public.tbmilcodestaldier.dvstalrichtlijn
IS 'Richtlijnduiding van stal. Samen met dvcodestal foreign key naar TbMilCodeStal.';
COMMENT ON COLUMN public.tbmilcodestaldier.dvdierrichtlijn
IS 'Richtlijnduiding van dier. Samen met dvcodedier foreign key naar TbMilCodeDier.';
COMMENT ON COLUMN public.tbmilcodestaldier.dffijnstof
IS 'Fijnstof in gram per jaar per dier.';
CREATE INDEX idx_milcodestaldier_codedier ON public.tbmilcodestaldier
USING btree (dvcodedier COLLATE pg_catalog."default");
CREATE INDEX idx_milcodestaldier_codestal ON public.tbmilcodestaldier
USING btree (dvcodestal COLLATE pg_catalog."default");
CREATE INDEX idx_milcodestaldier_dvdierrln ON public.tbmilcodestaldier
USING btree (dvdierrichtlijn COLLATE pg_catalog."default");
CREATE INDEX idx_milcodestaldier_dvstalrln ON public.tbmilcodestaldier
USING btree (dvstalrichtlijn COLLATE pg_catalog."default");
CREATE INDEX idx_milcodestaldier_richtlijn ON public.tbmilcodestaldier
USING btree (dvrichtlijn COLLATE pg_catalog."default");
CREATE INDEX idx_milcodestaldier_vervaldat ON public.tbmilcodestaldier
USING btree (ddvervaldatum);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|