bigdata
/
dsMin
6
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
dsMin/数据库模型/填报审核模型.ndm2

3006 lines
101 KiB
Raw Permalink Blame History Escape

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

{
"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": []
}
]
}
Reference in new issue View Git Blame Copy Permalink