DRP_TBL|console_logs
**
DRP_TBL|importmaster
**
DRP_TBL|dnd
**
DRP_TBL|after_disposed
**
DRP_TBL|process_attachment
**
DRP_TBL|qa_assign_log
**
DRP_TBL|export_data_csv
**
DRP_TBL|cron_scheduler
**
DRP_TBL|addCdrData_log
**
CRT_TBL|fresh_db_check|`Type` varchar(50) DEFAULT NULL,
  `Version` varchar(50) DEFAULT NULL
**
QRY|TRUNCATE fresh_db_check 
**
CRT_TBL|console_logs|`id` bigint(20) NOT NULL AUTO_INCREMENT,
	`process_id` int(11) DEFAULT NULL,
	`user_id` int(11) DEFAULT NULL,
	`name` varchar(100) DEFAULT NULL,
	`ext` varchar(100) DEFAULT NULL,
	`type` varchar(100) DEFAULT NULL,
	`data` text,
	`ip_address` varchar(50) DEFAULT NULL,
	`time` datetime DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
**
CRT_TBL|aftersaveupdatelog|`logid` varchar(15) DEFAULT NULL,
	`mapid` varchar(15) DEFAULT NULL,
	`masterid` varchar(15) DEFAULT NULL,
	`disposition` varchar(100) DEFAULT NULL,
	`subdisposition` varchar(100) DEFAULT NULL,
	`start_time` varchar(30) DEFAULT NULL,
	`end_time` varchar(30) DEFAULT NULL,
	`setcallbacktime` varchar(30) DEFAULT NULL,
	`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,
	`processid` varchar(15) DEFAULT NULL,
	`campaignid` varchar(15) DEFAULT NULL,
	`sqlcommand` text,
	`proc_agent_id` int(11) DEFAULT NULL
**
CRT_TBL|afteruploadupdatelog|`insertdate` DATETIME NULL DEFAULT NULL,
	`processid` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`campaignid` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`fileid` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci'
**
CRT_TBL|dnd|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `process_id` int(5) DEFAULT NULL,
  `campaign_id` int(5) DEFAULT NULL,
  `phone_no` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `dnd_end_date` datetime DEFAULT NULL,
  `block_incoming` int(1) DEFAULT '0',
  `created_by` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `srch_process_id` varchar(50) DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `inserted_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IndexDNDPhoneNO` (`phone_no`) USING BTREE
**
CRT_TBL|dnd_1|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `process_id` int(5) DEFAULT NULL,
  `campaign_id` int(5) DEFAULT NULL,
  `phone_no` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `dnd_end_date` datetime DEFAULT NULL,
  `block_incoming` int(1) DEFAULT '0',
  `created_by` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `srch_process_id` varchar(50) DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `inserted_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|addEmailDataLog|`pid` varchar(10) DEFAULT NULL,
	`cid` varchar(10) DEFAULT NULL,
	`client_id` varchar(10) DEFAULT NULL,
	`agent_id` varchar(50) DEFAULT NULL,
	`missed_call_email_template` int(11) DEFAULT NULL,
	`email_on_missed_call` int(11) DEFAULT NULL,
	`caller_id` varchar(16) DEFAULT NULL,
	`did_no` varchar(16) DEFAULT NULL,
	`log_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
**
CRT_TBL|crm_tms_config|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `campaign_id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `disposition` varchar(300) COLLATE utf8mb4_bin DEFAULT NULL,
  `subject` varchar(300) COLLATE utf8mb4_bin DEFAULT NULL,
  `tmstype` varchar(300) COLLATE utf8mb4_bin DEFAULT NULL,
  `new_ticket_url` longtext COLLATE utf8mb4_bin,
  `view_ticket_url` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
  `raise_ticket_url` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
  `new_ticket_request` longtext COLLATE utf8mb4_bin,
  `view_ticket_request` longtext COLLATE utf8mb4_bin,
  `raise_ticket_request` longtext COLLATE utf8mb4_bin,
  `status` int(1) DEFAULT NULL,
  `queue_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `tms_api_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `tms_api_client_token` text COLLATE utf8mb4_bin,
  `created_by` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `modified_by` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `inserted_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|omni_setup|`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `client_name` varchar(50) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `campaign_id` int(11) DEFAULT NULL,
  `email_template_id` int(11) DEFAULT NULL,
  `zoom_meeting_sms_template_id` int(11) DEFAULT NULL,
  `san_meeting_sms_template_id` int(11) DEFAULT NULL,
  `whatsapp_template_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `faq` varchar(50) DEFAULT NULL,
  `token` varchar(50) DEFAULT NULL,
  `start_time_hh` varchar(2) DEFAULT NULL,
  `start_time_mm` varchar(2) DEFAULT NULL,
  `end_time_hh` varchar(2) DEFAULT NULL,
  `end_time_mm` varchar(2) DEFAULT NULL,
  `agent` varchar(5) DEFAULT NULL,
  `setup_auto_reply_chat` varchar(500) DEFAULT NULL,
  `chat_dispose_message` varchar(200) DEFAULT NULL,
  `agent_mapping` int(1) DEFAULT NULL,
  `queue_log` tinyint(4) DEFAULT '0',
  `allow_paste_image` tinyint(4) DEFAULT '0',
  `default_setup` tinyint(4) DEFAULT '0',
  `san_video_app_url` varchar(250) DEFAULT NULL,
  `fb_page_id` varchar(20) DEFAULT NULL,
  `fb_page_name` varchar(300) DEFAULT NULL,
  `fb_app_id` varchar(20) DEFAULT NULL,
  `fb_app_name` varchar(300) DEFAULT NULL,
  `fb_api_url` varchar(300) DEFAULT NULL,
  `fb_app_secret` varchar(200) DEFAULT NULL,
  `fb_user_id` varchar(100) DEFAULT NULL,
  `fb_user_access_token` varchar(1000) DEFAULT NULL,
  `fb_page_access_token` varchar(1000) DEFAULT NULL,
  `fb_auto_rep_message` varchar(200) DEFAULT NULL,
  `env_name` varchar(20) DEFAULT NULL,
  `twitter_app_id` varchar(20) DEFAULT NULL,
  `twitter_id` varchar(20) DEFAULT NULL,
  `twitter_api_secret` varchar(100) DEFAULT NULL,
  `twitter_client_id` varchar(100) DEFAULT NULL,
  `twitter_client_secret` varchar(100) DEFAULT NULL,
  `twitter_api_key` varchar(100) DEFAULT NULL,
  `twitter_access_token_secret` varchar(150) DEFAULT NULL,
  `twitter_access_token` varchar(150) DEFAULT NULL,
  `twitter_direct_message` varchar(150) DEFAULT NULL,
  `twitter_auto_rep_msg` varchar(150) DEFAULT NULL,
  `twitter_api_base_url` varchar(150) DEFAULT NULL,
  `whatsApp_no` varchar(16) DEFAULT NULL,
  `whatsApp_user_id` varchar(50) DEFAULT NULL,
  `whatsApp_passwd` varchar(50) DEFAULT NULL,
  `whatsApp_auto_resp_msg` varchar(200) DEFAULT NULL,
  `wa_solution_provider` varchar(30) DEFAULT NULL,
  `whatsApp_api_url` text,
  `whatsApp_media_url` text,
  `viber_no` varchar(50) DEFAULT NULL,
  `viber_acc_id` varchar(150) DEFAULT NULL,
  `viber_acc_name` varchar(250) DEFAULT NULL,
  `viber_auth_token` text,
  `viber_auto_resp_msg` text,
  `viber_webhook_url` text,
  `viber_api_url` text,
  `website` varchar(250) DEFAULT NULL,
  `website_welcome_text` text,
  `website_auto_resp_msg` text,
  `website_font_family` varchar(100) DEFAULT NULL,
  `website_background_color` varchar(20) DEFAULT NULL,
  `website_foreground_color` varchar(20) DEFAULT NULL,
  `zoom_account_name` varchar(100) DEFAULT NULL,
  `zoom_account_id` varchar(150) DEFAULT NULL,
  `zoom_auth_token` varchar(500) DEFAULT NULL,
  `zoom_sdk_id` varchar(200) DEFAULT NULL,
  `zoom_sdk_token` varchar(200) DEFAULT NULL,
  `zoom_base_url` varchar(100) DEFAULT NULL,
  `zoom_token_url` varchar(100) DEFAULT NULL,
  `zoom_virtual_bg_path` text,
  `zoom_virtual_bg_id` varchar(250) DEFAULT NULL,
  `zoom_acc_logo_path` text,
  `zoom_web_sdk_url` varchar(500) DEFAULT NULL,
  `zoom_meeting_topic` varchar(100) DEFAULT NULL,
  `zoom_meeting_duration` smallint(6) DEFAULT NULL,
  `zoom_disable_video` tinyint(4) DEFAULT NULL,
  `zoom_disable_screen_share` tinyint(4) DEFAULT NULL,
  `san_meeting_duration` tinyint(4) DEFAULT NULL,
  `san_logo_path` text,
  `san_welcome_text` varchar(100) DEFAULT NULL,
  `san_meeting_enable_presentation` tinyint(4) DEFAULT NULL,
  `san_meeting_enable_notes` tinyint(4) DEFAULT NULL,
  `san_meeting_enable_external_video` tinyint(4) DEFAULT NULL,
  `san_banner_text` varchar(50) DEFAULT NULL,
  `san_banner_color` varchar(50) DEFAULT NULL,
  `bigblubtn_account_name` varchar(100) DEFAULT NULL,
  `bigblubtn_secret_key` text,
  `bigblubtn_api_base_url` varchar(200) DEFAULT NULL,
  `insert_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `last_update` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `omni_token` varchar(50) DEFAULT NULL,
  `created_by` int(5) DEFAULT NULL,
  `updated_by` int(5) DEFAULT NULL,
  `chat_online_message` varchar(250) DEFAULT NULL,
  `chat_offline_message` varchar(250) DEFAULT NULL,
  `chat_welcome_message` varchar(250) DEFAULT NULL,
  `start_time` varchar(20) DEFAULT NULL,
  `end_time` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|process_chat_session|`session_id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) NOT NULL DEFAULT '0',
  `campaign_id` int(11) NOT NULL DEFAULT '0',
  `agent_id_1` int(11) DEFAULT NULL,
  `agent_id_2` int(11) DEFAULT NULL,
  `initiated_by` int(11) DEFAULT NULL,
  `is_admin_session` tinyint(1) DEFAULT '0',
  `crm_user_id` int(11) DEFAULT '0',
  `session_start_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `session_end_at` datetime DEFAULT NULL,
  PRIMARY KEY (`session_id`) USING btree
