Datadictionary OpenWave 3.1.11

View: vwovdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwovdochteraantallen

Fields

Rules

Definition

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

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