Datadictionary OpenWave 3.1.32
Previous topic Chapter index Next topic

View: vwmilzwemlabanalyseklasse2overtredingen

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

Haalt alle klasse II overtredingen op

 

Fields

Name

Data type

Description

dnkeyanalysekop

integer

 

dnkeyobject

integer

 

ddmonsterdatum

timestamp

 

dnkeyparameter

integer

 

dlsluitinggekoppeld

char(1)

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwmilzwemlabanalyseklasse2overtredingen

 

Definition

CREATE VIEW public.vwmilzwemlabanalyseklasse2overtredingen (
   dnkeyanalysekop,
   dnkeyobject,
   ddmonsterdatum,
   dnkeyparameter,
   dlsluitinggekoppeld)
AS
SELECT
vwmilzwemlabanalyseregels.dnkeyanalysekop,
   vwmilzwemlabanalyseregels.dnkeyobject,
   vwmilzwemlabanalyseregels.ddmonsterdatum,
   vwmilzwemlabanalyseregels.dnkeyparameter,
   vwmilzwemlabanalyseregels.dlsluitinggekoppeld
FROM vwmilzwemlabanalyseregels
WHERE vwmilzwemlabanalyseregels.dfklasse2overtreding > 0;

COMMENT ON VIEW public.vwmilzwemlabanalyseklasse2overtredingen
IS 'Haalt alle klasse II overtredingen op';

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