dealer_series_products
产品线绑物料
所属应用: dealer
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| sp_id | 产品线绑物料ID | int(10) unsigned | Y | Y | |
| series_id | 产品线ID | int(10) unsigned | N | N | |
| bm_id | 物料ID | int(10) unsigned | N | N | |
| op_name | 创建人 | varchar(32) | N | N | |
| at_time | 创建时间 | TIMESTAMP | N | CURRENT_TIMESTAMP | N |
| up_time | 更新时间 | TIMESTAMP | N | CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | sp_id | Y | |
| ind_series_id | series_id | N | |
| ind_bm_id | bm_id | N | |
| ind_at_time | at_time | N | |
| ind_up_time | up_time | N |