描述

除了表列表中的字段以外，返回更多信息

请求地址

/v2/webservice/table/table-info

请求方法

Post

请求参数说明

示例

{
    "app_id":2,
    "zone_id":1,
    "table_name": "lstFriendMail"
}

返回data参数说明

成功返回

{
    "code": 0,
    "request_id": "a61d155b-6aff-4f8f-8141-5d8dd20e8c44",
    "data": {
        "uid": 6767,
        "zone_id": 1,
        "app_id": 5,
        "zone_show_id": 1,
        "set_id": 1,
        "mem_unused_cnt": 0,
        "mem_used_cnt": 0,
        "table_name": "GenericTableDemo",
        "fmt_type": "tdr",
        "shard_factors": "uin",
        "hash_mode": 1,
        "mod_num": 10000,
        "table_type": 0,
        "table_maxnum": 0,
        "key_struct": "",
        "value_struct": "",
        "status": 1,
        "estimated_volume": 0,
        "estimated_avarage_record_size": 0,
        "estimated_write_load": 1,
        "estimated_read_load": 1,
        "real_volume": 5,
        "real_avarage_record_size": 0,
        "real_write_load": 0,
        "real_read_load": 0,
        "disk_unused_cnt": 0,
        "disk_used_cnt": 0,
        "create_date": "2022-11-30T06:56:48.000Z",
        "memo": "",
        "is_accepted": 0,
        "proxy_beat_period": 20,
        "dm_ratio": 5,
        "kelly_bid": 0,
        "taskid": 0,
        "version": "",
        "set_name": "autoinstall_Set",
        "app_name": "数据编辑器体验环境",
        "zone_name": "正式体验数据",
        "xml": "945",
        "tdr": null,
        "key_fields": "{\"Num\":1,\"KeyField\":[{\"Name\":\"uin\",\"Type\":\"uint32\",\"MaxLen\":4}]}",
        "plugin_name": "",
        "plugin_enabled": 0,
        "plugin_target": 0,
        "plugin_lib_file_id": 0,
        "plugin_cfg_file_id": 0,
        "syncdb_config": "{\"Target\":0,\"DBQueueWriteFlag\":0,\"DBQueueReadFlag\":0,\"DBURL\":\"\",\"DefaultSyncName\":\"\",\"MaxBlockNumOfTaskQueue\":0,\"MaxNodeNumPerBlockOfTaskQueue\":0,\"TaskQueueBucketNum\":0,\"SyncMechNum\":0}",
        "read_only": 0,
        "value_fields": "{\"Num\":5,\"ValueField\":[{\"Name\":\"name\",\"Type\":\"string\",\"MaxLen\":1024,\"Default\":\"\"},{\"Name\":\"age\",\"Type\":\"uint32\",\"MaxLen\":4,\"Default\":\"\"},{\"Name\":\"score1\",\"Type\":\"float\",\"MaxLen\":4,\"Default\":\"\"},{\"Name\":\"score2\",\"Type\":\"uint32\",\"MaxLen\":4,\"Default\":\"\"},{\"Name\":\"score3\",\"Type\":\"double\",\"MaxLen\":8,\"Default\":\"\"}]}",
        "engine_parameters": "bnum=7500000#xmsiz=1000000000#xikmsiz=475000000#kfapow=6#kmapow=6#vfapow=6#vmapow=6#lnum=2",
        "compress": 1,
        "data_compatibility": 0,
        "data_expiration": "",
        "key_size": 1,
        "value_size": 1,
        "active_record_num": 1,
        "total_record_num": 1,
        "slave_read_date": 0,
        "slave_read_hour": 0,
        "slave_read_level": 0,
        "slave_read_ratio": 50,
        "slave_read_retry": 1,
        "init_tdr_ver": 1,
        "curr_tdr_ver": 1,
        "calc_resource_type": 1,
        "pcu": 0,
        "relationship_chain_interval": 0,
        "relationship_chain_count": 0,
        "index_count": 0,
        "read_index_interval": 0,
        "read_index_count": 0,
        "read_interval": 0,
        "write_interval": 0,
        "order_id": "",
        "max_read_rate": 0,
        "max_write_rate": 0,
        "exceed_times": 0,
        "idl_md5": "ce3a2d32f9a68994be2c01856e7ab531",
        "ext_idl_md5": "",
        "modify_date": "2023-01-05T07:44:39.000Z",
        "dbcluster_info": "{\"AppID\":5,\"ZoneID\":1,\"TableName\":\"GenericTableDemo\",\"TableType\":0,\"DbSources\":{\"DbSourceNum\":1,\"DbSource\":[{\"DbSourceName\":\"DbSource\",\"Ip\":\"\",\"Port\":-1,\"User\":\"\",\"Passwd\":\"\",\"DbName\":\"\",\"ConnPoolSize\":10,\"CharacterSet\":\"utf8\"}]},\"DbTables\":{\"DbTableNum\":1,\"DbTable\":[{\"TablePrefix\":\"\",\"SubTableCount\":0,\"ValueFields\":{\"FieldNum\":4,\"Field\":[{\"FieldName\":\"age\",\"DbFieldName\":\"\"},{\"FieldName\":\"score1\",\"DbFieldName\":\"\"},{\"FieldName\":\"score2\",\"DbFieldName\":\"\"},{\"FieldName\":\"score3\",\"DbFieldName\":\"\"}]},\"KeyFields\":{\"FieldNum\":1,\"Field\":[{\"FieldName\":\"uin\",\"DbFieldName\":\"\"}]},\"Deploy\":{\"SubTableStorePlaceNum\":1,\"SubTableStorePlace\":[{\"SubTableIndexStart\":0,\"SubTableIndexEnd\":0,\"DbSourceName\":\"DbSource\"}]}}]},\"FieldTypeStmts\":{\"TableTdrFile\":\"..\/..\/cfg\/tcapdb_1_5_5_1\/ce3a2d32f9a68994be2c01856e7ab531.tdr\",\"TableTdrName\":\"GenericTableDemo\",\"KeyFieldStmts\":{\"FieldStmtNum\":0},\"ValueFieldStmts\":{\"FieldStmtNum\":0},\"TableIdlFile\":\"\",\"IdlType\":1},\"RouteKeyFields\":{\"FieldNum\":0},\"tdbank_conf\":{\"bid\":\"\",\"tid\":\"\",\"db_name\":\"\",\"string_encode_manner\":0,\"msgtype\":0,\"tdbank_addr\":\"\"},\"DBType\":4,\"IndexInfo\":{\"ReplicationNum\":1,\"ShardNum\":3},\"PluginInfo\":{\"PluginName\":\"\",\"PluginFileID\":0,\"PluginFilePath\":\"\",\"WindowSize\":0,\"AlarmReceivers\":\"\"},\"KafkaInfo\":{\"Instance\":\"\",\"Address\":\"\",\"Topic\":\"\",\"User\":\"\",\"Password\":\"\",\"IsVpc\":0}}",
        "sort_field_num": 0,
        "sort_rule": 0,
        "data_protocol_type": "TBD",
        "qcloud_inst": "",
        "real_total_size": 0,
        "qcloud_status": 0,
        "qcloud_status_time": null,
        "gb_per_shard": 0,
        "periodically_cleanup_table_config": "",
        "pb_full_key_tag": "",
        "pb_split_key_tag": "",
        "qcloud_syncdb_status": 1,
        "qcloud_syncdb_instance_id": "",
        "write_ulog_mode": 0,
        "syncdb_type": 0,
        "local_indices": "",
        "repeated_bitmap": 256,
        "enable_cache": 0,
        "apply_user": "v_jxlin"
    }
}

失败返回

{

}