当站点被设置为分站点时，需要做的迁移动作
数量和sql，只写觉的重要的数据数量和sql，只写觉的重要的数据，以下数据为，假如19站点改为分站点后，要进行的操作
迁移项 | 备注 | 数量（19站点） | SQL |
|---|
客户站点开通 | 开通主站点, 设置分站点webhook | | |
库存 | 通过设置主站点容器，自动同步 | | |
库位 | N | | |
过道 | N | | |
库区 | N | | |
仓库 | N | | |
产品 | sql迁移到主站点
company_product
product_stock_level
product_stock_volume_level | | |
产品入库周期 | sql迁移到主站点 company_product_date_stock
company_product_stock_to_use
product_stock_daily_data
product_stock_daily_data_by_quantity client_temp_storage_volume_transaction client_company_date_temp_storage_volume client_company_temp_storage_volume_daily_data | | |
订单 | sql迁移到主站点
consignment | 19: 15070689 | | Code Block |
|---|
select count(id) from consignment where company_id in (19); |
|
订单产品 | 跟随订单 | 19: 5376313 | | Code Block |
|---|
select count(consignment_product.id) from consignment_product
inner join consignment on consignment.id = consignment_product.consignment_id
where company_id in (19); |
|
代理专线订单产品 | 跟随订单 | 19: 11271884 | | Code Block |
|---|
select count(agent_direct_consignment_product.id) from agent_direct_consignment_product
inner join consignment on consignment.id = agent_direct_consignment_product.consignment_id
where consignment.company_id in (19); |
|
邮递服务 | sql迁移到主站点，需改名字
delivery_service | 19: 639 | | Code Block |
|---|
select * from delivery_service where company_id in (19); |
|
服务商 | sql迁移到主站点
consignment_delivery_agent | 19: 23 | | Code Block |
|---|
select * from consignment_delivery_agent where company_id = 19; |
|
服务商账号 | sql迁移到主站点
consignment_delivery_agent_account
consignment_delivery_agent_account_config | | |
包裹尺寸 | 邮递服务相关 | 客户组 | sql迁移到主站点
delivery_package_size | 19：94 | | Code Block |
|---|
select * from delivery_package_size where company_id in (19); |
|
邮递服务服务类型 | sql迁移到主站点
delivery_service_service_type | | |
客户组 | sql迁移到主站点
client_group | | |
邮费，手续费，仓储费，邮票 | 跟随客户组，邮递服务，包裹尺寸 | | |
客户发货单 | N | | |
提单 | N | | |
物流计划 | N | | |
批次&箱&包裹 | N | | |
仓库调拨单&仓库调拨箱 | N | | |