Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtinginstallaties
Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtinginstallaties
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinrichtinginstallaties
Fields
Name | Data type | Description |
|---|---|---|
dvmodule |
char(1) |
|
dvstatus |
char(1) |
|
dnkeyvergunning |
integer |
|
dvzaakcode |
varchar(40) |
|
dddatum |
timestamp |
|
dvomschrijving |
varchar |
|
dnkeymilinrichtingen |
integer |
|
dvinstallatie |
varchar(50) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwinrichtinginstallaties
Definition
dvmodule,
dvstatus,
dnkeyvergunning,
dvzaakcode,
dddatum,
dvomschrijving,
dnkeymilinrichtingen,
dvinstallatie)
AS
SELECT 'W'::character(1) AS dvmodule,
'V'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvzaakcode,
c.ddbesluitdatum AS dddatum,
c.dvaanvraagnaam AS dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbomgvergunning c ON b.dnkeyomgvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar
UNION
SELECT 'W'::character(1) AS dvmodule,
'L'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvzaakcode,
c.ddaanvraag AS dddatum,
c.dvaanvraagnaam AS dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbomgvergunning c ON b.dnkeyomgvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL
UNION
SELECT 'E'::character(1) AS dvmodule,
'V'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvvergnummer AS dvzaakcode,
c.ddbesluitdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbmilvergunningen c ON b.dnkeymilvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar
UNION
SELECT 'E'::character(1) AS dvmodule,
'L'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvvergnummer AS dvzaakcode,
c.ddontvangstdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbmilvergunningen c ON b.dnkeymilvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL
UNION
SELECT 'B'::character(1) AS dvmodule,
'V'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvbouwnr AS dvzaakcode,
c.ddbesluitdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbbouwvergunningen c ON b.dnkeybouwvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
WHERE c.ddbesluitdatum IS NOT NULL AND e.dlverleend = 'T'::bpchar
UNION
SELECT 'B'::character(1) AS dvmodule,
'L'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvbouwnr AS dvzaakcode,
c.ddontvangstdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvinstallatie
FROM tbomgbwinstallaties b
JOIN tbbwinstallaties a ON b.dnkeybwinstallaties = a.dnkey
JOIN tbbouwvergunningen c ON b.dnkeybouwvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
WHERE c.ddbesluitdatum IS NULL AND c.ddingetrokken IS NULL
ORDER BY 2, 5 DESC;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|