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_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)

    • Related Articles

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

    • public.vwsurveyquestionanswers

      Description Survey Question Answers View Table Definition CREATE VIEW vwsurveyquestionanswers AS ( SELECT surveyquestionanswers.surveyid, surveyquestionanswers.conversationid, survey.completeddate, survey.completeddateltc, ...