首页  流程图  详情

财务表关系-old

2024-12-24 13:52:01   4  举报





遥望网络

逻辑关系图

表与表之间的关系

作者其他创作

大纲/内容

ods.live_zhubo_platform_account_df

app.finance_order_extend_detail_df

app.finance_ship_detail_df

dim.live_zhubo_user_info_df

dept_id

sync.app_finance_goods_stat_1_df

dw.live_erp_order_goods_df

1159 财务发货成本_一件代发

自营订单表

ods.live_goods_category_df t1

dim.zh_multiple_enum_df tB3

ods.live_account_crawler_conf_df

dw.live_order_basic_extend_df

982 财务订单_订单明细

app.finance_output_warehouse_goods_stat_ma t3

974 财务订单_统计概览_维度统计_店铺

buyer_order_no

sync.dhu_live_room_goods_detail_df

platform_order_goods_no

dw.live_order_goods_fin_df t1

order_no

替代线上的：dw.live_erp_order_di表该表按照天分区

dw.live_info_detail_df

dw.live_order_basic_extend_df t1

dw.live_coarse_room_order_goods_df

ods.live_live_custom_room_info_df

CPS商品表

dim.live_zhubo_manual_dept_df t2

1156 财务发货成本_发货明细

ods.live_erp_warehouse_df t7

dim.goods_supplier_cps_item_df

1条pon多条数据，1商品1佣金

dwd.live_order_logistics_di t5

org_id

dim.goods_supplier_cps_item_df t4

init_sku_code + supplier_no

ods.live_zhibo_live_cart_goods_df

inner join

1020 财务订单_统计明细_商品

968 财务订单-统计概览_天维度折线图

sync.app_finance_order_extend_detail_output_df_idxx

订单商品扩展表

dw.live_supplier_cps_item_order_df

ods.live_erp_after_sale_order_df t8

sync.app_finance_zhubo_stat_df

ods.ywcloud_org_df t5

ods.live_live_platform_room_info_df

dw.live_cart_goods_df

ding_user_id

1158 财务发货成本_自营总成本

dw.live_order_goods_df

970 财务订单_统计概览_维度统计_部门

unique_no

ods.live_supplier_base_df t6

dw.live_order_commission_fin_df

dwd.live_activity_data_export_detail_di t12

dw.live_erp_order_goods_df

t1.sku_id = t2.shangpinbianma

自营订单商品宽表

dw.live_order_goods_extend_df t2

app.finance_order_extend_detail_output_di

sync.app_finance_ship_detail_df_idx_v1

dw.live_order_goods_fin_df

dwd.live_t_rt_user_info_trend_detail_rpt_df

t1.cooperation_mode = t2.enum_id

app.dhu_30d_live_room_goods_detail_di

sync.live_supplier_cps_item_order_df

1157 财务发货成本_指标卡_折线图

976 财务订单_统计明细_主播商品

ods.live_delete_sku_detail_df t2

app.finance_ship_stat_df

dw.live_order_goods_df t3

app.finance_ship_detail_output_di

dw.live_erp_order_df t4

app.finance_zhubo_stat_df

dw.live_eff_zhubo_user_info_df

财务发货成本

dw.live_order_basic_extend_df

dwd.live_order_commission_di t1

dwd.live_erp_order_logistics_di

平台商品

dw.live_order_basic_extend_df t1

dw.live_erp_order_df

订单商品宽表

977 财务订单_统计明细_主播

platform_order_no

dw.live_order_goods_extend_df

ods.live_brand_df t4

dw.live_erp_order_goods_df t10

dw.live_erp_order_goods_df t1

ods.goods_item_category_df t5

app.finance_goods_stat_1_df

dw.live_coarse_room_order_goods_df

mid.live_order_goods_extend_df t1

app.finance_ship_month_stat_df

app.finance_order_extend_detail_df t2

dwd.live_order_basic_di tA

raw_so_id （order_no+A）

goods_id + from_source

遥望用户

dw.live_room_order_goods_ref_df

sync.app_finance_ship_month_stat_df

dwd.dhu_goods_info_back_track_df

platform_order_no+ goods_id + combo_sku_id

dw.live_eshop_cart_goods_df

dwd.live_t_rt_live_cart_goods_info_rpt_di

ods.live_zhubo_platform_account_df t7

975 财务订单_统计概览_维度统计_商品类目

ods.ywcloud_dingding_dept_user_rel_df t3

dw.live_order_commission_fin_df t2

dw.live_erp_order_goods_df t4

dim.live_platform_goods_info_df

ods.live_zhibo_live_cart_goods_other_info_df

973 财务订单_统计概览_维度统计_商品品牌

mid.live_user_goods_sales_hour_df

dwd.live_order_basic_di t2

dw.live_order_commission_df

dim.zh_multiple_enum_df tB4

ods.goods_terminal_category_df t4

output表结果为增量，同步到ES五个索引中

dim.live_platform_goods_info_df t3

