阿里巴巴新零售数据库设计(简化版)

最新推荐文章于 2023-03-09 08:25:06 发布

Gavincoder

最新推荐文章于 2023-03-09 08:25:06 发布

阅读量1.6k

点赞数

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/weixin_39200308/article/details/107497918

版权

本文详细介绍了阿里巴巴新零售数据库的设计，包括基础概念如SPU和SKU，以及表结构设计，如品类表、参数表、品牌表、商品分类表、会员等级表、订单表等。此外，还探讨了如何处理库存、采购、物流、退货和商品评价等关键业务流程，并提供了防止商品信息被篡改的策略。

摘要由CSDN通过智能技术生成

阿里巴巴新零售数据库设计(简化版)

语雀地址：https://www.yuque.com/gavincoder/ngs5gi/upkm1p#WXQOv

![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2MzI3MTE4MDQtYWFkNjQzNWItMWFiMC00YTA2LWI5NDEtMTgwN2NjODEzZmY0LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=298&margin=[object Object]&name=image.png&originHeight=596&originWidth=1032&size=161823&status=done&style=none&width=516)

基础概念

SPU

Standard Product Unit 标准产品单位
SPU描述一个产品的各种特性

什么时候用到SPU?

想买个ipad,搜ipad .
平台先去产品表搜id,然后再去商品表搜数据
因为产品表SPU数量远远小于商品表,这样可以很快获得商品信息

SKU

Stock Keeping Unit 库存进出计量单位
SKU是物理上不可分割的最小存货单位

库存字段,理论上应该放到SKU商品表与仓库表的交叉表内

SKU与权重

新零售平台主要是B2C的,所以修改SKU对权重的影响不大.
但是B2B的平台,修改SKU对商品权重影响很大 (约束商家修改SKU赖账之类,如"全新进口"在客户购买后改成了"国产")

SKU与参数如何对应

品类不同,参数不同
采用1对多的数据结构
![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2MzM5MzUwMTEtNTUzMDE0MzMtMzNlNC00ODU0LWE0MjItNjZiNmI2ODAwY2E4LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=161&margin=[object Object]&name=image.png&originHeight=321&originWidth=558&size=27251&status=done&style=none&width=279)![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2MzM5NzM5NDYtNzE3NGRiYjQtYTRmYy00ZTM2LWI3ODQtNjQyNDMyMWI3NmM2LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=167&margin=[object Object]&name=image.png&originHeight=334&originWidth=603&size=28835&status=done&style=none&width=302)

新零售系统的进销存属性

员工发货/角色权限定义
![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2NDM0NjIzNDQtNDgyMjJkYjAtNDZkNi00Y2ZmLWI4ZGYtNDEwZWViYjhjZGUxLnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=125&margin=[object Object]&name=image.png&originHeight=250&originWidth=498&size=29572&status=done&style=none&width=249)

商品采购与入库

![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2NDQ2MTQwODctNGQ3ZTY5YzItZWMyMS00N2FiLThiYWItYjI1ZDRkNmMzZTE4LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=212&margin=[object Object]&name=image.png&originHeight=424&originWidth=801&size=74838&status=done&style=none&width=401)

表结构设计知识点总览

![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2NDQ4MDIyMDYtOTkxNzA2OGEtZGEwYS00YWRmLTgyNTktNzA0MTliNzc2MWE1LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=254&margin=[object Object]&name=image.png&originHeight=339&originWidth=868&size=68450&status=done&style=none&width=651)

表结构设计

品类表

![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2MzkyNzcyNjgtZmNhYWRkYTMtOTIzNS00ZDBlLWExZGItOTVlOWYzYjhlOTBmLnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=144&margin=[object Object]&name=image.png&originHeight=287&originWidth=656&size=43055&status=done&style=none&width=328)![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2MzkyOTExMDUtNjFiYmM4ZTktZjA2Yi00M2MxLWEwZTUtZjQ0MDVhYTU4NmVjLnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=134&margin=[object Object]&name=image.png&originHeight=178&originWidth=274&size=23920&status=done&style=none&width=206)![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2Mzk0MTg5NzYtNDQ2MzE1MTQtYzNkNS00Yzg4LWE4ZTItMGIxMjllYWQ5M2MyLnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=139&margin=[object Object]&name=image.png&originHeight=139&originWidth=211&size=28229&status=done&style=none&width=211)

参数表

boolean类型在mysql中是tinyint(1)

![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2Mzk0MzQzMDEtOWQ4NjQyMDEtZDc3My00MDg3LThlMWUtODM4ZmQ4ZDkwYWU5LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=197&margin=[object Object]&name=image.png&originHeight=394&originWidth=614&size=105021&status=done&style=none&width=307)![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2Mzk1NTU2NTQtOTQ0MWU0NTctZGFjYS00NjQ3LWIwMGUtMGIyODk2MzFiOWI4LnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=212&margin=[object Object]&name=image.png&originHeight=356&originWidth=281&size=45647&status=done&style=none&width=167)![image.png](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvMzA4OTE4LzE1OTQ2Mzk2Mjk1NjItNWQ2OGFiYTktY2MxZC00MzQ5LWEzYzItODdiZWZjZTA5MDZlLnBuZw?x-oss-process=image/format,png#align=left&display=inline&height=243&margin=[object Object]&name=image.png&originHeight=243&originWidth=715&size=114429&status&#