Transcript Segment

Transcript Segment

contactcentredb.transcript_segment

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(255) false
contact_id varchar(255) true
participant_id varchar(255) true
participant_role varchar(255) true
content varchar true
begin_offset_millis integer true
end_offset_millis integer true
sentiment varchar(255) true
db_last_updated timestamp without time zone true

Constraints

Name Type Definition
pk_transcript_segment PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
pk_transcript_segment CREATE UNIQUE INDEX pk_transcript_segment ON contactcentredb.transcript_segment USING btree (id)

Generated by tbls


    • Related Articles

    • README

      Logo Amazon Connect Data Dictionary Tables Name Columns Comment Type contactcentredb.queueobservations 13 BASE TABLE contactcentredb.queuemetrics 42 BASE TABLE contactcentredb.usergroups 15 BASE TABLE contactcentredb.agentstatus 12 BASE TABLE ...

    • Release Notes

      Customer Science releases regular updates to our Genesys Adapter and associated CXiaaS offerings. Please review to understand our current releases: August 2025 August 2025 Version v3.52.1 - August 08, 2025 Improvements Extended Date Field Updates ...

    • public.convvoiceoverviewdata

      Description Voice Analysis Overview Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false Primary Key conversationid varchar(50) true Conversation GUID sentimentscore numeric(20,2) true Convesation Sentiment Score ...

    • public.detailedinteractiondata

      Description Conversation Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation Start ...

    • public.vwdetailedinteractiondata

      Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwdetailedinteractiondata AS ( SELECT di.keyid, di.conversationid, di.conversationstartdate, di.conversationstartdateltc, ...