Datadictionary OpenWave 3.1.11 |
|
View: vwmilcodestaldier
Datadictionary OpenWave 3.1.11 |
|
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 |
|
|
|
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, tbmilcodestaldier.dvstalrichtlijn,
tbmilcodestaldier.dvdierrichtlijn, tbmilcodestaldier.dffijnstof,
tbmilcodestal.ddvervaldatum AS ddstalvervaldatum,
tbmilcodedier.ddvervaldatum AS dddiervervaldatum
FROM tbmilcodestaldier
JOIN tbmilcodedier ON tbmilcodestaldier.dvcodedier::text =
tbmilcodedier.dvcode::text AND tbmilcodestaldier.dvdierrichtlijn::text = tbmilcodedier.dvrichtlijn::text
JOIN tbmilcodestal ON tbmilcodestaldier.dvcodestal::text =
tbmilcodestal.dvcode::text AND tbmilcodestaldier.dvstalrichtlijn::text = tbmilcodestal.dvrichtlijn::text;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|