Datadictionary OpenWave 3.1.27
Previous topic Chapter index Next topic

View: vwfrmkoppelbklactrefcontour

 

 

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
Previous topic Chapter index Next topic