archive_reship_items
所属应用: archive
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| item_id | 明细ID | mediumint(8) unsigned | Y | Y | |
| reship_id | 退换货单号 | int(10) unsigned | Y | N | |
| obj_id | obj_id | mediumint(8) unsigned | Y | 0 | N |
| bn | 货品bn | varchar(30) | Y | N | |
| product_name | 货品名称 | varchar(200) | N | N | |
| product_id | 货品ID | int(10) unsigned | N | N | |
| num | 数量 | mediumint(8) unsigned | Y | 1 | N |
| price | price | decimal(20,3) | Y | 0 | N |
| branch_id | 仓库ID | mediumint(8) unsigned | N | N | |
| op_id | op_id | mediumint(8) unsigned | N | N | |
| return_type | 退换货类型 return:退货;change:换货;refuse:拒收退货; | enum('return','change','refuse') | Y | return | N |
| defective_num | 不良品 | mediumint(8) unsigned | Y | 0 | N |
| normal_num | 良品 | mediumint(8) unsigned | Y | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | item_id | Y | |
| ind_bn | bn | N | |
| idx_c_op_id | op_id | N |