老带新数据流程图

字段一一对应

b_national_market_commission_payment_slip

b_national_market_qualification

xft_own_qualification_history

broker_id 业主idsales_id对应签约idbatch_id对应付款单idbpm_approve_status对应发放状态building_id对应楼盘idclient_id对应客户idamount对应佣金金额

老带新数据库（迁移表）

transfer_national_market_qualification

b_national_market_commission

xft_client_building_failed对应报备表报备失败数据xft_client_building_relation对应报备数据xft_client_building_visited对应到访数据xft_client_building_presale对应认购数据xft_client_building_sale对应签约数据通过relation表id关联到访1:1，关联认购签约1：n

xft_broker bxft_broker_approve ba

b_national_market_update_phone_log

tuozhou_judgement_customer_log

transfer_national_market_user

transfer_national_market_update_phone_log

transfer_national_market_recommend_custom

transfer_national_market_commission_payment_slip

xft_client_building_failedxft_client_building_relationxft_client_building_visitedxft_client_building_presalexft_client_building_sale

b_national_market_user

transfer_national_market_qualification_open_info

transfer_national_market_commission

xft_broker_mobile_operation_info

b_national_market_qualification_open_info

b_national_market_recommend_custom

xft_broker_payment

老带新数据库（原始表）

xft_broker_brokerage

b_national_market_modify_custom_detail

xft_own_qualification

transfer_national_market_modify_custom_detail

全员营销库