Datadictionary OpenWave 3.1.27
Previous topic Chapter index Next topic

View: vwfrmkoppelbklactevcontour

 

 

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