**
CRT_TBL|process_chat_session_log|`log_id` int(11) NOT NULL AUTO_INCREMENT,
  `session_id` int(11) NOT NULL DEFAULT '0',
  `msg_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `chat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `agent_id` int(11) DEFAULT NULL,
  `crm_user_id` int(11) DEFAULT NULL,
  `attachment_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_token` varchar(50) DEFAULT NULL,
  `read_by` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE
**
CRT_TBL|process_retry_disposition|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(5) NOT NULL,
  `attempt_no` int(5) DEFAULT NULL,
  `time_in_min` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|attendance_login_logout_log|`id` int(11) NOT NULL AUTO_INCREMENT,
  `agent_id` int(11) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `campaign_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `duration` bigint(20) DEFAULT NULL,
  `inserted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
**
CRT_TBL|attendance_register|`Attendance_Id` int(11) NOT NULL AUTO_INCREMENT,
  `Attendance_Date` date DEFAULT NULL,
  `Agent_Name` varchar(20) DEFAULT NULL,
  `Attendance_Type` int(11) DEFAULT NULL,
  `note` varchar(100) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`Attendance_Id`)
**
CRT_TBL|attendance_shift_master|`Shift_Id` int(11) NOT NULL AUTO_INCREMENT,
  `Shift_Name` varchar(10) DEFAULT NULL,
  `From_Hrs` varchar(50) DEFAULT NULL,
  `To_Hrs` varchar(10) DEFAULT NULL,
  `Half_Day_Duration` int(11) DEFAULT NULL,
  `Agent_Group_Id` int(11) DEFAULT NULL,
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `absent_duration` int(11) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`Shift_Id`)
**
CRT_TBL|attendance_type_master|`attendance_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `Attendance_Name` varchar(20) DEFAULT NULL,
  `Attendance_Type` varchar(30) DEFAULT NULL,
  `Color` varchar(30) DEFAULT NULL,
  `Description` varchar(100) DEFAULT NULL,
  `From_hrs` varchar(50) DEFAULT NULL,
  `To_hrs` varchar(50) DEFAULT NULL,
  `isPresent` bit(1) DEFAULT NULL,
  `isAbsent` bit(1) DEFAULT NULL,
  `isHalf_day` bit(1) DEFAULT NULL,
  `Time_stamp` timestamp NULL DEFAULT NULL,
  `Shiftid` int(11) DEFAULT NULL,
  PRIMARY KEY (`attendance_type_id`) USING BTREE,
  KEY `FK_attendance_type_master_attendance_shift_master` (`Shiftid`)
**
CRT_TBL|client_logs_admin|`id` int(5) NOT NULL AUTO_INCREMENT,
  `class` varchar(100) DEFAULT NULL,
  `method` varchar(100) DEFAULT NULL,
  `request` text,
  `time` datetime DEFAULT CURRENT_TIMESTAMP,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|captcha|`captcha_id` int(11) NOT NULL AUTO_INCREMENT,
  `captcha_time` int(10) unsigned NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `word` varchar(20) NOT NULL,
  PRIMARY KEY (`captcha_id`),
  KEY `captcha_time` (`captcha_time`)
**
CRT_TBL|process_disposition_flow|`id` int(11) NOT NULL AUTO_INCREMENT,
  `disposition` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL,
  `sub_dispo_flow` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|user_client_report|`id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|importmaster|`id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `process_id` int(5) DEFAULT NULL,
  `campaign_id` int(5) DEFAULT NULL,
  `branch_id` int(5) DEFAULT NULL,
  `import_type` varchar(25) CHARACTER SET latin1 DEFAULT NULL,
  `show_mapping` int(1) DEFAULT NULL,
  `update_existing_master_data` int(1) DEFAULT NULL,
  `force_update_existing_master_data` int(1) DEFAULT NULL,
  `update_existing_campaign_data` int(1) DEFAULT NULL,
  `do_not_import_existing_data` int(1) DEFAULT NULL,
  `active_file` int(1) DEFAULT NULL,
  `update_san_insert_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `mark_for_deletion` int(1) DEFAULT NULL,
  `priority` int(3) DEFAULT NULL,
  `retain_callback` int(1) DEFAULT NULL,
  `valid_upto` datetime DEFAULT NULL,
  `last_dnd_update` datetime DEFAULT NULL,
  `imported_by` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
  `total_records` int(11) DEFAULT NULL,
  `records_inserted` int(11) DEFAULT NULL,
  `records_updated` int(11) DEFAULT NULL,
  `duplicate_records` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `active_file` (`active_file`) USING BTREE,
  KEY `mark_for_deletion` (`mark_for_deletion`) USING BTREE,
  KEY `valid_upto` (`valid_upto`) USING BTREE
