Datadictionary OpenWave 3.1.25
Previous topic Chapter index Next topic

View: vwinfoheefttermijnen

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

There is no description for view vwinfoheefttermijnen

 

Fields

Name

Data type

Description

dnkeyinfoheeftterm

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwinfoheefttermijnen

 

Definition

CREATE VIEW public.vwinfoheefttermijnen (
   dnkeyinfoheeftterm)
AS
SELECT DISTINCT
a.dnkeyinfoaanvraag AS dnkeyinfoheeftterm
FROM tbinfoaanvragen b
    JOIN tbtermijnbewstappen a ON b.dnkey = a.dnkeyinfoaanvraag
WHERE b.ddblokkeerdatum IS NULL;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13
Previous topic Chapter index Next topic