Datadictionary OpenWave 3.1.11 |
|
View: vwhorecacontverg
Datadictionary OpenWave 3.1.11 |
|
View: vwhorecacontverg
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhorecacontverg
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dnkeygroepvergunning |
integer |
|
dnkeyperceeladressen |
integer |
|
dvcodedossierverblijf |
char(1) |
|
dvvergnummer |
varchar(20) |
|
dvcodeaardbesluit |
char(1) |
|
dnkeysoortverg |
integer |
|
dddatumbesluit |
timestamp |
|
ddvervaldatum |
timestamp |
|
ddaanvraagdatum |
timestamp |
|
dnkeygebied |
integer |
|
dnkeysoortonderneming |
integer |
|
dvzaaknaam |
varchar(200) |
|
dvzaaktel |
varchar(30) |
|
dvzaakfax |
varchar(30) |
|
dvzaakemail |
varchar(30) |
|
dvlokaliteiten |
varchar(2000) |
|
dlsocialehygiene |
char(1) |
|
dlwetmilieubeh |
char(1) |
|
dvzaakkvk |
varchar(20) |
|
dvhandelsnaam |
varchar(200) |
|
dvwebsite |
varchar(200) |
|
dvzaakbedrshor |
varchar(20) |
|
dvonthhorinrnr |
varchar(18) |
|
ddonthhorinrdatvan |
timestamp |
|
dvonthhorinroms |
varchar(2000) |
|
dvonthhorvrknr |
varchar(18) |
|
ddonthhorvrkdatvan |
timestamp |
|
ddonthhorvrkdattm |
timestamp |
|
dvonthhorvrkoms |
varchar(2000) |
|
dvonthhortsnr |
varchar(18) |
|
ddonthhortsdatvan |
timestamp |
|
dvonthhortsoms |
varchar(2000) |
|
dvvergbrandweer |
varchar(15) |
|
ddvergbrandweer |
timestamp |
|
dlpolitiekgev |
char(1) |
|
dvredenpolgevweb |
varchar(200) |
|
dvmemo |
varchar(4000) |
|
dnkeyrechtsvorm |
integer |
|
ddfataledatum |
timestamp |
|
dvdmszaakcode |
varchar(40) |
|
ddingetrokken |
timestamp |
|
dnobjstraatcode |
integer |
|
ddpercvervaldatum |
timestamp |
|
dnperceelkey |
integer |
|
dvperceelnummer |
varchar(5) |
|
dvextraperceelnummers |
varchar(200) |
|
dvobjhuisnummer |
varchar(5) |
|
dvobjhuisletter |
char(1) |
|
dvobjhuisnrtoevoeg |
varchar(4) |
|
dvobjaanduidhuisnr |
varchar(2) |
|
dvobjgmntecode |
varchar(5) |
|
dvsectie |
varchar(2) |
|
dvobjhuisnrinfo |
varchar(40) |
|
dvobjhuisnr |
varchar(15) |
|
dvobjstraat |
varchar(80) |
|
dvobjpostcode |
varchar(6) |
|
dvobjplaats |
varchar(80) |
|
dnobjcbs_buurt |
integer |
|
dvoneven |
char(1) |
|
dnkeycontactadressen |
integer |
|
dnkeyhorecavergunningen |
integer |
|
dvcodeadressoort |
char(3) |
|
dvsoorthorvergoms |
varchar(40) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
dnkeygroepvergunning,
dnkeyperceeladressen,
dvcodedossierverblijf,
dvvergnummer,
dvcodeaardbesluit,
dnkeysoortverg,
dddatumbesluit,
ddvervaldatum,
ddaanvraagdatum,
dnkeygebied,
dnkeysoortonderneming,
dvzaaknaam,
dvzaaktel,
dvzaakfax,
dvzaakemail,
dvlokaliteiten,
dlsocialehygiene,
dlwetmilieubeh,
dvzaakkvk,
dvhandelsnaam,
dvwebsite,
dvzaakbedrshor,
dvonthhorinrnr,
ddonthhorinrdatvan,
dvonthhorinroms,
dvonthhorvrknr,
ddonthhorvrkdatvan,
ddonthhorvrkdattm,
dvonthhorvrkoms,
dvonthhortsnr,
ddonthhortsdatvan,
dvonthhortsoms,
dvvergbrandweer,
ddvergbrandweer,
dlpolitiekgev,
dvredenpolgevweb,
dvmemo,
dnkeyrechtsvorm,
ddfataledatum,
dvdmszaakcode,
ddingetrokken,
dnobjstraatcode,
ddpercvervaldatum,
dnperceelkey,
dvperceelnummer,
dvextraperceelnummers,
dvobjhuisnummer,
dvobjhuisletter,
dvobjhuisnrtoevoeg,
dvobjaanduidhuisnr,
dvobjgmntecode,
dvsectie,
dvobjhuisnrinfo,
dvobjhuisnr,
dvobjstraat,
dvobjpostcode,
dvobjplaats,
dnobjcbs_buurt,
dvoneven,
dnkeycontactadressen,
dnkeyhorecavergunningen,
dvcodeadressoort,
dvsoorthorvergoms)
AS
SELECT tbhorecavergunningen.dnkey, tbhorecavergunningen.dnkeygroepvergunning,
tbhorecavergunningen.dnkeyperceeladressen,
tbhorecavergunningen.dvcodedossierverblijf,
tbhorecavergunningen.dvvergnummer, tbhorecavergunningen.dvcodeaardbesluit,
tbhorecavergunningen.dnkeysoortverg, tbhorecavergunningen.dddatumbesluit,
tbhorecavergunningen.ddvervaldatum, tbhorecavergunningen.ddaanvraagdatum,
tbhorecavergunningen.dnkeygebied,
tbhorecavergunningen.dnkeysoortonderneming, tbhorecavergunningen.dvzaaknaam,
tbhorecavergunningen.dvzaaktel, tbhorecavergunningen.dvzaakfax,
tbhorecavergunningen.dvzaakemail, tbhorecavergunningen.dvlokaliteiten,
tbhorecavergunningen.dlsocialehygiene, tbhorecavergunningen.dlwetmilieubeh,
tbhorecavergunningen.dvzaakkvk, tbhorecavergunningen.dvhandelsnaam,
tbhorecavergunningen.dvwebsite, tbhorecavergunningen.dvzaakbedrshor,
tbhorecavergunningen.dvonthhorinrnr,
tbhorecavergunningen.ddonthhorinrdatvan,
tbhorecavergunningen.dvonthhorinroms, tbhorecavergunningen.dvonthhorvrknr,
tbhorecavergunningen.ddonthhorvrkdatvan,
tbhorecavergunningen.ddonthhorvrkdattm,
tbhorecavergunningen.dvonthhorvrkoms, tbhorecavergunningen.dvonthhortsnr,
tbhorecavergunningen.ddonthhortsdatvan, tbhorecavergunningen.dvonthhortsoms,
tbhorecavergunningen.dvvergbrandweer, tbhorecavergunningen.ddvergbrandweer,
tbhorecavergunningen.dlpolitiekgev, tbhorecavergunningen.dvredenpolgevweb,
tbhorecavergunningen.dvmemo, tbhorecavergunningen.dnkeyrechtsvorm,
tbhorecavergunningen.ddfataledatum, tbhorecavergunningen.dvdmszaakcode,
tbhorecavergunningen.ddingetrokken,
tbperceeladressen.dnstraatcode AS dnobjstraatcode,
tbperceeladressen.ddvervaldatum AS ddpercvervaldatum,
tbperceeladressen.dnkey AS dnperceelkey, tbperceeladressen.dvperceelnummer,
tbperceeladressen.dvextraperceelnummers,
tbperceeladressen.dvhuisnummer AS dvobjhuisnummer,
tbperceeladressen.dvhuisletter AS dvobjhuisletter,
tbperceeladressen.dvhuisnummertoevoeging AS dvobjhuisnrtoevoeg,
tbperceeladressen.dvaanduidingbijhuisnummer AS dvobjaanduidhuisnr,
tbperceeladressen.dvgmntecode AS dvobjgmntecode, tbperceeladressen.dvsectie,
tbperceeladressen.dvhuisnrinfo AS dvobjhuisnrinfo,
(((((
CASE
WHEN tbperceeladressen.dvaanduidingbijhuisnummer IS NULL THEN ''::text
ELSE tbperceeladressen.dvaanduidingbijhuisnummer::text || ' '::text
END || tbperceeladressen.dvhuisnummer::text) || ' '::text) ||
CASE
WHEN tbperceeladressen.dvhuisletter IS NULL THEN ''::bpchar
ELSE tbperceeladressen.dvhuisletter
END::text) ||
CASE
WHEN rtrim(tbperceeladressen.dvhuisnummertoevoeging::text) IS NULL
THEN ''::text
ELSE replace('-'::text ||
tbperceeladressen.dvhuisnummertoevoeging::text, '--'::text, '-'::text)
END))::character varying(15) AS dvobjhuisnr,
tbopenbareruimte.dvopruimtenaam AS dvobjstraat,
tbperceeladressen.dvpostcode AS dvobjpostcode,
tbwoonplaats.dvwoonplaatsnaam AS dvobjplaats,
tbperceeladressen.dncbs_buurt AS dnobjcbs_buurt, tbperceeladressen.dvoneven,
tbhorecacontactennn.dnkeycontactadressen,
tbhorecacontactennn.dnkeyhorecavergunningen,
tbhorecacontactennn.dvcodeadressoort,
tbsoorthorverg.dvomschrijving AS dvsoorthorvergoms
FROM tbhorecavergunningen
JOIN tbperceeladressen ON tbhorecavergunningen.dnkeyperceeladressen =
tbperceeladressen.dnkey
JOIN tbopenbareruimte ON tbperceeladressen.dnkeyopenbruimte = tbopenbareruimte.dnkey
JOIN tbwoonplaats ON tbopenbareruimte.dnkeywoonplaats = tbwoonplaats.dnkey
JOIN tbhorecacontactennn ON tbhorecavergunningen.dnkey =
tbhorecacontactennn.dnkeyhorecavergunningen
JOIN tbsoorthorverg ON tbhorecavergunningen.dnkeysoortverg = tbsoorthorverg.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|