**
DRP_TBL|campaign_mapping
**
CRT_TBL|campaign_mapping|`map_id` int(11) NOT NULL AUTO_INCREMENT,
  `campaign_id` int(5) NOT NULL,
  `master_id` int(5) NOT NULL,
  `dialed` int(2) DEFAULT NULL,
  `agent_id` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `CallAgainTime` datetime DEFAULT NULL,
  `CallAgainNo` varchar(16) CHARACTER SET latin1 DEFAULT NULL,
  `CallAgainNoAttempt` int(1) DEFAULT NULL,
  `LastCallTime` datetime DEFAULT NULL,
  `disposition` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `sub_disposition` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `NoOfAttempts` int(5) DEFAULT NULL,
  `DoNotCall` int(1) DEFAULT NULL,
  `dncReason` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `CallConnected` int(1) DEFAULT NULL,
  `UniqueId` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `CallAssignPhoneNo` varchar(15) CHARACTER SET latin1 DEFAULT NULL,
  `HangupCause` int(3) DEFAULT NULL,
  `StopCalling` int(2) DEFAULT NULL,
  `StopCallingReason` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `FileId` int(11) DEFAULT NULL,
  `LastLogId` int(11) DEFAULT NULL,
  `LastIvrDigit` int(3) DEFAULT NULL,
  `DataChurnCounter` int(5) DEFAULT NULL,
  `CallAgainType` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `callbackLastDialTime` datetime DEFAULT NULL,
  `MapToAgent` int(1) NOT NULL DEFAULT '0',
  `Callbackdial_on_Hold` int(1) DEFAULT NULL,
  `AutoChurnCounter` int(5) DEFAULT '0',
  `StopCallingUpdateTime` datetime DEFAULT NULL,
  `mapping_remarks` varchar(50) DEFAULT NULL,
  `added_dial_list` int(1) DEFAULT NULL,
  `dial_list_add_time` datetime DEFAULT NULL,
  `Agent_assign_date` datetime DEFAULT NULL,
  `inserted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `inserted_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`map_id`) USING BTREE,
  KEY `CallAgainTime` (`CallAgainTime`) USING BTREE,
  KEY `MapToAgent` (`MapToAgent`) USING BTREE,
  KEY `dialed` (`dialed`) USING BTREE,
  KEY `master_id` (`master_id`) USING BTREE,
  KEY `agent_id` (`agent_id`) USING BTREE,
  KEY `FileId` (`FileId`) USING BTREE,
  KEY `campaign_id` (`campaign_id`) USING BTREE,
  KEY `DoNotCall` (`DoNotCall`) USING BTREE,
  KEY `StopCalling` (`StopCalling`) USING BTREE
