Description: Resumo analítico de speech and text analytics by conversation.
Loading diagram…
erDiagram
QUEUES {
string id PK
string name
string division__id
string division__name
float member_count
float media_settings__call__alerting_timeout_seconds
float media_settings__call__service_level__percentage
float media_settings__call__service_level__duration_ms
float media_settings__socialexpression__alerting_timeout_seconds
float media_settings__socialexpression__service_level__percentage
float media_settings__socialexpression__service_level__duration_ms
float media_settings__chat__alerting_timeout_seconds
float media_settings__chat__service_level__percentage
float media_settings__chat__service_level__duration_ms
float media_settings__callback__alerting_timeout_seconds
float media_settings__callback__service_level__percentage
float media_settings__callback__service_level__duration_ms
float media_settings__message__alerting_timeout_seconds
float media_settings__message__service_level__percentage
float media_settings__message__service_level__duration_ms
float media_settings__videocomm__alerting_timeout_seconds
float media_settings__videocomm__service_level__percentage
float media_settings__videocomm__service_level__duration_ms
float media_settings__email__alerting_timeout_seconds
float media_settings__email__service_level__percentage
float media_settings__email__service_level__duration_ms
datetime date_created
datetime date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_AGENTS_EMPATHY {
string conversation_id
string transcript_id
string agent_user_id
float agent_empathy_score
string conversation_start_time
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_PARTICIPANTS {
string id PK
string conversation_id
string participant_id
string user_id
string purpose
string direction
string queue_id
float empathy_score
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
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_TRANSCRIPT_TEXT {
string conversation_id
string communication_id
string transcript_id
bigint utterance_index
string participant_purpose
string user_id
bigint start_ms
datetime start_time
bigint duration_ms
float confidence
string text
string decorated_text
string language
string engine_provider
string engine_id
string extracted_at
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
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
}
USERS {
string id PK
string name
string division__id
string department
string email
string state
string title
string username
string manager__id
float version
string employer_info__official_name
string employer_info__employee_id
string employer_info__employee_type
string employer_info__date_hire
string routing_status__status
datetime routing_status__start_time
string presence__id
string presence__name
string presence__source
boolean presence__primary
string presence__presence_definition__id
string presence__presence_definition__system_presence
string presence__message
datetime presence__modified_date
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
boolean acd_auto_answer
string language_preference
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_TRANSCRIPTS }o--|| QUEUES : agent_queue_id
SPEECH_TRANSCRIPTS }o--|| USERS : agent_user_id
SPEECH_AGENTS_EMPATHY }o--|| SPEECH_TRANSCRIPTS : conversation_id
SPEECH_PARTICIPANTS }o--|| SPEECH_TRANSCRIPTS : conversation_id
SPEECH_TOPICS }o--|| SPEECH_TRANSCRIPTS : conversation_id
SPEECH_TRANSCRIPT_TEXT }o--|| SPEECH_TRANSCRIPTS : conversation_id
| Source column |
Target table |
Target column |
agent_queue_id |
queues |
id |
agent_user_id |
users |
id |