商品信息

<ul> <li>mall_product_info </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int (11)</td> <td>否</td> <td></td> <td>主键</td> </tr> <tr> <td>product_number</td> <td>varchar (64)</td> <td>是</td> <td></td> <td>编号</td> </tr> <tr> <td>product_name</td> <td>varchar (64)</td> <td>是</td> <td></td> <td>商品名称</td> </tr> <tr> <td>product_price</td> <td>decimal (10)</td> <td>是</td> <td></td> <td>商品价格</td> </tr> <tr> <td>product_desc</td> <td>longtext</td> <td>是</td> <td></td> <td>商品描述</td> </tr> <tr> <td>type_id</td> <td>int (11)</td> <td>是</td> <td></td> <td>商品类型</td> </tr> <tr> <td>img</td> <td>varchar (600)</td> <td>是</td> <td></td> <td>商品主图</td> </tr> <tr> <td>brand</td> <td>varchar (32)</td> <td>是</td> <td></td> <td>品牌信息</td> </tr> <tr> <td>product_count</td> <td>int (11)</td> <td>是</td> <td></td> <td>商品库存</td> </tr> <tr> <td>status</td> <td>char (2)</td> <td>是</td> <td></td> <td>商品状态</td> </tr> <tr> <td>redundancy</td> <td>varchar (600)</td> <td>是</td> <td></td> <td>冗余字段</td> </tr> <tr> <td>version</td> <td>int (2)</td> <td>是</td> <td></td> <td>乐观锁</td> </tr> <tr> <td>create_by</td> <td>int (11)</td> <td>是</td> <td></td> <td>创建人</td> </tr> <tr> <td>create_time</td> <td>timestamp</td> <td>是</td> <td>CURRENT_TIMESTAMP</td> <td>创建时间</td> </tr> <tr> <td>update_by</td> <td>int (11)</td> <td>是</td> <td></td> <td>修改人</td> </tr> <tr> <td>update_time</td> <td>timestamp</td> <td>是</td> <td>CURRENT_TIMESTAMP</td> <td>修改时间</td> </tr> <tr> <td>deleted</td> <td>char (2)</td> <td>是</td> <td>n</td> <td>逻辑删除</td> </tr> </tbody> </table>