Datadictionary OpenWave 3.1.33 |
|
View: vwinrichtinggebouwen_bt
Datadictionary OpenWave 3.1.33 |
|
View: vwinrichtinggebouwen_bt
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinrichtinggebouwen_bt
Columns
Name | Data type | Description |
|---|---|---|
dvmodule |
char(1) |
|
dvstatus |
char(1) |
|
dnkeyvergunning |
integer |
|
dvzaakcode |
varchar(40) |
|
dddatum |
timestamp |
|
dvomschrijving |
varchar(200) |
|
dnkeymilinrichtingen |
integer |
|
dvgebouwtype |
varchar(100) |
|
dvgebouwspec |
varchar(50) |
|
dnaantgebrtot |
integer |
|
dnaantgebrvan |
integer |
|
dvcontrolecode |
varchar(5) |
|
dvactiviteit |
varchar(100) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwinrichtinggebouwen_bt
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 AND
c.dlbeperktetoegang = 'T'::bpchar
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.dnkey
JOIN tbaardbesluit e ON c.dnkeyaardbesluit = e.dnkey
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 AND
c.dlbeperktetoegang = 'T'::bpchar
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;
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|