public.queuerealtimeconvdata

public.queuerealtimeconvdata

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
conversationid varchar(50) true
queueid varchar(50) true
conversationstate varchar(50) true
userid varchar(50) true
media varchar(50) true
direction varchar(50) true
state varchar(50) true
skill1 varchar(50) true
skill2 varchar(50) true
skill3 varchar(50) true
segementtime timestamp without time zone true
talktime timestamp without time zone true
heldstate varchar(50) true
heldtime timestamp without time zone true
actingas varchar(50) true
acwstate boolean true
manuallychecked boolean true
acwstring varchar(50) true
acwtime timestamp without time zone true
initialpriority integer true
updated timestamp without time zone true
segmenttime timestamp without time zone true
usedrout varchar(50) true
requestedrout1 varchar(50) true
requestedrout2 varchar(50) true
ani varchar(400) true
dnis varchar(400) true
participantname varchar(200) true
startdate timestamp without time zone true
startdateltc timestamp without time zone true
talktimeltc timestamp without time zone true

Constraints

Name Type Definition
queuerealtimeconvdata_key PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
queuerealtimeconvdata_key CREATE UNIQUE INDEX queuerealtimeconvdata_key ON public.queuerealtimeconvdata USING btree (keyid)

    • Related Articles

    • public.vwqueueconvrealtime

      Description See QueueConvRealTime: Queue Conversation Real-Time Data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, ...
    • public.vwrealtimequeue

      Description Real-time queue data Table Definition CREATE VIEW vwrealtimequeue AS ( WITH all_media AS ( SELECT DISTINCT queuerealtimeconvdata.media FROM queuerealtimeconvdata UNION SELECT unnest(ARRAY['voice'::text, 'callback'::text, 'chat'::text, ...
    • public.vwrealtimequeueconv

      Description Real-time queue conversation data Table Definition CREATE VIEW vwrealtimequeueconv AS ( SELECT qc.conversationid, qc.media, qc.actingas, datediff('second'::character varying, qc.startdate, timezone('utc'::text, now())) AS statussecs, ...
    • public.mvwconvvoiceoverviewdata

      Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
    • public.mvwconvvoicesentimentdetaildata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...