Datadictionary OpenWave 3.1.34 |
|
Table: tbmilnagetech
Datadictionary OpenWave 3.1.34 |
|
Table: tbmilnagetech
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel waarin nageschakelde technieken bij stallen worden gecodeerd zoals E6.4.2H droogtunnel met geperforeerde metalen platen (0,002)
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilnagetech_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
varchar(15) |
|
|
|
|
Codering van nageschakelde techniek. |
|
|
dvomschrijving |
varchar(60) |
|
|
|
|
Omschrijving van Nageschakelde techniek. |
|
|
dvrichtlijn |
varchar(10) |
|
|
|
|
Richtlijnduiding. |
|
|
dfnh3invloed |
double precision |
|
|
|
|
Beinvloeding op Ammoniakuitstoot in Kg per jaar per dier. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum van techniek. |
|
|
dfouinvloed |
double precision |
|
|
|
|
Beinvloeding op geur in aantallen odeurunits per seconde per jaar per dier. |
|
|
dffijnstofinvloed |
double precision |
|
|
|
|
Beinvloeding op fijnstof in gram per jaar per dier. |
|
|
dnkeymilcodebwl |
integer |
|
|
|
|
Foreign key naar tbmilcodebwl.dnkey (bodem, water landelijk gebied). |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilnaget_keymilcodebwl |
dnkeymilcodebwl |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milnagetech_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilnagetech |
btree |
|
dnkey |
|
|
|
idx_milnagetech_code |
btree |
|
dvcode |
|
|
|
idx_milnagetech_vervaldatum |
btree |
|
ddvervaldatum |
|
|
|
Triggers
There are no triggers for table tbmilnagetech
Rules
There are no rules for table tbmilnagetech
Policies
There are no policies for table tbmilnagetech
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilemstal_dnkeymilnaget2 |
dnkeymilnagetech2 |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilemstal_tbnaget |
dnkeymilnagetech |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(15),
dvomschrijving VARCHAR(60),
dvrichtlijn VARCHAR(10),
dfnh3invloed DOUBLE PRECISION STORAGE PLAIN,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dfouinvloed DOUBLE PRECISION STORAGE PLAIN,
dffijnstofinvloed DOUBLE PRECISION STORAGE PLAIN,
dnkeymilcodebwl INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbmilnagetech PRIMARY KEY(dnkey),
CONSTRAINT cnn_milnagetech_dvcode CHECK (dvcode IS NOT NULL),
CONSTRAINT cfk_tbmilnaget_keymilcodebwl FOREIGN KEY (dnkeymilcodebwl)
REFERENCES public.tbmilcodebwl(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilnagetech
IS 'Tabel waarin nageschakelde technieken bij stallen worden gecodeerd zoals E6.4.2H droogtunnel met geperforeerde metalen platen (0,002)';
COMMENT ON COLUMN public.tbmilnagetech.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilnagetech.dvcode
IS 'Codering van nageschakelde techniek.';
COMMENT ON COLUMN public.tbmilnagetech.dvomschrijving
IS 'Omschrijving van Nageschakelde techniek.';
COMMENT ON COLUMN public.tbmilnagetech.dvrichtlijn
IS 'Richtlijnduiding.';
COMMENT ON COLUMN public.tbmilnagetech.dfnh3invloed
IS 'Beinvloeding op Ammoniakuitstoot in Kg per jaar per dier.';
COMMENT ON COLUMN public.tbmilnagetech.ddvervaldatum
IS 'Vervaldatum van techniek.';
COMMENT ON COLUMN public.tbmilnagetech.dfouinvloed
IS 'Beinvloeding op geur in aantallen odeurunits per seconde per jaar per dier.';
COMMENT ON COLUMN public.tbmilnagetech.dffijnstofinvloed
IS 'Beinvloeding op fijnstof in gram per jaar per dier.';
COMMENT ON COLUMN public.tbmilnagetech.dnkeymilcodebwl
IS 'Foreign key naar tbmilcodebwl.dnkey (bodem, water landelijk gebied).';
CREATE INDEX idx_milnagetech_code ON public.tbmilnagetech
USING btree (dvcode COLLATE pg_catalog."default");
CREATE INDEX idx_milnagetech_vervaldatum ON public.tbmilnagetech
USING btree (ddvervaldatum);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|