Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

当站点被设置为主站点时，需要做的迁移动作。假设主站点是1站点和36站点

数量和sql，只写觉的重要的数据

迁移项

备注

数量（1站点，36站点）

SQL

客户站点开通

库存

跟随库位

1: 72215

36: 1502

select count(*) from container_product 
inner join container on container.id = container_id
inner join aisle on aisle.id = container.aisle_id
inner join zone on zone.id = zone_id
inner join warehouse on warehouse.id = warehouse_id
where warehouse.company_id = 1 and container.status = 'ACTIVE';

库位

跟随过道

1：843115

36: 23044

select count(container.id) from container 
inner join aisle on aisle.id = container.aisle_id
inner join zone on zone.id = zone_id
inner join warehouse on warehouse.id = warehouse_id
where warehouse.company_id = 1 and container.status = 'ACTIVE';

过道

跟随库区

库区

跟随仓库

仓库

修改仓库的站点id为分站点id，需要确认好，仓库要移到哪个分站点

  • No labels