Guideline for downloading Raw data to local database
Let’s start to divide the database tables into two types; basic tables and transactional tables.
Basic tables are:
- access_points*
- agent_event_source
- agent_event_types
- agent_result_codes
- agents*
- call_event_types
- call_result_codes
- media_types
- menues*
- queues*
- phone_types
- user_groups* (implemented as a view)
* Tables access_points, agents, menues and queues contain details about your solution(s), while the others contain generic Puzzel information.
Transactional tables are:
- call_events
- agent_events
- enqreg_header
- enqreg_category
- enqreg_topic
- sent_msg
- surveys
- call_variables
- call_relations
- call_event_extras
Please note the important field call_id has datatype Numeric (19,0).