**
QRY|INSERT INTO `importmaster` (`file_name`, `process_id`, `campaign_id`, `branch_id`, `import_type`, `show_mapping`, `update_existing_master_data`, `update_existing_campaign_data`, `do_not_import_existing_data`, `active_file`, `update_san_insert_date`, `upload_date`, `mark_for_deletion`, `priority`, `retain_callback`, `valid_upto`, `last_dnd_update`, `imported_by`, `total_records`, `records_inserted`, `records_updated`, `duplicate_records`) VALUES ('Manual Dial', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
**
CRT_TBL|letter_sms_log|`id` bigint(20) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) DEFAULT NULL,
  `receiver` varchar(15) NOT NULL,
  `message` varchar(1220) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `status` varchar(15) DEFAULT NULL,
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `api_response` text,
  `whatsappApi` text,
  `whatsapp_sent` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|letter_email_log|`id` bigint(20) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) DEFAULT NULL,
  `email_ac` int(3) NOT NULL,
  `to_email` varchar(100) NOT NULL,
  `bcc` varchar(100) NOT NULL,
  `cc` varchar(100) NOT NULL,
  `message` varchar(1220) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `body` text,
  `subject` varchar(1220) DEFAULT NULL,
  `status` varchar(15) DEFAULT NULL,
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `email_sent` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|omni_chat_customer_master|`id` int NOT NULL AUTO_INCREMENT,
  `client_id` int NOT NULL DEFAULT '0',
  `customer_name` varchar(120) DEFAULT NULL,
  `email_id` varchar(100) DEFAULT NULL,
  `facebook_id` varchar(100) DEFAULT NULL,
  `twitter_id` varchar(100) DEFAULT NULL,
  `whatsapp_no` varchar(16) DEFAULT NULL,
  `viber_id` varchar(100) DEFAULT NULL,
  `phone_no` varchar(16) DEFAULT NULL,
  `website_id` varchar(100) DEFAULT NULL,
  `master_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|omni_chat_session|`session_id` int NOT NULL AUTO_INCREMENT,
  `omni_id` int NOT NULL DEFAULT '0',
  `process_id` int NOT NULL DEFAULT '0',
  `campaign_id` int NOT NULL DEFAULT '0',
  `account_id` varchar(100) DEFAULT NULL,
  `start_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `end_time` datetime DEFAULT NULL,
  `chat_customer_id` int DEFAULT NULL,
  `agent_id` int DEFAULT NULL,
  `client_id` int DEFAULT NULL,
  `extension_no` varchar(20) DEFAULT NULL,
  `customer_name` varchar(100) DEFAULT NULL,
  `email_id` varchar(100) DEFAULT NULL,
  `phone_no` varchar(16) DEFAULT NULL,
  `type_of_chat` varchar(50) DEFAULT NULL,
  `initiated_by` varchar(20) DEFAULT NULL,
  `customer_account_id` varchar(100) DEFAULT NULL,
  `disposition` varchar(200) DEFAULT NULL,
  `sub_disposition` varchar(200) DEFAULT NULL,
  `process_master_id` int DEFAULT NULL,
  `process_log_id` int DEFAULT NULL,
  `meeting_log_id` int DEFAULT NULL,
  `remarks` varchar(2000) DEFAULT NULL,
  `is_customer_exit` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`session_id`)
**
CRT_TBL|omni_chat_session_log|`log_id` int NOT NULL AUTO_INCREMENT,
  `session_id` int NOT NULL DEFAULT '0',
  `msg_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `chat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `sent_by` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_user_id` int DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `media_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attachment_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`)
**
CRT_TBL|campaign_transfer_setting|`id` int(11) NOT NULL AUTO_INCREMENT,
  `disposition_campaign_trasfer` text COLLATE utf8mb4_bin,
  `sub_disposition_campaign_trasfer` text COLLATE utf8mb4_bin,
  `othr_field_campaign_trasfer` text COLLATE utf8mb4_bin,
  `othr_field_value_campaign_trasfer` text COLLATE utf8mb4_bin,
  `campaign_trasfer` int(11) DEFAULT NULL,
  `callback` int(11) DEFAULT NULL,
  `days` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `hours` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `minute` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `campaign_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|videocall_slot|`id` int(11) NOT NULL AUTO_INCREMENT,
  `fromtime` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `totime` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `inserted_by` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|fbforms|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `page_id` varchar(100) DEFAULT NULL,
  `page_name` varchar(100) DEFAULT NULL,
  `form_id` varchar(100) NOT NULL,
  `form_name` varchar(100) DEFAULT NULL,
  `form_status` varchar(20) DEFAULT NULL,
  `form_locale` varchar(50) DEFAULT NULL,
  `insert_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`form_id`) USING BTREE,
  KEY `id` (`id`)
**
CRT_TBL|fbforms_fields|`id` int(11) NOT NULL AUTO_INCREMENT,
  `form_id` varchar(100) DEFAULT NULL,
  `field_id` varchar(100) NOT NULL,
  `field_key` varchar(100) DEFAULT NULL,
  `field_label` varchar(100) DEFAULT NULL,
  `field_type` varchar(50) DEFAULT NULL,
  `insert_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`field_id`) USING BTREE,
  KEY `id` (`id`)
