/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.24.105
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : 192.168.24.105:3306
 Source Schema         : customer-center

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : 65001

 Date: 14/09/2020 14:16:32
*/
DROP DATABASE IF EXISTS `customer-center`;
CREATE DATABASE `customer-center`;
USE `customer-center`;

-- ----------------------------
-- Table structure for alarm_code
-- ----------------------------
CREATE TABLE `alarm_code`  (
  `id` bigint(10) NOT NULL COMMENT '报警编号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报警名称',
  `describe` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `source_type` bigint(20) NOT NULL DEFAULT 1 COMMENT '报警来源 1:平台 0:终端 20:第三方终端  21:第三方平台',
  `flag` smallint(6) NOT NULL DEFAULT 1 COMMENT '0停用、1启用',
  `parent_id` bigint(10) NOT NULL COMMENT '父类报警编码',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `un_id`(`id`) USING BTREE,
  INDEX `no_name_flag`(`name`, `flag`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `alarm_code` VALUES (1, '超速报警', NULL, 20, 1, 100);
INSERT INTO `alarm_code` VALUES (2, '疲劳驾驶报警', NULL, 20, 1, 101);
INSERT INTO `alarm_code` VALUES (3, '紧急报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (4, '进入指定区域报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (5, '离开指定区域报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (8, '越界报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (9, '盗警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (10, '基础类报警', '', 1, 1, 0);
INSERT INTO `alarm_code` VALUES (11, '软围栏', NULL, 1, 1, 0);
INSERT INTO `alarm_code` VALUES (12, '系统平台', NULL, 1, 1, 0);
INSERT INTO `alarm_code` VALUES (13, '林业细分报警', NULL, 1, 1, 0);
INSERT INTO `alarm_code` VALUES (14, '商砼细分报警', NULL, 1, 1, 0);
INSERT INTO `alarm_code` VALUES (16, '违规行驶报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (17, '前碰报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (18, '车道偏离报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (19, '胎压异常报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (20, '动态信息异常报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (21, '当天累计驾驶超时报警', NULL, 20, 1, 101);
INSERT INTO `alarm_code` VALUES (22, '危险驾驶行为报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (100, '超速报警', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (101, '疲劳驾驶', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (102, '碰撞危险', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (103, '注意力分散', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (104, '违规驾驶', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (105, '其他报警', NULL, 2, 1, 0);
INSERT INTO `alarm_code` VALUES (255, '其他报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (257, '视频信号丢失报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (258, '视频信号遮挡报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (259, '存储单元故障报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (260, '其他视频设备故障报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (261, '客车超员报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (262, '异常驾驶行为报警', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (263, '特殊报警录像达到存储阈值报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (513, '前向碰撞', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (514, '车道左偏离', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (515, '车道右偏离', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (516, '车距过近', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (517, '行人碰撞', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (518, '频繁变道', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (519, '道路标识超限报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (520, '急加速报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (521, '急减速报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (528, '急转弯报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (529, '外设状态异常报警（FMS）', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (530, '闭眼', NULL, 20, 1, 101);
INSERT INTO `alarm_code` VALUES (531, '打哈欠', NULL, 20, 1, 101);
INSERT INTO `alarm_code` VALUES (532, '长时间不目视前方', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (533, '抽烟', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (534, '接打手持电话', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (535, '驾驶员不在驾驶位置', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (536, '遮挡报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (537, '红外阻断报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (545, '双手同时脱离方向盘', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (546, '外设状态异常报警（DMS）', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (547, '胎压过高报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (548, '胎压过低报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (549, '胎温过高报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (550, '胎压传感器异常报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (551, '胎压不平衡报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (552, '慢漏气报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (553, '胎压传感器电池电量过低报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (560, '后方接近报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (561, '左侧后方接近报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (562, '右侧后方接近报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (563, '路网超速', NULL, 20, 1, 100);
INSERT INTO `alarm_code` VALUES (564, '车道偏离', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (565, '障碍物', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (566, '盲区监测报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (567, '分神驾驶', NULL, 20, 1, 103);
INSERT INTO `alarm_code` VALUES (568, '空挡滑行', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (569, '实线变道', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (576, '不按规定上下客', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (577, '路口快速通过', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (578, '道路标识限速报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (579, '道路标识限高报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (580, '道路标识限重报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (581, '道路标识限宽报警', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (582, '未系安全带', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (583, '疲劳驾驶（生理）', NULL, 20, 1, 101);
INSERT INTO `alarm_code` VALUES (584, '怠速', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (585, '异常熄火', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (586, '发动机超转', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (769, '碰撞侧翻报警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (770, '侧翻预警', NULL, 20, 1, 102);
INSERT INTO `alarm_code` VALUES (772, '进出路线报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (773, '路段行驶时间不足/过长报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (774, '车辆非法点火报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (775, '车辆非法位移报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (776, '终端故障报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (785, '三天未上线报警', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (787, '长期异地经营报警', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (788, '离线位移报警', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (10000, '里程传感器-超速报警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10001, '平台超速报警-超速报警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10002, '软围栏-超速报警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10003, '超速违章', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10004, '超速预警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10005, '疲劳驾驶报警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10006, '电量不足报警', NULL, 1, 1, 10);
INSERT INTO `alarm_code` VALUES (10113, '超时驾驶报警', NULL, 21, 1, 101);
INSERT INTO `alarm_code` VALUES (10510, '劫警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (10511, '偏离路线报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (10512, '车辆移动报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (11000, '进区域报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11001, '出区域报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11002, '进线路报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11003, '出线路报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11004, '路线偏离报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11005, '不按规定路线运行报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11006, '到达关键点报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11007, '未达到关键点报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11008, '路段堵塞报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (11009, '危险路段报警', NULL, 1, 1, 11);
INSERT INTO `alarm_code` VALUES (12000, '核心数据异常', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12001, '雨雪天气报警', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12002, '长时间下线报警', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12003, '平台文件存储阀值报警', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12004, '809下级平台异常断线-报警信息', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12005, '809下级平台异常断线-预警信息', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12006, '809下级平台数据传输异常-报警信息', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12007, '809下级平台数据传输异常-预警信息', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (12008, '809平台接入异常', NULL, 1, 1, 12);
INSERT INTO `alarm_code` VALUES (13000, '车机疑似屏蔽报警', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (13001, '上班未到岗', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (13002, '上班离岗', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (13003, '超时长停留', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (13004, '任务未到岗', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (13005, '任务离岗', NULL, 1, 1, 13);
INSERT INTO `alarm_code` VALUES (14000, '运输超时报警', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14001, '卸料超时报警', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14002, '停止超时报警', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14003, '异常卸料报警', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14004, '开盘时间提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14005, '结束任务时间提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14006, '派车间隔提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14007, '计划车次提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14008, '累计方量超过提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (14009, '供应尾数提醒', NULL, 1, 1, 14);
INSERT INTO `alarm_code` VALUES (40961, '超时停车', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (40962, '车辆定位信息上报时间间隔异常', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40963, '车辆定位信息上报距离间隔异常', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40964, '下级平台异常断线', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40965, '下级平台数据传输异常', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40966, '路段堵塞报警', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (40967, '危险路段报警', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40968, '雨雪天气报警', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40969, '驾驶员身份识别异常', NULL, 20, 1, 104);
INSERT INTO `alarm_code` VALUES (40970, '终端异常（含线路连接异常）', NULL, 20, 1, 105);
INSERT INTO `alarm_code` VALUES (40971, '平台接入异常', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (40972, '核心数据异常', NULL, 21, 1, 105);
INSERT INTO `alarm_code` VALUES (41215, '其他报警', NULL, 20, 1, 105);
-- ----------------------------
-- Table structure for alarm_risk_param
-- ----------------------------
CREATE TABLE `alarm_risk_param`  (
  `client_info_id` bigint(20) NOT NULL COMMENT '客户编号',
  `alarm_type` bigint(10) NOT NULL COMMENT '报警编号',
  `risk_type` bigint(10) NULL DEFAULT NULL COMMENT '风险类别',
  `one_level` tinyint(4) NULL DEFAULT NULL COMMENT '一级报警等级初始值',
  `two_level` tinyint(4) NULL DEFAULT NULL COMMENT '二级报警等级初始值',
  `create_time` bigint(20) NULL DEFAULT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NULL DEFAULT NULL COMMENT '数据更新时间',
  PRIMARY KEY (`client_info_id`, `alarm_type`) USING BTREE,
  INDEX `info`(`client_info_id`, `alarm_type`, `risk_type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alarm_set
-- ----------------------------
CREATE TABLE `alarm_set`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` smallint(2) NOT NULL COMMENT '设置类型\n\n1: 按平台级设置\n\n2:按企业级设置\n\n3:按监控对象设置',
  `identification` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订阅的标识，\n\n当订阅类型为平台时，传平台编号\n\n当订阅类型为企业时，传输企业编号\n\n当订阅监控对象时，传监控对象编号',
  `alarm_id` bigint(10) NOT NULL COMMENT '报警信息编号',
  `param` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警计算参数',
  `create_time` bigint(20) NULL DEFAULT NULL COMMENT '数据创建时间',
  `update_time` bigint(15) NULL DEFAULT NULL,
  `flag` int(5) NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  `client_info_id` bigint(20) NOT NULL COMMENT '平台id',
  PRIMARY KEY (`id`, `client_info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alarm_subscription
-- ----------------------------
CREATE TABLE `alarm_subscription`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_info_id` bigint(20) NOT NULL COMMENT '客户编号',
  `type` int(2) NOT NULL COMMENT '订阅类型\n\n1: 按平台级订阅\n\n2:按企业级订阅\n\n3:按监控对象订阅',
  `identification` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订阅的标识，',
  `param` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报警信息推送参数',
  `create_time` bigint(20) NOT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NOT NULL COMMENT '数据更新时间',
  `flag` int(2) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for data_dictionary
-- ----------------------------
CREATE TABLE `data_dictionary`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '目录code',
  `pid` bigint(20) NOT NULL COMMENT '父节点id，根节点约定为0',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `enabled` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否已启用(1：启用，0：停用)',
  `flag` tinyint(4) NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段1 value',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_cat_code`(`category`, `code`) USING BTREE,
  INDEX `idx_flag`(`flag`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 300 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `data_dictionary` VALUES (1, '客车', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '10');
INSERT INTO `data_dictionary` VALUES (2, '大型客车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '11');
INSERT INTO `data_dictionary` VALUES (3, '中型客车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '12');
INSERT INTO `data_dictionary` VALUES (4, '小型客车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '13');
INSERT INTO `data_dictionary` VALUES (5, '轿车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '14');
INSERT INTO `data_dictionary` VALUES (6, '大型卧铺客车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '15');
INSERT INTO `data_dictionary` VALUES (7, '中型卧铺客车', 'VEHICLE_TYPE', 1, NULL, b'1', 1, '16');
INSERT INTO `data_dictionary` VALUES (8, '普通货车', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '20');
INSERT INTO `data_dictionary` VALUES (9, '大型普通货车', 'VEHICLE_TYPE', 8, NULL, b'1', 1, '21');
INSERT INTO `data_dictionary` VALUES (10, '中型普通货车', 'VEHICLE_TYPE', 8, NULL, b'1', 1, '22');
INSERT INTO `data_dictionary` VALUES (11, '小型普通货车', 'VEHICLE_TYPE', 8, NULL, b'1', 1, '23');
INSERT INTO `data_dictionary` VALUES (12, '专用运输车', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '30');
INSERT INTO `data_dictionary` VALUES (13, '集装箱车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '31');
INSERT INTO `data_dictionary` VALUES (14, '大件运输车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '32');
INSERT INTO `data_dictionary` VALUES (15, '保温冷藏车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '33');
INSERT INTO `data_dictionary` VALUES (16, '商品车运输专用车辆', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '34');
INSERT INTO `data_dictionary` VALUES (17, '罐车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '35');
INSERT INTO `data_dictionary` VALUES (18, '牵引车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '36');
INSERT INTO `data_dictionary` VALUES (19, '挂车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '37');
INSERT INTO `data_dictionary` VALUES (20, '平板车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '38');
INSERT INTO `data_dictionary` VALUES (21, '其他专用车', 'VEHICLE_TYPE', 12, NULL, b'1', 1, '39');
INSERT INTO `data_dictionary` VALUES (22, '危险品运输车', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '40');
INSERT INTO `data_dictionary` VALUES (23, '农用车', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '50');
INSERT INTO `data_dictionary` VALUES (24, '拖拉机', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '60');
INSERT INTO `data_dictionary` VALUES (25, '轮式拖拉机', 'VEHICLE_TYPE', 24, NULL, b'1', 1, '61');
INSERT INTO `data_dictionary` VALUES (26, '手扶拖拉机', 'VEHICLE_TYPE', 24, NULL, b'1', 1, '62');
INSERT INTO `data_dictionary` VALUES (27, '履带拖拉机', 'VEHICLE_TYPE', 24, NULL, b'1', 1, '63');
INSERT INTO `data_dictionary` VALUES (28, '特种拖拉机', 'VEHICLE_TYPE', 24, NULL, b'1', 1, '64');
INSERT INTO `data_dictionary` VALUES (29, '其他车辆', 'VEHICLE_TYPE', 0, NULL, b'1', 1, '90');
INSERT INTO `data_dictionary` VALUES (31, '道路旅客运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '010');
INSERT INTO `data_dictionary` VALUES (32, '班车客运', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '011');
INSERT INTO `data_dictionary` VALUES (33, '包车客运', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '012');
INSERT INTO `data_dictionary` VALUES (34, '定线旅游', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '013');
INSERT INTO `data_dictionary` VALUES (35, '非定线旅游', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '014');
INSERT INTO `data_dictionary` VALUES (36, '道路货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '020');
INSERT INTO `data_dictionary` VALUES (37, '道路普通货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '021');
INSERT INTO `data_dictionary` VALUES (38, '货物专用运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '022');
INSERT INTO `data_dictionary` VALUES (39, '大型物件运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '023');
INSERT INTO `data_dictionary` VALUES (40, '道路危险货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '030');
INSERT INTO `data_dictionary` VALUES (41, '营运性危险货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '031');
INSERT INTO `data_dictionary` VALUES (42, '非经营性危险货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '032');
INSERT INTO `data_dictionary` VALUES (43, '机动车维修', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '040');
INSERT INTO `data_dictionary` VALUES (44, '汽车维修', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '041');
INSERT INTO `data_dictionary` VALUES (45, '危险货物运输车辆维修', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '042');
INSERT INTO `data_dictionary` VALUES (46, '摩托车维修', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '043');
INSERT INTO `data_dictionary` VALUES (47, '其他机动车维修', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '044');
INSERT INTO `data_dictionary` VALUES (48, '机动车驾驶员培训', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '050');
INSERT INTO `data_dictionary` VALUES (49, '普通机动车驾驶员培训', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '051');
INSERT INTO `data_dictionary` VALUES (50, '道路运输驾驶员从业资格培训', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '052');
INSERT INTO `data_dictionary` VALUES (51, '机动车驾驶员培训教练场', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '053');
INSERT INTO `data_dictionary` VALUES (52, '战场服务', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '060');
INSERT INTO `data_dictionary` VALUES (53, '道路旅客运输站', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '061');
INSERT INTO `data_dictionary` VALUES (54, '道路货运站(场)', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '062');
INSERT INTO `data_dictionary` VALUES (55, '国际道路运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '070');
INSERT INTO `data_dictionary` VALUES (56, '国际道路旅客运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '071');
INSERT INTO `data_dictionary` VALUES (57, '国际道路货物运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '072');
INSERT INTO `data_dictionary` VALUES (58, '公交运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '080');
INSERT INTO `data_dictionary` VALUES (59, '公交运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '081');
INSERT INTO `data_dictionary` VALUES (60, '出租运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '090');
INSERT INTO `data_dictionary` VALUES (61, '客运出租运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '091');
INSERT INTO `data_dictionary` VALUES (62, '货运出租运输', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '092');
INSERT INTO `data_dictionary` VALUES (63, '汽车租赁', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '100');
INSERT INTO `data_dictionary` VALUES (64, '客运汽车租赁', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '101');
INSERT INTO `data_dictionary` VALUES (65, '货运汽车租赁', 'INDUSTRY_CATEGORY', 0, NULL, b'1', 1, '102');
INSERT INTO `data_dictionary` VALUES (67, '道路旅客运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01000');
INSERT INTO `data_dictionary` VALUES (68, '班车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01100');
INSERT INTO `data_dictionary` VALUES (69, '县内班车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01101');
INSERT INTO `data_dictionary` VALUES (70, '县际班车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01102');
INSERT INTO `data_dictionary` VALUES (71, '市际班车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01103');
INSERT INTO `data_dictionary` VALUES (72, '省际班车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01104');
INSERT INTO `data_dictionary` VALUES (73, '包车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01200');
INSERT INTO `data_dictionary` VALUES (74, '县内包车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01201');
INSERT INTO `data_dictionary` VALUES (75, '县际包车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01202');
INSERT INTO `data_dictionary` VALUES (76, '市际包车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01203');
INSERT INTO `data_dictionary` VALUES (77, '省际包车客运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01204');
INSERT INTO `data_dictionary` VALUES (78, '定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01300');
INSERT INTO `data_dictionary` VALUES (79, '县内定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01301');
INSERT INTO `data_dictionary` VALUES (80, '县际定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01302');
INSERT INTO `data_dictionary` VALUES (81, '市际定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01303');
INSERT INTO `data_dictionary` VALUES (82, '省际定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01304');
INSERT INTO `data_dictionary` VALUES (83, '非定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01400');
INSERT INTO `data_dictionary` VALUES (84, '县内非定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01401');
INSERT INTO `data_dictionary` VALUES (85, '县际非定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01402');
INSERT INTO `data_dictionary` VALUES (86, '市际非定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01403');
INSERT INTO `data_dictionary` VALUES (87, '省际非定线旅游', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '01404');
INSERT INTO `data_dictionary` VALUES (88, '道路普通货运', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02000');
INSERT INTO `data_dictionary` VALUES (89, '道路普通货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02100');
INSERT INTO `data_dictionary` VALUES (90, '道路普通货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02101');
INSERT INTO `data_dictionary` VALUES (91, '货物专用运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02200');
INSERT INTO `data_dictionary` VALUES (92, '货物专用运输(集装箱)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02201');
INSERT INTO `data_dictionary` VALUES (93, '货物专用运输(冷藏保鲜设备)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02202');
INSERT INTO `data_dictionary` VALUES (94, '货物专用运输(罐式容器)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02203');
INSERT INTO `data_dictionary` VALUES (95, '大型物件运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02300');
INSERT INTO `data_dictionary` VALUES (96, '大型物件运输(一类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02301');
INSERT INTO `data_dictionary` VALUES (97, '大型物件运输(二类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02302');
INSERT INTO `data_dictionary` VALUES (98, '大型物件运输(三类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02303');
INSERT INTO `data_dictionary` VALUES (99, '大型物件运输(四类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '02304');
INSERT INTO `data_dictionary` VALUES (100, '道路危险货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03000');
INSERT INTO `data_dictionary` VALUES (101, '经营性道路危险货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03100');
INSERT INTO `data_dictionary` VALUES (102, '危险货物运输(1类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03111');
INSERT INTO `data_dictionary` VALUES (103, '危险货物运输(1类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03112');
INSERT INTO `data_dictionary` VALUES (104, '危险货物运输(1类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03113');
INSERT INTO `data_dictionary` VALUES (105, '危险货物运输(1类4项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03114');
INSERT INTO `data_dictionary` VALUES (106, '危险货物运输(1类5项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03115');
INSERT INTO `data_dictionary` VALUES (107, '危险货物运输(1类6项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03116');
INSERT INTO `data_dictionary` VALUES (108, '危险货物运输(2类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03121');
INSERT INTO `data_dictionary` VALUES (109, '危险货物运输(2类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03122');
INSERT INTO `data_dictionary` VALUES (110, '危险货物运输(2类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03123');
INSERT INTO `data_dictionary` VALUES (111, '危险货物运输(3类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03131');
INSERT INTO `data_dictionary` VALUES (112, '危险货物运输(4类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03141');
INSERT INTO `data_dictionary` VALUES (113, '危险货物运输(4类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03142');
INSERT INTO `data_dictionary` VALUES (114, '危险货物运输(4类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03143');
INSERT INTO `data_dictionary` VALUES (115, '危险货物运输(5类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03151');
INSERT INTO `data_dictionary` VALUES (116, '危险货物运输(5类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03152');
INSERT INTO `data_dictionary` VALUES (117, '危险货物运输(6类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03161');
INSERT INTO `data_dictionary` VALUES (118, '危险货物运输(6类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03162');
INSERT INTO `data_dictionary` VALUES (119, '危险货物运输(7类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03170');
INSERT INTO `data_dictionary` VALUES (120, '危险货物运输(8类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03181');
INSERT INTO `data_dictionary` VALUES (121, '危险货物运输(9类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03191');
INSERT INTO `data_dictionary` VALUES (122, '非经营性危险货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03200');
INSERT INTO `data_dictionary` VALUES (123, '危险货物运输(1类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03211');
INSERT INTO `data_dictionary` VALUES (124, '危险货物运输(1类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03212');
INSERT INTO `data_dictionary` VALUES (125, '危险货物运输(1类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03213');
INSERT INTO `data_dictionary` VALUES (126, '危险货物运输(1类4项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03214');
INSERT INTO `data_dictionary` VALUES (127, '危险货物运输(1类5项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03215');
INSERT INTO `data_dictionary` VALUES (128, '危险货物运输(1类6项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03216');
INSERT INTO `data_dictionary` VALUES (129, '危险货物运输(2类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03221');
INSERT INTO `data_dictionary` VALUES (130, '危险货物运输(2类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03222');
INSERT INTO `data_dictionary` VALUES (131, '危险货物运输(2类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03223');
INSERT INTO `data_dictionary` VALUES (132, '危险货物运输(3类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03231');
INSERT INTO `data_dictionary` VALUES (133, '危险货物运输(4类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03241');
INSERT INTO `data_dictionary` VALUES (134, '危险货物运输(4类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03242');
INSERT INTO `data_dictionary` VALUES (135, '危险货物运输(4类3项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03243');
INSERT INTO `data_dictionary` VALUES (136, '危险货物运输(5类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03251');
INSERT INTO `data_dictionary` VALUES (137, '危险货物运输(5类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03252');
INSERT INTO `data_dictionary` VALUES (138, '危险货物运输(6类1项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03261');
INSERT INTO `data_dictionary` VALUES (139, '危险货物运输(6类2项)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03262');
INSERT INTO `data_dictionary` VALUES (140, '危险货物运输(7类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03270');
INSERT INTO `data_dictionary` VALUES (141, '危险货物运输(8类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03281');
INSERT INTO `data_dictionary` VALUES (142, '危险货物运输(9类)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '03291');
INSERT INTO `data_dictionary` VALUES (143, '机动车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04000');
INSERT INTO `data_dictionary` VALUES (144, '一类汽车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04100');
INSERT INTO `data_dictionary` VALUES (145, '大中型客车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04101');
INSERT INTO `data_dictionary` VALUES (146, '大中型货车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04102');
INSERT INTO `data_dictionary` VALUES (147, '小型车辆维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04103');
INSERT INTO `data_dictionary` VALUES (148, '危险货物运输车辆维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04104');
INSERT INTO `data_dictionary` VALUES (149, '二类汽车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04200');
INSERT INTO `data_dictionary` VALUES (150, '大中型客车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04201');
INSERT INTO `data_dictionary` VALUES (151, '大中型货车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04202');
INSERT INTO `data_dictionary` VALUES (152, '小型车辆维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04203');
INSERT INTO `data_dictionary` VALUES (153, '三类汽车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04300');
INSERT INTO `data_dictionary` VALUES (154, '发动机维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04301');
INSERT INTO `data_dictionary` VALUES (155, '车身维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04302');
INSERT INTO `data_dictionary` VALUES (156, '电气系统维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04303');
INSERT INTO `data_dictionary` VALUES (157, '自动变速器维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04304');
INSERT INTO `data_dictionary` VALUES (158, '车身清洁维护', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04305');
INSERT INTO `data_dictionary` VALUES (159, '涂漆', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04306');
INSERT INTO `data_dictionary` VALUES (160, '轮胎动平衡及修补', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04307');
INSERT INTO `data_dictionary` VALUES (161, '四轮定位检测调整', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04308');
INSERT INTO `data_dictionary` VALUES (162, '供油系统维护及油品更换', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04309');
INSERT INTO `data_dictionary` VALUES (163, '喷油泵和喷油嘴维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04310');
INSERT INTO `data_dictionary` VALUES (164, '曲轴修磨', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04311');
INSERT INTO `data_dictionary` VALUES (165, '气缸膛磨', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04312');
INSERT INTO `data_dictionary` VALUES (166, '散热器(水箱)修理', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04313');
INSERT INTO `data_dictionary` VALUES (167, '空调维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04314');
INSERT INTO `data_dictionary` VALUES (168, '车辆装潢(篷布、坐垫及内饰)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04315');
INSERT INTO `data_dictionary` VALUES (169, '车辆玻璃安装', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04316');
INSERT INTO `data_dictionary` VALUES (170, '一类摩托车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04400');
INSERT INTO `data_dictionary` VALUES (171, '总成大修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04401');
INSERT INTO `data_dictionary` VALUES (172, '维护', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04402');
INSERT INTO `data_dictionary` VALUES (173, '小修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04403');
INSERT INTO `data_dictionary` VALUES (174, '二类摩托车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04500');
INSERT INTO `data_dictionary` VALUES (175, '维护', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04501');
INSERT INTO `data_dictionary` VALUES (176, '小修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04502');
INSERT INTO `data_dictionary` VALUES (177, '其他机动车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04600');
INSERT INTO `data_dictionary` VALUES (178, '其他机动车维修', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '04601');
INSERT INTO `data_dictionary` VALUES (179, '机动车驾驶员培训', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05000');
INSERT INTO `data_dictionary` VALUES (180, '普通机动车驾驶员培训', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05100');
INSERT INTO `data_dictionary` VALUES (181, 'A1', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05111');
INSERT INTO `data_dictionary` VALUES (182, 'A2', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05112');
INSERT INTO `data_dictionary` VALUES (183, 'A3', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05113');
INSERT INTO `data_dictionary` VALUES (184, 'B1', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05121');
INSERT INTO `data_dictionary` VALUES (185, 'B2', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05122');
INSERT INTO `data_dictionary` VALUES (186, 'C1', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05131');
INSERT INTO `data_dictionary` VALUES (187, 'C2', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05132');
INSERT INTO `data_dictionary` VALUES (188, 'C3', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05133');
INSERT INTO `data_dictionary` VALUES (189, 'C4', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05134');
INSERT INTO `data_dictionary` VALUES (190, 'D', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05140');
INSERT INTO `data_dictionary` VALUES (191, 'E', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05150');
INSERT INTO `data_dictionary` VALUES (192, 'F', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05160');
INSERT INTO `data_dictionary` VALUES (193, 'M', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05170');
INSERT INTO `data_dictionary` VALUES (194, '道路运输驾驶员从业资格培训', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05200');
INSERT INTO `data_dictionary` VALUES (195, '道路运输驾驶员从业资格培训(客运)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05201');
INSERT INTO `data_dictionary` VALUES (196, '道路运输驾驶员从业资格培训(货运)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05202');
INSERT INTO `data_dictionary` VALUES (197, '道路运输驾驶员从业资格培训(危险货运)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05203');
INSERT INTO `data_dictionary` VALUES (198, '道路运输驾驶员从业资格培训(其他)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05204');
INSERT INTO `data_dictionary` VALUES (199, '机动车驾驶员培训教练场', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05300');
INSERT INTO `data_dictionary` VALUES (200, '机动车驾驶员培训教练场', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '05301');
INSERT INTO `data_dictionary` VALUES (201, '道路货运站(场)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '06200');
INSERT INTO `data_dictionary` VALUES (202, '道路货运站(场)', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '06201');
INSERT INTO `data_dictionary` VALUES (203, '国际道路运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07000');
INSERT INTO `data_dictionary` VALUES (204, '国际道路旅客运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07100');
INSERT INTO `data_dictionary` VALUES (205, '定期国际道路旅客运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07101');
INSERT INTO `data_dictionary` VALUES (206, '不定期国际道路旅客运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07102');
INSERT INTO `data_dictionary` VALUES (207, '国际道路货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07200');
INSERT INTO `data_dictionary` VALUES (208, '国际道路货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07201');
INSERT INTO `data_dictionary` VALUES (209, '国际道路危险货物运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '07202');
INSERT INTO `data_dictionary` VALUES (210, '公交运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '08000');
INSERT INTO `data_dictionary` VALUES (211, '公交运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '08100');
INSERT INTO `data_dictionary` VALUES (212, '公交运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '08101');
INSERT INTO `data_dictionary` VALUES (213, '出租运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '09000');
INSERT INTO `data_dictionary` VALUES (214, '客运出租运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '09100');
INSERT INTO `data_dictionary` VALUES (215, '客运出租运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '09101');
INSERT INTO `data_dictionary` VALUES (216, '货运出租运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '09200');
INSERT INTO `data_dictionary` VALUES (217, '货运出租运输', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '09201');
INSERT INTO `data_dictionary` VALUES (218, '汽车租赁', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '10000');
INSERT INTO `data_dictionary` VALUES (219, '客运汽车租赁', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '10100');
INSERT INTO `data_dictionary` VALUES (220, '客运汽车租赁', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '10101');
INSERT INTO `data_dictionary` VALUES (221, '货运汽车租赁', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '10200');
INSERT INTO `data_dictionary` VALUES (222, '货运汽车租赁', 'BUSINESS_SCOPE', 0, NULL, b'1', 1, '10201');
INSERT INTO `data_dictionary` VALUES (223, '蓝色', 'PLATE_COLOR', 0, NULL, b'1', 1, '1');
INSERT INTO `data_dictionary` VALUES (224, '黄色', 'PLATE_COLOR', 0, NULL, b'1', 1, '2');
INSERT INTO `data_dictionary` VALUES (225, '黑色', 'PLATE_COLOR', 0, NULL, b'1', 1, '3');
INSERT INTO `data_dictionary` VALUES (226, '白色', 'PLATE_COLOR', 0, NULL, b'1', 1, '4');
INSERT INTO `data_dictionary` VALUES (227, '绿色', 'PLATE_COLOR', 0, NULL, b'1', 1, '5');
INSERT INTO `data_dictionary` VALUES (228, '黄绿色', 'PLATE_COLOR', 0, NULL, b'1', 1, '93');
INSERT INTO `data_dictionary` VALUES (229, '渐变绿色', 'PLATE_COLOR', 0, NULL, b'1', 1, '94');
INSERT INTO `data_dictionary` VALUES (230, '其他', 'PLATE_COLOR', 0, NULL, b'1', 1, '9');
INSERT INTO `data_dictionary` VALUES (231, '农蓝色', 'PLATE_COLOR', 0, NULL, b'1', 1, '90');
INSERT INTO `data_dictionary` VALUES (232, '农黄色', 'PLATE_COLOR', 0, NULL, b'1', 1, '91');
INSERT INTO `data_dictionary` VALUES (233, '农绿色', 'PLATE_COLOR', 0, NULL, b'1', 1, '92');
INSERT INTO `data_dictionary` VALUES (234, 'JT/808部标', 'ACCESS_PROTOCOL_TYPE', 0, NULL, b'1', 1, '10');
INSERT INTO `data_dictionary` VALUES (235, '超待协议', 'ACCESS_PROTOCOL_TYPE', 0, NULL, b'1', 1, '11');
INSERT INTO `data_dictionary` VALUES (236, '私有协议', 'ACCESS_PROTOCOL_TYPE', 0, NULL, b'1', 1, '12');
INSERT INTO `data_dictionary` VALUES (237, 'OBD类协议', 'ACCESS_PROTOCOL_TYPE', 0, NULL, b'1', 1, '13');
INSERT INTO `data_dictionary` VALUES (238, 'JT/T-809部标', 'ACCESS_PROTOCOL_TYPE', 0, NULL, b'1', 1, '20');
INSERT INTO `data_dictionary` VALUES (239, 'JT/T808-2011', 'ACCESS_PROTOCOL_TYPE', 234, NULL, b'1', 1, '1010');
INSERT INTO `data_dictionary` VALUES (240, 'JT/T808-2013', 'ACCESS_PROTOCOL_TYPE', 234, NULL, b'1', 1, '1011');
INSERT INTO `data_dictionary` VALUES (241, 'JT/T808-2019', 'ACCESS_PROTOCOL_TYPE', 234, NULL, b'1', 1, '1012');
INSERT INTO `data_dictionary` VALUES (242, 'F3超待', 'ACCESS_PROTOCOL_TYPE', 235, NULL, b'1', 1, '1110');
INSERT INTO `data_dictionary` VALUES (243, '艾赛欧超待', 'ACCESS_PROTOCOL_TYPE', 235, NULL, b'1', 1, '1111');
INSERT INTO `data_dictionary` VALUES (244, '博实结超待', 'ACCESS_PROTOCOL_TYPE', 235, NULL, b'1', 1, '1112');
INSERT INTO `data_dictionary` VALUES (245, '移为', 'ACCESS_PROTOCOL_TYPE', 236, NULL, b'1', 1, '1210');
INSERT INTO `data_dictionary` VALUES (246, '天禾', 'ACCESS_PROTOCOL_TYPE', 236, NULL, b'1', 1, '1211');
INSERT INTO `data_dictionary` VALUES (247, '北斗天地', 'ACCESS_PROTOCOL_TYPE', 236, NULL, b'1', 1, '1212');
INSERT INTO `data_dictionary` VALUES (248, '康凯斯', 'ACCESS_PROTOCOL_TYPE', 236, NULL, b'1', 1, '1213');
INSERT INTO `data_dictionary` VALUES (249, '杭州OBD', 'ACCESS_PROTOCOL_TYPE', 237, NULL, b'1', 1, '1310');
INSERT INTO `data_dictionary` VALUES (250, '郑州OBD', 'ACCESS_PROTOCOL_TYPE', 237, NULL, b'1', 1, '1311');
INSERT INTO `data_dictionary` VALUES (251, 'JT/809-2011', 'ACCESS_PROTOCOL_TYPE', 238, NULL, b'1', 1, '2010');
INSERT INTO `data_dictionary` VALUES (252, 'JT/809-2019', 'ACCESS_PROTOCOL_TYPE', 238, NULL, b'1', 1, '2011');
INSERT INTO `data_dictionary` VALUES (254, 'JT/T808-2011', 'ACCESS_PROTOCOL_TYPE', 239, NULL, b'1', 1, '101000');
INSERT INTO `data_dictionary` VALUES (255, 'JT/T808-2011(1078报批稿)', 'ACCESS_PROTOCOL_TYPE', 239, NULL, b'1', 1, '101001');
INSERT INTO `data_dictionary` VALUES (256, 'JT/T808-2013', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101100');
INSERT INTO `data_dictionary` VALUES (257, 'JT/T808-2013(川标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101101');
INSERT INTO `data_dictionary` VALUES (258, 'JT/T808-2013(冀标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101102');
INSERT INTO `data_dictionary` VALUES (259, 'JT/T808-2013(桂标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101103');
INSERT INTO `data_dictionary` VALUES (260, 'JT/T808-2013(苏标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101104');
INSERT INTO `data_dictionary` VALUES (261, 'JT/T808-2013(浙标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101105');
INSERT INTO `data_dictionary` VALUES (262, 'JT/T808-2013(吉标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101106');
INSERT INTO `data_dictionary` VALUES (263, 'JT/T808-2013(陕标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101107');
INSERT INTO `data_dictionary` VALUES (264, 'JT/T808-2013(赣标)', 'ACCESS_PROTOCOL_TYPE', 240, NULL, b'1', 1, '101108');
INSERT INTO `data_dictionary` VALUES (265, 'JT/T808-2019', 'ACCESS_PROTOCOL_TYPE', 241, NULL, b'1', 1, '101200');
INSERT INTO `data_dictionary` VALUES (266, 'JT/T808-2019(中位)', 'ACCESS_PROTOCOL_TYPE', 241, NULL, b'1', 1, '101201');
INSERT INTO `data_dictionary` VALUES (267, 'JT/T808-2019(沪标)', 'ACCESS_PROTOCOL_TYPE', 241, NULL, b'1', 1, '101202');
INSERT INTO `data_dictionary` VALUES (268, 'JT/T808-2019(京标)', 'ACCESS_PROTOCOL_TYPE', 241, NULL, b'1', 1, '101203');
INSERT INTO `data_dictionary` VALUES (269, 'F3超待', 'ACCESS_PROTOCOL_TYPE', 242, NULL, b'1', 1, '111000');
INSERT INTO `data_dictionary` VALUES (270, '艾赛欧超待', 'ACCESS_PROTOCOL_TYPE', 243, NULL, b'1', 1, '111100');
INSERT INTO `data_dictionary` VALUES (271, '博实结超待', 'ACCESS_PROTOCOL_TYPE', 244, NULL, b'1', 1, '111200');
INSERT INTO `data_dictionary` VALUES (272, '移为', 'ACCESS_PROTOCOL_TYPE', 245, NULL, b'1', 1, '121000');
INSERT INTO `data_dictionary` VALUES (273, '天禾', 'ACCESS_PROTOCOL_TYPE', 246, NULL, b'1', 1, '121100');
INSERT INTO `data_dictionary` VALUES (274, '北斗天地', 'ACCESS_PROTOCOL_TYPE', 247, NULL, b'1', 1, '121200');
INSERT INTO `data_dictionary` VALUES (275, '康凯斯有线', 'ACCESS_PROTOCOL_TYPE', 248, NULL, b'1', 1, '121300');
INSERT INTO `data_dictionary` VALUES (276, '康凯斯无线', 'ACCESS_PROTOCOL_TYPE', 248, NULL, b'1', 1, '121301');
INSERT INTO `data_dictionary` VALUES (277, '杭州OBD', 'ACCESS_PROTOCOL_TYPE', 249, NULL, b'1', 1, '131000');
INSERT INTO `data_dictionary` VALUES (278, '郑州OBD', 'ACCESS_PROTOCOL_TYPE', 250, NULL, b'1', 1, '131100');
INSERT INTO `data_dictionary` VALUES (279, 'JT/809-2011', 'ACCESS_PROTOCOL_TYPE', 251, NULL, b'1', 1, '201000');
INSERT INTO `data_dictionary` VALUES (280, 'JT/809-2019', 'ACCESS_PROTOCOL_TYPE', 252, NULL, b'1', 1, '201100');
INSERT INTO `data_dictionary` VALUES (281, 'JT/809-2019(中位)', 'ACCESS_PROTOCOL_TYPE', 252, NULL, b'1', 1, '201101');
INSERT INTO `data_dictionary` VALUES (282, '关键点', 'FENCE_TYPE', 0, NULL, b'1', 1, '0');
INSERT INTO `data_dictionary` VALUES (283, '圆形', 'FENCE_TYPE', 0, NULL, b'1', 1, '1');
INSERT INTO `data_dictionary` VALUES (284, '矩形', 'FENCE_TYPE', 0, NULL, b'1', 1, '2');
INSERT INTO `data_dictionary` VALUES (285, '多边形', 'FENCE_TYPE', 0, NULL, b'1', 1, '3');
INSERT INTO `data_dictionary` VALUES (286, '行政区划', 'FENCE_TYPE', 0, NULL, b'1', 1, '4');
INSERT INTO `data_dictionary` VALUES (287, '路线', 'FENCE_TYPE', 0, NULL, b'1', 1, '5');
INSERT INTO `data_dictionary` VALUES (288, '分段线路', 'FENCE_TYPE', 0, NULL, b'1', 1, '6');
INSERT INTO `data_dictionary` VALUES (289, '导航线路', 'FENCE_TYPE', 0, NULL, b'1', 1, '7');
INSERT INTO `data_dictionary` VALUES (290, '标注', 'FENCE_TYPE', 0, NULL, b'1', 1, '8');
INSERT INTO `data_dictionary` VALUES (291, '未定位', 'MONITOR_STATUS', 0, NULL, b'1', 1, '2');
INSERT INTO `data_dictionary` VALUES (292, '离线', 'MONITOR_STATUS', 0, NULL, b'1', 1, '3');
INSERT INTO `data_dictionary` VALUES (293, '在线停止', 'MONITOR_STATUS', 0, NULL, b'1', 1, '4');
INSERT INTO `data_dictionary` VALUES (294, '普通报警', 'MONITOR_STATUS', 0, NULL, b'1', 1, '5');
INSERT INTO `data_dictionary` VALUES (295, '休眠', 'MONITOR_STATUS', 0, NULL, b'1', 1, '7');
INSERT INTO `data_dictionary` VALUES (296, '深度休眠', 'MONITOR_STATUS', 0, NULL, b'1', 1, '8');
INSERT INTO `data_dictionary` VALUES (297, '超速报警', 'MONITOR_STATUS', 0, NULL, b'1', 1, '9');
INSERT INTO `data_dictionary` VALUES (298, '在线行驶', 'MONITOR_STATUS', 0, NULL, b'1', 1, '10');
INSERT INTO `data_dictionary` VALUES (299, '心跳', 'MONITOR_STATUS', 0, NULL, b'1', 1, '11');
-- ----------------------------
-- Table structure for fence_config_info
-- ----------------------------
CREATE TABLE `fence_config_info`  (
  `client_info_id` bigint(20) NOT NULL COMMENT '客户编号',
  `fence_id` bigint(20) NOT NULL COMMENT '围栏编号',
  `type` smallint(2) NOT NULL COMMENT '绑定对象类型\r\n\r\n1:监控对象',
  `identification` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '对象编号',
  `in_area` smallint(2) NULL DEFAULT NULL COMMENT '进区域是否报警\n\n1 报警 0不报警',
  `start_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警开始时间（HH:mm:ss）',
  `end_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警结束时间（HH:mm:ss）',
  `start_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警开始日期（yyyy-MM-dd）',
  `end_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警结束日期（yyyy-MM-dd）',
  `max_speed` decimal(4, 2) NULL DEFAULT NULL COMMENT '限速值 0.1 km/h',
  `night_max_speed` decimal(4, 2) NULL DEFAULT NULL COMMENT '夜间限速值 0.1 km/h',
  `night_limit_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '夜间限速时段（默认:00:00-05:00）',
  `out_area` smallint(2) NOT NULL COMMENT '出区域是否报警\r\n\r\n1 报警 0 不报警',
  `create_time` bigint(20) NOT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NOT NULL COMMENT '数据修改时间',
  `flag` int(5) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  PRIMARY KEY (`fence_id`, `identification`, `client_info_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fence_info
-- ----------------------------
CREATE TABLE `fence_info`  (
  `id` bigint(20) NOT NULL COMMENT '围栏id',
  `client_info_id` bigint(20) NOT NULL COMMENT '客户编号',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '围栏名称',
  `fence_type` smallint(2) NULL DEFAULT NULL COMMENT '围栏类型\r\n\r\n0：关键点\r\n\r\n1：圆形\r\n\r\n2：矩形\r\n\r\n3：多边形\r\n\r\n4：行政区划\r\n\r\n5：线路\r\n\r\n6：分段线路\r\n\r\n7：导航线路\r\n\r\n8：标注',
  `source_type` smallint(2) NULL DEFAULT NULL COMMENT '围栏源类型\r\n\r\n0：终端围栏\r\n\r\n1：平台围栏',
  `fence_data` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '围栏数据',
  `create_time` bigint(20) NULL DEFAULT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NOT NULL COMMENT '数据修改时间',
  `flag` int(5) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  PRIMARY KEY (`client_info_id`, `id`) USING BTREE,
  UNIQUE INDEX `UN_ID_CLIENT_INFO_ID`(`id`, `client_info_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_info
-- ----------------------------
CREATE TABLE `group_info`  (
  `id` bigint(20) NOT NULL COMMENT '分组信息ID',
  `client_info_id` bigint(20) NULL DEFAULT NULL COMMENT '平台id',
  `name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分组信息名称',
  `link_man` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `tel_phone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `create_time` bigint(20) NOT NULL COMMENT '数据创建时间',
  `flag` int(5) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  `update_time` bigint(20) NOT NULL COMMENT '数据更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `un_client_id`(`id`, `client_info_id`) USING BTREE,
  INDEX `no_name_flag`(`name`, `flag`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for industry_category
-- ----------------------------
CREATE TABLE `industry_category`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '行业类别编码',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '行业类别名称',
  `flag` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `info`(`code`, `flag`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `industry_category` VALUES (1, '010', '道路旅客运输', 1);
INSERT INTO `industry_category` VALUES (2, '011', '班车客运', 1);
INSERT INTO `industry_category` VALUES (3, '012', '包车客运', 1);
INSERT INTO `industry_category` VALUES (4, '013', '定线旅游', 1);
INSERT INTO `industry_category` VALUES (5, '014', '非定线旅游', 1);
INSERT INTO `industry_category` VALUES (6, '020', '道路货物运输', 1);
INSERT INTO `industry_category` VALUES (7, '021', '道路普通货物运输', 1);
INSERT INTO `industry_category` VALUES (8, '022', '货物专用运输', 1);
INSERT INTO `industry_category` VALUES (9, '023', '大型物件运输', 1);
INSERT INTO `industry_category` VALUES (10, '030', '道路危险货物运输', 1);
INSERT INTO `industry_category` VALUES (11, '031', '营运性危险货物运输', 1);
INSERT INTO `industry_category` VALUES (12, '032', '非经营性危险货物运输', 1);
INSERT INTO `industry_category` VALUES (13, '040', '机动车维修', 1);
INSERT INTO `industry_category` VALUES (14, '041', '汽车维修', 1);
INSERT INTO `industry_category` VALUES (15, '042', '危险货物运输车辆维修', 1);
INSERT INTO `industry_category` VALUES (16, '043', '摩托车维修', 1);
INSERT INTO `industry_category` VALUES (17, '044', '其他机动车维修', 1);
INSERT INTO `industry_category` VALUES (18, '050', '机动车驾驶员培训', 1);
INSERT INTO `industry_category` VALUES (19, '051', '普通机动车驾驶员培训', 1);
INSERT INTO `industry_category` VALUES (20, '052', '道路运输驾驶员从业资格培训', 1);
INSERT INTO `industry_category` VALUES (21, '053', '机动车驾驶员培训教练场', 1);
INSERT INTO `industry_category` VALUES (22, '060', '站场服务', 1);
INSERT INTO `industry_category` VALUES (23, '061', '道路旅客运输站', 1);
INSERT INTO `industry_category` VALUES (24, '062', '道路货运站(场)', 1);
INSERT INTO `industry_category` VALUES (25, '070', '国际道路运输', 1);
INSERT INTO `industry_category` VALUES (26, '071', '国际道路旅客运输', 1);
INSERT INTO `industry_category` VALUES (27, '072', '国际道路货物运输', 1);
INSERT INTO `industry_category` VALUES (28, '080', '公交运输', 1);
INSERT INTO `industry_category` VALUES (29, '081', '公交运输', 1);
INSERT INTO `industry_category` VALUES (30, '090', '出租运输', 1);
INSERT INTO `industry_category` VALUES (31, '091', '客运出租运输', 1);
INSERT INTO `industry_category` VALUES (32, '092', '货运出租运输', 1);
INSERT INTO `industry_category` VALUES (33, '100', '汽车租赁', 1);
INSERT INTO `industry_category` VALUES (34, '101', '客运汽车租赁', 1);
INSERT INTO `industry_category` VALUES (35, '102', '货运汽车租赁', 1);

-- ----------------------------
-- Table structure for offline_export
-- ----------------------------
CREATE TABLE `offline_export`  (
  `client_info_id` bigint(20) NOT NULL COMMENT '客户id',
  `client_id` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号',
  `business_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务ID,由paas_cloud提供',
  `query_condition` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '查询条件',
  `create_date_time` bigint(20) NOT NULL COMMENT '导出时间',
  `digest_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '摘要导出ID',
  `call_back_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回调路径',
  `status` tinyint(255) NOT NULL COMMENT ' 0 待执行 1 执行中 2成功 3 失败',
  `finish_time` bigint(20) NULL DEFAULT NULL COMMENT '完成时间',
  `real_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径',
  `file_size` int(11) NULL DEFAULT NULL COMMENT '文件大小,单位(Byte)',
  PRIMARY KEY (`client_info_id`, `create_date_time`) USING BTREE,
  INDEX `info`(`digest_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for organization_info
-- ----------------------------
CREATE TABLE `organization_info`  (
  `id` bigint(20) NOT NULL COMMENT '企业信息ID',
  `name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '企业信息名称',
  `trans_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运输行业编码   按照 JT/T415-2006 中 5.2.1 的规定',
  `create_time` bigint(20) NOT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NOT NULL COMMENT '数据更新时间',
  `flag` int(5) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  `client_info_id` bigint(20) NOT NULL COMMENT '客户平台编号',
  `organization_zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业所属地',
  PRIMARY KEY (`id`, `client_info_id`) USING BTREE,
  UNIQUE INDEX `un_client_id`(`id`, `client_info_id`) USING BTREE,
  INDEX `no_name_flag`(`name`, `flag`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for platform_bind_monitor
-- ----------------------------
CREATE TABLE `platform_bind_monitor`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `monitor_id` bigint(20) UNSIGNED NOT NULL COMMENT '监控对象编号',
  `platform_id` bigint(20) UNSIGNED NOT NULL COMMENT '接入平台编号',
  `client_info_id` int(10) UNSIGNED NOT NULL COMMENT '客户编号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `un_bind_id`(`monitor_id`, `platform_id`, `client_info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for platform_bind_organization
-- ----------------------------
CREATE TABLE `platform_bind_organization`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `organization_id` bigint(20) UNSIGNED NOT NULL COMMENT '监控对象编号',
  `platform_id` bigint(20) UNSIGNED NOT NULL COMMENT '接入平台编号',
  `client_info_id` int(10) UNSIGNED NOT NULL COMMENT '客户编号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `un_bind_id`(`organization_id`, `platform_id`, `client_info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for professional_info
-- ----------------------------
CREATE TABLE `professional_info`  (
  `id` bigint(20) NOT NULL COMMENT '从业人员信息ID',
  `client_info_id` bigint(20) NOT NULL COMMENT '客户编号',
  `name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '从业人员信息名称',
  `link_man` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `tel_phone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `create_time` bigint(20) NOT NULL COMMENT '数据创建时间',
  `update_time` bigint(20) NOT NULL COMMENT '数据更新时间',
  `flag` int(5) NOT NULL DEFAULT 1 COMMENT '逻辑删除：1：正常数据 0：失效数据',
  PRIMARY KEY (`id`, `client_info_id`) USING BTREE,
  UNIQUE INDEX `un_client_id_pro`(`id`, `client_info_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for risk_type
-- ----------------------------
CREATE TABLE `risk_type`  (
  `id` bigint(10) NOT NULL COMMENT '风险类别id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '风险类别名称',
  `intervals_time` smallint(6) NOT NULL COMMENT '风险合并升级间隔时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `risk_type` VALUES (100, '超速报警', 60);
INSERT INTO `risk_type` VALUES (101, '疲劳驾驶', 60);
INSERT INTO `risk_type` VALUES (102, '碰撞危险', 50);
INSERT INTO `risk_type` VALUES (103, '注意力分散', 30);
INSERT INTO `risk_type` VALUES (104, '违规异常', 20);
INSERT INTO `risk_type` VALUES (105, '其他', 30);

