Logical_Dim_Layer

有效的包裹，所在的节点，并进入节点时间

Table Background

商家域

dim_express_facility_zip_df

facility_idfacility_codefacility_namelgt_company_codelgt_company_namemanager_namemanager_phonedetailed_addresslongitude_coordinateslatitude_coordinatesprovince_nameprovince_codecity_namecity_codearea_namearea_codenode_typeactive_indicatorefficient_start_dateefficient_end_date

有效的包裹，所在的线段，并进入线段时间

Reference

Background

dim_express_edge_zip_df

edge_idsource_node_codesource_node_namesource_node_type(f/t)target_node_codetarget_node_nametarget_node_type(f/t)edge_type(f2t/t2t/t2f/f2f)edge_distance_kmcross_city_indicatorcross_province_indicatoractive_indicatorefficient_start_dateefficient_end_date

dim_express_vehicle_di

vehicle_license_numbervehicle_capacityvehicle_typevehicle_loadvehicle_cp

Issue/Dependent

fact_summary_mrd_lgt_event_finished_di

mail_noseller_idseller_nickbuyer_idbuyer_nickcp_codecp_namelgt_order_codenormalize_lg_order_codebiz_mord_idlgt_order_idsource_node_codesource_node_namesource_node_typesource_city_nametarget_node_codetarget_node_nametarget_node_typetarget_city_nameoperator_nameoperator_mobile_phoneaction_descriptionconsign_type_codeconsign_type_nametransfer_indicatorduplicate_indicatorarea_idevent_sourcetime_zonesource_node_occur_timestamptarget_node_occur_timestampspend_days_numberspend_hours_numberspend_minutes_numberspend_seconds_numberlgt_order_create_timestampprocess_timestamp

fact_detail_mrd_lgt_ord_event_active_node_di

mail_noseller_idseller_nickbuyer_idbuyer_nickcp_codecp_namelgt_order_codenormalize_lg_order_codebiz_mord_idlgt_order_idcurrent_node_codecurrent_node_namecurrent_node_typecurrent_city_nameoperator_nameoperator_mobile_phoneaction_descriptionaction_codeaction_nameaction_group_codeaction_group_nameconsign_type_codeconsign_type_nametransfer_indicatorduplicate_indicatorarea_idevent_sourcetime_zonecurrent_node_occur_timestampspend_days_numberspend_hours_numberspend_minutes_numberspend_seconds_numberlgt_order_create_timestampprocess_timestamp

Text Color

dim_exp_transfer_center_di

transfer_center_idtransfer_center_codetransfer_center_namelgt_company_namelgt_company_codeprovince_nameprovince_codecity_namecity_codearea_namearea_codedetailed_addresslongitude_coordinatelatitude_coordinatemanage_typetransportation_typemanager_namemanager_phoneleave_port_deadlinenode_type

dim_exp_transfer_center_zip_df

transfer_center_idtransfer_center_codetransfer_center_namelgt_company_namelgt_company_codeprovince_nameprovince_codecity_namecity_codearea_namearea_codedetailed_addresslongitude_coordinatelatitude_coordinatemanage_typetransportation_typemanager_namemanager_phoneleave_port_deadlinenode_typeactive_indicatorefficient_start_dateefficient_end_date

dim_mrd_action_di

action_nameaction_codeaction_group_nameaction_group_code

dim_express_courier_zip_df

courier_namecourier_phoneagelgt_company_codelgt_company_namefacility_namefacility_codecredit_level_numbernode_typeactive_indicatorefficient_start_dateefficient_end_date

dim_express_city_route_zip_df

route_idsource_province_namesource_province_codesource_city_namesource_city_codetarget_province_nametarget_province_codetarget_city_nametarget_city_codecross_city_indicatorcross_province_indicatorthrough_edge_groupthrough_edge_numberthrough_edge_total_distance_kmactive_indicatorefficient_start_dateefficient_end_date

买家域

结束的包裹，各个线段所用的时间

dim_express_city_route_di

route_idsource_province_namesource_province_codesource_city_namesource_city_codetarget_province_nametarget_province_codetarget_city_nametarget_city_codecross_city_indicatorcross_province_indicatorthrough_edge_groupthrough_edge_numberthrough_edge_total_distance_km

fact_detail_mrd_lgt_event_active_edge_di

mail_noseller_idseller_nickbuyer_idbuyer_nickcp_codecp_namelgt_order_codenormalize_lg_order_codebiz_mord_idlgt_order_idprevious_node_codeprevious_node_nameprevious_node_typeprevious_city_namenext_node_codenext_node_namenext_node_typenext_city_nameoperator_nameoperator_mobile_phoneaction_descriptionaction_codeaction_nameaction_group_codeaction_group_nameconsign_type_codeconsign_type_nametransfer_indicatorduplicate_indicatorarea_idevent_sourcetime_zonesource_node_occur_timestamptarget_node_occur_timestampspend_days_numberspend_hours_numberspend_minutes_numberspend_seconds_numberlgt_order_create_timestampprocess_timestamp

公共域

Dims

dim_express_edge_di

edge_idsource_node_codesource_node_namesource_node_type(f/t)target_node_codetarget_node_nametarget_node_type(f/t)edge_type(f2t/t2t/t2f/f2f)edge_distance_kmcross_city_indicatorcross_province_indicator

Fact

网络域

dim_express_facility_di

facility_idfacility_codefacility_namelgt_company_codelgt_company_namemanager_namemanager_phonedetailed_addresslongitude_coordinateslatitude_coordinatesprovince_nameprovince_codecity_namecity_codearea_namearea_codenode_type

结束的包裹，城市路由级别，并总共用的时间

fact_detail_mrd_lgt_event_finished_edge_di

dim_express_courier_di

courier_name(PK)courier_phone(PK)agelgt_company_codelgt_company_namefacility_namefacility_codecredit_level_numbernode_type