**
CRT_TBL|fbforms_fields_map|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `form_id` varchar(100) DEFAULT NULL,
  `page_id` varchar(100) DEFAULT NULL,
  `process_id` varchar(3) DEFAULT NULL,
  `campaign_id` varchar(3) DEFAULT NULL,
  `field_id` varchar(100) DEFAULT NULL,
  `field_key_fb` varchar(100) DEFAULT NULL,
  `field_key_process` varchar(50) DEFAULT NULL,
  `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  KEY `id` (`id`) USING BTREE
**
CRT_TBL|fbleads|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `json_data` text CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL,
  `inserted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|fbpages|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_Id` int(11) DEFAULT NULL,
  `page_name` varchar(100) DEFAULT NULL,
  `page_id` varchar(100) NOT NULL,
  `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`page_id`),
  KEY `id` (`id`)
**
CRT_TBL|feedback_urls|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `process_id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `log_id` int(11) NOT NULL,
  `master_id` int(11) NOT NULL,
  `phone_number` varchar(20) COLLATE utf8mb4_bin NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
**
CRT_TBL|video_call_connections|`id` bigint(11) NOT NULL AUTO_INCREMENT,
  `socket_id` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `ip_address` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `token` text CHARACTER SET latin1,
  `cr_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|agent_current_video_call|`id` int(11) NOT NULL AUTO_INCREMENT,
  `login_process_id` int(11) DEFAULT NULL,
  `login_campaign_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `session_id` int(11) DEFAULT NULL,
  `client_token` text,
  `client_sdpoffer` text,
  `agent_token` text,
  `agent_sdpoffer` text,
  `video_call_link` text,
  `recording_file_path` text,
  `last_active_time` datetime DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `cr_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|process_data_insert_rule|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` INT(11) UNSIGNED NOT NULL,
	`rule_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`display_order_data` VARCHAR(3) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`Default` INT(11) NULL DEFAULT NULL,
	`campaign` INT(11) NULL DEFAULT NULL,
	`rule_agent` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`assign_lead_login_agent` INT(11) NULL DEFAULT '0',
	`max_lead_per_day` INT(11) NULL DEFAULT '0',
	`agent_max_lead` INT(11) NULL DEFAULT '0',
	`round_robin` INT(1) NULL DEFAULT '0',
	`agent_condition` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`rule_condition` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|process_data_insert_rule_logic|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` INT(11) NULL DEFAULT NULL,
	`rule_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`othr_field_data_insert` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`othr_field_data_insert_value` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`display_order_data` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`condition` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`operator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|Data_insert_process|`process_id` INT(11) NULL DEFAULT NULL
**
CRT_TBL|process_attachment|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `master_id` INT(11) NULL DEFAULT '0',
	`map_id` INT(11) NULL DEFAULT '0',
	`attachment_path` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`attachment_desc` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`attachment_from` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `master_id` (`master_id`) USING BTREE,
	INDEX `map_id` (`map_id`) USING BTREE
**
CRT_TBL|omni_video_call_log|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `process_id` INT(11) NULL DEFAULT NULL,
	`omni_id` INT(11) NULL DEFAULT NULL,
	`master_id` INT(11) NULL DEFAULT NULL,
	`map_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`crm_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`caller_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`agent_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`channel` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`meeting_id` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`secret_id` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`topic` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`meeting_no` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`agent_link` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`customer_link` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`cancel_link` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`duration` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`sent_email` INT(11) NULL DEFAULT NULL,
	`sent_sms` INT(11) NULL DEFAULT NULL,
	`sent_whatsapp` INT(11) NULL DEFAULT NULL,
	`to_number` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`to_number_mask` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`from_mail_mask` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`from_mail` CHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`meeting_status` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`recording_saved` TINYINT(1) NULL DEFAULT '0',
	`agent_join_status` TINYINT(1) NULL DEFAULT '0',
	`customer_join_status` TINYINT(1) NULL DEFAULT '0',
	`recording_url` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`cr_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|letter_schedule|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `process_id` INT(3) NOT NULL,
	`master_id` INT(3) NULL DEFAULT NULL,
	`email_account_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`phone_no` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`emailTo` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`emailBcc` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`emailCc` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`subject` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`Emailbody` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`letter_sms_body` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`letter_sms_temlpate` INT(11) NULL DEFAULT NULL,
	`letter_email_temlpate` INT(11) NULL DEFAULT NULL,
	`schedule_time` DATETIME NOT NULL,
	`whatsapp` INT(3) NOT NULL,
	`email` INT(3) NOT NULL,
	`whatsappSent` INT(3) NOT NULL DEFAULT '0',
	`emailSent` INT(3) NOT NULL DEFAULT '0',
	`Master_data` TEXT NOT NULL COLLATE 'latin1_swedish_ci',
	`letter_template` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
	`letter_schedule_at` DATETIME NULL DEFAULT NULL,
	`status` INT(1) NOT NULL DEFAULT '0',
	`added_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|chatbotResponce|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `process_id` INT(11) NULL DEFAULT NULL,
	`message_id` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|video_call_connections|`id` INT(11) NOT NULL AUTO_INCREMENT,
  `socket_id` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `ip_address` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `token` text CHARACTER SET latin1,
  `cr_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|video_events|`data` text,
  `inserted_at` datetime DEFAULT CURRENT_TIMESTAMP
**
CRT_TBL|process_data_insert_rule|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) unsigned NOT NULL,
  `rule_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `display_order_data` varchar(3) COLLATE utf8mb4_bin DEFAULT NULL,
  `Default` int(11) DEFAULT NULL,
  `campaign` int(11) DEFAULT NULL,
  `rule_agent` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `assign_lead_login_agent` int(11) DEFAULT '0',
  `max_lead_per_day` int(11) DEFAULT '0',
  `agent_max_lead` int(11) DEFAULT '0',
  `round_robin` int(1) DEFAULT '0',
  `agent_condition` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
  `rule_condition` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
  `lead_by_campaign` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|process_data_insert_rule_logic|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) DEFAULT NULL,
  `rule_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `othr_field_data_insert` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
  `othr_field_data_insert_value` text COLLATE utf8mb4_bin,
  `display_order_data` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `condition` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `operator` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|process_smssetting|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(5) DEFAULT NULL,
  `disposition` varchar(70) DEFAULT NULL,
  `other_fld` text,
  `other_fld_val` text,
  `email` varchar(150) DEFAULT NULL,
  `template` int(5) DEFAULT NULL,
  `default_no` varchar(70) DEFAULT NULL,
  `other_no` varchar(70) DEFAULT NULL,
  `sms` tinyint(1) DEFAULT NULL,
  `whatsapp` tinyint(1) DEFAULT NULL,
  `send_to_client` tinyint(1) DEFAULT NULL,
  `send_to_branch` tinyint(1) DEFAULT NULL,
  `admin_send` tinyint(1) DEFAULT NULL,
  `send_to_assign_agent` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ProcSMSSetProc` (`process_id`),
  KEY `ProcSMSSetDispo` (`disposition`)
