Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

View: vwinrgebjongstedatumverleend

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

There is no description for view vwinrgebjongstedatumverleend

 

Fields

Name

Data type

Description

ddjongstedatum

timestamp

 

dnkeymilinrichtingen

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwinrgebjongstedatumverleend (
   ddjongstedatum,
   dnkeymilinrichtingen)
AS
SELECT max(vwinrichtinggebouwen.dddatum) AS ddjongstedatum,
   vwinrichtinggebouwen.dnkeymilinrichtingen
FROM vwinrichtinggebouwen
WHERE vwinrichtinggebouwen.dvstatus = 'V'::bpchar
GROUP BY vwinrichtinggebouwen.dnkeymilinrichtingen; 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50
 Previous topic Chapter index Next topic