Datadictionary OpenWave 3.1.11 |
|
View: vwlokcritlstitems
Datadictionary OpenWave 3.1.11 |
|
View: vwlokcritlstitems
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwlokcritlstitems
Fields
Name | Data type | Description |
|---|---|---|
dnkeylokcrititems |
integer |
|
dvcriterium |
varchar(40) |
|
dnpunten |
integer |
|
dnkeylokcritkoppel |
integer |
|
dlvoldoet |
char(1) |
|
dnkeylokcritlijsten |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeylokcrititems,
dvcriterium,
dnpunten,
dnkeylokcritkoppel,
dlvoldoet,
dnkeylokcritlijsten)
AS
SELECT tblokcrititems.dnkey AS dnkeylokcrititems, tblokcrititems.dvcriterium,
tblokcrititems.dnpunten, tblokcritkoppel.dnkey AS dnkeylokcritkoppel,
tblokcritkoppel.dlvoldoet, tblokcritlijsten.dnkey AS dnkeylokcritlijsten
FROM tblokcritkoppel
JOIN tblokcrititems ON tblokcritkoppel.dnkeylokcrititems = tblokcrititems.dnkey
JOIN tblokcritlijsten ON tblokcritkoppel.dnkeylokcritlijsten =
tblokcritlijsten.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|