omeanalysts_sale_products
已销售产品
所属应用: omeanalysts
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | ID | int(10) unsigned | Y | Y | |
| product_id | 货号 | int(10) unsigned | N | N | |
| branch_id | 仓库 | mediumint(8) unsigned | N | N | |
| sales_nums | 销量 | mediumint(8) unsigned | N | N | |
| sales_price | 销售单价 | decimal(20,3) | N | N | |
| sales_time | 销售时间 | int(10) unsigned | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_sales_time | sales_time | N | |
| idx_c_product_id | product_id | N | |
| idx_c_branch_id | branch_id | N |