omeanalysts_products_sale
产品销售排行榜
所属应用: omeanalysts
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | ID | int(10) unsigned | Y | Y | |
| shop_id | 来源店铺 | varchar(32) | N | N | |
| bn | 货号 | varchar(60) | N | 0 | N |
| name | 货品名称(规格) | varchar(200) | N | 0 | N |
| sales_num | 销售量 | mediumint(8) unsigned | N | 0 | N |
| sales_amount | 销售额 | decimal(20,3) | N | 0 | N |
| brand_id | 品牌 | mediumint(8) unsigned | N | N | |
| sales_time | 销售时间 | int(10) unsigned | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_bnsalestime | bn, sales_time | N | |
| idx_c_shop_id | shop_id | N | |
| idx_c_brand_id | brand_id | N |
