“信用分&信用报告”的版本间的差异
来自qingwei personal wiki
（创建页面，内容为“ category: 阿里 category: 数据管家”） |
|||
| 第1行： | 第1行： | ||
| + | == scope == | ||
| + | === 产品能力 === | ||
| + | * 若加工离线表 | ||
| + | <source lang="sql"> | ||
| + | # 相关表 | ||
| + | certified_item | ||
| + | certified_item_properties | ||
| + | certified_report | ||
| + | certified_item_table_value | ||
| + | |||
| + | SELECT * FROM `certified_report` WHERE company_id = 239468209 | ||
| + | |||
| + | SELECT * FROM `certified_item` WHERE report_id = 111370617 and data_key = "production_machinery" | ||
| + | |||
| + | SELECT * FROM `certified_item_table_value` WHERE certified_report_id = 111370617 and certified_item_id = 125722827 | ||
| + | </source> | ||
[[category: 阿里]] | [[category: 阿里]] | ||
[[category: 数据管家]] | [[category: 数据管家]] | ||
2019年2月12日 (二) 08:02的版本
scope
产品能力
- 若加工离线表
# 相关表
certified_item
certified_item_properties
certified_report
certified_item_table_value
SELECT * FROM `certified_report` WHERE company_id = 239468209
SELECT * FROM `certified_item` WHERE report_id = 111370617 and data_key = "production_machinery"
SELECT * FROM `certified_item_table_value` WHERE certified_report_id = 111370617 and certified_item_id = 125722827