**
CRT_TBL|process_emailsetting|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(11) DEFAULT NULL,
  `disposition` varchar(70) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `other_fld` text,
  `other_fld_val` text,
  `template` int(11) DEFAULT NULL,
  `default_email` varchar(70) DEFAULT NULL,
  `other_email` varchar(70) DEFAULT NULL,
  `send_to_client` tinyint(1) DEFAULT NULL,
  `send_to_branch` tinyint(1) DEFAULT NULL,
  `send_to_assign_agent` tinyint(1) DEFAULT NULL,
  `admin_send` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IndexProcEmailSetting` (`process_id`,`disposition`) USING BTREE,
  KEY `ProcEmailSetDispo` (`disposition`),
  KEY `ProcEmailSetProc` (`process_id`)
**
CRT_TBL|video_details|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `video_id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `title` text COLLATE utf8mb4_bin NOT NULL,
  `description` text COLLATE utf8mb4_bin,
  `published_at` datetime DEFAULT NULL,
  `thumbnail_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`video_id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
**
CRT_TBL|comment_details|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `video_id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `author_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `comment_text` text COLLATE utf8mb4_bin NOT NULL,
  `published_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `comment_details_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `video_details` (`video_id`)
**
CRT_TBL|whatsapp_provider|`id` int(11) NOT NULL AUTO_INCREMENT,
  `provider_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `insert_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
**
CRT_TBL|businesstemplate|`id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  `provider_name` varchar(70) COLLATE utf8mb4_bin NOT NULL,
  `provider_template` text COLLATE utf8mb4_bin NOT NULL,
  `provider_template_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `created_by` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `updated_by` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
