Datadictionary OpenWave 3.1.11

View: vwmilvergdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwmilvergdochteraantallen

Fields

Rules

Definition

CREATE VIEW public.vwmilvergdochteraantallen (
   tabel,
   dnkeymilvergunningen,
   aantal)
AS
       (        (        (        (        (        (        (        (
           (        (
SELECT 'tbtermbewstappen'::character varying(19) AS tabel,
                                                                                               a.dnkeymilvergunningen,
                                                                                               count(DISTINCT a.dnkeyorgprocedure +
                                                                                                   CASE
                                                                                                       WHEN a.dninvoegnr IS NULL THEN 0
                                                                                                       ELSE a.dninvoegnr
                                                                                                   END) AS aantal
FROM tbtermijnbewstappen a
                                                                                         JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(19) AS tabel,
                                                                                               a.dnkeymilvergunningen,
                                                                                               count(*) AS aantal
FROM tbinbehandelingbij a
                                                                                         JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbadviezen'::character varying(19) AS tabel,
                                                                                       a.dnkeymilvergunningen,
                                                                                       count(*) AS aantal
FROM tbadviezen a
                                                                             JOIN
                                                                                 tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbcorrespondentie'::character varying(19) AS tabel,
                                                                           a.dnkeymilvergunningen,
                                                                           count(*)
                                                                               AS aantal
FROM tbcorrespondentie a
                                                                     JOIN
                                                                         tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbcorrespbinnen'::character varying(19) AS tabel,
                                                                   a.dnkeymilvergunningen,
                                                                   count(*) AS aantal
FROM tbcorrespbinnen a
                                                             JOIN
                                                                 tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbmilvergcontactennn'::character varying(19) AS tabel,
                                                           a.dnkeymilvergunningen,
                                                           count(*) AS aantal
FROM tbmilvergcontactennn a
                                                     JOIN tbmilvergunningen b
                                                         ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbmilvergwetgrond'::character varying(19) AS tabel,
                                                   a.dnkeymilvergunningen,
                                                   count(*) AS aantal
FROM tbmilvergwetgrond a
                                             JOIN tbmilvergunningen b ON
                                                 a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbomgoloberichten'::character varying(19) AS tabel,
                                           a.dnkeymilvergunningen,
                                           count(*) AS aantal
FROM tbomgoloberichten a
                                     JOIN tbmilvergunningen b ON
                                         a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbgebouwen'::character varying(19) AS tabel,
                                   a.dnkeymilvergunningen, count(*) AS aantal
FROM tbgebouwen a
                             JOIN tbmilvergunningen b ON
                                 a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbomgbwinstallaties'::character varying(19) AS tabel,
                           a.dnkeymilvergunningen, count(*) AS aantal
FROM tbomgbwinstallaties a
                     JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbbwaantekeningen'::character varying(19) AS tabel,
                   a.dnkeymilvergunningen, count(*) AS aantal
FROM tbbwaantekeningen a
             JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen)
UNION
SELECT 'tbomgpreparaties'::character varying(19) AS tabel,
           a.dnkeymilvergunningen, count(*) AS aantal
FROM tbomgpreparaties a
     JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen;

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