Datadictionary OpenWave 3.1.11 |
|
View: vwfrmkopproccheck
Datadictionary OpenWave 3.1.11 |
|
View: vwfrmkopproccheck
Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbchecklistnaam en tbprocedures
Fields
Name | Data type | Description |
|---|---|---|
dnkeyprocedure |
integer |
Foreign key naar tbprocedures.dnkey |
dnkeychecklistnaam |
integer |
Foreign key naar tbchecklistnaam.dnkey |
dvprocnaam |
varchar(40) |
Naam van procedure |
dvchecklistnaam |
varchar(30) |
Naam van checklist |
dvvantoepop |
char(1) |
Moduleletter waar procdure aan is gekoppeld (WOECHIB) |
ddvervaldatum |
timestamp |
Verva;datum van de procedure |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyprocedure,
dnkeychecklistnaam,
dvprocnaam,
dvchecklistnaam,
dvvantoepop,
ddvervaldatum)
AS
SELECT a.dnkeyprocedure, a.dnkeychecklistnaam, b.dvprocnaam,
c.dvomschrijving AS dvchecklistnaam, b.dvvantoepop, b.ddvervaldatum
FROM tbkopproccheck a
JOIN tbprocedures b ON a.dnkeyprocedure = b.dnkey
JOIN tbchecklistnaam c ON a.dnkeychecklistnaam = c.dnkey;
COMMENT ON VIEW public.vwfrmkopproccheck
IS 'View van koppeltabel tbchecklistnaam en tbprocedures';
COMMENT ON COLUMN public.vwfrmkopproccheck.dnkeyprocedure
IS 'Foreign key naar tbprocedures.dnkey';
COMMENT ON COLUMN public.vwfrmkopproccheck.dnkeychecklistnaam
IS 'Foreign key naar tbchecklistnaam.dnkey';
COMMENT ON COLUMN public.vwfrmkopproccheck.dvprocnaam
IS 'Naam van procedure';
COMMENT ON COLUMN public.vwfrmkopproccheck.dvchecklistnaam
IS 'Naam van checklist';
COMMENT ON COLUMN public.vwfrmkopproccheck.dvvantoepop
IS 'Moduleletter waar procdure aan is gekoppeld (WOECHIB) ';
COMMENT ON COLUMN public.vwfrmkopproccheck.ddvervaldatum
IS 'Verva;datum van de procedure ';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|