**
CRT_TBL|country_master|`id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
**
ADD_CLM|country_master|active|TINYINT|2|Y|0|phonecode
**
QRY|INSERT INTO `country_master` (`iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`, `active`) VALUES
	('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93, 1),
	('AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61, 1),
	('BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55, 1),
	('CA', 'CANADA', 'Canada', 'CAN', 124, 1, 1),
	('CN', 'CHINA', 'China', 'CHN', 156, 86, 1),
	('FR', 'FRANCE', 'France', 'FRA', 250, 33, 1),
	('DE', 'GERMANY', 'Germany', 'DEU', 276, 49, 1),
	('IN', 'INDIA', 'India', 'IND', 356, 91, 1),
	('IT', 'ITALY', 'Italy', 'ITA', 380, 39, 1),
	('JP', 'JAPAN', 'Japan', 'JPN', 392, 81, 1),
	('KE', 'KENYA', 'Kenya', 'KEN', 404, 254, 1),
	('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60, 1),
	('MX', 'MEXICO', 'Mexico', 'MEX', 484, 52, 1),
	('NP', 'NEPAL', 'Nepal', 'NPL', 524, 977, 1),
	('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64, 1),
	('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27, 1),
	('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94, 1),
	('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268, 1),
	('TH', 'THAILAND', 'Thailand', 'THA', 764, 66, 1),
	('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44, 1),
	('US', 'UNITED STATES', 'United States', 'USA', 840, 1, 1);
**
CRT_TBL|export_data_csv|`id` int(11) NOT NULL AUTO_INCREMENT,
  `customSQL` text COLLATE utf8mb4_bin,
  `user_id` varchar(3) COLLATE utf8mb4_bin DEFAULT NULL,
  `class` varchar(15) COLLATE utf8mb4_bin DEFAULT NULL,
  `report_type` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `inserted_on` datetime DEFAULT CURRENT_TIMESTAMP,
  `completed_on` datetime DEFAULT NULL,
  `file_path` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `is_export` int(11) DEFAULT '0',
  `is_prosesed` int(11) DEFAULT '0',
  `reason` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
  PRIMARY KEY (`id`)
**
CRT_TBL|after_disposed|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` int(5) DEFAULT NULL,
  `campaign_id` int(5) DEFAULT NULL,
  `log_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `api_call_status` bit(1) DEFAULT NULL,
  `api_response_status` bit(1) DEFAULT NULL,
  `url` text CHARACTER SET latin1,
  `api_method` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `postData` text CHARACTER SET latin1,
  `response_from_api` text CHARACTER SET latin1,
  `Updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|call_logic_data|`id` int(11) NOT NULL AUTO_INCREMENT,
  `process_id` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `campaign_id` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `mobile_no` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `per_day_count` int(11) DEFAULT '0',
  `per_week_count` int(11) DEFAULT '0',
  `last_update` datetime DEFAULT NULL,
  `total_attempt` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|country_master|`id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
**
QRY|INSERT INTO `country_master` (`iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`, `active`) VALUES ('IN', 'INDIA', 'India', 'IND', 356, 91, 1);
**
CRT_TBL|otp_request_logs|`id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) NOT NULL,
  `request_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
**
CRT_TBL|qa_audit_master| `id` INT NOT NULL AUTO_INCREMENT,
	`client_id` INT NULL DEFAULT NULL,
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`qa_setup_id` INT NULL DEFAULT NULL,
	`ftr_status` VARCHAR(10) NULL DEFAULT NULL,
	`log_id` INT NULL DEFAULT NULL,
	`parent_id` INT NULL DEFAULT NULL,
	`log_phone_no` VARCHAR(50) NULL DEFAULT NULL,
	`agent_id` INT NULL DEFAULT NULL,
	`agent_name` VARCHAR(50) NULL DEFAULT NULL,
	`auditor_id` INT NULL DEFAULT NULL,
	`auditor_name` VARCHAR(50) NULL DEFAULT NULL,
	`emp_id` VARCHAR(50) NULL DEFAULT NULL,
	`date_of_call` DATETIME NULL DEFAULT NULL,
	`date_of_audit` DATETIME NULL DEFAULT NULL,
	`no_of_call_rec` INT NULL DEFAULT NULL,
	`call_duration` VARCHAR(50) NULL DEFAULT NULL,
	`qa_disposition_id` INT NULL DEFAULT NULL,
	`external_performance` DECIMAL(6,2) NULL DEFAULT NULL,
	`internal_performance` DECIMAL(6,2) NULL DEFAULT NULL,
	`fatal_error_call` DECIMAL(6,2) NULL DEFAULT NULL,
	`call_summary` TEXT NULL DEFAULT NULL,
	`area_of_strength` TEXT NULL DEFAULT NULL,
	`area_of_development` TEXT NULL DEFAULT NULL,
	`remark` TEXT NULL DEFAULT NULL,
	`feedback` TEXT NULL DEFAULT NULL,
	`decline_state` TINYINT NULL DEFAULT NULL,
	`feedback_datetime` DATETIME NULL DEFAULT NULL,
	`agent_sentiment` VARCHAR(50) NULL DEFAULT NULL,
	`customer_sentiment` VARCHAR(50) NULL DEFAULT NULL,
  `disposition` VARCHAR(50) NULL DEFAULT NULL,
  `sub_disposition` VARCHAR(50) NULL DEFAULT NULL,
	`created_date` DATETIME NULL DEFAULT (now()),
	`created_by` INT NULL DEFAULT NULL,
	`updated_date` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
	`updated_by` INT NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
CRT_TBL|qa_audit_question_result| `id` INT NOT NULL AUTO_INCREMENT,
	`qa_audit_id` INT NULL DEFAULT NULL,
	`parameter_id` INT NULL DEFAULT NULL,
	`parameter_name` TEXT NULL DEFAULT NULL,
	`status` VARCHAR(50) NULL DEFAULT NULL,
	`question_id` INT NULL DEFAULT NULL,
	`question` TEXT NULL DEFAULT NULL,
	`rating` VARCHAR(10) NULL DEFAULT NULL,
	`weightage` DECIMAL(10,2) NULL DEFAULT '0.00',
	`applicable_weightage` DECIMAL(10,2) NULL DEFAULT '0.00',
	`agent_grade` DECIMAL(10,2) NULL DEFAULT '0.00',
	`qa_comment` TEXT NULL DEFAULT NULL,
	`created_by` INT NULL DEFAULT NULL,
	`created_date` DATETIME NULL DEFAULT (now()),
	PRIMARY KEY (`id`)
**
CRT_TBL|qa_assign_log| `id` INT NOT NULL AUTO_INCREMENT,
	`log_id` INT NULL DEFAULT NULL,
	`manager` INT NULL DEFAULT NULL,
	`assign_to` INT NULL DEFAULT NULL,
	`assign_date` DATETIME NULL DEFAULT (now()),
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`assign_by` INT NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
CRT_TBL|qa_processquestion_disposition_setup| `id` INT NOT NULL AUTO_INCREMENT,
  `setup_id` int NOT NULL,
  `disposition_id` int DEFAULT NULL,
  `sub_disposition` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `percentage` double(5,2) DEFAULT '0.00',
  `duration` varchar(50) COLLATE utf8mb4_bin DEFAULT '00:00',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT (now()),
	PRIMARY KEY (`id`)
**
CRT_TBL|qa_processquestion_question_setup| `id` INT NOT NULL AUTO_INCREMENT,
	`setup_id` INT NULL DEFAULT NULL,
	`display_order` INT NULL DEFAULT NULL,
	`parameter_id` INT NULL DEFAULT NULL,
	`status` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`question_id` INT NULL DEFAULT NULL,
	`question_suggestion` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`weightage` DECIMAL(5,2) NULL DEFAULT '0.00',
	`created_by` INT NULL DEFAULT NULL,
	`created_date` DATE NULL DEFAULT (now()),
	PRIMARY KEY (`id`)
**
CRT_TBL|qa_processquestion_setup| `id` INT NOT NULL AUTO_INCREMENT,
	`client_id` INT NULL DEFAULT NULL,
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`date` DATE NULL DEFAULT NULL,
	`re_audit` TINYINT(1) NULL DEFAULT '0',
	`auto_assign` TINYINT(1) NULL DEFAULT '0',
	`send_notification_to_agent_after_audit` TINYINT(1) NULL DEFAULT '0',
	`assign_type` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`ftp_username` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`ftp_password` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`service_time` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`ftp_port` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`ftp_hostname` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`api_url` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`api_token` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`api_key` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`enable_ftp` TINYINT NULL DEFAULT '0',
	`enable_api` TINYINT NULL DEFAULT '0',
	`api_generate_token_url` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`recording_folder_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
  `meta_data_api_url` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`bot_agent_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`created_by` INT NULL DEFAULT NULL,
	`created_date` DATETIME NULL DEFAULT (now()),
	`updated_by` INT NULL DEFAULT NULL,
	`updated_date` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
**
CRT_TBL|upload_recording_logs| `id` INT NOT NULL AUTO_INCREMENT,
	`upload_type` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`client_id` INT NULL DEFAULT NULL,
	`agent_id` INT NULL DEFAULT NULL,
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`log_id` INT NULL DEFAULT NULL,
	`rec_file` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`response` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`cr_date` DATETIME NULL DEFAULT (now()),
	PRIMARY KEY (`id`)
**
  CRT_TBL|login_attempts| `username`  VARCHAR(100) NOT NULL COLLATE 'utf8mb4_0900_ai_ci',
	`attempts` INT NULL DEFAULT '0',
	`last_attempt` DATETIME NULL DEFAULT NULL,
	PRIMARY KEY (`username`)
**
  CRT_TBL|qa_call_transcript| `id` INT NOT NULL AUTO_INCREMENT,
	`audit_id` INT NULL DEFAULT NULL,
	`log_id` INT NULL DEFAULT NULL,
  `transcript_data` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
  `cr_date` DATETIME NULL DEFAULT (now()),
	PRIMARY KEY (`id`)
**
  CRT_TBL|qa_ai_audit_response_log| `id` INT NOT NULL AUTO_INCREMENT,
  `process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`log_id` INT NULL DEFAULT NULL,
	`processed_status` TINYINT NULL DEFAULT '0',
	`rec_file` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`response` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`cr_date` DATETIME NULL DEFAULT (now()),
	PRIMARY KEY (`id`)
