SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tbl_ads
-- ----------------------------
DROP TABLE IF EXISTS `tbl_ads`;
CREATE TABLE `tbl_ads` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `down_load_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '视频/图片地址',
  `link_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `video_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '视频图片',
  `position_id` int(16) NOT NULL DEFAULT '0' COMMENT '广告位id',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `city` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '展示城市',
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '广告名称',
  `platform` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '平台',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1：视频；2：图片',
  `people_tag_id` tinyint(3) NOT NULL DEFAULT '0' COMMENT '人群模板id',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '1启用0停用',
  `operator_user` int(10) DEFAULT NULL COMMENT '操作人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_ad_position`;
CREATE TABLE `tbl_ad_position` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告位id',
  `position_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '广告位名称',
  `position_desc` text COLLATE utf8_unicode_ci NOT NULL COMMENT '广告位描述',
  `position_type` tinyint(1) NOT NULL COMMENT '广告位类型（1：客户端；2：大屏端）',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态（0：暂停；1：开启）',
  `most_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '广告上限',
  `content_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '内容类型（1：视频；2：图片）',
  `operator_user` int(10) NOT NULL DEFAULT '0' COMMENT '操作者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_alipay_callback_info`;
CREATE TABLE `tbl_alipay_callback_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notify_time` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '通知时间',
  `notify_type` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '通知类型',
  `notify_id` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '通知校验ID',
  `app_id` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '支付宝分配给开发者的应用ID',
  `charset` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT 'CHARSET',
  `version` varchar(3) CHARACTER SET utf8 DEFAULT NULL COMMENT '接口版本',
  `sign_type` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '签名类型',
  `sign` varchar(256) CHARACTER SET utf8 DEFAULT NULL COMMENT '签名',
  `trade_no` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '支付宝交易号',
  `out_trade_no` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '商户订单号',
  `out_biz_no` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '商户业务号',
  `buyer_id` varchar(16) CHARACTER SET utf8 DEFAULT NULL COMMENT '买家支付宝用户号',
  `buyer_logon_id` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '买家支付宝账号',
  `seller_id` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '卖家支付宝用户号',
  `seller_email` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '卖家支付宝账号',
  `trade_status` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '交易状态',
  `total_amount` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单金额',
  `receipt_amount` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '实收金额',
  `invoice_amount` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开票金额',
  `buyer_pay_amount` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '付款金额',
  `point_amount` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '集分宝金额',
  `refund_fee` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '总退款金额',
  `subject` varchar(256) CHARACTER SET utf8 DEFAULT NULL COMMENT '订单标题',
  `body` varchar(256) CHARACTER SET utf8 DEFAULT NULL COMMENT '商品描述',
  `gmt_create` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交易创建时间',
  `gmt_payment` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交易付款时间',
  `gmt_refund` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交易退款时间',
  `gmt_close` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交易结束时间',
  `fund_bill_list` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '支付金额信息',
  `passback_params` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '回传参数',
  `voucher_detail_list` varchar(4) CHARACTER SET utf8 DEFAULT NULL COMMENT '优惠券信息',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='支付宝回调信息表';

DROP TABLE IF EXISTS `tbl_app_version_update`;
CREATE TABLE `tbl_app_version_update` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `platform` smallint(6) NOT NULL DEFAULT '0' COMMENT '上线系统 平台 1: ios, 2: android',
  `notice_type` smallint(6) NOT NULL DEFAULT '0' COMMENT '通知类型（1:强制 2:非强制）',
  `prompt` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '升级提示（不超过30个字）',
  `note` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `start_time` datetime NOT NULL COMMENT '生效开始时间	',
  `end_time` datetime NOT NULL COMMENT '生效结束时间',
  `download_url` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '安装包url',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `operator_id` int(11) NOT NULL COMMENT '创建人',
  `app_type` int(2) NOT NULL COMMENT '1:乘客端，2：司机端  3:车机端',
  `app_version` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'app版本号',
  `use_status` int(2) NOT NULL DEFAULT '1' COMMENT '启用停用状态，0：停用，1：启用',
  `version_code` int(11) NOT NULL DEFAULT '0' COMMENT '版本号code',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='乘客端,司机端，车机端app更新';


DROP TABLE IF EXISTS `tbl_base_info_company`;
CREATE TABLE `tbl_base_info_company` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(256) NOT NULL COMMENT '公司名称',
  `identifier` varchar(32) NOT NULL COMMENT '统一社会信用代码',
  `business_scope` varchar(256) NOT NULL COMMENT '经营范围',
  `contact_address` varchar(256) NOT NULL COMMENT '通信地址',
  `economic_type` varchar(128) NOT NULL COMMENT '经营业户经济类型',
  `reg_capital` varchar(128) NOT NULL COMMENT '注册资本',
  `legal_name` varchar(256) NOT NULL COMMENT '法人代表姓名',
  `legal_id` varchar(32) NOT NULL COMMENT '法人代表身份证号',
  `legal_phone` varchar(32) NOT NULL COMMENT '法人代表电话',
  `legal_photo` varchar(128) NOT NULL COMMENT '法人代表身份证扫描件文件编号',
  `state` int(1) NOT NULL COMMENT '状态0有效，1失效',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网约车平台公司基本信息';

DROP TABLE IF EXISTS `tbl_base_info_company_pay`;
CREATE TABLE `tbl_base_info_company_pay` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pay_name` varchar(256) NOT NULL COMMENT '银行或非银行支付机构名称',
  `pay_id` varchar(32) NOT NULL COMMENT '非银行支付机构支付业务许可证编号',
  `pay_type` varchar(64) NOT NULL COMMENT '支付业务类型',
  `pay_scope` varchar(64) NOT NULL COMMENT '业务覆盖范围',
  `prepare_bank` varchar(64) NOT NULL COMMENT '备付金存管银行',
  `count_date` int(10) NOT NULL COMMENT '结算周期（天）',
  `state` int(1) NOT NULL COMMENT '状态0有效，1失效',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网约车平台公司支付信息';

-- ----------------------------
-- Records of tbl_base_info_company_pay
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_base_info_company_permit
-- ----------------------------
DROP TABLE IF EXISTS `tbl_base_info_company_permit`;
CREATE TABLE `tbl_base_info_company_permit` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `certificate` varchar(64) NOT NULL COMMENT '网络预约出租汽车经营许可证号',
  `operation_area` varchar(128) NOT NULL COMMENT '经营区域',
  `owner_name` varchar(256) NOT NULL COMMENT '公司名称',
  `organization` varchar(256) NOT NULL COMMENT '发证机构名称',
  `start_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '有效期起',
  `stop_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '有效期止',
  `certify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '初次发证日期',
  `state` varchar(8) NOT NULL COMMENT '证照状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网约车平台公司经营许可证';

-- ----------------------------
-- Records of tbl_base_info_company_permit
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_base_info_company_service
-- ----------------------------
DROP TABLE IF EXISTS `tbl_base_info_company_service`;
CREATE TABLE `tbl_base_info_company_service` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(128) NOT NULL COMMENT '服务机构名称',
  `service_no` varchar(64) NOT NULL COMMENT '服务机构代码',
  `detail_address` varchar(128) NOT NULL COMMENT '服务机构地址',
  `responsible_name` varchar(64) NOT NULL COMMENT '服务机构负责人姓名',
  `responsible_phone` varchar(32) NOT NULL COMMENT '负责人联系电话',
  `manager_name` varchar(64) NOT NULL COMMENT '服务机构管理人姓名',
  `manager_phone` varchar(32) NOT NULL COMMENT '管理人联系电话',
  `contact_phone` varchar(32) NOT NULL COMMENT '服务机构紧急联系电话',
  `mail_address` varchar(128) NOT NULL COMMENT '行政文书送达邮寄地址',
  `create_date` datetime DEFAULT NULL COMMENT '服务机构设立日期',
  `state` int(1) DEFAULT NULL COMMENT '状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网约车平台公司服务机构';

-- ----------------------------
-- Records of tbl_base_info_company_service
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_call_records
-- ----------------------------
DROP TABLE IF EXISTS `tbl_call_records`;
CREATE TABLE `tbl_call_records` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `pool_key` varchar(64) DEFAULT NULL COMMENT '对应的号池Key',
  `sub_id` varchar(64) DEFAULT NULL COMMENT '通话对应的三元组的绑定关系ID',
  `call_id` varchar(64) DEFAULT NULL COMMENT '唯一标识一通通话记录的ID',
  `phone_no` varchar(64) DEFAULT NULL COMMENT 'AXB中的A号码',
  `secret_no` varchar(64) DEFAULT NULL COMMENT 'AXB中的X号码',
  `peer_no` varchar(64) DEFAULT NULL COMMENT 'AXB中的B号码或者N号码',
  `call_type` varchar(64) DEFAULT NULL COMMENT '呼叫类型\r\n0:主叫(phone_no打给peer_no)；1:被叫(peer_no打给phone_no)；2:短信发送；3:短信接收',
  `call_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '呼叫动作开始时间',
  `ring_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '对端手机振铃时间',
  `start_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '对端接听时间',
  `release_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '对端挂断时间，release_time - start_time 代表通话时长 如果结果为0,代表呼叫未接通',
  `release_dir` varchar(4) DEFAULT NULL COMMENT '通话释放方向',
  `release_cause` int(4) DEFAULT NULL COMMENT '释放原因\r\n1:未分配的号码\r\n2:无路由到指定的转接网\r\n3:无路由到目的地\r\n4:发送专用信息音\r\n16:正常的呼叫拆线\r\n17:用户忙\r\n18:用户未响应\r\n19:用户未应答\r\n20:用户缺席\r\n21:呼叫拒收\r\n22:号码改变\r\n27:目的地不可达\r\n28:无效的号码格式（地址不全）\r\n29:性能拒绝\r\n31:正常—未指定\r\n34: 无电路/通路可用\r\n42: 交换设备拥塞\r\n50:所请求的性能未预定\r\n53:CUG中限制去呼叫\r\n55: CUG中限制来呼叫\r\n57:承载能力无权\r\n58:承载能力目前不可用\r\n65:承载能力未实现\r\n69:所请求的性能未实现\r\n87:被叫用户不是CUG的成员\r\n88:不兼容的目的地\r\n90:不存在的CUG\r\n91:无效的转接网选择\r\n95:无效的消息，未指定\r\n97:消息类型不存在或未实现\r\n99:参数不存在或未实现\r\n102:定时器终了时恢复\r\n103:参数不存在或未实现—传递\r\n110:消息带有未被识别的参数—舍弃\r\n111:协议错误，未指定\r\n127:互通，未指定',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='通话记录表';

