master

分支 (1)

管理

管理

master

robotphp
/
sql
/
1_8.sql

CREATE TABLE `autodialer_examine_speech_asr` (
  `asr_id` int NOT NULL AUTO_INCREMENT COMMENT 'asr设置',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `interrupt` int NOT NULL COMMENT '打断值',
  `vad_value` enum('0','2') NOT NULL COMMENT 'vad值',
  `noise` decimal(2,1) NOT NULL DEFAULT '0.1' COMMENT '滤噪',
  `start` int NOT NULL DEFAULT '120' COMMENT '开始',
  `end` int NOT NULL DEFAULT '800' COMMENT '停止',
  `waiting` int NOT NULL DEFAULT '3000' COMMENT '等待',
  `max` int NOT NULL DEFAULT '15000' COMMENT '最大',
  `recording` enum('0','1','2') NOT NULL DEFAULT '1' COMMENT '录音值0:不录音，1：检测到声音开始录音，2：全部录音',
  `path` varchar(64) NOT NULL DEFAULT '' COMMENT '地址',
  `format` enum('mp3','wav') NOT NULL DEFAULT 'wav' COMMENT '音频格式',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`asr_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核asr参数设置表';


CREATE TABLE `autodialer_examine_speech_condition_rule` (
  `scr_id` int NOT NULL AUTO_INCREMENT COMMENT '规则选择的条件表id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `symbol` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '符号',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '符号对应的值',
  `user_id` int NOT NULL COMMENT '用户id创建者',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `sr_id` int NOT NULL COMMENT '意向标签规则id',
  `sc_id` int NOT NULL COMMENT '意向标签条件id',
  `name` varchar(100) DEFAULT NULL,
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`scr_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`),
  KEY `sr_id_key` (`sr_id`),
  KEY `sc_id_key` (`sc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核规则选择的条件表';


CREATE TABLE `autodialer_examine_speech_hot_word` (
  `hw_id` int NOT NULL AUTO_INCREMENT COMMENT '热词id',
  `sort` int NOT NULL DEFAULT '1' COMMENT '权重',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '热词名',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int DEFAULT NULL COMMENT '删除时间',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`hw_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核热词表';


CREATE TABLE `autodialer_examine_speech_label_synonym` (
  `sls_id` int NOT NULL AUTO_INCREMENT COMMENT '关键词',
  `sls_name` varchar(64) NOT NULL DEFAULT '' COMMENT '关键名称',
  `sls_keyword` enum('yes','no','any','reject') NOT NULL DEFAULT 'yes' COMMENT '关键分组默认是yes：肯定，no:否定，any：默认，reject:拒绝',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `node_id` int NOT NULL COMMENT '大节点id',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `delete_time` int DEFAULT '0',
  `node_ids` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`sls_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `speech_id` (`speech_id`),
  KEY `process_id` (`process_id`),
  KEY `node_id` (`node_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7645 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核关键词话术';


CREATE TABLE `autodialer_examine_speech_node_wav` (
  `snw_id` int NOT NULL AUTO_INCREMENT COMMENT '关系id',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `is_real` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1:未录音，2：上传录音',
  `upload_time` int NOT NULL DEFAULT '0' COMMENT '上传时间',
  `upload_id` int NOT NULL DEFAULT '0' COMMENT '上传用户',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `node_id` int DEFAULT NULL COMMENT '节点id',
  `content` varchar(255) NOT NULL COMMENT '节点内容',
  `upload_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上传地址',
   `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`snw_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `upload_time` (`upload_time`),
  KEY `user_id` (`user_id`),
  KEY `upload_id` (`upload_id`),
  KEY `speech_id` (`speech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核流程节点音频表';


CREATE TABLE `autodialer_examine_speech_process` (
  `process_id` int NOT NULL AUTO_INCREMENT COMMENT '流程ID',
  `sort` int NOT NULL DEFAULT '1' COMMENT '话术顺序',
  `process_name` varchar(64) NOT NULL COMMENT '流程名字',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `delete_time` int DEFAULT NULL COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术流程表';


CREATE TABLE `autodialer_examine_speech_process_node` (
  `node_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `info_title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '话术节点名称',
  `node_x` int NOT NULL COMMENT 'x轴',
  `node_y` int NOT NULL COMMENT 'y轴',
  `node_z_index` int NOT NULL COMMENT 'z层级',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `info_talk_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点话术信息',
  `switch_rule` enum('1','2') NOT NULL DEFAULT '1' COMMENT '切换规则1：顺序，2：系统时间',
  `talk_paramter` enum('1','2') NOT NULL DEFAULT '1' COMMENT '对话变量赋值1：开启，2：关闭',
  `talk_node` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启回答分支',
  `other_setting` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启其它设置',
  `talk_label` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启标签',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `node_type` varchar(32) NOT NULL DEFAULT '' COMMENT '话术类型',
  `user_id` int NOT NULL COMMENT '用户id',
  `node_ids` varchar(60) NOT NULL COMMENT '节点唯一id',
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `children` varchar(255) DEFAULT NULL COMMENT '子节点',
  `type_id` tinyint DEFAULT NULL COMMENT '1：普通节点，2：跳转节点:3：按键采集节点，IVR节点，条件判断节点，信息查询节点',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `active` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1：表示true,2:表示false',
  `next` enum('1','2','3','0') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '跳转节点存在1：挂机，2：跳转下一步，3：跳转指定流程,0是普通节点',
  `next_id` int DEFAULT '0' COMMENT '跳转到指定的流程id',
  `lab_id` int DEFAULT '0' COMMENT '标签',
  `node_data` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'nodeData的json 的 param数据',
  `node_all` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'nodeData里面的数据',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`node_id`) USING BTREE,
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2118 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术流程节点信息表';


CREATE TABLE `autodialer_examine_speech_process_node_children` (
  `children_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_x` int NOT NULL COMMENT 'x轴',
  `node_y` int NOT NULL COMMENT 'y轴',
  `node_z_index` int NOT NULL COMMENT 'z层级',
  `node_ids` varchar(60) NOT NULL COMMENT '节点唯一id',
  `label` varchar(64) NOT NULL COMMENT '字节点描述',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`children_id`),
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3688 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术子节点';


CREATE TABLE `autodialer_examine_speech_process_node_line` (
  `line_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `source` varchar(64) NOT NULL COMMENT '源连节点',
  `target` varchar(64) NOT NULL COMMENT '目标节点',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `stroke` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '颜色',
  `zIndex` int NOT NULL,
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`line_id`),
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1915 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术流程线表（为了父子关系）';


CREATE TABLE `autodialer_examine_speech_process_node_relation` (
  `relation_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_id` int NOT NULL COMMENT '大节点id',
  `parent_id` int NOT NULL COMMENT '大节点的父节点ID',
  `source` varchar(64) NOT NULL COMMENT '源连节点',
  `target` varchar(64) NOT NULL COMMENT '目标节点',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`relation_id`),
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2299 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核节点（大节点的关系不包括小的节点）';


CREATE TABLE `autodialer_examine_speech_process_node_setting` (
  `set_id` int NOT NULL AUTO_INCREMENT COMMENT '其它设置ID',
  `set_key` varchar(30) NOT NULL COMMENT '其它设置名称',
  `set_value` text NOT NULL COMMENT '其它设置值',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `node_id` int NOT NULL COMMENT '节点ID',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '话术流程节点信息表ID',
  `desc` varchar(64) DEFAULT NULL COMMENT '详情',
  `delete_time` int DEFAULT '0' COMMENT '删除id',
   `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`set_id`),
  KEY `process_id_key` (`process_id`),
  KEY `node_id_key` (`node_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`),
  KEY `info_id_key` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1361 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术流程的其他设置表';


CREATE TABLE `autodialer_examine_speech_process_node_tree` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '节点ID(树节点)',
  `parent_id` int NOT NULL COMMENT '父ID',
  `lft` int NOT NULL DEFAULT '0' COMMENT '左节点',
  `rgt` int NOT NULL DEFAULT '0' COMMENT '右节点',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL COMMENT '用户id',
  `node_id` int NOT NULL,
  `level` tinyint NOT NULL DEFAULT '0' COMMENT '层级',
  `node_tree_id` int NOT NULL COMMENT '树节点',
  `delete_time` enum('0','1') DEFAULT '0',
  `nodes_id` varchar(60) DEFAULT NULL COMMENT '上一个父子节点的子节点',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=961 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术流程节点tree表';


CREATE TABLE `autodialer_examine_speech_process_small_node_relation` (
  `psnr_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_id` int NOT NULL COMMENT '大节点id',
  `big_node_id` varchar(60) NOT NULL DEFAULT '0' COMMENT '大节点的ID',
  `small_node_id` varchar(60) NOT NULL DEFAULT '0' COMMENT '小节点的ID',
  `process_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`psnr_id`),
  KEY `process_id_key` (`process_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3671 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核大小节点的关系';


CREATE TABLE `autodialer_examine_speech_rule` (
  `sr_id` int NOT NULL AUTO_INCREMENT COMMENT '意向标签规则',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL COMMENT '用户id创建者',
  `lab_id` int NOT NULL COMMENT '标签id',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `count` int DEFAULT '0' COMMENT '匹配次数',
  `name` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '规则名称',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`sr_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`),
  KEY `lab_id_key` (`lab_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核意向标签规则表';


CREATE TABLE `autodialer_examine_speech_tech_wav` (
  `stw_id` int NOT NULL AUTO_INCREMENT COMMENT '关系id',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `is_real` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1:未录音，2：已录音',
  `upload_time` int NOT NULL DEFAULT '0' COMMENT '上传时间',
  `upload_id` int NOT NULL DEFAULT '0' COMMENT '上传用户',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `upload_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '录音地址',
  `tech_id` int DEFAULT NULL COMMENT '知识库节点',
  `content` varchar(255) NOT NULL COMMENT '节点内容',
  `as_id` int DEFAULT NULL COMMENT '回答内容id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`stw_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `upload_time` (`upload_time`),
  KEY `user_id` (`user_id`),
  KEY `upload_id` (`upload_id`),
  KEY `speech_id` (`speech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库声音表';


CREATE TABLE `autodialer_examine_speech_technology_answer` (
  `as_id` int NOT NULL AUTO_INCREMENT COMMENT '关键词ID',
  `answer_content` text NOT NULL COMMENT '回答内容',
  `answer_go` enum('0','1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '3' COMMENT '回答后0：挂机，1：等待用户应答，2：跳转到指定主流程,3:就是不跳转',
  `process_id` int DEFAULT NULL COMMENT '话术流程ID：answer_go=2的时候才会有这个流程ID',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `tech_id` int NOT NULL COMMENT '知识库分组表ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `sort` tinyint DEFAULT '1' COMMENT '顺序',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`as_id`),
  KEY `tech_id_key` (`tech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库列表回答内容表';


CREATE TABLE `autodialer_examine_speech_technology_answer_mul_process` (
  `as_id` int NOT NULL AUTO_INCREMENT COMMENT '关键词ID',
  `process_mul_id` int NOT NULL COMMENT '多伦会话id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `tech_id` int NOT NULL COMMENT '知识库分组表ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`as_id`),
  KEY `tech_id_key` (`tech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库列表回答多伦会话表';

CREATE TABLE `autodialer_examine_speech_technology_category` (
  `cate_id` int NOT NULL AUTO_INCREMENT COMMENT '知识库分组ID',
  `cate_name` varchar(30) NOT NULL COMMENT '知识库分组名称',
  `is_default` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否是默认分组1：是默认分组，2：不是默认分组',
  `talk_temp_id` int NOT NULL DEFAULT '0' COMMENT '话术模板ID',
  `admin_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `classify_id` int DEFAULT '0' COMMENT '场景id',
  `parent_id` int DEFAULT '0' COMMENT '父id',
  `check` enum('1','2') DEFAULT '1',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`cate_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库分组表(一级)';


CREATE TABLE `autodialer_examine_speech_technology_category_info` (
  `tech_id` int NOT NULL AUTO_INCREMENT COMMENT '知识库信息ID',
  `tech_name` varchar(30) NOT NULL COMMENT '知识库信息标准问题',
  `tech_paramters` enum('1','2') NOT NULL DEFAULT '1' COMMENT '对话变量赋值1：关闭，2：开启',
  `tech_answer_method` enum('1','2') NOT NULL DEFAULT '1' COMMENT '回答方式1：单句回答，2：进入多伦会话',
  `tech_switch_method` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '切换方式1：顺序，2：系统时间3：多伦会话',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `cate_id` int DEFAULT '0' COMMENT '分组id',
  `type` enum('1','2') DEFAULT '1' COMMENT '类型（业务类型）1：一般问题，2：业务问题',
  `key_number` int DEFAULT '0' COMMENT '关键词数量',
  `label_id` int DEFAULT '0' COMMENT '意向id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`tech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库列表';

CREATE TABLE `autodialer_examine_speech_technology_keyword` (
  `kw_id` int NOT NULL AUTO_INCREMENT COMMENT '关键词ID',
  `kw_name` varchar(30) NOT NULL COMMENT '其它设置名称',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `tech_id` int NOT NULL COMMENT '知识库分组表ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`kw_id`),
  KEY `tech_id_key` (`tech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库列表关键词';


CREATE TABLE `autodialer_examine_speech_technology_setting` (
  `set_id` int NOT NULL AUTO_INCREMENT COMMENT '其它设置ID',
  `set_key` varchar(30) NOT NULL COMMENT '其它设置名称',
  `set_value` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '其它设置值',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `tech_id` int NOT NULL COMMENT '知识库分组表ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`set_id`),
  KEY `tech_id_key` (`tech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核知识库分组表其他设置表';


CREATE TABLE `autodialer_examine_speech_tts` (
  `stt_id` int NOT NULL AUTO_INCREMENT COMMENT 'tts的id',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `vcn` varchar(20) NOT NULL COMMENT '发话人',
  `speed` int NOT NULL COMMENT '语速',
  `volume` int NOT NULL COMMENT '声音',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `man` enum('1','2') DEFAULT '2' COMMENT '1：真人2：合成音',
  `tts_type` enum('xf','ali','bb') DEFAULT 'ali',
  `pitch` int DEFAULT '0' COMMENT '语调',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`stt_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `user_id` (`user_id`),
  KEY `speech_id` (`speech_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核话术默认tts设置表';


CREATE TABLE `autodialer_examine_speech_mul_process` (
  `process_mul_id` int NOT NULL AUTO_INCREMENT COMMENT '流程ID',
  `sort` int NOT NULL DEFAULT '1' COMMENT '话术顺序',
  `process_name` varchar(64) NOT NULL COMMENT '流程名字',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `delete_time` int DEFAULT NULL COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`process_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话话术流程表';


CREATE TABLE `autodialer_examine_speech_mul_process_node` (
  `node_mul_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `info_title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '话术节点名称',
  `node_x` int NOT NULL COMMENT 'x轴',
  `node_y` int NOT NULL COMMENT 'y轴',
  `node_z_index` int NOT NULL COMMENT 'z层级',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `info_talk_info` varchar(255) NOT NULL COMMENT '节点话术信息',
  `switch_rule` enum('1','2') NOT NULL DEFAULT '1' COMMENT '切换规则1：顺序，2：系统时间',
  `talk_paramter` enum('1','2') NOT NULL DEFAULT '1' COMMENT '对话变量赋值1：开启，2：关闭',
  `talk_node` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启回答分支',
  `other_setting` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启其它设置',
  `talk_label` enum('1','2') NOT NULL DEFAULT '1' COMMENT '是否开启标签',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `node_type` varchar(32) NOT NULL DEFAULT '' COMMENT '话术类型',
  `user_id` int NOT NULL COMMENT '用户id',
  `node_ids` varchar(60) NOT NULL COMMENT '节点唯一id',
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `children` varchar(255) DEFAULT NULL COMMENT '子节点',
  `type_id` tinyint DEFAULT NULL COMMENT '1：普通节点，2：跳转节点:3：按键采集节点，IVR节点，条件判断节点，信息查询节点',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `active` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1：表示true,2:表示false',
  `next` enum('1','2','3','0') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '跳转节点存在1：挂机，2：跳转下一步，3：跳转指定流程,0:普通接点',
  `next_id` int DEFAULT '0' COMMENT '3:跳转到指定流程的id',
  `lab_id` int DEFAULT '0' COMMENT '标签id',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`node_mul_id`) USING BTREE,
  KEY `process_mul_id` (`process_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=349 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话话术流程节点信息表';

CREATE TABLE `autodialer_examine_speech_mul_process_node_children` (
  `children_mul_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_x` varchar(15) NOT NULL COMMENT 'x轴',
  `node_y` varchar(15) NOT NULL COMMENT 'y轴',
  `node_z_index` varchar(15) NOT NULL COMMENT 'z层级',
  `node_ids` varchar(60) NOT NULL COMMENT '节点唯一id',
  `label` varchar(64) NOT NULL COMMENT '字节点描述',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
   `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`children_mul_id`),
  KEY `process_mul_id_key` (`process_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话话术子节点';


CREATE TABLE `autodialer_examine_speech_mul_process_node_line` (
  `line_mul_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `source` varchar(64) NOT NULL COMMENT '源连节点',
  `target` varchar(64) NOT NULL COMMENT '目标节点',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`line_mul_id`),
  KEY `process_mul_id` (`process_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话话术流程线表';

CREATE TABLE `autodialer_examine_speech_mul_process_node_relation` (
  `relation_mul_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_mul_id` int NOT NULL COMMENT '大节点id',
  `parent_id` int NOT NULL COMMENT '大节点的父节点ID',
  `source` varchar(64) NOT NULL COMMENT '源连节点',
  `target` varchar(64) NOT NULL COMMENT '目标节点',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`relation_mul_id`),
  KEY `process_mul_id_key` (`process_mul_id`),
  KEY `node_mul_id_key` (`node_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话节点（大节点的关系不包括小的节点）';

CREATE TABLE `autodialer_examine_speech_mul_process_node_tree` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '节点ID(树节点)',
  `parent_id` int NOT NULL COMMENT '父ID',
  `lft` int NOT NULL DEFAULT '0' COMMENT '左节点',
  `rgt` int NOT NULL DEFAULT '0' COMMENT '右节点',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `user_id` int NOT NULL COMMENT '用户id',
  `node_mul_id` int NOT NULL,
  `level` tinyint NOT NULL DEFAULT '0' COMMENT '层级',
  `node_tree_id` int NOT NULL COMMENT '树节点',
  `delete_time` enum('0','1') DEFAULT '0',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `process_mul_id_key` (`process_mul_id`),
  KEY `node_mul_id_key` (`node_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话话术流程节点tree表';


CREATE TABLE `autodialer_examine_speech_mul_process_small_node_relation` (
  `psnr_id` int NOT NULL AUTO_INCREMENT COMMENT '话术流程信息ID',
  `node_mul_id` int NOT NULL COMMENT '大节点id',
  `big_node_id` varchar(60) NOT NULL DEFAULT '0' COMMENT '大节点的ID',
  `small_node_id` varchar(60) NOT NULL DEFAULT '0' COMMENT '小节点的ID',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` enum('0','1') DEFAULT '0' COMMENT '删除时间',
  `examine_status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`psnr_id`),
  KEY `process_mul_id_key` (`process_mul_id`),
  KEY `node_mul_id_key` (`node_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=665 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='审核多伦会话大小节点的关系';


CREATE TABLE `autodialer_speech_mul_label_synonym` (
  `sls_id` int NOT NULL AUTO_INCREMENT COMMENT '关键词',
  `sls_name` varchar(64) NOT NULL DEFAULT '' COMMENT '关键名称',
  `sls_keyword` enum('yes','no','any','reject') NOT NULL DEFAULT 'yes' COMMENT '关键分组默认是yes：肯定，no:否定，any：默认，reject:拒绝',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `node_mul_id` int NOT NULL COMMENT '大节点id',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `delete_time` int DEFAULT '0',
  `node_ids` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`sls_id`),
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `speech_id` (`speech_id`),
  KEY `process_mul_id` (`process_mul_id`),
  KEY `node_mul_id` (`node_mul_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7653 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='多伦会话关键词话术';


CREATE TABLE `autodialer_examine_speech_mul_process_node_setting` (
  `set_id` int NOT NULL AUTO_INCREMENT COMMENT '其它设置ID',
  `set_key` varchar(30) NOT NULL COMMENT '其它设置名称',
  `set_value` text NOT NULL COMMENT '其它设置值',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `node_mul_id` int NOT NULL COMMENT '节点ID',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `talk_temp_id` int NOT NULL COMMENT '话术模板ID',
  `user_id` int NOT NULL COMMENT '话术流程节点信息表ID',
  `desc` varchar(64) DEFAULT NULL COMMENT '详情',
  `delete_time` int DEFAULT '0' COMMENT '删除id',
  PRIMARY KEY (`set_id`),
  KEY `process_id_key` (`process_mul_id`),
  KEY `node_id_key` (`node_mul_id`),
  KEY `talk_temp_id_key` (`talk_temp_id`),
  KEY `info_id_key` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1396 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='多伦会话话术流程的其他设置表';


CREATE TABLE `autodialer_examine_speech_mul_label_synonym` (
  `sls_id` int NOT NULL COMMENT '关键词',
  `sls_name` varchar(64) NOT NULL DEFAULT '' COMMENT '关键名称',
  `sls_keyword` enum('yes','no','any','reject') NOT NULL DEFAULT 'yes' COMMENT '关键分组默认是yes：肯定，no:否定，any：默认，reject:拒绝',
  `create_time` int NOT NULL COMMENT '创建时间',
  `update_time` int NOT NULL DEFAULT '0' COMMENT '更新时间',
  `process_mul_id` int NOT NULL COMMENT '话术流程ID',
  `node_mul_id` int NOT NULL COMMENT '大节点id',
  `user_id` int NOT NULL DEFAULT '0' COMMENT '公司的用户ID 主账号',
  `speech_id` int NOT NULL COMMENT '话术模板id',
  `delete_time` int DEFAULT '0',
  `node_ids` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT COMMENT '审核id',
  `version` varchar(64) NOT NULL COMMENT '版本id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `create_time` (`create_time`),
  KEY `update_time` (`update_time`),
  KEY `speech_id` (`speech_id`),
  KEY `process_mul_id` (`process_mul_id`),
  KEY `node_mul_id` (`node_mul_id`),
  KEY `user_id` (`user_id`),
  KEY `sls_id` (`sls_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='多伦会话审核关键词话术';