Datadictionary OpenWave 3.1.32
Previous topic Chapter index Next topic

View: vwfrmkoppelbklactrefcontour

 

 

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