Contains data on skill mappings for users
CREATE VIEW vwskillmemberdata AS (
SELECT sm.userid,
ud.name AS user_name,
sd.name AS skill_name,
sm.proficiency,
sm.state
FROM ((userskillmappings sm
LEFT JOIN vwuserdetail ud ON (((sm.userid)::text = (ud.id)::text)))
LEFT JOIN skilldetails sd ON (((sm.skillid)::text = (sd.id)::text)))
ORDER BY sd.name, ud.name
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| userid | varchar(50) | true | User ID | |||
| user_name | varchar(200) | true | User Name | |||
| skill_name | varchar(50) | true | Skill Name | |||
| proficiency | numeric(20,2) | true | Indicates the proficiency level | |||
| state | varchar(50) | true | Represents the current state |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.userskillmappings | 6 | BASE TABLE | |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |
| public.skilldetails | 4 | BASE TABLE |