Description: Contact lists used in outbound campaigns.
Loading diagram…
erDiagram
CONTACT_LISTS {
string id PK
string name
float size
float version
datetime date_created
datetime date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CONVERSATION_UNI_YYYY_MM {
string id
string conversation_id
string session_id
datetime conversation_start
datetime conversation_end
datetime segment_start
string external_tag
datetime segment_end
string participant_id
string participant_name
string user_id
string purpose
string direction
string media_type
string disconnect_type
string queue_id
string queue_name
string wrap_up_code
string wrap_up_note
string flow_id
string flow_name
string outbound_campaign_id
string outbound_contact_id
string outbound_contact_list_id
float alert
float callback
float coaching
float contacting
float converting
float delay
float dialing
float hold
float interact
float ivr
float monitoring
float scheduled
float sharing
float system
float transmitting
float unknown
float uploading
float voicemail
float wrapup
float total
string ani
string dnis
string sip_response_codes
string transfer_target_address
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CONVERSATION_UNI_YYYY_MM }o--|| CONTACT_LISTS : outbound_contact_list_id
| Source column |
Target table |
Target column |
| - |
- |
- |