{ "paper": { "name": "A4", "leftMargin": 0.5, "rightMargin": 0.5, "topMargin": 0.5, "bottomMargin": 0.5, "isPortriat": true }, "modelVersion": 2.01, "defaultSchema": "", "server": { "objectType": "Server_MYSQL", "name": "Default", "serverVersion": 50799, "edition": "Default", "lowerCaseTableNames": 0, "schemas": [ { "objectType": "Schema_MYSQL", "name": "", "tables": [ { "objectType": "Table_MYSQL", "name": "plt_framework_role", "comment": "角色表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 64, "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": "code" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_demo", "comment": "", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_dict_entry", "comment": "字典实体", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "dict_id", "type": "varchar", "length": 64, "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": "dict_id" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 64, "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": "code" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "value", "type": "varchar", "length": 64, "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": "value" }, { "objectType": "TableField_MYSQL", "name": "attr", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "扩展参数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "attr" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_dict_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "dict_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_dict_id", "fields": [ "dict_id" ], "referenceSchema": "", "referenceTable": "plt_framework_dict", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_dict", "comment": "字典父类", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 64, "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": "code" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_address", "comment": "地址信息", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "varchar", "length": 64, "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": "parent_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "area_code", "type": "varchar", "length": 64, "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": "area_code" }, { "objectType": "TableField_MYSQL", "name": "type", "type": "varchar", "length": 64, "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": "type" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_dept", "comment": "部门表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "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": "", "collation": "", "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": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_tenant", "comment": "租户", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "manager_id", "type": "varchar", "length": 64, "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": "manager_id" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_account", "comment": "账号基础主表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "nickname", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "昵称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "nickname" }, { "objectType": "TableField_MYSQL", "name": "realname", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "真实姓名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "realname" }, { "objectType": "TableField_MYSQL", "name": "avatar_url", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "头像图片URL", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "avatar_url" }, { "objectType": "TableField_MYSQL", "name": "gender", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "用户性别（0未知、1男性、2女性）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "gender" }, { "objectType": "TableField_MYSQL", "name": "type", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "类型：1:平台、2:租户管理员、3:普通账号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "type" }, { "objectType": "TableField_MYSQL", "name": "password_failure_date_time", "type": "datetime", "length": 0, "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": "password_failure_date_time" }, { "objectType": "TableField_MYSQL", "name": "end_date_time", "type": "datetime", "length": 0, "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": "end_date_time" }, { "objectType": "TableField_MYSQL", "name": "is_locked", "type": "tinyint", "length": 1, "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": "is_locked" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_resources", "comment": "资源表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "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": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "name" }, { "objectType": "TableField_MYSQL", "name": "component_name", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "组件名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "component_name" }, { "objectType": "TableField_MYSQL", "name": "component_path", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "组件路径", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "component_path" }, { "objectType": "TableField_MYSQL", "name": "path", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "路由路径", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "path" }, { "objectType": "TableField_MYSQL", "name": "resource_type", "type": "varchar", "length": 32, "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": "resource_type" }, { "objectType": "TableField_MYSQL", "name": "permission", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "权限字符串", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "permission" }, { "objectType": "TableField_MYSQL", "name": "icon", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "菜单图标", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "icon" }, { "objectType": "TableField_MYSQL", "name": "cache", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "缓存", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "cache" }, { "objectType": "TableField_MYSQL", "name": "hidden", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否隐藏", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hidden" }, { "objectType": "TableField_MYSQL", "name": "link", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "外链菜单", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "link" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_operation_log", "comment": "操作日志实体", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "username", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "操作用户", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "username" }, { "objectType": "TableField_MYSQL", "name": "type", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "日志类型", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "type" }, { "objectType": "TableField_MYSQL", "name": "ip", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "操作ip", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ip" }, { "objectType": "TableField_MYSQL", "name": "ip_address", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "操作ip地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "ip_address" }, { "objectType": "TableField_MYSQL", "name": "os", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "操作系统", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "os" }, { "objectType": "TableField_MYSQL", "name": "browser", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "浏览器", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "browser" }, { "objectType": "TableField_MYSQL", "name": "browser_version", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "浏览器版本号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "browser_version" }, { "objectType": "TableField_MYSQL", "name": "request_url", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "request_url" }, { "objectType": "TableField_MYSQL", "name": "class_name", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "类路径", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "class_name" }, { "objectType": "TableField_MYSQL", "name": "method", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "方法名", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "method" }, { "objectType": "TableField_MYSQL", "name": "request", "type": "text", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求参数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "request" }, { "objectType": "TableField_MYSQL", "name": "time", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "请求耗时", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "time" }, { "objectType": "TableField_MYSQL", "name": "exception_detail", "type": "text", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "异常详细", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "exception_detail" }, { "objectType": "TableField_MYSQL", "name": "remarks", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "备注", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "remarks" }, { "objectType": "TableField_MYSQL", "name": "log_from", "type": "varchar", "length": 32, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "错误来源（1后端、2前端）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "log_from" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "os", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_role_resources", "comment": "角色与资源关联表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "int", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "resources_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "resources_id" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_role_id", "type": "", "method": "", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_resources_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "resources_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_role_id_resources_id", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "resources_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_role_id", "fields": [ "role_id" ], "referenceSchema": "", "referenceTable": "plt_framework_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_resources_id", "fields": [ "resources_id" ], "referenceSchema": "", "referenceTable": "plt_framework_resources", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_account_dept", "comment": "角色与部门关联表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "int", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "account_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "account_id" }, { "objectType": "TableField_MYSQL", "name": "dept_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "", "method": "", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_dept_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "dept_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_account_id_dept_id", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "dept_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "pk_account_id_copy_1", "fields": [ "account_id" ], "referenceSchema": "", "referenceTable": "plt_framework_account", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "pk_dept_id", "fields": [ "dept_id" ], "referenceSchema": "", "referenceTable": "plt_framework_dept", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_role_dept", "comment": "角色与部门关联表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "int", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_role_id", "type": "", "method": "", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_dept_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "dept_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_role_id_dept_id", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "dept_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_role_id_copy_1", "fields": [ "role_id" ], "referenceSchema": "", "referenceTable": "plt_framework_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_dept_id", "fields": [ "dept_id" ], "referenceSchema": "", "referenceTable": "plt_framework_dept", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_help_content", "comment": "帮助内容", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "help_group_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "help_group_id" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "text", "length": 512, "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": "content" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "int", "length": 12, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "is_show", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "显示/隐藏", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_show" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_help_group_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "help_group_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_help_group_id", "fields": [ "help_group_id" ], "referenceSchema": "", "referenceTable": "plt_framework_help_group", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_help_group", "comment": "帮助分类", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "parent_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "-1", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "父级id", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "parent_id" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "int", "length": 12, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "排序（倒序）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "sort" }, { "objectType": "TableField_MYSQL", "name": "is_show", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "显示/隐藏", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_show" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_invite", "comment": "邀请拉新记录", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "account_id", "type": "varchar", "length": 64, "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": "account_id" }, { "objectType": "TableField_MYSQL", "name": "invite_account_id", "type": "varchar", "length": 64, "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": "invite_account_id" }, { "objectType": "TableField_MYSQL", "name": "invite_account_nickname", "type": "varchar", "length": 64, "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": "invite_account_nickname" }, { "objectType": "TableField_MYSQL", "name": "is_reward", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否奖励", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_reward" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "idx_account_id", "fields": [ "account_id" ], "referenceSchema": "", "referenceTable": "plt_framework_account", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_feedback", "comment": "问题反馈", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "account_id", "type": "varchar", "length": 64, "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": "account_id" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "text", "length": -2147483648, "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": "content" }, { "objectType": "TableField_MYSQL", "name": "img_url", "type": "text", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "反馈图片地址（可多个）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "img_url" } ], "indexes": [], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_account_auths", "comment": "账号授权表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "account_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "account_id" }, { "objectType": "TableField_MYSQL", "name": "identity_type", "type": "varchar", "length": 64, "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": "identity_type" }, { "objectType": "TableField_MYSQL", "name": "identifier", "type": "varchar", "length": 255, "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": "identifier" }, { "objectType": "TableField_MYSQL", "name": "credential", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "凭证（站内的保存密码，站外的不保存或保存token）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "credential" }, { "objectType": "TableField_MYSQL", "name": "salt", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "盐值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "salt" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_identity_type_identifier", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "identity_type", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "identifier", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "pk_account_id", "fields": [ "account_id" ], "referenceSchema": "", "referenceTable": "plt_framework_account", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_business_config", "comment": "业务配置", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "code", "type": "varchar", "length": 64, "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": "code" }, { "objectType": "TableField_MYSQL", "name": "name", "type": "varchar", "length": 64, "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": "name" }, { "objectType": "TableField_MYSQL", "name": "value", "type": "varchar", "length": 64, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "值", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "value" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "unidx_key", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "code", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_account_role", "comment": "账号与角色关联表", "engine": "", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "", "createTime": "", "checkTime": "", "dataFree": 0, "dataLength": 0, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar(64)", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": true, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 0, "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_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "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": "is_del" }, { "objectType": "TableField_MYSQL", "name": "account_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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": "account_id" }, { "objectType": "TableField_MYSQL", "name": "role_id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "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" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_role_id", "type": "", "method": "", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_account_id_role_id", "type": "UNIQUE", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "account_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "role_id", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "pk_account_id_copy_2", "fields": [ "account_id" ], "referenceSchema": "", "referenceTable": "plt_framework_account", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "pk_role_id", "fields": [ "role_id" ], "referenceSchema": "", "referenceTable": "plt_framework_role", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "plt_framework_app", "comment": "App自更新", "engine": "InnoDB", "characterSet": "utf8mb4", "collation": "utf8mb4_bin", "autoIncrement": 0, "tablespace": "", "storage": "", "insertMethod": "", "connection": "", "checksum": false, "rowFormat": "DYNAMIC", "avgRowLength": 0, "maxRows": 0, "minRows": 0, "keyBlockSize": 0, "packKeys": "", "delayKeyWrite": false, "dataDirectory": "", "indexDirectory": "", "statsAutoRecalc": "", "statsPersistent": "", "statsSamplePages": 0, "union": "", "pageCheckSum": false, "transactional": false, "compression": "", "oldName": "", "encryption": false, "createOptions": "row_format=DYNAMIC", "createTime": "2020-05-17 14:33:50", "checkTime": "", "dataFree": 0, "dataLength": 16384, "indexLength": 0, "maxDataLength": 0, "rows": 0, "updateTime": "", "DDL": "", "partitionBy": "", "partitionByExpr": "", "partitions": 0, "partitionKeyAlgorithm": "", "subPartitionBy": "", "subPartitionByExpr": "", "subPartitions": 0, "subPartitionKeyAlgorithm": "", "fields": [ { "objectType": "TableField_MYSQL", "name": "id", "type": "varchar", "length": 64, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "id" }, { "objectType": "TableField_MYSQL", "name": "create_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_by" }, { "objectType": "TableField_MYSQL", "name": "create_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "创建时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "create_at" }, { "objectType": "TableField_MYSQL", "name": "update_by", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新人", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_by" }, { "objectType": "TableField_MYSQL", "name": "update_at", "type": "datetime", "length": 6, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "更新时间", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "update_at" }, { "objectType": "TableField_MYSQL", "name": "is_del", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Null", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "软删除", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_del" }, { "objectType": "TableField_MYSQL", "name": "product_name", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "产品名称", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "product_name" }, { "objectType": "TableField_MYSQL", "name": "platform", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "平台", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "platform" }, { "objectType": "TableField_MYSQL", "name": "version_code", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "版本编码", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "version_code" }, { "objectType": "TableField_MYSQL", "name": "version_number", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "版本号", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "version_number" }, { "objectType": "TableField_MYSQL", "name": "is_show", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否有效", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_show" }, { "objectType": "TableField_MYSQL", "name": "is_force_upgrade", "type": "tinyint", "length": 1, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "是否强制更新", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_force_upgrade" }, { "objectType": "TableField_MYSQL", "name": "upgrade_desc", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "升级描述", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "upgrade_desc" }, { "objectType": "TableField_MYSQL", "name": "download_url", "type": "varchar", "length": 255, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "utf8mb4", "collation": "utf8mb4_bin", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "下载地址", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "download_url" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_product_name_platform", "type": "NORMAL", "method": "", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "product_name", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "platform", "keyLength": 0, "order": "", "oldName": "" } ] } ], "primaryKey": { "objectType": "PrimaryKey_MYSQL", "name": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "id", "keyLength": 0, "order": "", "oldName": "id" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] } ], "views": [] } ] }, "diagrams": [ { "name": "nx-uiac", "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": "", "tableName": "plt_framework_operation_log", "x": 1950, "y": 30, "width": 335, "height": 513, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_account", "x": 650, "y": 370, "width": 388, "height": 366, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_account_auths", "x": 40, "y": 370, "width": 568, "height": 303, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_account_role", "x": 1580, "y": 430, "width": 243, "height": 240, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_dept", "x": 1010, "y": 790, "width": 243, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_resources", "x": 1520, "y": 1410, "width": 374, "height": 471, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_role", "x": 1580, "y": 790, "width": 243, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_role_resources", "x": 1580, "y": 1120, "width": 245, "height": 240, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_account_dept", "x": 720, "y": 780, "width": 243, "height": 240, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_demo", "x": 690, "y": 2390, "width": 243, "height": 177, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_address", "x": 1000, "y": 1950, "width": 247, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_dict", "x": 680, "y": 2000, "width": 243, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_dict_entry", "x": 390, "y": 1960, "width": 243, "height": 345, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_tenant", "x": 1310, "y": 1950, "width": 289, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_role_dept", "x": 1290, "y": 780, "width": 243, "height": 240, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_feedback", "x": 1670, "y": 1950, "width": 271, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_help_group", "x": 380, "y": 2370, "width": 243, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_help_content", "x": 40, "y": 2360, "width": 275, "height": 303, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_invite", "x": 670, "y": 40, "width": 348, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_business_config", "x": 2010, "y": 1950, "width": 243, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "", "tableName": "plt_framework_app", "x": 30, "y": 1950, "width": 291, "height": 366, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } } ], "layers": [], "relations": [ { "name": "fk_role_id", "sourceTableName": "plt_framework_role_resources", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1700, "y": 1105 }, { "x": 1700, "y": 1087 } ], "label": { "x": 1637, "y": 1125, "width": 68, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_resources_id", "sourceTableName": "plt_framework_role_resources", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1700, "y": 1375 }, { "x": 1700, "y": 1395 } ], "label": { "x": 1596, "y": 1324, "width": 106, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "pk_account_id_copy_2", "sourceTableName": "plt_framework_account_role", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1565, "y": 550 }, { "x": 1053, "y": 550 } ], "label": { "x": 1479, "y": 568, "width": 97, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "pk_role_id", "sourceTableName": "plt_framework_account_role", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1700, "y": 685 }, { "x": 1700, "y": 775 } ], "label": { "x": 1698, "y": 633, "width": 72, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "pk_account_id", "sourceTableName": "plt_framework_account_auths", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 623, "y": 550 }, { "x": 635, "y": 550 } ], "label": { "x": 566, "y": 551, "width": 97, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "pk_account_id_copy_1", "sourceTableName": "plt_framework_account_dept", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 840, "y": 765 }, { "x": 840, "y": 751 } ], "label": { "x": 745, "y": 734, "width": 97, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "pk_dept_id", "sourceTableName": "plt_framework_account_dept", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 978, "y": 900 }, { "x": 995, "y": 900 } ], "label": { "x": 890, "y": 909, "width": 75, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_dict_id", "sourceTableName": "plt_framework_dict_entry", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 648, "y": 2130 }, { "x": 665, "y": 2130 } ], "label": { "x": 644, "y": 2101, "width": 66, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_role_id_copy_1", "sourceTableName": "plt_framework_role_dept", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1548, "y": 900 }, { "x": 1565, "y": 900 } ], "label": { "x": 1470, "y": 861, "width": 68, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_dept_id", "sourceTableName": "plt_framework_role_dept", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1275, "y": 900 }, { "x": 1268, "y": 900 } ], "label": { "x": 1213, "y": 861, "width": 72, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "fk_help_group_id", "sourceTableName": "plt_framework_help_content", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 330, "y": 2510 }, { "x": 365, "y": 2510 } ], "label": { "x": 320, "y": 2471, "width": 114, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } }, { "name": "idx_account_id", "sourceTableName": "plt_framework_invite", "sourceSchemaName": "", "lineWidth": 1, "visible": true, "vertices": [ { "x": 840, "y": 337 }, { "x": 840, "y": 355 } ], "label": { "x": 742, "y": 286, "width": 100, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } } ], "viewRelations": [] } ] }