- 根据表名查sd_id
mysql> select sd_id,tbl_name from tbls where tbl_name='s_member_core_customer_i';
+--------+--------------------------+
| sd_id | tbl_name |
+--------+--------------------------+
| 111921 | s_member_core_customer_i |
+--------+--------------------------+
1 row in set (0.00 sec)
- 根据sd_id查cd_id
mysql> select cd_id,sd_id from sds where sd_id='111921';
+-------+--------+
| cd_id | sd_id |
+-------+--------+
| 35017 | 111921 |
+-------+--------+
- 根据cd_id即可查出注解字段
mysql> select * from columns_v2 where cd_id='35017';
+-------+---------------------------------------------------------------------------------------------------+----------------+-----------+-------------+
| CD_ID | COMMENT