Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtinggebouwen
Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtinggebouwen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinrichtinggebouwen
Fields
Name | Data type | Description |
|---|---|---|
dvmodule |
char(1) |
|
dvstatus |
char(1) |
|
dnkeyvergunning |
integer |
|
dvzaakcode |
varchar(40) |
|
dddatum |
timestamp |
|
dvomschrijving |
varchar |
|
dnkeymilinrichtingen |
integer |
|
dvgebouwtype |
varchar(100) |
|
dvgebouwspec |
varchar(50) |
|
dnaantgebrtot |
integer |
|
dnaantgebrvan |
integer |
|
dvcontrolecode |
varchar(5) |
|
dvactiviteit |
varchar |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwinrichtinggebouwen
Definition
dvmodule,
dvstatus,
dnkeyvergunning,
dvzaakcode,
dddatum,
dvomschrijving,
dnkeymilinrichtingen,
dvgebouwtype,
dvgebouwspec,
dnaantgebrtot,
dnaantgebrvan,
dvcontrolecode,
dvactiviteit)
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,
f.dvtype AS dvgebouwtype,
g.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
b.dvwerkzaamheden AS dvactiviteit
FROM tbtoestemmingen b
JOIN tbgebouwtype f ON b.dnkeygebouwtype = f.dnkey
LEFT JOIN tbcontrgebouwtype a ON f.dnkeycontrgebouwtype = 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
LEFT JOIN tbgebouwspec g ON b.dnkeygebouwspec = g.dnkey
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,
f.dvtype AS dvgebouwtype,
g.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
b.dvwerkzaamheden AS dvactiviteit
FROM tbtoestemmingen b
JOIN tbgebouwtype f ON b.dnkeygebouwtype = f.dnkey
LEFT JOIN tbcontrgebouwtype a ON f.dnkeycontrgebouwtype = a.dnkey
JOIN tbomgvergunning c ON b.dnkeyomgvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
LEFT JOIN tbgebouwspec g ON b.dnkeygebouwspec = g.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,
g.dvtype AS dvgebouwtype,
h.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
c.dvpublbouwwerk AS dvactiviteit
FROM tbgebouwen b
JOIN tbgebouwtype g ON b.dnkeygebouwtype = g.dnkey
LEFT JOIN tbcontrgebouwtype a ON g.dnkeycontrgebouwtype = 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
LEFT JOIN tbgebouwspec h ON b.dnkeygebouwspec = h.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.ddbesluitdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
g.dvtype AS dvgebouwtype,
h.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
c.dvpublbouwwerk AS dvactiviteit
FROM tbgebouwen b
JOIN tbgebouwtype g ON b.dnkeygebouwtype = g.dnkey
LEFT JOIN tbcontrgebouwtype a ON g.dnkeycontrgebouwtype = 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
LEFT JOIN tbgebouwspec h ON b.dnkeygebouwspec = h.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,
g.dvtype AS dvgebouwtype,
h.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
c.dvpublbouwwerk AS dvactiviteit
FROM tbgebouwen b
JOIN tbgebouwtype g ON b.dnkeygebouwtype = g.dnkey
LEFT JOIN tbcontrgebouwtype a ON g.dnkeycontrgebouwtype = 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
LEFT JOIN tbgebouwspec h ON b.dnkeygebouwspec = h.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.ddbesluitdatum AS dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
g.dvtype AS dvgebouwtype,
h.dvspecificatie AS dvgebouwspec,
b.dnaantgebrtot,
b.dnaantgebrvan,
a.dvcode AS dvcontrolecode,
c.dvpublbouwwerk AS dvactiviteit
FROM tbgebouwen b
JOIN tbgebouwtype g ON b.dnkeygebouwtype = g.dnkey
LEFT JOIN tbcontrgebouwtype a ON g.dnkeycontrgebouwtype = 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
LEFT JOIN tbgebouwspec h ON b.dnkeygebouwspec = h.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 |
|