{ "paper": { "name": "A4", "leftMargin": 0.5, "rightMargin": 0.5, "topMargin": 0.5, "bottomMargin": 0.5, "isPortriat": true }, "modelVersion": 2.01, "defaultSchema": "yxl", "server": { "objectType": "Server_MYSQL", "name": "Default", "serverVersion": 80099, "edition": "Default", "lowerCaseTableNames": 0, "schemas": [ { "objectType": "Schema_MYSQL", "name": "yxl", "tables": [ { "objectType": "Table_MYSQL", "name": "t_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": "t_top_search_keywords", "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": "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": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_vip_level", "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": "year_price", "type": "decimal", "length": 8, "decimals": 2, "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": "year_price" }, { "objectType": "TableField_MYSQL", "name": "month_price", "type": "decimal", "length": 8, "decimals": 2, "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": "month_price" }, { "objectType": "TableField_MYSQL", "name": "sale", "type": "decimal", "length": 8, "decimals": 2, "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": "sale" }, { "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_enable", "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_enable" } ], "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": "t_invite_record", "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": "reward_integral", "type": "int", "length": -2147483648, "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": "reward_integral" } ], "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": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_tweet", "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": "title", "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": "title" }, { "objectType": "TableField_MYSQL", "name": "author", "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": "author" }, { "objectType": "TableField_MYSQL", "name": "cover", "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": "cover" }, { "objectType": "TableField_MYSQL", "name": "brief", "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": "brief" }, { "objectType": "TableField_MYSQL", "name": "content", "type": "text", "length": 0, "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": "content" }, { "objectType": "TableField_MYSQL", "name": "reads", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "阅读数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "reads" }, { "objectType": "TableField_MYSQL", "name": "likes", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "点赞数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "likes" }, { "objectType": "TableField_MYSQL", "name": "collections", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "收藏数", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "collections" }, { "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": "t_vip_level_record", "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": "vip_level_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": "vip_level_id" }, { "objectType": "TableField_MYSQL", "name": "vip_level_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": "vip_level_name" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_vip_level_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "vip_level_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "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": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_vip_level_id", "fields": [ "vip_level_id" ], "referenceSchema": "yxl", "referenceTable": "t_vip_level", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_photo_account_record", "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": "photo_warehouse_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": "photo_warehouse_id" }, { "objectType": "TableField_MYSQL", "name": "is_likes", "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_likes" }, { "objectType": "TableField_MYSQL", "name": "is_collections", "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_collections" }, { "objectType": "TableField_MYSQL", "name": "is_hd_logo_photo", "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": "是否购买高清带logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_hd_logo_photo" }, { "objectType": "TableField_MYSQL", "name": "is_origin_photo", "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_origin_photo" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_photo_warehouse_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidex_account_id_photo_warehouse_id", "type": "UNIQUE", "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": "" }, { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_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": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_photo_warehouse_id_copy_1", "fields": [ "photo_warehouse_id" ], "referenceSchema": "yxl", "referenceTable": "t_photo_warehouse", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_collection_like", "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": "utf8mb4", "collation": "utf8mb4_bin", "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": "channel", "type": "tinyint", "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": "类型（0：幼儿园、1：活动、2：资讯）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "channel" }, { "objectType": "TableField_MYSQL", "name": "type", "type": "tinyint", "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": "类型（0：收藏、1：点赞）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "type" }, { "objectType": "TableField_MYSQL", "name": "object_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": "object_id" } ], "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": "" }, { "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": "t_withdrawal_record", "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": "phonenumber", "type": "varchar", "length": 11, "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": "phonenumber" }, { "objectType": "TableField_MYSQL", "name": "real_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": "real_name" }, { "objectType": "TableField_MYSQL", "name": "transaction_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": "transaction_account_id" }, { "objectType": "TableField_MYSQL", "name": "channels", "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": "channels" }, { "objectType": "TableField_MYSQL", "name": "value", "type": "decimal", "length": 8, "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" }, { "objectType": "TableField_MYSQL", "name": "transaction_id", "type": "varchar", "length": 128, "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": "transaction_id" }, { "objectType": "TableField_MYSQL", "name": "audit_account_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": "审核账号标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_account_id" }, { "objectType": "TableField_MYSQL", "name": "audit_status", "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": "审核状态（1：审核通过、0：未审核、-1:审核失败）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_status" }, { "objectType": "TableField_MYSQL", "name": "audit_date", "type": "datetime", "length": 0, "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": "audit_date" }, { "objectType": "TableField_MYSQL", "name": "audit_msg", "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": "audit_msg" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_ audit_account_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "audit_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": "" }, { "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": [] }, { "objectType": "Table_MYSQL", "name": "t_integral_cash_record", "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": "scene", "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": "scene" }, { "objectType": "TableField_MYSQL", "name": "display_text", "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": "display_text" }, { "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" }, { "objectType": "TableField_MYSQL", "name": "value", "type": "decimal", "length": 8, "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": "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": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_photo_get_like_record", "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": "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": "account_nickname" }, { "objectType": "TableField_MYSQL", "name": "photo_warehouse_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": "photo_warehouse_id" }, { "objectType": "TableField_MYSQL", "name": "origin_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": "origin_account_id" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_photo_warehouse_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_origin_account_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "origin_account_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_account_id_photo_warehouse_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": "photo_warehouse_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_photo_warehouse_id_copy_3", "fields": [ "photo_warehouse_id" ], "referenceSchema": "yxl", "referenceTable": "t_photo_warehouse", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_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": true, "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": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_shopping_car", "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": "photo_warehouse_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": "photo_warehouse_id" }, { "objectType": "TableField_MYSQL", "name": "is_hd_logo_photo", "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": "是否购买高清带logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_hd_logo_photo" }, { "objectType": "TableField_MYSQL", "name": "is_origin_photo", "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_origin_photo" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "NORMAL", "method": "BTREE", "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": "unidx_is_hd_logo_photo", "type": "UNIQUE", "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": "" }, { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "is_hd_logo_photo", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_is_origin_photo", "type": "UNIQUE", "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": "" }, { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_id", "keyLength": 0, "order": "", "oldName": "" }, { "objectType": "IndexField_MYSQL", "name": "is_origin_photo", "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": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_photo_warehouse_id_copy_2", "fields": [ "photo_warehouse_id" ], "referenceSchema": "yxl", "referenceTable": "t_photo_warehouse", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_order_item", "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": "order_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": "order_id" }, { "objectType": "TableField_MYSQL", "name": "photo_warehouse_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": "photo_warehouse_id" }, { "objectType": "TableField_MYSQL", "name": "is_hd_logo_photo", "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": "是否购买高清带logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "is_hd_logo_photo" }, { "objectType": "TableField_MYSQL", "name": "is_origin_photo", "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_origin_photo" }, { "objectType": "TableField_MYSQL", "name": "origin_price", "type": "decimal", "length": 8, "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": "origin_price" }, { "objectType": "TableField_MYSQL", "name": "payable_price", "type": "decimal", "length": 8, "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": "payable_price" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_photo_warehouse_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": true, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "photo_warehouse_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_order_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "order_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": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_photo_warehouse_id", "fields": [ "photo_warehouse_id" ], "referenceSchema": "yxl", "referenceTable": "t_photo_warehouse", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_order_id", "fields": [ "order_id" ], "referenceSchema": "yxl", "referenceTable": "t_order", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_order", "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": "origin_price", "type": "decimal", "length": 8, "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": "origin_price" }, { "objectType": "TableField_MYSQL", "name": "payable_price", "type": "decimal", "length": 8, "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": "payable_price" }, { "objectType": "TableField_MYSQL", "name": "paid_price", "type": "decimal", "length": 8, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "defaultType": "Others", "defaultValue": "0", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "订单实付", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "paid_price" }, { "objectType": "TableField_MYSQL", "name": "pay_channels", "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": "pay_channels" }, { "objectType": "TableField_MYSQL", "name": "state", "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": "state" }, { "objectType": "TableField_MYSQL", "name": "pay_end_time", "type": "datetime", "length": 0, "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": "pay_end_time" }, { "objectType": "TableField_MYSQL", "name": "transaction_id", "type": "varchar", "length": 128, "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": "transaction_id" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_account_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": true, "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": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_operate_sign_in_record", "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": "last_sign_in_date", "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": "last_sign_in_date" }, { "objectType": "TableField_MYSQL", "name": "sign_in_days", "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": "sign_in_days" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_account_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": "" } ] } ], "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": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_photoer_sign_in_record", "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": "kindergarten_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": "kindergarten_id" }, { "objectType": "TableField_MYSQL", "name": "kindergarten_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": "kindergarten_name" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_kindergarten_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "kindergarten_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": "" }, { "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_kindergarten_id_copy_3", "fields": [ "kindergarten_id" ], "referenceSchema": "yxl", "referenceTable": "t_kindergarten", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_kindergarten_info", "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": "kindergarten_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": "kindergarten_id" }, { "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": "real_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": "real_name" }, { "objectType": "TableField_MYSQL", "name": "business_license", "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": "business_license" }, { "objectType": "TableField_MYSQL", "name": "phonenumber", "type": "varchar", "length": 11, "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": "phonenumber" }, { "objectType": "TableField_MYSQL", "name": "id_card_number", "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": "id_card_number" }, { "objectType": "TableField_MYSQL", "name": "id_card_front", "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": "id_card_front" }, { "objectType": "TableField_MYSQL", "name": "id_card_back", "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": "id_card_back" }, { "objectType": "TableField_MYSQL", "name": "body_photo", "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": "body_photo" }, { "objectType": "TableField_MYSQL", "name": "email", "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": "email" }, { "objectType": "TableField_MYSQL", "name": "audit_account_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": "审核账号标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_account_id" }, { "objectType": "TableField_MYSQL", "name": "audit_status", "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": "审核状态（1：审核通过、0：未审核、-1:审核失败）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_status" }, { "objectType": "TableField_MYSQL", "name": "audit_date", "type": "datetime", "length": 0, "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": "audit_date" }, { "objectType": "TableField_MYSQL", "name": "audit_msg", "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": "audit_msg" } ], "indexes": [ { "objectType": "Index_MYSQL", "name": "idx_kindergarten_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "kindergarten_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "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": "" }, { "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_kindergarten_id_copy_2", "fields": [ "kindergarten_id" ], "referenceSchema": "yxl", "referenceTable": "t_kindergarten", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_banner", "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": "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" }, { "objectType": "TableField_MYSQL", "name": "img_url", "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": "img_url" }, { "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": "params", "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": "params" }, { "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": "t_kindergarten", "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": "brief", "type": "varchar", "length": 255, "decimals": -2147483648, "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": "brief" }, { "objectType": "TableField_MYSQL", "name": "phonenumber", "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": "phonenumber" }, { "objectType": "TableField_MYSQL", "name": "logo", "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": "幼儿园logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "logo" }, { "objectType": "TableField_MYSQL", "name": "preview_logo", "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": "幼儿园预览图logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "preview_logo" }, { "objectType": "TableField_MYSQL", "name": "hd_logo", "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": "幼儿园高清图logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo" }, { "objectType": "TableField_MYSQL", "name": "cover", "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": "cover" }, { "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": "province", "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": "province" }, { "objectType": "TableField_MYSQL", "name": "city", "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": "city" }, { "objectType": "TableField_MYSQL", "name": "area", "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": "area" }, { "objectType": "TableField_MYSQL", "name": "address", "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": "address" }, { "objectType": "TableField_MYSQL", "name": "lng", "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": "lng" }, { "objectType": "TableField_MYSQL", "name": "lat", "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": "lat" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "int", "length": -2147483648, "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": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_activity", "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": "kindergarten_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": "kindergarten_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": "brief", "type": "varchar", "length": 255, "decimals": -2147483648, "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": "brief" }, { "objectType": "TableField_MYSQL", "name": "cover", "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": "cover" }, { "objectType": "TableField_MYSQL", "name": "event_start_date", "type": "datetime", "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": "event_start_date" }, { "objectType": "TableField_MYSQL", "name": "event_end_date", "type": "datetime", "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": "event_end_date" }, { "objectType": "TableField_MYSQL", "name": "preview_logo", "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": "幼儿园预览图logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "preview_logo" }, { "objectType": "TableField_MYSQL", "name": "hd_logo", "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": "幼儿园高清图logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo" }, { "objectType": "TableField_MYSQL", "name": "sort", "type": "int", "length": -2147483648, "decimals": 0, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": true, "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": true, "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_kindergarten_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "kindergarten_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": "" }, { "objectType": "IndexField_MYSQL", "name": "", "keyLength": 0, "order": "", "oldName": "" } ], "oldName": "", "indexMethod": "BTREE", "comment": "" }, "foreignKeys": [ { "objectType": "ForeignKey_MYSQL", "name": "fk_kindergarten_id", "fields": [ "kindergarten_id" ], "referenceSchema": "yxl", "referenceTable": "t_kindergarten", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_photo_warehouse", "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": "kindergarten_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": "kindergarten_id" }, { "objectType": "TableField_MYSQL", "name": "activity_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": "活动标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "activity_id" }, { "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": "origin_filename", "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": "origin_filename" }, { "objectType": "TableField_MYSQL", "name": "photo_time", "type": "datetime", "length": 0, "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": "photo_time" }, { "objectType": "TableField_MYSQL", "name": "is_horizontal", "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": "is_horizontal" }, { "objectType": "TableField_MYSQL", "name": "list_preview", "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": "list_preview" }, { "objectType": "TableField_MYSQL", "name": "detail_preview", "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": "detail_preview" }, { "objectType": "TableField_MYSQL", "name": "hd_logo_photo_size", "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": "高清带logo大小", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo_photo_size" }, { "objectType": "TableField_MYSQL", "name": "hd_logo_photo_origin_price", "type": "decimal", "length": 8, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "高清带logo原价格", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo_photo_origin_price" }, { "objectType": "TableField_MYSQL", "name": "hd_logo_photo_price", "type": "decimal", "length": 8, "decimals": 2, "isUnsigned": false, "isZeroFill": false, "setEnumValues": "", "isBinary": false, "charset": "", "collation": "", "isNullable": false, "defaultType": "Others", "defaultValue": "", "isOnUpdateCurrentTimestamp": false, "isAutoInc": false, "comment": "高清带logo价格", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo_photo_price" }, { "objectType": "TableField_MYSQL", "name": "hd_logo_photo_pixel", "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": "高清带logo像素", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo_photo_pixel" }, { "objectType": "TableField_MYSQL", "name": "hd_logo_photo", "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": "高清带logo", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "hd_logo_photo" }, { "objectType": "TableField_MYSQL", "name": "origin_photo_size", "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": "origin_photo_size" }, { "objectType": "TableField_MYSQL", "name": "origin_photo_origin_price", "type": "decimal", "length": 8, "decimals": 2, "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": "origin_photo_origin_price" }, { "objectType": "TableField_MYSQL", "name": "origin_photo_price", "type": "decimal", "length": 8, "decimals": 2, "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": "origin_photo_price" }, { "objectType": "TableField_MYSQL", "name": "origin_photo_pixel", "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": "origin_photo_pixel" }, { "objectType": "TableField_MYSQL", "name": "origin_photo", "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": "origin_photo" }, { "objectType": "TableField_MYSQL", "name": "likes", "type": "int", "length": -2147483648, "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": "likes" }, { "objectType": "TableField_MYSQL", "name": "collections", "type": "int", "length": -2147483648, "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": "collections" }, { "objectType": "TableField_MYSQL", "name": "is_take", "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_take" }, { "objectType": "TableField_MYSQL", "name": "is_beautiful", "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_beautiful" }, { "objectType": "TableField_MYSQL", "name": "is_ready", "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_ready" }, { "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" }, { "objectType": "TableField_MYSQL", "name": "audit_status", "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": "审核状态（1：审核通过、0：未审核、-1:审核失败）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_status" }, { "objectType": "TableField_MYSQL", "name": "audit_date", "type": "datetime", "length": 0, "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": "audit_date" }, { "objectType": "TableField_MYSQL", "name": "audit_msg", "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": "audit_msg" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_kindergarten_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "kindergarten_id", "keyLength": 0, "order": "", "oldName": "" } ] }, { "objectType": "Index_MYSQL", "name": "idx_activity_id", "type": "NORMAL", "method": "BTREE", "comment": "", "oldName": "", "online": false, "keyBlockSize": 0, "parser": "", "algorithm": "", "lock": "", "collation": "", "cardinality": "", "packed": "", "fields": [ { "objectType": "IndexField_MYSQL", "name": "activity_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": "" }, { "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": "" }, { "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_kindergarten_id_copy_1", "fields": [ "kindergarten_id" ], "referenceSchema": "yxl", "referenceTable": "t_kindergarten", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" }, { "objectType": "ForeignKey_MYSQL", "name": "fk_activity_id", "fields": [ "activity_id" ], "referenceSchema": "yxl", "referenceTable": "t_activity", "referenceFields": [ "id" ], "onDelete": "", "onUpdate": "", "sourceCardinality": "NoneRelationship", "targetCardinality": "NoneRelationship", "oldName": "" } ], "triggers": [], "tablePartitions": [] }, { "objectType": "Table_MYSQL", "name": "t_photoer_audit", "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": "real_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": "real_name" }, { "objectType": "TableField_MYSQL", "name": "phonenumber", "type": "varchar", "length": 11, "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": "phonenumber" }, { "objectType": "TableField_MYSQL", "name": "bank_card_number", "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": "bank_card_number" }, { "objectType": "TableField_MYSQL", "name": "id_card_number", "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": "id_card_number" }, { "objectType": "TableField_MYSQL", "name": "id_card_front", "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": "id_card_front" }, { "objectType": "TableField_MYSQL", "name": "id_card_back", "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": "id_card_back" }, { "objectType": "TableField_MYSQL", "name": "body_photo", "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": "body_photo" }, { "objectType": "TableField_MYSQL", "name": "email", "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": "email" }, { "objectType": "TableField_MYSQL", "name": "camera_model", "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": "camera_model" }, { "objectType": "TableField_MYSQL", "name": "cooperation_scenario", "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": "cooperation_scenario" }, { "objectType": "TableField_MYSQL", "name": "shooting_days_per_month", "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": "shooting_days_per_month" }, { "objectType": "TableField_MYSQL", "name": "possible_shooting_time", "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": "possible_shooting_time" }, { "objectType": "TableField_MYSQL", "name": "personal_shooting_experience", "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": "personal_shooting_experience" }, { "objectType": "TableField_MYSQL", "name": "sample_reels", "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": "sample_reels" }, { "objectType": "TableField_MYSQL", "name": "audit_account_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": "审核账号标识", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_account_id" }, { "objectType": "TableField_MYSQL", "name": "audit_status", "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": "审核状态（1：审核通过、0：未审核、-1:审核失败）", "columnFormat": "", "storage": "", "isVirtual": false, "isGeneratedAlways": false, "virtualExpr": "", "virtualType": "", "oldName": "audit_status" }, { "objectType": "TableField_MYSQL", "name": "audit_date", "type": "datetime", "length": 0, "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": "audit_date" }, { "objectType": "TableField_MYSQL", "name": "audit_msg", "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": "audit_msg" } ], "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": "" } ] }, { "objectType": "Index_MYSQL", "name": "unidx_account_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": "" } ] } ], "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": "" }, { "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": [] }, { "objectType": "Schema_MYSQL", "name": "", "tables": [], "views": [] } ] }, "diagrams": [ { "name": "yxl", "paperWidth": 3, "paperHeight": 2, "tableFont": "Arial Unicode MS", "tableFontSize": 14, "isBalckWhite": true, "showDBSchemaName": true, "showViewRelations": true, "notation": "default", "showFieldComment": true, "showTableComment": true, "shapes": [ { "type": "table", "schemaName": "yxl", "tableName": "t_demo", "x": 1390, "y": 2220, "width": 243, "height": 177, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_banner", "x": 1430, "y": 1550, "width": 243, "height": 345, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_tweet", "x": 1110, "y": 1550, "width": 243, "height": 408, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_kindergarten", "x": 510, "y": 580, "width": 314, "height": 534, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_kindergarten_info", "x": 20, "y": 600, "width": 471, "height": 492, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_activity", "x": 510, "y": 140, "width": 314, "height": 408, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_vip_level", "x": 1070, "y": 2180, "width": 245, "height": 324, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_vip_level_record", "x": 720, "y": 2210, "width": 297, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_top_search_keywords", "x": 30, "y": 2220, "width": 243, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_photoer_audit", "x": 30, "y": 1550, "width": 471, "height": 597, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_photoer_sign_in_record", "x": 510, "y": 1160, "width": 305, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_operate_sign_in_record", "x": 340, "y": 2220, "width": 305, "height": 261, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_integral_cash_record", "x": 1740, "y": 1550, "width": 275, "height": 303, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_photo_warehouse", "x": 1210, "y": 410, "width": 471, "height": 765, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_photo_account_record", "x": 1280, "y": 30, "width": 327, "height": 324, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_shopping_car", "x": 840, "y": 900, "width": 327, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_order", "x": 2160, "y": 610, "width": 396, "height": 366, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_photo_get_like_record", "x": 1290, "y": 1210, "width": 313, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_order_item", "x": 1790, "y": 660, "width": 327, "height": 324, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_withdrawal_record", "x": 570, "y": 1550, "width": 471, "height": 429, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } }, { "type": "table", "schemaName": "yxl", "tableName": "t_collection_like", "x": 2080, "y": 1550, "width": 389, "height": 282, "isBold": false, "titleColor": { "r": 55, "g": 131, "b": 192, "a": 1 } } ], "layers": [], "relations": [ { "name": "fk_kindergarten_id_copy_2", "sourceTableName": "t_kindergarten_info", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 506, "y": 850 }, { "x": 495, "y": 850 } ], "label": { "x": 374, "y": 811, "width": 122, "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_kindergarten_id", "sourceTableName": "t_activity", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 660, "y": 563 }, { "x": 660, "y": 565 } ], "label": { "x": 540, "y": 512, "width": 122, "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_kindergarten_id_copy_3", "sourceTableName": "t_photoer_sign_in_record", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 660, "y": 1145 }, { "x": 660, "y": 1129 } ], "label": { "x": 668, "y": 1124, "width": 122, "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_vip_level_id", "sourceTableName": "t_vip_level_record", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1032, "y": 2340 }, { "x": 1055, "y": 2340 } ], "label": { "x": 924, "y": 2301, "width": 98, "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_kindergarten_id_copy_1", "sourceTableName": "t_photo_warehouse", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1195, "y": 790 }, { "x": 839, "y": 790 } ], "label": { "x": 1032, "y": 751, "width": 173, "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_activity_id", "sourceTableName": "t_photo_warehouse", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1195, "y": 540 }, { "x": 1160, "y": 540 }, { "x": 1160, "y": 350 }, { "x": 839, "y": 350 } ], "label": { "x": 1118, "y": 501, "width": 87, "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_photo_warehouse_id_copy_2", "sourceTableName": "t_shopping_car", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1182, "y": 1040 }, { "x": 1195, "y": 1040 } ], "label": { "x": 1172, "y": 1001, "width": 155, "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_photo_warehouse_id_copy_3", "sourceTableName": "t_photo_get_like_record", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1480, "y": 1195 }, { "x": 1480, "y": 1190 } ], "label": { "x": 1488, "y": 1174, "width": 206, "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_photo_warehouse_id", "sourceTableName": "t_order_item", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1775, "y": 790 }, { "x": 1696, "y": 790 } ], "label": { "x": 1630, "y": 751, "width": 155, "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_order_id", "sourceTableName": "t_order_item", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 2132, "y": 790 }, { "x": 2145, "y": 790 } ], "label": { "x": 2045, "y": 751, "width": 77, "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_photo_warehouse_id_copy_1", "sourceTableName": "t_photo_account_record", "sourceSchemaName": "yxl", "lineWidth": 1, "visible": true, "vertices": [ { "x": 1480, "y": 369 }, { "x": 1480, "y": 395 } ], "label": { "x": 1488, "y": 328, "width": 155, "height": 31, "fontName": "Arial Unicode MS", "fontSize": 14, "fontColor": { "r": 51, "g": 51, "b": 51, "a": 1 }, "isFontBold": false, "isFontItalic": false, "isVisible": false } } ], "viewRelations": [] } ] }