Datadictionary OpenWave 3.1.11

View: vwhandhdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwhandhdochteraantallen

Fields

Rules

Definition

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

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