描述
支持多个表的表字段
请求地址
/v2/webservice/table/get-table-key-value-fields
请求方法
Post
请求参数说明
| 字段名 | 字段说明 | 类型 | 是否必填 | 描述 |
|---|---|---|---|---|
| app_id | 项目ID | 是 | -- |
示例1，成功
{
"app_id": 2,
"tables": [
{
"zone_id": 1,
"table_name": "pb_generic_index_noshardkey"
},
{
"zone_id": 3,
"table_name": "pb_generic_index_noshardkey"
}
]
}
返回data.list参数说明
| 字段名 | 字段说明 | 类型 | 描述 |
|---|---|---|---|
| key_fields | key字段 | 结构体 | |
| value_files | value字段 | 结构体 | |
| key_fields.key_field | 具体的key字段 | 数组 | |
| value_files.value_field | 具体的key字段 | 数组 | |
| app_id | |||
| zone_id | |||
| table_name |
Fields结构体
| 字段名 | 字段说明 | 类型 | 描述 |
|---|---|---|---|
| name | 字段名 | ||
| type | 字段类型 |
成功返回
{
"code": 0,
"request_id": "8df8e6da-3781-47a0-8445-c08487ef5f97",
"data": {
"list": [
{
"key_fields": {
"num": 4,
"key_field": [
{
"name": "openid",
"type": "uint32",
"max_len": 4
},
{
"name": "timekey",
"type": "string",
"max_len": 1022
},
{
"name": "tconndid",
"type": "int32",
"max_len": 4
},
{
"name": "svrid",
"type": "string",
"max_len": 1022
}
]
},
"value_files": {
"num": 8,
"value_field": [
{
"name": "gamesvrid",
"type": "string",
"max_len": 10000000,
"default": ""
},
{
"name": "other_property",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "items",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "lockid",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "val",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "pay",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "id_uint32",
"type": "uint32",
"max_len": 4,
"default": ""
},
{
"name": "id_int32",
"type": "int32",
"max_len": 4,
"default": ""
}
]
},
"app_id": 2,
"zone_id": 1,
"table_name": "pb_generic_index_noshardkey",
"table_maxnum": 0,
"compress": 1,
"idl_md5": "56b398729e47fab0b1b92d94e4868996",
"ext_idl_md5": "a142f4d6099f892d9dbeba328f67eff9",
"create_date": "2023-03-08T08:03:42.000Z",
"dm_ratio": 5,
"engine_parameters": "bnum=100000#xmsiz=60000000#xikmsiz=26000000#kfapow=6#kmapow=6#vfapow=6#vmapow=6#lnum=2",
"fmt_type": "proto",
"tdr": null
},
{
"key_fields": {
"num": 4,
"key_field": [
{
"name": "openid",
"type": "uint32",
"max_len": 4
},
{
"name": "timekey",
"type": "string",
"max_len": 1022
},
{
"name": "tconndid",
"type": "int32",
"max_len": 4
},
{
"name": "svrid",
"type": "string",
"max_len": 1022
}
]
},
"value_files": {
"num": 8,
"value_field": [
{
"name": "gamesvrid",
"type": "string",
"max_len": 10000000,
"default": ""
},
{
"name": "other_property",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "items",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "lockid",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "val",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "pay",
"type": "binary",
"max_len": 10000000,
"default": ""
},
{
"name": "id_uint32",
"type": "uint32",
"max_len": 4,
"default": ""
},
{
"name": "id_int32",
"type": "int32",
"max_len": 4,
"default": ""
}
]
},
"app_id": 2,
"zone_id": 3,
"table_name": "pb_generic_index_noshardkey",
"table_maxnum": 0,
"compress": 1,
"idl_md5": "d504900a58ebc07f75d8fc6fd51ea26f",
"ext_idl_md5": "a142f4d6099f892d9dbeba328f67eff9",
"create_date": "2023-04-13T10:04:19.000Z",
"dm_ratio": 5,
"engine_parameters": "bnum=100000#xmsiz=60000000#xikmsiz=26000000#kmapow=6#kfapow=6#vmapow=6#vfapow=6#lnum=2",
"fmt_type": "proto",
"tdr": null
}
],
"total": 2
}
}
失败返回
{
}