**
  CRT_TBL|crm_google_setup| `id` INT NOT NULL AUTO_INCREMENT,
  `process_id` INT NULL DEFAULT NULL,
	`client_id` INT NULL DEFAULT NULL,
	`status` INT NULL DEFAULT NULL,
	`credentials` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`token` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
  `created_at` DATETIME NULL DEFAULT (now()),
	`updated_at` DATETIME NULL DEFAULT NULL,
	`created_by` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`updated_by` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	PRIMARY KEY (`id`)
**
  CRT_TBL|client_fresh_lead_log| `id` INT NOT NULL AUTO_INCREMENT,
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`api_url` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`api_type` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`payload` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`api_responce` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`created_at` DATETIME NULL DEFAULT NULL,
	`status` INT NULL DEFAULT NULL,
	`execution_time` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`)
**
  CRT_TBL|qa_ai_auto_upload_service_log| `id` INT NOT NULL AUTO_INCREMENT,
  `qa_setup_id` INT NULL DEFAULT NULL,
	`client_id` INT NULL DEFAULT NULL,
	`log_id` INT NULL DEFAULT NULL,
	`process_id` INT NULL DEFAULT NULL,
	`campaign_id` INT NULL DEFAULT NULL,
	`is_manual` TINYINT NULL DEFAULT '0',
	`upload_status` TINYINT NULL DEFAULT '0',
	`processed_status` TINYINT NULL DEFAULT '0',
	`rec_file` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`response` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`cr_date` DATETIME NULL DEFAULT (now()),
	`md_date` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
**
CRT_TBL|cron_scheduler|`id` INT NOT NULL AUTO_INCREMENT,
	`is_active` INT NOT NULL DEFAULT '0',
	`Cron` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`url` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`Desc` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`create_by` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`modified_by` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`created_on` TIMESTAMP NULL DEFAULT (CURRENT_TIMESTAMP),
	`modified_on` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
**
CRT_TBL|addCdrData_log| `unique_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `linked_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `trunk_channel` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `exten` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `caller_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `call_type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `did` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `start_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `acd_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `exten_ring_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `exten_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `exten_ans_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `end_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `acd` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `cause` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `agent_disconnect` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `out_call_type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `dtmf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `process_id` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `campaign_id` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `mapid` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `userfield` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `hold_duration` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `call_hangup_reason` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `duration` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `billsec` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `recording_file` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `end_call` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `disposition` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `ivr_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `crmid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `inserted_on` datetime DEFAULT NULL