Datadictionary OpenWave 3.1.25

View: vwhorecadochteraantallen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwhorecadochteraantallen

Fields

Rules

Indices

There are no indices for table vwhorecadochteraantallen

Definition

CREATE VIEW public.vwhorecadochteraantallen (
   tabel,
   dnkeyhorecavergunningen,
   aantal)
AS
SELECT 'tbtermbewstappen'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(DISTINCT a.dnkeyorgprocedure +
       CASE
           WHEN a.dninvoegnr IS NULL THEN 0
           ELSE a.dninvoegnr
       END) AS aantal
FROM tbtermijnbewstappen a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbinbehandelingbij a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbadviezen'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbadviezen a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbcorrespondentie'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbcorrespondentie a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbcorrespbinnen'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbcorrespbinnen a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorecacontactennn'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorecacontactennn a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbinspecties'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbinspecties a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tblegesregels'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tblegesregels a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorexploitatie'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorexploitatie a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorterras'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorterras a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorspeelautomaten'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorspeelautomaten a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorsluitingstijden'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorsluitingstijden a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorklachten'::character varying(20) AS tabel,
   a.dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorklachten a
    JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT 'tbhorbeperkingen'::character varying(20) AS tabel,
   a.dnkeyhorvergunning AS dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorbeperkingen a
    JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning
UNION
SELECT 'tbhorlokaliteiten'::character varying(20) AS tabel,
   a.dnkeyhorvergunning AS dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorlokaliteiten a
    JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning
UNION
SELECT 'tbhorontheffingen'::character varying(20) AS tabel,
   a.dnkeyhorvergunning AS dnkeyhorecavergunningen,
   count(*) AS aantal
FROM tbhorontheffingen a
    JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning;

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