数仓分层图

dwd层

sh_ads_merchant_dailytoday 日期count_1w_money当天金额大于1w商户数ticket_total_amount当天总金额大于20w商户数

dws层

云票c端

sh_dw_kaipiao_todaytoday 日期invoice_kind 类型channel 渠道industry 行业province 省份billing_merchants 有效商户数quantity_invoice 当天开票量success_invoice 当天成功开票量fail_invoice 当天失败开票量one_success_invoice 一次开票成功量

dwd_m_sell_clientschannel  渠道id 税号industry 行业province 省份

ods层

ads_i_invoice_dailyinvoice_num 每天发票数total_invoice_num累计发票量source 来源today 日期effective_invoice_num有效发票数total_effective_invoice_num累计有效发票量

sh_dws_merchant_dailytoday 日期max_count_1w_money当天最大金额ticket_total_amount_money当天总金额

dwd_kaipiaocreate_at 创建时间invoice_kind 类型sell_tax_code 纳税人税号state票据状态state_max开票状态最大值ticket_total_amount_has_tax 合计含税金额

ods_kaipiaocreate_at 创建时间invoice_kind 类型sell_tax_code 纳税人税号state票据状态state_max开票状态最大值ticket_total_amount_has_tax 合计含税金额

ads层

ods_m_sell_clientschannel  渠道id 税号industry 行业province 省份

dwd_qx_user_authuser_id  用户idsource_id 去重来源id

sh_ads_kaipiao_todaytoday 日期invoice_kind 类型channel 渠道industry 行业province 省份billing_merchants 有效商户数quantity_invoice 当天开票量total_quantity_invoice 累计开票量success_invoice 当天成功开票量total_success_invoice 累计开票成功量fail_invoice 当天失败开票量total_fail_invoice 累计开票失败量one_success_invoice 一次开票成功量count_1w_money  当天金额大于1w商户数ticket_total_amount  当天总金额大于20w商户数

dw_i_invoice_dailyinvoice_num 每天发票数source 来源today 日期effective_invoice_num有效发票数

qx_user_authuser_id  用户idsource_id 来源id

dwd_i_invoiceuser_id  用户idinvoice_id 发票idsource 发票来源today 日期

dws_i_invoice_dailyuser_id  用户idinvoice_id 开票idsource 发票来源today 日期union_id有效开票id

dws_m_sell_clientschannel  渠道id 税号industry 行业province 省份

云票b端

i_invoiceuser_id  用户idinvoice_id 发票idsource 发票来源created_at 创建日期