{ "paper": { "name": "A4", "leftMargin": 0.5, "rightMargin": 0.5, "topMargin": 0.5, "bottomMargin": 0.5, "isPortriat": true }, "modelVersion": 2.01, "defaultSchema": "Default", "server": { "objectType": "Server_MYSQL", "name": "Default", "serverVersion": 50725, "edition": "Default", "lowerCaseTableNames": 0, "schemas": [ { "objectType": "Schema_MYSQL", "name": "Default", "tables": [], "views": [] }, { "objectType": "Schema_MYSQL", "name": "zt", "tables": [ { "objectType": "Table_MYSQL", "name": "pro_main", "comment": "", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "pro_main", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2024-12-01 00:20:45", "checkTime": "", "dataFree": 0, "dataLength": 212992, "indexLength": 114688, "maxDataLength": 0, "rows": 644, "updateTime": "", "DDL": "CREATE TABLE `pro_main` (\n `id` varchar(50) NOT NULL,\n `isProject` tinyint(1) DEFAULT NULL COMMENT '是否为商机',\n `validStatus` varchar(50) DEFAULT NULL COMMENT '立项状态,0-商机,1-立项审核中,2-通过,3-不通过',\n `signStatus` varchar(50) DEFAULT NULL COMMENT '签约状态,0-待签约,1-状态审核中,2-应签约,3-已签约',\n `bidStatus` varchar(50) DEFAULT NULL COMMENT '招投标状态,0-待处理,1-状态审核中,2-已处理',\n `enableStatus` varchar(50) DEFAULT NULL COMMENT '有效状态,0-启用中,1-状态审核中,2-暂停,3-终止',\n `currAudit` varchar(50) DEFAULT NULL COMMENT '当前流程',\n `bizCode` varchar(50) DEFAULT '' COMMENT '商机编码',\n `proCode` varchar(50) DEFAULT NULL COMMENT '项目编码,当是项目时,以此编码为准',\n `proName` varchar(255) DEFAULT NULL COMMENT '项目名称',\n `custId` varchar(50) CHARACTER SET utf8 DEFAULT NULL,\n `custName` varchar(255) DEFAULT NULL,\n `proType` varchar(20) DEFAULT NULL COMMENT '项目类型',\n `proFrom` varchar(50) DEFAULT NULL COMMENT '项目来源',\n `proDescription` text COMMENT '项目说明',\n `proStatus` varchar(1) DEFAULT '0' COMMENT '项目状态:0-进行中,1-已验收,2-强制终止',\n `preSales` double DEFAULT NULL COMMENT '预计销售额',\n `attachFiles` text COMMENT '附件,以url链字符串进行存储,前端会进行管理',\n `jsonNotes` text COMMENT '日常日志,包括销售记录',\n `managedBy` varchar(2000) DEFAULT NULL COMMENT '项目经理',\n `chargedBy` varchar(50) CHARACTER SET utf8 DEFAULT NULL,\n `chargedName` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '销售负责人名称',\n `validAt` datetime DEFAULT NULL COMMENT '立项时间',\n `signAt` datetime DEFAULT NULL COMMENT '签约时间',\n `bidAt` datetime DEFAULT NULL COMMENT '招投标时间',\n `endingAt` datetime DEFAULT NULL COMMENT '终止或暂停时间',\n `notesAt` datetime DEFAULT NULL COMMENT '跟进记录更新时间',\n `delTag` varchar(1) DEFAULT '0' COMMENT '删除标记',\n `createdBy` varchar(50) CHARACTER SET utf8 DEFAULT NULL,\n `createdAt` datetime DEFAULT NULL,\n `updatedAt` datetime DEFAULT NULL,\n `reqdescription` text CHARACTER SET utf8 COMMENT '需求描述',\n `group_id` varchar(255) DEFAULT NULL COMMENT '集团',\n `real_valid_status` varchar(255) DEFAULT NULL COMMENT '立项状态 0 未申请 1 审核中 2 通过 3拒绝',\n `real_valid_At` datetime DEFAULT NULL COMMENT '立项时间',\n `closing_item_status` varchar(50) DEFAULT NULL COMMENT '结项状态 1-未结项 2- 已结项',\n `closing_item_time` datetime DEFAULT NULL COMMENT '结项提交时间',\n `remove_closing_time` datetime DEFAULT NULL COMMENT '解除结项时间',\n `reserve` varchar(255) DEFAULT NULL COMMENT '备用',\n `yw_status` varchar(50) DEFAULT NULL COMMENT '运维状态',\n `yw_person` varchar(1000) DEFAULT NULL COMMENT '运维负责人',\n `yw_fp_time` datetime DEFAULT NULL COMMENT '运维分配时间',\n `yw_transferred` varchar(50) DEFAULT NULL COMMENT '移交人',\n `reserve_time` datetime DEFAULT NULL COMMENT '备用时间',\n PRIMARY KEY (`id`) USING BTREE,\n KEY `fk_constraint_pro_user` (`createdBy`) USING BTREE,\n KEY `chargedBy` (`chargedBy`) USING BTREE,\n KEY `fk_constraint_pro_cus` (`custId`) USING BTREE,\n CONSTRAINT `fk_constraint_pro_cus` FOREIGN KEY (`custId`) REFERENCES `cus_main` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "isProject", "type": "tinyint", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否为商机", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "isProject" }, { "objectType": "TableField_MYSQL", "name": "validStatus", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "立项状态,0-商机,1-立项审核中,2-通过,3-不通过", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "validStatus" }, { "objectType": "TableField_MYSQL", "name": "signStatus", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "签约状态,0-待签约,1-状态审核中,2-应签约,3-已签约", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "signStatus" }, { "objectType": "TableField_MYSQL", "name": "bidStatus", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "招投标状态,0-待处理,1-状态审核中,2-已处理", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bidStatus" }, { "objectType": "TableField_MYSQL", "name": "enableStatus", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "有效状态,0-启用中,1-状态审核中,2-暂停,3-终止", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "enableStatus" }, { "objectType": "TableField_MYSQL", "name": "currAudit", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "当前流程", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "currAudit" }, { "objectType": "TableField_MYSQL", "name": "bizCode", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Empty", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "商机编码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bizCode" }, { "objectType": "TableField_MYSQL", "name": "proCode", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目编码,当是项目时,以此编码为准", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proCode" }, { "objectType": "TableField_MYSQL", "name": "proName", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proName" }, { "objectType": "TableField_MYSQL", "name": "custId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custId" }, { "objectType": "TableField_MYSQL", "name": "custName", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custName" }, { "objectType": "TableField_MYSQL", "name": "proType", "type": "varchar", "length": 20, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proType" }, { "objectType": "TableField_MYSQL", "name": "proFrom", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目来源", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proFrom" }, { "objectType": "TableField_MYSQL", "name": "proDescription", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proDescription" }, { "objectType": "TableField_MYSQL", "name": "proStatus", "type": "varchar", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Others", "defaultValue": "'0'", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目状态:0-进行中,1-已验收,2-强制终止", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proStatus" }, { "objectType": "TableField_MYSQL", "name": "preSales", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "预计销售额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "preSales" }, { "objectType": "TableField_MYSQL", "name": "attachFiles", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "附件,以url链字符串进行存储,前端会进行管理", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "attachFiles" }, { "objectType": "TableField_MYSQL", "name": "jsonNotes", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "日常日志,包括销售记录", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "jsonNotes" }, { "objectType": "TableField_MYSQL", "name": "managedBy", "type": "varchar", "length": 2000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目经理", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "managedBy" }, { "objectType": "TableField_MYSQL", "name": "chargedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "chargedBy" }, { "objectType": "TableField_MYSQL", "name": "chargedName", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "销售负责人名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "chargedName" }, { "objectType": "TableField_MYSQL", "name": "validAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "立项时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "validAt" }, { "objectType": "TableField_MYSQL", "name": "signAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "签约时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "signAt" }, { "objectType": "TableField_MYSQL", "name": "bidAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "招投标时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bidAt" }, { "objectType": "TableField_MYSQL", "name": "endingAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "终止或暂停时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "endingAt" }, { "objectType": "TableField_MYSQL", "name": "notesAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "跟进记录更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "notesAt" }, { "objectType": "TableField_MYSQL", "name": "delTag", "type": "varchar", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Others", "defaultValue": "'0'", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "删除标记", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "delTag" }, { "objectType": "TableField_MYSQL", "name": "createdBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "createdBy" }, { "objectType": "TableField_MYSQL", "name": "createdAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "createdAt" }, { "objectType": "TableField_MYSQL", "name": "updatedAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updatedAt" }, { "objectType": "TableField_MYSQL", "name": "reqdescription", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "需求描述", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "reqdescription" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "real_valid_status", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "立项状态 0 未申请 1 审核中 2 通过 3拒绝", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "real_valid_status" }, { "objectType": "TableField_MYSQL", "name": "real_valid_At", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "立项时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "real_valid_At" }, { "objectType": "TableField_MYSQL", "name": "closing_item_status", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "结项状态 1-未结项 2- 已结项", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "closing_item_status" }, { "objectType": "TableField_MYSQL", "name": "closing_item_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "结项提交时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "closing_item_time" }, { "objectType": "TableField_MYSQL", "name": "remove_closing_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "解除结项时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remove_closing_time" }, { "objectType": "TableField_MYSQL", "name": "reserve", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "reserve" }, { "objectType": "TableField_MYSQL", "name": "yw_status", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "运维状态", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "yw_status" }, { "objectType": "TableField_MYSQL", "name": "yw_person", "type": "varchar", "length": 1000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "运维负责人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "yw_person" }, { "objectType": "TableField_MYSQL", "name": "yw_fp_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "运维分配时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "yw_fp_time" }, { "objectType": "TableField_MYSQL", "name": "yw_transferred", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "移交人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "yw_transferred" }, { "objectType": "TableField_MYSQL", "name": "reserve_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "reserve_time" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "fk_constraint_pro_user", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "fk_constraint_pro_user", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "38", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "createdBy", "keyLength": 0, "order": "", "oldName": "createdBy" } ] }, { "objectType": "Index_MYSQL", "name": "chargedBy", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "chargedBy", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "48", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "chargedBy", "keyLength": 0, "order": "", "oldName": "chargedBy" } ] }, { "objectType": "Index_MYSQL", "name": "fk_constraint_pro_cus", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "fk_constraint_pro_cus", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "179", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "custId", "keyLength": 0, "order": "", "oldName": "custId" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "pro_main_extend", "comment": "", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "pro_main_extend", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2024-12-01 00:20:45", "checkTime": "", "dataFree": 0, "dataLength": 81920, "indexLength": 0, "maxDataLength": 0, "rows": 676, "updateTime": "", "DDL": "CREATE TABLE `pro_main_extend` (\n `id` varchar(50) NOT NULL,\n `pro_id` varchar(50) NOT NULL,\n `count_down` int(11) DEFAULT NULL COMMENT '倒计时 天',\n `biz_created_time` datetime DEFAULT NULL COMMENT '商机创建日期',\n `first_implement_time` datetime DEFAULT NULL COMMENT '优先实施时间',\n `start_sales_time` datetime DEFAULT NULL COMMENT '启动售前日期',\n `start_design_time` datetime DEFAULT NULL COMMENT '启动设计日期',\n `start_product_time` datetime DEFAULT NULL COMMENT '启动生产日期',\n `whole_online_time` datetime DEFAULT NULL COMMENT '整体上线日期',\n `actual_check_time` datetime DEFAULT NULL COMMENT '实际验收日期',\n `req_first_online_time` datetime DEFAULT NULL COMMENT '要求首批上线时间',\n `first_online_time` datetime DEFAULT NULL COMMENT '首批上线时间',\n `pro_cycle` int(11) DEFAULT NULL COMMENT '项目周期 天',\n `team_member` int(11) DEFAULT NULL COMMENT '团队城运',\n `man_day` double(11,1) DEFAULT NULL COMMENT '实际人天',\n `batch_number` int(11) DEFAULT NULL COMMENT '批次数',\n `task_number` int(11) DEFAULT NULL COMMENT '任务数',\n `bug_number` int(11) DEFAULT NULL COMMENT '问题数',\n `created_by` varchar(64) DEFAULT NULL COMMENT '创建',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',\n `updated_at` datetime DEFAULT NULL COMMENT '更新时间',\n `actual_online_time` datetime DEFAULT NULL COMMENT '实际上线实际',\n `status_description` varchar(255) DEFAULT NULL COMMENT '状态说明',\n `req_online_time` datetime DEFAULT NULL COMMENT '未上线批次的要求上线日期',\n `req_whole_online_time` datetime DEFAULT NULL COMMENT '要求整体上线时间',\n PRIMARY KEY (`id`,`pro_id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "count_down", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "倒计时 天", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "count_down" }, { "objectType": "TableField_MYSQL", "name": "biz_created_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "商机创建日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_created_time" }, { "objectType": "TableField_MYSQL", "name": "first_implement_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "优先实施时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "first_implement_time" }, { "objectType": "TableField_MYSQL", "name": "start_sales_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "启动售前日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "start_sales_time" }, { "objectType": "TableField_MYSQL", "name": "start_design_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "启动设计日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "start_design_time" }, { "objectType": "TableField_MYSQL", "name": "start_product_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "启动生产日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "start_product_time" }, { "objectType": "TableField_MYSQL", "name": "whole_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "整体上线日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "whole_online_time" }, { "objectType": "TableField_MYSQL", "name": "actual_check_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实际验收日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "actual_check_time" }, { "objectType": "TableField_MYSQL", "name": "req_first_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "要求首批上线时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "req_first_online_time" }, { "objectType": "TableField_MYSQL", "name": "first_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "首批上线时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "first_online_time" }, { "objectType": "TableField_MYSQL", "name": "pro_cycle", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目周期 天", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_cycle" }, { "objectType": "TableField_MYSQL", "name": "team_member", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "团队城运", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "team_member" }, { "objectType": "TableField_MYSQL", "name": "man_day", "type": "double", "length": 11, "decimals": 1, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实际人天", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "man_day" }, { "objectType": "TableField_MYSQL", "name": "batch_number", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "批次数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "batch_number" }, { "objectType": "TableField_MYSQL", "name": "task_number", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_number" }, { "objectType": "TableField_MYSQL", "name": "bug_number", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "问题数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bug_number" }, { "objectType": "TableField_MYSQL", "name": "created_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_by" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "updated_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_by" }, { "objectType": "TableField_MYSQL", "name": "updated_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_at" }, { "objectType": "TableField_MYSQL", "name": "actual_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实际上线实际", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "actual_online_time" }, { "objectType": "TableField_MYSQL", "name": "status_description", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "状态说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "status_description" }, { "objectType": "TableField_MYSQL", "name": "req_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "未上线批次的要求上线日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "req_online_time" }, { "objectType": "TableField_MYSQL", "name": "req_whole_online_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "要求整体上线时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "req_whole_online_time" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "pro_id", "keyLength": 0, "order": "", "oldName": "pro_id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "oa_pro_task_hour", "comment": "任务工时填报表", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "oa_pro_task_hour", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:20:30", "checkTime": "", "dataFree": 4194304, "dataLength": 7880704, "indexLength": 0, "maxDataLength": 0, "rows": 35467, "updateTime": "", "DDL": "CREATE TABLE `oa_pro_task_hour` (\n `id` varchar(100) NOT NULL COMMENT '主键',\n `pro_id` varchar(100) DEFAULT NULL COMMENT '项目id',\n `task_id` varchar(100) DEFAULT NULL COMMENT '任务id',\n `hour_state` varchar(100) DEFAULT NULL COMMENT '工时状态(0未提交 1评审中 2已评审 3退回)',\n `hour_date` datetime DEFAULT NULL COMMENT '日期',\n `cost_hour` double DEFAULT NULL COMMENT '所耗工时(小时)',\n `review_hour` double DEFAULT NULL COMMENT '认定工时(小时)',\n `handle_explain` varchar(600) DEFAULT NULL COMMENT '处理说明',\n `create_user` varchar(100) DEFAULT NULL COMMENT '创建人',\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `update_user` varchar(100) DEFAULT NULL COMMENT '更新人',\n `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n `group_id` varchar(100) DEFAULT NULL COMMENT '集团id(预留)',\n `back_reason` varchar(255) DEFAULT NULL COMMENT '退回原因',\n `other_explain` text COMMENT '其他说明',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务工时填报表'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "task_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MYSQL", "name": "hour_state", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "工时状态(0未提交 1评审中 2已评审 3退回)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hour_state" }, { "objectType": "TableField_MYSQL", "name": "hour_date", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hour_date" }, { "objectType": "TableField_MYSQL", "name": "cost_hour", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所耗工时(小时)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cost_hour" }, { "objectType": "TableField_MYSQL", "name": "review_hour", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "认定工时(小时)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "review_hour" }, { "objectType": "TableField_MYSQL", "name": "handle_explain", "type": "varchar", "length": 600, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_explain" }, { "objectType": "TableField_MYSQL", "name": "create_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_user" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_user" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团id(预留)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "back_reason", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "退回原因", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "back_reason" }, { "objectType": "TableField_MYSQL", "name": "other_explain", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "其他说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "other_explain" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "acc_receivable", "comment": "", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "acc_receivable", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:18:52", "checkTime": "", "dataFree": 0, "dataLength": 65536, "indexLength": 32768, "maxDataLength": 0, "rows": 111, "updateTime": "", "DDL": "CREATE TABLE `acc_receivable` (\n `id` varchar(50) NOT NULL,\n `planNo` varchar(50) DEFAULT NULL COMMENT '计划编号',\n `planStatus` varchar(1) DEFAULT NULL COMMENT '状态,0-未收款,1-收款中,2-收款完成',\n `ctrId` varchar(50) DEFAULT NULL COMMENT '合同ID',\n `contractNo` varchar(50) DEFAULT NULL COMMENT '合同号',\n `custId` varchar(50) DEFAULT NULL COMMENT '客户ID',\n `custName` varchar(50) DEFAULT NULL COMMENT '客户名称',\n `proId` varchar(50) DEFAULT NULL COMMENT '项目ID',\n `proName` varchar(50) DEFAULT NULL COMMENT '项目名称',\n `chargedBy` varchar(50) DEFAULT NULL COMMENT '销售人员',\n `arDate` date DEFAULT NULL COMMENT '应收日期',\n `arAmount` double DEFAULT NULL COMMENT '应收金额',\n `arName` varchar(100) DEFAULT NULL COMMENT '收款名称',\n `receiptNo` varchar(100) DEFAULT NULL COMMENT '发票号',\n `receiptDate` datetime DEFAULT NULL COMMENT '开票日期',\n `receiptAmount` double DEFAULT NULL COMMENT '开票金额',\n `receiveDate` datetime DEFAULT NULL COMMENT '收款日期',\n `receiveAmount` double DEFAULT NULL COMMENT '收款金额',\n `adjustAmount` double DEFAULT NULL COMMENT '调整金额',\n `adjustReason` text COMMENT '调整原因',\n `dealedBy` varchar(50) DEFAULT NULL COMMENT '办理人',\n `dealedAt` datetime DEFAULT NULL COMMENT '办理日期',\n `noticeDate` date DEFAULT NULL COMMENT '提醒日期',\n `updatedBy` varchar(50) DEFAULT NULL,\n `createdAt` datetime DEFAULT NULL,\n `updatedAt` datetime DEFAULT NULL,\n `sys_id` varchar(50) DEFAULT NULL COMMENT '系统码',\n `deliverymethod` varchar(255) DEFAULT NULL COMMENT '交割方式',\n `deliverydate` datetime DEFAULT NULL COMMENT '交割日期',\n `receiveuser` varchar(100) DEFAULT NULL COMMENT '接收人',\n `supplement` varchar(255) DEFAULT NULL COMMENT '补充说明',\n `paymentmethod` varchar(100) DEFAULT NULL COMMENT '收款方式',\n `othermethod` varchar(255) DEFAULT NULL COMMENT '其他收款方式',\n `cashamount` double DEFAULT NULL COMMENT '收款方式-现金金额',\n `telegraphicamount` double DEFAULT NULL COMMENT '收款方式-电汇金额',\n `otheramount` double DEFAULT NULL COMMENT '收款方式-其他金额',\n `paymentnotes` text COMMENT '收款登记备注',\n `adjustuser` varchar(100) DEFAULT NULL COMMENT '申请调整人',\n `adjustexplain` text COMMENT '调整说明',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n PRIMARY KEY (`id`) USING BTREE,\n KEY `FK_CONSTRAINTS_CTR_MAIN` (`ctrId`) USING BTREE,\n KEY `FK_CONSTRAINT_CTR_SALES_USER` (`updatedBy`) USING BTREE,\n CONSTRAINT `FK_CONSTRAINTS_CTR_MAIN` FOREIGN KEY (`ctrId`) REFERENCES `ctr_main` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n CONSTRAINT `FK_CONSTRAINT_CTR_SALES_USER` FOREIGN KEY (`updatedBy`) REFERENCES `frame_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "planNo", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "计划编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "planNo" }, { "objectType": "TableField_MYSQL", "name": "planStatus", "type": "varchar", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "状态,0-未收款,1-收款中,2-收款完成", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "planStatus" }, { "objectType": "TableField_MYSQL", "name": "ctrId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ctrId" }, { "objectType": "TableField_MYSQL", "name": "contractNo", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractNo" }, { "objectType": "TableField_MYSQL", "name": "custId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custId" }, { "objectType": "TableField_MYSQL", "name": "custName", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custName" }, { "objectType": "TableField_MYSQL", "name": "proId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proId" }, { "objectType": "TableField_MYSQL", "name": "proName", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proName" }, { "objectType": "TableField_MYSQL", "name": "chargedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "销售人员", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "chargedBy" }, { "objectType": "TableField_MYSQL", "name": "arDate", "type": "date", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "应收日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "arDate" }, { "objectType": "TableField_MYSQL", "name": "arAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "应收金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "arAmount" }, { "objectType": "TableField_MYSQL", "name": "arName", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "arName" }, { "objectType": "TableField_MYSQL", "name": "receiptNo", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发票号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiptNo" }, { "objectType": "TableField_MYSQL", "name": "receiptDate", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "开票日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiptDate" }, { "objectType": "TableField_MYSQL", "name": "receiptAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "开票金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiptAmount" }, { "objectType": "TableField_MYSQL", "name": "receiveDate", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiveDate" }, { "objectType": "TableField_MYSQL", "name": "receiveAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiveAmount" }, { "objectType": "TableField_MYSQL", "name": "adjustAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "调整金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "adjustAmount" }, { "objectType": "TableField_MYSQL", "name": "adjustReason", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "调整原因", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "adjustReason" }, { "objectType": "TableField_MYSQL", "name": "dealedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "办理人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dealedBy" }, { "objectType": "TableField_MYSQL", "name": "dealedAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "办理日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dealedAt" }, { "objectType": "TableField_MYSQL", "name": "noticeDate", "type": "date", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "提醒日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "noticeDate" }, { "objectType": "TableField_MYSQL", "name": "updatedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updatedBy" }, { "objectType": "TableField_MYSQL", "name": "createdAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "createdAt" }, { "objectType": "TableField_MYSQL", "name": "updatedAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updatedAt" }, { "objectType": "TableField_MYSQL", "name": "sys_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "系统码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sys_id" }, { "objectType": "TableField_MYSQL", "name": "deliverymethod", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "交割方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "deliverymethod" }, { "objectType": "TableField_MYSQL", "name": "deliverydate", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "交割日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "deliverydate" }, { "objectType": "TableField_MYSQL", "name": "receiveuser", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "接收人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiveuser" }, { "objectType": "TableField_MYSQL", "name": "supplement", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "补充说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "supplement" }, { "objectType": "TableField_MYSQL", "name": "paymentmethod", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "paymentmethod" }, { "objectType": "TableField_MYSQL", "name": "othermethod", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "其他收款方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "othermethod" }, { "objectType": "TableField_MYSQL", "name": "cashamount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款方式-现金金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cashamount" }, { "objectType": "TableField_MYSQL", "name": "telegraphicamount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款方式-电汇金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "telegraphicamount" }, { "objectType": "TableField_MYSQL", "name": "otheramount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款方式-其他金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "otheramount" }, { "objectType": "TableField_MYSQL", "name": "paymentnotes", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收款登记备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "paymentnotes" }, { "objectType": "TableField_MYSQL", "name": "adjustuser", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "申请调整人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "adjustuser" }, { "objectType": "TableField_MYSQL", "name": "adjustexplain", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "调整说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "adjustexplain" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "FK_CONSTRAINTS_CTR_MAIN", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "FK_CONSTRAINTS_CTR_MAIN", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "50", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "ctrId", "keyLength": 0, "order": "", "oldName": "ctrId" } ] }, { "objectType": "Index_MYSQL", "name": "FK_CONSTRAINT_CTR_SALES_USER", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "FK_CONSTRAINT_CTR_SALES_USER", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "15", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "updatedBy", "keyLength": 0, "order": "", "oldName": "updatedBy" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "FK_CONSTRAINTS_CTR_MAIN", "fields": [ "ctrId" ], "referenceSchema": "zt", "referenceTable": "ctr_main", "referenceFields": [ "id" ], "onDelete": "NO ACTION", "onUpdate": "NO ACTION", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "ZeroOrOneRelationship", "oldName": "FK_CONSTRAINTS_CTR_MAIN" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "ctr_main", "comment": "", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "ctr_main", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:18:54", "checkTime": "", "dataFree": 0, "dataLength": 212992, "indexLength": 32768, "maxDataLength": 0, "rows": 73, "updateTime": "", "DDL": "CREATE TABLE `ctr_main` (\n `id` varchar(50) NOT NULL,\n `proId` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,\n `proName` varchar(1000) DEFAULT NULL COMMENT '项目名称',\n `custId` varchar(50) DEFAULT NULL,\n `custName` varchar(1000) DEFAULT NULL COMMENT '客户名称',\n `receipt_id` varchar(50) DEFAULT NULL COMMENT '关联发票类型',\n `valid` varchar(1) DEFAULT NULL COMMENT '0-无效,1-有效',\n `contractName` varchar(255) DEFAULT NULL COMMENT '合同标的',\n `contractStatus` varchar(20) DEFAULT NULL COMMENT '合同状态,正常/到期',\n `contractNo` varchar(50) DEFAULT NULL COMMENT '合同编号',\n `contractFrom` varchar(50) DEFAULT NULL COMMENT '合同开始,日期',\n `contractTo` varchar(50) DEFAULT NULL COMMENT '合同结束',\n `totalAmount` double DEFAULT NULL,\n `receiveAmount` double DEFAULT NULL COMMENT '已收金额',\n `detailAmount` text COMMENT '费用明细,用json数据格式封装',\n `signAt` date DEFAULT NULL COMMENT '签约日期',\n `comments` text COMMENT '其他事项说明',\n `attachFiles` text COMMENT '附件',\n `chargedBy` varchar(50) DEFAULT NULL COMMENT '销售人员',\n `managedBy` varchar(50) DEFAULT NULL COMMENT '项目经理',\n `createdBy` varchar(50) DEFAULT NULL,\n `createdAt` datetime DEFAULT NULL,\n `updatedAt` datetime DEFAULT NULL,\n `contract_final_status` varchar(255) DEFAULT NULL COMMENT '合同最终状态(1-有效,2-到期,3-已续签,4-到期终止,5-终止,)',\n `checkprecis` text,\n `filetwo` text,\n `adjustamount` varchar(255) DEFAULT NULL,\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n `contract_amount` double DEFAULT NULL COMMENT '合同签约金额',\n `excluding_total_amount` double DEFAULT NULL COMMENT '不含税合同金额',\n `warranty_terms` varchar(2000) DEFAULT NULL COMMENT '质保及运维条款',\n `warranty_period` varchar(255) DEFAULT NULL COMMENT '质保期',\n `by_grp` varchar(255) DEFAULT NULL COMMENT '备用',\n PRIMARY KEY (`id`) USING BTREE,\n KEY `FK_CONSTRAINT_CTR_PRO` (`proId`) USING BTREE,\n KEY `FK_CONSTRAINT_CTR_USER` (`createdBy`) USING BTREE,\n CONSTRAINT `FK_CONSTRAINT_CTR_PRO` FOREIGN KEY (`proId`) REFERENCES `pro_main` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n CONSTRAINT `FK_CONSTRAINT_CTR_USER` FOREIGN KEY (`createdBy`) REFERENCES `frame_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "proId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proId" }, { "objectType": "TableField_MYSQL", "name": "proName", "type": "varchar", "length": 1000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "proName" }, { "objectType": "TableField_MYSQL", "name": "custId", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custId" }, { "objectType": "TableField_MYSQL", "name": "custName", "type": "varchar", "length": 1000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "custName" }, { "objectType": "TableField_MYSQL", "name": "receipt_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "关联发票类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receipt_id" }, { "objectType": "TableField_MYSQL", "name": "valid", "type": "varchar", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "0-无效,1-有效", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "valid" }, { "objectType": "TableField_MYSQL", "name": "contractName", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同标的", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractName" }, { "objectType": "TableField_MYSQL", "name": "contractStatus", "type": "varchar", "length": 20, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同状态,正常/到期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractStatus" }, { "objectType": "TableField_MYSQL", "name": "contractNo", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractNo" }, { "objectType": "TableField_MYSQL", "name": "contractFrom", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同开始,日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractFrom" }, { "objectType": "TableField_MYSQL", "name": "contractTo", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同结束", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contractTo" }, { "objectType": "TableField_MYSQL", "name": "totalAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "totalAmount" }, { "objectType": "TableField_MYSQL", "name": "receiveAmount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "已收金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "receiveAmount" }, { "objectType": "TableField_MYSQL", "name": "detailAmount", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "费用明细,用json数据格式封装", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "detailAmount" }, { "objectType": "TableField_MYSQL", "name": "signAt", "type": "date", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "签约日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "signAt" }, { "objectType": "TableField_MYSQL", "name": "comments", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "其他事项说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "comments" }, { "objectType": "TableField_MYSQL", "name": "attachFiles", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "附件", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "attachFiles" }, { "objectType": "TableField_MYSQL", "name": "chargedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "销售人员", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "chargedBy" }, { "objectType": "TableField_MYSQL", "name": "managedBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目经理", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "managedBy" }, { "objectType": "TableField_MYSQL", "name": "createdBy", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "createdBy" }, { "objectType": "TableField_MYSQL", "name": "createdAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "createdAt" }, { "objectType": "TableField_MYSQL", "name": "updatedAt", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updatedAt" }, { "objectType": "TableField_MYSQL", "name": "contract_final_status", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同最终状态(1-有效,2-到期,3-已续签,4-到期终止,5-终止,)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contract_final_status" }, { "objectType": "TableField_MYSQL", "name": "checkprecis", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "checkprecis" }, { "objectType": "TableField_MYSQL", "name": "filetwo", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "filetwo" }, { "objectType": "TableField_MYSQL", "name": "adjustamount", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "adjustamount" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "contract_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "合同签约金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contract_amount" }, { "objectType": "TableField_MYSQL", "name": "excluding_total_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "不含税合同金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "excluding_total_amount" }, { "objectType": "TableField_MYSQL", "name": "warranty_terms", "type": "varchar", "length": 2000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "质保及运维条款", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "warranty_terms" }, { "objectType": "TableField_MYSQL", "name": "warranty_period", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "质保期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "warranty_period" }, { "objectType": "TableField_MYSQL", "name": "by_grp", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "by_grp" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "FK_CONSTRAINT_CTR_PRO", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "FK_CONSTRAINT_CTR_PRO", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "73", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "proId", "keyLength": 0, "order": "", "oldName": "proId" } ] }, { "objectType": "Index_MYSQL", "name": "FK_CONSTRAINT_CTR_USER", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "FK_CONSTRAINT_CTR_USER", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "22", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "createdBy", "keyLength": 0, "order": "", "oldName": "createdBy" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "FK_CONSTRAINT_CTR_PRO", "fields": [ "proId" ], "referenceSchema": "zt", "referenceTable": "pro_main", "referenceFields": [ "id" ], "onDelete": "NO ACTION", "onUpdate": "NO ACTION", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "ZeroOrOneRelationship", "oldName": "FK_CONSTRAINT_CTR_PRO" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "oa_expense_ledger", "comment": "费用报支台账", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "oa_expense_ledger", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:18:59", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 16384, "maxDataLength": 0, "rows": 3, "updateTime": "", "DDL": "CREATE TABLE `oa_expense_ledger` (\n `id` varchar(100) NOT NULL COMMENT '主键',\n `pro_id` varchar(255) DEFAULT NULL COMMENT '项目id',\n `pro_name` varchar(255) DEFAULT NULL COMMENT '项目名称',\n `expense_type` varchar(255) DEFAULT NULL COMMENT '费用类型',\n `expense_amount` double(18,6) DEFAULT NULL COMMENT '费用金额',\n `happen_date` datetime DEFAULT NULL COMMENT '发生日期',\n `apply_user` varchar(255) DEFAULT NULL COMMENT '申请人',\n `create_user` varchar(100) DEFAULT NULL COMMENT '创建人',\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `update_user` varchar(100) DEFAULT NULL COMMENT '更新人',\n `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n `group_id` varchar(100) DEFAULT NULL COMMENT '集团id',\n `source` varchar(50) DEFAULT NULL COMMENT '来源 2-流程',\n PRIMARY KEY (`id`),\n KEY `pro_id_index` (`pro_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='费用报支台账'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "pro_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_name" }, { "objectType": "TableField_MYSQL", "name": "expense_type", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "费用类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "expense_type" }, { "objectType": "TableField_MYSQL", "name": "expense_amount", "type": "double", "length": 18, "decimals": 6, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "费用金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "expense_amount" }, { "objectType": "TableField_MYSQL", "name": "happen_date", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发生日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "happen_date" }, { "objectType": "TableField_MYSQL", "name": "apply_user", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "申请人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "apply_user" }, { "objectType": "TableField_MYSQL", "name": "create_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_user" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_user" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "source", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "来源 2-流程", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "source" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "pro_id_index", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "pro_id_index", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "1", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "pro_id", "keyLength": 0, "order": "", "oldName": "pro_id" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "oa_pro_task", "comment": "", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "oa_pro_task", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2024-12-01 00:20:28", "checkTime": "", "dataFree": 4194304, "dataLength": 4734976, "indexLength": 0, "maxDataLength": 0, "rows": 9142, "updateTime": "", "DDL": "CREATE TABLE `oa_pro_task` (\n `id` varchar(50) NOT NULL,\n `task_no` varchar(50) DEFAULT NULL COMMENT '任务编号',\n `pro_id` varchar(50) DEFAULT NULL COMMENT '项目',\n `task_type` varchar(255) DEFAULT NULL COMMENT '任务类型',\n `required_date` date DEFAULT NULL COMMENT '要求完成日期',\n `batch_id` varchar(50) DEFAULT NULL COMMENT '批次',\n `task_name` varchar(255) DEFAULT NULL COMMENT '任务名称',\n `task_explain` text COMMENT '任务说明',\n `handle_user_id` varchar(50) DEFAULT NULL COMMENT '处理人',\n `handle_user_type` varchar(50) DEFAULT NULL COMMENT '处理人类型 (1-内部,2-外包',\n `submit_user_id` varchar(50) DEFAULT NULL,\n `submit_time` datetime DEFAULT NULL COMMENT '提交日期',\n `status` varchar(50) DEFAULT NULL COMMENT '状态(0-未完成 1-已完成)',\n `handle_group` varchar(50) DEFAULT NULL COMMENT '处理组织',\n `complete_time` datetime DEFAULT NULL COMMENT '完成日期',\n `required_time` datetime DEFAULT NULL COMMENT '要求完成时间',\n `created_by` varchar(64) DEFAULT NULL COMMENT '创建',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',\n `updated_at` datetime DEFAULT NULL COMMENT '更新时间',\n `description` text COMMENT '描述',\n `year_mon` varchar(255) DEFAULT NULL COMMENT '年月',\n `first` varchar(255) DEFAULT NULL COMMENT '月份',\n `second` text COMMENT '文件附件',\n `task_date` varchar(255) DEFAULT NULL COMMENT '日期 一 二 三 四',\n `week_date` varchar(255) DEFAULT NULL COMMENT '星期 星期一 星期二 星期三',\n `submit_status` varchar(255) DEFAULT NULL COMMENT '1-保存,2-提交',\n `handle_explain` text COMMENT '处理说明',\n `spare_first` text COMMENT '处理附件',\n `spare_seconde` varchar(255) DEFAULT NULL COMMENT '任务类型原',\n `labor_hours` double(11,2) DEFAULT NULL COMMENT '所耗工时',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n `estimate_hours` double(11,2) DEFAULT NULL COMMENT '预估工时',\n `plan_id` varchar(50) DEFAULT NULL COMMENT '计划ID',\n `post_id` varchar(100) DEFAULT NULL COMMENT '处理人岗位id',\n `post_level` varchar(100) DEFAULT NULL COMMENT '处理人职级名称',\n `post_cost` decimal(18,2) DEFAULT NULL COMMENT '处理人人力成本',\n `review_hour` double DEFAULT NULL COMMENT '认定工时',\n `plan_start_date` datetime DEFAULT NULL COMMENT '计划启动日期',\n `handle_way` int(11) DEFAULT NULL COMMENT '处理方式(0工时填报 1任务分解)',\n `reality_start_date` datetime DEFAULT NULL COMMENT '实际启动日期',\n `parent_task_id` varchar(100) DEFAULT NULL COMMENT '父级任务id',\n `handle_way_disabled` varchar(10) DEFAULT NULL COMMENT '有值则禁止修改处理方式',\n `real_complete_time` datetime DEFAULT NULL COMMENT '实际完成时间',\n `instructions` text COMMENT '任务具体说明',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "task_no", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_no" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "task_type", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type" }, { "objectType": "TableField_MYSQL", "name": "required_date", "type": "date", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "要求完成日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "required_date" }, { "objectType": "TableField_MYSQL", "name": "batch_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "批次", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "batch_id" }, { "objectType": "TableField_MYSQL", "name": "task_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_name" }, { "objectType": "TableField_MYSQL", "name": "task_explain", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_explain" }, { "objectType": "TableField_MYSQL", "name": "handle_user_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_user_id" }, { "objectType": "TableField_MYSQL", "name": "handle_user_type", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理人类型 (1-内部,2-外包", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_user_type" }, { "objectType": "TableField_MYSQL", "name": "submit_user_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "submit_user_id" }, { "objectType": "TableField_MYSQL", "name": "submit_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "提交日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "submit_time" }, { "objectType": "TableField_MYSQL", "name": "status", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "状态(0-未完成 1-已完成)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "status" }, { "objectType": "TableField_MYSQL", "name": "handle_group", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理组织", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_group" }, { "objectType": "TableField_MYSQL", "name": "complete_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "完成日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "complete_time" }, { "objectType": "TableField_MYSQL", "name": "required_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "要求完成时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "required_time" }, { "objectType": "TableField_MYSQL", "name": "created_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_by" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "updated_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_by" }, { "objectType": "TableField_MYSQL", "name": "updated_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_at" }, { "objectType": "TableField_MYSQL", "name": "description", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "描述", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "description" }, { "objectType": "TableField_MYSQL", "name": "year_mon", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "年月", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "year_mon" }, { "objectType": "TableField_MYSQL", "name": "first", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "月份", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "first" }, { "objectType": "TableField_MYSQL", "name": "second", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "文件附件", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "second" }, { "objectType": "TableField_MYSQL", "name": "task_date", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "日期 一 二 三 四", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_date" }, { "objectType": "TableField_MYSQL", "name": "week_date", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "星期 星期一 星期二 星期三", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "week_date" }, { "objectType": "TableField_MYSQL", "name": "submit_status", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "1-保存,2-提交", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "submit_status" }, { "objectType": "TableField_MYSQL", "name": "handle_explain", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_explain" }, { "objectType": "TableField_MYSQL", "name": "spare_first", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理附件", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "spare_first" }, { "objectType": "TableField_MYSQL", "name": "spare_seconde", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务类型原", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "spare_seconde" }, { "objectType": "TableField_MYSQL", "name": "labor_hours", "type": "double", "length": 11, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所耗工时", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "labor_hours" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "estimate_hours", "type": "double", "length": 11, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "预估工时", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "estimate_hours" }, { "objectType": "TableField_MYSQL", "name": "plan_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "计划ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "plan_id" }, { "objectType": "TableField_MYSQL", "name": "post_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理人岗位id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_id" }, { "objectType": "TableField_MYSQL", "name": "post_level", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理人职级名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_level" }, { "objectType": "TableField_MYSQL", "name": "post_cost", "type": "decimal", "length": 18, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理人人力成本", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_cost" }, { "objectType": "TableField_MYSQL", "name": "review_hour", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "认定工时", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "review_hour" }, { "objectType": "TableField_MYSQL", "name": "plan_start_date", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "计划启动日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "plan_start_date" }, { "objectType": "TableField_MYSQL", "name": "handle_way", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "处理方式(0工时填报 1任务分解)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_way" }, { "objectType": "TableField_MYSQL", "name": "reality_start_date", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实际启动日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "reality_start_date" }, { "objectType": "TableField_MYSQL", "name": "parent_task_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "父级任务id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "parent_task_id" }, { "objectType": "TableField_MYSQL", "name": "handle_way_disabled", "type": "varchar", "length": 10, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "有值则禁止修改处理方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "handle_way_disabled" }, { "objectType": "TableField_MYSQL", "name": "real_complete_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实际完成时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "real_complete_time" }, { "objectType": "TableField_MYSQL", "name": "instructions", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务具体说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "instructions" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "oa_pro_type", "comment": "项目类型", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "oa_pro_type", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:20:34", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 24, "updateTime": "", "DDL": "CREATE TABLE `oa_pro_type` (\n `id` varchar(50) NOT NULL,\n `pro_label` varchar(255) DEFAULT NULL COMMENT '项目类型',\n `pro_value` varchar(255) DEFAULT NULL COMMENT '项目子项值',\n `is_default` varchar(10) DEFAULT NULL COMMENT '是否默认 (1-默认)',\n `is_not_sign` varchar(10) DEFAULT NULL COMMENT '不需要签约 (0-需要签约,1-不需要)',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n `created_by` varchar(64) DEFAULT NULL COMMENT '创建人id',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `updated_by` varchar(64) DEFAULT NULL COMMENT '修改人id',\n `updated_at` datetime DEFAULT NULL COMMENT '修改时间',\n `firs` varchar(255) DEFAULT NULL COMMENT '备用',\n `second` varchar(255) DEFAULT NULL COMMENT '备用',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目类型'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "pro_label", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_label" }, { "objectType": "TableField_MYSQL", "name": "pro_value", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目子项值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_value" }, { "objectType": "TableField_MYSQL", "name": "is_default", "type": "varchar", "length": 10, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否默认 (1-默认)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_default" }, { "objectType": "TableField_MYSQL", "name": "is_not_sign", "type": "varchar", "length": 10, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "不需要签约 (0-需要签约,1-不需要)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_not_sign" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "created_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_by" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "updated_by", "type": "varchar", "length": 64, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改人id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_by" }, { "objectType": "TableField_MYSQL", "name": "updated_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_at" }, { "objectType": "TableField_MYSQL", "name": "firs", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "firs" }, { "objectType": "TableField_MYSQL", "name": "second", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "second" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "oa_user_cost", "comment": "人员成本设定", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "oa_user_cost", "encryption": false, "createOptions": "", "createTime": "2024-12-01 00:20:45", "checkTime": "", "dataFree": 0, "dataLength": 81920, "indexLength": 16384, "maxDataLength": 0, "rows": 392, "updateTime": "", "DDL": "CREATE TABLE `oa_user_cost` (\n `id` varchar(100) NOT NULL COMMENT '主键',\n `post_id` varchar(100) DEFAULT NULL COMMENT '岗位id',\n `post_name` varchar(100) DEFAULT NULL COMMENT '岗位名称',\n `post_level` varchar(100) DEFAULT NULL COMMENT '岗位层级',\n `post_cost` decimal(18,2) DEFAULT NULL COMMENT '人力成本',\n `effect_date` datetime DEFAULT NULL COMMENT '生效日期',\n `create_user` varchar(100) DEFAULT NULL COMMENT '创建人',\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `update_user` varchar(100) DEFAULT NULL COMMENT '更新人',\n `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n `group_id` varchar(100) DEFAULT NULL COMMENT '集团id',\n PRIMARY KEY (`id`),\n KEY `oa_user_cost_group_id_index` (`group_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='人员成本设定'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "post_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_id" }, { "objectType": "TableField_MYSQL", "name": "post_name", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_name" }, { "objectType": "TableField_MYSQL", "name": "post_level", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位层级", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_level" }, { "objectType": "TableField_MYSQL", "name": "post_cost", "type": "decimal", "length": 18, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "人力成本", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_cost" }, { "objectType": "TableField_MYSQL", "name": "effect_date", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "生效日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "effect_date" }, { "objectType": "TableField_MYSQL", "name": "create_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_user" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_user", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_user" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "oa_user_cost_group_id_index", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "oa_user_cost_group_id_index", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "5", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "group_id", "keyLength": 0, "order": "", "oldName": "group_id" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "out_order_main", "comment": "外包采购单", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "out_order_main", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2024-12-01 00:20:45", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 38, "updateTime": "", "DDL": "CREATE TABLE `out_order_main` (\n `id` varchar(50) NOT NULL,\n `pro_id` varchar(50) DEFAULT NULL COMMENT '项目ID',\n `pro_name` varchar(255) DEFAULT NULL COMMENT '项目名称',\n `cust_name` varchar(255) DEFAULT NULL COMMENT '客户名称',\n `status` varchar(1) DEFAULT '0' COMMENT '订单状态,0-待支付,1-部分支付,2-已支付',\n `biz_id` varchar(50) DEFAULT NULL COMMENT '外采团队ID',\n `biz_name` varchar(255) DEFAULT NULL,\n `biz_by` varchar(50) DEFAULT NULL COMMENT '外包联系人',\n `order_no` varchar(50) DEFAULT NULL COMMENT '采购单号',\n `deal_at` datetime DEFAULT NULL COMMENT '发包时间',\n `out_timeline` datetime DEFAULT NULL COMMENT '要求完成时间',\n `delivery_at` datetime DEFAULT NULL COMMENT '交付时间',\n `trans_at` datetime DEFAULT NULL COMMENT '移交时间',\n `order_amount` double DEFAULT NULL COMMENT '订单总金额',\n `tax_rate` double DEFAULT NULL COMMENT '税率',\n `procure_content` varchar(2000) DEFAULT NULL COMMENT '采购内容',\n `procure_file` text COMMENT '采购附件',\n `pid_amount` double DEFAULT NULL COMMENT '已付款',\n `should_amount` double DEFAULT NULL COMMENT '应付款',\n `pay_type` varchar(255) DEFAULT NULL COMMENT '支付方式',\n `deal_by` varchar(50) DEFAULT NULL COMMENT '发包人',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `created_by` varchar(50) DEFAULT NULL COMMENT '创建人',\n `updated_by` varchar(50) DEFAULT NULL COMMENT '更新人',\n `updated_at` datetime DEFAULT NULL COMMENT '更新时间',\n `first` varchar(255) DEFAULT NULL COMMENT '备用字段',\n `second` varchar(255) DEFAULT NULL COMMENT '备用字段',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `source` varchar(255) DEFAULT NULL COMMENT '来源',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n `supplier_id` varchar(100) DEFAULT NULL COMMENT '供应商id',\n `amount_belong` varchar(100) DEFAULT NULL COMMENT '费用、成本归属',\n `amount_belong_type` varchar(100) DEFAULT NULL COMMENT '费用、成本归属类型',\n `excluding_order_amount` double DEFAULT NULL COMMENT '采购金额(不含税)',\n PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='外包采购单'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "pro_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_name" }, { "objectType": "TableField_MYSQL", "name": "cust_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cust_name" }, { "objectType": "TableField_MYSQL", "name": "status", "type": "varchar", "length": 1, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Others", "defaultValue": "'0'", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "订单状态,0-待支付,1-部分支付,2-已支付", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "status" }, { "objectType": "TableField_MYSQL", "name": "biz_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "外采团队ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_id" }, { "objectType": "TableField_MYSQL", "name": "biz_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_name" }, { "objectType": "TableField_MYSQL", "name": "biz_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "外包联系人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_by" }, { "objectType": "TableField_MYSQL", "name": "order_no", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "采购单号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "order_no" }, { "objectType": "TableField_MYSQL", "name": "deal_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发包时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "deal_at" }, { "objectType": "TableField_MYSQL", "name": "out_timeline", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "要求完成时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "out_timeline" }, { "objectType": "TableField_MYSQL", "name": "delivery_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "交付时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "delivery_at" }, { "objectType": "TableField_MYSQL", "name": "trans_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "移交时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "trans_at" }, { "objectType": "TableField_MYSQL", "name": "order_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "订单总金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "order_amount" }, { "objectType": "TableField_MYSQL", "name": "tax_rate", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "税率", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "tax_rate" }, { "objectType": "TableField_MYSQL", "name": "procure_content", "type": "varchar", "length": 2000, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "采购内容", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "procure_content" }, { "objectType": "TableField_MYSQL", "name": "procure_file", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "采购附件", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "procure_file" }, { "objectType": "TableField_MYSQL", "name": "pid_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "已付款", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pid_amount" }, { "objectType": "TableField_MYSQL", "name": "should_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "应付款", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "should_amount" }, { "objectType": "TableField_MYSQL", "name": "pay_type", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "支付方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_type" }, { "objectType": "TableField_MYSQL", "name": "deal_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发包人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "deal_by" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "created_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_by" }, { "objectType": "TableField_MYSQL", "name": "updated_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_by" }, { "objectType": "TableField_MYSQL", "name": "updated_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_at" }, { "objectType": "TableField_MYSQL", "name": "first", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用字段", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "first" }, { "objectType": "TableField_MYSQL", "name": "second", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备用字段", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "second" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "source", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "来源", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "source" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "supplier_id", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "供应商id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "supplier_id" }, { "objectType": "TableField_MYSQL", "name": "amount_belong", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "费用、成本归属", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "amount_belong" }, { "objectType": "TableField_MYSQL", "name": "amount_belong_type", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "费用、成本归属类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "amount_belong_type" }, { "objectType": "TableField_MYSQL", "name": "excluding_order_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "采购金额(不含税)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "excluding_order_amount" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "out_order_pay", "comment": "支付明细", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "out_order_pay", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2024-12-01 00:20:45", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 68, "updateTime": "", "DDL": "CREATE TABLE `out_order_pay` (\n `id` varchar(50) NOT NULL,\n `out_order_main_id` varchar(50) DEFAULT NULL COMMENT '采购单ID',\n `pay_detail_type` varchar(255) DEFAULT NULL COMMENT '支付方式',\n `pay_at` datetime DEFAULT NULL COMMENT '付款日期',\n `pay_name` varchar(255) DEFAULT NULL COMMENT '付款名称',\n `pay_amount` double DEFAULT NULL COMMENT '付款金额',\n `invoice_amount` double DEFAULT NULL COMMENT '发票金额',\n `rate` double DEFAULT NULL COMMENT '税率',\n `invoice_no` varchar(255) DEFAULT NULL COMMENT '发票号',\n `apply_time` datetime DEFAULT NULL COMMENT '申请时间',\n `apply_by` varchar(50) DEFAULT NULL COMMENT '申请人',\n `status` varchar(50) DEFAULT NULL COMMENT '付款状态(1-未付款 2-已付款)',\n `plan_pay_amount` double DEFAULT NULL COMMENT '计划付款金额',\n `plan_pay_time` datetime DEFAULT NULL COMMENT '计划付款时间',\n `remind_time` datetime DEFAULT NULL COMMENT '提醒时间',\n `invoice_file` text COMMENT '发票附件',\n `pay_info` text COMMENT '支付说明',\n `remark` text COMMENT '备注',\n `registrant_person` varchar(50) DEFAULT NULL COMMENT '登记人',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `created_by` varchar(50) DEFAULT NULL COMMENT '创建人',\n `updated_by` varchar(50) DEFAULT NULL COMMENT '更新人',\n `updated_at` datetime DEFAULT NULL COMMENT '更新时间',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团ID',\n `source` varchar(50) DEFAULT NULL COMMENT '来源 (2-流程)',\n `excluding_pay_amount` double DEFAULT NULL COMMENT '支付金额(不含税)',\n PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='支付明细'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "out_order_main_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "采购单ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "out_order_main_id" }, { "objectType": "TableField_MYSQL", "name": "pay_detail_type", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "支付方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_detail_type" }, { "objectType": "TableField_MYSQL", "name": "pay_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "付款日期", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_at" }, { "objectType": "TableField_MYSQL", "name": "pay_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "付款名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_name" }, { "objectType": "TableField_MYSQL", "name": "pay_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "付款金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_amount" }, { "objectType": "TableField_MYSQL", "name": "invoice_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发票金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "invoice_amount" }, { "objectType": "TableField_MYSQL", "name": "rate", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "税率", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "rate" }, { "objectType": "TableField_MYSQL", "name": "invoice_no", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发票号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "invoice_no" }, { "objectType": "TableField_MYSQL", "name": "apply_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "申请时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "apply_time" }, { "objectType": "TableField_MYSQL", "name": "apply_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "申请人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "apply_by" }, { "objectType": "TableField_MYSQL", "name": "status", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "付款状态(1-未付款 2-已付款)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "status" }, { "objectType": "TableField_MYSQL", "name": "plan_pay_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "计划付款金额", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "plan_pay_amount" }, { "objectType": "TableField_MYSQL", "name": "plan_pay_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "计划付款时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "plan_pay_time" }, { "objectType": "TableField_MYSQL", "name": "remind_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "提醒时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remind_time" }, { "objectType": "TableField_MYSQL", "name": "invoice_file", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发票附件", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "invoice_file" }, { "objectType": "TableField_MYSQL", "name": "pay_info", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "支付说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pay_info" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "text", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "registrant_person", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "登记人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "registrant_person" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "created_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_by" }, { "objectType": "TableField_MYSQL", "name": "updated_by", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_by" }, { "objectType": "TableField_MYSQL", "name": "updated_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "updated_at" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "source", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "来源 (2-流程)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "source" }, { "objectType": "TableField_MYSQL", "name": "excluding_pay_amount", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "支付金额(不含税)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "excluding_pay_amount" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "resource_plan_staff", "comment": "资源计划人员基础表", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "resource_plan_staff", "encryption": false, "createOptions": "", "createTime": "2024-12-13 16:40:25", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 32768, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `resource_plan_staff` (\n `id` varchar(50) NOT NULL,\n `user_id` varchar(50) DEFAULT NULL,\n `user_name` varchar(50) DEFAULT NULL COMMENT '用户名称',\n `oa_fun_classification_id` varchar(50) DEFAULT NULL COMMENT '职能分类ID',\n `oa_fun_classification_name` varchar(255) DEFAULT NULL COMMENT '职能分类名称',\n `post_id` varchar(50) DEFAULT NULL COMMENT '岗位职级(oa_user_cost)',\n `post_level_name` varchar(50) DEFAULT NULL COMMENT '岗位职级',\n `pro_id` varchar(50) DEFAULT NULL COMMENT '项目',\n `pro_name` varchar(255) DEFAULT NULL COMMENT '项目名称',\n `group_id` varchar(50) DEFAULT NULL COMMENT '集团',\n `cust_name` varchar(255) DEFAULT NULL COMMENT '客户',\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',\n `update_at` datetime DEFAULT NULL COMMENT '修改时间',\n `update_by` varchar(100) DEFAULT NULL COMMENT '修改人',\n PRIMARY KEY (`id`),\n KEY `staff_pro_id_index` (`pro_id`) USING BTREE,\n KEY `staff_user_id_index` (`user_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资源计划人员基础表'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "user_name", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_name" }, { "objectType": "TableField_MYSQL", "name": "oa_fun_classification_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "职能分类ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "oa_fun_classification_id" }, { "objectType": "TableField_MYSQL", "name": "oa_fun_classification_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "职能分类名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "oa_fun_classification_name" }, { "objectType": "TableField_MYSQL", "name": "post_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位职级(oa_user_cost)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_id" }, { "objectType": "TableField_MYSQL", "name": "post_level_name", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位职级", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_level_name" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "pro_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "项目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_name" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "集团", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "cust_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cust_name" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "staff_pro_id_index", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "staff_pro_id_index", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "0", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "pro_id", "keyLength": 0, "order": "", "oldName": "pro_id" } ] }, { "objectType": "Index_MYSQL", "name": "staff_user_id_index", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "staff_user_id_index", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "0", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "user_id", "keyLength": 0, "order": "", "oldName": "user_id" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "resource_plan_staff_detail", "comment": "资源计划人员详情表", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "resource_plan_staff_detail", "encryption": false, "createOptions": "", "createTime": "2024-12-13 16:40:25", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `resource_plan_staff_detail` (\n `id` varchar(50) NOT NULL,\n `plan_staff_id` varchar(50) DEFAULT NULL COMMENT '资源计划人员ID',\n `user_id` varchar(50) DEFAULT NULL,\n `pro_id` varchar(50) DEFAULT NULL,\n `year_no` int(11) DEFAULT NULL COMMENT '年',\n `month_no` int(11) DEFAULT NULL COMMENT '月',\n `year_month_str` varchar(50) DEFAULT NULL COMMENT '年月',\n `year_mon` int(11) DEFAULT NULL COMMENT '年月',\n `multiple_hour` double DEFAULT NULL COMMENT '倍数',\n `workload` double DEFAULT NULL COMMENT '工作量 (倍数*工作天数)',\n `cost` double DEFAULT NULL COMMENT '成本',\n `group_id` varchar(50) DEFAULT NULL,\n `created_at` datetime DEFAULT NULL COMMENT '创建时间',\n `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',\n `update_at` datetime DEFAULT NULL COMMENT '修改时间',\n `update_by` varchar(100) DEFAULT NULL COMMENT '修改人',\n `month_days` int(11) DEFAULT NULL COMMENT '每月工作天数',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资源计划人员详情表'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "plan_staff_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "资源计划人员ID", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "plan_staff_id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "pro_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "pro_id" }, { "objectType": "TableField_MYSQL", "name": "year_no", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "年", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "year_no" }, { "objectType": "TableField_MYSQL", "name": "month_no", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "月", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "month_no" }, { "objectType": "TableField_MYSQL", "name": "year_month_str", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "年月", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "year_month_str" }, { "objectType": "TableField_MYSQL", "name": "year_mon", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "年月", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "year_mon" }, { "objectType": "TableField_MYSQL", "name": "multiple_hour", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "倍数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "multiple_hour" }, { "objectType": "TableField_MYSQL", "name": "workload", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "工作量 (倍数*工作天数)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "workload" }, { "objectType": "TableField_MYSQL", "name": "cost", "type": "double", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "成本", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cost" }, { "objectType": "TableField_MYSQL", "name": "group_id", "type": "varchar", "length": 50, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "group_id" }, { "objectType": "TableField_MYSQL", "name": "created_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "created_at" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 100, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "修改人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "month_days", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "每月工作天数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "month_days" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] } ], "views": [] } ] }, "diagrams": [ { "name": "Diagram 1", "paperWidth": 2, "paperHeight": 1, "tableFont": "Arial Unicode MS", "tableFontSize": 14, "isBalckWhite": false, "showDBSchemaName": false, "showViewRelations": true, "notation": "default", "showFieldComment": false, "showTableComment": false, "shapes": [ { "type": "table", "schemaName": "zt", "tableName": "pro_main", "x": 0, "y": 50, "width": 300, "height": 931, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "pro_main_extend", "x": 370, "y": 30, "width": 225, "height": 571, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "oa_pro_task_hour", "x": 940, "y": 60, "width": 204, "height": 351, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "acc_receivable", "x": 670, "y": 580, "width": 210, "height": 851, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "ctr_main", "x": 1820, "y": 30, "width": 230, "height": 711, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "oa_expense_ledger", "x": 1550, "y": 40, "width": 218, "height": 311, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "oa_pro_task", "x": 1560, "y": 460, "width": 232, "height": 951, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "oa_pro_type", "x": 950, "y": 570, "width": 177, "height": 291, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "oa_user_cost", "x": 370, "y": 630, "width": 188, "height": 271, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "out_order_main", "x": 1280, "y": 530, "width": 235, "height": 731, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "out_order_pay", "x": 350, "y": 930, "width": 215, "height": 571, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "resource_plan_staff", "x": 620, "y": 70, "width": 271, "height": 351, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "zt", "tableName": "resource_plan_staff_detail", "x": 1290, "y": 50, "width": 217, "height": 391, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } } ], "layers": [], "relations": [ { "name": "FK_CONSTRAINTS_CTR_MAIN", "sourceTableName": "acc_receivable", "sourceSchemaName": "zt", "lineWidth": 1, "visible": true, "vertices": [ { "x": 780, "y": 565 }, { "x": 780, "y": 120 }, { "x": 1920, "y": 120 }, { "x": 1920, "y": 756 } ], "label": { "x": 788, "y": 560, "width": 209, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "FK_CONSTRAINT_CTR_PRO", "sourceTableName": "ctr_main", "sourceSchemaName": "zt", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1930, "y": 756 }, { "x": 1930, "y": 125 }, { "x": 150, "y": 125 }, { "x": 150, "y": 35 } ], "label": { "x": 1854, "y": 746, "width": 196, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } } ], "viewRelations": [] } ] }