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)

    • Related Articles

    • public.vwsurveyquestiongroupscores

      Description Survey Question Group Scores View Table Definition CREATE VIEW vwsurveyquestiongroupscores AS ( SELECT surveyquestiongroupscores.surveyid, surveyquestiongroupscores.conversationid, surveyquestiongroupscores.surveyformid, ...

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

      Description See UserDetail: User Description in detail Table Definition CREATE VIEW vwuserdetail AS ( SELECT ud.id, ud.name, ud.jabberid, ud.state, ud.title, lower((ud.email)::text) AS email, ud.username, ud.department, ud.manager AS managerid, ...

    • public.vwsurveyquestionanswers

      Description Survey Question Answers View Table Definition CREATE VIEW vwsurveyquestionanswers AS ( SELECT surveyquestionanswers.surveyid, surveyquestionanswers.conversationid, surveyquestionanswers.surveyformid, surveyquestionanswers.surveyname, ...

    • public.vwcalldetail

      Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcalldetail AS ( SELECT di.conversationid, di.originaldirection, di.mediatype, di.ani, di.dnis, di.purpose, di.sessiondirection, ...