CREATE TABLE `autodialer_job` (
  `job_id` int NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `job_name` varchar(64) NOT NULL default '' COMMENT '关键名称',
  `destination_dialplan` varchar(64) NOT NULL default 'XML' COMMENT '暂时默认XML',
  `enable` enum('true','false') NOT NULL default 'true' COMMENT '关键名称',
  `line_group`  int NOT NULL COMMENT '线路组id',
  `start_time`  int NOT NULL COMMENT '开始时间',
  `stop_time`   int NOT NULL COMMENT '停止时间',
  `work_hour_id`int NOT NULL COMMENT '工作时间id',
  `work_week`int NOT NULL COMMENT    '工作天',
  `number_queue`int NOT NULL COMMENT '队列号码redis的key',
  `destination_extension`int NOT NULL COMMENT '话术的id',
  `destination_context`varchar(64) NOT NULL default 'robot' COMMENT '话术路由',
  `limit`int NOT NULL COMMENT '并发数',
  `seat` int NOT NULL default 0 COMMENT '坐席id',
  `call_multiple`int NOT NULL default 0 COMMENT '呼叫倍数',
  `queue_limit` decimal(3,2) NOT NULL default 0.00 COMMENT '呼叫限制',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  PRIMARY KEY (`job_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `speech_id` (`speech_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='任务表';



CREATE TABLE cdr (
    uuid VARCHAR(50) ,
    channel VARCHAR(100) ,
    account VARCHAR(50) ,
    direction VARCHAR(50) ,
    destination_number VARCHAR(50),
    caller_id_number VARCHAR(50) ,
    callee_id_number VARCHAR(50) ,
    direction VARCHAR(50) ,
    sip_term_status VARCHAR(50) ,
    hangup_cause VARCHAR(100) ,
    sip_hangup_disposition VARCHAR(50) ,
    network_addr VARCHAR(50) ,
    created_time DATETIME ,
    answered_time DATETIME ,
    hungup_time  DATETIME ,
    billsec INT ,
    duration INT ,
    rtp_last_audio_codec_string VARCHAR(50) ,
    record_filename VARCHAR(256) ,
    details TEXT,
    PRIMARY KEY (`uuid`),
    KEY `created_time` (`created_time`),
    KEY `answered_time` (`answered_time`),
    KEY `answered_time` (`answered_time`),
    KEY `caller_id_number` (`caller_id_number`),
    KEY `callee_id_number` (`callee_id_number`)
)ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='号码记录';