zqm_micro_goods
- 微商城推荐商品表随心看
| 字段 | 类型 | 允许空 | 默认 | 注释 |
|---|---|---|---|---|
| commend_id | int(10) unsigned | NO | NULL | 推荐编号 |
| commend_member_id | int(10) unsigned | NO | NULL | 推荐人用户编号 |
| commend_goods_id | int(10) unsigned | NO | NULL | 推荐商品编号 |
| commend_goods_commonid | int(10) unsigned | NO | NULL | 商品公共表id |
| commend_goods_store_id | int(10) unsigned | NO | NULL | 推荐商品店铺编号 |
| commend_goods_name | varchar(100) | NO | NULL | 推荐商品名称 |
| commend_goods_price | decimal(11,2) | NO | NULL | 推荐商品价格 |
| commend_goods_image | varchar(100) | NO | NULL | 推荐商品图片 |
| commend_message | varchar(1000) | NO | NULL | 推荐信息 |
| commend_time | int(10) unsigned | NO | NULL | 推荐时间 |
| class_id | int(10) unsigned | NO | NULL | 无 |
| like_count | int(10) unsigned | NO | 0 | 喜欢数 |
| comment_count | int(10) unsigned | NO | 0 | 评论数 |
| click_count | int(10) unsigned | NO | 0 | 点击数 |
| microshop_commend | tinyint(3) unsigned | NO | 0 | 首页推荐 0-否 1-推荐 |
| microshop_sort | tinyint(3) unsigned | NO | 255 | 排序 |