public.convvoicetopicdetaildata

public.convvoicetopicdetaildata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
conversationid varchar(50) true
starttime timestamp without time zone false
starttimeltc timestamp without time zone true
participant varchar(50) true
duration numeric(20,2) true
confidence numeric(20,2) true
topicname varchar(200) true
topicid varchar(50) true
topicphrase varchar(200) true
transcriptphrase varchar(200) true
updated timestamp without time zone true
transcriptnumber varchar(50) true
communicationid varchar(50) true
ani varchar(200) true
dnis varchar(200) true
queueid varchar(50) true
userid varchar(50) true

Constraints

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

Indexes

Name Definition
convvoicetopicdetaildata_new_pkey CREATE UNIQUE INDEX convvoicetopicdetaildata_new_pkey ON ONLY public.convvoicetopicdetaildata USING btree (keyid, starttime)
convvoicetopic__new_topicid CREATE INDEX convvoicetopic__new_topicid ON ONLY public.convvoicetopicdetaildata USING btree (topicid)
convvoicetopic_new_conv CREATE INDEX convvoicetopic_new_conv ON ONLY public.convvoicetopicdetaildata USING btree (conversationid)
convvoicetopicdetaildata_updated_idx CREATE INDEX convvoicetopicdetaildata_updated_idx ON ONLY public.convvoicetopicdetaildata USING btree (updated)
convvoicetopicdetaildata_confidence_idx CREATE INDEX convvoicetopicdetaildata_confidence_idx ON ONLY public.convvoicetopicdetaildata USING btree (confidence)
convvoicetopic_new_start CREATE INDEX convvoicetopic_new_start ON ONLY public.convvoicetopicdetaildata USING btree (starttime)
convvoicetopic_new_startltc CREATE INDEX convvoicetopic_new_startltc ON ONLY public.convvoicetopicdetaildata USING btree (starttimeltc)
convvoicetopic_participant CREATE INDEX convvoicetopic_participant ON ONLY public.convvoicetopicdetaildata USING btree (participant)
convvoicetopic_topicphrase CREATE INDEX convvoicetopic_topicphrase ON ONLY public.convvoicetopicdetaildata USING btree (topicphrase)
idx_convvoicetopicdetaildata_time_queue_topic CREATE INDEX idx_convvoicetopicdetaildata_time_queue_topic ON ONLY public.convvoicetopicdetaildata USING btree (starttime, queueid, topicname) INCLUDE (confidence, duration, participant) WHERE ((starttime IS NOT NULL) AND (queueid IS NOT NULL))
idx_convvoicetopicdetaildata_topic_time CREATE INDEX idx_convvoicetopicdetaildata_topic_time ON ONLY public.convvoicetopicdetaildata USING btree (topicname, starttime DESC) INCLUDE (queueid, userid, confidence, duration) WHERE (topicname IS NOT NULL)