Datadictionary OpenWave 3.1.5
Previous topic Chapter index Next topic

View: vwmilklachten_behandelaar

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwmilklachten_behandelaar

 

Fields

Name

Data type

Description

dddatumklacht

timestamp

 

ddafgerond

timestamp

 

dnkeymilinrichtingen

integer

 

dvomschrklacht

varchar(50)

 

dvcodemedewerkers

char(5)

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwmilklachten_behandelaar (
   dddatumklacht,
   ddafgerond,
   dnkeymilinrichtingen,
   dvomschrklacht,
   dvcodemedewerkers)
AS
SELECT
tbklachten.dddatumklacht, tbklachten.ddafgerond,
   tbklachten.dnkeymilinrichtingen,
   tbklachtoverlast.dvomsoverlast AS dvomschrklacht,
   tbklachten.dvcodemedewerkers
FROM tbklachten
  JOIN tbklachtoverlast ON tbklachten.dnkeyklachtoverlast = tbklachtoverlast.dnkey
WHERE tbklachten.dddatumklacht IS NOT NULL AND tbklachten.ddafgerond IS NULL
   AND
(tbklachten.dnkeymilinrichtingen IN (
   SELECT tbmilinrichtingen.dnkey
   FROM tbmilinrichtingen
   WHERE tbmilinrichtingen.ddblokkering IS NULL
   ));

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 15-5-2014 16:11
Previous topic Chapter index Next topic