public.userpresencedata

public.userpresencedata

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false
id varchar(50) true
userid varchar(50) true
startdate timestamp without time zone false
startdateltc timestamp without time zone true
timetype varchar(20) true
systempresenceid varchar(50) true
presenceid varchar(50) true
presencetime numeric(20,2) true
routingid varchar(50) true
routingtime numeric(20,2) true
updated timestamp without time zone true

Constraints

Name Type Definition
userpresencedata_pkey PRIMARY KEY PRIMARY KEY (keyid, startdate)

Indexes

Name Definition
userpresencedata_pkey CREATE UNIQUE INDEX userpresencedata_pkey ON ONLY public.userpresencedata USING btree (keyid, startdate)
userpresencedatastart CREATE INDEX userpresencedatastart ON ONLY public.userpresencedata USING btree (startdate)
userpresencedatastartltc CREATE INDEX userpresencedatastartltc ON ONLY public.userpresencedata USING btree (startdateltc)
userpresencedatatype CREATE INDEX userpresencedatatype ON ONLY public.userpresencedata USING btree (timetype)
userpresencedatauser CREATE INDEX userpresencedatauser ON ONLY public.userpresencedata USING btree (userid)
userpresencedata_timetype_startdateltc CREATE INDEX userpresencedata_timetype_startdateltc ON ONLY public.userpresencedata USING btree (timetype, startdateltc)
userpresencedata_startdate_cover CREATE INDEX userpresencedata_startdate_cover ON ONLY public.userpresencedata USING btree (startdate) INCLUDE (id, userid, startdateltc, systempresenceid, presenceid, presencetime, routingid, routingtime)

    • Related Articles

    • public.userpresencedatadaily

      Description User Presence Data Daily Data - LTC - See UserPresenceData for Descriptions Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time ...

    • public.userpresencedataweekly

      Description User Presence Data Weekly Data - LTC - See UserPresenceData for Descriptions Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time ...

    • public.userpresencedatamonthly

      Description User Presence Data Monthly Data - LTC - See UserPresenceData for Descriptions Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without ...

    • public.vwuserpresencedata

      Description See UserPresenceData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwuserpresencedata AS ( SELECT pd.id, pd.userid, ud.name AS agentname, ud.managerid, ud.managername, ud.divisionid, dd.name AS divisionname, ...

    • public.vwuserpresencedatadaily

      Description See UserPresenceDataDaily - Expands all the GUIDs with their lookups(Daily) Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, ...