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 ...

    • Contact Lens Summary

      contactcentredb.contact_lens_summary Description Columns Name Type Default Nullable Children Parents Comment contact_id varchar(255) false transcript_summary varchar true overall_sentiment_agent double precision true overall_sentiment_customer double ...

    • 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, ...

    • 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 ...