okr_okrshop_goods_comment

<h4>okr_okrshop_goods_comment 商品评论</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td>NO</td> <td></td> <td>ID</td> </tr> <tr> <td>user_id</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>用员ID</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>店铺ID</td> </tr> <tr> <td>order_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>订单ID</td> </tr> <tr> <td>goods_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>商品ID</td> </tr> <tr> <td>order_type</td> <td>enum('goods','groups','seckill')</td> <td>YES</td> <td>goods</td> <td>订单类型:goods=普通订单,groups=拼团订单,seckill=秒杀订单</td> </tr> <tr> <td>order_goods_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>订单商品ID</td> </tr> <tr> <td>state</td> <td>enum('0','1','2')</td> <td>NO</td> <td>1</td> <td>评价:0=好评,1=中评,2=差评</td> </tr> <tr> <td>content</td> <td>text</td> <td>YES</td> <td></td> <td>内容</td> </tr> <tr> <td>tag</td> <td>varchar(500)</td> <td>YES</td> <td></td> <td>评论标签</td> </tr> <tr> <td>suk</td> <td>text</td> <td>NO</td> <td></td> <td>所购买商品SUK</td> </tr> <tr> <td>images</td> <td>varchar(1500)</td> <td>YES</td> <td></td> <td>图片组</td> </tr> <tr> <td>score</td> <td>float(3,1) unsigned</td> <td>YES</td> <td>0.0</td> <td>综合评分</td> </tr> <tr> <td>score_describe</td> <td>float(3,1) unsigned</td> <td>YES</td> <td>0.0</td> <td>描述相符</td> </tr> <tr> <td>score_service</td> <td>float(3,1) unsigned</td> <td>YES</td> <td>0.0</td> <td>服务相符</td> </tr> <tr> <td>score_deliver</td> <td>float(3,1) unsigned</td> <td>YES</td> <td>0.0</td> <td>发货相符</td> </tr> <tr> <td>score_logistics</td> <td>float(3,1) unsigned</td> <td>YES</td> <td>0.0</td> <td>物流相符</td> </tr> <tr> <td>switch</td> <td>tinyint(1)</td> <td>YES</td> <td>0</td> <td>匿名评论</td> </tr> <tr> <td>createtime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>updatetime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>更新时间</td> </tr> <tr> <td>deletetime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>删除时间</td> </tr> <tr> <td>status</td> <td>enum('normal','hidden')</td> <td>YES</td> <td>normal</td> <td>状态</td> </tr> </tbody> </table>