{ "paper": { "name": "A4", "leftMargin": 0.5, "rightMargin": 0.5, "topMargin": 0.5, "bottomMargin": 0.5, "isPortriat": true }, "modelVersion": 2.01, "defaultSchema": "mldong", "server": { "objectType": "Server_MYSQL", "name": "Default", "serverVersion": 50728, "edition": "Default", "lowerCaseTableNames": 0, "schemas": [ { "objectType": "Schema_MYSQL", "name": "mldong", "tables": [ { "objectType": "Table_MYSQL", "name": "sys_config", "comment": "参数配置", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 2, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_config", "encryption": false, "createOptions": "", "createTime": "2020-11-05 09:47:46", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `sys_config` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',\n `config_name` varchar(64) DEFAULT NULL COMMENT '参数名称',\n `config_key` varchar(64) DEFAULT NULL COMMENT '参数键名',\n `config_value` text COMMENT '参数键值',\n `is_system` tinyint(1) unsigned DEFAULT '2' COMMENT '系统内置(1->否|NO,2->是|YES)',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='参数配置'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "config_name", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "参数名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "config_name" }, { "objectType": "TableField_MYSQL", "name": "config_key", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "参数键名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "config_key" }, { "objectType": "TableField_MYSQL", "name": "config_value", "type": "text", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "参数键值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "config_value" }, { "objectType": "TableField_MYSQL", "name": "is_system", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "系统内置(1->否|NO,2->是|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_system" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_dept", "comment": "", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 15, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_dept", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-10-24 19:02:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 4, "updateTime": "", "DDL": "CREATE TABLE `sys_dept` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `parent_id` bigint(20) DEFAULT '0' COMMENT '父级id',\n `name` varchar(100) NOT NULL COMMENT '部门名称',\n `code` varchar(30) DEFAULT NULL COMMENT '部门编码',\n `sort` double(10,2) DEFAULT '10.00' COMMENT '排序',\n `contacts` varchar(20) DEFAULT NULL COMMENT '联系人',\n `mobile_phone` varchar(15) DEFAULT NULL COMMENT '联系人手机号',\n `telephone` varchar(20) DEFAULT NULL COMMENT '电话',\n `email` varchar(32) DEFAULT NULL COMMENT '邮箱',\n `address` varchar(255) DEFAULT NULL COMMENT '地址',\n `is_enabled` tinyint(1) unsigned DEFAULT '2' COMMENT '是否启用(1->禁用|NO,2->启用|YES)',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "父级id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "parent_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "部门名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 30, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "部门编码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "code" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "contacts", "type": "varchar", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "联系人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "contacts" }, { "objectType": "TableField_MYSQL", "name": "mobile_phone", "type": "varchar", "length": 15, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "联系人手机号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "mobile_phone" }, { "objectType": "TableField_MYSQL", "name": "telephone", "type": "varchar", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "电话", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "telephone" }, { "objectType": "TableField_MYSQL", "name": "email", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "邮箱", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "email" }, { "objectType": "TableField_MYSQL", "name": "address", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "address" }, { "objectType": "TableField_MYSQL", "name": "is_enabled", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否启用(1->禁用|NO,2->启用|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_enabled" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_dict", "comment": "字典", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 7, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_dict", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 6, "updateTime": "2021-01-20 09:00:38", "DDL": "CREATE TABLE `sys_dict` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `name` varchar(32) NOT NULL COMMENT '名称',\n `dict_key` varchar(64) NOT NULL COMMENT '唯一编码',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='字典'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "dict_key", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "唯一编码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dict_key" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_notice", "comment": "通知公告", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 2, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_notice", "encryption": false, "createOptions": "", "createTime": "2020-10-27 17:08:51", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 1, "updateTime": "2021-01-29 15:20:01", "DDL": "CREATE TABLE `sys_notice` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',\n `title` varchar(100) DEFAULT NULL COMMENT '公告标题',\n `type` int(6) unsigned DEFAULT '10' COMMENT '公告类型(10->通知|TZ,20->公告|GG)',\n `content` longtext COMMENT '公告内容',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='通知公告'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "title", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "公告标题", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "title" }, { "objectType": "TableField_MYSQL", "name": "type", "type": "int", "length": 6, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "公告类型(10->通知|TZ,20->公告|GG)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "type" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "longtext", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "公告内容", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "content" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_role", "comment": "角色", "engine": "InnoDB", "characterSet": "utf8", "collation": "utf8_general_ci", "autoIncrement": 6, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Compact", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_role", "encryption": false, "createOptions": "row_format=COMPACT", "createTime": "2020-12-23 20:06:30", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 5, "updateTime": "", "DDL": "CREATE TABLE `sys_role` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `name` varchar(64) CHARACTER SET utf8mb4 NOT NULL COMMENT '角色名称',\n `role_key` varchar(32) DEFAULT NULL COMMENT '角色标识(唯一)',\n `role_type` int(6) DEFAULT '10' COMMENT '角色类型(10->管理员|ADMIN,20->流程审核员|WORKFLOW)',\n `data_scope` int(6) unsigned DEFAULT '10' COMMENT '数据范围(10->所有数据权限|ALL,20->部门数据权限|DEPT,30->部门及以下数据权限|DEPT_CHILD,40->仅本人数据权限|MYSELF,50->自定义数据权限|CUSTOM)',\n `is_enabled` tinyint(1) DEFAULT '2' COMMENT '是否启用(1->禁用|NO,2->启用|YES)',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "role_key", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色标识(唯一)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_key" }, { "objectType": "TableField_MYSQL", "name": "role_type", "type": "int", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色类型(10->管理员|ADMIN,20->流程审核员|WORKFLOW)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_type" }, { "objectType": "TableField_MYSQL", "name": "data_scope", "type": "int", "length": 6, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "数据范围(10->所有数据权限|ALL,20->部门数据权限|DEPT,30->部门及以下数据权限|DEPT_CHILD,40->仅本人数据权限|MYSELF,50->自定义数据权限|CUSTOM)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "data_scope" }, { "objectType": "TableField_MYSQL", "name": "is_enabled", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否启用(1->禁用|NO,2->启用|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_enabled" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8", "collation": "utf8_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_upload_config", "comment": "上传配置", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 2, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_upload_config", "encryption": false, "createOptions": "", "createTime": "2020-11-05 22:26:16", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 1, "updateTime": "", "DDL": "CREATE TABLE `sys_upload_config` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `biz_name` varchar(100) DEFAULT NULL COMMENT '业务名称',\n `biz_type` varchar(32) NOT NULL COMMENT '业务类型',\n `file_size_min` bigint(20) unsigned DEFAULT '0' COMMENT '限定上传文件大小最小值，单位`byte`。（0为不限制）',\n `file_size_max` bigint(20) unsigned DEFAULT '0' COMMENT '限定上传文件大小最大值，单位`byte`。（0为不限制）',\n `file_ext` varchar(64) NOT NULL COMMENT '限定用户上传后辍(多个逗号分割)',\n `upload_dir` varchar(100) DEFAULT '' COMMENT '上传目录',\n `upload_sub_dir` varchar(255) DEFAULT '' COMMENT '上传子目录',\n `base_url` varchar(32) DEFAULT '' COMMENT '访问地址前辍',\n `callback_url` varchar(100) DEFAULT '' COMMENT '回调地址',\n `naming_strategy` varchar(32) NOT NULL COMMENT '命名策略',\n `is_record` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否记录(1->不记录|NO,2->记录|YES)',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='上传配置'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "biz_name", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "业务名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_name" }, { "objectType": "TableField_MYSQL", "name": "biz_type", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "业务类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_type" }, { "objectType": "TableField_MYSQL", "name": "file_size_min", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "限定上传文件大小最小值，单位`byte`。（0为不限制）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_size_min" }, { "objectType": "TableField_MYSQL", "name": "file_size_max", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "限定上传文件大小最大值，单位`byte`。（0为不限制）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_size_max" }, { "objectType": "TableField_MYSQL", "name": "file_ext", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "限定用户上传后辍(多个逗号分割)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_ext" }, { "objectType": "TableField_MYSQL", "name": "upload_dir", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Empty", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "上传目录", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "upload_dir" }, { "objectType": "TableField_MYSQL", "name": "upload_sub_dir", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Empty", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "上传子目录", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "upload_sub_dir" }, { "objectType": "TableField_MYSQL", "name": "base_url", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Empty", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "访问地址前辍", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "base_url" }, { "objectType": "TableField_MYSQL", "name": "callback_url", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Empty", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "回调地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "callback_url" }, { "objectType": "TableField_MYSQL", "name": "naming_strategy", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "命名策略", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "naming_strategy" }, { "objectType": "TableField_MYSQL", "name": "is_record", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否记录(1->不记录|NO,2->记录|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_record" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_upload_record", "comment": "上传记录", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 5, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_upload_record", "encryption": false, "createOptions": "", "createTime": "2020-06-14 12:58:12", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `sys_upload_record` (\n `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',\n `biz_type` varchar(32) DEFAULT NULL COMMENT '业务类型',\n `biz_id` varchar(40) DEFAULT NULL COMMENT '业务id',\n `url` varchar(100) DEFAULT NULL COMMENT '文件保存的资源路径',\n `file_name` varchar(100) DEFAULT NULL COMMENT '上传的原始文件名',\n `file_size` bigint(20) unsigned DEFAULT NULL COMMENT '资源大小，单位为字节',\n `mime_type` varchar(32) DEFAULT NULL COMMENT '资源类型',\n `file_ext` varchar(10) DEFAULT NULL COMMENT '上传资源的后缀名',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='上传记录'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "biz_type", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "业务类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_type" }, { "objectType": "TableField_MYSQL", "name": "biz_id", "type": "varchar", "length": 40, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "业务id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "biz_id" }, { "objectType": "TableField_MYSQL", "name": "url", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "文件保存的资源路径", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "url" }, { "objectType": "TableField_MYSQL", "name": "file_name", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "上传的原始文件名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_name" }, { "objectType": "TableField_MYSQL", "name": "file_size", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "资源大小，单位为字节", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_size" }, { "objectType": "TableField_MYSQL", "name": "mime_type", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "资源类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "mime_type" }, { "objectType": "TableField_MYSQL", "name": "file_ext", "type": "varchar", "length": 10, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "上传资源的后缀名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "file_ext" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_user", "comment": "用户", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 16, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Compact", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_user", "encryption": false, "createOptions": "row_format=COMPACT", "createTime": "2020-10-21 09:44:24", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 32768, "maxDataLength": 0, "rows": 12, "updateTime": "", "DDL": "CREATE TABLE `sys_user` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `user_name` varchar(32) NOT NULL COMMENT '用户名',\n `real_name` varchar(32) DEFAULT NULL COMMENT '姓名',\n `avatar` varchar(200) DEFAULT NULL COMMENT '头像',\n `email` varchar(64) DEFAULT NULL COMMENT '邮箱',\n `mobile_phone` varchar(11) DEFAULT NULL COMMENT '手机号',\n `telephone` varchar(20) DEFAULT NULL COMMENT '电话',\n `password` varchar(40) DEFAULT NULL COMMENT '密码',\n `salt` varchar(10) DEFAULT NULL COMMENT '加盐',\n `sex` int(6) unsigned DEFAULT '1' COMMENT '性别(1->男|MALE,2->女|FEMALE,3->未知|UNKNOWN)',\n `is_locked` tinyint(1) unsigned DEFAULT '1' COMMENT '是否锁定(2->已锁定|YES,1->未锁定|NO)',\n `dept_id` bigint(20) unsigned DEFAULT NULL COMMENT '部门id',\n `post_id` bigint(20) unsigned DEFAULT NULL COMMENT '岗位id',\n `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`),\n KEY `real_name` (`real_name`),\n KEY `user_name` (`user_name`)\n) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "user_name", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_name" }, { "objectType": "TableField_MYSQL", "name": "real_name", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "姓名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "real_name" }, { "objectType": "TableField_MYSQL", "name": "avatar", "type": "varchar", "length": 200, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "头像", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "avatar" }, { "objectType": "TableField_MYSQL", "name": "email", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "邮箱", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "email" }, { "objectType": "TableField_MYSQL", "name": "mobile_phone", "type": "varchar", "length": 11, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "手机号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "mobile_phone" }, { "objectType": "TableField_MYSQL", "name": "telephone", "type": "varchar", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "电话", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "telephone" }, { "objectType": "TableField_MYSQL", "name": "password", "type": "varchar", "length": 40, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "密码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "password" }, { "objectType": "TableField_MYSQL", "name": "salt", "type": "varchar", "length": 10, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "加盐", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "salt" }, { "objectType": "TableField_MYSQL", "name": "sex", "type": "int", "length": 6, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "性别(1->男|MALE,2->女|FEMALE,3->未知|UNKNOWN)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sex" }, { "objectType": "TableField_MYSQL", "name": "is_locked", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否锁定(2->已锁定|YES,1->未锁定|NO)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_locked" }, { "objectType": "TableField_MYSQL", "name": "dept_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "部门id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dept_id" }, { "objectType": "TableField_MYSQL", "name": "post_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "post_id" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "real_name", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "real_name", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "10", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "real_name", "keyLength": 0, "order": "", "oldName": "real_name" } ] }, { "objectType": "Index_MYSQL", "name": "user_name", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "user_name", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "12", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "user_name", "keyLength": 0, "order": "", "oldName": "user_name" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_user_role", "comment": "用户角色关系表", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 13, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_user_role", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 11, "updateTime": "", "DDL": "CREATE TABLE `sys_user_role` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',\n `role_id` bigint(20) unsigned NOT NULL COMMENT '角色id',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色关系表'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_id" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_ur_user_id", "fields": [ "user_id" ], "referenceSchema": "mldong", "referenceTable": "sys_user", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_ur_role_id", "fields": [ "role_id" ], "referenceSchema": "mldong", "referenceTable": "sys_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_role_menu", "comment": "角色菜单关系", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 47, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_role_menu", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 46, "updateTime": "", "DDL": "CREATE TABLE `sys_role_menu` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `role_id` bigint(20) unsigned NOT NULL COMMENT '角色id',\n `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单id',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COMMENT='角色菜单关系'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_id" }, { "objectType": "TableField_MYSQL", "name": "menu_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "菜单id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "menu_id" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_rm_role_id", "fields": [ "role_id" ], "referenceSchema": "mldong", "referenceTable": "sys_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_rm_menu_id", "fields": [ "menu_id" ], "referenceSchema": "mldong", "referenceTable": "sys_menu", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_role_access", "comment": "角色权限关系", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 51, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_role_access", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 16384, "maxDataLength": 0, "rows": 49, "updateTime": "", "DDL": "CREATE TABLE `sys_role_access` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `role_id` bigint(20) unsigned NOT NULL COMMENT '角色id',\n `access` varchar(64) NOT NULL COMMENT '权限标识',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`),\n KEY `idx_sys_role_access` (`access`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限关系'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_id" }, { "objectType": "TableField_MYSQL", "name": "access", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "权限标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "access" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_sys_role_access", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "idx_sys_role_access", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "A", "cardinality": "45", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "access", "keyLength": 0, "order": "", "oldName": "access" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_ra_role_id", "fields": [ "role_id" ], "referenceSchema": "mldong", "referenceTable": "sys_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_role_dept", "comment": "角色部门关系表", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "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": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_role_dept", "encryption": false, "createOptions": "", "createTime": "2020-12-23 19:59:51", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "CREATE TABLE `sys_role_dept` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `role_id` bigint(20) unsigned NOT NULL COMMENT '角色id',\n `dept_id` bigint(20) unsigned NOT NULL COMMENT '角色id',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色部门关系表'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "role_id" }, { "objectType": "TableField_MYSQL", "name": "dept_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "角色id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dept_id" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_rd_role_id", "fields": [ "role_id" ], "referenceSchema": "mldong", "referenceTable": "sys_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_rd_dept_id", "fields": [ "dept_id" ], "referenceSchema": "mldong", "referenceTable": "sys_dept", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_user_login_times", "comment": "用户登录次数", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "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": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_user_login_times", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 1, "updateTime": "", "DDL": "CREATE TABLE `sys_user_login_times` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',\n `login_ip` char(15) DEFAULT NULL COMMENT '登录ip',\n `times` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '登录次数',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户登录次数'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "login_ip", "type": "char", "length": 15, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "登录ip", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "login_ip" }, { "objectType": "TableField_MYSQL", "name": "times", "type": "int", "length": 10, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "登录次数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "times" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_ult_user_id", "fields": [ "user_id" ], "referenceSchema": "mldong", "referenceTable": "sys_user", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_request_log", "comment": "请求日志", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 1004, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_request_log", "encryption": false, "createOptions": "", "createTime": "2020-09-06 20:13:17", "checkTime": "", "dataFree": 4194304, "dataLength": 3686400, "indexLength": 0, "maxDataLength": 0, "rows": 642, "updateTime": "2021-02-03 08:43:14", "DDL": "CREATE TABLE `sys_request_log` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `track_id` char(40) DEFAULT NULL COMMENT '请求唯一标识',\n `request_type` int(10) unsigned DEFAULT '99' COMMENT '请求类型(10->添加|SAVE,20->修改|UPDATE,30->删除|REMOVE,40->导入|IMPORT,50->导出|EXPORT,99->其他|OTHER)',\n `uri` varchar(64) DEFAULT NULL COMMENT '请求路径',\n `query_string` varchar(255) DEFAULT NULL COMMENT '请求url参数',\n `method` char(8) DEFAULT NULL COMMENT '请求方式',\n `description` varchar(64) DEFAULT NULL COMMENT '操作说明',\n `ip` varchar(16) DEFAULT NULL COMMENT '客户端ip',\n `body` text COMMENT '请求体',\n `token` varchar(255) DEFAULT NULL COMMENT '请求token',\n `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',\n `user_name` varchar(64) DEFAULT NULL COMMENT '用户名',\n `return_data` longtext COMMENT '返回参数',\n `start_time` datetime(3) DEFAULT NULL COMMENT '开始时间',\n `end_time` datetime(3) DEFAULT NULL COMMENT '结束时间',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8mb4 COMMENT='请求日志'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "track_id", "type": "char", "length": 40, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求唯一标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "track_id" }, { "objectType": "TableField_MYSQL", "name": "request_type", "type": "int", "length": 10, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "99", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求类型(10->添加|SAVE,20->修改|UPDATE,30->删除|REMOVE,40->导入|IMPORT,50->导出|EXPORT,99->其他|OTHER)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "request_type" }, { "objectType": "TableField_MYSQL", "name": "uri", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求路径", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "uri" }, { "objectType": "TableField_MYSQL", "name": "query_string", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求url参数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "query_string" }, { "objectType": "TableField_MYSQL", "name": "method", "type": "char", "length": 8, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求方式", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "method" }, { "objectType": "TableField_MYSQL", "name": "description", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "操作说明", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "description" }, { "objectType": "TableField_MYSQL", "name": "ip", "type": "varchar", "length": 16, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "客户端ip", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ip" }, { "objectType": "TableField_MYSQL", "name": "body", "type": "text", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求体", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "body" }, { "objectType": "TableField_MYSQL", "name": "token", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求token", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "token" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "user_name", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_name" }, { "objectType": "TableField_MYSQL", "name": "return_data", "type": "longtext", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "返回参数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "return_data" }, { "objectType": "TableField_MYSQL", "name": "start_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "开始时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "start_time" }, { "objectType": "TableField_MYSQL", "name": "end_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "结束时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "end_time" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_url_user_id", "fields": [ "user_id" ], "referenceSchema": "mldong", "referenceTable": "sys_user", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "cms_article", "comment": "", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 4, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "cms_article", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2021-01-05 09:00:09", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 3, "updateTime": "", "DDL": "CREATE TABLE `cms_article` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `category_id` bigint(20) unsigned DEFAULT NULL COMMENT '栏目id',\n `title` varchar(120) NOT NULL COMMENT '标题',\n `description` varchar(255) DEFAULT NULL COMMENT '描述',\n `cover` varchar(255) DEFAULT NULL COMMENT '大图',\n `author` varchar(30) DEFAULT NULL COMMENT '作者',\n `source` varchar(64) DEFAULT NULL COMMENT '文章来源',\n `sort` double(10,2) unsigned DEFAULT '10.00' COMMENT '排序',\n `publish_time` datetime(3) DEFAULT NULL COMMENT '发布时间',\n `is_publish` tinyint(1) DEFAULT NULL COMMENT '是否发布(1->否|NO,2->是|YES)',\n `content` mediumtext COMMENT '文本内容',\n `ext_form_value` text COMMENT '扩展信息',\n `dept_id` bigint(20) unsigned DEFAULT NULL COMMENT '所属部门',\n `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '所属用户',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "category_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "栏目id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "category_id" }, { "objectType": "TableField_MYSQL", "name": "title", "type": "varchar", "length": 120, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标题", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "title" }, { "objectType": "TableField_MYSQL", "name": "description", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "描述", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "description" }, { "objectType": "TableField_MYSQL", "name": "cover", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "大图", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cover" }, { "objectType": "TableField_MYSQL", "name": "author", "type": "varchar", "length": 30, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "作者", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "author" }, { "objectType": "TableField_MYSQL", "name": "source", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "文章来源", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "source" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "publish_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "发布时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "publish_time" }, { "objectType": "TableField_MYSQL", "name": "is_publish", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否发布(1->否|NO,2->是|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_publish" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "mediumtext", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "文本内容", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "content" }, { "objectType": "TableField_MYSQL", "name": "ext_form_value", "type": "text", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "扩展信息", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ext_form_value" }, { "objectType": "TableField_MYSQL", "name": "dept_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属部门", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dept_id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属用户", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_ac_category_id", "fields": [ "category_id" ], "referenceSchema": "mldong", "referenceTable": "cms_category", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_au_user_id", "fields": [], "referenceSchema": "mldong", "referenceTable": "sys_user", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_ad_dept_id", "fields": [], "referenceSchema": "mldong", "referenceTable": "sys_dept", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_menu", "comment": "菜单", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 27, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_menu", "encryption": false, "createOptions": "", "createTime": "2021-01-08 17:30:13", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 22, "updateTime": "", "DDL": "CREATE TABLE `sys_menu` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `parent_id` bigint(20) unsigned DEFAULT '0' COMMENT '父菜单id',\n `name` varchar(64) NOT NULL COMMENT '菜单名称',\n `sort` double(10,2) DEFAULT '10.00' COMMENT '排序',\n `route_name` varchar(64) DEFAULT NULL COMMENT '路由名称',\n `path` varchar(64) DEFAULT NULL COMMENT '路由地址',\n `icon` varchar(32) DEFAULT NULL COMMENT '图标',\n `is_show` tinyint(1) unsigned DEFAULT '2' COMMENT '是否显示(1->不显示|NO,2->显示|YES)',\n `is_cache` tinyint(1) unsigned DEFAULT '1' COMMENT '是否缓存(1->不缓存|NO,2->缓存|YES)',\n `remark` varchar(100) DEFAULT NULL COMMENT '备注',\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='菜单'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "父菜单id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "parent_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "菜单名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "route_name", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "路由名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "route_name" }, { "objectType": "TableField_MYSQL", "name": "path", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "路由地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "path" }, { "objectType": "TableField_MYSQL", "name": "icon", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "图标", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "icon" }, { "objectType": "TableField_MYSQL", "name": "is_show", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否显示(1->不显示|NO,2->显示|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_show" }, { "objectType": "TableField_MYSQL", "name": "is_cache", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否缓存(1->不缓存|NO,2->缓存|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_cache" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_mm_parent_id", "fields": [ "parent_id" ], "referenceSchema": "mldong", "referenceTable": "sys_menu", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "cms_category", "comment": "", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 28, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "cms_category", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2021-01-05 08:56:48", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 27, "updateTime": "", "DDL": "CREATE TABLE `cms_category` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `parent_id` bigint(20) unsigned DEFAULT '0' COMMENT '父栏目id',\n `name` varchar(100) NOT NULL COMMENT '栏目名称',\n `sort` double(10,2) unsigned DEFAULT '10.00' COMMENT '排序',\n `icon` varchar(255) DEFAULT NULL COMMENT '图标',\n `is_nav` tinyint(1) unsigned DEFAULT '2' COMMENT '是否导航(1->否|NO,2->是|YES)',\n `is_show` tinyint(1) unsigned DEFAULT '2' COMMENT '是否显示(1->否|NO,2->是|YES)',\n `is_page` tinyint(1) unsigned DEFAULT '1' COMMENT '是否单页面(1->否|NO,2->是|YES)',\n `dept_id` bigint(20) unsigned DEFAULT NULL COMMENT '所属部门',\n `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '所属用户',\n `model_id` bigint(255) unsigned DEFAULT NULL COMMENT '所属模型',\n `seo_keyworks` varchar(100) DEFAULT NULL COMMENT 'seo关键字',\n `seo_description` varchar(255) DEFAULT NULL COMMENT 'seo描述',\n `ext_form_config` text COMMENT '扩展的表单配置',\n `ext_form_value` varchar(255) DEFAULT NULL COMMENT '扩展表单值',\n `ext_article_form_config` text COMMENT '文章扩展字段配置',\n `content` mediumtext COMMENT '富文本',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "父栏目id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "parent_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "栏目名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "icon", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "图标", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "icon" }, { "objectType": "TableField_MYSQL", "name": "is_nav", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否导航(1->否|NO,2->是|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_nav" }, { "objectType": "TableField_MYSQL", "name": "is_show", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否显示(1->否|NO,2->是|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_show" }, { "objectType": "TableField_MYSQL", "name": "is_page", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否单页面(1->否|NO,2->是|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_page" }, { "objectType": "TableField_MYSQL", "name": "dept_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属部门", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dept_id" }, { "objectType": "TableField_MYSQL", "name": "user_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属用户", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "user_id" }, { "objectType": "TableField_MYSQL", "name": "model_id", "type": "bigint", "length": 255, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "所属模型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "model_id" }, { "objectType": "TableField_MYSQL", "name": "seo_keyworks", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "seo关键字", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "seo_keyworks" }, { "objectType": "TableField_MYSQL", "name": "seo_description", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "seo描述", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "seo_description" }, { "objectType": "TableField_MYSQL", "name": "ext_form_config", "type": "text", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "扩展的表单配置", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ext_form_config" }, { "objectType": "TableField_MYSQL", "name": "ext_form_value", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "扩展表单值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ext_form_value" }, { "objectType": "TableField_MYSQL", "name": "ext_article_form_config", "type": "text", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "文章扩展字段配置", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ext_article_form_config" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "mediumtext", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "富文本", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "content" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_cu_user_id", "fields": [ "user_id" ], "referenceSchema": "mldong", "referenceTable": "sys_user", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_cd_dept_id", "fields": [ "dept_id" ], "referenceSchema": "mldong", "referenceTable": "sys_dept", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_cc_parent_id", "fields": [ "parent_id" ], "referenceSchema": "mldong", "referenceTable": "cms_category", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "OneAndOnlyOneRelationship", "targetCardinality": "ZeroOrManyRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_dict_item", "comment": "字典项", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 12, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_dict_item", "encryption": false, "createOptions": "", "createTime": "2020-06-14 11:43:27", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 11, "updateTime": "2021-01-22 15:28:29", "DDL": "CREATE TABLE `sys_dict_item` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `dict_id` bigint(20) unsigned NOT NULL COMMENT '字典id',\n `name` varchar(32) NOT NULL COMMENT '名称',\n `dict_item_value` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '值',\n `sort` double(10,2) unsigned DEFAULT '10.00' COMMENT '排序',\n `remark` varchar(255) DEFAULT NULL,\n `create_time` datetime(3) NOT NULL COMMENT '创建时间',\n `update_time` datetime(3) NOT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='字典项'", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "dict_id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "字典id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dict_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "dict_item_value", "type": "int", "length": 10, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "dict_item_value" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remark", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remark" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_di_dict_id", "fields": [ "dict_id" ], "referenceSchema": "mldong", "referenceTable": "sys_dict", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "ZeroOrManyRelationship", "targetCardinality": "OneAndOnlyOneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "sys_post", "comment": "岗位", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_general_ci", "autoIncrement": 5, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "Dynamic", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "sys_post", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-10-24 19:02:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 4, "updateTime": "", "DDL": "CREATE TABLE `sys_post` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',\n `name` varchar(100) NOT NULL COMMENT '岗位名称',\n `code` varchar(30) NOT NULL COMMENT '岗位编号',\n `sort` double(10,2) unsigned DEFAULT '10.00' COMMENT '排序',\n `is_enabled` tinyint(1) unsigned DEFAULT '2' COMMENT '是否启用(1->禁用|NO,2->启用|YES)',\n `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',\n `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',\n `is_deleted` tinyint(1) unsigned DEFAULT '1' COMMENT '是否删除(1->未删除|NO,2->已删除|YES)',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "bigint", "length": 20, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "主键", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 100, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 30, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_general_ci", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "岗位编号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "code" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "double", "length": 10, "decimals": 2, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "10.00", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "is_enabled", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "2", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否启用(1->禁用|NO,2->启用|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_enabled" }, { "objectType": "TableField_MYSQL", "name": "create_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_time" }, { "objectType": "TableField_MYSQL", "name": "update_time", "type": "datetime", "length": 3, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_time" }, { "objectType": "TableField_MYSQL", "name": "is_deleted", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": true, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否删除(1->未删除|NO,2->已删除|YES)", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_deleted" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] } ], "views": [] } ] }, "diagrams": [ { "name": "mldong", "paperWidth": 3, "paperHeight": 2, "tableFont": "Arial Unicode MS", "tableFontSize": 14, "isBalckWhite": false, "showDBSchemaName": false, "showViewRelations": true, "notation": "default", "showFieldComment": true, "showTableComment": true, "shapes": [ { "type": "table", "schemaName": "mldong", "tableName": "cms_article", "x": 830, "y": 1120, "width": 460, "height": 391, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "cms_category", "x": 1310, "y": 1090, "width": 490, "height": 451, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_config", "x": 1180, "y": 1960, "width": 450, "height": 260, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_dept", "x": 1590, "y": 1560, "width": 450, "height": 331, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_dict", "x": 2660, "y": 1960, "width": 470, "height": 220, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_dict_item", "x": 2220, "y": 1940, "width": 390, "height": 260, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_menu", "x": 2300, "y": 30, "width": 460, "height": 340, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_notice", "x": 30, "y": 2430, "width": 470, "height": 220, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_post", "x": 1700, "y": 1960, "width": 460, "height": 240, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_request_log", "x": 30, "y": 600, "width": 910, "height": 440, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_role", "x": 1990, "y": 660, "width": 1080, "height": 280, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_role_access", "x": 3110, "y": 700, "width": 410, "height": 200, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_role_dept", "x": 2270, "y": 1650, "width": 480, "height": 200, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_role_menu", "x": 2270, "y": 410, "width": 510, "height": 200, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_upload_config", "x": 30, "y": 1960, "width": 550, "height": 400, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_upload_record", "x": 650, "y": 1960, "width": 460, "height": 300, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_user", "x": 980, "y": 610, "width": 490, "height": 420, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_user_login_times", "x": 1000, "y": 310, "width": 450, "height": 220, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "mldong", "tableName": "sys_user_role", "x": 1500, "y": 700, "width": 450, "height": 200, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } } ], "layers": [], "relations": [ { "name": "fk_di_dict_id", "sourceTableName": "sys_dict_item", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2625, "y": 2070 }, { "x": 2645, "y": 2070 } ], "label": { "x": 2615, "y": 2022, "width": 84, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ur_user_id", "sourceTableName": "sys_user_role", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1485, "y": 800 }, { "x": 1485, "y": 800 } ], "label": { "x": 1403, "y": 752, "width": 92, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ur_role_id", "sourceTableName": "sys_user_role", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1965, "y": 800 }, { "x": 1975, "y": 800 } ], "label": { "x": 1961, "y": 802, "width": 88, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_rm_role_id", "sourceTableName": "sys_role_menu", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2510, "y": 625 }, { "x": 2510, "y": 645 } ], "label": { "x": 2421, "y": 565, "width": 91, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_rm_menu_id", "sourceTableName": "sys_role_menu", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2510, "y": 395 }, { "x": 2510, "y": 385 } ], "label": { "x": 2410, "y": 355, "width": 102, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ra_role_id", "sourceTableName": "sys_role_access", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 3095, "y": 800 }, { "x": 3085, "y": 800 } ], "label": { "x": 3017, "y": 752, "width": 88, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ac_category_id", "sourceTableName": "cms_article", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1305, "y": 1320 }, { "x": 1295, "y": 1320 } ], "label": { "x": 1174, "y": 1272, "width": 121, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_rd_role_id", "sourceTableName": "sys_role_dept", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2510, "y": 1635 }, { "x": 2510, "y": 955 } ], "label": { "x": 2512, "y": 1595, "width": 88, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_rd_dept_id", "sourceTableName": "sys_role_dept", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2255, "y": 1750 }, { "x": 2055, "y": 1750 } ], "label": { "x": 2265, "y": 1702, "width": 92, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ult_user_id", "sourceTableName": "sys_user_login_times", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1220, "y": 545 }, { "x": 1220, "y": 595 } ], "label": { "x": 1128, "y": 485, "width": 94, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_url_user_id", "sourceTableName": "sys_request_log", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 955, "y": 800 }, { "x": 965, "y": 800 } ], "label": { "x": 850, "y": 752, "width": 95, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_au_user_id", "sourceTableName": "cms_article", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1130, "y": 1105 }, { "x": 1130, "y": 1045 } ], "label": { "x": 1037, "y": 1065, "width": 95, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_cu_user_id", "sourceTableName": "cms_category", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1460, "y": 1075 }, { "x": 1460, "y": 1080 }, { "x": 1320, "y": 1080 }, { "x": 1320, "y": 1045 } ], "label": { "x": 1368, "y": 1035, "width": 94, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_cd_dept_id", "sourceTableName": "cms_category", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1815, "y": 1370 }, { "x": 1840, "y": 1370 }, { "x": 1840, "y": 1545 } ], "label": { "x": 1711, "y": 1322, "width": 94, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_ad_dept_id", "sourceTableName": "cms_article", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1080, "y": 1526 }, { "x": 1080, "y": 1750 }, { "x": 1575, "y": 1750 } ], "label": { "x": 1082, "y": 1466, "width": 95, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_mm_parent_id", "sourceTableName": "sys_menu", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2775, "y": 350 }, { "x": 2790, "y": 350 }, { "x": 2790, "y": 410 }, { "x": 2730, "y": 410 }, { "x": 2730, "y": 385 } ], "label": { "x": 2765, "y": 302, "width": 114, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_cc_parent_id", "sourceTableName": "cms_category", "sourceSchemaName": "mldong", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1815, "y": 1520 }, { "x": 1840, "y": 1520 }, { "x": 1840, "y": 1580 }, { "x": 1780, "y": 1580 }, { "x": 1780, "y": 1556 } ], "label": { "x": 1805, "y": 1472, "width": 106, "height": 40, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } } ], "viewRelations": [] } ] }