Schema
public
Owner
waveuser005
Descriptions
Haalt alle klasse III 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 vwmilzwemlabanalyseklasse3overtredingen
Definition
CREATE VIEW public.vwmilzwemlabanalyseklasse3overtredingen (
dnkeyanalysekop,
dnkeyobject,
ddmonsterdatum,
dnkeyparameter,
dlsluitinggekoppeld)
AS
SELECT vwmilzwemlabanalyseregels.dnkeyanalysekop,
vwmilzwemlabanalyseregels.dnkeyobject,
vwmilzwemlabanalyseregels.ddmonsterdatum,
vwmilzwemlabanalyseregels.dnkeyparameter,
vwmilzwemlabanalyseregels.dlsluitinggekoppeld
FROM vwmilzwemlabanalyseregels
WHERE vwmilzwemlabanalyseregels.dfklasse3overtreding > 0;
COMMENT ON VIEW public.vwmilzwemlabanalyseklasse3overtredingen
IS 'Haalt alle klasse III overtredingen op.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 17-5-2024 15:06 |
![]() ![]() ![]() |