DROP TABLE IF EXISTS `tbl_car_base_info`;
CREATE TABLE `tbl_car_base_info` (
  `id` int(11) NOT NULL COMMENT '车辆id',
  `company_logo` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公司标识',
  `car_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆厂牌',
  `car_base_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆类型',
  `car_owner` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆所有人',
  `plate_color` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车牌颜色',
  `engine_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '发动机号电动机号',
  `car_brain_plate` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车脑品牌',
  `car_brain_number` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车脑编号',
  `vin_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'vin码',
  `register_time` date DEFAULT NULL COMMENT '注册日期',
  `fuel_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '燃料类型',
  `engine_capacity` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '发动机排量',
  `car_img_file_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆照片文件编号',
  `transport_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '运输证字号',
  `transport_issuing_authority` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆运输证发证机构',
  `business_area` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '经营区域',
  `transport_certificate_validity_start` date DEFAULT NULL COMMENT '车辆运输证有效期起',
  `transport_certificate_validity_end` date DEFAULT NULL COMMENT '车辆运输证有效期止',
  `first_register_time` date DEFAULT NULL COMMENT '车辆初次登记日期',
  `state_of_repair` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆检修状态',
  `next_annual_inspection_time` date DEFAULT NULL COMMENT '下次年检时间',
  `annual_audit_status` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '年度审核状态',
  `invoice_printing_equipment_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '发票打印设备序列号',
  `gps_brand` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '卫星定位装置品牌',
  `gps_model` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '型号',
  `gps_imei` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'imei',
  `gps_install_time` date DEFAULT NULL COMMENT '安装日期',
  `report_time` date DEFAULT NULL COMMENT '报备日期',
  `service_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '服务类型',
  `charge_type_code` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '运价类型编码',
  `car_invoice_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆发票',
  `quality_certificate_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '合格证',
  `vehicle_license_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '行驶证',
  `registration_certificate_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '登记证书',
  `tax_payment_certificate_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '完税证明',
  `transport_certificate_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '汽车运输证',
  `other_img1` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '其他一',
  `other_img2` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '其他二',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_car_bind_change_record`;
CREATE TABLE `tbl_car_bind_change_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `car_info_id` int(10) unsigned NOT NULL COMMENT '车辆ID',
  `bind_tag` varchar(30) NOT NULL COMMENT '绑定类型',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间',
  `bind_value` varchar(500) NOT NULL COMMENT '绑定内容',
  `bind_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0绑定,1解绑',
  `operator_id` int(10) unsigned NOT NULL COMMENT '操作人ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='车辆绑定信息变更表';

DROP TABLE IF EXISTS `tbl_car_brand`;
CREATE TABLE `tbl_car_brand` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '车辆品牌ID',
  `brand` varchar(16) NOT NULL DEFAULT '' COMMENT '车辆品牌',
  `model` varchar(30) NOT NULL DEFAULT '' COMMENT '车辆型号',
  `seats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '标准座位数量',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0：未删除，1：已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `tbl_car_dispatch_capacity_set`;
CREATE TABLE `tbl_car_dispatch_capacity_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `car_service_period` tinyint(1) NOT NULL DEFAULT '0' COMMENT '车辆服务时段 1白天2夜晚',
  `spare_driver_count` int(10) NOT NULL DEFAULT '0' COMMENT '空闲司机数量',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='车辆调度运力设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_direct_route_order_radius_set`;
CREATE TABLE `tbl_car_dispatch_direct_route_order_radius_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '服务类型id',
  `direct_route_order_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '顺风单类型 1回家单 2接力单 3特殊时段预约单',
  `direct_route_order_radius` int(10) NOT NULL DEFAULT '0' COMMENT '顺风单半径（公里）',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0未删除 1已删除',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='车辆调度顺风单半径设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_distribute_interval_set`;
CREATE TABLE `tbl_car_dispatch_distribute_interval_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '服务类型id',
  `car_service_before_interval` int(10) NOT NULL DEFAULT '0' COMMENT '用车服务前间隔（分钟）',
  `car_service_after_interval` int(10) NOT NULL DEFAULT '0' COMMENT '用车服务后间隔（分钟）',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='车辆调度派单间隔设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_distribute_radius_set`;
CREATE TABLE `tbl_car_dispatch_distribute_radius_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '服务类型id',
  `min_radius` int(10) NOT NULL DEFAULT '0' COMMENT '最小派单半径（公里）',
  `min_radius_first_push_driver_count` int(10) NOT NULL DEFAULT '0' COMMENT '最小派单半径首次推送司机数量',
  `max_radius` int(10) NOT NULL DEFAULT '0' COMMENT '最大派单半径（公里）',
  `max_radius_first_push_driver_count` int(10) NOT NULL DEFAULT '0' COMMENT '最大派单半径首次推送司机数量',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='车辆调度派单半径设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_distribute_set`;
CREATE TABLE `tbl_car_dispatch_distribute_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `is_force_distribute` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开启强派 0不开启 1开启',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='车辆调度派发设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_special_period_set`;
CREATE TABLE `tbl_car_dispatch_special_period_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL,
  `time_period` varchar(255) NOT NULL DEFAULT '' COMMENT '时段设置',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0未删除 1已删除',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='车辆调度特殊时段设置';


DROP TABLE IF EXISTS `tbl_car_dispatch_time_threshold_set`;
CREATE TABLE `tbl_car_dispatch_time_threshold_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '服务类型id',
  `time_threshold_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '时间阈值类型 1开启立即用车派单逻辑 2预约用车待派订单开启强派模式',
  `time_threshold` int(10) NOT NULL DEFAULT '0' COMMENT '时间阈值（分钟）',
  `operator_id` int(10) DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='车辆调度时间阈值设置';


DROP TABLE IF EXISTS `tbl_car_driver_bind_record`;
CREATE TABLE `tbl_car_driver_bind_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_info_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '司机ID',
  `car_info_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '车辆ID',
  `operator_user` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'system',
  `type` int(11) NOT NULL COMMENT '1绑定0解绑',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bind_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '绑定时间',
  `unbind_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '解绑时间',
  `total_mile` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '车辆总里程',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `tbl_car_info`;
CREATE TABLE `tbl_car_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '车辆id',
  `plate_number` varchar(16) NOT NULL DEFAULT '' COMMENT '车牌号',
  `operation_status` int(2) NOT NULL DEFAULT '0' COMMENT '运营状态：-1，删除 0，上架 1，下架 2，待整备',
  `publish_time` datetime DEFAULT NULL COMMENT '上架时间',
  `full_name` varchar(64) NOT NULL DEFAULT '' COMMENT '车辆全名',
  `color` varchar(30) NOT NULL DEFAULT '' COMMENT '车身颜色',
  `car_img` varchar(256) NOT NULL DEFAULT '' COMMENT '汽车图片',
  `city_code` varchar(32) NOT NULL DEFAULT '' COMMENT '城市',
  `car_type_id` int(16) unsigned NOT NULL DEFAULT '0' COMMENT '车辆类型',
  `car_level_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '车辆级别',
  `regist_date` datetime DEFAULT NULL COMMENT '上牌日期',
  `insurance_start_date` datetime DEFAULT NULL COMMENT '保险生效日期',
  `insurance_end_date` datetime DEFAULT NULL COMMENT '保险失效日期',
  `annual_end_date` datetime DEFAULT NULL COMMENT '年检到期日期',
  `car_license_img` varchar(256) NOT NULL DEFAULT '' COMMENT '行驶本图片地址',
  `is_free_order` int(2) DEFAULT '0' COMMENT '是否开启顺风单0：停用，1：启用',
  `remark` varchar(256) NOT NULL DEFAULT '' COMMENT '备注',
  `use_status` int(2) NOT NULL DEFAULT '0' COMMENT '启用停用状态，0：停用，1：启用',
  `large_screen_device_code` varchar(256) NOT NULL DEFAULT '' COMMENT '大屏编号',
  `large_screen_device_brand` varchar(64) NOT NULL DEFAULT '' COMMENT '大屏品牌名称',
  `car_screen_device_code` varchar(256) NOT NULL DEFAULT '' COMMENT '车机/脑设备号',
  `car_screen_device_brand` varchar(64) NOT NULL DEFAULT '' COMMENT '车机/脑品牌名称',
  `operator_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `total_mile` int(11) NOT NULL DEFAULT '0' COMMENT '行驶总里程单位：km',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_car_level`;
CREATE TABLE `tbl_car_level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(30) NOT NULL DEFAULT '' COMMENT '车辆级别标签',
  `icon` varchar(500) NOT NULL DEFAULT '' COMMENT '车型图标',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `operator_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `enable` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '状态:0未启用1启用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='车辆级别列表';


DROP TABLE IF EXISTS `tbl_car_machine_info_record`;
CREATE TABLE `tbl_car_machine_info_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `car_device_code` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '设备唯一号',
  `mileage` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '累计总里程,km',
  `sub_mileage` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '累计分里程',
  `is_ns` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '南纬或北纬  n或s',
  `latitude` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '纬度',
  `is_ew` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '是否东经西经 e或w',
  `longitude` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '经度',
  `qf` int(2) NOT NULL DEFAULT '0' COMMENT '质量因子',
  `satellite_num` int(8) NOT NULL DEFAULT '0' COMMENT '可使用卫星数量',
  `accuracy` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '精度，米',
  `gps_accuracy_status` int(2) NOT NULL DEFAULT '0' COMMENT '卫星信号强度',
  `elevation` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '海拔',
  `direction` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '方向',
  `surplus_distance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '剩余续航里程',
  `parking_sw` int(2) NOT NULL DEFAULT '0' COMMENT '手刹开关',
  `key_pos` int(2) NOT NULL DEFAULT '0' COMMENT '钥匙位置',
  `sw_gear` int(2) NOT NULL DEFAULT '0' COMMENT '档位信号',
  `brk_sta` int(2) NOT NULL DEFAULT '0' COMMENT '制动踏板位置',
  `car_speed` int(10) NOT NULL DEFAULT '0' COMMENT '瞬时车速',
  `ev_soc` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '剩余电量',
  `limt_speed` int(10) NOT NULL DEFAULT '0' COMMENT '整车最大车速',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of tbl_car_machine_info_record
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_car_screen_driver
-- ----------------------------
DROP TABLE IF EXISTS `tbl_car_screen_driver`;
CREATE TABLE `tbl_car_screen_driver` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `driver_id` int(16) NOT NULL COMMENT '司机id',
  `car_screen_code` varchar(128) NOT NULL DEFAULT '' COMMENT '汽车屏幕唯一码',
  `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '登录时间',
  `logout_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '登出时间',
  `login_status` int(2) NOT NULL COMMENT '登录状态：1：登录，2：退出登录',
  `repair_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '修复登出时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tbl_car_screen_driver
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_car_type
-- ----------------------------
DROP TABLE IF EXISTS `tbl_car_type`;
CREATE TABLE `tbl_car_type` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `brand` varchar(30) NOT NULL DEFAULT '' COMMENT '品牌',
  `model` varchar(30) NOT NULL DEFAULT '' COMMENT '型号',
  `seats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '座位数量',
  `city` varchar(30) NOT NULL DEFAULT '' COMMENT '城市',
  `type_desc` varchar(60) NOT NULL DEFAULT '',
  `img_url` varchar(500) NOT NULL DEFAULT '' COMMENT '车型图片地址',
  `status` int(2) NOT NULL DEFAULT '0' COMMENT '0：未启用，1：已启用',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '录入时间',
  `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `operator_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `tbl_channel`;
CREATE TABLE `tbl_channel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_name` varchar(64) NOT NULL COMMENT '渠道名称',
  `channel_status` int(2) NOT NULL DEFAULT '0' COMMENT '渠道开启暂停状态 1开启 0暂停',
  `operator_id` int(11) NOT NULL COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=300005 DEFAULT CHARSET=utf8 COMMENT='渠道管理表';


DROP TABLE IF EXISTS `tbl_charge_rule`;
CREATE TABLE `tbl_charge_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `city_code` varchar(32) NOT NULL DEFAULT '' COMMENT '城市编码',
  `service_type_id` int(10) NOT NULL COMMENT '服务类型',
  `channel_id` int(10) NOT NULL COMMENT '渠道名称',
  `car_level_id` int(10) NOT NULL COMMENT '车辆级别',
  `lowest_price` double(10,2) NOT NULL COMMENT '基础价',
  `base_price` double(10,2) NOT NULL COMMENT '起步价',
  `base_kilo` double(10,2) NOT NULL COMMENT '基础价格包含公里数',
  `base_minutes` double(10,2) NOT NULL COMMENT '基础价格包含时长数(分钟)',
  `per_kilo_price` double(10,2) NOT NULL COMMENT '超公里单价(每公里单价)',
  `per_minute_price` double(10,2) NOT NULL COMMENT '超时间单价(每分钟单价)',
  `beyond_start_kilo` double(10,2) NOT NULL COMMENT '远途起算公里',
  `beyond_per_kilo_price` double(10,2) NOT NULL COMMENT '远途单价',
  `night_start` time DEFAULT NULL COMMENT '夜间时间段开始',
  `night_end` time DEFAULT NULL COMMENT '夜间时间段结束',
  `night_per_kilo_price` double(10,2) DEFAULT NULL COMMENT '夜间超公里加收单价',
  `night_per_minute_price` double(10,2) DEFAULT NULL COMMENT '夜间超时间加收单价',
  `effective_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '生效时间',
  `active_status` int(11) NOT NULL DEFAULT '0' COMMENT '生效状态 0已失效 1未失效',
  `is_unuse` int(11) NOT NULL DEFAULT '0' COMMENT '是否不可用 0可用 1不可用',
  `creator_id` int(10) NOT NULL DEFAULT '0' COMMENT '创建人id',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='计费规则表';


DROP TABLE IF EXISTS `tbl_charge_rule_detail`;
CREATE TABLE `tbl_charge_rule_detail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rule_id` int(10) NOT NULL,
  `start` int(2) NOT NULL COMMENT '时间段开始',
  `end` int(2) NOT NULL COMMENT '时间段结束',
  `per_kilo_price` double(10,2) NOT NULL COMMENT '超公里单价',
  `per_minute_price` double(10,2) NOT NULL COMMENT '超时间单价',
  `is_delete` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除 0未删除 1已删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='计费规则时间段表';


DROP TABLE IF EXISTS `tbl_city`;
CREATE TABLE `tbl_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_name` varchar(64) NOT NULL COMMENT '城市名称',
  `city_code` varchar(32) NOT NULL COMMENT '城市编码',
  `city_longitude_latitude` varchar(64) NOT NULL COMMENT '城市中心经纬度',
  `order_risk_top` int(4) NOT NULL COMMENT '下单风险上限值',
  `city_status` int(2) NOT NULL DEFAULT '0' COMMENT '是否开通 0未开通 1开通',
  `operator_id` int(11) NOT NULL COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `city_code` (`city_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='城市表';


DROP TABLE IF EXISTS `tbl_coupon`;
CREATE TABLE `tbl_coupon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '优惠券id',
  `status` int(4) unsigned NOT NULL DEFAULT '1' COMMENT '优惠券状态 0:禁用, 1:启用',
  `coupon_name` varchar(60) NOT NULL COMMENT '优惠券名称',
  `coupon_desc` varchar(250) NOT NULL DEFAULT '' COMMENT '优惠券描述',
  `coupon_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '优惠方式 1:现金券, 3:专项券-免费送车券, 4:专项券-免费还车券 2:折扣券',
  `coupon_class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券类型ID',
  `coupon_class_name` varchar(60) NOT NULL DEFAULT '' COMMENT '优惠券类型名称',
  `get_method` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1,主动发放. 2,用户获取',
  `minimum_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单最低金额',
  `reduction_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '减免金额 仅现金券有此项',
  `maximum_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最高抵扣金额',
  `discount` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '折扣比例',
  `effective_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '有效期类型 1：天数 ，2：时间段',
  `effective_day` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '有效期天数',
  `enable_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '有效期开始时间',
  `expire_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '有效期结束时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user` varchar(30) NOT NULL DEFAULT '' COMMENT '创建用户',
  `function_type` int(4) NOT NULL DEFAULT '1' COMMENT '功能类型 1:市场活动, 2:订单赔付',
  `total_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总数量',
  `get_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已获取',
  `used_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已使用',
  `operator_id` int(10) unsigned DEFAULT '0' COMMENT '操作人ID',
  PRIMARY KEY (`id`),
  KEY `inx_fuction_type` (`function_type`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='优惠券配置表';

DROP TABLE IF EXISTS `tbl_coupon_activity`;
CREATE TABLE `tbl_coupon_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `activity_no` varchar(30) NOT NULL DEFAULT '' COMMENT '方案编号',
  `activity_name` varchar(30) NOT NULL DEFAULT '' COMMENT '方案名称',
  `enable_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '活动开始时间',
  `expire_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间',
  `activity_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '优惠形式',
  `coupon_rule` varchar(250) NOT NULL DEFAULT '' COMMENT '领券规则',
  `activity_desc` varchar(250) NOT NULL DEFAULT '' COMMENT '活动描述',
  `get_times` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '领券次数',
  `send_times` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发送次数',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '最后变更人id',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '0冻结1正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='营销方案表';


DROP TABLE IF EXISTS `tbl_coupon_class`;
CREATE TABLE `tbl_coupon_class` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '优惠方式:1现金券,2折扣券',
  `coupon_name` varchar(30) NOT NULL DEFAULT '' COMMENT '优惠券名称',
  `reduction_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '抵扣金额',
  `discount` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '折扣比例(8, 7.5)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '最后修改人id',
  `is_pause` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '暂停:0否1是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='优惠券类型表';

DROP TABLE IF EXISTS `tbl_coupon_conditions`;
CREATE TABLE `tbl_coupon_conditions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  `hour_set` varchar(80) NOT NULL DEFAULT '' COMMENT '小时集合',
  `week_set` varchar(15) NOT NULL DEFAULT '' COMMENT '周集合',
  `date_set` varchar(80) NOT NULL DEFAULT '' COMMENT '日期集合',
  `city_set` varchar(1023) NOT NULL DEFAULT '' COMMENT '城市集合',
  `car_set` varchar(60) NOT NULL DEFAULT '' COMMENT '车辆类型集合',
  `service_set` varchar(30) NOT NULL DEFAULT '' COMMENT '服务集合',
  `level_set` varchar(30) NOT NULL DEFAULT '',
  `hour_raw` varchar(120) NOT NULL DEFAULT '' COMMENT '时段原始数据',
  `date_raw` varchar(120) NOT NULL DEFAULT '' COMMENT '日期原始数据',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='优惠券使用条件限制表';


DROP TABLE IF EXISTS `tbl_coupon_send_info`;
CREATE TABLE `tbl_coupon_send_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `send_num` int(11) NOT NULL COMMENT '发放数量',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `operator_user` varchar(64) NOT NULL COMMENT '操作用户',
  `get_num` int(11) NOT NULL COMMENT '领取数量',
  `use_num` int(11) NOT NULL COMMENT '使用数量',
  `coupon_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `img_url` varchar(128) NOT NULL,
  `message` varchar(256) NOT NULL,
  `send_list` varchar(5120) NOT NULL,
  `send_time` datetime NOT NULL,
  `send_status` int(11) NOT NULL,
  `description` varchar(1024) NOT NULL COMMENT '优惠券文案',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `tbl_coupon_task`;
CREATE TABLE `tbl_coupon_task` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  `coupon_name` varchar(30) NOT NULL DEFAULT '' COMMENT '优惠券名称',
  `number` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '发放数量',
  `task_tag` varchar(30) NOT NULL DEFAULT '' COMMENT '任务标签,用于区分不同批次',
  `people_tag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '人群模板ID',
  `task_target` varchar(1280) NOT NULL DEFAULT '' COMMENT '任务目标,最多100个手机号',
  `app_tpl_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'app文案模板ID',
  `sms_tpl_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '短信文案模板ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `task_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '任务状态:0未开始1进行中2完成',
  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_cancel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否终止:0否,1是',
  `plan_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '计划发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='优惠券发送任务表';

DROP TABLE IF EXISTS `tbl_device_blacklist`;
CREATE TABLE `tbl_device_blacklist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `device_type` char(1) NOT NULL DEFAULT '' COMMENT '1 android 2 ios3 other',
  `device_code` varchar(64) NOT NULL DEFAULT '' COMMENT '手机设备串码',
  `last_login_time` timestamp NULL DEFAULT NULL COMMENT '最后一次登录时间',
  `is_release` tinyint(11) unsigned NOT NULL DEFAULT '0' COMMENT '1 解禁，0 未解禁',
  `phones` mediumtext COMMENT '欠款手机号',
  `memo` mediumtext NOT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='设备黑名单';

DROP TABLE IF EXISTS `tbl_dictionary`;
CREATE TABLE `tbl_dictionary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `dic_parentid` int(10) NOT NULL COMMENT '父id',
  `dic_type` varchar(100) NOT NULL DEFAULT '' COMMENT '类型',
  `dic_name` varchar(50) NOT NULL DEFAULT '',
  `dic_value` varchar(200) NOT NULL DEFAULT '' COMMENT '值',
  `dic_desc` varchar(200) NOT NULL DEFAULT '' COMMENT '描述',
  `dic_order` int(5) unsigned NOT NULL COMMENT '排序',
  `dic_status` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `typeindex` (`dic_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典表';

-- ----------------------------
-- Records of tbl_dictionary
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_driver_address
-- ----------------------------
DROP TABLE IF EXISTS `tbl_driver_address`;
CREATE TABLE `tbl_driver_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_id` int(11) unsigned NOT NULL COMMENT '司机id',
  `address` varchar(120) NOT NULL DEFAULT '' COMMENT '详细地址',
  `address_longitude` varchar(32) NOT NULL DEFAULT '' COMMENT '地址经度',
  `address_latitude` varchar(32) NOT NULL DEFAULT '' COMMENT '地址纬度',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  `tag` varchar(15) NOT NULL DEFAULT '' COMMENT '标签',
  `is_default` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否默认地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='司机顺风地址记录表';

DROP TABLE IF EXISTS `tbl_driver_advice`;
CREATE TABLE `tbl_driver_advice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `driver_id` int(10) NOT NULL DEFAULT '0' COMMENT '司机id',
  `advice_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '反馈类型',
  `advice_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '反馈内容',
  `phone` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '司机电话',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_driver_base_info`;
CREATE TABLE `tbl_driver_base_info` (
  `id` int(11) NOT NULL,
  `mobile_operator` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '手机运营商',
  `company_logo` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公司标识',
  `administrative_code` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '注册行政地区代码',
  `birthday` date DEFAULT NULL COMMENT '驾驶员出生日期',
  `country` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '国籍',
  `national` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '驾驶员民族',
  `driving_licence_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '驾驶证编号',
  `marital_status` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '婚姻状况',
  `foreign_language_ability` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '外语能力',
  `app_version` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '使用APP版本号',
  `map_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '使用地图类型',
  `education_background` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '驾驶员学历',
  `household_registration_authority` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '户口   登记机关名称',
  `registered_permanent_residence_address` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '户口   住址',
  `address` varchar(736) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '现居地址',
  `address_longitude` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '现居地址经度',
  `address_latitude` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '现居地址纬度',
  `driver_img_file_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '驾驶员照片文件编号',
  `driver_license` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '机动车驾驶员证',
  `driver_license_scan_copy_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '机动车驾驶证扫描件文件编号',
  `driving_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '准驾车型',
  `first_get_driver_license_date` datetime DEFAULT NULL COMMENT '初次领取驾驶证日期',
  `driver_license_validity_start` datetime DEFAULT NULL COMMENT '驾驶证有效期起',
  `driver_license_validity_end` datetime DEFAULT NULL COMMENT '驾驶证有效期止',
  `is_taxi_driver` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '是否巡游出租车驾驶员',
  `network_reservation_taxi_driver_license_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '网络预约出租汽车驾驶员证号',
  `network_reservation_taxi_driver_license_issuing_agencies` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '网络预约出租汽车驾驶员证发证机构',
  `certificate_issuing_date` datetime DEFAULT NULL COMMENT '资格证发证日期',
  `first_qualification_date` datetime DEFAULT NULL COMMENT '初次领取资格证日期',
  `qualification_certificate_validity_start` datetime DEFAULT NULL COMMENT '资格证有效期起',
  `qualification_certificate_validity_end` datetime DEFAULT NULL COMMENT '资格证有效期止',
  `reported_date` datetime DEFAULT NULL COMMENT '报备日期',
  `is_full_time_driver` int(11) NOT NULL DEFAULT '0' COMMENT '是否专职驾驶员',
  `is_in_driver_blacklist` int(11) NOT NULL DEFAULT '0' COMMENT '是否在黑名单',
  `service_type` int(11) NOT NULL DEFAULT '0' COMMENT '服务类型',
  `company` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '驾驶员合同（或协议）签署公司',
  `contract_start_date` datetime DEFAULT NULL COMMENT '合同开始时间',
  `contract_end_date` datetime DEFAULT NULL COMMENT '合同结束时间',
  `emergency_contact` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '紧急联系人',
  `emergency_contact_phone_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '紧急联系人电话',
  `emergency_contact_address` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '紧急联系人地址',
  `training_courses` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '培训课名称',
  `training_courses_date` datetime DEFAULT NULL COMMENT '培训课程日期',
  `training_courses_start_date` datetime DEFAULT NULL COMMENT '培训开始日期',
  `training_courses_end_date` datetime DEFAULT NULL COMMENT '培训结束日期',
  `training_courses_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '培训时长',
  `bank_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '开户行',
  `bank_card_number` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '银行卡号',
  `note` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `qualification_certificate_img` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '从业资格证照片',
  `other_img1` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '其他一',
  `other_img2` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '其他二',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_driver_bind_change_record`;
CREATE TABLE `tbl_driver_bind_change_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_info_id` int(10) unsigned NOT NULL COMMENT '司机ID',
  `bind_tag` varchar(30) NOT NULL COMMENT '绑定类型',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间',
  `bind_value` varchar(500) NOT NULL COMMENT '绑定内容',
  `bind_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0绑定,1解绑',
  `operator_id` int(10) unsigned NOT NULL COMMENT '操作人ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 COMMENT='司机绑定信息变更表';

DROP TABLE IF EXISTS `tbl_driver_income_detail`;
CREATE TABLE `tbl_driver_income_detail` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `driver_info_id` int(16) unsigned NOT NULL DEFAULT '0',
  `order_no` varchar(32) NOT NULL DEFAULT '',
  `order_money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `driver_ratio` decimal(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_driver_info`;
CREATE TABLE `tbl_driver_info` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(32) NOT NULL DEFAULT '' COMMENT '司机手机号',
  `driver_leader` int(11) unsigned DEFAULT '0' COMMENT '司机主管',
  `driver_name` varchar(16) NOT NULL DEFAULT '' COMMENT '司机姓名',
  `register_time` datetime DEFAULT NULL COMMENT '注册时间',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `gender` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `car_id` int(16) unsigned DEFAULT NULL COMMENT '车辆id',
  `is_following` int(1) NOT NULL DEFAULT '0' COMMENT '是否是顺风单0否 1是',
  `work_status` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '司机工作状态\r\n0：非出车状态，\r\n1：出车，未接订单，\r\n2：出车，接到订单,\r\n3：暂停接单',
  `head_img` varchar(256) NOT NULL DEFAULT '' COMMENT '司机头像',
  `city_code` varchar(8) NOT NULL DEFAULT '' COMMENT '城市代码',
  `bind_time` datetime DEFAULT NULL COMMENT '绑定时间',
  `use_status` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '启用停用状态，0：停用，1：启用',
  `cs_work_status` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '车机工作状态\r\n0：车机未登录登录\r\n1：车机登录\r\n2：车机听单\r\n3：车机暂停听单\r\n4：车机收车\r\n\r\n',
  `sign_status` int(2) NOT NULL DEFAULT '1' COMMENT '1：已签约，0：已解约',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='司机信息表';

DROP TABLE IF EXISTS `tbl_driver_licence_info`;
CREATE TABLE `tbl_driver_licence_info` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '审核记录id',
  `driver_id` int(16) NOT NULL DEFAULT '0' COMMENT '司机id',
  `main_driving_license` varchar(256) NOT NULL DEFAULT '' COMMENT '驾照主页照片地址',
  `vice_driving_license` varchar(256) NOT NULL DEFAULT '' COMMENT '驾照副页照片地址',
  `all_driving_license` varchar(256) NOT NULL DEFAULT '' COMMENT '驾照正副页照片地址',
  `group_driving_license` varchar(256) NOT NULL DEFAULT '' COMMENT '手持驾照照片地址',
  `identity_card_id` varchar(32) NOT NULL DEFAULT '' COMMENT '身份证',
  `main_idcard_license` varchar(256) NOT NULL DEFAULT '' COMMENT '身份证正面照',
  `vice_idcard_license` varchar(256) NOT NULL DEFAULT '' COMMENT '身份证副页照片地址',
  `group_idcard_license` varchar(256) NOT NULL DEFAULT '' COMMENT '手持身份证照片',
  `plate_number` varchar(16) NOT NULL DEFAULT '' COMMENT '车牌号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `fk_reference_2` (`driver_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='司机驾驶证信息';

DROP TABLE IF EXISTS `tbl_driver_message`;
CREATE TABLE `tbl_driver_message` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `passenger_id` int(16) unsigned NOT NULL DEFAULT '0',
  `driver_id` int(16) NOT NULL DEFAULT '0',
  `content` varchar(256) NOT NULL DEFAULT '',
  `is_delete` int(2) NOT NULL DEFAULT '0' COMMENT '1:删除，0：未删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `if_success` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否发送成功',
  `order_id` varchar(32) NOT NULL DEFAULT '' COMMENT '订单id',
  `message_type` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型',
  `message_channel` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '1：极光推送，2：短信',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `tbl_driver_order_message_statistical`;
CREATE TABLE `tbl_driver_order_message_statistical` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `driver_id` int(10) NOT NULL COMMENT '司机Id',
  `driving_licence_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '机动车驾驶证编号',
  `cycle` varchar(255) NOT NULL COMMENT '统计周期 格式为YYYYMM',
  `order_count` int(10) NOT NULL COMMENT '完成订单数',
  `traffic_violations_count` int(32) NOT NULL DEFAULT '0' COMMENT '交通违章次数',
  `complained_count` int(32) NOT NULL DEFAULT '0' COMMENT '被投诉次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='司机订单及其它信息统计';


DROP TABLE IF EXISTS `tbl_driver_punish`;
CREATE TABLE `tbl_driver_punish` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `driver_id` int(10) NOT NULL COMMENT '司机id',
  `punish_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '处罚时间',
  `punish_reason` varchar(128) NOT NULL COMMENT '处罚原因',
  `punish_result` varchar(128) NOT NULL COMMENT '处罚结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='司机处罚表';


DROP TABLE IF EXISTS `tbl_driver_rate`;
CREATE TABLE `tbl_driver_rate` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `driver_id` int(10) NOT NULL COMMENT '司机ID',
  `grade` int(2) NOT NULL DEFAULT '0' COMMENT '等级',
  `test_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '考核日期',
  `test_department` varchar(255) NOT NULL DEFAULT '' COMMENT '考核机构',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='驾驶员荣誉信息表';


DROP TABLE IF EXISTS `tbl_driver_work_time`;
CREATE TABLE `tbl_driver_work_time` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `driver_id` int(10) unsigned NOT NULL COMMENT '司机id',
  `work_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '工作开始时间',
  `work_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '工作结束时间',
  `work_duration` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '此次工作时长',
  `work_day` date NOT NULL DEFAULT '0000-00-00' COMMENT '工作日',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='司机工作时间';


DROP TABLE IF EXISTS `tbl_dynamic_discount_city`;
CREATE TABLE `tbl_dynamic_discount_city` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `dynamic_discount_rule_id` int(10) NOT NULL DEFAULT '0' COMMENT '动态折扣关联id',
  `city_code` varchar(32) NOT NULL DEFAULT '' COMMENT '城市编码',
  `is_delete` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0不删除 1删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='动态调价城市表';


DROP TABLE IF EXISTS `tbl_dynamic_discount_info`;
CREATE TABLE `tbl_dynamic_discount_info` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `dynamic_discount_rule_id` int(10) NOT NULL DEFAULT '0' COMMENT '动态折扣关联id',
  `km` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '里程',
  `discount` double(3,2) NOT NULL DEFAULT '0.00' COMMENT '折扣',
  `is_delete` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0不删除 1删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='动态折扣信息表';


DROP TABLE IF EXISTS `tbl_dynamic_discount_rule`;
CREATE TABLE `tbl_dynamic_discount_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `service_type` varchar(255) NOT NULL DEFAULT '' COMMENT '服务类型',
  `car_level` varchar(255) NOT NULL DEFAULT '' COMMENT '车辆级别',
  `time_set` varchar(255) NOT NULL DEFAULT '' COMMENT '时段设置',
  `date_type` int(1) NOT NULL DEFAULT '0' COMMENT '日期类型 1星期 2特殊日期',
  `week_set` varchar(255) NOT NULL DEFAULT '' COMMENT '星期设置',
  `special_date_set` varchar(255) NOT NULL DEFAULT '' COMMENT '特殊日期设置',
  `discount_max_price` double(8,2) NOT NULL DEFAULT '0.00' COMMENT '折扣封顶金额',
  `valid_start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '生效开始时间',
  `valid_end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '生效结束时间',
  `is_unuse` int(1) NOT NULL DEFAULT '0' COMMENT '是否不可用 0可用 1不可用',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='动态折扣规则表';


DROP TABLE IF EXISTS `tbl_evaluate_driver`;
CREATE TABLE `tbl_evaluate_driver` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `grade` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '分数',
  `content` varchar(500) NOT NULL DEFAULT '' COMMENT '评价内容',
  `order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
  `passenger_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '乘客ID',
  `driver_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '司机ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户的订单评价表';

DROP TABLE IF EXISTS `tbl_feedback`;
CREATE TABLE `tbl_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `user_name` varchar(100) DEFAULT '',
  `phone` varchar(64) NOT NULL,
  `terminal` char(255) NOT NULL DEFAULT '' COMMENT '端\r\n1:乘客\r\n2,司机\r\n3,车机\r\n4,大屏',
  `category` char(255) NOT NULL DEFAULT '' COMMENT '问题类型',
  `content` varchar(255) DEFAULT NULL COMMENT '反馈内容 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='用户反馈记录表';

DROP TABLE IF EXISTS `tbl_fence_info`;
CREATE TABLE `tbl_fence_info` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gid` varchar(70) NOT NULL DEFAULT '' COMMENT '高德ID',
  `city_code` varchar(70) NOT NULL DEFAULT '' COMMENT '城市编码',
  `fence_name` varchar(70) NOT NULL DEFAULT '' COMMENT '围栏名称',
  `valid_start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '生效开始时间',
  `valid_end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '生效结束时间',
  `is_deny` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用 0未禁用 1已禁用',
  ` is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0未删除 1已删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='围栏管理';


DROP TABLE IF EXISTS `tbl_flight_number`;
CREATE TABLE `tbl_flight_number` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `flight_number` varchar(30) DEFAULT NULL COMMENT '航班号',
  `flight_date` date NOT NULL COMMENT '航班日期',
  `passenger_info_id` int(11) unsigned NOT NULL,
  `start_code` char(3) DEFAULT NULL COMMENT '起点code',
  `end_code` char(3) DEFAULT NULL COMMENT '终点code',
  `is_subscribe` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否订阅：1订阅，0取消订阅',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建记录日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='用户航班号';

DROP TABLE IF EXISTS `tbl_invoice_record`;
CREATE TABLE `tbl_invoice_record` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '发票ID',
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '乘客ID',
  `order_id_list` varchar(512) NOT NULL COMMENT '订单list，逗号分隔',
  `invoice_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '发票总价',
  `invoice_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1：待开票（申请开票）,\r\n2：待邮寄,\r\n3：已邮寄,\r\n4：已撤销,',
  `invoice_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发票类型：1：普票，2：专票',
  `invoice_body` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发票主体：1：个人，2：企业',
  `invoice_title` varchar(128) NOT NULL DEFAULT '' COMMENT '发票抬头',
  `invoice_content` varchar(128) NOT NULL DEFAULT '' COMMENT '发票内容',
  `taxpayer_id` varchar(32) NOT NULL DEFAULT '' COMMENT '纳税人识别号',
  `reg_address` varchar(256) NOT NULL DEFAULT '' COMMENT '注册地址',
  `reg_phone` varchar(32) NOT NULL DEFAULT '' COMMENT '注册电话',
  `deposit_bank` varchar(218) NOT NULL DEFAULT '' COMMENT '开户银行',
  `bank_account` varchar(32) NOT NULL DEFAULT '' COMMENT '银行账号',
  `receiver_name` varchar(32) NOT NULL DEFAULT '' COMMENT '收件人姓名',
  `receiver_phone` varchar(16) NOT NULL DEFAULT '' COMMENT '收件人电话',
  `receiver_address` varchar(256) NOT NULL DEFAULT '' COMMENT '收件人地址',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申请开票时间',
  `express_company` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '快递公司',
  `express_num` varchar(32) NOT NULL DEFAULT '' COMMENT '快递号',
  `express_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '邮寄时间',
  `reject_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '驳回原因ID',
  `cancel_desc` varchar(32) NOT NULL DEFAULT '' COMMENT '撤销原因',
  `email` varchar(128) NOT NULL DEFAULT '' COMMENT '邮件地址',
  `invoice_number` varchar(32) NOT NULL DEFAULT '' COMMENT '发票号',
  `express_company_name` varchar(128) NOT NULL DEFAULT '' COMMENT '快递公司名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_large_screen_passenger`;
CREATE TABLE `tbl_large_screen_passenger` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '乘客id',
  `device_code` varchar(128) NOT NULL COMMENT '设备号',
  `login_time` datetime DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `login_status` int(2) DEFAULT NULL COMMENT '登录状态：1：登录，2：退出登录',
  `repair_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='乘客大屏登录状态';

-- ----------------------------
-- Records of tbl_large_screen_passenger
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_message_show
-- ----------------------------
DROP TABLE IF EXISTS `tbl_message_show`;
CREATE TABLE `tbl_message_show` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` varchar(512) NOT NULL COMMENT '消息体',
  `yid` varchar(32) NOT NULL DEFAULT '' COMMENT '乘客、司机id,大屏设备号',
  `accept_identity` tinyint(3) NOT NULL COMMENT '发送端（1：乘客；2：司机；4：大屏）',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `push_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '推送类型 （1：营销通知，2：系统通知，3：订单通知，4：支付通知）',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示（0：不显示，1：显示）',
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读（0：未读，1：已读）',
  `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单号',
  `sms_send_app_id` int(10) NOT NULL DEFAULT '0' COMMENT '推送任务id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1522 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_order`;
CREATE TABLE `tbl_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(32) NOT NULL DEFAULT '' COMMENT '订单号',
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '乘客id',
  `passenger_phone` varchar(64) NOT NULL COMMENT '乘客电话',
  `device_code` varchar(64) NOT NULL DEFAULT '' COMMENT '乘客设备号',
  `driver_id` int(10) unsigned DEFAULT NULL COMMENT '司机id',
  `driver_status` int(2) unsigned DEFAULT '0' COMMENT '司机状态   \r\n0：没有司机接单   \r\n1：司机接单  \r\n2.  去接乘客 \r\n3：司机到达上车点   \r\n4：开始行程   \r\n5：结束行程  \r\n6：发起收款  \r\n7：取消',
  `driver_phone` varchar(64) DEFAULT NULL COMMENT '司机电话',
  `car_id` int(10) unsigned DEFAULT NULL COMMENT '车辆id',
  `plate_number` varchar(16) DEFAULT NULL COMMENT '车牌号',
  `user_longitude` varchar(32) NOT NULL COMMENT '用户位置经度',
  `user_latitude` varchar(32) NOT NULL COMMENT '用户位置纬度',
  `start_longitude` varchar(32) NOT NULL COMMENT '乘客下单起点经度',
  `start_latitude` varchar(32) NOT NULL COMMENT '乘客下单起点纬度',
  `start_address` varchar(128) NOT NULL COMMENT '起点名称',
  `end_address` varchar(128) NOT NULL COMMENT '终点地址名称',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '乘客下单时间',
  `order_start_time` timestamp NULL DEFAULT NULL COMMENT '订单开始时间',
  `end_longitude` varchar(32) NOT NULL COMMENT '乘客下单终点经度',
  `end_latitude` varchar(32) NOT NULL COMMENT '乘客下单终点纬度',
  `driver_grab_time` timestamp NULL DEFAULT NULL COMMENT '司机抢单时间',
  `driver_start_time` timestamp NULL DEFAULT NULL COMMENT '司机去接乘客出发时间',
  `driver_arrived_time` timestamp NULL DEFAULT NULL COMMENT '司机到达时间',
  `pick_up_passenger_longitude` varchar(32) DEFAULT '' COMMENT '去接乘客经度',
  `pick_up_passenger_latitude` varchar(32) DEFAULT '' COMMENT '去接乘客纬度',
  `pick_up_passenger_address` varchar(300) DEFAULT '' COMMENT '去接乘客地点',
  `receive_passenger_time` timestamp NULL DEFAULT NULL COMMENT '接到乘客时间',
  `receive_passenger_longitude` varchar(32) NOT NULL DEFAULT '' COMMENT '接到乘客经度',
  `receive_passenger_latitude` varchar(32) NOT NULL DEFAULT '' COMMENT '接到乘客纬度',
  `passenger_getoff_time` timestamp NULL DEFAULT NULL COMMENT '乘客下车时间',
  `passenger_getoff_longitude` varchar(32) DEFAULT NULL COMMENT '乘客下车经度',
  `passenger_getoff_latitude` varchar(32) DEFAULT NULL COMMENT '乘客下车纬度',
  `other_name` varchar(16) DEFAULT NULL COMMENT '他人姓名 （乘车人）',
  `other_phone` varchar(64) DEFAULT NULL COMMENT '他人电话　(乘车人）',
  `order_type` int(2) unsigned DEFAULT NULL COMMENT '订单类型：1：自己叫车，2：他人叫车',
  `service_type` int(2) unsigned NOT NULL COMMENT '叫车订单类型，\r\n1：实时订单，\r\n2：预约订单，\r\n3：接机单，\r\n4：送机单，\r\n5：日租，\r\n6：半日租',
  `order_channel` int(2) unsigned NOT NULL DEFAULT '1' COMMENT '订单渠道 \r\n1.自有订单\r\n2.高德\r\n3.飞猪',
  `status` int(2) NOT NULL COMMENT '订单状态 0: 订单预估 1：订单开始 2：司机接单 3：去接乘客 4：司机到达乘客起点 5：乘客上车，司机开始行程 6：到达目的地，行程结束，未支付 7：发起收款 8: 支付完成 9.乘客取消订单',
  `transaction_id` varchar(32) DEFAULT NULL COMMENT '商户交易id',
  `mapping_id` varchar(64) DEFAULT NULL COMMENT '订单状态 0: 订单预估 1：订单开始 2：司机接单 3：去接乘客 4：司机到达乘客起点 5：乘客上车，司机开始行程 6：到达目的地，行程结束，未支付 7：发起收款 8: 支付完成 9.订单取消',
  `mapping_number` varchar(32) DEFAULT NULL COMMENT '关联号码',
  `merchant_id` varchar(32) DEFAULT NULL COMMENT '商户id',
  `is_evaluate` int(2) NOT NULL DEFAULT '0' COMMENT '乘客是否评价，0：未评价，1：已评价',
  `invoice_type` int(2) unsigned NOT NULL DEFAULT '1' COMMENT '发票状态：\r\n1：未开票，\r\n2：申请开票，\r\n3：开票中，\r\n4：已开票,\r\n5：退回,',
  `is_annotate` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '通知客服状态\r\n0，未通知  \r\n1,  已通知',
  `source` varchar(64) NOT NULL COMMENT '设备来源\r\n1: ios\r\n2:android\r\n3.other',
  `use_coupon` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否使用优惠券 \r\n0:未使用  1:使用',
  `cancel_order_type` int(2) unsigned DEFAULT NULL COMMENT '取消原因类型id',
  `pay_type` int(1) DEFAULT NULL COMMENT '1:余额\r\n2.微信\r\n3.支付宝',
  `is_paid` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否已支付 0：未支付  1：已支付',
  `is_cancel` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否取消  0：未取消   1：已取消',
  `is_adjust` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '调帐状态  0：未调帐  1:调账中 2.调账完毕',
  `is_dissent` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否疑义订单 0：否  1：是',
  `is_manual` int(1) NOT NULL DEFAULT '0' COMMENT '是否人工派单0 否 1 原来无司机, 人工派 2原来有司机，改派',
  `is_following` int(1) NOT NULL DEFAULT '0' COMMENT '是否是顺风单0否 1是',
  `is_fake_success` int(1) NOT NULL DEFAULT '0' COMMENT '是否是假成功单0 否 1是',
  `memo` varchar(500) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备忘录',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  `user_feature` int(2) DEFAULT '0' COMMENT '1：儿童用车\r\n2：女性用车',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1967 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='订单表';

DROP TABLE IF EXISTS `tbl_order_adjust_record`;
CREATE TABLE `tbl_order_adjust_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `order_id` int(10) unsigned NOT NULL COMMENT '订单id',
  `doubt_id` int(10) unsigned DEFAULT NULL,
  `adjust_account_type` int(255) unsigned NOT NULL COMMENT '调账类型1,充值 2.扣款',
  `charge_number` varchar(32) DEFAULT NULL COMMENT '充值|扣款 单号',
  `old_cost` decimal(10,2) NOT NULL COMMENT '调账前金额',
  `new_cost` decimal(10,2) NOT NULL COMMENT '调账后金额',
  `reason_type` int(10) unsigned NOT NULL COMMENT '调账原因id',
  `reason_text` varchar(500) NOT NULL DEFAULT '' COMMENT '自定义调账原因',
  `solution` varchar(500) DEFAULT NULL COMMENT '处理方案',
  `operator` int(10) unsigned NOT NULL COMMENT '操作人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='订单调帐';


-- ----------------------------
-- Table structure for tbl_order_cancel_record
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_cancel_record`;
CREATE TABLE `tbl_order_cancel_record` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `is_charge` int(10) unsigned NOT NULL COMMENT '乘客是否有责0无责，1有责',
  `cancel_cost` double(10,0) NOT NULL COMMENT '取消费',
  `reason_type` int(10) unsigned NOT NULL COMMENT '取消原因类型 \r\n1\r\n2\r\n3\r\n4',
  `reason_text` varchar(128) NOT NULL COMMENT '其他原因',
  `operator` int(10) unsigned NOT NULL COMMENT '操作人',
  `operator_type` int(1) NOT NULL COMMENT '操作人类型1:客户自行取消 2:客服取消',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8 COMMENT='订单取消原因';

DROP TABLE IF EXISTS `tbl_order_change_record`;
CREATE TABLE `tbl_order_change_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) DEFAULT NULL COMMENT '订单id',
  `driver_befor` int(11) DEFAULT NULL COMMENT '接单司机id',
  `driver_after` int(11) DEFAULT NULL COMMENT '派单司机id',
  `reason` varchar(64) DEFAULT NULL COMMENT '派单原因',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `operate_uesr` varchar(64) DEFAULT NULL COMMENT '操作用户',
  `other_reason` varchar(64) DEFAULT NULL COMMENT '其它原因',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_order_doubt`;
CREATE TABLE `tbl_order_doubt` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL COMMENT '订单id',
  `appeal_number` varchar(32) NOT NULL DEFAULT '' COMMENT '申诉单号',
  `adjust_type` int(10) unsigned DEFAULT NULL COMMENT '调账类型\r\n1充值\r\n2扣款\r\n3发优惠券',
  `adjust_content` varchar(200) NOT NULL DEFAULT '' COMMENT '调账内容 充值| 扣款 单号，优惠券',
  `reason_type` int(10) unsigned DEFAULT NULL COMMENT '疑义原因类型 \r\n 1=>''提前计费'',\r\n 2=>''司要绕路'',\r\n 3=>''不明费用'',\r\n 4=>''其他问题'',',
  `reason_text` varchar(300) DEFAULT '' COMMENT '自定义其他疑义原因',
  `old_cost` decimal(10,2) DEFAULT NULL COMMENT '调账前金额',
  `now_cost` decimal(10,2) DEFAULT NULL COMMENT '调账后金额',
  `status` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '1待处理 \r\n2待审核 \r\n3已审核 \r\n4已完成 \r\n5已撤销 ',
  `handle_type` int(10) unsigned DEFAULT NULL COMMENT '处理类型\r\n1充值\r\n2扣款\r\n3发优惠券',
  `solution` varchar(200) NOT NULL DEFAULT '' COMMENT '处理方案',
  `operators` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人 （多人操作全记录)',
  `operate_time` timestamp NULL DEFAULT NULL COMMENT '操作时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '提交时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='调帐审核';

DROP TABLE IF EXISTS `tbl_order_gift_coupon_record`;
CREATE TABLE `tbl_order_gift_coupon_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `order_id` int(10) unsigned NOT NULL COMMENT '订单id',
  `doubt_id` int(10) DEFAULT NULL COMMENT '疑义定单id //order_doubt表中的id',
  `passenger_info_id` int(10) DEFAULT NULL COMMENT '接收用户优惠券的passenger id',
  `coupon_id` int(10) unsigned NOT NULL COMMENT '优惠券类型id',
  `user_phone` varchar(64) NOT NULL COMMENT '用户电话',
  `coupon_name` varchar(200) DEFAULT NULL COMMENT '优惠券类型名',
  `user_coupon_id` int(10) DEFAULT NULL COMMENT '用户优惠券id',
  `coupon_amount` float(10,2) DEFAULT NULL COMMENT '优惠券金额',
  `coupon_expired_date` varchar(200) DEFAULT NULL COMMENT '优惠券有效期 文案',
  `operator_id` int(10) NOT NULL COMMENT '操作人Id',
  `operator_time` datetime NOT NULL COMMENT '操作时间',
  `solution` varchar(300) DEFAULT NULL COMMENT '处理方案',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_order_payment`;
CREATE TABLE `tbl_order_payment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL COMMENT '订单id',
  `pay_type` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '支付类型：1微信，2账户余额，4支付宝',
  `total_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `balance_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '余额支付金额',
  `wechat_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '微信支付金额',
  `alipay_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付宝金额',
  `user_coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户获得优惠券id,此时不是优惠券id，是用户优惠券关联id',
  `coupon_reduce_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠券减免金额',
  `paid_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已支付金额',
  `remain_price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '剩余支付的金额',
  `tail_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '尾款价格',
  `replenish_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '补扣价格',
  `pay_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '支付时间',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单支付表';

DROP TABLE IF EXISTS `tbl_order_points`;
CREATE TABLE `tbl_order_points` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `driver_id` int(16) DEFAULT NULL COMMENT '司机Id',
  `car_id` int(16) DEFAULT NULL COMMENT '车辆Id',
  `order_id` int(16) DEFAULT NULL COMMENT '订单id',
  `points` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_order_reassignment_record
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_reassignment_record`;
CREATE TABLE `tbl_order_reassignment_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL COMMENT '订单Id',
  `driver_id_before` int(10) unsigned NOT NULL COMMENT '原司机Id',
  `driver_name_before` varchar(100) NOT NULL DEFAULT '' COMMENT '原司机姓名',
  `driver_id_now` int(10) unsigned NOT NULL COMMENT '当前司机ID',
  `driver_name_now` varchar(100) NOT NULL DEFAULT '' COMMENT '当前司机name',
  `operator` varchar(32) NOT NULL DEFAULT '' COMMENT '操作者',
  `reason_type` int(64) NOT NULL COMMENT '改派原因',
  `reason_text` varchar(200) DEFAULT '' COMMENT '改派内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COMMENT='订单改派';


-- ----------------------------
-- Table structure for tbl_order_rule_mirror
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_rule_mirror`;
CREATE TABLE `tbl_order_rule_mirror` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单_id',
  `rule_id` int(10) NOT NULL COMMENT '计价规则id',
  `rule` text NOT NULL COMMENT '规则镜像的json',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1967 DEFAULT CHARSET=utf8 COMMENT='订单计费规则镜像表';

-- ----------------------------
-- Table structure for tbl_order_rule_price
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_rule_price`;
CREATE TABLE `tbl_order_rule_price` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `category` varchar(1) NOT NULL COMMENT '价格类型：0预估，1实际',
  `total_price` double(10,2) NOT NULL COMMENT '总价',
  `total_distance` double(10,2) NOT NULL COMMENT '总距离（公里）',
  `total_time` double(10,0) NOT NULL COMMENT '总时间（分钟）',
  `city_code` varchar(32) NOT NULL COMMENT '城市编码',
  `city_name` varchar(64) NOT NULL COMMENT '城市名称',
  `service_type_id` int(2) NOT NULL COMMENT '服务类型id',
  `service_type_name` varchar(64) NOT NULL COMMENT '服务类型名称',
  `channel_id` int(10) NOT NULL COMMENT '渠道id',
  `channel_name` varchar(64) NOT NULL COMMENT '渠道名称',
  `car_level_id` int(10) NOT NULL COMMENT '车辆级别id',
  `car_level_name` varchar(64) NOT NULL COMMENT '车辆级别名称',
  `base_price` double(10,2) NOT NULL COMMENT '基础价格',
  `base_kilo` double(10,2) NOT NULL COMMENT '基础价格包含公里数',
  `base_minute` double(10,2) NOT NULL COMMENT '基础价格包含时长数（分钟）',
  `lowest_price` double(10,2) NOT NULL COMMENT '最低消费',
  `night_start` time DEFAULT NULL COMMENT '夜间时间段开始',
  `night_end` time DEFAULT NULL COMMENT '夜间时间段结束',
  `night_per_kilo_price` double(10,2) DEFAULT NULL COMMENT '夜间超公里加收单价',
  `night_per_minute_price` double(10,2) DEFAULT NULL COMMENT '夜间超时间加收单价',
  `night_distance` double(10,2) NOT NULL COMMENT '夜间行驶总里程（公里）',
  `night_time` double(10,2) NOT NULL COMMENT '夜间行驶总时间（分钟）',
  `night_price` double(10,2) NOT NULL COMMENT '夜间服务费',
  `beyond_start_kilo` double(10,2) NOT NULL COMMENT '远途起算公里',
  `beyond_per_kilo_price` double(10,2) NOT NULL COMMENT '远途单价',
  `beyond_distance` double(8,2) NOT NULL COMMENT '远途距离，超出远途的公里数',
  `beyond_price` double(10,2) NOT NULL COMMENT '远途费',
  `per_kilo_price` double(10,2) NOT NULL COMMENT '超公里单价(每公里单价)',
  `path` double(10,2) NOT NULL COMMENT '(不包含起步)行驶总里程（公里）或分段计价合计里程（公里）',
  `path_price` double(10,2) NOT NULL COMMENT '(不包含起步)行驶总里程价格或分段计价合计价格',
  `per_minute_price` double(10,2) NOT NULL COMMENT '超时间单价(每分钟单价)或分段计价默认的每分钟单价',
  `duration` double(10,2) NOT NULL COMMENT '(不包含起步)行驶时长（分钟）或分段计价合计时长（分钟）',
  `duration_price` double(10,2) NOT NULL COMMENT '(不包含起步)行驶时长价格或分段计价合计时间价格',
  `rest_duration` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '其他时段时长合计',
  `rest_duration_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '其他时段时长费用合计',
  `rest_distance` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '其他时段距离合计',
  `rest_distance_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '其他时段距离费用合计',
  `road_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '过路费',
  `parking_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '停车费',
  `other_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '其它费用',
  `dynamic_discount_rate` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '动态调价的折扣率(0-1 两小数)',
  `dynamic_discount` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '动态调价的金额',
  `supplement_price` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '最低消费补足的费用',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  PRIMARY KEY (`id`),
  KEY `idx_order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2196 DEFAULT CHARSET=utf8 COMMENT='计费明细表';

-- ----------------------------
-- Table structure for tbl_order_rule_price_detail
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_rule_price_detail`;
CREATE TABLE `tbl_order_rule_price_detail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `category` varchar(1) NOT NULL COMMENT '价格类型：0预约，1实际',
  `start_hour` int(2) NOT NULL COMMENT '时间段-开始',
  `end_hour` int(2) NOT NULL COMMENT '时间段-结束',
  `per_kilo_price` double(10,2) NOT NULL COMMENT '超公里单价(每公里单价)',
  `per_minute_price` double(10,2) NOT NULL COMMENT '超时间单价(每分钟单价)',
  `duration` double(10,2) NOT NULL COMMENT '该时间段的时间统计',
  `time_price` double(10,2) NOT NULL COMMENT '该时间段的时间价格合计',
  `distance` double(10,2) NOT NULL COMMENT '该时间段的距离统计',
  `distance_price` double(10,2) NOT NULL COMMENT '该时间段的距离价格合计',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分段计时计费明细表';

-- ----------------------------
-- Records of tbl_order_rule_price_detail
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_order_send_coupon_record
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_send_coupon_record`;
CREATE TABLE `tbl_order_send_coupon_record` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `coupon_id` int(10) NOT NULL COMMENT '优惠券Id',
  `operator` int(10) NOT NULL COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
  `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_order_send_coupon_record
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_order_use_coupon
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order_use_coupon`;
CREATE TABLE `tbl_order_use_coupon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL COMMENT '订单id',
  `coupon_id` int(11) unsigned NOT NULL COMMENT '优惠券Id',
  `category` char(1) NOT NULL DEFAULT '0' COMMENT '0:预估 1，实际',
  `coupon_money` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券金额',
  `after_use_coupon_moeny` float(10,2) DEFAULT NULL COMMENT '使用优惠券后订单金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=467 DEFAULT CHARSET=utf8 COMMENT='订单优惠券使用记录';

DROP TABLE IF EXISTS `tbl_organization_info`;
CREATE TABLE `tbl_organization_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '机构信息id',
  `organization_name` varchar(255) DEFAULT '' COMMENT '服务机构名称',
  `organization_code` varchar(255) DEFAULT '' COMMENT '服务机构代码',
  `administrative_division_code` varchar(255) DEFAULT '' COMMENT '行政区划分代码',
  `organization_address` varchar(255) DEFAULT '' COMMENT '服务机构地址',
  `duty_name` varchar(255) DEFAULT '' COMMENT '负责人姓名',
  `duty_phone` varchar(32) DEFAULT '' COMMENT '负责人手机号',
  `admin_name` varchar(10) DEFAULT '' COMMENT '管理员姓名',
  `admin_phone` varchar(32) DEFAULT '' COMMENT '管理员电话',
  `organization_head_phone` varchar(32) DEFAULT '' COMMENT '服务机构总联系电话',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_organization_info
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_passenger_address
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_address`;
CREATE TABLE `tbl_passenger_address` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '乘客id',
  `latitude` double(10,6) DEFAULT NULL COMMENT '地址纬度',
  `longitude` double(10,6) DEFAULT NULL COMMENT '地址经度',
  `address_name` varchar(64) DEFAULT '' COMMENT '详细地址',
  `type` int(2) DEFAULT NULL COMMENT '0:家，1：公司',
  `address_desc` varchar(2048) DEFAULT '' COMMENT '地址描述',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


-- ----------------------------
-- Table structure for tbl_passenger_blacklist
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_blacklist`;
CREATE TABLE `tbl_passenger_blacklist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(64) NOT NULL COMMENT '电话号码',
  `reason` char(1) NOT NULL DEFAULT '' COMMENT '1 个人用户1小时内连续取消订单3次\r\n2 24小时内取消10次派车成功单',
  `category` char(1) NOT NULL DEFAULT '1' COMMENT '1 临时黑名单 2 永久黑名单',
  `is_release` char(1) NOT NULL DEFAULT '0' COMMENT '1 解禁，0 未解禁',
  `release_time` timestamp NULL DEFAULT NULL COMMENT '解禁时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='用户黑名单';


-- ----------------------------
-- Table structure for tbl_passenger_consume_record
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_consume_record`;
CREATE TABLE `tbl_passenger_consume_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `event` char(1) NOT NULL COMMENT '消费事件\r\n1.订单扣款\r\n2......',
  `monetary` decimal(10,2) NOT NULL COMMENT '消费金额',
  `transaction_number` varchar(32) NOT NULL DEFAULT '' COMMENT '交易单号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_passenger_consume_record
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_passenger_history_address
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_history_address`;
CREATE TABLE `tbl_passenger_history_address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL COMMENT '乘客id',
  `passenger_phone` char(11) NOT NULL DEFAULT '' COMMENT '乘客电话',
  `type` int(10) unsigned NOT NULL COMMENT '1上车地点\r\n2下车地点',
  `address` varchar(500) DEFAULT '' COMMENT '详细地址',
  `city_code` varchar(32) DEFAULT NULL COMMENT '城市码',
  `city` varchar(32) DEFAULT NULL COMMENT '城市',
  `detail_name` varchar(100) DEFAULT NULL COMMENT '地址短名',
  `ad_code` varchar(32) DEFAULT NULL COMMENT '地址码',
  `longitude` varchar(32) NOT NULL DEFAULT '' COMMENT '经度',
  `latitude` varchar(32) NOT NULL DEFAULT '' COMMENT '纬度',
  `address_poi` varchar(1000) DEFAULT NULL,
  `is_del` char(1) NOT NULL DEFAULT '0' COMMENT '是否被删除0未删除 1删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=454 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_passenger_history_car_person`;
CREATE TABLE `tbl_passenger_history_car_person` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL COMMENT '订车人id',
  `passenger_phone` varchar(32) NOT NULL COMMENT '订车人用户phone',
  `use_car_person_name` varchar(100) NOT NULL DEFAULT '' COMMENT '用车人姓名',
  `use_car_person_phone` varchar(64) DEFAULT NULL COMMENT '用车人电话',
  `is_del` char(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1删除 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_passenger_info`;
CREATE TABLE `tbl_passenger_info` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `phone` varchar(64) NOT NULL DEFAULT '' COMMENT '电话',
  `educatioan` varchar(255) DEFAULT '' COMMENT '学历',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `passenger_name` varchar(16) NOT NULL DEFAULT '' COMMENT '乘客名称',
  `register_time` datetime DEFAULT NULL COMMENT '注册时间',
  `balance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '余额',
  `gender` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '0：女，1：男',
  `head_img` varchar(256) NOT NULL DEFAULT '' COMMENT '头像',
  `passenger_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户类型，1：个人用户，2：企业用户',
  `user_level` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '会员等级',
  `register_type` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '注册渠道 1 安卓 2 ios',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后一次登录时间',
  `last_login_method` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '上次登陆方式:1,验证码,2密码',
  `last_login_screen_time` datetime DEFAULT NULL COMMENT '上次登录大屏时间',
  `last_login_screen_method` char(1) NOT NULL DEFAULT '' COMMENT '上次登录大屏方式',
  `last_order_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次下单时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_passenger_message`;
CREATE TABLE `tbl_passenger_message` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(256) NOT NULL DEFAULT '',
  `if_success` tinyint(2) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tbl_passenger_message
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_passenger_register_source
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_register_source`;
CREATE TABLE `tbl_passenger_register_source` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(16) DEFAULT NULL,
  `register_source` varchar(32) DEFAULT NULL,
  `market_channel` varchar(64) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_passenger_statics`;
CREATE TABLE `tbl_passenger_statics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `total_distance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总里程',
  `month_distance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '当月里程',
  `total_charge` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '充值总金额',
  `total_refund` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款总额',
  `total_order_pay` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单支付总额',
  `month_order_pay` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '月订单支付总额',
  `total_invoice` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已开票总金额',
  `can_invoice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '未开票总金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='乘客统计信息表';

-- ----------------------------
-- Records of tbl_passenger_statics
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_passenger_wallet
-- ----------------------------
DROP TABLE IF EXISTS `tbl_passenger_wallet`;
CREATE TABLE `tbl_passenger_wallet` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(16) DEFAULT NULL COMMENT '乘客Id',
  `capital` double(10,2) DEFAULT NULL COMMENT '本金',
  `give_fee` double(10,2) DEFAULT NULL COMMENT '赠费',
  `freeze_capital` double(10,2) DEFAULT NULL COMMENT '冻结本金',
  `freeze_give_fee` double(10,2) DEFAULT NULL COMMENT '冻结赠费',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_userid` (`passenger_info_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8 COMMENT='乘客钱包';

DROP TABLE IF EXISTS `tbl_passenger_wallet_1106`;
CREATE TABLE `tbl_passenger_wallet_1106` (
  `id` int(16) NOT NULL DEFAULT '0',
  `passenger_info_id` int(16) DEFAULT NULL COMMENT '乘客Id',
  `capital` double(10,2) DEFAULT NULL COMMENT '本金',
  `give_fee` double(10,2) DEFAULT NULL COMMENT '赠费',
  `freeze_capital` double(10,2) DEFAULT NULL COMMENT '冻结本金',
  `freeze_give_fee` double(10,2) DEFAULT NULL COMMENT '冻结赠费',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_passenger_wallet_freeze_record`;
CREATE TABLE `tbl_passenger_wallet_freeze_record` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(16) NOT NULL COMMENT '乘客Id',
  `freeze_capital` double(10,2) DEFAULT NULL COMMENT '冻结本金',
  `freeze_give_fee` double(10,2) DEFAULT NULL COMMENT '冻结赠费',
  `order_id` int(16) NOT NULL COMMENT '订单Id',
  `freeze_status` int(2) DEFAULT NULL COMMENT '0:解冻，1：冻结',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=314 DEFAULT CHARSET=utf8 COMMENT='钱包冻结/解冻记录';

DROP TABLE IF EXISTS `tbl_passenger_wallet_record`;
CREATE TABLE `tbl_passenger_wallet_record` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `passenger_info_id` int(16) NOT NULL COMMENT '用户ID',
  `transaction_id` varchar(32) DEFAULT '' COMMENT '第三方支付ID',
  `pay_time` datetime NOT NULL COMMENT '支付时间',
  `pay_capital` double(10,2) NOT NULL COMMENT '本金',
  `pay_give_fee` double(10,2) NOT NULL COMMENT '赠费',
  `refund_capital` double(10,2) DEFAULT '0.00' COMMENT '退款本金',
  `refund_give_fee` double(10,2) DEFAULT '0.00' COMMENT '退款赠费',
  `recharge_discount` double(10,2) NOT NULL COMMENT '充值折扣',
  `pay_type` tinyint(2) NOT NULL COMMENT '1：微信 ，2：账户余额，3：平台账户，4：支付宝',
  `pay_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1：已支付 ，0：未支付',
  `trade_type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '交易类型：\r\n1充值\r\n2消费\r\n3退款\r\n4订单冻结\r\n5订单补扣\r\n6尾款支付\r\n7解冻',
  `trade_reason` varchar(100) NOT NULL DEFAULT '' COMMENT '交易原因',
  `description` varchar(200) NOT NULL COMMENT '描述',
  `create_user` varchar(20) DEFAULT NULL COMMENT '创建用户',
  `order_id` int(10) DEFAULT NULL COMMENT '订单Id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_userid` (`passenger_info_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3001 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='充值交易记录';

DROP TABLE IF EXISTS `tbl_people_tag`;
CREATE TABLE `tbl_people_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(60) NOT NULL DEFAULT '' COMMENT '人群标签名称',
  `tag_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '目标类别 (1,passenger, 2,driver)',
  `tag_conditions` varchar(2000) NOT NULL DEFAULT '' COMMENT '筛选条件',
  `tag_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '标签人数(约数)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '更新人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='人群标签';

DROP TABLE IF EXISTS `tbl_phone_message`;
CREATE TABLE `tbl_phone_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(16) COLLATE utf8_unicode_ci NOT NULL COMMENT '电话',
  `sms_content` varchar(512) COLLATE utf8_unicode_ci NOT NULL COMMENT '消息体',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `push_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推送类型 （1：营销,2:通知）',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送状态（0：失败；1：成功）',
  `operator` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '操作者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_push_account`;
CREATE TABLE `tbl_push_account` (
  `id` int(16) unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(32) NOT NULL DEFAULT '' COMMENT '设备来源 iOS,Android',
  `jpush_id` varchar(64) NOT NULL DEFAULT '' COMMENT '消息推送设备id',
  `yid` varchar(64) NOT NULL COMMENT '系统用户号，司机、乘客用yid，大屏唯一码、车机用唯一码',
  `audience` int(2) NOT NULL DEFAULT '1' COMMENT '听众类型：1：别名，2：注册Id',
  `identity_status` int(2) unsigned NOT NULL COMMENT '身份标记 1:乘客，2：司机，3：车机，4：大屏',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='极光id手机表';

DROP TABLE IF EXISTS `tbl_push_app_message`;
CREATE TABLE `tbl_push_app_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `yid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '乘客、司机id,大屏设备号',
  `accept_identity` tinyint(1) NOT NULL DEFAULT '0' COMMENT '接收端（1：乘客；2：司机；4：大屏）',
  `title` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示（0：不显示，1：显示）',
  `push_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '推送类型  （1：营销通知，2：系统通知，3：订单通知，4：支付通知）',
  `sms_send_app_id` int(10) NOT NULL DEFAULT '0' COMMENT '推送任务id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2284 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_push_loop_message`;
CREATE TABLE `tbl_push_loop_message` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `accept_identity` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '1:乘客，2：司机，3：车机，4：大屏',
  `accept_id` varchar(128) NOT NULL DEFAULT '' COMMENT '接受方id',
  `message_type` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型，看枚举定义',
  `message_body` varchar(1024) NOT NULL DEFAULT '' COMMENT '消息体',
  `read_flag` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0:未读，1：已读',
  `send_id` varchar(128) NOT NULL DEFAULT '' COMMENT '发送方id',
  `send_identity` int(2) NOT NULL COMMENT '发送者身份类别',
  `expire_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '消息失效时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '消息创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `expire_time` (`expire_time`),
  KEY `accept_id` (`accept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=556 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='消息系统列表';

DROP TABLE IF EXISTS `tbl_push_message_record`;
CREATE TABLE `tbl_push_message_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '系统类型',
  `jpush_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '接收通知的设备token',
  `message_type` int(3) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型',
  `message_body` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `send_result` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '发送结果1：成功，0：失败',
  `send_id` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '发送方id',
  `send_identity` int(2) NOT NULL COMMENT '发送者身份类别',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3044 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='消息推送记录';


-- ----------------------------
-- Table structure for tbl_recharge_price
-- ----------------------------
DROP TABLE IF EXISTS `tbl_recharge_price`;
CREATE TABLE `tbl_recharge_price` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'paymentID',
  `amount` double(10,2) DEFAULT NULL COMMENT '充值金额',
  `reward` double(10,2) DEFAULT NULL COMMENT '赠送金额',
  `desc` varchar(200) DEFAULT NULL COMMENT '金额描述信息',
  `is_deleted` bit(1) DEFAULT NULL COMMENT '是否被删除 1 ：已删除 0 ：未删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='充值金额规则';

DROP TABLE IF EXISTS `tbl_secret_voice_records`;
CREATE TABLE `tbl_secret_voice_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `call_id` varchar(64) NOT NULL,
  `subs_id` varchar(64) NOT NULL COMMENT '对应的三元组的绑定关系ID',
  `call_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '呼叫时间',
  `flag` int(1) NOT NULL DEFAULT '0' COMMENT '是否下载文件0：未下载  1：已下载',
  `oss_download_url` varchar(512) DEFAULT NULL COMMENT '文件下载地址',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COMMENT='通话记录上传记录表\r\n';


-- ----------------------------
-- Table structure for tbl_service
-- ----------------------------
DROP TABLE IF EXISTS `tbl_service`;
CREATE TABLE `tbl_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_code` varchar(32) NOT NULL COMMENT '城市编码',
  `service_type_id` int(11) NOT NULL COMMENT '服务类型id',
  `together_order_number` int(4) NOT NULL DEFAULT '0' COMMENT '同时可下单数量',
  `service_status` int(2) NOT NULL COMMENT '服务开启状态 0暂停 1开启',
  `operator_id` int(11) NOT NULL COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_service_type`;
CREATE TABLE `tbl_service_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_type_name` varchar(64) NOT NULL COMMENT '服务类型名称',
  `service_type_status` int(2) NOT NULL COMMENT '服务类型状态 1开启 0暂停',
  `is_use` char(1) NOT NULL DEFAULT '0' COMMENT '使用状态  1使用 0未使用',
  `operator_id` int(11) NOT NULL COMMENT '操作人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='服务类型表';

DROP TABLE IF EXISTS `tbl_sms`;
CREATE TABLE `tbl_sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `passenger_phone_number` varchar(16) NOT NULL DEFAULT '' COMMENT '乘客手机号',
  `sms_content` varchar(512) NOT NULL DEFAULT '' COMMENT '短信内容',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `operator` varchar(255) NOT NULL DEFAULT '' COMMENT '操作人',
  `send_flag` tinyint(1) NOT NULL COMMENT '发送状态 0:失败  1: 成功',
  `send_number` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送失败次数',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1554 DEFAULT CHARSET=utf8mb4;


-- ----------------------------
-- Table structure for tbl_sms_app_template
-- ----------------------------
DROP TABLE IF EXISTS `tbl_sms_app_template`;
CREATE TABLE `tbl_sms_app_template` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '模板名称',
  `template_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '模板类型（1：营销；2：通知）',
  `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '模板内容',
  `operator_user` int(10) DEFAULT NULL COMMENT '操作者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of tbl_sms_app_template
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_sms_send_app
-- ----------------------------
DROP TABLE IF EXISTS `tbl_sms_send_app`;
CREATE TABLE `tbl_sms_send_app` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '消息标题名称',
  `show_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '展示端（1：乘客；2：司机）',
  `sms_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型（1：营销；2：通知）',
  `people_tag_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '人群id',
  `sms_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '消息图片',
  `app_template_id` int(11) NOT NULL DEFAULT '0' COMMENT '消息文案id',
  `sms_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `start_time` datetime NOT NULL COMMENT '生效时间',
  `send_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推送状态（0：未推送；1：已推送）',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `operator_user` int(10) DEFAULT NULL COMMENT '操作者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_tima` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of tbl_sms_send_app
-- ----------------------------

-- ----------------------------
-- Table structure for tbl_sms_send_phone
-- ----------------------------
DROP TABLE IF EXISTS `tbl_sms_send_phone`;
CREATE TABLE `tbl_sms_send_phone` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sms_template_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT '文案模板template_id',
  `sms_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消息类型（1：营销；2：通知）',
  `send_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送类型（1：单人发送；2：批量发送）',
  `phone_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '单人发送手机号',
  `phone_file` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '批量发送文件名',
  `send_people` int(10) NOT NULL DEFAULT '0' COMMENT '1:乘客；2：司机',
  `operator_user` int(10) DEFAULT NULL COMMENT '操作者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `tbl_sms_template`;
CREATE TABLE `tbl_sms_template` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `template_id` varchar(16) NOT NULL DEFAULT '' COMMENT '短信模板ID',
  `template_name` varchar(128) DEFAULT NULL,
  `content` varchar(512) NOT NULL DEFAULT '' COMMENT '模板内容',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `template_type` tinyint(1) NOT NULL DEFAULT '3' COMMENT '模板类型（1：营销；2：通知；3：订单）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `TEMPLATE_ID` (`template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4;

DROP TABLE IF EXISTS `tbl_sys_config`;
CREATE TABLE `tbl_sys_config` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `conf_key` varchar(30) NOT NULL COMMENT '配置项',
  `conf_val` varchar(2000) NOT NULL COMMENT '配置值',
  `conf_name` varchar(30) NOT NULL COMMENT '配置名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统配置杂项';

DROP TABLE IF EXISTS `tbl_sys_user`;
CREATE TABLE `tbl_sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `salt` varchar(15) NOT NULL DEFAULT '' COMMENT '密码的盐',
  `phone` varchar(32) NOT NULL DEFAULT '',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `last_login_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '最后登录时间',
  `modify_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改人ID',
  `last_update_password_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_tv_apps`;
CREATE TABLE `tbl_tv_apps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(16) NOT NULL COMMENT '应用名称',
  `version_code` int(11) NOT NULL COMMENT '版本号',
  `start_time` datetime NOT NULL COMMENT '开始更新时间',
  `down_load_url` varchar(255) NOT NULL COMMENT '应用包下载链接',
  `package_name` varchar(32) NOT NULL COMMENT '包名',
  `ico_url` varchar(255) NOT NULL COMMENT '应用图标',
  `use_status` int(2) NOT NULL COMMENT '应用状态 1启用 0停用',
  `position` int(3) NOT NULL COMMENT '应用位置',
  `is_del` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除 1是 0否',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `operator_id` int(11) NOT NULL COMMENT '创建人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_tv_version_update`;
CREATE TABLE `tbl_tv_version_update` (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'TV平台版本名称',
  `tv_version_code` int(4) NOT NULL DEFAULT '0' COMMENT 'tvVersionCode',
  `tv_version` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '版本号',
  `notice_type` smallint(6) NOT NULL COMMENT '通知类型（1:强制 2:非强制）',
  `prompt` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '升级提示（不超过30个字）',
  `note` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `start_time` datetime NOT NULL COMMENT '生效开始时间	',
  `end_time` datetime NOT NULL COMMENT '生效结束时间',
  `download_url` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '安装包URL',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `operator_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建人id',
  `use_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '启用停用状态，0：停用，1：启用',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `tbl_user_coupon`;
CREATE TABLE `tbl_user_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '领取记录ID',
  `passenger_id` int(11) NOT NULL DEFAULT '0' COMMENT '乘客ID',
  `phone_number` varchar(20) NOT NULL DEFAULT '' COMMENT '电话号码',
  `order_id` varchar(32) NOT NULL DEFAULT '' COMMENT '关联订单号',
  `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  `coupon_name` varchar(30) DEFAULT '',
  `coupon_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券类型 1:现金券, 2:专项券-免费送车券, 3:专项券-免费还车券 4:折扣券',
  `get_method` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '	1,主动发放. 2,用户获取',
  `enable_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '优惠券起效时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '获取时间',
  `expire_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间',
  `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '使用时间',
  `use_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '使用时间',
  `is_use` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态 0:未使用, 1:已使用',
  `minimum_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '最低消费金额',
  `reduction_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '减免金额(现金券：能抵扣的金额,折扣券：最高能抵扣的金额)',
  `discount` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '折扣8,7.5',
  `function_type` int(4) NOT NULL DEFAULT '0' COMMENT '功能类型 1:市场活动, 2:订单赔付',
  `indemnity_record_id` int(10) NOT NULL DEFAULT '0' COMMENT '赔付记录ID',
  `activity_tag` varchar(30) NOT NULL DEFAULT '' COMMENT '活动标签',
  `activity_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动ID',
  PRIMARY KEY (`id`),
  KEY `INX_PHONE` (`phone_number`),
  KEY `INX_COUPON` (`coupon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1252 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户优惠券表';

DROP TABLE IF EXISTS `tbl_weixinpay_callback_info`;
CREATE TABLE `tbl_weixinpay_callback_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(32) DEFAULT NULL COMMENT '微信订单号',
  `out_trade_no` varchar(32) DEFAULT NULL COMMENT '商户订单号',
  `total_fee` int(11) DEFAULT NULL,
  `body` varchar(200) DEFAULT NULL,
  `result_code` varchar(16) DEFAULT NULL COMMENT '业务结果',
  `err_code` varchar(45) DEFAULT NULL COMMENT '错误代码',
  `openid` varchar(128) DEFAULT NULL COMMENT '用户标识',
  `trade_type` varchar(45) DEFAULT NULL COMMENT '交易类型',
  `bank_type` varchar(16) DEFAULT NULL COMMENT '付款银行',
  `time_end` datetime DEFAULT NULL COMMENT '支付完成时间',
  `attach` varchar(128) DEFAULT NULL,
  `order_type` int(11) DEFAULT NULL COMMENT '订单类型 1："充值" ， 3："订单"， 4："缴纳押金"  6："违章缴费"',
  `status` int(11) DEFAULT '1' COMMENT '订单状态 1：未支付 ，2：已支付',
  `mch_id` varchar(32) DEFAULT NULL COMMENT '商户ID',
  `source` varchar(32) DEFAULT NULL COMMENT '来源iOS，Android',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `INX_OUT_NO` (`out_trade_no`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信支付信息表';