wms_order_objects
订单商品对象表(弃用)
所属应用: wms
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| obj_id | obj_id | int(10) unsigned | Y | N | |
| order_bn | order_bn | varchar(32) | Y | 0 | N |
| obj_type | obj_type | varchar(50) | Y | N | |
| goods_id | goods_id | int(10) unsigned | Y | 0 | N |
| bn | bn | varchar(40) | N | N | |
| name | name | varchar(200) | N | N | |
| price | price | decimal(20,3) | Y | 0 | N |
| quantity | quantity | mediumint(8) unsigned | Y | 1 | N |
| pmt_price | pmt_price | decimal(20,3) | N | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | obj_id | Y |