商品表

<ul> <li>admin_shop_good 商品表</li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int (10)</td> <td>否</td> <td></td> <td>自增ID</td> </tr> <tr> <td>goods_name</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_price</td> <td>decimal (10)</td> <td>是</td> <td></td> <td>商品价格</td> </tr> <tr> <td>market_price</td> <td>decimal (10)</td> <td>是</td> <td></td> <td>市场价格</td> </tr> <tr> <td>cost_price</td> <td>decimal (10)</td> <td>是</td> <td></td> <td>成本价</td> </tr> <tr> <td>goods_number</td> <td>int (10)</td> <td>是</td> <td></td> <td>商品数量</td> </tr> <tr> <td>frozen_number</td> <td>int (10)</td> <td>是</td> <td></td> <td>冻结数量</td> </tr> <tr> <td>goods_remark</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>商品简单描述</td> </tr> <tr> <td>goods_desc</td> <td>text</td> <td>是</td> <td></td> <td>详细介绍</td> </tr> <tr> <td>goods_logo</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>商品logo</td> </tr> <tr> <td>type_id</td> <td>int (10)</td> <td>是</td> <td></td> <td>商品类型id</td> </tr> <tr> <td>brand_id</td> <td>int (10)</td> <td>是</td> <td></td> <td>品牌ID</td> </tr> <tr> <td>cate_id</td> <td>int (10)</td> <td>是</td> <td></td> <td>商品分类ID</td> </tr> <tr> <td>mould_id</td> <td>int (10)</td> <td>是</td> <td></td> <td>运费模板id</td> </tr> <tr> <td>weight</td> <td>double (10)</td> <td>是</td> <td></td> <td>商品重量</td> </tr> <tr> <td>volume</td> <td>double (10)</td> <td>是</td> <td></td> <td>商品体积</td> </tr> <tr> <td>keywords</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>关键词</td> </tr> <tr> <td>comments_num</td> <td>int (11)</td> <td>是</td> <td></td> <td>评论</td> </tr> <tr> <td>collect_num</td> <td>int (11)</td> <td>是</td> <td></td> <td>收藏数</td> </tr> <tr> <td>sale_num</td> <td>int (10)</td> <td>是</td> <td></td> <td>销量</td> </tr> <tr> <td>is_on_sale</td> <td>tinyint (1)</td> <td>是</td> <td></td> <td>是否上架</td> </tr> <tr> <td>is_free_shipping</td> <td>tinyint (1)</td> <td>是</td> <td></td> <td>是否包邮</td> </tr> <tr> <td>is_recommend</td> <td>tinyint (1)</td> <td>是</td> <td></td> <td>是否推荐</td> </tr> <tr> <td>is_new</td> <td>tinyint (1)</td> <td>是</td> <td></td> <td>是否新品</td> </tr> <tr> <td>is_hot</td> <td>tinyint (1)</td> <td>是</td> <td></td> <td>是否热卖</td> </tr> <tr> <td>sort</td> <td>smallint (6)</td> <td>是</td> <td></td> <td>排序</td> </tr> <tr> <td>suppliers_id</td> <td>smallint (6)</td> <td>是</td> <td></td> <td>供应商</td> </tr> <tr> <td>goods_attr</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>商品属性值</td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td>是</td> <td></td> <td>创建时间</td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td>是</td> <td></td> <td>修改时间</td> </tr> <tr> <td>deleted_at</td> <td>timestamp</td> <td>是</td> <td></td> <td>删除时间</td> </tr> </tbody> </table>