Datadictionary OpenWave 3.1.11

View: vwinfodochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinfodochteraantallen

Fields

Rules

Definition

CREATE VIEW public.vwinfodochteraantallen (
   tabel,
   dnkeyinfoaanvraag,
   aantal)
AS
       (        (        (        (        (        (
SELECT 'tbtermbewstappen'::character varying(19) AS tabel,
                                                           a.dnkeyinfoaanvraag,
                                                           count(DISTINCT
                                                               a.dnkeyorgprocedure +
                                                               CASE
                                                                   WHEN
                                                                       a.dninvoegnr IS NULL THEN 0
                                                                   ELSE a.dninvoegnr
                                                               END) AS aantal
FROM tbtermijnbewstappen a
                                                     JOIN tbinfoaanvragen b ON
                                                         a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag
UNION
SELECT 'tbinbehandelingbij'::character varying(19) AS tabel,
                                                           a.dnkeyinfoaanvraag,
                                                           count(*) AS aantal
FROM tbinbehandelingbij a
                                                     JOIN tbinfoaanvragen b ON
                                                         a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tbadviezen'::character varying(19) AS tabel,
                                                   a.dnkeyinfoaanvraag,
                                                   count(*) AS aantal
FROM tbadviezen a
                                             JOIN tbinfoaanvragen b ON
                                                 a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tbcorrespondentie'::character varying(19) AS tabel,
                                           a.dnkeyinfoaanvraag,
                                           count(*) AS aantal
FROM tbcorrespondentie a
                                     JOIN tbinfoaanvragen b ON
                                         a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tbcorrespbinnen'::character varying(19) AS tabel,
                                   a.dnkeyinfoaanvraag, count(*) AS aantal
FROM tbcorrespbinnen a
                             JOIN tbinfoaanvragen b ON a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tbinfocontactennn'::character varying(19) AS tabel,
                           a.dnkeyinfoaanvraag, count(*) AS aantal
FROM tbinfocontactennn a
                     JOIN tbinfoaanvragen b ON a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tblegesregels'::character varying(19) AS tabel,
                   a.dnkeyinfoaanvraag, count(*) AS aantal
FROM tblegesregels a
             JOIN tbinfoaanvragen b ON a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag)
UNION
SELECT 'tbinfotrefwoordennn'::character varying(19) AS tabel,
           a.dnkeyinfoaanvraag, count(*) AS aantal
FROM tbinfotrefwoordennn a
     JOIN tbinfoaanvragen b ON a.dnkeyinfoaanvraag = b.dnkey
GROUP BY a.dnkeyinfoaanvraag;

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