Datadictionary OpenWave 3.1.25

View: vwhandhdochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwhandhdochteraantallen

Fields

Rules

Indices

There are no indices for table vwhandhdochteraantallen

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