Datadictionary OpenWave 3.1.25 |
|
View: vwovdochteraantallen
Datadictionary OpenWave 3.1.25 |
|
View: vwovdochteraantallen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwovdochteraantallen
Fields
Name | Data type | Description |
|---|---|---|
tabel |
varchar(20) |
|
dnkeyovvergunningen |
integer |
|
aantal |
bigint |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwovdochteraantallen
Definition
tabel,
dnkeyovvergunningen,
aantal)
AS
SELECT 'tbtermbewstappen'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(DISTINCT a.dnkeyorgprocedure +
CASE
WHEN a.dninvoegnr IS NULL THEN 0
ELSE a.dninvoegnr
END) AS aantal
FROM tbtermijnbewstappen a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbinbehandelingbij'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbinbehandelingbij a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbadviezen'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbadviezen a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbcorrespondentie'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbcorrespondentie a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbcorrespbinnen'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbcorrespbinnen a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbovcontactennn'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbovcontactennn a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tbinspecties'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tbinspecties a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen
UNION
SELECT 'tblegesregels'::character varying(20) AS tabel,
a.dnkeyovvergunningen,
count(*) AS aantal
FROM tblegesregels a
JOIN tbovvergunningen b ON a.dnkeyovvergunningen = b.dnkey
GROUP BY a.dnkeyovvergunningen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|