wap_delivery_items
移动端发货通知单明细表
所属应用: wap
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| item_id | item_id | int(10) unsigned | Y | Y | |
| outer_item_id | outer_item_id | int(10) unsigned | Y | N | |
| delivery_id | delivery_id | int(10) unsigned | Y | 0 | N |
| product_id | product_id | int(10) unsigned | Y | 0 | N |
| shop_product_id | shop_product_id | varchar(50) | N | N | |
| bn | bn | varchar(30) | N | N | |
| product_name | product_name | varchar(200) | N | N | |
| number | number | mediumint(8) unsigned | Y | 0 | N |
| verify | verify | enum('true','false') | Y | false | N |
| verify_num | verify_num | mediumint(8) unsigned | Y | 0 | N |
| price | price | decimal(20,3) | Y | 0 | N |
| sale_price | sale_price | decimal(20,3) | Y | 0 | N |
| pmt_price | pmt_price | decimal(20,3) | Y | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | item_id | Y | |
| idx_c_delivery_id | delivery_id | N | |
| idx_c_product_id | product_id | N |
