Datadictionary OpenWave 3.1.11

View: vwomgdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwomgdochteraantallen

Fields

Rules

Definition

CREATE VIEW public.vwomgdochteraantallen (
   tabel,
   dnkeyomgvergunningen,
   aantal)
AS
       (        (        (        (        (        (        (        (
           (        (        (
SELECT 'tbtermbewstappen'::character varying(20) AS tabel,
                                                                                                       a.dnkeyomgvergunningen,
                                                                                                       count(DISTINCT a.dnkeyorgprocedure +
                                                                                                           CASE
                                                                                                               WHEN a.dninvoegnr IS NULL THEN 0
                                                                                                               ELSE a.dninvoegnr
                                                                                                           END) AS aantal
FROM tbtermijnbewstappen a
                                                                                                 JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(20) AS tabel,
                                                                                                       a.dnkeyomgvergunningen,
                                                                                                       count(*) AS aantal
FROM tbinbehandelingbij a
                                                                                                 JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbadviezen'::character varying(20) AS tabel,
                                                                                               a.dnkeyomgvergunningen,
                                                                                               count(*) AS aantal
FROM tbadviezen a
                                                                                         JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbcorrespondentie'::character varying(20) AS tabel,
                                                                                       a.dnkeyomgvergunningen,
                                                                                       count(*) AS aantal
FROM tbcorrespondentie a
                                                                             JOIN
                                                                                 tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbcorrespbinnen'::character varying(20) AS tabel,
                                                                           a.dnkeyomgvergunningen,
                                                                           count(*)
                                                                               AS aantal
FROM tbcorrespbinnen a
                                                                     JOIN
                                                                         tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbomgvergcontactennn'::character varying(20) AS tabel,
                                                                   a.dnkeyomgvergunningen,
                                                                   count(*) AS aantal
FROM tbomgvergcontactennn a
                                                             JOIN
                                                                 tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tblegesregels'::character varying(20) AS tabel,
                                                           a.dnkeyomgvergunningen,
                                                           count(*) AS aantal
FROM tblegesregels a
                                                     JOIN tbomgvergunning b ON
                                                         a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbtoestemmingen'::character varying(20) AS tabel,
                                                   a.dnkeyomgvergunningen,
                                                   count(*) AS aantal
FROM tbtoestemmingen a
                                             JOIN tbomgvergunning b ON
                                                 a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbinspecties'::character varying(20) AS tabel,
                                           a.dnkeyomgvergunningen,
                                           count(*) AS aantal
FROM tbinspecties a
                                     JOIN tbomgvergunning b ON
                                         a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbomgvergbestemtoets'::character varying(20) AS tabel,
                                   a.dnkeyomgvergunningen, count(*) AS aantal
FROM tbomgvergbestemtoets a
                             JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbomgoloberichten'::character varying(20) AS tabel,
                           a.dnkeyomgvergunningen, count(*) AS aantal
FROM tbomgoloberichten a
                     JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbomgbwinstallaties'::character varying(20) AS tabel,
                   a.dnkeyomgvergunningen, count(*) AS aantal
FROM tbomgbwinstallaties a
             JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen)
UNION
SELECT 'tbomgpreparaties'::character varying(20) AS tabel,
           a.dnkeyomgvergunningen, count(*) AS aantal
FROM tbomgpreparaties a
     JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen;

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