Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtingaantek
Datadictionary OpenWave 3.1.25 |
|
View: vwinrichtingaantek
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinrichtingaantek
Fields
Name | Data type | Description |
|---|---|---|
dvmodule |
char(1) |
|
dvstatus |
char(1) |
|
dnkeyvergunning |
integer |
|
dvzaakcode |
varchar(40) |
|
dddatum |
timestamp |
|
dvomschrijving |
varchar |
|
dnkeymilinrichtingen |
integer |
|
dvmemo |
varchar(2000) |
|
dvaardbesluit |
varchar(40) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwinrichtingaantek
Definition
dvmodule,
dvstatus,
dnkeyvergunning,
dvzaakcode,
dddatum,
dvomschrijving,
dnkeymilinrichtingen,
dvmemo,
dvaardbesluit)
AS
SELECT 'E'::character(1) AS dvmodule,
'V'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvvergnummer AS dvzaakcode,
a.dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvmemo,
e.dvomschrijving AS dvaardbesluit
FROM tbbwaantekeningen a
JOIN tbmilvergunningen c ON a.dnkeymilvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbsoortmilverg f ON c.dnkeysoortmilverg = f.dnkey
LEFT JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL OR c.ddingetrokken IS NOT NULL
UNION
SELECT 'E'::character(1) AS dvmodule,
'L'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvvergnummer AS dvzaakcode,
a.dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvmemo,
NULL::character varying(40) AS dvaardbesluit
FROM tbbwaantekeningen a
JOIN tbmilvergunningen c ON a.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,
a.dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvmemo,
e.dvomschrijving AS dvaardbesluit
FROM tbbwaantekeningen a
JOIN tbbouwvergunningen c ON a.dnkeybouwvergunningen = c.dnkey
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbsoortplan f ON c.dnsoortplan = f.dnkey
LEFT JOIN tbaardbesluit e ON c.dvcodeaardbesluit = e.dvcode
WHERE c.ddbesluitdatum IS NOT NULL OR c.ddingetrokken IS NOT NULL
UNION
SELECT 'B'::character(1) AS dvmodule,
'L'::character(1) AS dvstatus,
c.dnkey AS dnkeyvergunning,
c.dvbouwnr AS dvzaakcode,
a.dddatum,
f.dvomschrijving,
c.dnkeymilinrichtingen,
a.dvmemo,
NULL::character varying(40) AS dvaardbesluit
FROM tbbwaantekeningen a
JOIN tbbouwvergunningen c ON a.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 |
|