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

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

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

      Description Conversation Flow Outcome 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 ...