vop_sku_stock
唯品会购物车冻结表
所属应用: vop
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | 自增主键ID | int(10) unsigned | Y | Y | |
| barcode | 条形码 | varchar(200) | Y | N | |
| bm_id | 基础物料ID | int(10) unsigned | N | N | |
| material_bn | 基础物料编码 | varchar(200) | Y | N | |
| shop_bn | 店铺编码 | varchar(30) | Y | N | |
| shop_id | 店铺名称 | varchar(32) | N | N | |
| leaving_stock | 剩余库存 | mediumint(8) unsigned | N | 1 | N |
| current_hold | 目前为购物车+未支付订单占用的库存值 | mediumint(8) unsigned | N | 1 | N |
| unpaid_hold | 未支付占用数 | mediumint(8) unsigned | N | 1 | N |
| circuit_break_value | 熔断值 | mediumint(8) unsigned | N | 1 | N |
| area_warehouse_id | 分区仓库代码ID | mediumint(8) unsigned | N | 1 | N |
| warehouse_flag | (0或者null)全国逻辑仓或7大仓 1：省仓编码 | mediumint(8) unsigned | N | 1 | N |
| at_time | 创建时间 | TIMESTAMP | N | CURRENT_TIMESTAMP | N |
| up_time | 更新时间 | TIMESTAMP | N | CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_shop_material_bn | shop_id, material_bn | Y | |
| ind_shop_barcode | shop_id, barcode | Y | |
| ind_barcode | barcode | N | |
| ind_material_bn | material_bn | N | |
| ind_at_time | at_time | N | |
| ind_up_time | up_time | N | |
| idx_c_bm_id | bm_id | N | |
| idx_c_shop_id | shop_id | N |