{ "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_MARIADB", "name": "Default", "serverVersion": 100399, "edition": "Default", "lowerCaseTableNames": 0, "schemas": [ { "objectType": "Schema_MARIADB", "name": "Default", "tables": [ { "objectType": "Table_MARIADB", "name": "t_fillout_task_children", "comment": "填报审核任务中包含哪些任务类型", "engine": "", "characterSet": "", "collation": "", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "task_type_id", "type": "int", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type_id" } ], "indexes": [ { "objectType": "Index_MARIADB", "name": "", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_type_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_detail_t_fillout_task_1", "fields": [ "task_id" ], "referenceSchema": "base_db", "referenceTable": "t_fillout_task", "referenceFields": [ "task_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_detail_t_fillout_task_type_1", "fields": [ "task_type_id" ], "referenceSchema": "base_db", "referenceTable": "t_fillout_task_type", "referenceFields": [ "task_type_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MARIADB", "name": "t_fillout_bureau_task", "comment": "单位的填报任务进度表，哪一项完成了提交，哪一项还没有进行操作", "engine": "", "characterSet": "", "collation": "", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "哪一个任务", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "task_type_id", "type": "int", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "哪一个子类型", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type_id" }, { "objectType": "TableField_MARIADB", "name": "bureau_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "哪个单位ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_id" }, { "objectType": "TableField_MARIADB", "name": "district_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属的县区ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "district_id" }, { "objectType": "TableField_MARIADB", "name": "city_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属的市ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_id" }, { "objectType": "TableField_MARIADB", "name": "is_finish", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否已完成填报？", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_finish" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": -2147483648, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_type_id", "keyLength": -2147483648, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "bureau_id", "keyLength": -2147483648, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_bureau_sub_task_t_fillout_task_releation_1", "fields": [ "task_id" ], "referenceSchema": "Default", "referenceTable": "t_fillout_task_children", "referenceFields": [ "task_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_bureau_sub_task_t_fillout_task_releation_2", "fields": [ "task_type_id" ], "referenceSchema": "Default", "referenceTable": "t_fillout_task_children", "referenceFields": [ "task_type_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MARIADB", "name": "t_fillout_bureau_task_teacher", "comment": "", "engine": "", "characterSet": "", "collation": "", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "任务ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "task_type_id", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type_id" }, { "objectType": "TableField_MARIADB", "name": "bureau_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_id" }, { "objectType": "TableField_MARIADB", "name": "district_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所在的县区ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "district_id" }, { "objectType": "TableField_MARIADB", "name": "city_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所在的城市ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_id" }, { "objectType": "TableField_MARIADB", "name": "teacher_count_fillout", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "填报教职工数量", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "teacher_count_fillout" }, { "objectType": "TableField_MARIADB", "name": "teacher_count_real", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "系统计算出的实际数量", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "teacher_count_real" }, { "objectType": "TableField_MARIADB", "name": "last_updated_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "最后修改时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "last_updated_time" }, { "objectType": "TableField_MARIADB", "name": "last_updated_person", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "最后修改人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "last_updated_person" } ], "indexes": [ { "objectType": "Index_MARIADB", "name": "index_bureau_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "bureau_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "index_district_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "district_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "index_city_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "city_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": -2147483648, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "bureau_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_type_id", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_1", "fields": [ "task_id" ], "referenceSchema": "Default", "referenceTable": "t_fillout_bureau_task", "referenceFields": [ "task_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_2", "fields": [ "task_type_id" ], "referenceSchema": "Default", "referenceTable": "t_fillout_bureau_task", "referenceFields": [ "task_type_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_3", "fields": [ "bureau_id" ], "referenceSchema": "Default", "referenceTable": "t_fillout_bureau_task", "referenceFields": [ "bureau_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] } ], "views": [] }, { "objectType": "Schema_MARIADB", "name": "base_db", "tables": [ { "objectType": "Table_MARIADB", "name": "t_fillout_task_student", "comment": "教职工信息审核", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_bin", "autoIncrement": 1, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "t_fillout_teacher", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "2020-04-27 15:38:39", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `t_fillout_teacher` (\n `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n `person_count` int(11) NOT NULL COMMENT '教职工数量',\n `bureau_id` int(11) NOT NULL COMMENT '单位ID',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_student_id", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_student_id" }, { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "对应的任务ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "student_count_fillout", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "填充学生数量,{{.forUi}}", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "student_count_fillout" }, { "objectType": "TableField_MARIADB", "name": "student_count_real", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "实时学生数量", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "student_count_real" }, { "objectType": "TableField_MARIADB", "name": "fillout_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "填报人ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "fillout_person_id" }, { "objectType": "TableField_MARIADB", "name": "fillout_bureau_id", "type": "char", "length": 36, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "填报单位ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "fillout_bureau_id" }, { "objectType": "TableField_MARIADB", "name": "fillout_district_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属填报县区ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "fillout_district_id" }, { "objectType": "TableField_MARIADB", "name": "fillout_city_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属填报市ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "fillout_city_id" }, { "objectType": "TableField_MARIADB", "name": "last_updated_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间(最后修改时间)", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "last_updated_time" }, { "objectType": "TableField_MARIADB", "name": "bureau_check", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位是否审核", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_check" }, { "objectType": "TableField_MARIADB", "name": "bureau_check_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_check_time" }, { "objectType": "TableField_MARIADB", "name": "bureau_check_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_check_person_id" }, { "objectType": "TableField_MARIADB", "name": "distric_check", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区是否审核", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_check" }, { "objectType": "TableField_MARIADB", "name": "distric_check_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_check_time" }, { "objectType": "TableField_MARIADB", "name": "distric_check_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_check_person_id" }, { "objectType": "TableField_MARIADB", "name": "city_check", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市是否审核", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_check" }, { "objectType": "TableField_MARIADB", "name": "city_check_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_check_time" }, { "objectType": "TableField_MARIADB", "name": "city_check_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_check_person_id" } ], "indexes": [ { "objectType": "Index_MARIADB", "name": "", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "fillout_bureau_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "bureau_check", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "_copy_2", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "fillout_district_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "distric_check", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "_copy_1", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "fillout_city_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "city_check", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_student_id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_teacher_task_t_fillout_task_1_copy_1", "fields": [ "task_id" ], "referenceSchema": "base_db", "referenceTable": "t_fillout_task", "referenceFields": [ "task_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MARIADB", "name": "t_fillout_task_type", "comment": "审核任务类型表", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_bin", "autoIncrement": 1, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "t_fillout_task_type", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "2020-04-27 15:40:18", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `t_fillout_task_type` (\n `task_type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '任务类型ID',\n `task_type_name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '任务类型名称',\n PRIMARY KEY (`task_type_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_type_id", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "任务类型ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type_id" }, { "objectType": "TableField_MARIADB", "name": "task_type_name", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "utf8", "collation": "utf8_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务类型名称", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_type_name" }, { "objectType": "TableField_MARIADB", "name": "table_name", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "对应的表名", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "table_name" }, { "objectType": "TableField_MARIADB", "name": "is_sync", "type": "int", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否可以通过实时数据接口进行同步？", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_sync" }, { "objectType": "TableField_MARIADB", "name": "sync_http_interface", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "’-1‘", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "同步获取数据的http接口,此接口接收bureau_id,district_id,city_id三个参数，来获取数据实时信息。", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sync_http_interface" }, { "objectType": "TableField_MARIADB", "name": "config_json", "type": "longtext", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "配置的JSON数据，用于UI展示和数据验证，以及其它相关配置信息", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "config_json" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_type_id", "keyLength": 0, "order": "", "oldName": "task_type_id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MARIADB", "name": "t_fillout_task_verification", "comment": "教职工信息审核", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_bin", "autoIncrement": 1, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "t_fillout_teacher", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "2020-04-27 15:38:39", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `t_fillout_teacher` (\n `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',\n `person_count` int(11) NOT NULL COMMENT '教职工数量',\n `bureau_id` int(11) NOT NULL COMMENT '单位ID',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "bureau_id", "type": "char", "length": 36, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "填报单位ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_id" }, { "objectType": "TableField_MARIADB", "name": "district_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属填报县区ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "district_id" }, { "objectType": "TableField_MARIADB", "name": "city_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属填报市ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_id" }, { "objectType": "TableField_MARIADB", "name": "bureau_verification", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位审核结果，0:待审，1：通过，2：拒绝", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_verification" }, { "objectType": "TableField_MARIADB", "name": "bureau_verification_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_verification_time" }, { "objectType": "TableField_MARIADB", "name": "bureau_verification_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "单位审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "bureau_verification_person_id" }, { "objectType": "TableField_MARIADB", "name": "distric_verification", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区审核结果，-1：未达，0：待审核，1：通过，2：拒绝", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_verification" }, { "objectType": "TableField_MARIADB", "name": "distric_verification_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_verification_time" }, { "objectType": "TableField_MARIADB", "name": "distric_verification_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "县区审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "distric_verification_person_id" }, { "objectType": "TableField_MARIADB", "name": "city_verification", "type": "int", "length": 11, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市审核结果，-1:未达，0：待审，1：通过，2：拒绝", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_verification" }, { "objectType": "TableField_MARIADB", "name": "city_verification_time", "type": "datetime", "length": -2147483648, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市审核时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_verification_time" }, { "objectType": "TableField_MARIADB", "name": "city_verification_person_id", "type": "char", "length": 36, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "市审核人员ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "city_verification_person_id" } ], "indexes": [ { "objectType": "Index_MARIADB", "name": "index_bureau_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "bureau_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "index_district_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "district_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MARIADB", "name": "index_city_task", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "city_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "bureau_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MARIADB", "name": "fk_t_fillout_task_common_t_fillout_task_1", "fields": [ "task_id" ], "referenceSchema": "base_db", "referenceTable": "t_fillout_task", "referenceFields": [ "task_id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MARIADB", "name": "t_fillout_task", "comment": "填报审核任务表", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_bin", "autoIncrement": 1, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": "", "union": "", "pageChecksum": false, "transactional": false, "oldName": "t_fillout_task", "encryption": false, "encryptionKeyID": 0, "IETFQuotes": false, "createOptions": "", "createTime": "2020-04-27 15:39:33", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 16384, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `t_fillout_task` (\n `task_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '任务主键',\n `task_name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '任务名称',\n `task_type_id` int(11) NOT NULL COMMENT '任务类型ID',\n `org_id` char(36) COLLATE utf8_bin NOT NULL COMMENT '单位ID',\n `level_id` int(11) NOT NULL COMMENT '任务级别，1：市级，2：县级，3：校级',\n `start_date` date NOT NULL COMMENT '开始日期',\n `end_date` date NOT NULL COMMENT '结束日期',\n `b_use` int(11) NOT NULL COMMENT '是否正在进行中',\n `create_person_id` char(36) COLLATE utf8_bin NOT NULL COMMENT '创建人ID',\n `create_time` datetime NOT NULL COMMENT '创建时间',\n PRIMARY KEY (`task_id`),\n KEY `index_org_id_b_use` (`org_id`,`b_use`,`task_type_id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MARIADB", "name": "task_id", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "任务主键", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_id" }, { "objectType": "TableField_MARIADB", "name": "task_name", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "utf8", "collation": "utf8_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务名称", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_name" }, { "objectType": "TableField_MARIADB", "name": "task_title", "type": "varchar", "length": 255, "decimals": -2147483648, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用来做大数据展示时的统计截止描述信息", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "task_title" }, { "objectType": "TableField_MARIADB", "name": "manager_id", "type": "char", "length": 36, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "utf8", "collation": "utf8_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发布单位ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "manager_id" }, { "objectType": "TableField_MARIADB", "name": "level_id", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "任务级别，1：市级，2：县级", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "level_id" }, { "objectType": "TableField_MARIADB", "name": "start_date", "type": "date", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "开始日期", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "start_date" }, { "objectType": "TableField_MARIADB", "name": "end_date", "type": "date", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "结束日期", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "end_date" }, { "objectType": "TableField_MARIADB", "name": "b_use", "type": "int", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否正在进行中", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "b_use" }, { "objectType": "TableField_MARIADB", "name": "create_person_id", "type": "char", "length": 36, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "utf8", "collation": "utf8_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人ID", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_person_id" }, { "objectType": "TableField_MARIADB", "name": "create_time", "type": "datetime", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" } ], "indexes": [ { "objectType": "Index_MARIADB", "name": "index_org_id_b_use", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "index_org_id_b_use", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "0", "packed": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "b_use", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MARIADB", "name": "", "fields": [ { "objectType": "IndexField_MARIADB", "name": "task_id", "keyLength": 0, "order": "", "oldName": "task_id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] } ], "views": [] } ] }, "diagrams": [ { "name": "Diagram 1", "paperWidth": 1, "paperHeight": 1, "tableFont": "Arial Unicode MS", "tableFontSize": 14, "isBalckWhite": false, "showDBSchemaName": false, "showViewRelations": true, "notation": "default", "showFieldComment": false, "showTableComment": false, "shapes": [ { "type": "table", "schemaName": "base_db", "tableName": "t_fillout_task", "x": 380, "y": 70, "width": 220, "height": 250, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "base_db", "tableName": "t_fillout_task_type", "x": 910, "y": 110, "width": 209, "height": 180, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "base_db", "tableName": "t_fillout_task_verification", "x": 40, "y": 40, "width": 280, "height": 320, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "Default", "tableName": "t_fillout_task_children", "x": 660, "y": 150, "width": 200, "height": 90, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "Default", "tableName": "t_fillout_bureau_task_teacher", "x": 630, "y": 560, "width": 250, "height": 220, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "Default", "tableName": "t_fillout_bureau_task", "x": 660, "y": 300, "width": 200, "height": 200, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } } ], "layers": [], "relations": [ { "name": "fk_t_fillout_task_detail_t_fillout_task_1", "sourceTableName": "t_fillout_task_children", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 645, "y": 200 }, { "x": 615, "y": 200 } ], "label": { "x": 399, "y": 162, "width": 256, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_task_detail_t_fillout_task_type_1", "sourceTableName": "t_fillout_task_children", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 875, "y": 200 }, { "x": 895, "y": 200 } ], "label": { "x": 871, "y": 172, "width": 291, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_task_common_t_fillout_task_1", "sourceTableName": "t_fillout_task_verification", "sourceSchemaName": "base_db", "lineWidth": 1, "visible": true, "vertices": [ { "x": 335, "y": 200 }, { "x": 365, "y": 200 } ], "label": { "x": 325, "y": 162, "width": 278, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_bureau_sub_task_t_fillout_task_releation_1", "sourceTableName": "t_fillout_bureau_task", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 775, "y": 285 }, { "x": 775, "y": 255 } ], "label": { "x": 415, "y": 255, "width": 362, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_bureau_sub_task_t_fillout_task_releation_2", "sourceTableName": "t_fillout_bureau_task", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 745, "y": 285 }, { "x": 745, "y": 255 } ], "label": { "x": 385, "y": 255, "width": 362, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_1", "sourceTableName": "t_fillout_bureau_task_teacher", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 780, "y": 545 }, { "x": 780, "y": 515 } ], "label": { "x": 430, "y": 515, "width": 352, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_2", "sourceTableName": "t_fillout_bureau_task_teacher", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 760, "y": 545 }, { "x": 760, "y": 515 } ], "label": { "x": 410, "y": 515, "width": 352, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_t_fillout_task_teacher_t_fillout_bureau_sub_task_3", "sourceTableName": "t_fillout_bureau_task_teacher", "sourceSchemaName": "Default", "lineWidth": 1, "visible": true, "vertices": [ { "x": 740, "y": 545 }, { "x": 740, "y": 515 } ], "label": { "x": 390, "y": 515, "width": 352, "height": 30, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } } ], "viewRelations": [] } ] }