Datadictionary OpenWave 3.1.25 |
|
View: vwfrmmwteams
Datadictionary OpenWave 3.1.25 |
|
View: vwfrmmwteams
Schema
public
Owner
waveuser005
Descriptions
View van Verbindingstabel tussen tbteams en tbmedewerkers
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key van tbmwteams |
dnkeyteam |
integer |
Foreign key naar tbteams.dnkey |
dvteamnaam |
varchar(100) |
Naam van team |
dvcodemw |
text |
Foreign key naar tbmedewerkers.dvcode |
dvmwvoluit |
varchar(62) |
Medewekersnaam voluit |
ddvervaldatum |
timestamp |
Datum waar vanaf combinatie team medewerker nier meer geldig is |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmmwteams
Definition
dnkey,
dnkeyteam,
dvteamnaam,
dvcodemw,
dvmwvoluit,
ddvervaldatum)
AS
SELECT a.dnkey,
a.dnkeyteam,
b.dvteamnaam,
btrim(a.dvcodemw::text) AS dvcodemw,
(((
CASE
WHEN btrim(c.dvvoorletters::text) IS NULL THEN ''::text
ELSE c.dvvoorletters::text || ' '::text
END ||
CASE
WHEN btrim(c.dvtussenvoegsel::text) IS NULL THEN ''::text
ELSE c.dvtussenvoegsel::text || ' '::text
END) || c.dvomschrijving::text))::character varying(62) AS dvmwvoluit,
a.ddvervaldatum
FROM tbmwteams a
LEFT JOIN tbteams b ON a.dnkeyteam = b.dnkey
LEFT JOIN tbmedewerkers c ON a.dvcodemw = c.dvcode;
COMMENT ON VIEW public.vwfrmmwteams
IS 'View van Verbindingstabel tussen tbteams en tbmedewerkers';
COMMENT ON COLUMN public.vwfrmmwteams.dnkey
IS 'Primary key van tbmwteams';
COMMENT ON COLUMN public.vwfrmmwteams.dnkeyteam
IS 'Foreign key naar tbteams.dnkey';
COMMENT ON COLUMN public.vwfrmmwteams.dvteamnaam
IS 'Naam van team';
COMMENT ON COLUMN public.vwfrmmwteams.dvcodemw
IS 'Foreign key naar tbmedewerkers.dvcode';
COMMENT ON COLUMN public.vwfrmmwteams.dvmwvoluit
IS 'Medewekersnaam voluit';
COMMENT ON COLUMN public.vwfrmmwteams.ddvervaldatum
IS 'Datum waar vanaf combinatie team medewerker nier meer geldig is';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|