Description: Tópicos detectados nas conversations pelo speech analytics.
Loading diagram…
erDiagram
SPEECH_TOPICS {
string id PK
string conversation_id
string topic
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
bigint start_ms__i
float start_ms__f
bigint end_ms__i
float end_ms__f
float confidence
float sentiment_score
}
SPEECH_TRANSCRIPTS {
string conversation_id PK
datetime conversation_start_time
float conversation_sentiment_score
float conversation_sentiment_trend
float conversation_empathy_score
bigint conv_duration_ms
bigint handle_time_ms
bigint cust_speech_ms
bigint agent_speech_ms
bigint overtalk_ms
bigint overtalk_instances
bigint silence_ms
bigint ivr_ms
bigint other_ms
bigint queue_acd_ms
float cust_speech_pct
float agent_speech_pct
float overtalk_pct
float silence_pct
float ivr_pct
float other_pct
float queue_acd_pct
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
string agent_user_id
string agent_queue_id
}
SPEECH_TOPICS }o--|| SPEECH_TRANSCRIPTS : conversation_id
| Source column |
Target table |
Target column |
conversation_id |
speech_transcripts |
conversation_id |
| Source table |
Source column |
Target column |
| - |
- |
- |