Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevrefcontour (REV refertiecontouren)
Fields
Name | Data type | Description |
---|---|---|
dnkey |
integer |
Primary key van koppelbklactrefcontour |
dnkeymilcodebkl |
integer |
Foreign key naar REV BKL-actiivteit tbmilcodebkl |
dnkeyrevrefcontour |
integer |
Foreign key naar REV referentiecontour tbrevrefcontour |
dvbklactivnaam |
varchar(200) |
BKLactiviteitnaam in REV |
dvrefcontournaam |
varchar(200) |
Refenriecontournaam in REV |
dvrefeigennaam |
varchar(200) |
Eigen benaming Refenriecontournaam |
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 refertiecontouren)';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkey
IS 'Primary key van koppelbklactrefcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkeymilcodebkl
IS 'Foreign key naar REV BKL-actiivteit tbmilcodebkl';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dnkeyrevrefcontour
IS 'Foreign key naar REV referentiecontour tbrevrefcontour';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvbklactivnaam
IS 'BKLactiviteitnaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvrefcontournaam
IS 'Refenriecontournaam in REV';
COMMENT ON COLUMN public.vwfrmkoppelbklactrefcontour.dvrefeigennaam
IS 'Eigen benaming Refenriecontournaam';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 28-10-2022 13:55 |
![]() ![]() ![]() |