Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevrefcontour (REV referentiecontouren)
Fields
Name | Data type | Description |
---|---|---|
dnkey |
integer |
Primary key van koppelbklactrefcontour |
dnkeymilcodebkl |
integer |
Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey) |
dnkeyrevrefcontour |
integer |
Foreign key naar REV referentiecontour (tbrevrefcontour.dnkey) |
dvbklactivnaam |
varchar(200) |
BKL-activiteitnaam in REV |
dvrefcontournaam |
varchar(200) |
Refenriecontournaam in REV |
dvrefeigennaam |
varchar(200) |
Eigen benaming Referentiecontournaam |
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table vwfrmkoppelbklactrefcontour
Definition
CREATE VIEW public.vwfrmkoppelbklactrefcontour (
dnkey,
dnkeymilcodebkl,
dnkeyrevrefcontour,
dvbklactivnaam,
dvrefcontournaam,
dvrefeigennaam)
AS
SELECT a.dnkey,
a.dnkeymilcodebkl,
a.dnkeyrevrefcontour,
b.dvnaaminrev AS dvbklactivnaam,
c.dvnaaminrev AS dvrefcontournaam,
c.dvomschrijving AS dvrefeigennaam
FROM tbkoppelbklactrefcontour a
JOIN tbmilcodebkl b ON b.dnkey = a.dnkeymilcodebkl
JOIN tbrevrefcontour c ON c.dnkey = a.dnkeyrevrefcontour;
COMMENT ON VIEW public.vwfrmkoppelbklactrefcontour
IS 'View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevrefcontour (REV referentiecontouren)';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkey
IS 'Primary key van koppelbklactrefcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkeymilcodebkl
IS 'Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey)';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkeyrevrefcontour
IS 'Foreign key naar REV referentiecontour (tbrevrefcontour.dnkey)';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvbklactivnaam
IS 'BKL-activiteitnaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvrefcontournaam
IS 'Refenriecontournaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvrefeigennaam
IS 'Eigen benaming Referentiecontournaam';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
![]() ![]() ![]() |