public.vwmumemberdata

public.vwmumemberdata

Description

MU Member Data

Table Definition
CREATE VIEW vwmumemberdata AS (
 SELECT mudetails.id AS mu_id,
    mudetails.name AS mu_name,
    mumemberdata.id AS user_id,
    vwuserdetail.name AS user_name,
    vwuserdetail.managername AS manager_name
   FROM ((mumemberdata
     LEFT JOIN mudetails ON (((mudetails.id)::text = (mumemberdata.muid)::text)))
     LEFT JOIN vwuserdetail ON (((vwuserdetail.id)::text = (mumemberdata.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
mu_id varchar(50) true MU GUID
mu_name varchar(100) true MU Name
user_id varchar(50) true User ID
user_name varchar(200) true User Name
manager_name varchar(200) true Manager Name

Referenced Tables

Name Columns Comment Type
public.mumemberdata 4 BASE TABLE
public.mudetails 12 BASE TABLE
public.vwuserdetail 18 User details with manager and division context VIEW