Datadictionary OpenWave 3.1.25 |
|
View: vwfrmteams
Datadictionary OpenWave 3.1.25 |
|
View: vwfrmteams
Schema
public
Owner
waveuser005
Descriptions
View van tbteams
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key tbteams.dnkey |
dvteamnaam |
varchar(100) |
naam van het team |
ddvervaldatum |
timestamp |
Datum waar vanaf team nier meer gekozen kan worden |
dvcodeteamleider |
char(5) |
Foreign key naar tbmedewerkers.dvcode |
dvteamleidervoluit |
varchar(62) |
Naam, voorletters en tussenvoegsel van teamleider |
dnkeycompartiment |
integer |
Foreign key naar tbcompartiment.dnkey |
dvcompartimentnaam |
varchar(50) |
Naam van compartiment |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmteams
Definition
dnkey,
dvteamnaam,
ddvervaldatum,
dvcodeteamleider,
dvteamleidervoluit,
dnkeycompartiment,
dvcompartimentnaam)
AS
SELECT a.dnkey,
a.dvteamnaam,
a.ddvervaldatum,
a.dvcodeteamleider,
(((((b.dvomschrijving::text || ', '::text) || COALESCE(b.dvvoorletters,
''::character varying)::text) || ' '::text) || COALESCE(b.dvtussenvoegsel, ''::character varying)::text))::character varying(62) AS dvteamleidervoluit,
a.dnkeycompartiment,
c.dvnaam AS dvcompartimentnaam
FROM tbteams a
LEFT JOIN tbmedewerkers b ON a.dvcodeteamleider = b.dvcode
LEFT JOIN tbcompartiment c ON a.dnkeycompartiment = c.dnkey;
COMMENT ON VIEW public.vwfrmteams
IS 'View van tbteams';
COMMENT ON COLUMN public.vwfrmteams.dnkey
IS 'Primary key tbteams.dnkey';
COMMENT ON COLUMN public.vwfrmteams.dvteamnaam
IS 'naam van het team';
COMMENT ON COLUMN public.vwfrmteams.ddvervaldatum
IS 'Datum waar vanaf team nier meer gekozen kan worden';
COMMENT ON COLUMN public.vwfrmteams.dvcodeteamleider
IS 'Foreign key naar tbmedewerkers.dvcode';
COMMENT ON COLUMN public.vwfrmteams.dvteamleidervoluit
IS 'Naam, voorletters en tussenvoegsel van teamleider';
COMMENT ON COLUMN public.vwfrmteams.dnkeycompartiment
IS 'Foreign key naar tbcompartiment.dnkey';
COMMENT ON COLUMN public.vwfrmteams.dvcompartimentnaam
IS 'Naam van compartiment';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|