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

2023-01-05 17:06:07
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;
码农公寓

相关文章
