fw_admin/售后服务MySQL结构.sql

/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : localhost:3306
 Source Schema         : servedb

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

 Date: 11/01/2021 19:31:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for codes
-- ----------------------------
DROP TABLE IF EXISTS `codes`;
CREATE TABLE `codes`  (
  `ID` int(11) NOT NULL,
  `now` int(11) NULL DEFAULT NULL,
  `date` int(11) NULL DEFAULT NULL COMMENT '日期',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `len` int(11) NOT NULL COMMENT '长度',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_project_dabiao_info
-- ----------------------------
DROP TABLE IF EXISTS `t_project_dabiao_info`;
CREATE TABLE `t_project_dabiao_info`  (
  `id` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL,
  `typeid` int(11) NULL DEFAULT NULL,
  `yearvalue` int(11) NULL DEFAULT NULL,
  `monthvalue` int(11) NULL DEFAULT NULL,
  `warrantytype` int(11) NULL DEFAULT NULL,
  `thisdate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lognum` int(11) NULL DEFAULT NULL,
  `ischeck` int(11) NULL DEFAULT NULL,
  `ispass` int(11) NULL DEFAULT NULL,
  `salecenterid` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_project_lognum
-- ----------------------------
DROP TABLE IF EXISTS `t_project_lognum`;
CREATE TABLE `t_project_lognum`  (
  `projectid` int(11) NULL DEFAULT NULL,
  `yearvalue` int(11) NULL DEFAULT NULL,
  `serviceamount` int(11) NULL DEFAULT NULL,
  `mon1_lognum` int(11) NULL DEFAULT NULL,
  `mon2_lognum` int(11) NULL DEFAULT NULL,
  `mon3_lognum` int(11) NULL DEFAULT NULL,
  `mon4_lognum` int(11) NULL DEFAULT NULL,
  `mon5_lognum` int(11) NULL DEFAULT NULL,
  `mon6_lognum` int(11) NULL DEFAULT NULL,
  `mon7_lognum` int(11) NULL DEFAULT NULL,
  `mon8_lognum` int(11) NULL DEFAULT NULL,
  `mon9_lognum` int(11) NULL DEFAULT NULL,
  `mon10_lognum` int(11) NULL DEFAULT NULL,
  `mon11_lognum` int(11) NULL DEFAULT NULL,
  `mon12_lognum` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_servelogtype
-- ----------------------------
DROP TABLE IF EXISTS `t_servelogtype`;
CREATE TABLE `t_servelogtype`  (
  `ID` int(11) NOT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `desc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tacceptance
-- ----------------------------
DROP TABLE IF EXISTS `tacceptance`;
CREATE TABLE `tacceptance`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `startdate` datetime NULL DEFAULT NULL COMMENT '验收日期-起始',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `enddate` datetime NULL DEFAULT NULL COMMENT '验收日期-结束',
  `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收地点',
  `custnameid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户姓名',
  `functions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '系统已经实现的功能',
  `runmatter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '系统运行情况或使用效果',
  `advice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '其它',
  `custpost` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户职位',
  `custphone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户电话',
  `conclusion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '验收结论',
  `doctypeid` int(11) NULL DEFAULT NULL COMMENT '报告类型',
  `type` int(11) NULL DEFAULT NULL COMMENT '报告分类',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '调试验收报告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tacceptance_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tacceptance_attachment`;
CREATE TABLE `tacceptance_attachment`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `acceptanceid` int(11) NULL DEFAULT NULL COMMENT '验收报告单ID(外键，指向tacceptance.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '调试验收报告-验收附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tacceptance_debug_attach
-- ----------------------------
DROP TABLE IF EXISTS `tacceptance_debug_attach`;
CREATE TABLE `tacceptance_debug_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `acceptanceid` int(11) NULL DEFAULT NULL COMMENT '验收报告单ID(外键，指向tacceptance.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '验收报告--调试附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tacceptancetype
-- ----------------------------
DROP TABLE IF EXISTS `tacceptancetype`;
CREATE TABLE `tacceptancetype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for taimpass
-- ----------------------------
DROP TABLE IF EXISTS `taimpass`;
CREATE TABLE `taimpass`  (
  `ID` int(11) NOT NULL,
  `aimpass` decimal(10, 2) NULL DEFAULT NULL COMMENT '目标合格率',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '目标合格率' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tallot
-- ----------------------------
DROP TABLE IF EXISTS `tallot`;
CREATE TABLE `tallot`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `salecenter` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域/销售服务中心',
  `employeename` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `allotcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请单号',
  `allotdate` datetime NULL DEFAULT NULL COMMENT '申请日期',
  `allottype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采购类型',
  `urgentlevel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '紧急程度',
  `reservecode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预留号码',
  `finishdate` datetime NULL DEFAULT NULL COMMENT '办结日期',
  `totalmoney` decimal(12, 2) NULL DEFAULT NULL COMMENT '涉及总额',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注说明',
  `createtime` datetime NULL DEFAULT NULL COMMENT '导入时间',
  `empjobnumber` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人工号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物料调拨单主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tallot_product
-- ----------------------------
DROP TABLE IF EXISTS `tallot_product`;
CREATE TABLE `tallot_product`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `allotcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料调拨单ID,外键指向tallot.id',
  `productcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料名称',
  `productnum` int(11) NULL DEFAULT NULL COMMENT '物料数量',
  `productunit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料单位',
  `stockloc` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库存地点',
  `stockcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库存编号',
  `createtime` datetime NULL DEFAULT NULL COMMENT '导入时间',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '关联项目,外键指向tproject.id',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物料调拨单-产品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcar
-- ----------------------------
DROP TABLE IF EXISTS `tcar`;
CREATE TABLE `tcar`  (
  `ID` int(11) NOT NULL,
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '所在销售服务中心(外键，指向tsalecenter.ID)',
  `area` int(11) NULL DEFAULT NULL COMMENT '服务地区-客户ID(外键，指向tcustomer.ID)',
  `plateno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车牌号',
  `model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车型',
  `buydate` datetime NULL DEFAULT NULL COMMENT '购置日期',
  `mileage` decimal(12, 2) NULL DEFAULT NULL COMMENT '行驶里程',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '(isdel)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `totalmileage` decimal(12, 2) NULL DEFAULT NULL COMMENT '总行驶',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcar_detail
-- ----------------------------
DROP TABLE IF EXISTS `tcar_detail`;
CREATE TABLE `tcar_detail`  (
  `ID` int(11) NOT NULL,
  `carid` int(11) NULL DEFAULT NULL COMMENT '车辆档案ID(外键，指向tcar.ID)',
  `date` datetime NULL DEFAULT NULL COMMENT '记录日期',
  `kilometre` decimal(12, 2) NULL DEFAULT NULL COMMENT '公里数',
  `mileage` decimal(12, 2) NULL DEFAULT NULL COMMENT '行驶里程',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL,
  `createmanid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `mbkm` decimal(12, 2) NULL DEFAULT NULL COMMENT '保养里程',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆管理每周公里数记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcartype
-- ----------------------------
DROP TABLE IF EXISTS `tcartype`;
CREATE TABLE `tcartype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车型',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcompetitor
-- ----------------------------
DROP TABLE IF EXISTS `tcompetitor`;
CREATE TABLE `tcompetitor`  (
  `ID` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '竞争对手名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '竞争对手表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcontact
-- ----------------------------
DROP TABLE IF EXISTS `tcontact`;
CREATE TABLE `tcontact`  (
  `ID` int(11) NOT NULL,
  `copyerid` int(11) NULL DEFAULT NULL COMMENT '员工ID(指向temployee)',
  `isdel` int(11) NULL DEFAULT NULL,
  `usuallycopyer` int(11) NULL DEFAULT NULL COMMENT '是否为常用登录人',
  `uid` int(11) NULL DEFAULT NULL COMMENT '当前登录人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcustlinkman
-- ----------------------------
DROP TABLE IF EXISTS `tcustlinkman`;
CREATE TABLE `tcustlinkman`  (
  `ID` int(11) NOT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `customerid` int(11) NULL DEFAULT NULL COMMENT '客户ID(外键，指向tcustomer.ID)',
  `dept` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在部门',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `post` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职务',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系邮箱',
  `sex` int(11) NULL DEFAULT NULL COMMENT '性别',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户联系人' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcustomer
-- ----------------------------
DROP TABLE IF EXISTS `tcustomer`;
CREATE TABLE `tcustomer`  (
  `ID` int(11) NOT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `PID` int(11) NULL DEFAULT NULL COMMENT '父级客户ID(树形，指向tcustomer.ID)',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位名称',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcusttrain
-- ----------------------------
DROP TABLE IF EXISTS `tcusttrain`;
CREATE TABLE `tcusttrain`  (
  `ID` int(11) NOT NULL,
  `startdate` datetime NULL DEFAULT NULL COMMENT '培训起始时间',
  `enddate` datetime NULL DEFAULT NULL COMMENT '培训终止时间',
  `address` int(11) NULL DEFAULT NULL COMMENT '培训地点(1:在京,2:现场)',
  `teacherid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训讲师	(外键，多选，指向temployee.ID)',
  `custnum` int(11) NULL DEFAULT NULL COMMENT '参加人数',
  `abstract` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容摘要',
  `summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '培训总结',
  `advice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '客户主要建议',
  `score` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '客户综合评分',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `creater` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '填报人',
  `teachername` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训讲师	(外键，多选，指向temployee.ID)',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  `isnew` smallint(6) NULL DEFAULT NULL COMMENT '是否已查看(0:未查看,1:已查看)',
  `isfile` smallint(6) NULL DEFAULT NULL COMMENT '表单状态(0:未提交,1:已提交,2:已归档,3:已驳回)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目培训记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcusttrain_attach
-- ----------------------------
DROP TABLE IF EXISTS `tcusttrain_attach`;
CREATE TABLE `tcusttrain_attach`  (
  `ID` int(11) NOT NULL,
  `custtrainid` int(11) NULL DEFAULT NULL COMMENT '项目培训记录ID(外键，指向tcusttrain.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目培训记录签到表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcusttrain_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tcusttrain_attachment`;
CREATE TABLE `tcusttrain_attachment`  (
  `ID` int(11) NOT NULL,
  `custtrainid` int(11) NULL DEFAULT NULL COMMENT '项目培训记录ID(外键，指向tcusttrain.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目培训记录附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcusttrain_detail
-- ----------------------------
DROP TABLE IF EXISTS `tcusttrain_detail`;
CREATE TABLE `tcusttrain_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `custtrainid` int(11) NULL DEFAULT NULL COMMENT '项目培训记录ID(外键，指向tcusttrain.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称	(外键，指向tproject.ID)',
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(0：未删除，1：已删除)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目培训记录项目信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tcusttype
-- ----------------------------
DROP TABLE IF EXISTS `tcusttype`;
CREATE TABLE `tcusttype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户满意度调查对象分类名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户满意度调查对象分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tdocout
-- ----------------------------
DROP TABLE IF EXISTS `tdocout`;
CREATE TABLE `tdocout`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户文件发放记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tdocout_attach
-- ----------------------------
DROP TABLE IF EXISTS `tdocout_attach`;
CREATE TABLE `tdocout_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `docoutid` int(11) NULL DEFAULT NULL COMMENT '用户文件发放记录外键',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户文件发放记录附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for templet_file
-- ----------------------------
DROP TABLE IF EXISTS `templet_file`;
CREATE TABLE `templet_file`  (
  `ID` int(11) NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `pageid` int(11) NULL DEFAULT NULL COMMENT '模板页面(外键，指向tsysmodule.ID)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for temployee
-- ----------------------------
DROP TABLE IF EXISTS `temployee`;
CREATE TABLE `temployee`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `user_login` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录账号',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '在职标识(0：在职，1：离职)',
  `isdel` int(11) NULL DEFAULT NULL,
  `techlevel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技术等级',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '所在销售服务中心(外键，指向tsalecenter.ID)',
  `sex` int(11) NULL DEFAULT NULL COMMENT '性别（0：女，1：男）',
  `birthdate` datetime NULL DEFAULT NULL COMMENT '出生日期',
  `birthaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出生地',
  `datetype` int(11) NULL DEFAULT NULL COMMENT '农历/公历(0：农历，1：公历)',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系邮箱',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `education` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历',
  `ismarry` int(11) NULL DEFAULT NULL COMMENT '婚姻状况( 1：已婚，2：未婚)',
  `politics` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '政治面貌',
  `createtime` datetime NULL DEFAULT NULL,
  `jobnumber` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工号',
  `duty` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职务',
  `totalscore` double NULL DEFAULT NULL COMMENT '分数',
  `oaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA员工ID',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `idcard` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for temployee_detail
-- ----------------------------
DROP TABLE IF EXISTS `temployee_detail`;
CREATE TABLE `temployee_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '员工档案ID(外键，指向temployee.ID)',
  `startdate` datetime NULL DEFAULT NULL COMMENT '起始日期',
  `enddate` datetime NULL DEFAULT NULL COMMENT '截止日期',
  `orgid` int(11) NULL DEFAULT NULL COMMENT '所在销售服务中心(外键，指向torganization.ID)',
  `score` double NULL DEFAULT NULL COMMENT '销售服务中心经理评分',
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(0：未删除，1：已删除)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `areaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务区域外键，指向torganization.ID',
  `positionid` int(11) NULL DEFAULT NULL COMMENT '岗位外键，指向torganizationposition.ID',
  `areaname` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务区域名称',
  `employeepositionid` int(11) NULL DEFAULT NULL COMMENT '员工部门明细表id,指向temployeeposition.id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for temployeeposition
-- ----------------------------
DROP TABLE IF EXISTS `temployeeposition`;
CREATE TABLE `temployeeposition`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `employee` int(11) NULL DEFAULT NULL COMMENT '员工ID',
  `organization` int(11) NULL DEFAULT NULL COMMENT '组织ID',
  `position` int(11) NULL DEFAULT NULL COMMENT '岗位ID',
  `isposition` int(11) NULL DEFAULT NULL COMMENT '主岗位标识',
  `ismanager` int(11) NULL DEFAULT NULL COMMENT '负责人标识',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `worktypeid` int(11) NULL DEFAULT NULL COMMENT '兼职/全职',
  `areaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责区域ID',
  `areaname` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责区域名称',
  `oaemployee` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA员工ID',
  `oaorganization` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA部门ID',
  `oaposition` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA岗位ID',
  `oaareaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA区域ID（若OA无，则不需要导入该字段）',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工岗位角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tempposition
-- ----------------------------
DROP TABLE IF EXISTS `tempposition`;
CREATE TABLE `tempposition`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `employeename` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `jobnumber` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工号',
  `downtime` datetime NULL DEFAULT NULL COMMENT '下井时间',
  `uptime` datetime NULL DEFAULT NULL COMMENT '上井时间',
  `coal` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下井煤矿',
  `work` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `createtime` datetime NOT NULL COMMENT '导入时间',
  `isdel` int(11) NULL DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '井下人员定位表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tequipok
-- ----------------------------
DROP TABLE IF EXISTS `tequipok`;
CREATE TABLE `tequipok`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `okrate` decimal(10, 2) NULL DEFAULT NULL COMMENT '目标合格率',
  `date` datetime NULL DEFAULT NULL COMMENT '统计时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间(isdel)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `doctypeid` int(11) NULL DEFAULT NULL COMMENT '提交报告类型 ，指向 twarndays.ID',
  `runstateid` int(11) NULL DEFAULT NULL COMMENT '项目运行状态(外键，指向trunstate.ID)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '井下设备完好率表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tequipok_detail
-- ----------------------------
DROP TABLE IF EXISTS `tequipok_detail`;
CREATE TABLE `tequipok_detail`  (
  `ID` int(11) NOT NULL,
  `equipokid` int(11) NULL DEFAULT NULL COMMENT '井下设备完好率统计表ID外键(指向tequipok)',
  `partid` int(11) NULL DEFAULT NULL COMMENT '元件名称(指向tproduct)',
  `num` decimal(12, 2) NULL DEFAULT NULL COMMENT '安装数量',
  `oknum` decimal(12, 2) NULL DEFAULT NULL COMMENT '完好数量',
  `okrate` decimal(12, 2) NULL DEFAULT NULL COMMENT '完好率',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `supplylistid` int(11) NULL DEFAULT NULL COMMENT '物料清单id，外键指向tsupplylistnew.id（或tsupplylist.id相同）',
  `productcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '井下设备完好率统计表    井下设备主体内容表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for terppro_wbs
-- ----------------------------
DROP TABLE IF EXISTS `terppro_wbs`;
CREATE TABLE `terppro_wbs`  (
  `ID` int(11) NOT NULL,
  `erpprojectid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'erp项目id,外键，指向terpproject.erpid',
  `wbsid` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'wbsid',
  `wbscode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'wbs编号',
  `wbsname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'wbs项目名称',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `isreport` int(11) NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'WBS项目表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for terpproject
-- ----------------------------
DROP TABLE IF EXISTS `terpproject`;
CREATE TABLE `terpproject`  (
  `ID` int(11) NOT NULL,
  `erpid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联ERP项目ID / 项目定义ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联ERP项目名称 / 项目定义描述',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联ERP项目编号 / 项目定义名称',
  `isdel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `thiscreatetime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for texperience
-- ----------------------------
DROP TABLE IF EXISTS `texperience`;
CREATE TABLE `texperience`  (
  `ID` int(11) NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '故障描述',
  `date` datetime NULL DEFAULT NULL COMMENT '时间(isdel)',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间(isdel)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `analysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '故障分析',
  `process` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理过程',
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理结果',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '经验交流表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for texperience_attach
-- ----------------------------
DROP TABLE IF EXISTS `texperience_attach`;
CREATE TABLE `texperience_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `experienceid` int(11) NULL DEFAULT NULL COMMENT '经验交流ID(外键，指向texperience.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tinstalldebug
-- ----------------------------
DROP TABLE IF EXISTS `tinstalldebug`;
CREATE TABLE `tinstalldebug`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `reporttypeid` int(11) NULL DEFAULT NULL COMMENT '报告类型(1:日报，2:周报)',
  `startdate` datetime NULL DEFAULT NULL COMMENT '报告开始日期',
  `mineemployeeid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井上服务人员(外键，多选，指向temployee.ID)',
  `downemployeeid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井下服务人员(外键，多选，指向temployee.ID)',
  `mineemployeename` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井上服务人员名称',
  `downemployeename` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井下服务人员名称',
  `mainwork` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '主要工作',
  `unfinishwork` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '未完成工作',
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '存在问题',
  `workplan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作计划',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `enddate` datetime NULL DEFAULT NULL COMMENT '报告结束日期',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安装调试阶段报告表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tinstalldebug_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tinstalldebug_attachment`;
CREATE TABLE `tinstalldebug_attachment`  (
  `ID` int(11) NOT NULL,
  `installdebugid` int(11) NULL DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `uploaddate` datetime NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmainreporttype
-- ----------------------------
DROP TABLE IF EXISTS `tmainreporttype`;
CREATE TABLE `tmainreporttype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报告类型名称',
  `isdel` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运行维护阶段报告类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmaintenance
-- ----------------------------
DROP TABLE IF EXISTS `tmaintenance`;
CREATE TABLE `tmaintenance`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `main` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '整体运行情况',
  `custuse` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '客户使用情况',
  `damage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '产品损坏情况',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '报告时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `doctypeid` int(11) NULL DEFAULT NULL COMMENT '提交报告类型 ，指向 twarndays.ID',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运行维护阶段报告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmaintenance_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tmaintenance_attachment`;
CREATE TABLE `tmaintenance_attachment`  (
  `ID` int(11) NOT NULL,
  `maintenanceid` int(11) NULL DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `uploaddate` datetime NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketlase
-- ----------------------------
DROP TABLE IF EXISTS `tmarketlase`;
CREATE TABLE `tmarketlase`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `type` int(11) NULL DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目丢失原因表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprofinal
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprofinal`;
CREATE TABLE `tmarketprofinal`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目名称外键(指向tmarketproject)',
  `isdel` int(11) NULL DEFAULT NULL,
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `orgid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心',
  `describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场项目内容描述',
  `summary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售工作情况总结',
  `problem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售工作存在问题',
  `experience` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售工作借鉴经验',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目总结报告表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject`;
CREATE TABLE `tmarketproject`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场项目名称',
  `typeid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场项目类型(外键tmarkettype)',
  `typename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场项目类型名称',
  `sourceid` int(11) NULL DEFAULT NULL COMMENT '项目来源（外键tmarketsource）',
  `employee` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '具体负责人',
  `servicecenter` int(11) NULL DEFAULT NULL COMMENT '主要销售服务中心',
  `otherservicecenterid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他销售服务中心ID',
  `otherservicecentername` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他服务中心负责人名称',
  `province` int(11) NULL DEFAULT NULL COMMENT '省',
  `city` int(11) NULL DEFAULT NULL COMMENT '市',
  `describe` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场项目描述',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `customer` int(11) NULL DEFAULT NULL COMMENT '客户名称',
  `ring` int(11) NULL DEFAULT NULL COMMENT '所属集团',
  `colliery` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在矿井',
  `workplane` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在工作面',
  `starttime` datetime NULL DEFAULT NULL COMMENT '项目开始时间',
  `specialrequire` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户特殊要求',
  `secondremark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `cc` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮件抄送人',
  `projecttype` int(11) NULL DEFAULT NULL COMMENT '项目类型(外键tmarketprojecttype)',
  `markettype` int(11) NULL DEFAULT NULL COMMENT '项目市场类别',
  `tenderinfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '招标基本信息',
  `dealprice` decimal(12, 2) NULL DEFAULT NULL COMMENT '项目成交价',
  `statusrecond` int(11) NULL DEFAULT NULL COMMENT '项目状态记录(外键tmarketstatu)',
  `losereason` int(11) NULL DEFAULT NULL COMMENT '项目丢失原因（外键tmarketlase）',
  `reasonremark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目状态记录备注',
  `oacode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oa编号',
  `projectcontractcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目合同编号',
  `time` datetime NULL DEFAULT NULL COMMENT '后续市场信息时间提醒',
  `marketinfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后续市场信息描述',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `employeename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '具体负责人名称',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_area
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_area`;
CREATE TABLE `tmarketproject_area`  (
  `ID` int(11) NOT NULL,
  `provinceid` int(11) NULL DEFAULT NULL COMMENT '省',
  `cityid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',
  `cityText` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市名称',
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目名称外键(指向tmarketproject)',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息矿井行政区域表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_attachment`;
CREATE TABLE `tmarketproject_attachment`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识(isdel)',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_offer
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_offer`;
CREATE TABLE `tmarketproject_offer`  (
  `ID` int(11) NOT NULL,
  `price` double NULL DEFAULT NULL COMMENT '天玛报价',
  `otherprice` double NULL DEFAULT NULL COMMENT '竞争对手报价',
  `time` int(11) NULL DEFAULT NULL COMMENT '报价次数',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息天玛报价表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_people
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_people`;
CREATE TABLE `tmarketproject_people`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目负责人',
  `sex` int(11) NULL DEFAULT NULL COMMENT '性别',
  `duty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位',
  `linktel` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `type` int(11) NULL DEFAULT NULL COMMENT '人员类型',
  `state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关键状态',
  `isdel` int(11) NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息人员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_peopletype
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_peopletype`;
CREATE TABLE `tmarketproject_peopletype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息人员类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_person
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_person`;
CREATE TABLE `tmarketproject_person`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目负责人姓名',
  `duty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职务',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `linktel` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `work` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责工作',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息相关人物' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_rival
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_rival`;
CREATE TABLE `tmarketproject_rival`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '竞争对手名称',
  `record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '竞争对手记录',
  `isdel` int(11) NULL DEFAULT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息竞争对手' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketproject_tender
-- ----------------------------
DROP TABLE IF EXISTS `tmarketproject_tender`;
CREATE TABLE `tmarketproject_tender`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件自动生成名称',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识(isdel)',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传日期',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场信息招标' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprojecttype
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprojecttype`;
CREATE TABLE `tmarketprojecttype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目类别（项目市场信息）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprotrack
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprotrack`;
CREATE TABLE `tmarketprotrack`  (
  `ID` int(11) NOT NULL,
  `marketproject` int(11) NULL DEFAULT NULL COMMENT '市场项目外键(指向tmarketproject)',
  `orgid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心',
  `isdel` int(11) NULL DEFAULT NULL,
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目跟踪记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprotrack_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprotrack_attachment`;
CREATE TABLE `tmarketprotrack_attachment`  (
  `ID` int(11) NOT NULL,
  `marketprotrack` int(11) NULL DEFAULT NULL COMMENT '市场项目跟踪记录(外键，指向tmarketprotrack)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识(isdel)',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目跟踪记录附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprotrack_detail
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprotrack_detail`;
CREATE TABLE `tmarketprotrack_detail`  (
  `ID` int(11) NOT NULL,
  `marketprotrack` int(11) NULL DEFAULT NULL COMMENT '市场项目跟踪记录(外键，指向tmarketprotrack)',
  `isdel` int(11) NULL DEFAULT NULL,
  `salerecond` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售记录',
  `time` datetime NULL DEFAULT NULL COMMENT '时间',
  `work` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售工作',
  `creater` int(11) NULL DEFAULT NULL COMMENT '填报人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目跟踪记录明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprotrack_trouble
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprotrack_trouble`;
CREATE TABLE `tmarketprotrack_trouble`  (
  `ID` int(11) NOT NULL,
  `marketprotrack` int(11) NULL DEFAULT NULL COMMENT '市场项目跟踪记录(外键，指向tmarketprotrack)',
  `isdel` int(11) NULL DEFAULT NULL,
  `trouble` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目困难',
  `describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目跟踪记录明细（项目困难）表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketprotype
-- ----------------------------
DROP TABLE IF EXISTS `tmarketprotype`;
CREATE TABLE `tmarketprotype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市场类别名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目市场类别表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketsource
-- ----------------------------
DROP TABLE IF EXISTS `tmarketsource`;
CREATE TABLE `tmarketsource`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目来源表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarketstatu
-- ----------------------------
DROP TABLE IF EXISTS `tmarketstatu`;
CREATE TABLE `tmarketstatu`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态记录名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目状态记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmarkettype
-- ----------------------------
DROP TABLE IF EXISTS `tmarkettype`;
CREATE TABLE `tmarkettype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目类型名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市场项目类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmatchnum
-- ----------------------------
DROP TABLE IF EXISTS `tmatchnum`;
CREATE TABLE `tmatchnum`  (
  `ID` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `isdisable` int(11) NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmiss
-- ----------------------------
DROP TABLE IF EXISTS `tmiss`;
CREATE TABLE `tmiss`  (
  `ID` int(11) NOT NULL,
  `receiptid` int(11) NULL DEFAULT NULL COMMENT '接货记录ID(外键,指向treceive)',
  `sendaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  `receiveaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货地址',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `mistakestype` int(11) NULL DEFAULT NULL COMMENT '错漏记录类型',
  `missingno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '记录单号',
  `receiptdate` datetime NULL DEFAULT NULL COMMENT '接货时间',
  `receipter` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货人员',
  `solvedate` datetime NULL DEFAULT NULL COMMENT '解决时间',
  `relation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联记录指向treceive',
  `totalnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总数量',
  `totalmissingnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总错漏货数量',
  `issolve` int(11) NULL DEFAULT NULL COMMENT '是否解决(1，是；0，否)',
  `relationname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联记录',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '错发漏发记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmiss_detail
-- ----------------------------
DROP TABLE IF EXISTS `tmiss_detail`;
CREATE TABLE `tmiss_detail`  (
  `ID` int(11) NOT NULL,
  `missid` int(11) NULL DEFAULT NULL COMMENT '接货记录ID(外键，指向tmiss.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `num` decimal(12, 2) NULL DEFAULT NULL COMMENT '数量',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `isprojectid` int(11) NULL DEFAULT NULL COMMENT '涉及项目	0：否，1：是',
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应发货品名',
  `missingproduct` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错漏货品名称',
  `missingnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '错漏数量',
  `missingproductname` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '错发漏发记录明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tmodel
-- ----------------------------
DROP TABLE IF EXISTS `tmodel`;
CREATE TABLE `tmodel`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厂家名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `num` int(11) NULL DEFAULT NULL COMMENT '累计使用次数',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支架型号表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tnotice
-- ----------------------------
DROP TABLE IF EXISTS `tnotice`;
CREATE TABLE `tnotice`  (
  `ID` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知内容(解析之前)',
  `date` datetime NULL DEFAULT NULL COMMENT '时间',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `new` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知内容(解析之后)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tnotice_attach
-- ----------------------------
DROP TABLE IF EXISTS `tnotice_attach`;
CREATE TABLE `tnotice_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `noticeid` int(11) NULL DEFAULT NULL COMMENT '通知ID(外键，指向tnotice.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for torganization
-- ----------------------------
DROP TABLE IF EXISTS `torganization`;
CREATE TABLE `torganization`  (
  `ID` int(11) NOT NULL,
  `PID` int(11) NULL DEFAULT NULL COMMENT '父级组织机构ID(树形，指向torganization.ID)',
  `orgcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构编码',
  `orgname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构名称',
  `isdel` int(11) NULL DEFAULT NULL,
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `oaid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oa部门ID',
  `oapid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oa部门父ID',
  `isarea` int(11) NULL DEFAULT NULL COMMENT '是否是区域（0：不是；1：是）',
  `type` int(11) NULL DEFAULT NULL COMMENT '组织类型指向torgtype',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for torganizationcode
-- ----------------------------
DROP TABLE IF EXISTS `torganizationcode`;
CREATE TABLE `torganizationcode`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `orgid` int(11) NULL DEFAULT NULL COMMENT '机构ID',
  `province` int(11) NULL DEFAULT NULL COMMENT '省份',
  `city` int(11) NULL DEFAULT NULL COMMENT '城市',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组织机构-省市编码' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for torganizationposition
-- ----------------------------
DROP TABLE IF EXISTS `torganizationposition`;
CREATE TABLE `torganizationposition`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `orgid` int(11) NULL DEFAULT NULL COMMENT '机构ID',
  `positionname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位名称',
  `positionlevel` int(11) NULL DEFAULT NULL COMMENT '岗位级别',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createtime` datetime NULL DEFAULT NULL,
  `oaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oa岗位ID',
  `oaorgid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oa机构ID',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组织岗位' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for torgtype
-- ----------------------------
DROP TABLE IF EXISTS `torgtype`;
CREATE TABLE `torgtype`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `level` int(11) NULL DEFAULT NULL COMMENT '级别',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组织类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for totherlog
-- ----------------------------
DROP TABLE IF EXISTS `totherlog`;
CREATE TABLE `totherlog`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `workdate` datetime NULL DEFAULT NULL COMMENT '工作日期',
  `workemployeeid` int(11) NULL DEFAULT NULL COMMENT '工作人员(外键指向temployee.id)',
  `otheremployeeid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他工作人员(多选，外键指向temployee.id)',
  `otheremployeename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他工作人员姓名',
  `isbusitravel` tinyint(4) NULL DEFAULT NULL COMMENT '出差状态(0:未出差 1:已出差)',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键，指向torganization.id)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for totherlog_attach
-- ----------------------------
DROP TABLE IF EXISTS `totherlog_attach`;
CREATE TABLE `totherlog_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `otherlogid` int(11) NULL DEFAULT NULL COMMENT '工作日志主表(外键，指向totherlog.ID)',
  `filename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件名称',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for totherlog_detail
-- ----------------------------
DROP TABLE IF EXISTS `totherlog_detail`;
CREATE TABLE `totherlog_detail`  (
  `ID` int(11) NOT NULL,
  `otherlogid` int(11) NULL DEFAULT NULL COMMENT '工作日志主表(外键指向totherlog.id)',
  `worktypeid` tinyint(4) NULL DEFAULT NULL COMMENT '工作类型(0:市场销售  1:货品批发2:出厂服务 3：日常工作)',
  `mession` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务',
  `worktime_start` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作时间_开始',
  `worktime_end` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作时间_结束',
  `workcontent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '其他工作日志工作内容明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for totherlog_employee
-- ----------------------------
DROP TABLE IF EXISTS `totherlog_employee`;
CREATE TABLE `totherlog_employee`  (
  `ID` int(11) NOT NULL,
  `otherlogid` int(11) NULL DEFAULT NULL COMMENT '工作日志主表(外键指向totherlog.id)',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '其他工作人员id（外键指向temployee.id）',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除 1:已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '其他工作日志其他工作人员明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpartdamage
-- ----------------------------
DROP TABLE IF EXISTS `tpartdamage`;
CREATE TABLE `tpartdamage`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间(isdel)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `okrate` decimal(10, 2) NULL DEFAULT NULL COMMENT '目标合格率',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目元件损坏情况表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpartdamage_detail
-- ----------------------------
DROP TABLE IF EXISTS `tpartdamage_detail`;
CREATE TABLE `tpartdamage_detail`  (
  `ID` int(11) NOT NULL,
  `partdamageid` int(11) NULL DEFAULT NULL COMMENT '项目元件损坏ID(外键，指向tpartdamage.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `date` datetime NULL DEFAULT NULL COMMENT '损坏时间',
  `num` int(11) NULL DEFAULT NULL COMMENT '损坏元器件总数量',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `softtext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '软件特殊情况记录',
  `tsupplylist_detailnewid` int(11) NULL DEFAULT NULL COMMENT '物料清单明细表id，外键指向tsupplylist_detailnew.id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '元器件累计损坏统计明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpartinstall
-- ----------------------------
DROP TABLE IF EXISTS `tpartinstall`;
CREATE TABLE `tpartinstall`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `date` datetime NULL DEFAULT NULL COMMENT '统计时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `passrate` decimal(10, 2) NULL DEFAULT NULL COMMENT '目标合格率',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '一次安装合格率' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpartinstall_detail
-- ----------------------------
DROP TABLE IF EXISTS `tpartinstall_detail`;
CREATE TABLE `tpartinstall_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `partinstallid` int(11) NULL DEFAULT NULL COMMENT '一次安装合格率统计表ID(外键，指向tpartinstall.ID)',
  `partid` int(11) NULL DEFAULT NULL COMMENT '元件名称',
  `num` int(11) NULL DEFAULT NULL COMMENT '安装数量',
  `failnum` int(11) NULL DEFAULT NULL COMMENT '不合格品数量',
  `okrate` decimal(12, 2) NULL DEFAULT NULL COMMENT '合格率',
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(0：未删除，1：已删除)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `supplylistid` int(11) NULL DEFAULT NULL COMMENT '物料清单id，外键指向tsupplylistnew.id（或tsupplylist.id相同）',
  `productcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '一次安装合格率明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpick
-- ----------------------------
DROP TABLE IF EXISTS `tpick`;
CREATE TABLE `tpick`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `salecenter` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域/销售服务中心',
  `employeename` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `pickcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请单号',
  `pickdate` datetime NULL DEFAULT NULL COMMENT '申请日期',
  `picktype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采购类型',
  `urgentlevel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '紧急程度',
  `reservecode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预留号码',
  `finishdate` datetime NULL DEFAULT NULL COMMENT '办结日期',
  `totalmoney` decimal(12, 2) NULL DEFAULT NULL COMMENT '物料总价',
  `ledgerinfo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总账科目信息',
  `ledgercode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总账科目编号',
  `orderinfo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内部订单信息',
  `ordercode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内部订单编号',
  `costcenterinfo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成本中心信息',
  `costcentercode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成本中心编号',
  `projectinfo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目信息',
  `projectledgercode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目编号',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注说明',
  `createtime` datetime NULL DEFAULT NULL COMMENT '导入时间',
  `empjobnumber` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人工号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '费用领料单主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tpick_product
-- ----------------------------
DROP TABLE IF EXISTS `tpick_product`;
CREATE TABLE `tpick_product`  (
  `ID` int(11) NOT NULL,
  `pickcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请单号,外键指向tpick.pickcode',
  `productcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `productname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `productunit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `price` decimal(12, 2) NULL DEFAULT NULL,
  `stockloc` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `stockcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL COMMENT '导入时间',
  `productnum` int(11) NULL DEFAULT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '关联项目,外键指向tproject.id',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '费用领料单-产品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproduct
-- ----------------------------
DROP TABLE IF EXISTS `tproduct`;
CREATE TABLE `tproduct`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称、物料长描述',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注（为空，未导入，后期不用可删除该冗余字段）',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号/物料短描述（规格型号Z3)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `productno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品号（为空，未导入，后期不用可删除该冗余字段）',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '基本计量单位',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `erpid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ERP产品ID（为空，未导入，后期不用可删除该冗余字段）',
  `groupno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料组',
  `type` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料类型',
  `typedesc` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料类型描述',
  `unitdesc` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '基本计量单位描述',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '元件档案/产品档案' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproduct_type
-- ----------------------------
DROP TABLE IF EXISTS `tproduct_type`;
CREATE TABLE `tproduct_type`  (
  `ID` int(11) NOT NULL,
  `typename` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料类型',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(1:已删,0:未删)',
  `projecttype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目类型，多选',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `projecttype_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目类型名称',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '元件分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject
-- ----------------------------
DROP TABLE IF EXISTS `tproject`;
CREATE TABLE `tproject`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `shortname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目简称',
  `groupid` int(11) NULL DEFAULT NULL COMMENT '所属集团',
  `coal` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用煤矿',
  `provinceid` int(11) NULL DEFAULT NULL COMMENT '省(外键，指向tarea.ID)',
  `cityid` int(11) NULL DEFAULT NULL COMMENT '市(外键，指向tarea.ID)',
  `countyid` int(11) NULL DEFAULT NULL COMMENT '县(外键，指向tarea.ID)',
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详细地址',
  `typeid` int(11) NULL DEFAULT NULL COMMENT '项目类型(外键，指向tprojecttype.ID)',
  `matchnum` int(11) NULL DEFAULT NULL COMMENT '配套套数',
  `repairsate` int(11) NULL DEFAULT NULL COMMENT '项目维修状况(外键，指向trepairstate.ID)',
  `runstate` int(11) NULL DEFAULT NULL COMMENT '项目运行状态(外键，指向trunstate.ID)',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键，指向tsalecenter.ID)',
  `majoremployeeid` int(11) NULL DEFAULT NULL COMMENT '项目主要负责人(外键，指向temployee.ID)',
  `otheremployee` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目其他负责人(外键，多选，指向temployee.ID)',
  `name` int(11) NULL DEFAULT NULL COMMENT '关联ERP项目',
  `code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联ERP编号',
  `arrivedate` datetime NULL DEFAULT NULL COMMENT '设备到货时间',
  `installdate` datetime NULL DEFAULT NULL COMMENT '井下安装时间',
  `productdate` datetime NULL DEFAULT NULL COMMENT '开始生产时间',
  `warrantystart` datetime NULL DEFAULT NULL COMMENT '质保期-起始',
  `warranty` int(11) NULL DEFAULT NULL COMMENT '质保期',
  `warrantyend` datetime NULL DEFAULT NULL COMMENT '质保期-结束',
  `parentproject` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '前置项目(多选外键，指向tproject.ID)',
  `starttime` datetime NULL DEFAULT NULL COMMENT '工作面使用起始时间',
  `endtime` datetime NULL DEFAULT NULL COMMENT '工作面使用结束时间',
  `coalname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作面使用煤矿',
  `facename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用煤矿',
  `auxiliaryvalvesuppid` int(11) NULL DEFAULT NULL COMMENT '支架辅助阀-厂家(外键，指向tsupplier.ID)',
  `onewayvalvemodel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支架立柱液控单向阀-型号',
  `suppfiltsupplierid` int(11) NULL DEFAULT NULL COMMENT '支架过滤器厂家(外键，指向tsupplier.ID)',
  `suppfiltmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支架过滤器型号',
  `suppfilttype` int(11) NULL DEFAULT NULL COMMENT '支架过滤器类型',
  `highpresupplierid` int(11) NULL DEFAULT NULL COMMENT '高压过滤站厂家(外键，指向tsupplier.ID)',
  `highpremodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '高压过滤站型号',
  `highpretype` int(11) NULL DEFAULT NULL COMMENT '高压过滤站类型',
  `suppcontsupplierid` int(11) NULL DEFAULT NULL COMMENT '支架电控系统-厂家(外键，指向tsupplier.ID)',
  `suppcontmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支架控制器-型号',
  `posdetectype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采煤机位置检测装置类型',
  `upload` int(11) NULL DEFAULT NULL COMMENT '数据上传（有/无）(0：无，1：有)',
  `machinerytrack` int(11) NULL DEFAULT NULL COMMENT '跟机自动化（有/无）(0：无，1：有)',
  `liquidsuppsupplierid` int(11) NULL DEFAULT NULL COMMENT '集成供液系统-厂家(外键，指向tsupplier.ID)',
  `liquidsuppmodel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '集成供液系统-型号',
  `plc` int(11) NULL DEFAULT NULL COMMENT '集成供液系统-PLC信息(0: 无，1: 有)',
  `varyfrequency` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '集成供液系统-变频信息',
  `emulsionpumpsupplierid` int(11) NULL DEFAULT NULL COMMENT '乳化液泵站厂家(外键，指向tsupplier.ID)',
  `emulsionpumpmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '乳化液泵站型号',
  `emulsionpumpnum` double NULL DEFAULT NULL COMMENT '乳化液泵站数量',
  `spraypumpsupplierid` int(11) NULL DEFAULT NULL COMMENT '喷雾泵泵站厂家(外键，指向tsupplier.ID)',
  `spraypumpmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '喷雾泵泵站型号',
  `spraypumpnum` double NULL DEFAULT NULL COMMENT '喷雾泵泵站数量',
  `watertanknum` double NULL DEFAULT NULL COMMENT '水箱-数量',
  `watertankvolume` double NULL DEFAULT NULL COMMENT '水箱-容量',
  `mixturetanknum` double NULL DEFAULT NULL COMMENT '混合液箱-数量',
  `mixturetankvolume` double NULL DEFAULT NULL COMMENT '混合液箱-容量',
  `returntanknum` double NULL DEFAULT NULL COMMENT '回液箱-数量',
  `returntankvolume` double NULL DEFAULT NULL COMMENT '回液箱-容量',
  `mmassupplier` int(11) NULL DEFAULT NULL COMMENT '综采自动化系统-厂家(外键，指向tsupplier.ID)',
  `mmasvideo` int(11) NULL DEFAULT NULL COMMENT '综采自动化系统视频（有/无）(0: 无， 1: 有)',
  `mmasremocont` int(11) NULL DEFAULT NULL COMMENT '综采自动化系统远控（有/无）(0: 无， 1: 有)',
  `minesupplierid` int(11) NULL DEFAULT NULL COMMENT '采煤机厂家(外键，指向tsupplier.ID)_',
  `minemodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采煤机型号',
  `scrapersupplierid` int(11) NULL DEFAULT NULL COMMENT '刮板运输机厂家(外键，指向tsupplier.ID)',
  `scrapermodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刮板运输机型号',
  `beltsupplierid` int(11) NULL DEFAULT NULL COMMENT '皮带运输机-厂家(外键，指向tsupplier.ID)',
  `beltmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '皮带运输机-型号',
  `threecontsupplierid` int(11) NULL DEFAULT NULL COMMENT '三机控制-厂家(外键，指向tsupplier.ID)',
  `threecontmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三机控制-型号',
  `threemonitsupplierid` int(11) NULL DEFAULT NULL COMMENT '三机监测-厂家(外键，指向tsupplier.ID)',
  `threemonitmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三机监测-型号',
  `switchsupplierid` int(11) NULL DEFAULT NULL COMMENT '组合开关-厂家(外键，指向tsupplier.ID)',
  `switchmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组合开关-型号',
  `voicecommsupplierid` int(11) NULL DEFAULT NULL COMMENT '工作面语音通信-厂家(外键，指向tsupplier.ID)',
  `voicecommmodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作面语音通信-型号',
  `supportnum` double NULL DEFAULT NULL COMMENT '配套支架总架数',
  `invertersupplierid` int(11) NULL DEFAULT NULL COMMENT '变频器-厂家(外键，指向tsupplier.ID)',
  `invertermodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变频器-型号',
  `isdel` int(11) NULL DEFAULT NULL,
  `isdisable` int(11) NULL DEFAULT NULL,
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `totalauxnum` decimal(20, 2) NULL DEFAULT NULL COMMENT '总的支架数量',
  `totalvalvefunctionnum` decimal(20, 2) NULL DEFAULT NULL COMMENT '总的支架主阀-功能数',
  `projectid` int(11) NULL DEFAULT NULL,
  `otheremployeename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目其他负责人(外键，多选，指向temployee.ID)',
  `emulsifyoil` int(11) NULL DEFAULT NULL COMMENT '乳化油厂家',
  `servicearea` int(11) NULL DEFAULT NULL COMMENT '区域',
  `workplane` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前使用工作面',
  `qastate` int(11) NULL DEFAULT NULL COMMENT '质保状态',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `wbsid` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'wbsid',
  `oldgroup` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '曾用名',
  `watersupplier` int(11) NULL DEFAULT NULL COMMENT '水处理装置_厂家',
  `watermodel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水处理装置_型号',
  `supporttype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '中间架支架型号',
  `nowarranty` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject_face
-- ----------------------------
DROP TABLE IF EXISTS `tproject_face`;
CREATE TABLE `tproject_face`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作面名称',
  `length` double NULL DEFAULT NULL COMMENT '工作面走向长度',
  `aveheight` double NULL DEFAULT NULL COMMENT '工作面平均采高',
  `incangle` double NULL DEFAULT NULL COMMENT '工作面倾斜角度',
  `inclength` double NULL DEFAULT NULL COMMENT '工作面倾斜长度',
  `roof` int(11) NULL DEFAULT NULL COMMENT '顶板条件',
  `topcoal` int(11) NULL DEFAULT NULL COMMENT '放顶煤（是/否）(0：否，1：是)',
  `gas` int(11) NULL DEFAULT NULL COMMENT '瓦斯含量（高/低）(0：低，1：高)',
  `avedaioutput` double NULL DEFAULT NULL COMMENT '平均日产（万吨）',
  `maxdaioutput` double NULL DEFAULT NULL COMMENT '最高日产（万吨）',
  `avemonoutput` double NULL DEFAULT NULL COMMENT '平均月产（万吨）',
  `maxmonoutput` double NULL DEFAULT NULL COMMENT '最高月产（万吨）',
  `faceoutput` double NULL DEFAULT NULL COMMENT '总产量（万吨）',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `isdel` int(11) NULL DEFAULT NULL,
  `starttime` datetime NULL DEFAULT NULL COMMENT '工作面使用起始时间',
  `endtime` datetime NULL DEFAULT NULL COMMENT '工作面使用结束时间',
  `coalname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作面使用煤矿',
  `projectstateid` int(11) NULL DEFAULT NULL COMMENT '项目运行状态id，指向tprojectstate.id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作面使用情况' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject_otheremployee
-- ----------------------------
DROP TABLE IF EXISTS `tproject_otheremployee`;
CREATE TABLE `tproject_otheremployee`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `otheremployeeid` int(11) NULL DEFAULT NULL COMMENT '其他项目负责人id(外键，指向temployee.ID)',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject_parent
-- ----------------------------
DROP TABLE IF EXISTS `tproject_parent`;
CREATE TABLE `tproject_parent`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '主表ID',
  `projectname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL,
  `preprojectid` int(11) NULL DEFAULT NULL COMMENT '前置项目ID ',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject_province
-- ----------------------------
DROP TABLE IF EXISTS `tproject_province`;
CREATE TABLE `tproject_province`  (
  `id` smallint(6) NOT NULL,
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PID` smallint(6) NULL DEFAULT NULL,
  `type` smallint(6) NULL DEFAULT NULL,
  `initial` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `initials` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pinyin` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `extra` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `suffix` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `code` char(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `area_code` char(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `order` tinyint(4) NULL DEFAULT NULL,
  `isdisable` smallint(6) NULL DEFAULT NULL,
  `isdel` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tproject_support
-- ----------------------------
DROP TABLE IF EXISTS `tproject_support`;
CREATE TABLE `tproject_support`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `supplierid` int(11) NULL DEFAULT NULL COMMENT '供货厂家(外键，指向tsupplier.ID)',
  `typeid` int(11) NULL DEFAULT NULL COMMENT '支架类型(外键，指向tsupport_type.ID)',
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号',
  `num` float NULL DEFAULT NULL COMMENT '数量',
  `mainvalvesupp` int(11) NULL DEFAULT NULL COMMENT '主阀厂家',
  `mainvalvemodel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主阀型号',
  `mainvalvefuncnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '主阀功能数',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `projectstateid` int(11) NULL DEFAULT NULL COMMENT '项目运行状态id，指向tprojectstate.id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配套支架明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tprojectstate
-- ----------------------------
DROP TABLE IF EXISTS `tprojectstate`;
CREATE TABLE `tprojectstate`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目运行状态变更' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tprojectstate_detail
-- ----------------------------
DROP TABLE IF EXISTS `tprojectstate_detail`;
CREATE TABLE `tprojectstate_detail`  (
  `ID` int(11) NOT NULL,
  `projectstateid` int(11) NULL DEFAULT NULL COMMENT '运行状态变更 外键，指向tprojectstate.ID',
  `happendate` datetime NULL DEFAULT NULL COMMENT '发生时间',
  `runstate` int(11) NULL DEFAULT NULL COMMENT '运行状态 外键，指向trunstate.ID',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人',
  `createmanname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人姓名',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目运行状态变更明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tprojecttype
-- ----------------------------
DROP TABLE IF EXISTS `tprojecttype`;
CREATE TABLE `tprojecttype`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treceive
-- ----------------------------
DROP TABLE IF EXISTS `treceive`;
CREATE TABLE `treceive`  (
  `ID` int(11) NOT NULL,
  `date` datetime NULL DEFAULT NULL COMMENT '接货时间',
  `sendaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  `receiveaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货地址',
  `receiveman` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货人姓名',
  `receivephone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货人电话',
  `notifierid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知人(外键，多选，指向temployee.ID)',
  `notifiername` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知人姓名',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键，指向tsalecenter.ID)',
  `money` decimal(12, 2) NULL DEFAULT NULL COMMENT '发生费用',
  `iscommit` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `totalnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总数量',
  `totalmoney` decimal(12, 2) NULL DEFAULT NULL COMMENT '总钱数',
  `totalreceiptnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总的收货数量',
  `totalwrongnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总的错误记录',
  `deliveryid` int(11) NULL DEFAULT NULL COMMENT '发货记录ID(外键，指向tsend.ID)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接货记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treceive_detail
-- ----------------------------
DROP TABLE IF EXISTS `treceive_detail`;
CREATE TABLE `treceive_detail`  (
  `ID` int(11) NOT NULL,
  `receiveid` int(11) NULL DEFAULT NULL COMMENT '接货记录ID(外键，指向treceive.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `listono` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '装箱清单单号',
  `serialno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序号',
  `productno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品号',
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品名',
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格',
  `sendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '数量',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
  `boxno` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '箱号',
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `attribute` int(11) NULL DEFAULT NULL COMMENT '关联属性',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `receivenum` decimal(12, 2) NULL DEFAULT NULL COMMENT '收货数量',
  `money` decimal(12, 2) NULL DEFAULT NULL COMMENT '费用总额',
  `isprojectid` int(11) NULL DEFAULT NULL COMMENT '涉及项目	0：否，1：是',
  `wrongnum` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误记录',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接货记录-明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treceiveprove
-- ----------------------------
DROP TABLE IF EXISTS `treceiveprove`;
CREATE TABLE `treceiveprove`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `date` datetime NULL DEFAULT NULL COMMENT '验收日期',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收地点',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '验收人员',
  `custnameid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户姓名	(外键，指向tcustbook.ID)',
  `custpost` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户职位',
  `custphone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户电话',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备到货验收表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treceiveprove_attachment
-- ----------------------------
DROP TABLE IF EXISTS `treceiveprove_attachment`;
CREATE TABLE `treceiveprove_attachment`  (
  `ID` int(11) NOT NULL,
  `receiveproveid` int(11) NULL DEFAULT NULL COMMENT '设备到货验收证明ID(外键，指向treceiveprove.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(isdel)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备到货验收附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treformnotice
-- ----------------------------
DROP TABLE IF EXISTS `treformnotice`;
CREATE TABLE `treformnotice`  (
  `ID` int(11) NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改主题',
  `reformstate` tinyint(4) NULL DEFAULT NULL COMMENT '整改状态(1:已发放 2:已确认 3:已提交 4:已完成)',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键，指向torganization.id)',
  `reformheadid` int(11) NULL DEFAULT NULL COMMENT '整改负责人(外键，指向temployee.id)',
  `reformmemberid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改组员id(多选，外键指向temployee.id)',
  `reformembername` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改组员名字',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '关联项目(外键指向tproject.id)',
  `reformcontent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '整改内容',
  `reformalteradvice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '整改意见',
  `reformdeadline` datetime NULL DEFAULT NULL COMMENT '整改期限',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  `issueorgid` int(11) NULL DEFAULT NULL COMMENT '发放部门(外键指向torganization.id)',
  `issuedate` datetime NULL DEFAULT NULL COMMENT '发放日期',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键指向temployee.id)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '填报时间',
  `confirmdate` datetime NULL DEFAULT NULL COMMENT '确认时间',
  `confirmemployee` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '确认人员',
  `reformplan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '整改计划',
  `finishdate` datetime NULL DEFAULT NULL COMMENT '完成时间',
  `isoverdue` tinyint(4) NULL DEFAULT NULL COMMENT '是否逾期',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除 1:已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '整改通知单主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treformnotice_attach
-- ----------------------------
DROP TABLE IF EXISTS `treformnotice_attach`;
CREATE TABLE `treformnotice_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `reformnoticeid` int(11) NULL DEFAULT NULL COMMENT '整改通知单(外键，指向treformnotice.ID)',
  `filename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件名称',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '整改通知单附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treformnotice_employee
-- ----------------------------
DROP TABLE IF EXISTS `treformnotice_employee`;
CREATE TABLE `treformnotice_employee`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `reformnoticeid` int(11) NULL DEFAULT NULL COMMENT '整改通知单主表(外键指向treformnotice.id)',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '整改组员id(外键，指向temployee.id)',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除 1:已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '整改通知单整改组员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treformnotice_record
-- ----------------------------
DROP TABLE IF EXISTS `treformnotice_record`;
CREATE TABLE `treformnotice_record`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `reformnoticeid` int(11) NULL DEFAULT NULL COMMENT '整改通制单主表id(外键指向treformnotice.id)',
  `recordemployeeid` int(11) NULL DEFAULT NULL COMMENT '记录人id(外键指向temployee.id)',
  `recorddate` datetime NULL DEFAULT NULL COMMENT '记录时间',
  `recordcontent` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除 1:已删除)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传附件名称',
  `uploaddateList` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传时间',
  `reportMan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '整改通知单整改记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for treformnotice_recordattach
-- ----------------------------
DROP TABLE IF EXISTS `treformnotice_recordattach`;
CREATE TABLE `treformnotice_recordattach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `reformnotice_recordid` int(11) NULL DEFAULT NULL COMMENT '整改通知单整改记录id(外键，指向treformnotice_record.ID)',
  `filename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '整改通知单记录附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairedreceive
-- ----------------------------
DROP TABLE IF EXISTS `trepairedreceive`;
CREATE TABLE `trepairedreceive`  (
  `ID` int(11) NOT NULL,
  `repairsendid` int(11) NULL DEFAULT NULL COMMENT '需维修产品发货单ID(外键，指向trepairsend.ID)',
  `repairsendcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需维修产品发货单号',
  `receivedate` datetime NULL DEFAULT NULL COMMENT '发货时间',
  `receiveaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地点',
  `totalsendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总维修发货数量',
  `isreceive` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `receiveemployeeid` int(11) NULL DEFAULT NULL COMMENT '发货登记人员(外键，指向temployee.ID)',
  `totalreceivenum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总实际到货数量',
  `deliveryno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接货单号',
  `deliverydate` datetime NULL DEFAULT NULL COMMENT '接货日期',
  `deliverysite` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货地点',
  PRIMARY KEY (`ID`, `deliveryno`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已维修产品接货单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairedreceive_detail
-- ----------------------------
DROP TABLE IF EXISTS `trepairedreceive_detail`;
CREATE TABLE `trepairedreceive_detail`  (
  `ID` int(11) NOT NULL,
  `repairedreceiveid` int(11) NULL DEFAULT NULL COMMENT '已维修产品接货单ID(外键，指向trepairreceive.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `productid` int(11) NULL DEFAULT NULL,
  `sendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '维修发货数量',
  `planbackdate` datetime NULL DEFAULT NULL COMMENT '计划返回时间',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `receivenum` decimal(12, 2) NULL DEFAULT NULL COMMENT '实际到货数量',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已维修产品接货-产品明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairedsend
-- ----------------------------
DROP TABLE IF EXISTS `trepairedsend`;
CREATE TABLE `trepairedsend`  (
  `ID` int(11) NOT NULL,
  `repairsendid` int(11) NULL DEFAULT NULL COMMENT '需维修产品发货单ID(外键，指向trepairsend.ID)',
  `repairsendcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需维修产品发货单号',
  `senddate` datetime NULL DEFAULT NULL COMMENT '发货时间',
  `sendaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送地点',
  `totalsendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总维修发货数量',
  `isreceive` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `sendemployeeid` int(11) NULL DEFAULT NULL COMMENT '发货登记人员(外键，指向temployee.ID)',
  `receiveid` int(11) NULL DEFAULT NULL COMMENT '需维修接货单(外键指向trepairreceive)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已维修产品发货单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairedsend_detail
-- ----------------------------
DROP TABLE IF EXISTS `trepairedsend_detail`;
CREATE TABLE `trepairedsend_detail`  (
  `ID` int(11) NOT NULL,
  `repairedsendid` int(11) NULL DEFAULT NULL COMMENT '已维修产品发货单ID(外键，指向trepairedsend.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `productid` int(11) NULL DEFAULT NULL COMMENT '产品ID',
  `sendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '维修发货数量',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已维修产品发货明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairprocess
-- ----------------------------
DROP TABLE IF EXISTS `trepairprocess`;
CREATE TABLE `trepairprocess`  (
  `ID` int(11) NOT NULL,
  `repairsendid` int(11) NULL DEFAULT NULL COMMENT '需维修产品发货单ID(外键，指向trepairsend.ID)',
  `repairsendcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需维修产品发货单号',
  `totalnotsendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '发货时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '发货时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `repairstateid` int(11) NULL DEFAULT NULL COMMENT '维修状态分类ID(外键，指向trepairstate.ID)(isdel)',
  `repairno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维修单号',
  `deliverysite` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '维修进程管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairprocess_detail
-- ----------------------------
DROP TABLE IF EXISTS `trepairprocess_detail`;
CREATE TABLE `trepairprocess_detail`  (
  `ID` int(11) NOT NULL,
  `repairprocessid` int(11) NULL DEFAULT NULL COMMENT '维修进程单ID(外键，指向trepairprocess.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `productid` int(11) NULL DEFAULT NULL COMMENT '产品ID',
  `notsendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '未发货数量',
  `planbackdate` datetime NULL DEFAULT NULL COMMENT '原定计划时间',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `alterplandate` datetime NULL DEFAULT NULL COMMENT '修改计划时间',
  `repair` int(11) NULL DEFAULT NULL COMMENT '维修状态',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '维修进程管理明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairreceive
-- ----------------------------
DROP TABLE IF EXISTS `trepairreceive`;
CREATE TABLE `trepairreceive`  (
  `ID` int(11) NOT NULL,
  `deliveryid` int(11) NULL DEFAULT NULL COMMENT '需维修产品发货单ID(外键，指向trepairsend.ID)',
  `repairsendcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需维修产品发货单号',
  `receivedate` datetime NULL DEFAULT NULL COMMENT '接货时间',
  `receiveaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货地址',
  `totalsendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总返厂发货数量',
  `isreceive` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)(isdel)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '接货时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `totalreceivenum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总实际收货数量',
  `receiveemployeeid` int(11) NULL DEFAULT NULL COMMENT '接货登记人员(外键，指向temployee.ID)',
  `deliveryno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货单号',
  `deliverydate` datetime NULL DEFAULT NULL COMMENT '发货时间',
  `deliverysite` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  `isbacksend` int(11) NULL DEFAULT NULL COMMENT '是否已发货',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需维修产品接货记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairreceive_detail
-- ----------------------------
DROP TABLE IF EXISTS `trepairreceive_detail`;
CREATE TABLE `trepairreceive_detail`  (
  `ID` int(11) NOT NULL,
  `repairreceiveid` int(11) NULL DEFAULT NULL COMMENT '需维修产品接货单ID',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `productid` int(11) NULL DEFAULT NULL COMMENT '产品ID',
  `sendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '返厂发货数量',
  `planbackdate` datetime NULL DEFAULT NULL COMMENT '计划返回时间',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `receivenum` double NULL DEFAULT NULL COMMENT '实际收货数量',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需维修产品接货记录明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairsend
-- ----------------------------
DROP TABLE IF EXISTS `trepairsend`;
CREATE TABLE `trepairsend`  (
  `ID` int(11) NOT NULL,
  `sendcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货单单号',
  `senddate` datetime NULL DEFAULT NULL COMMENT '发货时间',
  `sendemployeeid` int(11) NULL DEFAULT NULL COMMENT '发货登记人员(外键，指向temployee.ID)',
  `sendaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送地点',
  `totalsendnum` float NULL DEFAULT NULL COMMENT '总返厂发货数量',
  `isreceive` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需维修产品发货记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairsend_detail
-- ----------------------------
DROP TABLE IF EXISTS `trepairsend_detail`;
CREATE TABLE `trepairsend_detail`  (
  `ID` int(11) NOT NULL,
  `repairsendid` int(11) NULL DEFAULT NULL COMMENT '需维修产品发货单ID(外键，指向trepairsend.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `productid` int(11) NULL DEFAULT NULL COMMENT '产品ID',
  `sendnum` float NULL DEFAULT NULL COMMENT '返厂发货数量',
  `planbackdate` datetime NULL DEFAULT NULL COMMENT '计划返回时间',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需维修产品发货记录明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trepairstate
-- ----------------------------
DROP TABLE IF EXISTS `trepairstate`;
CREATE TABLE `trepairstate`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trules
-- ----------------------------
DROP TABLE IF EXISTS `trules`;
CREATE TABLE `trules`  (
  `ID` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知内容(解析前)',
  `date` datetime NULL DEFAULT NULL COMMENT '时间',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间(isdel)',
  `new` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知内容(解析后)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理规定' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trules_attach
-- ----------------------------
DROP TABLE IF EXISTS `trules_attach`;
CREATE TABLE `trules_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `rulesid` int(11) NULL DEFAULT NULL COMMENT '管理规定ID(外键，指向trules.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for trunstate
-- ----------------------------
DROP TABLE IF EXISTS `trunstate`;
CREATE TABLE `trunstate`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目运行状态分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsatisfaction
-- ----------------------------
DROP TABLE IF EXISTS `tsatisfaction`;
CREATE TABLE `tsatisfaction`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `custtypeid` int(11) NULL DEFAULT NULL COMMENT '调查对象分类(外键，指向tcusttype.ID)',
  `coal` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用煤矿',
  `custfullnameid` int(11) NULL DEFAULT NULL COMMENT '客户全称',
  `custname` int(11) NULL DEFAULT NULL COMMENT '客户姓名,外键指向tcustlinkman.id',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `performance` decimal(12, 2) NULL DEFAULT NULL COMMENT '产品性能',
  `appearance` decimal(12, 2) NULL DEFAULT NULL COMMENT '产品外观',
  `quality` decimal(12, 2) NULL DEFAULT NULL COMMENT '包装质量',
  `totalproduct` decimal(12, 2) NULL DEFAULT NULL COMMENT '产品质量分值合计(35%)',
  `service` decimal(12, 2) NULL DEFAULT NULL COMMENT '服务质量（35%）',
  `totalservice` decimal(12, 2) NULL DEFAULT NULL COMMENT '服务质量分值合计',
  `price` decimal(12, 2) NULL DEFAULT NULL COMMENT '价格（15%）',
  `totalprice` decimal(12, 2) NULL DEFAULT NULL COMMENT '价格分值合计',
  `delivery` decimal(12, 2) NULL DEFAULT NULL COMMENT '交货期（15%）',
  `totaldelivery` decimal(12, 2) NULL DEFAULT NULL COMMENT '交货期分值合计',
  `advice` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户意见建议',
  `totalscore` decimal(12, 2) NULL DEFAULT NULL COMMENT '加权平均值合计',
  `doctypeid` int(11) NULL DEFAULT NULL COMMENT '提交报告类型 ，指向 twarndays.ID',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  `isnew` smallint(6) NULL DEFAULT NULL COMMENT '是否已查看(0:未查看,1:已查看)',
  `isfile` smallint(6) NULL DEFAULT NULL COMMENT '表单状态(0:未提交,1:已提交,2:已归档,3:已驳回)',
  `custpost` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户职位',
  `custphone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户电话',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户满意度调查表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsatisfaction_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tsatisfaction_attachment`;
CREATE TABLE `tsatisfaction_attachment`  (
  `ID` int(11) NOT NULL,
  `satisfactionid` int(11) NULL DEFAULT NULL COMMENT '专题报告外键',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识(isdel)',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户满意度调查附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsend
-- ----------------------------
DROP TABLE IF EXISTS `tsend`;
CREATE TABLE `tsend`  (
  `ID` int(11) NOT NULL,
  `date` datetime NULL DEFAULT NULL COMMENT '发货日期',
  `sendaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货地址',
  `receiveaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接货地址',
  `receiveman` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货人姓名',
  `receivephone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货人电话',
  `notifierid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知人(外键，多选，指向temployee.ID)',
  `notifiername` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知人姓名',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键，指向tsalecenter.ID)',
  `money` decimal(12, 2) NULL DEFAULT NULL COMMENT '发生费用',
  `isreceive` int(11) NULL DEFAULT NULL COMMENT '是否接货	(0：未接货，1：已接货)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `totalnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总数量',
  `totalmoney` decimal(12, 2) NULL DEFAULT NULL COMMENT '总钱数',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发货记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsend_attribute
-- ----------------------------
DROP TABLE IF EXISTS `tsend_attribute`;
CREATE TABLE `tsend_attribute`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发货记录-关联属性表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsend_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsend_detail`;
CREATE TABLE `tsend_detail`  (
  `ID` int(11) NOT NULL,
  `sendid` int(11) NULL DEFAULT NULL COMMENT '发货记录ID(外键，指向tsend.ID)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `listono` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '装箱清单单号',
  `serialno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序号',
  `productno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品号',
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品名',
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格',
  `sendnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '数量',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
  `boxno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '箱号',
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `attribute` int(11) NULL DEFAULT NULL COMMENT '关联属性',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `money` decimal(12, 2) NULL DEFAULT NULL COMMENT '费用总额',
  `isprojectid` int(11) NULL DEFAULT NULL COMMENT '涉及项目(0：否，1：是)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发货记录-明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tservelog
-- ----------------------------
DROP TABLE IF EXISTS `tservelog`;
CREATE TABLE `tservelog`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `jobtype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务分类	1：井上，2：井下',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目名称(外键，指向tproject.ID)',
  `date` datetime NULL DEFAULT NULL COMMENT '服务日期',
  `coal` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务煤矿',
  `servicerid` int(11) NULL DEFAULT NULL COMMENT '服务人员(外键，指向temployee)',
  `upemstardate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井上服务时间',
  `downstaredate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '井下服务时间',
  `techemployee` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技术支持人员(外键，指向temployee)',
  `isdel` int(11) NULL DEFAULT NULL,
  `iscommit` int(11) NULL DEFAULT NULL COMMENT '提交审核标识(0：未提交，1：已提交)',
  `employee` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '问题描述',
  `measure` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理措施',
  `result` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '处理结果',
  `totalnum` double NULL DEFAULT NULL,
  `techemployeename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技术支持人员',
  `upemendate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `downendate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `number` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `downtimelen` decimal(12, 3) NULL DEFAULT NULL COMMENT '下井总时长',
  `emppositionid` int(11) NULL DEFAULT NULL COMMENT '下井记录id,外键指向tempposition.id',
  `subdowntimelen` decimal(12, 3) NULL DEFAULT NULL COMMENT '下井服务时长',
  `coalname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '矿方联系人',
  `coaltel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '矿方联系电话',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tservelog_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tservelog_attachment`;
CREATE TABLE `tservelog_attachment`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `servelogid` int(11) NULL DEFAULT NULL COMMENT '服务日志附件表(外键，指向tservelog.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tservelog_damage
-- ----------------------------
DROP TABLE IF EXISTS `tservelog_damage`;
CREATE TABLE `tservelog_damage`  (
  `ID` int(11) NOT NULL,
  `servelogid` int(11) NULL DEFAULT NULL COMMENT '服务日志明细表(外键，指向tservelog.ID)',
  `partid` int(11) NULL DEFAULT NULL COMMENT '损坏元件ID(外键，指向tproduct)',
  `partname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '损坏元件名称',
  `partnum` int(11) NULL DEFAULT NULL COMMENT '损坏元件个数',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `projecid` int(11) NULL DEFAULT NULL COMMENT '项目简称',
  `partcause` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '损坏原因',
  `projectabbreviationname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `softtext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '软件特殊情况记录',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '元件损坏明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tservelog_detail
-- ----------------------------
DROP TABLE IF EXISTS `tservelog_detail`;
CREATE TABLE `tservelog_detail`  (
  `ID` int(11) NOT NULL,
  `servelogid` int(11) NULL DEFAULT NULL COMMENT '服务日志明细表(外键，指向tservelog.ID)',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '问题描述',
  `measure` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理措施',
  `result` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '处理结果',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称',
  `mession` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `otherid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `subdowntimelen` decimal(12, 3) NULL DEFAULT NULL COMMENT '下井时长',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tservelog_techemp
-- ----------------------------
DROP TABLE IF EXISTS `tservelog_techemp`;
CREATE TABLE `tservelog_techemp`  (
  `ID` int(11) NOT NULL,
  `servelogid` int(11) NULL DEFAULT NULL COMMENT '服务日志明细表(外键，指向tservelog.ID)',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '井上服务人员(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tspecialreport
-- ----------------------------
DROP TABLE IF EXISTS `tspecialreport`;
CREATE TABLE `tspecialreport`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报告主题',
  `importanttype` int(11) NULL DEFAULT NULL COMMENT '重要程度	(1一般，2严重，3特别严重)',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '报告内容',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `isresolve` int(11) NULL DEFAULT NULL COMMENT '是否解决	(0：否，1：是)',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  `isnew` smallint(6) NULL DEFAULT NULL COMMENT '是否已查看(0:未查看,1:已查看)',
  `isfile` smallint(6) NULL DEFAULT NULL COMMENT '表单状态(0:未提交,1:已提交,2:已归档,3:已驳回)',
  `reportmember` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专题组组员',
  `reportmembername` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专题组组员名字',
  `resolveman` int(11) NULL DEFAULT NULL COMMENT '解决操作人(外键指向temployee.id)',
  `resolvetime` datetime NULL DEFAULT NULL COMMENT '解决时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目专题报告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tspecialreport_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tspecialreport_attachment`;
CREATE TABLE `tspecialreport_attachment`  (
  `ID` int(11) NOT NULL,
  `specialid` int(11) NOT NULL COMMENT '专题报告外键',
  `filename` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目专题报告附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tspecialreport_detail
-- ----------------------------
DROP TABLE IF EXISTS `tspecialreport_detail`;
CREATE TABLE `tspecialreport_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `specialreportid` int(11) NULL DEFAULT NULL COMMENT '项目专题报告ID(外键，指向tspecialreport.ID)',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(0：未删除，1：已删除)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `tsupplylist_detailnewid` int(11) NULL DEFAULT NULL COMMENT '物料清单明细表id，外键指向tsupplylist_detailnew.id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目专题报告涉及产品明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tspecialreport_employee
-- ----------------------------
DROP TABLE IF EXISTS `tspecialreport_employee`;
CREATE TABLE `tspecialreport_employee`  (
  `ID` int(11) NOT NULL,
  `specialreportid` int(11) NULL DEFAULT NULL,
  `employeeid` int(11) NULL DEFAULT NULL,
  `isdel` tinyint(4) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tspecialreport_message
-- ----------------------------
DROP TABLE IF EXISTS `tspecialreport_message`;
CREATE TABLE `tspecialreport_message`  (
  `ID` int(11) NOT NULL,
  `messager` int(11) NULL DEFAULT NULL COMMENT '留言人',
  `messagedate` datetime NULL DEFAULT NULL COMMENT '留言日期',
  `messagecontent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '留言内容',
  `isdel` int(11) NULL DEFAULT NULL,
  `specialid` int(11) NULL DEFAULT NULL COMMENT '项目专题报告ID(外键，指向tspecialreport.ID)',
  `creater` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目专题报告留言' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_car
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_car`;
CREATE TABLE `tsumm_car`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '车辆数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心车辆数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_downmine
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_downmine`;
CREATE TABLE `tsumm_downmine`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `servetypeid` tinyint(4) NULL DEFAULT NULL COMMENT '服务类型(1:井下 2:井上)',
  `rate` decimal(6, 4) NULL DEFAULT NULL COMMENT '所占比例'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '月度下井服务比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_downmine_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_downmine_detail`;
CREATE TABLE `tsumm_downmine_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '数量',
  `servetypeid` tinyint(4) NULL DEFAULT NULL COMMENT '服务类型(1:井上 2:井下)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心项目月度下井服务数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_employee
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_employee`;
CREATE TABLE `tsumm_employee`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '人员数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心人员数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_projecttype
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_projecttype`;
CREATE TABLE `tsumm_projecttype`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `projecttypeid` tinyint(4) NULL DEFAULT NULL COMMENT '项目类型(外键，指向tprojecttype.id)',
  `rate` decimal(6, 4) NULL DEFAULT NULL COMMENT '所占比例'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目整体情况比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_projecttype_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_projecttype_detail`;
CREATE TABLE `tsumm_projecttype_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `projecttypeid` tinyint(4) NULL DEFAULT NULL COMMENT '项目类型(外键，指向tprojecttype.id)',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键,指向torganization.ID)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心项目情况数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_runstate
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_runstate`;
CREATE TABLE `tsumm_runstate`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `runstateid` tinyint(4) NULL DEFAULT NULL COMMENT '运行状态',
  `rate` decimal(6, 4) NULL DEFAULT NULL COMMENT '所占比例'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目运行状态比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_runstate_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_runstate_detail`;
CREATE TABLE `tsumm_runstate_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `runstateid` tinyint(4) NULL DEFAULT NULL COMMENT '0:质保内1:质保外',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心项目运行状态数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_warranty
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_warranty`;
CREATE TABLE `tsumm_warranty`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `warrantyid` tinyint(4) NULL DEFAULT NULL COMMENT '0:质保内1:质保外',
  `rate` decimal(6, 4) NULL DEFAULT NULL COMMENT '所占比例'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目质保状态比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_warranty_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_warranty_detail`;
CREATE TABLE `tsumm_warranty_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `warrantyid` tinyint(4) NULL DEFAULT NULL COMMENT '0:质保内1:质保外',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心项目质保状态数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_workload
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_workload`;
CREATE TABLE `tsumm_workload`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `worktypeid` tinyint(4) NULL DEFAULT NULL COMMENT '工作类型(0:市场销售 1:货品收发 2:出厂服务 3:日常工作 4:项目服务)',
  `rate` decimal(6, 4) NULL DEFAULT NULL COMMENT '所占比例'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '月度工作量比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsumm_workload_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsumm_workload_detail`;
CREATE TABLE `tsumm_workload_detail`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `countdate` datetime NULL DEFAULT NULL COMMENT '统计日期',
  `worktypeid` tinyint(4) NULL DEFAULT NULL COMMENT '工作类型(0:市场销售 1:货品收发 2:出厂服务 3:日常工作 4:项目服务)',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `amount` int(11) NULL DEFAULT NULL COMMENT '数量'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售服务中心项目月度工作量数量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupervise
-- ----------------------------
DROP TABLE IF EXISTS `tsupervise`;
CREATE TABLE `tsupervise`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `serviceflow` float NULL DEFAULT NULL COMMENT '售后服务流程规范得分',
  `servicetech` float NULL DEFAULT NULL COMMENT '售后服务技术规范得分',
  `totalrun` float NULL DEFAULT NULL COMMENT '服务标准执行情况',
  `archives` float NULL DEFAULT NULL COMMENT '服务项目档案审核得分',
  `totalarchives` float NULL DEFAULT NULL COMMENT '项目服务档案建设',
  `complaint` float NULL DEFAULT NULL COMMENT '服务投诉得分',
  `totalcomplaint` float NULL DEFAULT NULL COMMENT '服务投诉',
  `replacerate` float NULL DEFAULT NULL COMMENT '服务项目累计更换率统计表得分',
  `damagerate` float NULL DEFAULT NULL COMMENT '服务项目元件损坏情况统计表得分',
  `allotrate` float NULL DEFAULT NULL COMMENT '服务项目物料调拨情况统计表得分',
  `pickrate` float NULL DEFAULT NULL COMMENT '得分服务项目费用领料情况统计表',
  `totalrate` float NULL DEFAULT NULL COMMENT '质保期内备件消耗率统计得分',
  `okrate` float NULL DEFAULT NULL COMMENT '井下设备完好率统计表得分',
  `okcheck` float NULL DEFAULT NULL COMMENT '质保期内设备完好率审核表得分',
  `totalok` float NULL DEFAULT NULL COMMENT '质保期内设备完好率',
  `dailywork` float NULL DEFAULT NULL COMMENT '日常工作反馈情况得分',
  `totalwork` float NULL DEFAULT NULL COMMENT '日常服务工作',
  `date` datetime NULL DEFAULT NULL COMMENT '检查时间',
  `address` varchar(53) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查地点',
  `employee` float NULL DEFAULT NULL COMMENT '检查人员',
  `totalscore` float NULL DEFAULT NULL COMMENT '检查总分',
  `checkadvice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '检查意见',
  `rectifyadvice` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '整改结果意见',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间(isdel)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `changestate` int(11) NULL DEFAULT NULL COMMENT '整改状态',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务监管' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupervise_attach
-- ----------------------------
DROP TABLE IF EXISTS `tsupervise_attach`;
CREATE TABLE `tsupervise_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `supervise` int(11) NULL DEFAULT NULL COMMENT '服务监管ID(外键，指向tsupervise.ID)',
  `filename` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识(0：未删除，1：已删除)',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目服务监管附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupervision
-- ----------------------------
DROP TABLE IF EXISTS `tsupervision`;
CREATE TABLE `tsupervision`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `salecenterid` int(11) NULL DEFAULT NULL COMMENT '销售服务中心(外键指向torganization.id)',
  `examdate` datetime NULL DEFAULT NULL COMMENT '检查日期',
  `examscore` decimal(6, 2) NULL DEFAULT NULL COMMENT '检查总评分',
  `cc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件抄送人',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键指向temployee.id)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '填报时间',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除，1:已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务监管考核主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupervision_index
-- ----------------------------
DROP TABLE IF EXISTS `tsupervision_index`;
CREATE TABLE `tsupervision_index`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标名称',
  `weight` decimal(5, 2) NULL DEFAULT NULL COMMENT '权重',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标志0：未删，1已删',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupervision_score
-- ----------------------------
DROP TABLE IF EXISTS `tsupervision_score`;
CREATE TABLE `tsupervision_score`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `supervisionid` int(11) NULL DEFAULT NULL COMMENT '服务监管考核表(外键指向tsupervision.id)',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键指向tproject.id)',
  `supervisionindex_id` int(11) NULL DEFAULT NULL COMMENT '指标项id(外键指向tsupervision_index.id)',
  `supervisionindex_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指向标名称',
  `supervisionindex_weight` decimal(6, 2) NULL DEFAULT NULL COMMENT '指向标权重',
  `score` decimal(6, 2) NULL DEFAULT NULL COMMENT '得分',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识(0:未删除   1:已删除)',
  `supervisescore` decimal(6, 2) NULL DEFAULT NULL COMMENT '评分项得分'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务监管考核评分明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplier
-- ----------------------------
DROP TABLE IF EXISTS `tsupplier`;
CREATE TABLE `tsupplier`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厂家名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `num` int(11) NULL DEFAULT NULL COMMENT '累计使用次数',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `customer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `customertel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  `suppliertype` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `suppliertypename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `createtman` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供货厂家表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplier_type
-- ----------------------------
DROP TABLE IF EXISTS `tsupplier_type`;
CREATE TABLE `tsupplier_type`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名字',
  `isdel` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplylist
-- ----------------------------
DROP TABLE IF EXISTS `tsupplylist`;
CREATE TABLE `tsupplylist`  (
  `ID` int(11) NOT NULL,
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供货清单号 / 供货单编号',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '关联ERP项目ID，指向terpproject.ID（为空，未导入，后期不用可删除该冗余字段）',
  `erpprojectid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目定义ID，指向terpproject. erpid',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `totalnum` double NULL DEFAULT NULL COMMENT '总数量（为空，未导入，后期不用可删除该冗余字段）',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)（为空，未导入，后期不用可删除该冗余字段）',
  `erpprojectname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目定义(若项目定义为名称，项目定义为该字段)',
  `wbsid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目WBSID',
  `wbsno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目WBS定义',
  `erpprojectcode` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'erp项目编码 / 项目定义(若项目定义为编号，项目定义为该字段)',
  `projecttypeid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目类型（为空，未导入，后期不用可删除该冗余字段）',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplylist_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsupplylist_detail`;
CREATE TABLE `tsupplylist_detail`  (
  `ID` int(11) NOT NULL,
  `supplylistid` int(11) NULL DEFAULT NULL COMMENT '供货清单ID(外键，指向tsupplylist.ID)（为空，未导入，后期不用可删除该冗余字段）',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `productid` int(11) NULL DEFAULT NULL COMMENT '产品ID，指向tproduct.ID（为空，未导入，后期不用可删除该冗余字段）',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称（为空，未导入，后期不用可删除该冗余字段）',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品编码 / 物料编码',
  `productno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品品号（为空，未导入，后期不用可删除该冗余字段）',
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品型号（为空，未导入，后期不用可删除该冗余字段）',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
  `num` decimal(18, 2) NULL DEFAULT NULL COMMENT '供货数量',
  `erpproductid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ERP产品表ID，指向tproduct.erpid（为空，未导入，后期不用可删除该冗余字段）',
  `supplylistcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供货清单单号',
  `rowno` int(11) NULL DEFAULT NULL COMMENT '供货单行项目号',
  `productcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  `demanddate` datetime NULL DEFAULT NULL COMMENT '需求日期',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `isuse` int(11) NULL DEFAULT NULL COMMENT '是否用于一次安装',
  `zzid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zz1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `zz2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `zz3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `wbsid` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplylist_detailnew
-- ----------------------------
DROP TABLE IF EXISTS `tsupplylist_detailnew`;
CREATE TABLE `tsupplylist_detailnew`  (
  `ID` int(11) NOT NULL,
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
  `num` decimal(18, 3) NULL DEFAULT NULL COMMENT '供货数量',
  `supplylistcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供货清单单号',
  `rowno` int(11) NULL DEFAULT NULL COMMENT '供货单行项目号',
  `productcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  `isuse` int(11) NULL DEFAULT NULL COMMENT '是否用于一次安装(0：否，1：是)',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '长描述',
  `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '短描述',
  `supplylistid` int(11) NULL DEFAULT NULL COMMENT '物料清单id，外键指向tsupplylistnew.id（或tsupplylist.id相同）',
  `installnum` int(11) NULL DEFAULT NULL COMMENT '实际安装数量',
  `producttypeid` int(11) NULL DEFAULT NULL COMMENT '物料类型，外键指向tproduct_type.id',
  `partid` int(11) NULL DEFAULT NULL COMMENT '元件名称ID',
  `demanddate` datetime NULL DEFAULT NULL COMMENT '需求日期',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `zzid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zz1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `zz2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `zz3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `isimport` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供货清单明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupplylistnew
-- ----------------------------
DROP TABLE IF EXISTS `tsupplylistnew`;
CREATE TABLE `tsupplylistnew`  (
  `ID` int(11) NOT NULL,
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供货清单号 / 供货单编号',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)（为空，未导入，后期不用可删除该冗余字段）',
  `wbsid` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目WBSID',
  `wbsno` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目WBS定义',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供货清单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupport_type
-- ----------------------------
DROP TABLE IF EXISTS `tsupport_type`;
CREATE TABLE `tsupport_type`  (
  `ID` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支架类型名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配套支架类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupportcheck
-- ----------------------------
DROP TABLE IF EXISTS `tsupportcheck`;
CREATE TABLE `tsupportcheck`  (
  `ID` int(11) NOT NULL,
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键，指向tproject.ID)',
  `startdate` datetime NULL DEFAULT NULL COMMENT '验收时间——开始',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '创建人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL,
  `enddate` datetime NULL DEFAULT NULL COMMENT '验收日期-结束',
  `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收地点',
  `employeeid` int(11) NULL DEFAULT NULL COMMENT '验收人员',
  `totalnum` decimal(12, 2) NULL DEFAULT NULL COMMENT '总支架数',
  `type` int(11) NULL DEFAULT NULL COMMENT '报告类型：1:支架出厂验收报告 2:行程传感器出厂验收报告 3:其他出厂验收报告',
  `passnum` int(11) NULL DEFAULT NULL COMMENT '合格数量',
  `failnum` int(11) NULL DEFAULT NULL COMMENT '不合格数量',
  `checkproject` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收项目',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支架出厂验收记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupportcheck_attach
-- ----------------------------
DROP TABLE IF EXISTS `tsupportcheck_attach`;
CREATE TABLE `tsupportcheck_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `supportcheckid` int(11) NULL DEFAULT NULL COMMENT '支架出厂验收记录单ID(外键，指向tsupportcheck.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支架出厂验收记录附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsupportcheck_detail
-- ----------------------------
DROP TABLE IF EXISTS `tsupportcheck_detail`;
CREATE TABLE `tsupportcheck_detail`  (
  `ID` int(11) NOT NULL,
  `supportcheckid` int(11) NULL DEFAULT NULL COMMENT '支架出厂验收记录单ID(外键，指向tsupportcheck.ID)	',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `projectsupportid` int(11) NULL DEFAULT NULL COMMENT '项目支架ID(外键，指向tproject_support.ID)',
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支架类型',
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号',
  `num` decimal(12, 2) NULL DEFAULT NULL COMMENT '数量',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支架出厂验收记录-明细' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsys_permission_resource
-- ----------------------------
DROP TABLE IF EXISTS `tsys_permission_resource`;
CREATE TABLE `tsys_permission_resource`  (
  `ID` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL COMMENT '权限id',
  `resource_id` int(11) NOT NULL COMMENT '资源id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '许可名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限码，不能重复',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `FK__tsys_perm__permi__2AE0483B`(`permission_id`) USING BTREE,
  CONSTRAINT `FK__tsys_perm__permi__2AE0483B` FOREIGN KEY (`permission_id`) REFERENCES `tsyspermission` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单可具有按钮权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsys_role_perm_res
-- ----------------------------
DROP TABLE IF EXISTS `tsys_role_perm_res`;
CREATE TABLE `tsys_role_perm_res`  (
  `ID` int(11) NOT NULL,
  `role_id` int(11) NOT NULL COMMENT '角色',
  `permission_res_id` int(11) NOT NULL COMMENT '权限与资源的关联id',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色可具有菜单按钮权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsysmodule
-- ----------------------------
DROP TABLE IF EXISTS `tsysmodule`;
CREATE TABLE `tsysmodule`  (
  `SysModuleId` int(11) NOT NULL,
  `SysFlowIndexId` int(11) NULL DEFAULT NULL,
  `SysModuleParent` int(11) NULL DEFAULT NULL,
  `SysModuleName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `SysModulePage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Sort` int(11) NULL DEFAULT NULL,
  `isindex` int(11) NULL DEFAULT NULL COMMENT '0',
  `isdel` int(11) NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `templettype` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`SysModuleId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsyspermission
-- ----------------------------
DROP TABLE IF EXISTS `tsyspermission`;
CREATE TABLE `tsyspermission`  (
  `ID` int(11) NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限编码',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '按钮权限类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsysrole
-- ----------------------------
DROP TABLE IF EXISTS `tsysrole`;
CREATE TABLE `tsysrole`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `isdisable` int(11) NULL DEFAULT NULL COMMENT '停用标识',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createtime` datetime NULL DEFAULT NULL,
  `oaid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OA角色ID',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tsysuser_role
-- ----------------------------
DROP TABLE IF EXISTS `tsysuser_role`;
CREATE TABLE `tsysuser_role`  (
  `ID` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `oauserid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'erp用户ID',
  `oaroleid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'erp角色ID',
  `importdate` datetime NULL DEFAULT NULL COMMENT '导入日期',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `FK__tsysuser___role___2CC890AD`(`role_id`) USING BTREE,
  INDEX `FK__tsysuser___user___2DBCB4E6`(`user_id`) USING BTREE,
  CONSTRAINT `FK__tsysuser___role___2CC890AD` FOREIGN KEY (`role_id`) REFERENCES `tsysrole` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK__tsysuser___user___2DBCB4E6` FOREIGN KEY (`user_id`) REFERENCES `temployee` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechfile
-- ----------------------------
DROP TABLE IF EXISTS `ttechfile`;
CREATE TABLE `ttechfile`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `projectid` int(11) NULL DEFAULT NULL COMMENT '项目简称(外键指向tproject.ID)',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件标题',
  `techfiletypeid` int(11) NULL DEFAULT NULL COMMENT '文件类型(外键，指向ttechfile_type.id)',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件备注',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '填报时间',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `isnew` tinyint(4) NULL DEFAULT NULL COMMENT '是否已查看(0:未查看;1:已查看)',
  `isfile` tinyint(4) NULL DEFAULT NULL COMMENT '归档状态(0:未提交；1:已提交；2:已归档；3:已驳回)'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目技术文件主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechfile_attach
-- ----------------------------
DROP TABLE IF EXISTS `ttechfile_attach`;
CREATE TABLE `ttechfile_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `techfileid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '项目技术文件(外键，指向ttechfile.ID)',
  `filename` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '上传路径',
  `filerealname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目技术文件–附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechfile_type
-- ----------------------------
DROP TABLE IF EXISTS `ttechfile_type`;
CREATE TABLE `ttechfile_type`  (
  `ID` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` tinyint(4) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechinfor
-- ----------------------------
DROP TABLE IF EXISTS `ttechinfor`;
CREATE TABLE `ttechinfor`  (
  `ID` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `isdel` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目技术信息选择模块' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechsource
-- ----------------------------
DROP TABLE IF EXISTS `ttechsource`;
CREATE TABLE `ttechsource`  (
  `ID` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容(解析前)',
  `date` datetime NULL DEFAULT NULL COMMENT '时间',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识	(0：未删除，1：已删除)',
  `createmanid` int(11) NULL DEFAULT NULL COMMENT '填报人(外键，指向temployee.ID)',
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `reportdate` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `new` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容(解析后)',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '技术资料' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ttechsource_attach
-- ----------------------------
DROP TABLE IF EXISTS `ttechsource_attach`;
CREATE TABLE `ttechsource_attach`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `techsourceid` int(11) NULL DEFAULT NULL COMMENT '技术资料ID(外键，指向ttechsource.ID)',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传路径',
  `filerealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `uploader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传人',
  `uploaddate` datetime NULL DEFAULT NULL COMMENT '上传日期',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for twarn
-- ----------------------------
DROP TABLE IF EXISTS `twarn`;
CREATE TABLE `twarn`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `warndocsid` int(11) NULL DEFAULT NULL COMMENT '提交文档类型，指向 twarndocs.ID',
  `warndaysid` int(11) NULL DEFAULT NULL COMMENT '提交时间，指向 twarndays.id',
  `createtime` datetime NULL DEFAULT NULL,
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `intervaldays` int(11) NULL DEFAULT NULL COMMENT '提前提醒天数',
  `isallwarn` int(11) NULL DEFAULT NULL COMMENT '提醒类型（1: 全部提醒，2：非大修类型提醒）',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件提交提醒设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for twarndays
-- ----------------------------
DROP TABLE IF EXISTS `twarndays`;
CREATE TABLE `twarndays`  (
  `ID` int(11) NOT NULL,
  `name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提醒时间',
  `days` int(11) NULL DEFAULT NULL COMMENT '对应天数',
  `isdel` int(11) NULL DEFAULT NULL,
  `warrantyid` int(11) NULL DEFAULT NULL COMMENT '质保期类型(1:半年,2:一年,3:一年半,4:两年)',
  `type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提醒间隔类型(d:天,m:月,y:年)',
  `typenum` int(11) NULL DEFAULT NULL COMMENT '提醒间隔数量',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文档提醒时间类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for twarndocs
-- ----------------------------
DROP TABLE IF EXISTS `twarndocs`;
CREATE TABLE `twarndocs`  (
  `ID` int(11) NOT NULL COMMENT '主键',
  `docname` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提交文档名称',
  `table_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应表名',
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '表单链接',
  `projectfield` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应table中的“项目”的字段名称',
  `employeefield` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应table表中的“上报人”的字段名称，该字段的值指向temployee.id',
  `doctype` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应table表中的“上报类型”的字段名称，该字段的值指向 twarndays.id',
  `isdel` int(11) NULL DEFAULT NULL COMMENT '删除标识',
  `sysmoduleid` int(11) NULL DEFAULT NULL COMMENT '页面菜单id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '提醒文档类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for twarranty
-- ----------------------------
DROP TABLE IF EXISTS `twarranty`;
CREATE TABLE `twarranty`  (
  `ID` int(11) NOT NULL,
  `num` int(11) NULL DEFAULT NULL COMMENT '数量',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `isdel` int(11) NULL DEFAULT NULL,
  `isdisable` int(11) NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '质保期' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tyear
-- ----------------------------
DROP TABLE IF EXISTS `tyear`;
CREATE TABLE `tyear`  (
  `id` int(11) NOT NULL COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `isdel` tinyint(4) NULL DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;