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.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.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, survey.completeddate, survey.completeddateltc, ...