okr_okrshop_goods

<h4>okr_okrshop_goods 商品表</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>shop_id</td> <td>int(10) unsigned</td> <td>YES</td> <td>0</td> <td>店铺ID</td> </tr> <tr> <td>shop_category_id</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>店铺内类目</td> </tr> <tr> <td>category_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>商品类目</td> </tr> <tr> <td>brand_id</td> <td>int(10) unsigned</td> <td>YES</td> <td>0</td> <td>品牌ID</td> </tr> <tr> <td>category_attribute</td> <td>longtext</td> <td>YES</td> <td></td> <td>类目属性</td> </tr> <tr> <td>title</td> <td>varchar(100)</td> <td>NO</td> <td></td> <td>商品标题</td> </tr> <tr> <td>image</td> <td>varchar(100)</td> <td>NO</td> <td></td> <td>商品主图</td> </tr> <tr> <td>images</td> <td>varchar(1500)</td> <td>NO</td> <td></td> <td>产品相册</td> </tr> <tr> <td>description</td> <td>varchar(255)</td> <td>NO</td> <td></td> <td>商品描述</td> </tr> <tr> <td>flag</td> <td>set('hot','index','recommend')</td> <td>NO</td> <td></td> <td>标志(多选):hot=热门,index=首页,recommend=推荐</td> </tr> <tr> <td>stock</td> <td>enum('porder','payment')</td> <td>NO</td> <td>porder</td> <td>库存计算方式:porder=下单减库存,payment=付款减库存</td> </tr> <tr> <td>content</td> <td>longtext</td> <td>NO</td> <td></td> <td>商品详情</td> </tr> <tr> <td>freight_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>运费模板</td> </tr> <tr> <td>grounding</td> <td>tinyint(1)</td> <td>NO</td> <td>0</td> <td>上架状态</td> </tr> <tr> <td>specs</td> <td>enum('single','multi')</td> <td>NO</td> <td>single</td> <td>商品规格:single=单规格,multi=多规格</td> </tr> <tr> <td>distribution</td> <td>enum('true','false')</td> <td>NO</td> <td>false</td> <td>是否独立分销:true=开启,false=关闭</td> </tr> <tr> <td>activity</td> <td>enum('0','1')</td> <td>NO</td> <td>0</td> <td>活动中:0=没在活动中,1=活动中</td> </tr> <tr> <td>activity_id</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>活动ID</td> </tr> <tr> <td>activity_type</td> <td>enum('goods','groups','seckill','bargain')</td> <td>NO</td> <td>goods</td> <td>活动类型:goods=商品,groups=拼团,seckill=秒杀,bargain=砍价</td> </tr> <tr> <td>views</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>点击</td> </tr> <tr> <td>price</td> <td>decimal(10,2)</td> <td>YES</td> <td>0.00</td> <td>产品价格</td> </tr> <tr> <td>sales</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>销量</td> </tr> <tr> <td>payment</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>付款人数</td> </tr> <tr> <td>comment</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>评论</td> </tr> <tr> <td>praise</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>好评</td> </tr> <tr> <td>moderate</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>中评</td> </tr> <tr> <td>negative</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>差评</td> </tr> <tr> <td>like</td> <td>int(10) unsigned</td> <td>NO</td> <td>0</td> <td>收藏</td> </tr> <tr> <td>weigh</td> <td>int(10)</td> <td>NO</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>