<div class="container"> <h1 style="text-align: center;">b2c 数据字典</h1> <h3>nc_cms_articleCMS文章表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>article_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>文章编号</td> </tr> <tr> <td>title</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>文章标题</td> </tr> <tr> <td>class_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>文章分类编号</td> </tr> <tr> <td>short_title</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>文章短标题</td> </tr> <tr> <td>source</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>文章来源</td> </tr> <tr> <td>url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>文章来源链接</td> </tr> <tr> <td>author</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>文章作者</td> </tr> <tr> <td>summary</td> <td>varchar(140)</td> <td></td> <td>NO</td> <td></td> <td>文章摘要</td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>文章正文</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>文章标题图片</td> </tr> <tr> <td>keyword</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>文章关键字</td> </tr> <tr> <td>article_id_array</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>相关文章</td> </tr> <tr> <td>click</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>文章点击量</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>commend_flag</td> <td>tinyint(1) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>文章推荐标志0-未推荐,1-已推荐</td> </tr> <tr> <td>comment_flag</td> <td>tinyint(1) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>文章是否允许评论1-允许,0-不允许</td> </tr> <tr> <td>status</td> <td>tinyint(1) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>0-草稿、1-待审核、2-已发布、-1-回收站</td> </tr> <tr> <td>attachment_path</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>文章附件路径</td> </tr> <tr> <td>tag</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>文章标签</td> </tr> <tr> <td>comment_count</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>文章评论数</td> </tr> <tr> <td>last_comment_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>最新评论时间</td> </tr> <tr> <td>share_count</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>文章分享数</td> </tr> <tr> <td>publisher_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>发布者用户名</td> </tr> <tr> <td>uid</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>发布者编号</td> </tr> <tr> <td>public_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>发布时间</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>文章发布时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>文章修改时间</td> </tr> </tbody> </table> <h3>nc_cms_article_classcms文章分类表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>class_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>分类编号</td> </tr> <tr> <td>pid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>上级分类</td> </tr> <tr> <td>name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>分类名称</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>nc_cms_commentCMS评论表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>comment_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>评论编号</td> </tr> <tr> <td>text</td> <td>varchar(2000)</td> <td></td> <td>NO</td> <td></td> <td>评论内容</td> </tr> <tr> <td>uid</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>评论人编号</td> </tr> <tr> <td>quote_comment_id</td> <td>int(11) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>评论引用</td> </tr> <tr> <td>up</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>点赞数量</td> </tr> <tr> <td>comment_time</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>评论时间</td> </tr> </tbody> </table> <h3>nc_cms_topic专题</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>topic_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>专题编号</td> </tr> <tr> <td>instance_id</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>title</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>专题标题</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>专题封面</td> </tr> <tr> <td>status</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>专题状态 0草稿 1发布</td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>专题内容</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_account商城资金统计</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>account_id</td> <td>int(10)</td> <td></td> <td>NO</td> <td>是</td> <td>账户ID</td> </tr> <tr> <td>account_profit</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>平台的总营业额</td> </tr> <tr> <td>account_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>平台资金总余额</td> </tr> <tr> <td>account_return</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>平台利润总额</td> </tr> <tr> <td>account_deposit</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>保证金总额</td> </tr> <tr> <td>account_order</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商城订单总额</td> </tr> <tr> <td>account_withdraw</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商城提现总额</td> </tr> <tr> <td>account_shop</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺总余额</td> </tr> <tr> <td>account_shop_withdraw</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺总提现</td> </tr> </tbody> </table> <h3>ns_account_assistant_records招商员支付记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>serial_no</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>流水号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>对应金额</td> </tr> <tr> <td>account_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>账户类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> </tbody> </table> <h3>ns_account_order_records金额账户记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>serial_no</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>流水号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>对应金额</td> </tr> <tr> <td>account_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>账户类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> </tbody> </table> <h3>ns_account_period商城账期结算表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>period_id</td> <td>int(10)</td> <td></td> <td>NO</td> <td>是</td> <td>账户ID</td> </tr> <tr> <td>period_year</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td>账期年份</td> </tr> <tr> <td>period_month</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td>账期月份</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>结束时间</td> </tr> <tr> <td>account_profit</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期总营业额</td> </tr> <tr> <td>account_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期总发生余额</td> </tr> <tr> <td>account_return</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期利润总额</td> </tr> <tr> <td>account_deposit</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期保证金总额</td> </tr> <tr> <td>account_order</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期订单总额</td> </tr> <tr> <td>account_withdraw</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期店铺提现总额</td> </tr> <tr> <td>account_shop</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期店铺总发生额</td> </tr> <tr> <td>account_shop_withdraw</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>账期店铺总提现额</td> </tr> </tbody> </table> <h3>ns_account_records金额账户记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>对应金额</td> </tr> <tr> <td>account_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>账户类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>is_display</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否显示</td> </tr> <tr> <td>is_calculate</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否参与计算</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> </tbody> </table> <h3>ns_account_return_records平台的利润的记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>金额</td> </tr> <tr> <td>return_type</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>提成类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>关联id</td> </tr> <tr> <td>is_display</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否显示</td> </tr> <tr> <td>is_calculate</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否计算</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_account_withdraw_records金额账户记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>serial_no</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>流水号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>对应金额</td> </tr> <tr> <td>account_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>账户类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> </tbody> </table> <h3>ns_account_withdraw_user_records会员提现记录表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>serial_no</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>流水号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>对应金额</td> </tr> <tr> <td>account_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>账户类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> </tbody> </table> <h3>ns_attribute商品相关属性</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>attr_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>商品属性ID</td> </tr> <tr> <td>attr_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性名称</td> </tr> <tr> <td>is_use</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否使用</td> </tr> <tr> <td>spec_id_array</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>关联规格</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_attribute_value商品属性值</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>attr_value_id</td> <td>int(11) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>属性值ID</td> </tr> <tr> <td>attr_value_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>属性值名称</td> </tr> <tr> <td>attr_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>属性ID</td> </tr> <tr> <td>value</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>属性对应相关数据</td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>属性对应输入类型1.直接2.单选3.多选</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>1999</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>is_search</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否使用</td> </tr> </tbody> </table> <h3>ns_cart购物车表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>cart_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>购物车id</td> </tr> <tr> <td>buyer_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>买家id</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>shop_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品id</td> </tr> <tr> <td>goods_name</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>sku_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品的skuid</td> </tr> <tr> <td>sku_name</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>商品的sku名称</td> </tr> <tr> <td>price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品价格</td> </tr> <tr> <td>num</td> <td>smallint(5)</td> <td>1</td> <td>NO</td> <td></td> <td>购买商品数量</td> </tr> <tr> <td>goods_picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>bl_id</td> <td>mediumint(8)</td> <td>0</td> <td>NO</td> <td></td> <td>组合套装ID</td> </tr> </tbody> </table> <h3>ns_consult咨询类型表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>consult_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>咨询编号</td> </tr> <tr> <td>goods_id</td> <td>int(11) unsigned</td> <td>0</td> <td>YES</td> <td></td> <td>商品编号</td> </tr> <tr> <td>goods_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>咨询发布者会员编号(0:游客)</td> </tr> <tr> <td>member_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>会员名称</td> </tr> <tr> <td>shop_id</td> <td>int(11) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>店铺编号</td> </tr> <tr> <td>shop_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>ct_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>咨询类型</td> </tr> <tr> <td>consult_content</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>咨询内容</td> </tr> <tr> <td>consult_addtime</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>咨询发布时间</td> </tr> <tr> <td>consult_reply</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>咨询回复内容</td> </tr> <tr> <td>consult_reply_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>咨询回复时间</td> </tr> <tr> <td>isanonymous</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>0表示不匿名 1表示匿名</td> </tr> </tbody> </table> <h3>ns_consult_type咨询类型表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>ct_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>咨询类型id</td> </tr> <tr> <td>ct_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>咨询类型名称</td> </tr> <tr> <td>ct_introduce</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>咨询类型详细介绍</td> </tr> <tr> <td>ct_sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>ns_coupon优惠券表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>coupon_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>优惠券id</td> </tr> <tr> <td>coupon_type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>优惠券类型id</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺Id</td> </tr> <tr> <td>coupon_code</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>优惠券编码</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>领用人</td> </tr> <tr> <td>use_order_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>优惠券使用订单id</td> </tr> <tr> <td>create_order_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>创建订单id(优惠券只有是完成订单发放的优惠券时才有值)</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>面额</td> </tr> <tr> <td>fetch_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>领取时间</td> </tr> <tr> <td>use_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>使用时间</td> </tr> <tr> <td>state</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>优惠券状态 0未领用 1已领用(未使用) 2已使用 3已过期</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>有效期开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>有效期结束时间</td> </tr> <tr> <td>get_type</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>获取方式1订单2.首页领取</td> </tr> </tbody> </table> <h3>ns_coupon_goods优惠券使用商品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>coupon_type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>优惠券类型id</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品id</td> </tr> </tbody> </table> <h3>ns_coupon_type优惠券类型表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>coupon_type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>优惠券类型Id</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>coupon_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>优惠券名称</td> </tr> <tr> <td>money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>发放面额</td> </tr> <tr> <td>count</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>发放数量</td> </tr> <tr> <td>max_fetch</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>每人最大领取个数 0无限制</td> </tr> <tr> <td>at_least</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>满多少元使用 0代表无限制</td> </tr> <tr> <td>need_user_level</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>领取人会员等级</td> </tr> <tr> <td>range_type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>使用范围0部分产品使用 1全场产品使用</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>有效日期开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>有效日期结束时间</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>update_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>is_show</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否允许首页显示0不显示1显示</td> </tr> </tbody> </table> <h3>ns_express_company物流公司</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>co_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>表序号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商铺id</td> </tr> <tr> <td>company_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>物流公司名称</td> </tr> <tr> <td>express_no</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>物流编号</td> </tr> <tr> <td>is_enabled</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>使用状态</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>物流公司模版图片</td> </tr> <tr> <td>phone</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>联系电话</td> </tr> <tr> <td>orders</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>express_logo</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>公司logo</td> </tr> </tbody> </table> <h3>ns_express_shipping运单模板</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>sid</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>运单模版id</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>template_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>模版名称</td> </tr> <tr> <td>co_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>物流公司 id</td> </tr> <tr> <td>size_type</td> <td>smallint(6)</td> <td>1</td> <td>NO</td> <td></td> <td>尺寸类型 1像素px 2毫米mm</td> </tr> <tr> <td>width</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>宽度</td> </tr> <tr> <td>height</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>长度</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>快递单图片</td> </tr> </tbody> </table> <h3>ns_express_shipping_items物流模板打印项</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>sid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>运单模版id</td> </tr> <tr> <td>field_name</td> <td>varchar(30)</td> <td></td> <td>NO</td> <td></td> <td>字段名称</td> </tr> <tr> <td>field_display_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>打印项名称</td> </tr> <tr> <td>is_print</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>是否打印</td> </tr> <tr> <td>x</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>x</td> </tr> <tr> <td>y</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>y</td> </tr> </tbody> </table> <h3>ns_express_shipping_items_library物流模版打印项库</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>Id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>物流模版打印项库ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>field_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>字段名</td> </tr> <tr> <td>field_display_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>字段显示名</td> </tr> <tr> <td>is_enabled</td> <td>bit(1)</td> <td>b'1'</td> <td>NO</td> <td></td> <td>是否启用</td> </tr> </tbody> </table> <h3>ns_gift_grant_records赠品发放记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>gift_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>赠送活动ID</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>赠送商品ID</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>赠送商品名称</td> </tr> <tr> <td>goods_img</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>赠送商品图片</td> </tr> <tr> <td>num</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>赠送数量</td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>发放方式</td> </tr> <tr> <td>type_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>发放相关ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>赠送时间</td> </tr> <tr> <td>memo</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_goods商品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>goods_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>商品id(SKU)</td> </tr> <tr> <td>goods_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>category_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>商品分类id</td> </tr> <tr> <td>category_id_1</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>一级分类id</td> </tr> <tr> <td>category_id_2</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>二级分类id</td> </tr> <tr> <td>category_id_3</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>三级分类id</td> </tr> <tr> <td>brand_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>品牌id</td> </tr> <tr> <td>group_id_array</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺分类id 首尾用,隔开</td> </tr> <tr> <td>promotion_type</td> <td>tinyint(3)</td> <td>0</td> <td>NO</td> <td></td> <td>促销类型 0无促销,1团购,2限时折扣</td> </tr> <tr> <td>promote_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>促销活动ID</td> </tr> <tr> <td>goods_type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>实物或虚拟商品标志 1实物商品 0 虚拟商品 2 F码商品</td> </tr> <tr> <td>market_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>市场价</td> </tr> <tr> <td>price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品原价格</td> </tr> <tr> <td>promotion_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品促销价格</td> </tr> <tr> <td>cost_price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>成本价</td> </tr> <tr> <td>point_exchange_type</td> <td>tinyint(3)</td> <td>0</td> <td>NO</td> <td></td> <td>积分兑换类型 0 非积分兑换 1 只能积分兑换</td> </tr> <tr> <td>point_exchange</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>积分兑换</td> </tr> <tr> <td>give_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>购买商品赠送积分</td> </tr> <tr> <td>is_member_discount</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>参与会员折扣</td> </tr> <tr> <td>shipping_fee</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>运费 0为免运费</td> </tr> <tr> <td>shipping_fee_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>售卖区域id 物流模板id ns_order_shipping_fee 表id</td> </tr> <tr> <td>stock</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>商品库存</td> </tr> <tr> <td>max_buy</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>限购 0 不限购</td> </tr> <tr> <td>clicks</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>商品点击数量</td> </tr> <tr> <td>min_stock_alarm</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>库存预警值</td> </tr> <tr> <td>sales</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>销售数量</td> </tr> <tr> <td>collects</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>收藏数量</td> </tr> <tr> <td>star</td> <td>tinyint(3) unsigned</td> <td>5</td> <td>NO</td> <td></td> <td>好评星级</td> </tr> <tr> <td>evaluates</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>评价数</td> </tr> <tr> <td>shares</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>分享数</td> </tr> <tr> <td>province_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>一级地区id</td> </tr> <tr> <td>city_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>二级地区id</td> </tr> <tr> <td>picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品主图</td> </tr> <tr> <td>keywords</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品关键词</td> </tr> <tr> <td>introduction</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品简介,促销语</td> </tr> <tr> <td>description</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>商品详情</td> </tr> <tr> <td>QRcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品二维码</td> </tr> <tr> <td>code</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商家编号</td> </tr> <tr> <td>is_stock_visible</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>页面不显示库存</td> </tr> <tr> <td>is_hot</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否热销商品</td> </tr> <tr> <td>is_recommend</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否推荐</td> </tr> <tr> <td>is_new</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否新品</td> </tr> <tr> <td>is_pre_sale</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否预售</td> </tr> <tr> <td>is_bill</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否开具增值税发票 1是,0否</td> </tr> <tr> <td>state</td> <td>tinyint(3)</td> <td>1</td> <td>NO</td> <td></td> <td>商品状态 0下架,1正常,10违规(禁售)</td> </tr> <tr> <td>sale_date</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>上下架时间</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>商品添加时间</td> </tr> <tr> <td>update_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>商品编辑时间</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>img_id_array</td> <td>varchar(1000)</td> <td></td> <td>YES</td> <td></td> <td>商品图片序列</td> </tr> <tr> <td>sku_img_array</td> <td>varchar(1000)</td> <td></td> <td>YES</td> <td></td> <td>商品sku应用图片列表 属性,属性值,图片ID</td> </tr> <tr> <td>match_point</td> <td>float(10,2)</td> <td></td> <td>YES</td> <td></td> <td>实物与描述相符(根据评价计算)</td> </tr> <tr> <td>match_ratio</td> <td>float(10,2)</td> <td></td> <td>YES</td> <td></td> <td>实物与描述相符(根据评价计算)百分比</td> </tr> <tr> <td>real_sales</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>实际销量</td> </tr> <tr> <td>goods_attribute_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品类型</td> </tr> <tr> <td>goods_spec_format</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>商品规格</td> </tr> </tbody> </table> <h3>ns_goods_attribute商品属性表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>attr_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>attr_value_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>属性值id</td> </tr> <tr> <td>attr_value</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性值名称</td> </tr> <tr> <td>attr_value_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性值对应数据值</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>create_time</td> <td>varchar(255)</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_goods_attribute_deleted被删除的商品属性表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>attr_id</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>attr_value_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>属性值id</td> </tr> <tr> <td>attr_value</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性值名称</td> </tr> <tr> <td>attr_value_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性值对应数据值</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>create_time</td> <td>varchar(255)</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_goods_attribute_value商品规格值模版表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>attr_value_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>商品属性值ID</td> </tr> <tr> <td>attr_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品属性ID</td> </tr> <tr> <td>attr_value</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>值名称</td> </tr> <tr> <td>is_visible</td> <td>bit(1)</td> <td>b'1'</td> <td>NO</td> <td></td> <td>是否可视</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_goods_brand品牌表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>brand_id</td> <td>bigint(20)</td> <td></td> <td>NO</td> <td>是</td> <td>索引ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>brand_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>品牌名称</td> </tr> <tr> <td>brand_initial</td> <td>varchar(1)</td> <td></td> <td>NO</td> <td></td> <td>品牌首字母</td> </tr> <tr> <td>brand_pic</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>图片</td> </tr> <tr> <td>brand_recommend</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐,0为否,1为是,默认为0</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>brand_category_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>类别名称</td> </tr> <tr> <td>category_id_array</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>所属分类id组</td> </tr> <tr> <td>brand_ads</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>品牌推荐广告</td> </tr> <tr> <td>category_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>品牌所属分类名称</td> </tr> <tr> <td>category_id_1</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>一级分类ID</td> </tr> <tr> <td>category_id_2</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>二级分类ID</td> </tr> <tr> <td>category_id_3</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>三级分类ID</td> </tr> </tbody> </table> <h3>ns_goods_category商品分类表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>category_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>category_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>分类名称</td> </tr> <tr> <td>short_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品分类简称</td> </tr> <tr> <td>pid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>父级id</td> </tr> <tr> <td>level</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>分类等级</td> </tr> <tr> <td>is_visible</td> <td>int(11)</td> <td>1</td> <td>YES</td> <td></td> <td>是否显示 1 显示 0 不显示</td> </tr> <tr> <td>attr_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>关联商品类型ID</td> </tr> <tr> <td>attr_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>关联类型名称</td> </tr> <tr> <td>keywords</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>关键词</td> </tr> <tr> <td>description</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>描述</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>category_pic</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品分类图片</td> </tr> </tbody> </table> <h3>ns_goods_deleted商品回收站表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>goods_id</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td>商品id(SKU)</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>category_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>商品分类id</td> </tr> <tr> <td>category_id_1</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>一级分类id</td> </tr> <tr> <td>category_id_2</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>二级分类id</td> </tr> <tr> <td>category_id_3</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>三级分类id</td> </tr> <tr> <td>brand_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>品牌id</td> </tr> <tr> <td>group_id_array</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺分类id 首尾用,隔开</td> </tr> <tr> <td>promotion_type</td> <td>tinyint(3)</td> <td>0</td> <td>NO</td> <td></td> <td>促销类型 0无促销,1团购,2限时折扣</td> </tr> <tr> <td>promote_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>促销活动ID</td> </tr> <tr> <td>goods_type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>实物或虚拟商品标志 1实物商品 0 虚拟商品 2 F码商品</td> </tr> <tr> <td>market_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>市场价</td> </tr> <tr> <td>price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品原价格</td> </tr> <tr> <td>promotion_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品促销价格</td> </tr> <tr> <td>cost_price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>成本价</td> </tr> <tr> <td>point_exchange_type</td> <td>tinyint(3)</td> <td>0</td> <td>NO</td> <td></td> <td>积分兑换类型 0 非积分兑换 1 只能积分兑换</td> </tr> <tr> <td>point_exchange</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>积分兑换</td> </tr> <tr> <td>give_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>购买商品赠送积分</td> </tr> <tr> <td>is_member_discount</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>参与会员折扣</td> </tr> <tr> <td>shipping_fee</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>运费 0为免运费</td> </tr> <tr> <td>shipping_fee_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>售卖区域id 物流模板id ns_order_shipping_fee 表id</td> </tr> <tr> <td>stock</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>商品库存</td> </tr> <tr> <td>max_buy</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>限购 0 不限购</td> </tr> <tr> <td>clicks</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>商品点击数量</td> </tr> <tr> <td>min_stock_alarm</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>库存预警值</td> </tr> <tr> <td>sales</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>销售数量</td> </tr> <tr> <td>collects</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>收藏数量</td> </tr> <tr> <td>star</td> <td>tinyint(3) unsigned</td> <td>5</td> <td>NO</td> <td></td> <td>好评星级</td> </tr> <tr> <td>evaluates</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>评价数</td> </tr> <tr> <td>shares</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>分享数</td> </tr> <tr> <td>province_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>一级地区id</td> </tr> <tr> <td>city_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>二级地区id</td> </tr> <tr> <td>picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品主图</td> </tr> <tr> <td>keywords</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品关键词</td> </tr> <tr> <td>introduction</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品简介,促销语</td> </tr> <tr> <td>description</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>商品详情</td> </tr> <tr> <td>QRcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品二维码</td> </tr> <tr> <td>code</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商家编号</td> </tr> <tr> <td>is_stock_visible</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>页面不显示库存</td> </tr> <tr> <td>is_hot</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否热销商品</td> </tr> <tr> <td>is_recommend</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否推荐</td> </tr> <tr> <td>is_new</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否新品</td> </tr> <tr> <td>is_pre_sale</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否预售</td> </tr> <tr> <td>is_bill</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否开具增值税发票 1是,0否</td> </tr> <tr> <td>state</td> <td>tinyint(3)</td> <td>1</td> <td>NO</td> <td></td> <td>商品状态 0下架,1正常,10违规(禁售)</td> </tr> <tr> <td>sale_date</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>上下架时间</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>商品添加时间</td> </tr> <tr> <td>update_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>商品编辑时间</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>img_id_array</td> <td>varchar(1000)</td> <td></td> <td>YES</td> <td></td> <td>商品图片序列</td> </tr> <tr> <td>sku_img_array</td> <td>varchar(1000)</td> <td></td> <td>YES</td> <td></td> <td>商品sku应用图片列表 属性,属性值,图片ID</td> </tr> <tr> <td>match_point</td> <td>float(10,2)</td> <td></td> <td>YES</td> <td></td> <td>实物与描述相符(根据评价计算)</td> </tr> <tr> <td>match_ratio</td> <td>float(10,2)</td> <td></td> <td>YES</td> <td></td> <td>实物与描述相符(根据评价计算)百分比</td> </tr> <tr> <td>real_sales</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>实际销量</td> </tr> <tr> <td>goods_attribute_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品类型</td> </tr> <tr> <td>goods_spec_format</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>商品规格</td> </tr> </tbody> </table> <h3>ns_goods_evaluate商品评价表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>评价ID</td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单ID</td> </tr> <tr> <td>order_no</td> <td>bigint(20) unsigned</td> <td></td> <td>NO</td> <td></td> <td>订单编号</td> </tr> <tr> <td>order_goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单项ID</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>goods_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品价格</td> </tr> <tr> <td>goods_image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>shop_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>content</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>评价内容</td> </tr> <tr> <td>addtime</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>评价时间</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>评价图片</td> </tr> <tr> <td>explain_first</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>解释内容</td> </tr> <tr> <td>member_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>评价人名称</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>评价人编号</td> </tr> <tr> <td>is_anonymous</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>0表示不是 1表示是匿名评价</td> </tr> <tr> <td>scores</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>评分1-5分</td> </tr> <tr> <td>again_content</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>追加评价内容</td> </tr> <tr> <td>again_addtime</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>追加评价时间</td> </tr> <tr> <td>again_image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>追加评价图片</td> </tr> <tr> <td>again_explain</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>追加解释内容</td> </tr> <tr> <td>explain_type</td> <td>int(11)</td> <td>0</td> <td>YES</td> <td></td> <td>1好评2中评3差评</td> </tr> <tr> <td>is_show</td> <td>int(1)</td> <td>1</td> <td>YES</td> <td></td> <td>1显示 0隐藏</td> </tr> </tbody> </table> <h3>ns_goods_group商品分组表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>group_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>group_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>分类名称</td> </tr> <tr> <td>pid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>上级id 最多2级</td> </tr> <tr> <td>level</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>级别</td> </tr> <tr> <td>is_visible</td> <td>int(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否可视</td> </tr> <tr> <td>group_pic</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>图片</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>ns_goods_sku商品skui规格价格库存信息表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>sku_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>表序号</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品编号</td> </tr> <tr> <td>sku_name</td> <td>varchar(500)</td> <td></td> <td>NO</td> <td></td> <td>SKU名称</td> </tr> <tr> <td>attr_value_items</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性和属性值 id串 attribute + attribute value 表ID分号分隔</td> </tr> <tr> <td>attr_value_items_format</td> <td>varchar(500)</td> <td></td> <td>NO</td> <td></td> <td>属性和属性值id串组合json格式</td> </tr> <tr> <td>market_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>市场价</td> </tr> <tr> <td>price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>价格</td> </tr> <tr> <td>promote_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>促销价格</td> </tr> <tr> <td>cost_price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>成本价</td> </tr> <tr> <td>stock</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>库存</td> </tr> <tr> <td>picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>如果是第一个sku编码, 可以加图片</td> </tr> <tr> <td>code</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商家编码</td> </tr> <tr> <td>QRcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品二维码</td> </tr> <tr> <td>create_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>update_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_goods_sku_deleted商品skui规格价格库存信息回收站表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>sku_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>表序号</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品编号</td> </tr> <tr> <td>sku_name</td> <td>varchar(500)</td> <td></td> <td>NO</td> <td></td> <td>SKU名称</td> </tr> <tr> <td>attr_value_items</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性和属性值 id串 attribute + attribute value 表ID分号分隔</td> </tr> <tr> <td>attr_value_items_format</td> <td>varchar(500)</td> <td></td> <td>NO</td> <td></td> <td>属性和属性值id串组合json格式</td> </tr> <tr> <td>market_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>市场价</td> </tr> <tr> <td>price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>价格</td> </tr> <tr> <td>promote_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>促销价格</td> </tr> <tr> <td>cost_price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>成本价</td> </tr> <tr> <td>stock</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>库存</td> </tr> <tr> <td>picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>如果是第一个sku编码, 可以加图片</td> </tr> <tr> <td>code</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商家编码</td> </tr> <tr> <td>QRcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品二维码</td> </tr> <tr> <td>create_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>update_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_goods_spec商品属性(规格)表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>spec_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>属性ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>spec_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>属性名称</td> </tr> <tr> <td>is_visible</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否可视</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建日期</td> </tr> <tr> <td>show_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>展示方式 1 文字 2 颜色 3 图片</td> </tr> </tbody> </table> <h3>ns_goods_spec_value商品规格值模版表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>spec_value_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>商品属性值ID</td> </tr> <tr> <td>spec_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品属性ID</td> </tr> <tr> <td>spec_value_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品属性值名称</td> </tr> <tr> <td>spec_value_data</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品属性值数据</td> </tr> <tr> <td>is_visible</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否可视</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>ns_member前台用户表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>用户ID</td> </tr> <tr> <td>member_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>前台用户名</td> </tr> <tr> <td>member_level</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>会员等级</td> </tr> <tr> <td>reg_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>注册时间</td> </tr> <tr> <td>memo</td> <td>varchar(1000)</td> <td></td> <td>YES</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_member_account会员账户统计表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员uid</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>会员积分</td> </tr> <tr> <td>balance</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>余额</td> </tr> <tr> <td>coin</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>购物币</td> </tr> <tr> <td>member_cunsum</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>会员消费</td> </tr> <tr> <td>member_sum_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>会员累计积分</td> </tr> </tbody> </table> <h3>ns_member_account_records会员流水账表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>用户ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>account_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>账户类型1.积分2.余额3.购物币</td> </tr> <tr> <td>sign</td> <td>smallint(6)</td> <td>1</td> <td>NO</td> <td></td> <td>正负号</td> </tr> <tr> <td>number</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>数量</td> </tr> <tr> <td>from_type</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>产生方式1.商城订单2.订单退还3.兑换4.充值5.签到6.分享7.注册8.提现9提现退还</td> </tr> <tr> <td>data_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>相关表的数据ID</td> </tr> <tr> <td>text</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>数据相关内容描述文本</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_member_balance_withdraw会员余额提现记录表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺编号</td> </tr> <tr> <td>withdraw_no</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>提现流水号</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员id</td> </tr> <tr> <td>bank_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>提现银行名称</td> </tr> <tr> <td>account_number</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>提现银行账号</td> </tr> <tr> <td>realname</td> <td>varchar(10)</td> <td></td> <td>NO</td> <td></td> <td>提现账户姓名</td> </tr> <tr> <td>mobile</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>手机</td> </tr> <tr> <td>cash</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>提现金额</td> </tr> <tr> <td>ask_for_date</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>提现日期</td> </tr> <tr> <td>payment_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>到账日期</td> </tr> <tr> <td>status</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>当前状态 0已申请(等待处理) 1已同意 -1 已拒绝</td> </tr> <tr> <td>memo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> <tr> <td>modify_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>ns_member_bank_account会员提现账号</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员id</td> </tr> <tr> <td>bank_type</td> <td>varchar(50)</td> <td>1</td> <td>NO</td> <td></td> <td>账号类型 1银行卡2支付宝</td> </tr> <tr> <td>branch_bank_name</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>支行信息</td> </tr> <tr> <td>realname</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>真实姓名</td> </tr> <tr> <td>account_number</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>银行账号</td> </tr> <tr> <td>mobile</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>手机号</td> </tr> <tr> <td>is_default</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否默认账号</td> </tr> <tr> <td>create_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>创建日期</td> </tr> <tr> <td>modify_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>ns_member_express_address会员收货地址管理</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员基本资料表ID</td> </tr> <tr> <td>consigner</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>收件人</td> </tr> <tr> <td>mobile</td> <td>varchar(11)</td> <td></td> <td>NO</td> <td></td> <td>手机</td> </tr> <tr> <td>phone</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>固定电话</td> </tr> <tr> <td>province</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>省</td> </tr> <tr> <td>city</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>市</td> </tr> <tr> <td>district</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>区县</td> </tr> <tr> <td>address</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>详细地址</td> </tr> <tr> <td>zip_code</td> <td>varchar(6)</td> <td></td> <td>NO</td> <td></td> <td>邮编</td> </tr> <tr> <td>alias</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>地址别名</td> </tr> <tr> <td>is_default</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>默认收货地址</td> </tr> </tbody> </table> <h3>ns_member_favorites收藏表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>log_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>记录ID</td> </tr> <tr> <td>uid</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>会员ID</td> </tr> <tr> <td>fav_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>商品或店铺ID</td> </tr> <tr> <td>fav_type</td> <td>varchar(20)</td> <td>goods</td> <td>NO</td> <td></td> <td>类型:goods为商品,shop为店铺,默认为商品</td> </tr> <tr> <td>fav_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>收藏时间</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>shop_name</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>shop_logo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺logo</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_image</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>log_price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品收藏时价格</td> </tr> <tr> <td>log_msg</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>收藏备注</td> </tr> </tbody> </table> <h3>ns_member_gift会员赠品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>gift_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员ID</td> </tr> <tr> <td>promotion_gift_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>赠品活动ID</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>赠品ID</td> </tr> <tr> <td>goods_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>赠品名称</td> </tr> <tr> <td>goods_picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>赠品图片</td> </tr> <tr> <td>num</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>赠品数量</td> </tr> <tr> <td>get_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>获取方式</td> </tr> <tr> <td>get_type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>获取方式对应ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>说明</td> </tr> </tbody> </table> <h3>ns_member_level会员等级</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>level_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>等级ID</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>level_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>等级名称</td> </tr> <tr> <td>min_integral</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>累计积分</td> </tr> <tr> <td>goods_discount</td> <td>decimal(3,2)</td> <td>1.00</td> <td>NO</td> <td></td> <td>折扣率</td> </tr> <tr> <td>desc</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>等级描述</td> </tr> <tr> <td>is_default</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是默认</td> </tr> <tr> <td>quota</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>消费额度</td> </tr> <tr> <td>upgrade</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>升级条件 1.累计积分 2.消费额度 3.同时满足</td> </tr> <tr> <td>relation</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>1.或 2. 且</td> </tr> </tbody> </table> <h3>ns_member_recharge会员充值余额记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>recharge_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>支付金额</td> </tr> <tr> <td>uid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>用户uid</td> </tr> <tr> <td>out_trade_no</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>支付流水号</td> </tr> <tr> <td>create_time</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>is_pay</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>是否支付</td> </tr> <tr> <td>status</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>状态</td> </tr> </tbody> </table> <h3>ns_offpay_area货到付款支持地区表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td>店铺Id</td> </tr> <tr> <td>province_id</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>省Id组合</td> </tr> <tr> <td>city_id</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>市Id组合</td> </tr> <tr> <td>district_id</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>县Id组合</td> </tr> </tbody> </table> <h3>ns_order订单表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>订单id</td> </tr> <tr> <td>order_no</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>订单编号</td> </tr> <tr> <td>out_trade_no</td> <td>varchar(100)</td> <td>0</td> <td>NO</td> <td></td> <td>外部交易号</td> </tr> <tr> <td>order_type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>订单类型</td> </tr> <tr> <td>payment_type</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>支付类型。取值范围: WEIXIN (微信自有支付) WEIXIN_DAIXIAO (微信代销支付) ALIPAY (支付宝支付)</td> </tr> <tr> <td>shipping_type</td> <td>tinyint(4)</td> <td>1</td> <td>YES</td> <td></td> <td>订单配送方式</td> </tr> <tr> <td>order_from</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>订单来源</td> </tr> <tr> <td>buyer_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>买家id</td> </tr> <tr> <td>user_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>买家会员名称</td> </tr> <tr> <td>pay_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>订单付款时间</td> </tr> <tr> <td>buyer_ip</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>买家ip</td> </tr> <tr> <td>buyer_message</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>买家附言</td> </tr> <tr> <td>buyer_invoice</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>买家发票信息</td> </tr> <tr> <td>shipping_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>买家要求配送时间</td> </tr> <tr> <td>sign_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>买家签收时间</td> </tr> <tr> <td>receiver_mobile</td> <td>varchar(11)</td> <td></td> <td>NO</td> <td></td> <td>收货人的手机号码</td> </tr> <tr> <td>receiver_province</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>收货人所在省</td> </tr> <tr> <td>receiver_city</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>收货人所在城市</td> </tr> <tr> <td>receiver_district</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>收货人所在街道</td> </tr> <tr> <td>receiver_address</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>收货人详细地址</td> </tr> <tr> <td>receiver_zip</td> <td>varchar(6)</td> <td></td> <td>NO</td> <td></td> <td>收货人邮编</td> </tr> <tr> <td>receiver_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>收货人姓名</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>卖家店铺id</td> </tr> <tr> <td>shop_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>卖家店铺名称</td> </tr> <tr> <td>seller_star</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>卖家对订单的标注星标</td> </tr> <tr> <td>seller_memo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>卖家对订单的备注</td> </tr> <tr> <td>consign_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>卖家发货时间</td> </tr> <tr> <td>consign_time_adjust</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>卖家延迟发货时间</td> </tr> <tr> <td>goods_money</td> <td>decimal(19,2)</td> <td></td> <td>NO</td> <td></td> <td>商品总价</td> </tr> <tr> <td>order_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单总价</td> </tr> <tr> <td>point</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单消耗积分</td> </tr> <tr> <td>point_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单消耗积分抵多少钱</td> </tr> <tr> <td>coupon_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单代金券支付金额</td> </tr> <tr> <td>coupon_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单代金券id</td> </tr> <tr> <td>user_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>订单余额支付金额</td> </tr> <tr> <td>user_platform_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>用户平台余额支付</td> </tr> <tr> <td>promotion_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单优惠活动金额</td> </tr> <tr> <td>shipping_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单运费</td> </tr> <tr> <td>pay_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单实付金额</td> </tr> <tr> <td>refund_money</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>订单退款金额</td> </tr> <tr> <td>coin_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>购物币金额</td> </tr> <tr> <td>give_point</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单赠送积分</td> </tr> <tr> <td>give_coin</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>订单成功之后返购物币</td> </tr> <tr> <td>order_status</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>订单状态</td> </tr> <tr> <td>pay_status</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>订单付款状态</td> </tr> <tr> <td>shipping_status</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>订单配送状态</td> </tr> <tr> <td>review_status</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>订单评价状态</td> </tr> <tr> <td>feedback_status</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>订单维权状态</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>订单创建时间</td> </tr> <tr> <td>finish_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>订单完成时间</td> </tr> <tr> <td>is_evaluate</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>是否评价 0为未评价 1为已评价 2为已追评</td> </tr> </tbody> </table> <h3>ns_order_action订单操作表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>action_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>动作id</td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单id</td> </tr> <tr> <td>action</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>动作内容</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>操作人id</td> </tr> <tr> <td>user_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>操作人</td> </tr> <tr> <td>order_status</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单大状态</td> </tr> <tr> <td>order_status_text</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>订单状态名称</td> </tr> <tr> <td>action_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>操作时间</td> </tr> </tbody> </table> <h3>ns_order_goods订单商品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>order_goods_id</td> <td>int(11) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>订单项ID</td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单ID</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>sku_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>skuID</td> </tr> <tr> <td>sku_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>sku名称</td> </tr> <tr> <td>price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品价格</td> </tr> <tr> <td>cost_price</td> <td>decimal(19,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品成本价</td> </tr> <tr> <td>num</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>购买数量</td> </tr> <tr> <td>adjust_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>调整金额</td> </tr> <tr> <td>goods_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品总价</td> </tr> <tr> <td>goods_picture</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>buyer_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>购买人ID</td> </tr> <tr> <td>point_exchange_type</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>积分兑换类型0.非积分兑换1.积分兑换</td> </tr> <tr> <td>goods_type</td> <td>varchar(255)</td> <td>1</td> <td>NO</td> <td></td> <td>商品类型</td> </tr> <tr> <td>promotion_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>促销ID</td> </tr> <tr> <td>promotion_type_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>促销类型</td> </tr> <tr> <td>order_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>订单类型</td> </tr> <tr> <td>order_status</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>订单状态</td> </tr> <tr> <td>give_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>积分数量</td> </tr> <tr> <td>shipping_status</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>物流状态</td> </tr> <tr> <td>refund_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>退款时间</td> </tr> <tr> <td>refund_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>退款方式</td> </tr> <tr> <td>refund_require_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>退款金额</td> </tr> <tr> <td>refund_reason</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>退款原因</td> </tr> <tr> <td>refund_shipping_code</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>退款物流单号</td> </tr> <tr> <td>refund_shipping_company</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>退款物流公司名称</td> </tr> <tr> <td>refund_real_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>实际退款金额</td> </tr> <tr> <td>refund_status</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>退款状态</td> </tr> <tr> <td>memo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> <tr> <td>is_evaluate</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>是否评价 0为未评价 1为已评价 2为已追评</td> </tr> </tbody> </table> <h3>ns_order_goods_express商品订单物流信息表(多次发货)</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单id</td> </tr> <tr> <td>order_goods_id_array</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>订单项商品组合列表</td> </tr> <tr> <td>express_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>包裹名称 (包裹- 1 包裹 - 2)</td> </tr> <tr> <td>shipping_type</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>发货方式1 需要物流 0无需物流</td> </tr> <tr> <td>express_company_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>快递公司id</td> </tr> <tr> <td>express_company</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>物流公司名称</td> </tr> <tr> <td>express_no</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>运单编号</td> </tr> <tr> <td>shipping_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>发货时间</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>用户id</td> </tr> <tr> <td>user_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>用户名</td> </tr> <tr> <td>memo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_order_goods_promotion_details订单商品优惠详情</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单ID</td> </tr> <tr> <td>sku_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品skuid</td> </tr> <tr> <td>promotion_type</td> <td>varbinary(255)</td> <td></td> <td>NO</td> <td></td> <td>优惠类型规则ID(满减对应规则)</td> </tr> <tr> <td>promotion_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>优惠ID</td> </tr> <tr> <td>discount_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>优惠的金额,单位:元,精确到小数点后两位</td> </tr> <tr> <td>used_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>使用时间</td> </tr> </tbody> </table> <h3>ns_order_payment订单支付表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>out_trade_no</td> <td>varchar(30)</td> <td></td> <td>NO</td> <td></td> <td>支付单编号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>执行支付的相关店铺ID(0平台)</td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>订单类型1.商城订单2.交易商支付</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>订单类型关联ID</td> </tr> <tr> <td>pay_body</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>订单支付简介</td> </tr> <tr> <td>pay_detail</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>订单支付详情</td> </tr> <tr> <td>pay_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>支付金额</td> </tr> <tr> <td>pay_status</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>支付状态</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>pay_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>支付时间</td> </tr> <tr> <td>pay_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>支付方式</td> </tr> </tbody> </table> <h3>ns_order_promotion_details订单优惠详情</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单ID</td> </tr> <tr> <td>promotion_type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>优惠类型规则ID(满减对应规则)</td> </tr> <tr> <td>promotion_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>优惠ID</td> </tr> <tr> <td>promotion_type</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>优惠类型</td> </tr> <tr> <td>promotion_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>该优惠活动的名称</td> </tr> <tr> <td>promotion_condition</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>优惠使用条件说明</td> </tr> <tr> <td>discount_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>优惠的金额,单位:元,精确到小数点后两位</td> </tr> <tr> <td>used_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>使用时间</td> </tr> </tbody> </table> <h3>ns_order_refund订单商品退货退款操作表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>id</td> </tr> <tr> <td>order_goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单商品表id</td> </tr> <tr> <td>refund_status</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>操作状态 流程状态(refund_status) 状态名称(refund_status_name) 操作时间 1 买家申请 发起了退款申请,等待卖家处理 2 等待买家退货 卖家已同意退款申请,等待买家退货 3 等待卖家确认收货 买家已退货,等待卖家确认收货 4 等待卖家确认退款 卖家同意退款 0 退款已成功 卖家退款给买家,本次维权结束 -1 退款已拒绝 卖家拒绝本次退款,本次维权结束 -2 退款已关闭 主动撤销退款,退款关闭 -3 退款申请不通过 拒绝了本次退款申请,等待买家修改</td> </tr> <tr> <td>action</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>退款操作内容描述</td> </tr> <tr> <td>action_way</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>操作方 1 买家 2 卖家</td> </tr> <tr> <td>action_userid</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>操作人id</td> </tr> <tr> <td>action_username</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>操作人姓名</td> </tr> <tr> <td>action_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>操作时间</td> </tr> </tbody> </table> <h3>ns_order_shipping_fee售卖区域</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shipping_fee_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>售卖区域ID</td> </tr> <tr> <td>shipping_fee_name</td> <td>varchar(30)</td> <td></td> <td>NO</td> <td></td> <td>售卖区域名称</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建日期</td> </tr> <tr> <td>update_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>最后更新时间</td> </tr> </tbody> </table> <h3>ns_order_shipping_fee_extend售卖区域扩展表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>售卖区域扩展ID</td> </tr> <tr> <td>shipping_fee_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>售卖区域ID</td> </tr> <tr> <td>province_id</td> <td>varchar(8000)</td> <td>0</td> <td>NO</td> <td></td> <td>省级地区ID组成的串,以,隔开,两端也有,</td> </tr> <tr> <td>city_id</td> <td>varchar(8000)</td> <td>0</td> <td>NO</td> <td></td> <td>市级地区ID组成的串,以,隔开,两端也有,</td> </tr> <tr> <td>snum</td> <td>mediumint(8) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>首件数量</td> </tr> <tr> <td>sprice</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>首件运费</td> </tr> <tr> <td>xnum</td> <td>mediumint(8) unsigned</td> <td>1</td> <td>NO</td> <td></td> <td>续件数量</td> </tr> <tr> <td>xprice</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>续件运费</td> </tr> <tr> <td>is_default</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否默认 1 默认</td> </tr> </tbody> </table> <h3>ns_order_shop_return店铺退货设置</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>shop_address</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商家地址</td> </tr> <tr> <td>seller_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>收件人</td> </tr> <tr> <td>seller_mobile</td> <td>varchar(11)</td> <td></td> <td>NO</td> <td></td> <td>收件人手机号</td> </tr> <tr> <td>seller_zipcode</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>邮编</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_platform_adv广告表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>adv_id</td> <td>mediumint(8) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>广告自增标识编号</td> </tr> <tr> <td>ap_id</td> <td>mediumint(8) unsigned</td> <td></td> <td>NO</td> <td></td> <td>广告位id</td> </tr> <tr> <td>adv_title</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>广告内容描述</td> </tr> <tr> <td>adv_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>链接地址</td> </tr> <tr> <td>adv_image</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>广告内容图片</td> </tr> <tr> <td>slide_sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td>幻灯片排序</td> </tr> <tr> <td>click_num</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>广告点击率</td> </tr> <tr> <td>background</td> <td>varchar(255)</td> <td>#FFFFFF</td> <td>NO</td> <td></td> <td>背景色</td> </tr> </tbody> </table> <h3>ns_platform_adv_position广告位表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>ap_id</td> <td>mediumint(8) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>广告位置id</td> </tr> <tr> <td>ap_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>广告位置名</td> </tr> <tr> <td>ap_intro</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>广告位简介</td> </tr> <tr> <td>ap_class</td> <td>smallint(1) unsigned</td> <td></td> <td>NO</td> <td></td> <td>广告类别:0图片1文字2幻灯3Flash</td> </tr> <tr> <td>ap_display</td> <td>smallint(1) unsigned</td> <td></td> <td>NO</td> <td></td> <td>广告展示方式:0幻灯片1多广告展示2单广告展示</td> </tr> <tr> <td>is_use</td> <td>smallint(1) unsigned</td> <td></td> <td>NO</td> <td></td> <td>广告位是否启用:0不启用1启用</td> </tr> <tr> <td>ap_height</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td>广告位高度</td> </tr> <tr> <td>ap_width</td> <td>int(10)</td> <td></td> <td>NO</td> <td></td> <td>广告位宽度</td> </tr> <tr> <td>ap_price</td> <td>int(10) unsigned</td> <td></td> <td>YES</td> <td></td> <td>广告位单价</td> </tr> <tr> <td>adv_num</td> <td>int(10) unsigned</td> <td></td> <td>YES</td> <td></td> <td>拥有的广告数</td> </tr> <tr> <td>click_num</td> <td>int(10) unsigned</td> <td></td> <td>YES</td> <td></td> <td>广告位点击率</td> </tr> <tr> <td>default_content</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>广告位默认内容</td> </tr> <tr> <td>ap_background_color</td> <td>varchar(50)</td> <td>#FFFFFF</td> <td>NO</td> <td></td> <td>广告位背景色 默认白色</td> </tr> <tr> <td>type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>广告位所在位置类型 1 pc端 2 手机端</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>is_del</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否可以删除 0可以 1不可删除</td> </tr> </tbody> </table> <h3>ns_platform_block首页促销板块</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>block_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>is_display</td> <td>smallint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>是否显示</td> </tr> <tr> <td>block_color</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>颜色风格</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>更新时间</td> </tr> <tr> <td>block_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>板块名称</td> </tr> <tr> <td>block_short_name</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>板块简称</td> </tr> <tr> <td>recommend_ad_image_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>推荐单图广告位名称</td> </tr> <tr> <td>recommend_ad_image</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐单图广告位</td> </tr> <tr> <td>recommend_ad_slide_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>推荐幻灯广告位名称</td> </tr> <tr> <td>recommend_ad_slide</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>推荐幻灯广告位</td> </tr> <tr> <td>recommend_ad_images_name</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐多图广告位名称</td> </tr> <tr> <td>recommend_ad_images</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐多图广告位</td> </tr> <tr> <td>recommend_brands</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>推荐品牌</td> </tr> <tr> <td>recommend_categorys</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>推荐商品分类</td> </tr> <tr> <td>recommend_goods_category_name_1</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>推荐分类商品别名</td> </tr> <tr> <td>recommend_goods_category_1</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐显示商品分类</td> </tr> <tr> <td>recommend_goods_category_name_2</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>推荐分类商品别名</td> </tr> <tr> <td>recommend_goods_category_2</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐显示商品分类</td> </tr> <tr> <td>recommend_goods_category_name_3</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>推荐分类商品别名</td> </tr> <tr> <td>recommend_goods_category_3</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐显示商品分类</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>block_data</td> <td>longtext</td> <td></td> <td>YES</td> <td></td> <td>板块数据</td> </tr> </tbody> </table> <h3>ns_platform_goods_recommend平台商品推荐</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>recommend_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>推荐商品ID</td> </tr> <tr> <td>state</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>推荐状态</td> </tr> <tr> <td>class_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>推荐类型</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_platform_goods_recommend_class店铺商品推荐类别</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>class_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>class_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>类型名称</td> </tr> <tr> <td>class_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>推荐模块1.系统固有模块2.平台增加模块</td> </tr> <tr> <td>is_use</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否使用</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>255</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> </tbody> </table> <h3>ns_platform_help_class平台说明类型</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>class_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>表主键</td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>1.帮助类别2.会员协议类别3.开店协议类别</td> </tr> <tr> <td>class_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>类型名称</td> </tr> <tr> <td>parent_class_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>上级ID</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序号</td> </tr> </tbody> </table> <h3>ns_platform_help_document平台说明内容</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>表主键</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>最后修改人ID</td> </tr> <tr> <td>class_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>所属说明类型ID</td> </tr> <tr> <td>title</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>主题</td> </tr> <tr> <td>link_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>链接地址</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>内容</td> </tr> <tr> <td>image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>图片</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modufy_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_platform_link友情链接表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>link_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>索引id</td> </tr> <tr> <td>link_title</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>标题</td> </tr> <tr> <td>link_url</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>链接</td> </tr> <tr> <td>link_pic</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>图片</td> </tr> <tr> <td>link_sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>is_blank</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>是否新窗口打开 1.是 2.否</td> </tr> <tr> <td>is_show</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>是否显示 1.是 2.否</td> </tr> </tbody> </table> <h3>ns_point_config积分设置表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>is_open</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否启动</td> </tr> <tr> <td>convert_rate</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>1积分对应金额</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>积分说明</td> </tr> </tbody> </table> <h3>ns_promotion_bundling组合销售活动表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>bl_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>组合ID</td> </tr> <tr> <td>bl_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>组合名称</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>shop_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>bl_price</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>商品组合价格</td> </tr> <tr> <td>shipping_fee_type</td> <td>tinyint(1)</td> <td></td> <td>NO</td> <td></td> <td>运费承担方式 1卖家承担运费 2买家承担运费</td> </tr> <tr> <td>shipping_fee</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>运费</td> </tr> <tr> <td>status</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>组合状态 0-关闭/1-开启</td> </tr> </tbody> </table> <h3>ns_promotion_bundling_goods组合销售活动商品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>bl_goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>组合商品id</td> </tr> <tr> <td>bl_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>组合id</td> </tr> <tr> <td>goods_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>商品id</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_picture</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>bl_goods_price</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>商品组合价格</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>ns_promotion_discount限时折扣</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>discount_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>shop_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>discount_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>活动名称</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>结束时间</td> </tr> <tr> <td>status</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>活动状态(0-未发布/1-正常/3-关闭/4-结束)</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>remark</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_promotion_discount_goods限时折扣商品列表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>discount_goods_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>discount_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>对应活动</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>结束时间</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>status</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>状态</td> </tr> <tr> <td>discount</td> <td>decimal(10,2)</td> <td></td> <td>NO</td> <td></td> <td>活动折扣或者减现信息</td> </tr> <tr> <td>goods_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_picture</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> </tbody> </table> <h3>ns_promotion_full_mail满额包邮</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>mail_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>is_open</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否开启 0未开启 1已开启</td> </tr> <tr> <td>full_mail_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>包邮所需订单金额</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>更新时间</td> </tr> </tbody> </table> <h3>ns_promotion_gift赠品活动表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>gift_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>赠品活动id</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>赠品有效期开始时间</td> </tr> <tr> <td>days</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>领取有效期(多少天)</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>赠品有效期结束时间</td> </tr> <tr> <td>max_num</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>领取限制(次/人 (0表示不限领取次数))</td> </tr> <tr> <td>shop_id</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>gift_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>赠品活动名称</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_promotion_gift_goods商品赠品表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>id</td> </tr> <tr> <td>gift_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>赠品id</td> </tr> <tr> <td>goods_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>商品id</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_picture</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> </tbody> </table> <h3>ns_promotion_mansong满减送活动表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>mansong_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>满送活动编号</td> </tr> <tr> <td>mansong_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>活动名称</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>活动开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>活动结束时间</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>店铺编号</td> </tr> <tr> <td>shop_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>status</td> <td>tinyint(1) unsigned</td> <td></td> <td>NO</td> <td></td> <td>活动状态(0-未发布/1-正常/3-关闭/4-结束)</td> </tr> <tr> <td>remark</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> <tr> <td>type</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>1.普通优惠 2.多级优惠</td> </tr> <tr> <td>range_type</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>1全部商品 0部分商品</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_promotion_mansong_goods满减送商品</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>mansong_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>满减送ID</td> </tr> <tr> <td>goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商品ID</td> </tr> <tr> <td>goods_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>商品名称</td> </tr> <tr> <td>goods_picture</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品图片</td> </tr> <tr> <td>start_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>开始时间</td> </tr> <tr> <td>end_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>结束时间</td> </tr> <tr> <td>status</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>活动状态</td> </tr> </tbody> </table> <h3>ns_promotion_mansong_rule满就送活动规则表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>rule_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>规则编号</td> </tr> <tr> <td>mansong_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>活动编号</td> </tr> <tr> <td>price</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>级别价格(满多少)</td> </tr> <tr> <td>discount</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>减现金优惠金额(减多少金额)</td> </tr> <tr> <td>free_shipping</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>免邮费</td> </tr> <tr> <td>give_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>送积分数量(0表示不送)</td> </tr> <tr> <td>give_coupon</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>送优惠券的id(0表示不送)</td> </tr> <tr> <td>gift_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>礼品(赠品)id</td> </tr> </tbody> </table> <h3>ns_reward_rule奖励规则表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>sign_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>签到送积分</td> </tr> <tr> <td>share_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>分享送积分</td> </tr> <tr> <td>reg_member_self_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>注册会员 自己获得的积分</td> </tr> <tr> <td>reg_member_one_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>注册会员 上级获得的积分</td> </tr> <tr> <td>reg_member_two_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>注册会员 上上级获得的积分</td> </tr> <tr> <td>reg_member_three_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>注册会员 上上上级获得的积分</td> </tr> <tr> <td>reg_promoter_self_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为推广员 自己获得的积分</td> </tr> <tr> <td>reg_promoter_one_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为推广员 上级获得的积分</td> </tr> <tr> <td>reg_promoter_two_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为推广员 上上级获得的积分</td> </tr> <tr> <td>reg_promoter_three_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为推广员 上上上级获得的积分</td> </tr> <tr> <td>reg_partner_self_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为股东 自己获得的积分</td> </tr> <tr> <td>reg_partner_one_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为股东 上级获得的积分</td> </tr> <tr> <td>reg_partner_two_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为股东 上上级获得的积分</td> </tr> <tr> <td>reg_partner_three_point</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>成为股东 上上上级获得的积分</td> </tr> <tr> <td>into_store_coupon</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>进店领用优惠券 存入优惠券id(coupon_id)</td> </tr> <tr> <td>share_coupon</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>分享领用优惠券 存入优惠券id(coupon_id)</td> </tr> </tbody> </table> <h3>ns_shop店铺数据表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺索引id</td> </tr> <tr> <td>shop_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>店铺名称</td> </tr> <tr> <td>shop_type</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺类型等级</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>会员id</td> </tr> <tr> <td>shop_group_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺分类</td> </tr> <tr> <td>shop_company_name</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>店铺公司名称</td> </tr> <tr> <td>province_id</td> <td>mediumint(8) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>店铺所在省份ID</td> </tr> <tr> <td>city_id</td> <td>mediumint(8) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>店铺所在市ID</td> </tr> <tr> <td>shop_address</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>详细地区</td> </tr> <tr> <td>shop_zip</td> <td>varchar(10)</td> <td></td> <td>NO</td> <td></td> <td>邮政编码</td> </tr> <tr> <td>shop_state</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>店铺状态,0关闭,1开启,2审核中</td> </tr> <tr> <td>shop_close_info</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>店铺关闭原因</td> </tr> <tr> <td>shop_sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺排序</td> </tr> <tr> <td>shop_create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>店铺时间</td> </tr> <tr> <td>shop_end_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>店铺关闭时间</td> </tr> <tr> <td>shop_logo</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>店铺logo</td> </tr> <tr> <td>shop_banner</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>店铺横幅</td> </tr> <tr> <td>shop_avatar</td> <td>varchar(150)</td> <td></td> <td>YES</td> <td></td> <td>店铺头像</td> </tr> <tr> <td>shop_keywords</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺seo关键字</td> </tr> <tr> <td>shop_description</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺seo描述</td> </tr> <tr> <td>shop_qq</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>QQ</td> </tr> <tr> <td>shop_ww</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>阿里旺旺</td> </tr> <tr> <td>shop_phone</td> <td>varchar(20)</td> <td></td> <td>YES</td> <td></td> <td>商家电话</td> </tr> <tr> <td>shop_domain</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>店铺二级域名</td> </tr> <tr> <td>shop_domain_times</td> <td>tinyint(1) unsigned</td> <td>0</td> <td>YES</td> <td></td> <td>二级域名修改次数</td> </tr> <tr> <td>shop_recommend</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐,0为否,1为是,默认为0</td> </tr> <tr> <td>shop_credit</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺信用</td> </tr> <tr> <td>shop_desccredit</td> <td>float</td> <td>0</td> <td>NO</td> <td></td> <td>描述相符度分数</td> </tr> <tr> <td>shop_servicecredit</td> <td>float</td> <td>0</td> <td>NO</td> <td></td> <td>服务态度分数</td> </tr> <tr> <td>shop_deliverycredit</td> <td>float</td> <td>0</td> <td>NO</td> <td></td> <td>发货速度分数</td> </tr> <tr> <td>shop_collect</td> <td>int(10) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>店铺收藏数量</td> </tr> <tr> <td>shop_stamp</td> <td>varchar(200)</td> <td></td> <td>YES</td> <td></td> <td>店铺印章</td> </tr> <tr> <td>shop_printdesc</td> <td>varchar(500)</td> <td></td> <td>YES</td> <td></td> <td>打印订单页面下方说明文字</td> </tr> <tr> <td>shop_sales</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺销售额(不计算退款)</td> </tr> <tr> <td>shop_account</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺账户余额</td> </tr> <tr> <td>shop_cash</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺可提现金额</td> </tr> <tr> <td>shop_workingtime</td> <td>varchar(100)</td> <td></td> <td>YES</td> <td></td> <td>工作时间</td> </tr> <tr> <td>live_store_name</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>商铺名称</td> </tr> <tr> <td>live_store_address</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>商家地址</td> </tr> <tr> <td>live_store_tel</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>商铺电话</td> </tr> <tr> <td>live_store_bus</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>公交线路</td> </tr> <tr> <td>shop_vrcode_prefix</td> <td>char(3)</td> <td></td> <td>YES</td> <td></td> <td>商家兑换码前缀</td> </tr> <tr> <td>store_qtian</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>7天退换</td> </tr> <tr> <td>shop_zhping</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>正品保障</td> </tr> <tr> <td>shop_erxiaoshi</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>两小时发货</td> </tr> <tr> <td>shop_tuihuo</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>退货承诺</td> </tr> <tr> <td>shop_shiyong</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>试用中心</td> </tr> <tr> <td>shop_shiti</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>实体验证</td> </tr> <tr> <td>shop_xiaoxie</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>消协保证</td> </tr> <tr> <td>shop_huodaofk</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>货到付款</td> </tr> <tr> <td>shop_free_time</td> <td>varchar(10)</td> <td></td> <td>YES</td> <td></td> <td>商家配送时间</td> </tr> <tr> <td>shop_region</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>店铺默认配送区域</td> </tr> <tr> <td>recommend_uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推荐招商员用户id</td> </tr> <tr> <td>shop_qrcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺公众号</td> </tr> </tbody> </table> <h3>ns_shop_ad店铺广告设置</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>ad_image</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>广告图片</td> </tr> <tr> <td>link_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>链接地址</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>type</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>类型 0 -- pc端 1-- 手机端</td> </tr> <tr> <td>background</td> <td>varchar(255)</td> <td>#FFFFFF</td> <td>NO</td> <td></td> <td>背景色</td> </tr> </tbody> </table> <h3>ns_shop_coin_records店铺购物币记录</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>num</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>购物币数量</td> </tr> <tr> <td>account_type</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>增加或减少类型</td> </tr> <tr> <td>type_alis_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>关联ID</td> </tr> <tr> <td>is_display</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否显示</td> </tr> <tr> <td>text</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>简介</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_shop_express_address物流地址</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>express_address_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>物流地址id</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>商铺id</td> </tr> <tr> <td>contact</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>联系人</td> </tr> <tr> <td>mobile</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>手机</td> </tr> <tr> <td>phone</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>电话</td> </tr> <tr> <td>company_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>公司名称</td> </tr> <tr> <td>province</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>所在地省</td> </tr> <tr> <td>city</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>所在地市</td> </tr> <tr> <td>district</td> <td>smallint(6)</td> <td>0</td> <td>NO</td> <td></td> <td>所在地区县</td> </tr> <tr> <td>zipcode</td> <td>varchar(6)</td> <td></td> <td>NO</td> <td></td> <td>邮编</td> </tr> <tr> <td>address</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>详细地址</td> </tr> <tr> <td>is_consigner</td> <td>tinyint(2)</td> <td>0</td> <td>NO</td> <td></td> <td>发货地址标记</td> </tr> <tr> <td>is_receiver</td> <td>tinyint(2)</td> <td>0</td> <td>NO</td> <td></td> <td>收货地址标记</td> </tr> <tr> <td>create_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>创建日期</td> </tr> <tr> <td>modify_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>ns_shop_group店铺分组表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_group_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>分组ID</td> </tr> <tr> <td>group_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>分组名称</td> </tr> <tr> <td>group_sort</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>分组排序号</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>ns_shop_navigation店铺导航管理</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>nav_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>nav_title</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>导航名称</td> </tr> <tr> <td>nav_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>链接地址</td> </tr> <tr> <td>nav_type</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>导航类型 0代表 商城链接 1代表外部链接</td> </tr> <tr> <td>is_blank</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否在新窗口打开 0 在当前页面打开 1在新窗口打开</td> </tr> <tr> <td>template_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模块名称</td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>3</td> <td>NO</td> <td></td> <td>纵向所在位置1.头部2.中部3底部</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>align</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>横向所在位置1 左 2 右</td> </tr> </tbody> </table> <h3>ns_shop_navigation_template导航 的 系统默认模板</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>template_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>template_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板名称</td> </tr> <tr> <td>template_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>访问路径</td> </tr> <tr> <td>is_use</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>是否有效</td> </tr> <tr> <td>use_type</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>1 shop端 0wap端</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>ns_shop_order_account_records店铺针对订单的金额分配</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>order_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单ID</td> </tr> <tr> <td>order_no</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>订单编号</td> </tr> <tr> <td>order_goods_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>订单项ID</td> </tr> <tr> <td>goods_pay_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>订单项实际支付金额</td> </tr> <tr> <td>rate</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>商品平台佣金比率</td> </tr> <tr> <td>shop_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺获取金额</td> </tr> <tr> <td>platform_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>平台获取金额</td> </tr> <tr> <td>is_refund</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否产生退款</td> </tr> <tr> <td>refund_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>实际退款金额</td> </tr> <tr> <td>shop_refund_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>店铺扣减余额</td> </tr> <tr> <td>platform_refund_money</td> <td>decimal(10,2)</td> <td>0.00</td> <td>NO</td> <td></td> <td>平台扣减余额</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>is_issue</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否已经结算</td> </tr> <tr> <td>remark</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>ns_shop_weixin_share店铺分享内容设置</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>shop_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>goods_param_1</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品分享价格标示</td> </tr> <tr> <td>goods_param_2</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>商品分享内容</td> </tr> <tr> <td>shop_param_1</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺分享标题</td> </tr> <tr> <td>shop_param_2</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺分享主题</td> </tr> <tr> <td>shop_param_3</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺分享内容</td> </tr> <tr> <td>qrcode_param_1</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>二维码分享主题</td> </tr> <tr> <td>qrcode_param_2</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>二维码分享内容</td> </tr> </tbody> </table> <h3>sys_album_class相册表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>album_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>相册id</td> </tr> <tr> <td>shop_id</td> <td>int(10)</td> <td>1</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>pid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>上级相册ID</td> </tr> <tr> <td>album_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>相册名称</td> </tr> <tr> <td>album_cover</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>相册封面</td> </tr> <tr> <td>is_default</td> <td>tinyint(1) unsigned</td> <td>0</td> <td>NO</td> <td></td> <td>是否为默认相册,1代表默认</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_album_picture相册图片表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>pic_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>相册图片表id</td> </tr> <tr> <td>shop_id</td> <td>int(10) unsigned</td> <td>1</td> <td>YES</td> <td></td> <td>所属实例id</td> </tr> <tr> <td>album_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td></td> <td>相册id</td> </tr> <tr> <td>is_wide</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否宽屏</td> </tr> <tr> <td>pic_name</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>图片名称</td> </tr> <tr> <td>pic_tag</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>图片标签</td> </tr> <tr> <td>pic_cover</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>原图图片路径</td> </tr> <tr> <td>pic_size</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>原图大小</td> </tr> <tr> <td>pic_spec</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>原图规格</td> </tr> <tr> <td>pic_cover_big</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>大图路径</td> </tr> <tr> <td>pic_size_big</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>大图大小</td> </tr> <tr> <td>pic_spec_big</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>大图规格</td> </tr> <tr> <td>pic_cover_mid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>中图路径</td> </tr> <tr> <td>pic_size_mid</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>中图大小</td> </tr> <tr> <td>pic_spec_mid</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>中图规格</td> </tr> <tr> <td>pic_cover_small</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>小图路径</td> </tr> <tr> <td>pic_size_small</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>小图大小</td> </tr> <tr> <td>pic_spec_small</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>小图规格</td> </tr> <tr> <td>pic_cover_micro</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>微图路径</td> </tr> <tr> <td>pic_size_micro</td> <td>varchar(255)</td> <td>0</td> <td>NO</td> <td></td> <td>微图大小</td> </tr> <tr> <td>pic_spec_micro</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>微图规格</td> </tr> <tr> <td>upload_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>图片上传时间</td> </tr> </tbody> </table> <h3>sys_area全部区域表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>area_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>area_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_city</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>city_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>province_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>city_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>zipcode</td> <td>varchar(6)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>sort</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_config第三方配置表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>实例ID</td> </tr> <tr> <td>key</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>配置项WCHAT,QQ,WPAY,ALIPAY...</td> </tr> <tr> <td>value</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>配置值json</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>desc</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>描述</td> </tr> <tr> <td>is_use</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否启用 1启用 0不启用</td> </tr> </tbody> </table> <h3>sys_district</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>district_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>city_id</td> <td>int(11)</td> <td>0</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>district_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>sort</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_instance系统实例表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>instance_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>实例名</td> </tr> <tr> <td>instance_typeid</td> <td>int(11)</td> <td>2</td> <td>NO</td> <td></td> <td>实例类型ID</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>qrcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>实例二维码</td> </tr> <tr> <td>remark</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>实例简介</td> </tr> </tbody> </table> <h3>sys_instance_type实例类型</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>instance_typeid</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>实例类型ID</td> </tr> <tr> <td>type_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>实例类型名称</td> </tr> <tr> <td>type_module_array</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>实例类型权限</td> </tr> <tr> <td>type_desc</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>实例类型说明</td> </tr> <tr> <td>type_sort</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> </tbody> </table> <h3>sys_module系统模块表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>module_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>模块ID</td> </tr> <tr> <td>module_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模块标题</td> </tr> <tr> <td>module</td> <td>varchar(255)</td> <td>admin</td> <td>NO</td> <td></td> <td>项目名</td> </tr> <tr> <td>controller</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>控制器名</td> </tr> <tr> <td>method</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>方法名</td> </tr> <tr> <td>pid</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>上级模块ID</td> </tr> <tr> <td>level</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>深度等级</td> </tr> <tr> <td>url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>链接地址</td> </tr> <tr> <td>is_menu</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是菜单</td> </tr> <tr> <td>is_dev</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否仅开发者模式可见</td> </tr> <tr> <td>sort</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>排序(同级有效)</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>模块描述</td> </tr> <tr> <td>module_picture</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>模块图片</td> </tr> <tr> <td>icon_class</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>矢量图class</td> </tr> <tr> <td>is_control_auth</td> <td>tinyint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否控制权限</td> </tr> </tbody> </table> <h3>sys_notice网站公告</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>shopid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID(单店版为0)</td> </tr> <tr> <td>notice_message</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>公告内容</td> </tr> <tr> <td>is_enable</td> <td>tinyint(1)</td> <td>0</td> <td>YES</td> <td></td> <td>是否启用(0:隐藏,1:显示)</td> </tr> </tbody> </table> <h3>sys_notice_template通知模版设置</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>template_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>模板id</td> </tr> <tr> <td>template_type</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板类型</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>template_code</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板编号</td> </tr> <tr> <td>template_title</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板编号</td> </tr> <tr> <td>template_content</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>模板名称</td> </tr> <tr> <td>sign_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>签名</td> </tr> <tr> <td>is_enable</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否开启</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>更新时间</td> </tr> </tbody> </table> <h3>sys_notice_template_item通知模板项</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>item_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>项名称</td> </tr> <tr> <td>show_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>显示名称</td> </tr> <tr> <td>replace_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>替换字段名字</td> </tr> <tr> <td>type_ids</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>关联type类型</td> </tr> <tr> <td>order</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> </tbody> </table> <h3>sys_notice_template_type通知模板类型</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>type_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>template_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板名称</td> </tr> <tr> <td>template_code</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板编号</td> </tr> <tr> <td>template_type</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模板类型</td> </tr> </tbody> </table> <h3>sys_province</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>province_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>area_id</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>province_name</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>sort</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_user系统用户表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>uid</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>实例信息</td> </tr> <tr> <td>user_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>用户名</td> </tr> <tr> <td>user_password</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>用户密码(MD5)</td> </tr> <tr> <td>user_status</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>用户状态 用户状态默认为1</td> </tr> <tr> <td>user_headimg</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>用户头像</td> </tr> <tr> <td>is_system</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是系统后台用户 0 不是 1 是</td> </tr> <tr> <td>is_member</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是前台会员</td> </tr> <tr> <td>user_tel</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>手机号</td> </tr> <tr> <td>user_tel_bind</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>手机号是否绑定 0 未绑定 1 绑定</td> </tr> <tr> <td>user_qq</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>qq号</td> </tr> <tr> <td>qq_openid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>qq互联id</td> </tr> <tr> <td>qq_info</td> <td>varchar(2000)</td> <td></td> <td>NO</td> <td></td> <td>qq账号相关信息</td> </tr> <tr> <td>user_email</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>邮箱</td> </tr> <tr> <td>user_email_bind</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否邮箱绑定</td> </tr> <tr> <td>wx_openid</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>微信用户openid</td> </tr> <tr> <td>wx_sub_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>微信用户关注时间</td> </tr> <tr> <td>wx_notsub_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>微信用户取消关注时间</td> </tr> <tr> <td>wx_is_sub</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>微信用户是否关注</td> </tr> <tr> <td>wx_info</td> <td>varchar(2000)</td> <td></td> <td>YES</td> <td></td> <td>微信用户信息</td> </tr> <tr> <td>other_info</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>附加信息</td> </tr> <tr> <td>reg_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>注册时间</td> </tr> <tr> <td>current_login_ip</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>当前登录ip</td> </tr> <tr> <td>current_login_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>当前登录时间</td> </tr> <tr> <td>current_login_type</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td>当前登录的操作终端类型</td> </tr> <tr> <td>last_login_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>上次登录时间</td> </tr> <tr> <td>last_login_ip</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>上次登录ip</td> </tr> <tr> <td>last_login_type</td> <td>int(11)</td> <td></td> <td>YES</td> <td></td> <td>上次登录的操作终端类型</td> </tr> <tr> <td>login_num</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>登录次数</td> </tr> <tr> <td>real_name</td> <td>varchar(50)</td> <td></td> <td>YES</td> <td></td> <td>真实姓名</td> </tr> <tr> <td>sex</td> <td>smallint(6)</td> <td>0</td> <td>YES</td> <td></td> <td>性别 0保密 1男 2女</td> </tr> <tr> <td>birthday</td> <td>date</td> <td>0000-00-00</td> <td>YES</td> <td></td> <td>生日</td> </tr> <tr> <td>location</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>所在地</td> </tr> <tr> <td>nick_name</td> <td>varchar(50)</td> <td>牛酷用户</td> <td>YES</td> <td></td> <td>用户昵称</td> </tr> <tr> <td>wx_unionid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>微信unionid</td> </tr> <tr> <td>qrcode_template_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>模板id</td> </tr> </tbody> </table> <h3>sys_user_admin后台管理员表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>user用户ID</td> </tr> <tr> <td>admin_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>用户姓名</td> </tr> <tr> <td>group_id_array</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>系统用户组</td> </tr> <tr> <td>is_admin</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是系统管理员组</td> </tr> <tr> <td>admin_status</td> <td>int(11)</td> <td>1</td> <td>YES</td> <td></td> <td>状态 默认为1</td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>附加信息</td> </tr> </tbody> </table> <h3>sys_user_group系统用户组表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>group_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>实例ID</td> </tr> <tr> <td>group_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>用户组名称</td> </tr> <tr> <td>group_status</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>用户组状态</td> </tr> <tr> <td>is_system</td> <td>int(1)</td> <td>0</td> <td>NO</td> <td></td> <td>是否是系统用户组</td> </tr> <tr> <td>module_id_array</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>系统模块ID组,用,隔开</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>描述</td> </tr> </tbody> </table> <h3>sys_user_log用户操作日志</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>操作用户ID</td> </tr> <tr> <td>is_system</td> <td>int(11)</td> <td>1</td> <td>NO</td> <td></td> <td>是否是后台操作</td> </tr> <tr> <td>controller</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>操作控制器</td> </tr> <tr> <td>method</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>操作方案</td> </tr> <tr> <td>data</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>传输数据</td> </tr> <tr> <td>ip</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>ip地址</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>创建时间</td> </tr> </tbody> </table> <h3>sys_web_style网站前台样式表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>style_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>style_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>样式名称</td> </tr> <tr> <td>style_path</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>样式路径</td> </tr> <tr> <td>stye_img</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>样式图片路径</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改时间</td> </tr> <tr> <td>desc</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>sys_website网站信息表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>website_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>主键ID</td> </tr> <tr> <td>title</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站标题</td> </tr> <tr> <td>logo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站logo</td> </tr> <tr> <td>web_desc</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>网站描述</td> </tr> <tr> <td>key_words</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站关键字</td> </tr> <tr> <td>web_icp</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站备案号</td> </tr> <tr> <td>style_id</td> <td>int(10)</td> <td>0</td> <td>NO</td> <td></td> <td>网站风格</td> </tr> <tr> <td>web_address</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站联系地址</td> </tr> <tr> <td>web_qrcode</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站公众号二维码</td> </tr> <tr> <td>web_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺网址</td> </tr> <tr> <td>web_email</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站邮箱</td> </tr> <tr> <td>web_phone</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站联系方式</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>网站创建时间</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>网站修改时间</td> </tr> <tr> <td>web_qq</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站qq号</td> </tr> <tr> <td>web_weixin</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>网站微信号</td> </tr> <tr> <td>web_status</td> <td>int(10)</td> <td>1</td> <td>NO</td> <td></td> <td>网站运营状态1.开启 2.关闭</td> </tr> <tr> <td>third_count</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>第三方统计</td> </tr> <tr> <td>close_reason</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>站点关闭原因</td> </tr> <tr> <td>wap_status</td> <td>int(10)</td> <td>1</td> <td>NO</td> <td></td> <td>手机端运营状态 1.开启2.关闭</td> </tr> </tbody> </table> <h3>sys_weixin_auth店铺(实例)微信公众账号授权</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>authorizer_appid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺的appid 授权之后不用刷新</td> </tr> <tr> <td>authorizer_refresh_token</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺授权之后的刷新token,每月刷新</td> </tr> <tr> <td>authorizer_access_token</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>店铺的公众号token,只有2小时</td> </tr> <tr> <td>func_info</td> <td>varchar(1000)</td> <td></td> <td>NO</td> <td></td> <td>授权项目</td> </tr> <tr> <td>nick_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>公众号昵称</td> </tr> <tr> <td>head_img</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>公众号头像url</td> </tr> <tr> <td>user_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>公众号原始账号</td> </tr> <tr> <td>alias</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>公众号原始名称</td> </tr> <tr> <td>qrcode_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>公众号二维码url</td> </tr> <tr> <td>auth_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>授权时间</td> </tr> </tbody> </table> <h3>sys_weixin_default_replay关注时回复</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>reply_media_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>回复媒体内容id</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_weixin_fans微信公众号获取粉丝列表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>fans_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>粉丝ID</td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>会员编号ID</td> </tr> <tr> <td>source_uid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>推广人uid</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺ID</td> </tr> <tr> <td>nickname</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>昵称</td> </tr> <tr> <td>nickname_decode</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>headimgurl</td> <td>varchar(500)</td> <td></td> <td>NO</td> <td></td> <td>头像</td> </tr> <tr> <td>sex</td> <td>smallint(6)</td> <td>1</td> <td>NO</td> <td></td> <td>性别</td> </tr> <tr> <td>language</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>用户语言</td> </tr> <tr> <td>country</td> <td>varchar(60)</td> <td></td> <td>NO</td> <td></td> <td>国家</td> </tr> <tr> <td>province</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>省</td> </tr> <tr> <td>city</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>城市</td> </tr> <tr> <td>district</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>行政区/县</td> </tr> <tr> <td>openid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>用户的标识,对当前公众号唯一 用户的唯一身份ID</td> </tr> <tr> <td>unionid</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>粉丝unionid</td> </tr> <tr> <td>groupid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>粉丝所在组id</td> </tr> <tr> <td>is_subscribe</td> <td>bigint(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否订阅</td> </tr> <tr> <td>subscribe_date</td> <td>datetime</td> <td></td> <td>NO</td> <td></td> <td>订阅时间</td> </tr> <tr> <td>unsubscribe_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>解订阅时间</td> </tr> <tr> <td>update_date</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>粉丝信息最后更新时间</td> </tr> <tr> <td>memo</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>备注</td> </tr> </tbody> </table> <h3>sys_weixin_follow_replay关注时回复</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>reply_media_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>回复媒体内容id</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_weixin_functions_button微信功能按钮</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>button_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键id</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>实例</td> </tr> <tr> <td>button_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>模块名</td> </tr> <tr> <td>keyname</td> <td>varchar(20)</td> <td></td> <td>NO</td> <td></td> <td>触发关键词</td> </tr> <tr> <td>url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>触发网址</td> </tr> <tr> <td>hits</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>触发次数</td> </tr> <tr> <td>is_enabled</td> <td>int(1)</td> <td>1</td> <td>NO</td> <td></td> <td>是否启用</td> </tr> <tr> <td>is_system</td> <td>int(1)</td> <td>0</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>orders</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>创建日期</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td></td> <td>YES</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>sys_weixin_instance_msg微信实例消息</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id(单店版为0)</td> </tr> <tr> <td>template_no</td> <td>varchar(55)</td> <td></td> <td>NO</td> <td></td> <td>模版编号</td> </tr> <tr> <td>template_id</td> <td>varbinary(55)</td> <td></td> <td>YES</td> <td></td> <td>微信模板消息的ID</td> </tr> <tr> <td>title</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>模版标题</td> </tr> <tr> <td>is_enable</td> <td>bit(1)</td> <td>b'0'</td> <td>YES</td> <td></td> <td>是否启用</td> </tr> <tr> <td>headtext</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>头部文字</td> </tr> <tr> <td>bottomtext</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>底部文字</td> </tr> </tbody> </table> <h3>sys_weixin_key_replay关键词回复</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>key</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>关键词</td> </tr> <tr> <td>match_type</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>匹配类型1模糊匹配2全部匹配</td> </tr> <tr> <td>reply_media_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>回复媒体内容id</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_weixin_media</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>media_id</td> <td>int(11) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>图文消息id</td> </tr> <tr> <td>title</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>标题</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>实例id店铺id</td> </tr> <tr> <td>type</td> <td>varchar(255)</td> <td>1</td> <td>NO</td> <td></td> <td>类型1文本(项表无内容) 2单图文 3多图文</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建日期</td> </tr> <tr> <td>modify_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>sys_weixin_media_item</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td>id</td> </tr> <tr> <td>media_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>图文消息id</td> </tr> <tr> <td>title</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>标题</td> </tr> <tr> <td>author</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>作者</td> </tr> <tr> <td>cover</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>图文消息封面</td> </tr> <tr> <td>show_cover_pic</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>封面图片显示在正文中</td> </tr> <tr> <td>summary</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>摘要</td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>NO</td> <td></td> <td>正文</td> </tr> <tr> <td>content_source_url</td> <td>varchar(200)</td> <td></td> <td>NO</td> <td></td> <td>图文消息的原文地址,即点击“阅读原文”后的URL</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序号</td> </tr> <tr> <td>hits</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>阅读次数</td> </tr> </tbody> </table> <h3>sys_weixin_menu微设置->微店菜单</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>menu_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>menu_name</td> <td>varchar(50)</td> <td></td> <td>NO</td> <td></td> <td>菜单名称</td> </tr> <tr> <td>ico</td> <td>varchar(32)</td> <td></td> <td>NO</td> <td></td> <td>菜图标单</td> </tr> <tr> <td>pid</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>父菜单</td> </tr> <tr> <td>menu_event_type</td> <td>tinyint(4)</td> <td>1</td> <td>NO</td> <td></td> <td>1普通url 2 图文素材 3 功能</td> </tr> <tr> <td>media_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>图文消息ID</td> </tr> <tr> <td>menu_event_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>菜单url</td> </tr> <tr> <td>hits</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>触发数</td> </tr> <tr> <td>sort</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>排序</td> </tr> <tr> <td>create_date</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>创建日期</td> </tr> <tr> <td>modify_date</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td>修改日期</td> </tr> </tbody> </table> <h3>sys_weixin_msg_template微信消息模版</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>主键</td> </tr> <tr> <td>template_no</td> <td>varchar(55)</td> <td></td> <td>NO</td> <td></td> <td>编号</td> </tr> <tr> <td>title</td> <td>varchar(100)</td> <td></td> <td>NO</td> <td></td> <td>标题</td> </tr> <tr> <td>contents</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>内容示例</td> </tr> <tr> <td>template_id</td> <td>varchar(55)</td> <td></td> <td>YES</td> <td></td> <td>模版id</td> </tr> <tr> <td>headtext</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>头部文字</td> </tr> <tr> <td>bottomtext</td> <td>varchar(255)</td> <td></td> <td>YES</td> <td></td> <td>底部文字</td> </tr> </tbody> </table> <h3>sys_weixin_qrcode_template微信推广二维码模板管理</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td></td> <td>NO</td> <td>是</td> <td>实例ID</td> </tr> <tr> <td>instance_id</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>店铺id</td> </tr> <tr> <td>background</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>背景图片</td> </tr> <tr> <td>nick_font_color</td> <td>varchar(255)</td> <td>#000</td> <td>NO</td> <td></td> <td>昵称字体颜色</td> </tr> <tr> <td>nick_font_size</td> <td>smallint(6)</td> <td>12</td> <td>NO</td> <td></td> <td>昵称字体大小</td> </tr> <tr> <td>is_logo_show</td> <td>smallint(6)</td> <td>1</td> <td>NO</td> <td></td> <td>logo是否显示</td> </tr> <tr> <td>header_left</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>头部左边距</td> </tr> <tr> <td>header_top</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>头部上边距</td> </tr> <tr> <td>name_left</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>昵称左边距</td> </tr> <tr> <td>name_top</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>昵称上边距</td> </tr> <tr> <td>logo_left</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>logo左边距</td> </tr> <tr> <td>logo_top</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>logo上边距</td> </tr> <tr> <td>code_left</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>二维码左边距</td> </tr> <tr> <td>code_top</td> <td>varchar(6)</td> <td>0px</td> <td>NO</td> <td></td> <td>二维码上边距</td> </tr> <tr> <td>is_check</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否默认</td> </tr> <tr> <td>is_remove</td> <td>tinyint(4)</td> <td>0</td> <td>NO</td> <td></td> <td>是否删除 0未删除 1删除</td> </tr> <tr> <td>template_url</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td>模板样式路径</td> </tr> </tbody> </table> <h3>sys_weixin_user_msg微信用户消息表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>msg_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>msg_type</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>is_replay</td> <td>int(11)</td> <td>0</td> <td>NO</td> <td></td> <td>是否回复</td> </tr> </tbody> </table> <h3>sys_weixin_user_msg_replay微信用户消息回复表</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>replay_id</td> <td>int(10) unsigned</td> <td></td> <td>NO</td> <td>是</td> <td></td> </tr> <tr> <td>msg_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>replay_uid</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>当前客服uid</td> </tr> <tr> <td>replay_type</td> <td>varchar(255)</td> <td></td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>content</td> <td>text</td> <td></td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>replay_time</td> <td>datetime</td> <td>0000-00-00 00:00:00</td> <td>NO</td> <td></td> <td></td> </tr> </tbody> </table> <h3>sys_wexin_onekeysubscribe微信一键关注设置</h3> <table > <thead> <tr> <th>字段名</th> <th>数据类型</th> <th>默认值</th> <th>允许非空</th> <th>自动递增</th> <th>备注</th> </tr> </thead> <tbody> <tr> <td>instance_id</td> <td>int(11)</td> <td></td> <td>NO</td> <td></td> <td>实例ID</td> </tr> <tr> <td>url</td> <td>varchar(300)</td> <td></td> <td>NO</td> <td></td> <td>一键关注url</td> </tr> </tbody> </table> </div>