Datadictionary OpenWave 3.1.11

View: vwbouwdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwbouwdochteraantallen

Fields

Rules

Definition

CREATE VIEW public.vwbouwdochteraantallen (
   tabel,
   dnkeybouwvergunningen,
   aantal)
AS
       (        (        (        (        (        (
SELECT 'tbtermbewstappen'::character varying(18) AS tabel,
                                                           a.dnkeybouwvergunningen,
                                                           count(DISTINCT
                                                               a.dnkeyorgprocedure +
                                                               CASE
                                                                   WHEN
                                                                       a.dninvoegnr IS NULL THEN 0
                                                                   ELSE a.dninvoegnr
                                                               END) AS aantal
FROM tbtermijnbewstappen a
                                                     JOIN tbbouwvergunningen b
                                                         ON a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(18) AS tabel,
                                                           a.dnkeybouwvergunningen,
                                                           count(*) AS aantal
FROM tbinbehandelingbij a
                                                     JOIN tbbouwvergunningen b
                                                         ON a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tbadviezen'::character varying(18) AS tabel,
                                                   a.dnkeybouwvergunningen,
                                                   count(*) AS aantal
FROM tbadviezen a
                                             JOIN tbbouwvergunningen b ON
                                                 a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tbcorrespondentie'::character varying(18) AS tabel,
                                           a.dnkeybouwvergunningen,
                                           count(*) AS aantal
FROM tbcorrespondentie a
                                     JOIN tbbouwvergunningen b ON
                                         a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tbcorrespbinnen'::character varying(18) AS tabel,
                                   a.dnkeybouwvergunningen, count(*) AS aantal
FROM tbcorrespbinnen a
                             JOIN tbbouwvergunningen b ON
                                 a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tbbouwcontactennn'::character varying(18) AS tabel,
                           a.dnkeybouwvergunningen, count(*) AS aantal
FROM tbbouwcontactennn a
                     JOIN tbbouwvergunningen b ON a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tbinspecties'::character varying(18) AS tabel,
                   a.dnkeybouwvergunningen, count(*) AS aantal
FROM tbinspecties a
             JOIN tbbouwvergunningen b ON a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen)
UNION
SELECT 'tblegesregels'::character varying(18) AS tabel,
           a.dnkeybouwvergunningen, count(*) AS aantal
FROM tblegesregels a
     JOIN tbbouwvergunningen b ON a.dnkeybouwvergunningen = b.dnkey
GROUP BY a.dnkeybouwvergunningen;

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