Datadictionary OpenWave 3.1.25 |
|
View: vwmilcodestaldier
Datadictionary OpenWave 3.1.25 |
|
View: vwmilcodestaldier
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmilcodestaldier
Fields
Name | Data type | Description |
|---|---|---|
dnkeycodestaldier |
integer |
|
dvdiercode |
varchar(10) |
|
dvdieroms |
varchar(60) |
|
dvstalcode |
varchar(15) |
|
dvstaloms |
varchar(2000) |
|
dvrichtlijn |
varchar(10) |
|
dfdierenpermve |
double precision |
|
dfnh3factor |
double precision |
|
dfodeurfactor |
double precision |
|
ddvervaldatum |
timestamp |
|
dvstalrichtlijn |
varchar(10) |
|
dvdierrichtlijn |
varchar(10) |
|
dffijnstof |
double precision |
|
ddstalvervaldatum |
timestamp |
|
dddiervervaldatum |
timestamp |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwmilcodestaldier
Definition
dnkeycodestaldier,
dvdiercode,
dvdieroms,
dvstalcode,
dvstaloms,
dvrichtlijn,
dfdierenpermve,
dfnh3factor,
dfodeurfactor,
ddvervaldatum,
dvstalrichtlijn,
dvdierrichtlijn,
dffijnstof,
ddstalvervaldatum,
dddiervervaldatum)
AS
SELECT tbmilcodestaldier.dnkey AS dnkeycodestaldier,
tbmilcodedier.dvcode AS dvdiercode,
tbmilcodedier.dvdieroms,
tbmilcodestal.dvcode AS dvstalcode,
tbmilcodestal.dvstaloms,
tbmilcodestaldier.dvrichtlijn,
tbmilcodestaldier.dfdierenpermve,
tbmilcodestaldier.dfnh3factor,
tbmilcodestaldier.dfodeurfactor,
tbmilcodestaldier.ddvervaldatum,
tbmilcodestal.dvrichtlijn AS dvstalrichtlijn,
tbmilcodedier.dvrichtlijn AS dvdierrichtlijn,
tbmilcodestaldier.dffijnstof,
tbmilcodestal.ddvervaldatum AS ddstalvervaldatum,
tbmilcodedier.ddvervaldatum AS dddiervervaldatum
FROM tbmilcodestaldier
JOIN tbmilcodedier ON tbmilcodestaldier.dnkeymilcodedier = tbmilcodedier.dnkey
JOIN tbmilcodestal ON tbmilcodestaldier.dnkeymilcodestal = tbmilcodestal.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|