<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>