public.userrealtimeconvdata

public.userrealtimeconvdata

Description

User Real Time Conversation Data

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false Primary Key
id varchar(50) true
conversationid varchar(50) true Conversation GUID
media varchar(50) true Conversation Media Type
direction varchar(50) true Conversation Direction
conversationstate varchar(50) true Conversation State
acwstate boolean true Conversation ACW State
acwstring varchar(50) true Conversation ACW GUID
acwtime timestamp without time zone true Conversation ACW Start Time (UTC)
heldstate boolean true Conversation Held State
heldtime timestamp without time zone true Conversation Held Start Time (UTC)
talktime timestamp without time zone true Conversation Talk Time Start (UTC)
startdate timestamp without time zone true
startdateltc timestamp without time zone true
actingas varchar(50) true Conversation Acting As (ACD as Queue, Customer or Agent)
queueid varchar(50) true Queue GUID
skill1 varchar(50) true Conversation Skill 1
skill2 varchar(50) true Conversation Skill 2
skill3 varchar(50) true Conversation Skill 3
intialpriority integer true
updated timestamp without time zone true Date Row Updated (UTC)
initialpriority integer true Conversation Initial Priority
userid varchar(50) true Agent GUID
usedrout varchar(50) true Conversation Used Route
requestedrout1 varchar(50) true Conversation Requested Route 1
requestedrout2 varchar(50) true Conversation Requested Route 2
ani varchar(400) true Conversation ANI
dnis varchar(400) true Conversation DNIS
participantname varchar(200) true
segmenttime timestamp without time zone true Conversation Current Segment Start Time (UTC)
talktimeltc timestamp without time zone true Conversation Talk Time Start (LTC)
state varchar(50) true
manuallychecked boolean true
disconnecttype varchar(50) true Disconnect type indicating how the conversation ended (e.g., transfer, client, peer)

Constraints

Name Type Definition
userrealtimeconvdata_key PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
userrealtimeconvdata_key CREATE UNIQUE INDEX userrealtimeconvdata_key ON public.userrealtimeconvdata USING btree (keyid)
idx_userrealtimeconvdata_userid CREATE INDEX idx_userrealtimeconvdata_userid ON public.userrealtimeconvdata USING btree (userid)
idx_userrealtimeconvdata_conversationid CREATE INDEX idx_userrealtimeconvdata_conversationid ON public.userrealtimeconvdata USING btree (conversationid)
idx_userrealtimeconvdata_queueid CREATE INDEX idx_userrealtimeconvdata_queueid ON public.userrealtimeconvdata USING btree (queueid)
idx_userrealtimeconvdata_id CREATE INDEX idx_userrealtimeconvdata_id ON public.userrealtimeconvdata USING btree (id)