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 |
![]() ![]() ![]() |