数据库查询主题域与表关联关系

适用模块

模型设计
元数据中心

具体说明

导出表和主题归属的映射关系

使用示例

mysql> select * from Music_MetaHubTag where id in (select tag_id from Music_MetaHubTableTag where tbl='ads_approve_total_alalysis_test') and type='domainv2' \G;
*************************** 1. row ***************************
              id: 88
             tag: 9
        keywords: ["财务域", "cwy"]
      created_by: admin.mammut@163.com
last_modified_by: admin.mammut@163.com
  db_create_time: 2021-03-04 21:23:14
  db_update_time: 2021-07-13 20:05:24
            type: domainv2
          biz_id: 1
   parent_tag_id: 0
           level: 1
*************************** 2. row ***************************
              id: 634
             tag: 139
        keywords: ["资产负债", "zhaiwu"]
      created_by: wb.lijingqi01@mesg.corp.netease.com
last_modified_by: wb.lijingqi01@mesg.corp.netease.com
  db_create_time: 2021-07-08 11:24:51
  db_update_time: 2021-07-13 14:38:25
            type: domainv2
          biz_id: 1
   parent_tag_id: 88
           level: 1
*************************** 3. row ***************************
              id: 772
             tag: 150
        keywords: ["资产合计", "zchj"]
      created_by: gexujun@corp.netease.com
last_modified_by: gexujun@corp.netease.com
  db_create_time: 2021-07-15 10:44:35
  db_update_time: 2021-07-15 10:44:35
            type: domainv2
          biz_id: 1
   parent_tag_id: 634
           level: 1
*************************** 4. row ***************************
              id: 1328
             tag: 270
        keywords: ["test1", "t1"]
      created_by: yidedi@corp.netease.com
last_modified_by: yidedi@corp.netease.com
  db_create_time: 2021-11-01 13:21:08
  db_update_time: 2021-11-01 13:21:08
            type: domainv2
          biz_id: 1
   parent_tag_id: 772
           level: 1
4 rows in set (0.01 sec)

作者：林帅