Datadictionary OpenWave 3.1.25 |
|
View: vwstraatnamen
Datadictionary OpenWave 3.1.25 |
|
View: vwstraatnamen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwstraatnamen
Fields
Name | Data type | Description |
|---|---|---|
dvwoonplaats |
varchar(80) |
|
ddwplvervaldatum |
timestamp |
|
dvnaam_nen5825 |
varchar(80) |
|
dnkeywoonplaats |
integer |
|
dnkeyopruimte |
integer |
|
ddoprvervaldatum |
timestamp |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwstraatnamen
Definition
dvwoonplaats,
ddwplvervaldatum,
dvnaam_nen5825,
dnkeywoonplaats,
dnkeyopruimte,
ddoprvervaldatum)
AS
SELECT b.dvwoonplaatsnaam AS dvwoonplaats,
b.ddvervaldatum AS ddwplvervaldatum,
a.dvopruimtenaam AS dvnaam_nen5825,
a.dnkeywoonplaats,
a.dnkey AS dnkeyopruimte,
a.ddvervaldatum AS ddoprvervaldatum
FROM tbopenbareruimte a
JOIN tbwoonplaats b ON a.dnkeywoonplaats = b.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|