Datadictionary OpenWave 3.1.33 |
|
View: vwomgcontverg_bt
Datadictionary OpenWave 3.1.33 |
|
View: vwomgcontverg_bt
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwomgcontverg_bt
Columns
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dvvergnummer |
varchar(40) |
|
dvsoortomgverg |
varchar(150) |
|
ddaanvraagdatum |
timestamp |
|
ddbesluitdatum |
timestamp |
|
dvarchiefnr |
varchar(40) |
|
dvobjstraat |
varchar(80) |
|
dvobjpostcode |
varchar(6) |
|
dvobjhuisnummer |
varchar(5) |
|
dvobjhuisletter |
char(1) |
|
dvobjhuisnrtoevoeg |
varchar(4) |
|
dvobjplaats |
varchar(80) |
|
dnkeycontactadressen |
integer |
|
dvaanvraagnaam |
varchar(200) |
|
dnicoon |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwomgcontverg_bt
Definition
dnkey,
dvvergnummer,
dvsoortomgverg,
ddaanvraagdatum,
ddbesluitdatum,
dvarchiefnr,
dvobjstraat,
dvobjpostcode,
dvobjhuisnummer,
dvobjhuisletter,
dvobjhuisnrtoevoeg,
dvobjplaats,
dnkeycontactadressen,
dvaanvraagnaam,
dnicoon)
AS
SELECT tbomgvergunning.dnkey,
tbomgvergunning.dvzaakcode AS dvvergnummer,
tbsoortomgverg.dvomschrijving AS dvsoortomgverg,
tbomgvergunning.ddaanvraag AS ddaanvraagdatum,
tbomgvergunning.ddbesluitdatum,
tbomgvergunning.dvdmszaakcode AS dvarchiefnr,
tbopenbareruimte.dvopruimtenaam AS dvobjstraat,
tbperceeladressen.dvpostcode AS dvobjpostcode,
tbperceeladressen.dvhuisnummer AS dvobjhuisnummer,
tbperceeladressen.dvhuisletter AS dvobjhuisletter,
tbperceeladressen.dvhuisnummertoevoeging AS dvobjhuisnrtoevoeg,
tbwoonplaats.dvwoonplaatsnaam AS dvobjplaats,
tbomgvergcontactennn.dnkeycontactadressen,
tbomgvergunning.dvaanvraagnaam,
tbsoortomgverg.dnicoon
FROM tbomgvergunning
JOIN tbperceeladressen ON tbomgvergunning.dnkeyperceeladressen =
tbperceeladressen.dnkey
JOIN tbopenbareruimte ON tbperceeladressen.dnkeyopenbruimte =
tbopenbareruimte.dnkey
JOIN tbwoonplaats ON tbopenbareruimte.dnkeywoonplaats = tbwoonplaats.dnkey
JOIN tbomgvergcontactennn ON tbomgvergunning.dnkey =
tbomgvergcontactennn.dnkeyomgvergunningen
JOIN tbsoortomgverg ON tbomgvergunning.dnkeysoortomgverg = tbsoortomgverg.dnkey
WHERE tbomgvergunning.dlbeperktetoegang = 'T'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|