Schema
public
Owner
waveuser005
Descriptions
Haalt alle klasse II overtredingen op
Columns
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 dnkeyanalysekop,
dnkeyobject,
ddmonsterdatum,
dnkeyparameter,
dlsluitinggekoppeld
FROM vwmilzwemlabanalyseregels
WHERE dfklasse2overtreding > 0;
COMMENT ON VIEW public.vwmilzwemlabanalyseklasse2overtredingen
IS 'Haalt alle klasse II overtredingen op';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|