Datadictionary OpenWave 3.1.11

View: vwmilinrdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwmilinrdochteraantallen

Fields

Rules

Definition

CREATE VIEW public.vwmilinrdochteraantallen (
   tabel,
   dnkeymilinrichtingen,
   aantal)
AS
       (        (        (        (        (        (        (        (
           (        (        (        (        (        (        (        (        (
SELECT 'tbcorrespondentie'::character varying(17) AS tabel,
                                                                                                                                                       a.dnkeymilinrichtingen,
                                                                                                                                                       count(*) AS aantal
FROM tbcorrespondentie a
                                                                                                                                                 JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen
UNION
SELECT 'tbcorrespbinnen'::character varying(17) AS tabel,
                                                                                                                                                       a.dnkeymilinrichtingen,
                                                                                                                                                       count(*) AS aantal
FROM tbcorrespbinnen a
                                                                                                                                                 JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilcontactennn'::character varying(17) AS tabel,
                                                                                                                                               a.dnkeymilinrichtingen,
                                                                                                                                               count(*) AS aantal
FROM tbmilcontactennn a
                                                                                                                                         JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbinspecties'::character varying(17) AS tabel,
                                                                                                                                       a.dnkeymilinrichtingen,
                                                                                                                                       count(*) AS aantal
FROM tbinspecties a
                                                                                                                                 JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbklachten'::character varying(17) AS tabel,
                                                                                                                               a.dnkeymilinrichtingen,
                                                                                                                               count(*) AS aantal
FROM tbklachten a
                                                                                                                         JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbhorontheffingen'::character varying(17) AS tabel,
                                                                                                                       a.dnkeymilinrichtingen,
                                                                                                                       count(*) AS aantal
FROM tbhorontheffingen a
                                                                                                                 JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmiltrefwoord'::character varying(17) AS tabel,
                                                                                                               a.dnkeymilinrichtingen,
                                                                                                               count(*) AS aantal
FROM tbmiltrefwoord a
                                                                                                         JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilopslag'::character varying(17) AS tabel,
                                                                                                       a.dnkeymilinrichtingen,
                                                                                                       count(*) AS aantal
FROM tbmilopslag a
                                                                                                 JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilcertificaten'::character varying(17) AS tabel,
                                                                                               a.dnkeymilinrichtingen,
                                                                                               count(*) AS aantal
FROM tbmilcertificaten a
                                                                                         JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilsbi'::character varying(17) AS tabel,
                                                                                       a.dnkeymilinrichtingen,
                                                                                       count(*) AS aantal
FROM tbmilsbi a
                                                                             JOIN
                                                                                 tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilivb'::character varying(17) AS tabel,
                                                                           a.dnkeymilinrichtingen,
                                                                           count(*)
                                                                               AS aantal
FROM tbmilivb a
                                                                     JOIN
                                                                         tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilemwater'::character varying(17) AS tabel,
                                                                   a.dnkeymilinrichtingen,
                                                                   count(*) AS aantal
FROM tbmilemwater a
                                                             JOIN
                                                                 tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilemstal'::character varying(17) AS tabel,
                                                           a.dnkeymilinrichtingen,
                                                           count(*) AS aantal
FROM tbmilemstal a
                                                     JOIN tbmilinrichtingen b
                                                         ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilemlucht'::character varying(17) AS tabel,
                                                   a.dnkeymilinrichtingen,
                                                   count(*) AS aantal
FROM tbmilemlucht a
                                             JOIN tbmilinrichtingen b ON
                                                 a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmilenergie'::character varying(17) AS tabel,
                                           a.dnkeymilinrichtingen,
                                           count(*) AS aantal
FROM tbmilenergie a
                                     JOIN tbmilinrichtingen b ON
                                         a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbmildiversen'::character varying(17) AS tabel,
                                   a.dnkeymilinrichtingen, count(*) AS aantal
FROM tbmildiversen a
                             JOIN tbmilinrichtingen b ON
                                 a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbbwaantekeningen'::character varying(17) AS tabel,
                           a.dnkeymilinrichtingen, count(*) AS aantal
FROM tbbwaantekeningen a
                     JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbaanvalsplannen'::character varying(17) AS tabel,
                   a.dnkeymilinrichtingen, count(*) AS aantal
FROM tbaanvalsplannen a
             JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen)
UNION
SELECT 'tbomsinstallaties'::character varying(17) AS tabel,
           a.dnkeymilinrichtingen, count(*) AS aantal
FROM tbomsinstallaties a
     JOIN tbmilinrichtingen b ON a.dnkeymilinrichtingen = b.dnkey
GROUP BY a.dnkeymilinrichtingen;

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