Datadictionary OpenWave 3.1.11

View: vwinrneveninrichtingen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinrneveninrichtingen

Fields

Rules

Definition

CREATE VIEW public.vwinrneveninrichtingen (
   dnkeyneveninrichting,
   dnkeyhoofdinrichting,
   dvinrichtingnr,
   dvinrichtingnaam,
   dvobjadres,
   dvwoonplaatsnaam)
AS
SELECT a.dnkey AS dnkeyneveninrichting,
   a.dnkeyparentinr AS dnkeyhoofdinrichting, a.dvinrichtingnr,
   a.dvinrichtingnaam,
   (((((((c.dvopruimtenaam::text ||
       CASE
           WHEN b.dvaanduidingbijhuisnummer IS NULL THEN ' '::text
           ELSE (' '::text || b.dvaanduidingbijhuisnummer::text) || ' '::text
       END) || b.dvhuisnummer::text) || ' '::text) ||
       CASE
           WHEN b.dvhuisletter IS NULL THEN ''::bpchar
           ELSE b.dvhuisletter
       END::text) ||
       CASE
           WHEN rtrim(b.dvhuisnummertoevoeging::text) IS NULL THEN ''::text
           ELSE replace('-'::text || b.dvhuisnummertoevoeging::text, '
               --'::text, '-'::text)
       END) ||
       CASE
           WHEN b.dvhuisnrinfo IS NULL THEN ''::text
           ELSE rtrim(' '::text || b.dvhuisnrinfo::text)
       END))::character varying(136) AS dvobjadres,
   d.dvwoonplaatsnaam
FROM tbmilinrichtingen a
  JOIN tbperceeladressen b ON a.dnkeyperceeladressen = b.dnkey
  JOIN tbopenbareruimte c ON b.dnkeyopenbruimte = c.dnkey
  JOIN tbwoonplaats d ON c.dnkeywoonplaats = d.dnkey
WHERE a.dnkeyparentinr IS NOT NULL;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50