Datadictionary OpenWave 3.1.33 |
|
View: vwinrichtingpreparaties_bt
Datadictionary OpenWave 3.1.33 |
|
View: vwinrichtingpreparaties_bt
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinrichtingpreparaties_bt
Columns
Name | Data type | Description |
|---|---|---|
dvmodule |
char(1) |
|
dvstatus |
char(1) |
|
dnkeyvergunning |
integer |
|
dvzaakcode |
varchar(40) |
|
dddatum |
timestamp |
|
dvomschrijving |
varchar(200) |
|
dnkeymilinrichtingen |
integer |
|
dvpreparatie |
varchar(50) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwinrichtingpreparaties_bt
Definition
dvmodule,
dvstatus,
dnkeyvergunning,
dvzaakcode,
dddatum,
dvomschrijving,
dnkeymilinrichtingen,
dvpreparatie)
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.dvpreparatie
FROM tbomgpreparaties b
JOIN tbpreparaties a ON b.dnkeypreparaties = 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
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.dvpreparatie
FROM tbomgpreparaties b
JOIN tbpreparaties a ON b.dnkeypreparaties = a.dnkey
JOIN tbomgvergunning c ON b.dnkeyomgvergunningen = c.dnkey AND
c.dlbeperktetoegang = 'T'::bpchar
JOIN tbmilinrichtingen d ON c.dnkeymilinrichtingen = d.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 |
|