public.userpresencedetaileddata

public.userpresencedetaileddata

Description

User Presence Detailed Data

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false Primary Key
userid varchar(50) true Agent GUID
starttime timestamp without time zone false Start Time (UTC)
starttimeltc timestamp without time zone true Start Time (LTC)
endtime timestamp without time zone true End Time (UTC)
endtimeltc timestamp without time zone true End Time (LTC)
systempresence varchar(50) true System Presence GUID
orgpresence varchar(50) true Organisation Presence GUID
routingstatus varchar(50) true Routing Status (GUID)
timeinstate numeric(20,2) true Time in State (Secs)
updated timestamp without time zone true Date Row Updated (UTC)
organizationpresenceid varchar(50) true Organisation Presence GUID

Constraints

Name Type Definition
userpresencedetaileddata_pkey PRIMARY KEY PRIMARY KEY (keyid, starttime)

Indexes

Name Definition
userpresencedetaileddata_pkey CREATE UNIQUE INDEX userpresencedetaileddata_pkey ON ONLY public.userpresencedetaileddata USING btree (keyid, starttime)
userpresencedetend CREATE INDEX userpresencedetend ON ONLY public.userpresencedetaileddata USING btree (endtime)
userpresencedetendltc CREATE INDEX userpresencedetendltc ON ONLY public.userpresencedetaileddata USING btree (endtimeltc)
userpresencedetorgpres CREATE INDEX userpresencedetorgpres ON ONLY public.userpresencedetaileddata USING btree (orgpresence)
userpresencedetrouting CREATE INDEX userpresencedetrouting ON ONLY public.userpresencedetaileddata USING btree (routingstatus)
userpresencedetstart CREATE INDEX userpresencedetstart ON ONLY public.userpresencedetaileddata USING btree (starttime)
userpresencedetstartltc CREATE INDEX userpresencedetstartltc ON ONLY public.userpresencedetaileddata USING btree (starttimeltc)
userpresencedetsyspres CREATE INDEX userpresencedetsyspres ON ONLY public.userpresencedetaileddata USING btree (systempresence)
userpresencedetuser CREATE INDEX userpresencedetuser ON ONLY public.userpresencedetaileddata USING btree (userid)