ome_delivery_items_storagelife
发货单货品保质期批次表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| item_storagelife_id | item_storagelife_id | int(10) unsigned | Y | Y | |
| delivery_id | delivery_id | int(10) unsigned | Y | 0 | N |
| bm_id | bm_id | int(10) unsigned | Y | 0 | N |
| bn | bn | varchar(30) | N | N | |
| product_name | product_name | varchar(200) | N | N | |
| expire_bn | 保质期批次号 | varchar(200) | Y | N | |
| number | 数量 | mediumint(8) unsigned | Y | 0 | N |
| status | 状态 | tinyint(1) | Y | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | item_storagelife_id | Y | |
| idx_c_expire_bn | expire_bn | N | |
| idx_c_delivery_id | delivery_id | N | |
| idx_c_bm_id | bm_id | N |