Datadictionary OpenWave 3.1.11

View: vwinrichtingaantek

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinrichtingaantek

Fields

Rules

Definition

CREATE VIEW public.vwinrichtingaantek (
   dvmodule,
   dvstatus,
   dnkeyvergunning,
   dvzaakcode,
   dddatum,
   dvomschrijving,
   dnkeymilinrichtingen,
   dvmemo,
   dvaardbesluit)
AS
       (        (
SELECT 'E'::character(1) AS dvmodule,
                           'V'::character(1) AS dvstatus,
                           c.dnkey AS dnkeyvergunning,
                           c.dvvergnummer AS dvzaakcode, a.dddatum,
                           f.dvomschrijving, c.dnkeymilinrichtingen, a.dvmemo,
                           e.dvomschrijving AS dvaardbesluit
FROM tbbwaantekeningen a
                     JOIN tbmilvergunningen c ON a.dnkeymilvergunningen = c.dnkey
                JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
           JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
      LEFT JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL OR c.ddingetrokken IS NOT NULL
UNION
SELECT 'E'::character(1) AS dvmodule,
                           'L'::character(1) AS dvstatus,
                           c.dnkey AS dnkeyvergunning,
                           c.dvvergnummer AS dvzaakcode, a.dddatum,
                           f.dvomschrijving, c.dnkeymilinrichtingen, a.dvmemo,
                           NULL::character varying(40) AS dvaardbesluit
FROM tbbwaantekeningen a
                     JOIN tbmilvergunningen c ON a.dnkeymilvergunningen = c.dnkey
                JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
           JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL)
UNION
SELECT 'B'::character(1) AS dvmodule,
                   'V'::character(1) AS dvstatus, c.dnkey AS dnkeyvergunning,
                   c.dvbouwnr AS dvzaakcode, a.dddatum, f.dvomschrijving,
                   c.dnkeymilinrichtingen, a.dvmemo,
                   e.dvomschrijving AS dvaardbesluit
FROM tbbwaantekeningen a
             JOIN tbbouwvergunningen c ON a.dnkeybouwvergunningen = c.dnkey
        JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
   JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
  LEFT JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL OR c.ddingetrokken IS NOT NULL)
UNION
SELECT 'B'::character(1) AS dvmodule, 'L'::character(1) AS dvstatus,
           c.dnkey AS dnkeyvergunning, c.dvbouwnr AS dvzaakcode, a.dddatum,
           f.dvomschrijving, c.dnkeymilinrichtingen, a.dvmemo,
           NULL::character varying(40) AS dvaardbesluit
FROM tbbwaantekeningen a
     JOIN tbbouwvergunningen c ON a.dnkeybouwvergunningen = c.dnkey
  JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
  JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL
ORDER BY 2, 5 DESC;

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