NetCore微服务简单流程审批数据库设计及后台服务开发

1.数据库设计

-- ----------------------------
-- Table structure for TBase_Flow
-- ----------------------------
DROP TABLE IF EXISTS `TBase_Flow`;
CREATE TABLE `TBase_Flow`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `FlowDescription` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程说明',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TBase_FlowActivity
-- ----------------------------
DROP TABLE IF EXISTS `TBase_FlowActivity`;
CREATE TABLE `TBase_FlowActivity`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `ApplyId` int(11) NULL DEFAULT NULL COMMENT 'FlowApplyId',
  `ProposerId` int(11) NULL DEFAULT NULL COMMENT '申请人Id',
  `Proposer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `FId` int(11) NULL DEFAULT NULL COMMENT '流程Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `Current_FNId` int(11) NULL DEFAULT NULL COMMENT '当前运行的流程Id',
  `Current_FNName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前运行的流程名称',
  `ApproverId` int(11) NULL DEFAULT NULL COMMENT '审批人Id',
  `Approver` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人',
  `Remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见',
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `IsAgree` int(1) NULL DEFAULT 0 COMMENT '是否同意 0同意 1拒绝',
  `OperationTime` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程活动表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TBase_FlowApply
-- ----------------------------
DROP TABLE IF EXISTS `TBase_FlowApply`;
CREATE TABLE `TBase_FlowApply`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `ProposerId` int(11) NULL DEFAULT NULL COMMENT '申请人Id',
  `Proposer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请人',
  `FId` int(11) NULL DEFAULT NULL COMMENT '流程Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `Current_FNId` int(11) NULL DEFAULT NULL COMMENT '当前运行的流程节点Id',
  `Current_FNName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前运行的流程节点名称',
  `Next_FNId` int(11) NULL DEFAULT NULL COMMENT '下一运行流程节点的Id',
  `Next_FNName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下一运行流程节点的名称',
  `ApplyTimes` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
  `ApplyDays` int(11) NULL DEFAULT NULL COMMENT '申请天数',
  `BorrowStartTime` datetime(0) NULL DEFAULT NULL COMMENT '借阅开始时间',
  `BorrowEndTime` datetime(0) NULL DEFAULT NULL COMMENT '借阅结束时间',
  `Goal` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借阅目的',
  `IsLose` int(1) NULL DEFAULT 0 COMMENT '是否失效 0:否 1：是',
  `State` int(1) NULL DEFAULT 0 COMMENT '0 审批中 1审批通过 2审批不通过',
  `ProposerRemark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人备注',
  `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程申请表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TBase_FlowNode
-- ----------------------------
DROP TABLE IF EXISTS `TBase_FlowNode`;
CREATE TABLE `TBase_FlowNode`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `FId` int(11) NULL DEFAULT NULL COMMENT '流程Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `FlowNodeName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程节点名称',
  `FlowNodeDescription` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程节点说明',
  `OrderBy` int(11) NULL DEFAULT NULL COMMENT '执行顺序',
  `Next_FNId` int(11) NULL DEFAULT NULL COMMENT '下一个运行的流程Id',
  `Next_FNName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下一个运行的流程名称',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程节点表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TBase_FlowNodeUser
-- ----------------------------
DROP TABLE IF EXISTS `TBase_FlowNodeUser`;
CREATE TABLE `TBase_FlowNodeUser`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `FId` int(11) NULL DEFAULT NULL COMMENT '流程Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `FNId` int(11) NULL DEFAULT NULL COMMENT '流程节点Id',
  `FNName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程节点名称',
  `ApproverId` int(11) NULL DEFAULT NULL COMMENT '审批人Id',
  `Approver` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人',
  `RoleId` int(11) NULL DEFAULT NULL COMMENT '角色Id',
  `RoleName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程节点审批人表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TBase_FlowRole
-- ----------------------------
DROP TABLE IF EXISTS `TBase_FlowRole`;
CREATE TABLE `TBase_FlowRole`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `FId` int(11) NULL DEFAULT NULL COMMENT '流程Id',
  `FlowName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',
  `RoleId` int(11) NULL DEFAULT NULL COMMENT '角色Id',
  `RoleName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程节点角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TFlow_VeteranInfoMapUser
-- ----------------------------
DROP TABLE IF EXISTS `TFlow_VeteranInfoMapUser`;
CREATE TABLE `TFlow_VeteranInfoMapUser`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增Id',
  `ApplyId` int(11) NULL DEFAULT NULL COMMENT 'FlowApplyId的Id',
  `VId` int(11) NULL DEFAULT NULL COMMENT '退役军人档案信息Id',
  `ProposerId` int(11) NULL DEFAULT NULL COMMENT '申请人Id',
  `CreateId` int(11) NULL DEFAULT NULL COMMENT '创建人Id',
  `CreateBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ModifyId` int(11) NULL DEFAULT NULL COMMENT '修改人Id',
  `ModifyBy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `IsDelected` int(1) NULL DEFAULT 0 COMMENT '软删除 0:否 1：是',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'TBase_VeteranInfo和sysyerinfo映射表' ROW_FORMAT = Dynamic;