Datadictionary OpenWave 3.1.11 |
|
View: vwfrmaudit
Datadictionary OpenWave 3.1.11 |
|
View: vwfrmaudit
Schema
public
Owner
waveuser005
Descriptions
View op tbaudit(audittrail)
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key. |
ddtimestamp |
timestamp |
Datum en tijd |
dvtimestamp |
text |
Datum en tijd itgeschreven als string dd-mm-yyy-hr-mm-ss |
dvcodemw |
char(5) |
Medewerker: tbmedewerkers.dvcode |
dvmwvoluit |
varchar(62) |
Medewerkernaam:voorletters en tussenvoegsel |
dvtablename |
varchar(30) |
Tabelnaam |
dvpointer |
varchar(50) |
Primary key van tabelnaam |
dvaction |
char(1) |
(Edit), (I)nsert of (D)elete |
dvfieldname |
varchar(30) |
Veldnaam uit tabelnaam |
dvvalue |
varchar(4000) |
Nieuwe waarde van veldnaam |
dvlocation |
varchar(1000) |
Devicelocatie waarvanuit de wijziging s gemaakt |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
ddtimestamp,
dvtimestamp,
dvcodemw,
dvmwvoluit,
dvtablename,
dvpointer,
dvaction,
dvfieldname,
dvvalue,
dvlocation)
AS
SELECT a.dnkey, a.ddtimestamp,
to_char(a.ddtimestamp, 'dd-mm-yyyy HH24:MI:SS'::text) AS dvtimestamp,
a.dvcodemw,
(((
CASE
WHEN b.dvvoorletters IS NULL THEN ''::text
ELSE b.dvvoorletters::text || ' '::text
END ||
CASE
WHEN b.dvtussenvoegsel IS NULL THEN ''::text
ELSE b.dvtussenvoegsel::text || ' '::text
END) || b.dvomschrijving::text))::character varying(62) AS dvmwvoluit,
a.dvtablename, a.dvpointer, a.dvaction, a.dvfieldname, a.dvvalue,
a.dvlocation
FROM tbaudit a
LEFT JOIN tbmedewerkers b ON a.dvcodemw = b.dvcode;
COMMENT ON VIEW public.vwfrmaudit
IS 'View op tbaudit(audittrail)';
COMMENT ON COLUMN public.vwfrmaudit.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.vwfrmaudit.ddtimestamp
IS 'Datum en tijd';
COMMENT ON COLUMN public.vwfrmaudit.dvtimestamp
IS 'Datum en tijd itgeschreven als string dd-mm-yyy-hr-mm-ss';
COMMENT ON COLUMN public.vwfrmaudit.dvcodemw
IS 'Medewerker: tbmedewerkers.dvcode';
COMMENT ON COLUMN public.vwfrmaudit.dvmwvoluit
IS 'Medewerkernaam:voorletters en tussenvoegsel';
COMMENT ON COLUMN public.vwfrmaudit.dvtablename
IS 'Tabelnaam';
COMMENT ON COLUMN public.vwfrmaudit.dvpointer
IS 'Primary key van tabelnaam';
COMMENT ON COLUMN public.vwfrmaudit.dvaction
IS '(Edit), (I)nsert of (D)elete';
COMMENT ON COLUMN public.vwfrmaudit.dvfieldname
IS 'Veldnaam uit tabelnaam';
COMMENT ON COLUMN public.vwfrmaudit.dvvalue
IS 'Nieuwe waarde van veldnaam';
COMMENT ON COLUMN public.vwfrmaudit.dvlocation
IS 'Devicelocatie waarvanuit de wijziging s gemaakt';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|