Datadictionary OpenWave 3.1.11 |
|
View: vwbestcontverg
Datadictionary OpenWave 3.1.11 |
|
View: vwbestcontverg
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwbestcontverg
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dnkeybestemmingsplannen |
integer |
|
dnkeysrtbestplan |
integer |
|
dvnummer |
varchar(36) |
|
dvnaam |
varchar(256) |
|
dvkern |
varchar(18) |
|
dvomschrijving |
varchar(256) |
|
dddatumvaststelling |
timestamp |
|
dddatumgoedkeuring |
timestamp |
|
dvsoortplan |
char(1) |
|
categorie |
varchar(50) |
|
dnkeycontactadressen |
integer |
|
dnkeybestplan |
integer |
|
dvcodeadressoort |
char(3) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
dnkeybestemmingsplannen,
dnkeysrtbestplan,
dvnummer,
dvnaam,
dvkern,
dvomschrijving,
dddatumvaststelling,
dddatumgoedkeuring,
dvsoortplan,
categorie,
dnkeycontactadressen,
dnkeybestplan,
dvcodeadressoort)
AS
SELECT tbbestemmingsplannen.dnkey,
tbbestemmingsplannen.dnkeybestemmingsplannen,
tbbestemmingsplannen.dnkeysrtbestplan, tbbestemmingsplannen.dvnummer,
tbbestemmingsplannen.dvnaam, tbbestemmingsplannen.dvkern,
tbbestemmingsplannen.dvomschrijving,
tbbestemmingsplannen.dddatumvaststelling,
tbbestemmingsplannen.dddatumgoedkeuring, tbsrtbestplan.dvsoortplan,
tbbestplancategorie.dvomschrijving AS categorie,
tbbestemcontactennn.dnkeycontactadressen,
tbbestemcontactennn.dnkeybestemmingsplannen AS dnkeybestplan,
tbbestemcontactennn.dvcodeadressoort
FROM tbbestemmingsplannen
LEFT JOIN tbsrtbestplan ON tbbestemmingsplannen.dnkeysrtbestplan =
tbsrtbestplan.dnkey
JOIN tbbestemcontactennn ON tbbestemmingsplannen.dnkey =
tbbestemcontactennn.dnkeybestemmingsplannen
LEFT JOIN tbbestplancategorie ON tbsrtbestplan.dnkeybestplancategorie =
tbbestplancategorie.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|