dw.live_order_room_df 扩为全量订单 t1；cart_goods_df 关联t1(去掉无房间号的) 得到映射表t2;dw.live_order_room_df 关联t2 打上流量标记

app.live_goods_detail_df

dw.live_order_goods_extend_df t2

ods.live_zhubo_user_info_df t1

dw.live_order_goods_extend_df t11

dim.goods_supplier_cps_item_df t8

ods.xp_item_platform_relation_df

dw.dhu_live_room_goods_detail_df

dwd.live_erp_order_new_di

969 财务订单_统计概览_维度统计_主播

user_id+dept_id 定位dim唯一记录(一个员工可能会有多个部门[领导])t1.ding_user_id = t2.dingding_user_idt2.dingding_user_id = t3.dingding_user_idt3.dept_id = t4.dept_idt4.dept_id = t5.org_id

商品中心

dwd.live_order_goods_di

自营部分 span style=\"font-size: inherit;\

dw.live_cart_goods_relation_df 扩张为订单商品得到t2；order_goods_extend 关联 t2

dim.zh_multiple_enum_df t2

dw.xp_plan_live_room_goods_detail_df

dw.live_goods_zhubo_detail_df t1

dw.live_cart_goods_relation_df

ods.goods_spu_df t3

roi 投资回报率：付款GMV[sales_amt]： span style=\"font-weight: normal;\

ods.ywcloud_user_df t1

user_id+dept_id

dwd.live_order_goods_di t1

dwd.live_order_logistics_di t9

dwd.live_order_basic_di

pk_id+platform_order_no 11-26前 pk_id为null platform_order_no唯一11-26后，pk_id唯一

sync.app_finance_goods_zhubo_stat_1_df

dw.live_order_basic_extend_df

dingding_user_id

ods.live_zhibo_off_live_goods_data_df

app.finance_goods_stat_df

dim.live_zhubo_user_info_df t6

dw.live_room_order_goods_df

mid.dhu_replay_live_room_goods_df

sku_no

sync.dim_live_ship_select_df

只插入数据，不删除不更新，遇到唯一键冲突则忽略该记录（定制开发的同步任务Jar包）

app.dhu_30d_live_room_info_di

dw.live_order_goods_extend_df

ods.goods_sell_submit_spu_df t2

STOP |每月发货订单明细

app.live_warehouse_compare_df

platform_order_no+ goods_id + combo_sku_id (>2020-11-26)

dwd.live_erp_order_goods_new_di t1

999 商品详情

dim.live_show_select_df

ods.live_platform_rate_config_df t5

998 主播详情

1161 财务发货成本_下拉框

ods.goods_supplier_cps_item_df t1

981 财务订单_下拉框

推补录

dim.live_platform_goods_info_df t3

order_from_source: 1-淘宝 2-京东 3-拼多多 4-快手小店 5-有赞微商城 6-微小店 7-有赞客 8-抖音小店 9-京东来客 10-抖音CPS 11-魔筷 12-抖音小店+抖音CPS 13-有赞分销 14-快手CPS'15-有赞微商城+有赞客16-快手小店+快手CPS

dw.live_order_basic_extend_df t1

ods.goods_system_plate_form_rel_df t2

dwd.live_account_base_df t5

dwd.live_order_basic_di t1

app.finance_goods_zhubo_stat_df

订单扩展宽表

mid.live_order_goods_extend_df

佣金表

dim.zh_multiple_enum_df t6

tA表所有字段做判空处理tB1.order_from_source = tB2.enum_idtB1.platform=tB3.enum_id tB1.order_status= tB4.enum_id ==> tBtA.platform_order_no = tB.platform_order_no

dw.live_user_goods_sales_hour_df

user_no

dwd.live_order_basic_di t5

on t1.platform_order_no = t2.platform_order_not1.goods_id = t3.goods_id and t2.order_from_source = t3.from_source

group by t2.user_id去重t1.zhubo_bc=t2.user_id

dw.live_erp_order_goods_df t2

dw.live_coarse_room_order_goods_df

dw.live_order_goods_df t2

ods.live_zhubo_user_info_df

ods.goods_sell_submit_sku_df t1

ods.live_order_basic_di tB1

sync.live_show_select_df

app.finance_order_extend_detail_df t1

ods.goods_item_category_df

dw.live_order_goods_extend_df

t5.order_no as order_not5.pon as platform_order_not1.outer_order_no as raw_so_id[A]t1.platform_order_no as inner_outer_not1.platform_order_goods_no as pogn

ods.goods_system_plate_form_rel_df t3

dim.live_live_platform_room_info_df

sync.app_finance_ship_stat_df

<2020-11-26聚合处理 group by platform_order_no；>2020-11-26保留并剪裁掉了 1/2 的列

dwd.live_erp_order_goods_ext_di t2

dim.live_ship_select_df

1000 瑜大商品详情

app.finance_goods_zhubo_stat_1_df

sync.app_finance_goods_stat_df

dim.ywcloud_user_info_df t2

dingding_user_id + dept_id

订单表