Database diagram

Raw data Database diagram, part-1 (of 2)

New column in table agents from db v2.3: puzzel_id

Raw data Database diagram, part-2 (of 2)

New in db v2.4.1.0

• In table 'surveys' we added columns 'survey_name', 'survey_id', 'related_ticket_id'
   

New in db v2.4.0.0

• In table 'enqreg_category' we added a new column ‘parent_category_id’
• In view 'vw_enqreg_total' we added 2 new columns: 'parsed_category_name' and 'parsed_category_id'
   

New in db v2.3:

• New table 'access_points'
• New table 'sent_msg' (Populated only if requested)
• New columns in table 'surveys': 'element_type', 'element_id', 'ci_session_id'