UserQueueMappings: View for mappings in between User and Queue
CREATE VIEW vwuserqueuemappings AS (
SELECT qm.queueid,
qd.name AS queuename,
qm.userid,
ud.name,
ud.department,
ud.managername,
qm.divisionid
FROM ((userqueuemappings qm
LEFT JOIN vwuserdetail ud ON (((qm.userid)::text = (ud.id)::text)))
LEFT JOIN vwqueuedetails qd ON (((qm.queueid)::text = (qd.id)::text)))
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| queueid | varchar(50) | true | Queue GUID | |||
| queuename | varchar(255) | true | Queue Name | |||
| userid | varchar(50) | true | User GUID | |||
| name | varchar(200) | true | User Name | |||
| department | varchar(200) | true | Department | |||
| managername | varchar(200) | true | Manager Name | |||
| divisionid | varchar(50) | true | Division GUID |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.userqueuemappings | 7 | BASE TABLE | |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |
| public.vwqueuedetails | 32 | Queue lookup data | VIEW |