public.vwteammemberdata

Description

Team Member Data View

Table Definition

CREATE VIEW vwteammemberdata AS (
 SELECT tm.userid,
    ud.name AS "Agent Name",
    td.name AS "Team Name"
   FROM ((teammemberdata tm
     LEFT JOIN userdetails ud ON (((tm.userid)::text = (ud.id)::text)))
     LEFT JOIN teamdetails td ON (((tm.teamid)::text = (td.id)::text)))
)

Columns

Name	Type	Nullable	Comment
userid	varchar(50)	true	User ID
Agent Name	varchar(200)	true	Agent Name
Team Name	varchar(200)	true	Team Name

Referenced Tables

Name	Columns	Comment	Type
public.teammemberdata	4	Work Team Membership Data	BASE TABLE
public.userdetails	14		BASE TABLE
public.teamdetails	7		BASE TABLE