Datadictionary OpenWave 3.1.32 |
|
View: vwfrmmilzwemzalen
Datadictionary OpenWave 3.1.32 |
|
View: vwfrmmilzwemzalen
Schema
public
Owner
waveuser005
Descriptions
Haalt de zaalgegevens per inrichting op. Basistabel tbmilzwemzalen
Fields
Name | Data type | Description |
|---|---|---|
dnkeyzwemzaal |
integer |
|
dnkeymilinrichtingen |
integer |
|
dvinrichtingnaam |
varchar(100) |
|
dvzaalnaam |
varchar(50) |
|
dvzaalomschrijving |
varchar(200) |
|
dlisbinnen |
char(1) |
|
dlisopen |
char(1) |
|
dvredengesloten |
varchar(200) |
|
dlozon |
text |
|
dlisopenext |
text |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmmilzwemzalen
Definition
dnkeyzwemzaal,
dnkeymilinrichtingen,
dvinrichtingnaam,
dvzaalnaam,
dvzaalomschrijving,
dlisbinnen,
dlisopen,
dvredengesloten,
dlozon,
dlisopenext)
AS
SELECT zalen.dnkey AS dnkeyzwemzaal,
zalen.dnkeymilinrichtingen,
ext.dvinrichtingnaam,
zalen.dvzaalnaam,
zalen.dvzaalomschrijving,
zalen.dlisbinnen,
zalen.dlisopen,
zalen.dvredengesloten,
CASE
WHEN ozon.aantal > 0 THEN 'T'::text
ELSE 'F'::text
END AS dlozon,
CASE
WHEN zalen.dlisbinnen = 'T'::bpchar THEN
CASE
WHEN CURRENT_DATE >= ext.ddbinnenopendatum AND CURRENT_DATE <=
ext.ddbinnensluitdatum AND ext.dlisopen = 'T'::bpchar AND zalen.dlisopen = 'T'::bpchar THEN 'T'::text
ELSE 'F'::text
END
ELSE
CASE
WHEN CURRENT_DATE >= ext.ddbuitenopendatum AND CURRENT_DATE <=
ext.ddbuitensluitdatum AND ext.dlisopen = 'T'::bpchar AND zalen.dlisopen = 'T'::bpchar THEN 'T'::text
ELSE 'F'::text
END
END AS dlisopenext
FROM tbmilzwemzalen zalen
LEFT JOIN vwmilzwemext ext ON ext.dnkey = zalen.dnkeymilinrichtingen
LEFT JOIN LATERAL (
SELECT tbmilzwemobjecten.dnkeyzwemzaal,
count(*) AS aantal
FROM tbmilzwemobjecten
GROUP BY tbmilzwemobjecten.dnkeyzwemzaal, tbmilzwemobjecten.dlozon
HAVING tbmilzwemobjecten.dlozon = 'T'::bpchar
) ozon ON ozon.dnkeyzwemzaal = zalen.dnkey;
COMMENT ON VIEW public.vwfrmmilzwemzalen
IS 'Haalt de zaalgegevens per inrichting op. Basistabel tbmilzwemzalen';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|