Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevevcontour (REV EVcontouren)
Fields
Name | Data type | Description |
---|---|---|
dnkey |
integer |
Primary key van koppelbklactevcontour |
dnkeymilcodebkl |
integer |
Foreign key naar REV BKL-actiivteit tbmilcodebkl |
dnkeyrevevcontour |
integer |
Foreign key naar REV EV-contour tbrevevcontour |
dvbklactivnaam |
varchar(200) |
BKLactiviteitnaam in REV |
dvevcontournaam |
varchar(200) |
EV-contournaam in REV |
dveveigennaam |
varchar(200) |
Eigen benaming van EV contourV |
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table vwfrmkoppelbklactevcontour
Definition
CREATE VIEW public.vwfrmkoppelbklactevcontour (
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 EVcontouren)';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkey
IS 'Primary key van koppelbklactevcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkeymilcodebkl
IS 'Foreign key naar REV BKL-actiivteit tbmilcodebkl';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dnkeyrevevcontour
IS 'Foreign key naar REV EV-contour tbrevevcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dvbklactivnaam
IS 'BKLactiviteitnaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dvevcontournaam
IS 'EV-contournaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactevcontour.dveveigennaam
IS 'Eigen benaming van EV contourV';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 28-10-2022 13:55 |
![]() ![]() ![]() |