public.userdetails

public.userdetails

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(200) true
jabberid varchar(100) true
state varchar(50) true
title varchar(200) true
email varchar(200) true
username varchar(200) true
department varchar(200) true
manager varchar(50) true
divisionid varchar(50) true
employeeid varchar(50) true
datehire varchar(50) true
updated timestamp without time zone true

Constraints

Name Type Definition
userdetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
userdetails_pkey CREATE UNIQUE INDEX userdetails_pkey ON public.userdetails USING btree (id)
userdetails_name_idx CREATE INDEX userdetails_name_idx ON public.userdetails USING btree (name)
userdetails_manager_idx CREATE INDEX userdetails_manager_idx ON public.userdetails USING btree (manager)
userdetails_divisionid_idx CREATE INDEX userdetails_divisionid_idx ON public.userdetails USING btree (divisionid)
userdetails_state_idx CREATE INDEX userdetails_state_idx ON public.userdetails USING btree (state)
idx_userdetails_id_division CREATE INDEX idx_userdetails_id_division ON public.userdetails USING btree (id, divisionid) INCLUDE (name, email, department, title) WHERE (id IS NOT NULL)
idx_userdetails_name_division CREATE INDEX idx_userdetails_name_division ON public.userdetails USING btree (name, divisionid, id) INCLUDE (email, department, title, state) WHERE (name IS NOT NULL)
idx_userdetails_email_division CREATE INDEX idx_userdetails_email_division ON public.userdetails USING btree (email, divisionid) INCLUDE (id, name, department) WHERE (email IS NOT NULL)

    • Related Articles

    • 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 ...

    • public.vwusergroupmappings

      Description Table Definition CREATE VIEW vwusergroupmappings AS ( SELECT ugm.id, ugm.name, ud.id AS user_id, ud.name AS user_name, ugm.groupid AS group_id, ugm.updated FROM (usergroupmappings ugm JOIN userdetails ud ON (((ugm.userid)::text = ...

    • public.vwsurveydata

      Description Survey Data View Table Definition CREATE VIEW vwsurveydata AS ( SELECT surveydata.surveyid, surveydata.conversationid, surveydata.surveyformid, surveydata.surveyname, surveydata.agentid, agent.name AS agentname, agent.department AS ...

    • public.vwevaluationoverview

      Description View for evaluation overview data (converted from materialized view) Table Definition CREATE VIEW vwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...

    • public.vwevaluationgroupdata

      Description View for evaluation group data (converted from table) Table Definition CREATE VIEW vwevaluationgroupdata AS ( SELECT egd.keyid, egd.evaluationid, egd.questiongroupid, ( SELECT ed.questiongroupname FROM evaldetails ed WHERE ...