Datadictionary OpenWave 3.1.32 |
|
View: vwfrmkoppelbklactevcontour
Datadictionary OpenWave 3.1.32 |
|
View: vwfrmkoppelbklactevcontour
Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevevcontour (REV EV-contouren)
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key van koppelbklactevcontour |
dnkeymilcodebkl |
integer |
Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey) |
dnkeyrevevcontour |
integer |
Foreign key naar REV EV-contour (tbrevevcontour.dnkey) |
dvbklactivnaam |
varchar(200) |
BKL-activiteitnaam in REV |
dvevcontournaam |
varchar(200) |
EV-contournaam in REV |
dveveigennaam |
varchar(200) |
Eigen benaming van EV contour |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmkoppelbklactevcontour
Definition
dnkey,
dnkeymilcodebkl,
dnkeyrevevcontour,
dvbklactivnaam,
dvevcontournaam,
dveveigennaam)
AS
SELECT a.dnkey,
a.dnkeymilcodebkl,
a.dnkeyrevevcontour,
b.dvnaaminrev AS dvbklactivnaam,
c.dvnaaminrev AS dvevcontournaam,
c.dvomschrijving AS dveveigennaam
FROM tbkoppelbklactevcontour a
JOIN tbmilcodebkl b ON b.dnkey = a.dnkeymilcodebkl
JOIN tbrevevcontour c ON c.dnkey = a.dnkeyrevevcontour;
COMMENT ON VIEW public.vwfrmkoppelbklactevcontour
IS 'View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevevcontour (REV EV-contouren)';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkey
IS 'Primary key van koppelbklactevcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkeymilcodebkl
IS 'Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey)';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkeyrevevcontour
IS 'Foreign key naar REV EV-contour (tbrevevcontour.dnkey)';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dvbklactivnaam
IS 'BKL-activiteitnaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dvevcontournaam
IS 'EV-contournaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dveveigennaam
IS 'Eigen benaming van EV contour';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|