Datadictionary OpenWave 3.1.25

View: vwmilvergdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwmilvergdochteraantallen

Fields

Rules

Indices

There are no indices for table vwmilvergdochteraantallen

Definition

CREATE VIEW public.vwmilvergdochteraantallen (
   tabel,
   dnkeymilvergunningen,
   aantal)
AS
SELECT 'tbtermbewstappen'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(DISTINCT a.dnkeyorgprocedure +
       CASE
           WHEN a.dninvoegnr IS NULL THEN 0
           ELSE a.dninvoegnr
       END) AS aantal
FROM tbtermijnbewstappen a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbinbehandelingbij a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbadviezen'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbadviezen a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbcorrespondentie'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbcorrespondentie a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbcorrespbinnen'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbcorrespbinnen a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbmilvergcontactennn'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbmilvergcontactennn a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbmilvergwetgrond'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbmilvergwetgrond a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbomgoloberichten'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbomgoloberichten a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbgebouwen'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbgebouwen a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbomgbwinstallaties'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbomgbwinstallaties a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbbwaantekeningen'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbbwaantekeningen a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen
UNION
SELECT 'tbomgpreparaties'::character varying(19) AS tabel,
   a.dnkeymilvergunningen,
   count(*) AS aantal
FROM tbomgpreparaties a
    JOIN tbmilvergunningen b ON a.dnkeymilvergunningen = b.dnkey
GROUP BY a.dnkeymilvergunningen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13