ome_reship_items_serial
退货单货品唯一码表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| item_serial_id | item_serial_id | int(10) unsigned | Y | Y | |
| reship_id | reship_id | int(10) unsigned | Y | 0 | N |
| product_id | product_id | int(10) unsigned | Y | 0 | N |
| bn | bn | varchar(30) | N | N | |
| product_name | product_name | varchar(200) | N | N | |
| serial_number | 唯一码 | varchar(30) | Y | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | item_serial_id | Y | |
| idx_c_serial_number | serial_number | N | |
| idx_c_reship_id | reship_id | N | |
| idx_c_product_id | product_id | N |