代码拉取完成，页面将自动刷新
{
"paper": {
"name": "A4",
"leftMargin": 0.5,
"rightMargin": 0.5,
"topMargin": 0.5,
"bottomMargin": 0.5,
"isPortriat": true
},
"modelVersion": 2.01,
"defaultSchema": "Default",
"server": {
"objectType": "Server_MYSQL",
"name": "Default",
"serverVersion": 50799,
"edition": "Default",
"lowerCaseTableNames": 0,
"schemas": [
{
"objectType": "Schema_MYSQL",
"name": "Default",
"tables": [
{
"objectType": "Table_MYSQL",
"name": "boying_category",
"comment": "目录表,可标识是演唱会,还是相声表演等类型",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "category",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:25",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `category` (\n `category_id` int(11) NOT NULL AUTO_INCREMENT,\n `parent_id` int(11) NOT NULL COMMENT '上级分类的编号：0表示一级分类',\n `name` varchar(64) NOT NULL,\n `level` int(11) DEFAULT NULL COMMENT '分类级别',\n `weight` int(11) NOT NULL COMMENT '用于排序,0则不显示',\n `icon` varchar(64) DEFAULT NULL COMMENT '该目录的图标',\n `description` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`category_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='目录表,可标识是演唱会,还是相声表演等类型,一共有两级目录'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "目录名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "icon",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "该目录的图标",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "icon"
},
{
"objectType": "TableField_MYSQL",
"name": "description",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "目录描述",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "description"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用于排序,0则不显示",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "weight"
},
{
"objectType": "TableField_MYSQL",
"name": "admin_delete",
"type": "tinyint",
"length": 1,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "管理员是否删除了该目录,默认为0，即未删除状态",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "admin_delete"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "category_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_show",
"comment": "演唱会信息表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "show",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:36",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `show` (\n `show_id` int(11) NOT NULL AUTO_INCREMENT,\n `name` varchar(64) NOT NULL,\n `category_id` int(11) NOT NULL COMMENT '所属的目录',\n `poster` varchar(64) DEFAULT NULL COMMENT '该演唱会的海报信息',\n `details` blob COMMENT '存储该演唱会等的图文信息',\n `min_price` decimal(10,2) DEFAULT NULL COMMENT '该演唱会的最低价',\n PRIMARY KEY (`show_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='演唱会信息表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "category_id",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "category_id"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "poster",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "该演唱会的海报信息",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "poster"
},
{
"objectType": "TableField_MYSQL",
"name": "details",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "存储该演唱会等的图文信息",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "details"
},
{
"objectType": "TableField_MYSQL",
"name": "city",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "演出所在城市",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "city"
},
{
"objectType": "TableField_MYSQL",
"name": "address",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "具体演出地址",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "address"
},
{
"objectType": "TableField_MYSQL",
"name": "start_time",
"type": "timestamp",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "演出开始时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "start_time"
},
{
"objectType": "TableField_MYSQL",
"name": "end_time",
"type": "timestamp",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "演出结束时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "end_time"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "该演出展示的优先基本,0为不展示",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "weight"
},
{
"objectType": "TableField_MYSQL",
"name": "min_price",
"type": "double",
"length": -2147483648,
"decimals": -2147483648,
"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": "min_price"
},
{
"objectType": "TableField_MYSQL",
"name": "max_price",
"type": "double",
"length": -2147483648,
"decimals": -2147483648,
"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": "max_price"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "show_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_seat",
"comment": "对于某个演唱会的容量信息表.包括每个级别的容量,价格,库存等",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "class",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:26",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `class` (\n `class_id` int(11) NOT NULL AUTO_INCREMENT,\n `showSessionId` int(11) NOT NULL,\n `grade` int(11) NOT NULL COMMENT '所属哪个级别,例如A等座,B等座',\n `capacity` int(11) NOT NULL COMMENT '该级别座位的容量',\n `price` decimal(10,2) NOT NULL COMMENT '该级别座位的定价',\n PRIMARY KEY (`class_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='对于某个演唱会的某个场次的座位级别信息表.包括每个级别的容量,价格等'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "show_id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "所属演出Id",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "show_id"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "所属哪个级别,例如\"A等票“，”B等票“",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "price",
"type": "double",
"length": 10,
"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": "price"
},
{
"objectType": "TableField_MYSQL",
"name": "capacity",
"type": "int",
"length": 11,
"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": "capacity"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "class_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_stock",
"comment": "演出座次对应的库存",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "",
"createTime": "",
"checkTime": "",
"dataFree": 0,
"dataLength": 0,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "stock",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"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": "stock"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": -2147483648,
"order": "",
"oldName": ""
}
],
"oldName": "",
"indexMethod": "",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_order",
"comment": "用户订单表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "order",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:29",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `order` (\n `order_id` int(11) NOT NULL AUTO_INCREMENT,\n `show_session_id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL,\n `status` int(11) NOT NULL COMMENT ' 已取消,待付款,待使用,待评价',\n `time` datetime NOT NULL,\n `address_id` int(11) DEFAULT NULL,\n PRIMARY KEY (`order_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='用户订单表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "user_id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "所属用户Id",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "user_id"
},
{
"objectType": "TableField_MYSQL",
"name": "show_id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "所属演出Id",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "show_id"
},
{
"objectType": "TableField_MYSQL",
"name": "seat_id",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "对应演出座次Id",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "seat_id"
},
{
"objectType": "TableField_MYSQL",
"name": "promo_id",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "若非0，则代表是秒杀商品的价格",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "promo_id"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "待观看，已完成，已取消(1，2，3)",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
},
{
"objectType": "TableField_MYSQL",
"name": "time",
"type": "timestamp",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "订单支付时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "time"
},
{
"objectType": "TableField_MYSQL",
"name": "user_delete",
"type": "tinyint",
"length": 1,
"decimals": -2147483648,
"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": "user_delete"
},
{
"objectType": "TableField_MYSQL",
"name": "admin_delete",
"type": "tinyint",
"length": 1,
"decimals": -2147483648,
"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": "admin_delete"
},
{
"objectType": "TableField_MYSQL",
"name": "ticket_count",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "ticket_count"
},
{
"objectType": "TableField_MYSQL",
"name": "ticket_price",
"type": "double",
"length": -2147483648,
"decimals": -2147483648,
"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": "ticket_price"
},
{
"objectType": "TableField_MYSQL",
"name": "order_price",
"type": "double",
"length": 10,
"decimals": 2,
"isUnsigned": false,
"isZeroFill": true,
"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": "order_price"
},
{
"objectType": "TableField_MYSQL",
"name": "payment",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "订单支付方式（支付宝，微信)",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "payment"
},
{
"objectType": "TableField_MYSQL",
"name": "qr_code_url",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "二维码图片,供观影人验证入场",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "qr_code_url"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "order_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_promo",
"comment": "秒杀活动表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_bin",
"autoIncrement": 0,
"tablespace": "",
"storage": "",
"insertMethod": "",
"connection": "",
"checksum": false,
"rowFormat": "",
"avgRowLength": 0,
"maxRows": 0,
"minRows": 0,
"keyBlockSize": 0,
"packKeys": "",
"delayKeyWrite": false,
"dataDirectory": "",
"indexDirectory": "",
"statsAutoRecalc": "",
"statsPersistent": "",
"statsSamplePages": 0,
"union": "",
"pageCheckSum": false,
"transactional": false,
"compression": "",
"oldName": "",
"encryption": false,
"createOptions": "",
"createTime": "",
"checkTime": "",
"dataFree": 0,
"dataLength": 0,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "seat_id",
"type": "int",
"length": -2147483648,
"decimals": -2147483648,
"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": "seat_id"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "活动名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "start_time",
"type": "datetime",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "活动开始时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "start_time"
},
{
"objectType": "TableField_MYSQL",
"name": "end_time",
"type": "datetime",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "活动结束时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "end_time"
},
{
"objectType": "TableField_MYSQL",
"name": "price",
"type": "double",
"length": -2147483648,
"decimals": -2147483648,
"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": "price"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": -2147483648,
"order": "",
"oldName": ""
}
],
"oldName": "",
"indexMethod": "",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "boying_user",
"comment": "用户表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "user",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:40",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `user` (\n `user_id` int(11) NOT NULL AUTO_INCREMENT,\n `username` varchar(32) DEFAULT NULL,\n `password` varchar(32) NOT NULL,\n `real_name` varchar(32) DEFAULT NULL COMMENT '用户真实姓名',\n `identity_number` varchar(32) DEFAULT NULL COMMENT '用户身份证号',\n `phone` varchar(32) NOT NULL,\n `email` varchar(32) DEFAULT NULL,\n `age` int(11) DEFAULT NULL,\n `gender` tinyint(1) DEFAULT NULL COMMENT '用户性别 1->男,0->女',\n PRIMARY KEY (`user_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='用户表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "username",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用户名",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "username"
},
{
"objectType": "TableField_MYSQL",
"name": "password",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用户加密后的密码",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "password"
},
{
"objectType": "TableField_MYSQL",
"name": "phone",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "联系电话",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "phone"
},
{
"objectType": "TableField_MYSQL",
"name": "email",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "邮箱",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "email"
},
{
"objectType": "TableField_MYSQL",
"name": "icon",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "个人头像",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "icon"
},
{
"objectType": "TableField_MYSQL",
"name": "real_name",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用户真实姓名",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "real_name"
},
{
"objectType": "TableField_MYSQL",
"name": "identity_number",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用户身份证号",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "identity_number"
},
{
"objectType": "TableField_MYSQL",
"name": "age",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "age"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "timestamp",
"length": -2147483648,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "创建时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "gender",
"type": "tinyint",
"length": 1,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "用户性别 1->男,0->女",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "gender"
},
{
"objectType": "TableField_MYSQL",
"name": "admin_delete",
"type": "tinyint",
"length": 1,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "管理员是否删除了该用户,默认为0，即未删除状态",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "admin_delete"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "user_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_category",
"comment": "后台资源分类表，在细粒度进行权限控制时，可能资源会比较多，所以设计了个资源分类的概念，便于给角色分配资源。",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "resource_category",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:31",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `resource_category` (\n `resource_category_id` int(11) NOT NULL AUTO_INCREMENT,\n `create_time` datetime DEFAULT NULL,\n `name` varchar(64) DEFAULT NULL,\n `sort` int(11) DEFAULT NULL,\n PRIMARY KEY (`resource_category_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台资源分类表，在细粒度进行权限控制时，可能资源会比较多，所以设计了个资源分类的概念，便于给角色分配资源。'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "datetime",
"length": -2147483648,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": true,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"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": "weight"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源目录状态，启用状态：0->禁用；1->启用",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "resource_category_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_resource",
"comment": "后台资源表，用于控制后台用户可以访问的接口，使用了Ant路径的匹配规则，可以使用通配符定义一系列接口的权限。",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "resource",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:30",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `resource` (\n `resource_id` int(11) NOT NULL AUTO_INCREMENT,\n `resource_category_id` int(11) DEFAULT NULL,\n `create_time` datetime DEFAULT NULL,\n `name` varchar(255) DEFAULT NULL,\n `url` varchar(255) DEFAULT NULL COMMENT '资源URL',\n `description` varchar(255) DEFAULT NULL COMMENT '资源描述',\n PRIMARY KEY (`resource_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台资源表，用于控制后台用户可以访问的接口，使用了Ant路径的匹配规则，可以使用通配符定义一系列接口的权限。'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "category_id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "对应资源目录ID",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "category_id"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "datetime",
"length": -2147483648,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源创建时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "url",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源URL",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "url"
},
{
"objectType": "TableField_MYSQL",
"name": "description",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源描述",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "description"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "int",
"length": 11,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "资源启用状态：0->禁用；1->启用",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "weight"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "resource_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_role_resource",
"comment": "后台角色资源关系表，多对多关系，可以给一个角色分配多个资源。",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "role_resource",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:35",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `role_resource` (\n `role_resource_id` int(11) NOT NULL AUTO_INCREMENT,\n `role_id` int(11) NOT NULL,\n `resource_id` int(11) NOT NULL,\n PRIMARY KEY (`role_resource_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台角色资源关系表，多对多关系，可以给一个角色分配多个资源。'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "role_id",
"type": "int",
"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": "role_id"
},
{
"objectType": "TableField_MYSQL",
"name": "resource_id",
"type": "int",
"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": "resource_id"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "role_resource_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_role",
"comment": "后台用户角色表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "role",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:33",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `role` (\n `role_id` int(11) NOT NULL AUTO_INCREMENT,\n `name` varchar(255) NOT NULL COMMENT '角色名称',\n `description` varchar(255) DEFAULT NULL COMMENT '角色描述',\n `admin_count` int(11) DEFAULT NULL COMMENT '后台用户数量',\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `status` tinyint(4) DEFAULT NULL COMMENT '启用状态：0->禁用；1->启用',\n `sort` int(11) DEFAULT NULL COMMENT '用于排序',\n PRIMARY KEY (`role_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台用户角色表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "角色名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "description",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "角色描述",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "description"
},
{
"objectType": "TableField_MYSQL",
"name": "admin_count",
"type": "int",
"length": 11,
"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": "admin_count"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "datetime",
"length": 0,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "创建时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "tinyint",
"length": 1,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "启用状态：0->禁用；1->启用",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "weight"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "role_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_role_menu",
"comment": "后台角色菜单关系表，多对多关系，可以给一个角色分配多个菜单。",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "role_menu",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:34",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `role_menu` (\n `role_menu_id` int(11) NOT NULL AUTO_INCREMENT,\n `menu_id` int(11) NOT NULL,\n `role_id` int(11) NOT NULL,\n PRIMARY KEY (`role_menu_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台角色菜单关系表，多对多关系，可以给一个角色分配多个菜单。'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "menu_id",
"type": "int",
"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": "menu_id"
},
{
"objectType": "TableField_MYSQL",
"name": "role_id",
"type": "int",
"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": "role_id"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "role_menu_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_menu",
"comment": "后台菜单表，用于控制后台用户可以访问的菜单，支持隐藏、排序和更改名称、图标。",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "menu",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:28",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `menu` (\n `menu_id` int(11) NOT NULL AUTO_INCREMENT,\n `parent_id` int(11) DEFAULT NULL COMMENT '父级ID',\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `title` varchar(64) DEFAULT NULL COMMENT '菜单名称',\n `level` int(11) DEFAULT NULL COMMENT '菜单级数',\n `sort` int(11) DEFAULT NULL COMMENT '菜单排序',\n `icon` varchar(255) DEFAULT NULL,\n `hidden` tinyint(1) DEFAULT NULL COMMENT '控制前端是否隐藏',\n PRIMARY KEY (`menu_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台菜单表，用于控制后台用户可以访问的菜单，支持隐藏、排序和更改名称、图标。'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "parent_id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "0",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "父级ID",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "parent_id"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "datetime",
"length": 0,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "创建时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "title",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "菜单名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "title"
},
{
"objectType": "TableField_MYSQL",
"name": "level",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "菜单级数",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "level"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"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": "weight"
},
{
"objectType": "TableField_MYSQL",
"name": "name",
"type": "varchar",
"length": 255,
"decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "前端名称",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "name"
},
{
"objectType": "TableField_MYSQL",
"name": "icon",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "前端图标",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "icon"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "tinyint",
"length": 1,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "菜单启用状态：0->禁用；1->启用",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "menu_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_user_role",
"comment": "后台用户和角色关系表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "admin_role",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:24",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `admin_role` (\n `admin_role_id` int(11) NOT NULL AUTO_INCREMENT,\n `admin_id` int(11) NOT NULL,\n `role_id` int(11) NOT NULL,\n PRIMARY KEY (`admin_role_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台用户和角色关系表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "user_id",
"type": "int",
"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": "user_id"
},
{
"objectType": "TableField_MYSQL",
"name": "role_id",
"type": "int",
"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": "role_id"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "admin_role_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
},
{
"objectType": "Table_MYSQL",
"name": "admin_user",
"comment": "后台用户表",
"engine": "InnoDB",
"characterSet": "utf8",
"collation": "utf8_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": "admin",
"encryption": false,
"createOptions": "",
"createTime": "2020-10-15 17:34:23",
"checkTime": "",
"dataFree": 0,
"dataLength": 16384,
"indexLength": 0,
"maxDataLength": 0,
"rows": 0,
"updateTime": "",
"DDL": "CREATE TABLE `admin` (\n `admin_id` int(11) NOT NULL AUTO_INCREMENT,\n `username` varchar(64) NOT NULL,\n `password` varchar(64) NOT NULL,\n `icon` varchar(64) DEFAULT NULL COMMENT '头像',\n `email` varchar(64) DEFAULT NULL,\n `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n `login_time` datetime DEFAULT NULL COMMENT '最后登录时间',\n `status` tinyint(1) DEFAULT '1' COMMENT '帐号启用状态：0->禁用；1->启用',\n PRIMARY KEY (`admin_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='后台用户表'",
"partitionBy": "",
"partitionByExpr": "",
"partitions": 0,
"partitionKeyAlgorithm": "",
"subPartitionBy": "",
"subPartitionByExpr": "",
"subPartitions": 0,
"subPartitionKeyAlgorithm": "",
"fields": [
{
"objectType": "TableField_MYSQL",
"name": "id",
"type": "int",
"length": 11,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": true,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "id"
},
{
"objectType": "TableField_MYSQL",
"name": "username",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "username"
},
{
"objectType": "TableField_MYSQL",
"name": "password",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "password"
},
{
"objectType": "TableField_MYSQL",
"name": "icon",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "头像",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "icon"
},
{
"objectType": "TableField_MYSQL",
"name": "email",
"type": "varchar",
"length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "utf8",
"collation": "utf8_bin",
"isNullable": false,
"defaultType": "Empty",
"defaultValue": "Empty String",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "email"
},
{
"objectType": "TableField_MYSQL",
"name": "create_time",
"type": "datetime",
"length": 0,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "创建时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "create_time"
},
{
"objectType": "TableField_MYSQL",
"name": "login_time",
"type": "datetime",
"length": 0,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": true,
"defaultType": "Others",
"defaultValue": "CURRENT_TIMESTAMP",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "最后登录时间",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "login_time"
},
{
"objectType": "TableField_MYSQL",
"name": "status",
"type": "tinyint",
"length": 1,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
"isNullable": false,
"defaultType": "Others",
"defaultValue": "1",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
"comment": "帐号启用状态：0->禁用；1->启用",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
"oldName": "status"
},
{
"objectType": "TableField_MYSQL",
"name": "weight",
"type": "int",
"length": 11,
"decimals": -2147483648,
"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": "weight"
}
],
"indexes": [],
"primaryKey": {
"objectType": "PrimaryKey_MYSQL",
"name": "",
"fields": [
{
"objectType": "IndexField_MYSQL",
"name": "id",
"keyLength": 0,
"order": "",
"oldName": "admin_id"
}
],
"oldName": "",
"indexMethod": "BTREE",
"comment": ""
},
"foreignKeys": [],
"triggers": [],
"tablePartitions": []
}
],
"views": []
},
{
"objectType": "Schema_MYSQL",
"name": "test1",
"tables": [],
"views": []
}
]
},
"diagrams": [
{
"name": "Diagram 1",
"paperWidth": 2,
"paperHeight": 1,
"tableFont": "Arial Unicode MS",
"tableFontSize": 14,
"isBalckWhite": false,
"showDBSchemaName": false,
"showViewRelations": true,
"notation": "default",
"showFieldComment": false,
"showTableComment": false,
"shapes": [
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_user",
"x": 1180,
"y": 30,
"width": 200,
"height": 230,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_user_role",
"x": 980,
"y": 80,
"width": 165,
"height": 110,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_menu",
"x": 770,
"y": 390,
"width": 181,
"height": 230,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_resource",
"x": 280,
"y": 50,
"width": 210,
"height": 200,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_category",
"x": 280,
"y": 300,
"width": 210,
"height": 150,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_role",
"x": 760,
"y": 50,
"width": 183,
"height": 180,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_role_menu",
"x": 780,
"y": 260,
"width": 161,
"height": 110,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "admin_role_resource",
"x": 530,
"y": 80,
"width": 177,
"height": 110,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_category",
"x": 1110,
"y": 870,
"width": 190,
"height": 170,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_seat",
"x": 570,
"y": 860,
"width": 180,
"height": 210,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_order",
"x": 540,
"y": 1120,
"width": 260,
"height": 330,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_show",
"x": 850,
"y": 820,
"width": 200,
"height": 280,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_user",
"x": 840,
"y": 1120,
"width": 230,
"height": 300,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_stock",
"x": 580,
"y": 740,
"width": 150,
"height": 110,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
},
{
"type": "table",
"schemaName": "Default",
"tableName": "boying_promo",
"x": 310,
"y": 860,
"width": 200,
"height": 200,
"isBold": false,
"titleColor": {
"r": 55,
"g": 131,
"b": 192,
"a": 1
}
}
],
"layers": [],
"relations": [],
"viewRelations": []
}
]
}
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手