Datadictionary OpenWave 3.1.25

View: vwmilinrdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwmilinrdochteraantallen

Fields

Rules

Indices

There are no indices for table vwmilinrdochteraantallen

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 5-1-2022 14:13