Datadictionary OpenWave 3.1.32 |
|
View: vwmilzwemobjecten
Datadictionary OpenWave 3.1.32 |
|
View: vwmilzwemobjecten
Schema
public
Owner
waveuser005
Descriptions
Haalt de zwermobjecten op
Fields
Name | Data type | Description |
|---|---|---|
dnkeyobject |
integer |
|
dnkeymilinrichtingen |
integer |
|
dvinrichtingnaam |
varchar(100) |
|
dnkeyzwemzaal |
integer |
|
dnkeyobjecttype |
integer |
|
dvobjectnaam |
varchar(100) |
|
dvobjectnaamvoorlab |
varchar(100) |
|
dvobjectomschrijving |
varchar(100) |
|
dlishoofdobject |
char(1) |
|
dlisopen |
char(1) |
|
dvredengesloten |
varchar(200) |
|
dnkeyhoofdobject |
integer |
|
dlozon |
char(1) |
|
dlisopenext |
text |
|
dlisopencombi |
text |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwmilzwemobjecten
Definition
dnkeyobject,
dnkeymilinrichtingen,
dvinrichtingnaam,
dnkeyzwemzaal,
dnkeyobjecttype,
dvobjectnaam,
dvobjectnaamvoorlab,
dvobjectomschrijving,
dlishoofdobject,
dlisopen,
dvredengesloten,
dnkeyhoofdobject,
dlozon,
dlisopenext,
dlisopencombi)
AS
SELECT obj.dnkey AS dnkeyobject,
obj.dnkeymilinrichtingen,
zz.dvinrichtingnaam,
obj.dnkeyzwemzaal,
obj.dnkeyobjecttype,
obj.dvobjectnaam,
obj.dvobjectnaamvoorlab,
obj.dvobjectomschrijving,
obj.dlishoofdobject,
obj.dlisopen,
obj.dvredengesloten,
obj.dnkeyhoofdobject,
obj.dlozon,
zz.dlisopenext,
CASE
WHEN obj.dlisopen = 'F'::bpchar OR zz.dlisopenext = 'F'::text THEN 'F'::text
ELSE 'T'::text
END AS dlisopencombi
FROM tbmilzwemobjecten obj
LEFT JOIN vwfrmmilzwemzalen zz ON zz.dnkeyzwemzaal = obj.dnkeyzwemzaal;
COMMENT ON VIEW public.vwmilzwemobjecten
IS 'Haalt de zwermobjecten op';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|