| 123456789101112131415161718192021222324252627282930313233343536 |
- ; 表名:raw_shp_tzy_merchant_info_inc_d
- ; 配套 sync ini:jobs/raw/shp/raw_shp_tzy_merchant_info_inc_d.ini
- ; 配套 DDL:manual/ddl/raw/shp/raw_shp_tzy_merchant_info_inc_d_create.sql
- ; 配套建模文档:kb/24-raw建模.md §5
- ;
- ; 字段决策来源:inbox 3.2.2.3 店铺域建模.md(分析师库 ods 草稿) vs PG 业务库实际 schema 对账。
- ; - 明性裁:inbox 涉密列标 y / y(hash) / y(sync -month) → 审批会议决策。
- ; method 映射:y → trim、y(hash) → md5、y(sync -month) → month_trunc。
- ; - 隐性裁:PG 业务库有 / inbox 草稿无的字段(上游变更未通知下游,待与业务库后端对账)。
- ;
- ; 2026-04-30 第一版:本表 PG 字段集与 inbox 完全一致,无隐性裁。
- [mask]
- ; ---- 明性裁 ----
- avatar = trim
- linkname = trim
- link = trim
- address = trim
- more_address = trim
- anchor_wechat = trim
- customer_wechat = trim
- customer_qrcode = trim
- jd_token = trim
- jd_trade_code = trim
- jd_refresh_token = trim
- work_wechat_auth = trim
- self_sign_type = trim
- self_sign_id = trim
- self_sign_status = trim
- self_sign_status_msg = trim
- self_sign_data = trim
- pay_config = trim
- group_show_imgs = trim
- show_config_json = trim
- bond_amount = trim
|