查看“Mydata”的源代码

== 日常环境 ==
=== chrome下访问 ===
# 打开无痕浏览
# url中输入 chrome://net-internals/#hsts， 选择Domain Security Policy
# Delete domain security policies 中删除： hz-mydata.alibaba.com, login.alibaba,com 
=== DNS配置 ===
<source lang="shell">
11.160.117.191  data.alibaba.com

11.160.205.238  hz-mydata.alibaba.com

11.160.205.238  us-mydata.alibaba.com

11.163.84.60  alidata-bops.alibaba-inc.com


11.162.132.172  www2.alibaba.com  

#alibaba
11.163.171.5    login.alibaba.com  #enlogin
11.163.174.65    accounts.alibaba.com
#11.163.86.202  passport.alibaba.com
11.163.14.171    marketing.alibaba.com
127.0.0.1    i.alibaba.com  
127.0.0.1  umidprod.stable.alibaba-inc.com    
127.0.0.1  profile.alibaba.com
127.0.0.1  notification.alibaba.com
127.0.0.1  www.alibaba.com
127.0.0.1  page.1688.com
127.0.0.1  stat.gmonitor.aliimg.com
127.0.0.1  acookie.alibaba.com
127.0.0.1  page.china.alibaba.com
127.0.0.1  ynuf.alibaba.com
127.0.0.1  hzhermes.alibaba.com
127.0.0.1  checktoken.alibaba.com
127.0.0.1  checktoken2.alibaba.com
127.0.0.1  translate.google.com
127.0.0.1  cmap.alibaba.com
#登录
11.239.151.122  login.aliexpress.com  #  aone
#add  by  youzhao  for  host  api  test
127.0.0.1  www.func1.com
127.0.0.1  www.func2.com

#  ENV_FUNC

#  external  hosts

#  11.22.33.44  alex_test_domain

10.125.10.175  sso.alibaba-inc.com

10.125.10.174  img.alitest.net

10.218.130.51  cun.taobao.org

10.218.137.155  i.cun.daily.taobao.net

10.189.227.143  cun.daily.taobao.net

10.101.73.189  g.tbcdn.cn

#10.101.73.189  g.alicdn.com

100.69.167.192  cunlist.daily.taobao.com

10.101.83.83  radar.aliyun.test

10.101.83.79  auth.alibaba.net

10.189.227.74  account.aliyun.test

#10.101.91.52  passport.daily.alibaba.com

10.101.86.70  aui.aliyun.test

10.101.83.84  portal.aliyun.test

10.125.1.239  radar.alibaba-inc.com

100.69.192.12  tcunmotion.taobao.org

10.218.133.185  poa.alibaba-inc.com

#  meri日常环境

10.218.143.112  testmeri.alibabacorp.com

100.69.161.171  venice-test.alibaba.com

100.69.169.167  recluse.alitest.net

#  ceres日常环境

100.69.170.245  ceresiner.alitest.com

100.69.170.245  cerespub.alitest.com

#  Ants独立性环境

100.69.170.245  cg.zmxy.net

100.69.170.245  cg.mybank.net

100.69.170.245  cg.antsdaq.net

100.69.170.245  cg.alipay.net

100.69.170.245  cg.ant-financial.net

100.69.170.245  cg.koubei.net

#    ceres需要的1688日常环境

42.156.238.99  login.1688.com

42.156.238.99  pass.pass.1688.com

42.156.238.99  trade.1688.com

42.156.238.99  order.1688.com

42.156.238.99  member.china.alibaba.com

42.156.238.99  member.1688.com

#  42.156.238.99  test.img.china.alibaba.com  i00.c.aliimg.com  i01.c.aliimg.com  i02.c.aliimg.com  i03.c.aliimg.com  i04.c.aliimg.com  i05.c.aliimg.com

42.156.238.99  go.1688.com

42.156.238.99  webpush.1688.com

112.124.132.140  gw.open.1688.com

42.156.238.99  portal.go.1688.com

42.156.238.99  foxtest001.go.1688.com

42.156.238.99  zhoulhtest001.go.1688.com

42.156.238.99  hxjtest1.go.1688.com

42.156.238.99  shenghua001.go.1688.com

42.156.238.99  open.go.1688.com

#  rocky日常环境

11.239.186.181  property-daily.alibaba-inc.com

100.69.199.118  property-test.alibaba-inc.com

#  10.232.101.129    yunpan.alibaba-inc.com

#  10.218.139.10  a-work.alibaba-inc.com
</source>
== db ==
=== 新产品表 ===
dwp_en_gm_vip_prod_eff_d
=== 行业树===
<source lang=sql>
create table `sc_alidata_[0000-0015].dwp_en_dm_vip_compcate_d_[[0000-0216]]` (
  `id` bigint  not null auto_increment comment '主键',
  `stat_date` date comment '统计日期',
  `admin_mbr_seq` bigint comment '会员SEQ',
  `admin_mbr_id` varchar(100) comment '会员ID',
  `comp_id` bigint comment '公司ID',
  `cate_id` bigint comment '产品发布类目ID【关联维表icbucdm.dim_en_pcate_v】【关联键cate_id】',
  `itm_cnt_std_009` bigint comment '历史截至当日商品数',
  `rank_std_001` bigint comment '历史截止当日商品数排序',
  `cate_desc` varchar(200) comment '行业描述',
  primary key (id),
  key `idx_admin_mbr_id` (stat_date,admin_mbr_seq)
) default charset=utf8mb4 comment='每个分区包含公司发布商品的行业指标';
</source>
相关的表:
dim_en_iview_cate (数据仓库中)  --> pub_en_iview_category_dimt0 (mysql表)<br />
备注: pub_en_iview_category_dimt0  这个就是从icbucdm.dim_en_pcate_v 出来的