自定义表关系报告制作方法

SELECT t1.name 自定义表名,t1.query sql内容,t1.create_time 创建时间,
t1.modify_time 修改时间,t2.type 类型,t3.name 项目名称,t4.name 数据连接名,t6.name 模型名称,
t8.title,t7.report_id,t9.name 应用图表名称
from custom_table t1 LEFT JOIN table_rely t2 on t1.id=t2.resource_id
LEFT JOIN youdata.project    t3   on t1.project_id =t3.id
LEFT JOIN youdata.data_connection t4 ON t1.data_connection_id=t4.id
LEFT JOIN youdata.data_model_extract t5 on t1.id=t5.table_expr_id
LEFT JOIN youdata.data_model t6 ON t5.data_model_id=t6.id
LEFT JOIN youdata.new_report_data_model t7 ON t6.id=t7.related_data_model_id
LEFT JOIN youdata.new_report t8 on t7.report_id=t8.id
LEFT JOIN youdata.componnet_info_view t9 on t8.id=t9.report_id
WHERE t2.type="CUSTOM_TABLE" AND t6.name is not null 
and t9.data_model_id=t6.id AND t3.id=10