Datadictionary OpenWave 3.1.11 |
|
View: vwfrmprocitemcheck
Datadictionary OpenWave 3.1.11 |
|
View: vwfrmprocitemcheck
Schema
public
Owner
waveuser005
Descriptions
View van koppeltabel tbchecklistnaam en tbprocitems
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key van tbprocitemcheck. |
dnkeyprocitems |
integer |
Foreign key naar tbprocitems.dnkey. |
dnkeychecklistnaam |
integer |
Foreign key naar tbchecklistnaam.dnkey. |
dvprocitem |
varchar(40) |
Naam van de procedure-item |
dvchecklistnaam |
varchar(30) |
Naam van de checklist |
dvprocnaam |
varchar(40) |
Naam van procedure waar procitem aanhangt |
dvvantoepop |
char(1) |
Procedure is van toepassing op module (BCEHIOW) |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
dnkeyprocitems,
dnkeychecklistnaam,
dvprocitem,
dvchecklistnaam,
dvprocnaam,
dvvantoepop)
AS
SELECT a.dnkey, a.dnkeyprocitems, a.dnkeychecklistnaam,
b.dvomschrijving AS dvprocitem, c.dvomschrijving AS dvchecklistnaam,
d.dvprocnaam, d.dvvantoepop
FROM tbprocitemcheck a
JOIN tbprocitems b ON a.dnkeyprocitems = b.dnkey
JOIN tbprocedures d ON b.dnkeyprocedures = d.dnkey
JOIN tbchecklistnaam c ON a.dnkeychecklistnaam = c.dnkey;
COMMENT ON VIEW public.vwfrmprocitemcheck
IS 'View van koppeltabel tbchecklistnaam en tbprocitems';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dnkey
IS 'Primary key van tbprocitemcheck.';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dnkeyprocitems
IS 'Foreign key naar tbprocitems.dnkey.';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dnkeychecklistnaam
IS 'Foreign key naar tbchecklistnaam.dnkey.';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dvprocitem
IS 'Naam van de procedure-item';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dvchecklistnaam
IS 'Naam van de checklist';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dvprocnaam
IS 'Naam van procedure waar procitem aanhangt';
COMMENT ON COLUMN public.vwfrmprocitemcheck.dvvantoepop
IS 'Procedure is van toepassing op module (BCEHIOW)';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|