Datadictionary OpenWave 3.1.11

View: vwinrichtingpreparaties

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinrichtingpreparaties

Fields

Rules

Definition

CREATE VIEW public.vwinrichtingpreparaties (
   dvmodule,
   dvstatus,
   dnkeyvergunning,
   dvzaakcode,
   dddatum,
   dvomschrijving,
   dnkeymilinrichtingen,
   dvpreparatie)
AS
       (        (        (        (
SELECT 'W'::character(1) AS dvmodule,
                                           'V'::character(1) AS dvstatus,
                                           c.dnkey AS dnkeyvergunning,
                                           c.dvzaakcode,
                                           c.ddbesluitdatum AS dddatum,
                                           c.dvaanvraagnaam AS dvomschrijving,
                                           c.dnkeymilinrichtingen,
                                           a.dvpreparatie
FROM tbomgpreparaties b
                                     JOIN tbpreparaties a ON
                                         b.dnkeypreparaties = a.dnkey
                                JOIN tbomgvergunning c ON
                                    b.dnkeyomgvergunningen = c.dnkey
                           JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
                      JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar
UNION
SELECT 'W'::character(1) AS dvmodule,
                                           'L'::character(1) AS dvstatus,
                                           c.dnkey AS dnkeyvergunning,
                                           c.dvzaakcode,
                                           c.ddaanvraag AS dddatum,
                                           c.dvaanvraagnaam AS dvomschrijving,
                                           c.dnkeymilinrichtingen,
                                           a.dvpreparatie
FROM tbomgpreparaties b
                                     JOIN tbpreparaties a ON
                                         b.dnkeypreparaties = a.dnkey
                                JOIN tbomgvergunning c ON
                                    b.dnkeyomgvergunningen = c.dnkey
                           JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL)
UNION
SELECT 'E'::character(1) AS dvmodule,
                                   'V'::character(1) AS dvstatus,
                                   c.dnkey AS dnkeyvergunning,
                                   c.dvvergnummer AS dvzaakcode,
                                   c.ddbesluitdatum AS dddatum,
                                   f.dvomschrijving, c.dnkeymilinrichtingen,
                                   a.dvpreparatie
FROM tbomgpreparaties b
                             JOIN tbpreparaties a ON b.dnkeypreparaties = a.dnkey
                        JOIN tbmilvergunningen c ON b.dnkeymilvergunningen = c.dnkey
                   JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
              JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
         JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar)
UNION
SELECT 'E'::character(1) AS dvmodule,
                           'L'::character(1) AS dvstatus,
                           c.dnkey AS dnkeyvergunning,
                           c.dvvergnummer AS dvzaakcode,
                           c.ddontvangstdatum AS dddatum, f.dvomschrijving,
                           c.dnkeymilinrichtingen, a.dvpreparatie
FROM tbomgpreparaties b
                     JOIN tbpreparaties a ON b.dnkeypreparaties = a.dnkey
                JOIN tbmilvergunningen c ON b.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, c.ddbesluitdatum AS dddatum,
                   f.dvomschrijving, c.dnkeymilinrichtingen, a.dvpreparatie
FROM tbomgpreparaties b
             JOIN tbpreparaties a ON b.dnkeypreparaties = a.dnkey
        JOIN tbbouwvergunningen c ON b.dnkeybouwvergunningen = c.dnkey
   JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
  JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
  JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar)
UNION
SELECT 'B'::character(1) AS dvmodule, 'L'::character(1) AS dvstatus,
           c.dnkey AS dnkeyvergunning, c.dvbouwnr AS dvzaakcode,
           c.ddontvangstdatum AS dddatum, f.dvomschrijving,
           c.dnkeymilinrichtingen, a.dvpreparatie
FROM tbomgpreparaties b
     JOIN tbpreparaties a ON b.dnkeypreparaties = a.dnkey
  JOIN tbbouwvergunningen c ON b.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