數據字典 · shopxo 商城分析

## 數據字典 ```[sql] /* Navicat MySQL Data Transfer Source Server : 127.0.0.1_3306 Source Server Version : 50724 Source Host : 127.0.0.1:3306 Source Database : shopxo Target Server Type : MYSQL Target Server Version : 50724 File Encoding : 65001 Date: 2019-02-26 11:40:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `s_admin` -- ---------------------------- DROP TABLE IF EXISTS `s_admin`; CREATE TABLE `s_admin` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理員id' , `username` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶名' , `login_pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼' , `login_salt` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼配合加密字符串' , `mobile` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手機號碼' , `gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性別（0保密，1女，2男）' , `login_total` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登錄次數' , `login_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后登錄時間' , `role_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所屬角色組' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理員' AUTO_INCREMENT=4 ; -- ---------------------------- -- Table structure for `s_answer` -- ---------------------------- DROP TABLE IF EXISTS `s_answer`; CREATE TABLE `s_answer` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '聯系人' , `tel` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '聯系電話' , `content` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '詳細內容' , `reply` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '回復內容' , `is_reply` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否已回復（0否, 1是）' , `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否顯示（0不顯示, 1顯示）' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已刪除（0否, 大于0刪除時間）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `user_id` (`name`) USING BTREE , INDEX `is_delete_time` (`is_delete_time`) USING BTREE , INDEX `is_show` (`is_show`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶留言/問答' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_app_home_nav` -- ---------------------------- DROP TABLE IF EXISTS `s_app_home_nav`; CREATE TABLE `s_app_home_nav` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `platform` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pc' COMMENT '所屬平臺（pc PC網站, h5 H5手機網站, app 手機APP, alipay 支付寶小程序, weixin 微信小程序, baidu 百度小程序）' , `event_type` tinyint(2) NOT NULL DEFAULT '-1' COMMENT '事件類型（0 WEB頁面, 1 內部頁面(小程序或APP內部地址), 2 外部小程序(同一個主體下的小程序appid), 3 打開地圖, 4 撥打電話）' , `event_value` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '事件值' , `images_url` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片地址' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '別名' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `bg_color` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'css背景色值' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `platform` (`platform`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `sort` (`sort`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='手機 - 首頁導航' AUTO_INCREMENT=5 ; -- ---------------------------- -- Table structure for `s_article` -- ---------------------------- DROP TABLE IF EXISTS `s_article`; CREATE TABLE `s_article` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `title` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `article_category_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章分類' , `title_color` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '標題顏色' , `jump_url` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '跳轉url地址' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '內容' , `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '圖片數據（一維數組json）' , `image_count` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章圖片數量' , `access_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訪問次數' , `is_home_recommended` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否首頁推薦（0否, 1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `title` (`title`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `access_count` (`access_count`) USING BTREE , INDEX `image_count` (`image_count`) USING BTREE , INDEX `article_category_id` (`article_category_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文章' AUTO_INCREMENT=30 ; -- ---------------------------- -- Table structure for `s_article_category` -- ---------------------------- DROP TABLE IF EXISTS `s_article_category`; CREATE TABLE `s_article_category` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分類id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `name` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名稱' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `pid` (`pid`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文章分類' AUTO_INCREMENT=25 ; -- ---------------------------- -- Table structure for `s_brand` -- ---------------------------- DROP TABLE IF EXISTS `s_brand`; CREATE TABLE `s_brand` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `brand_category_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '品牌分類id' , `logo` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'logo圖標' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名稱' , `website_url` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '官網地址' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='品牌' AUTO_INCREMENT=3 ; -- ---------------------------- -- Table structure for `s_brand_category` -- ---------------------------- DROP TABLE IF EXISTS `s_brand_category`; CREATE TABLE `s_brand_category` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分類id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `name` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名稱' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `pid` (`pid`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='品牌分類' AUTO_INCREMENT=32 ; -- ---------------------------- -- Table structure for `s_cart` -- ---------------------------- DROP TABLE IF EXISTS `s_cart`; CREATE TABLE `s_cart` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '用戶id' , `goods_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '商品id' , `title` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '封面圖片' , `original_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '原價' , `price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '銷售價格' , `stock` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '購買數量' , `spec` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '規格' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE , INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `title` (`title`) USING BTREE , INDEX `stock` (`stock`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='購物車' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_config` -- ---------------------------- DROP TABLE IF EXISTS `s_config`; CREATE TABLE `s_config` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '基本設置id' , `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '值' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名稱' , `describe` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述' , `error_tips` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '錯誤提示' , `type` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '類型（admin后臺, home前臺）' , `only_tag` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一的標記' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), UNIQUE INDEX `only_tag` (`only_tag`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='基本配置參數' AUTO_INCREMENT=86 ; -- ---------------------------- -- Table structure for `s_custom_view` -- ---------------------------- DROP TABLE IF EXISTS `s_custom_view`; CREATE TABLE `s_custom_view` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `title` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '內容' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `is_header` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否包含頭部（0否, 1是）' , `is_footer` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否包含尾部（0否, 1是）' , `is_full_screen` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否滿屏（0否, 1是）' , `image` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '圖片數據（一維數組json）' , `image_count` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章圖片數量' , `access_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訪問次數' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `title` (`title`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `access_count` (`access_count`) USING BTREE , INDEX `image_count` (`image_count`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='自定義頁面' AUTO_INCREMENT=2 ; -- ---------------------------- -- Table structure for `s_express` -- ---------------------------- DROP TABLE IF EXISTS `s_express`; CREATE TABLE `s_express` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `icon` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'icon圖標' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名稱' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='快遞公司' AUTO_INCREMENT=15 ; -- ---------------------------- -- Table structure for `s_goods` -- ---------------------------- DROP TABLE IF EXISTS `s_goods`; CREATE TABLE `s_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `brand_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '品牌id' , `title` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `title_color` char(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題顏色' , `model` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '型號' , `place_origin` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '產地（地區省id）' , `inventory` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '庫存（所有規格庫存總和）' , `inventory_unit` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '庫存單位' , `images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '封面圖片' , `original_price` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '原價（單值:10, 區間:10.00-20.00）一般用于展示使用' , `min_original_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低原價' , `max_original_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最大原價' , `price` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '銷售價格（單值:10, 區間:10.00-20.00）一般用于展示使用' , `min_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低價格' , `max_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最高價格' , `give_integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '購買贈送積分' , `buy_min_number` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最低起購數量（默認1）' , `buy_max_number` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大購買數量（最大數值 100000000, 小于等于0或空則不限）' , `is_deduction_inventory` tinyint(2) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否扣減庫存（0否, 1是）' , `is_shelves` tinyint(2) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否上架（下架后用戶不可見, 0否, 1是）' , `is_home_recommended` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否首頁推薦（0否, 1是）' , `content_web` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '電腦端詳情內容' , `photo_count` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '相冊圖片數量' , `sales_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '銷量' , `access_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訪問次數' , `video` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '短視頻' , `home_recommended_images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '首頁推薦圖片' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已刪除（0 未刪除, 大于0則是刪除時間）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `title` (`title`) USING BTREE , INDEX `access_count` (`access_count`) USING BTREE , INDEX `photo_count` (`photo_count`) USING BTREE , INDEX `is_shelves` (`is_shelves`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品' AUTO_INCREMENT=13 ; -- ---------------------------- -- Table structure for `s_goods_browse` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_browse`; CREATE TABLE `s_goods_browse` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶商品瀏覽' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_goods_category` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_category`; CREATE TABLE `s_goods_category` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `icon` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'icon圖標' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名稱' , `vice_name` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '副標題' , `describe` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述' , `bg_color` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'css背景色值' , `big_images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '大圖片' , `is_home_recommended` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否首頁推薦（0否, 1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `pid` (`pid`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `sort` (`sort`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品分類' AUTO_INCREMENT=893 ; -- ---------------------------- -- Table structure for `s_goods_category_join` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_category_join`; CREATE TABLE `s_goods_category_join` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `category_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分類id' , `add_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `category_id` (`category_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品分類關聯' AUTO_INCREMENT=58 ; -- ---------------------------- -- Table structure for `s_goods_content_app` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_content_app`; CREATE TABLE `s_goods_content_app` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片' , `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '內容' , `sort` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `sort` (`sort`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品手機詳情' AUTO_INCREMENT=102 ; -- ---------------------------- -- Table structure for `s_goods_favor` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_favor`; CREATE TABLE `s_goods_favor` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶商品收藏' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_goods_photo` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_photo`; CREATE TABLE `s_goods_photo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片' , `is_show` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '是否顯示（0否, 1是）' , `sort` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `is_show` (`is_show`) USING BTREE , INDEX `sort` (`sort`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品相冊圖片' AUTO_INCREMENT=78 ; -- ---------------------------- -- Table structure for `s_goods_spec_base` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_spec_base`; CREATE TABLE `s_goods_spec_base` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '銷售價格' , `inventory` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '庫存' , `weight` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '重量（kg） ' , `coding` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '編碼' , `barcode` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '條形碼' , `original_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '原價' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `attribute_type_id` (`price`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品規格基礎' AUTO_INCREMENT=114 ; -- ---------------------------- -- Table structure for `s_goods_spec_type` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_spec_type`; CREATE TABLE `s_goods_spec_type` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '類型值（json字符串存儲）' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '類型名稱' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `goods_id` (`goods_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品規格類型' AUTO_INCREMENT=34 ; -- ---------------------------- -- Table structure for `s_goods_spec_value` -- ---------------------------- DROP TABLE IF EXISTS `s_goods_spec_value`; CREATE TABLE `s_goods_spec_value` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `goods_spec_base_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品規格基礎id' , `value` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '規格值' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `goods_spec_base_id` (`goods_spec_base_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品規格值' AUTO_INCREMENT=221 ; -- ---------------------------- -- Table structure for `s_link` -- ---------------------------- DROP TABLE IF EXISTS `s_link`; CREATE TABLE `s_link` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `name` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '導航名稱' , `url` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'url地址' , `describe` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `is_new_window_open` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否新窗口打開（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `sort` (`sort`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='友情鏈接' AUTO_INCREMENT=18 ; -- ---------------------------- -- Table structure for `s_message` -- ---------------------------- DROP TABLE IF EXISTS `s_message`; CREATE TABLE `s_message` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `title` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `detail` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '詳情' , `business_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '業務id' , `business_type` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '業務類型（0默認, 1訂單, ...）' , `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '消息類型（0普通通知, ...）' , `is_read` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否已讀（0否, 1是）' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已刪除（0否, 大于0刪除時間）' , `user_is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶是否已刪除（0否, 大于0刪除時間）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='消息' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_navigation` -- ---------------------------- DROP TABLE IF EXISTS `s_navigation`; CREATE TABLE `s_navigation` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `name` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '導航名稱' , `url` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'url地址' , `value` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分類id' , `data_type` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '數據類型（custom:自定義導航, article_class:文章分類, customview:自定義頁面）' , `nav_type` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '導航類型（header:頂部導航, footer:底部導航）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否顯示（0否，1是）' , `is_new_window_open` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否新窗口打開（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `is_show` (`is_show`) USING BTREE , INDEX `sort` (`sort`) USING BTREE , INDEX `nav_type` (`nav_type`) USING BTREE , INDEX `pid` (`pid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='導航' AUTO_INCREMENT=32 ; -- ---------------------------- -- Table structure for `s_order` -- ---------------------------- DROP TABLE IF EXISTS `s_order`; CREATE TABLE `s_order` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `order_no` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '訂單號' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `shop_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪id' , `receive_address_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收件地址id' , `receive_name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收件人-姓名' , `receive_tel` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收件人-電話' , `receive_province` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收件人-省' , `receive_city` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收件人-市' , `receive_county` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收件人-縣/區' , `receive_address` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收件人-詳細地址' , `user_note` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶備注' , `express_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '快遞id' , `express_number` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '快遞單號' , `payment_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '支付方式id' , `status` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單狀態（0待確認, 1已確認/待支付, 2已支付/待發貨, 3已發貨/待收貨, 4已完成, 5已取消, 6已關閉）' , `pay_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付狀態（0未支付, 1已支付, 2已退款）' , `preferential_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '優惠金額' , `price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '訂單單價' , `total_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '訂單總價(訂單最終價格)' , `pay_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已支付金額' , `pay_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付時間' , `confirm_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '確認時間' , `delivery_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '發貨時間' , `cancel_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '取消時間' , `collect_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收貨時間' , `close_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '關閉時間' , `comments_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '評論時間' , `is_comments` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商家是否已評論（0否, 大于0評論時間）' , `user_is_comments` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶是否已評論（0否, 大于0評論時間）' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商家是否已刪除（0否, 大于0刪除時間）' , `user_is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶是否已刪除（0否, 大于0刪除時間）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), UNIQUE INDEX `order_no` (`order_no`) USING BTREE , INDEX `user_id` (`user_id`) USING BTREE , INDEX `shop_id` (`shop_id`) USING BTREE , INDEX `status` (`status`) USING BTREE , INDEX `pay_status` (`pay_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='訂單' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_order_comments` -- ---------------------------- DROP TABLE IF EXISTS `s_order_comments`; CREATE TABLE `s_order_comments` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `shop_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪id' , `order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `content` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '評價內容' , `rating` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '評價級別（默認0 1~5）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE , INDEX `shop_id` (`shop_id`) USING BTREE , INDEX `order_id` (`order_id`) USING BTREE , INDEX `goods_id` (`goods_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='訂單評價' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_order_detail` -- ---------------------------- DROP TABLE IF EXISTS `s_order_detail`; CREATE TABLE `s_order_detail` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `shop_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪id' , `title` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題' , `images` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '封面圖片' , `original_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '原價' , `price` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '訂單價格' , `spec` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '規格' , `buy_number` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '購買數量' , `spec_weight` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '重量（kg）' , `spec_coding` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '編碼' , `spec_barcode` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '條形碼' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE , INDEX `order_id` (`order_id`) USING BTREE , INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `shop_id` (`shop_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='訂單詳情' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_order_goods_inventory_log` -- ---------------------------- DROP TABLE IF EXISTS `s_order_goods_inventory_log`; CREATE TABLE `s_order_goods_inventory_log` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單id' , `goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' , `order_status` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單狀態（0待確認, 1已確認/待支付, 2已支付/待發貨, 3已發貨/待收貨, 4已完成, 5已取消, 6已關閉）' , `original_inventory` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '原庫存' , `new_inventory` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最新庫存' , `is_rollback` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否回滾（0否, 1是）' , `rollback_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '回滾時間' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創建時間' , PRIMARY KEY (`id`), INDEX `order_id` (`order_id`) USING BTREE , INDEX `goods_id` (`goods_id`) USING BTREE , INDEX `order_status` (`order_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='訂單商品庫存變更日志' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_order_status_history` -- ---------------------------- DROP TABLE IF EXISTS `s_order_status_history`; CREATE TABLE `s_order_status_history` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單id' , `original_status` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '原始狀態' , `new_status` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '最新狀態' , `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作描述' , `creator` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創建-用戶id' , `creator_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '創建人-姓名' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創建時間' , PRIMARY KEY (`id`), INDEX `order_id` (`order_id`) USING BTREE , INDEX `original_status` (`original_status`) USING BTREE , INDEX `new_status` (`new_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='訂單狀態歷史紀錄' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_pay_log` -- ---------------------------- DROP TABLE IF EXISTS `s_pay_log`; CREATE TABLE `s_pay_log` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '支付日志id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `order_id` int(11) UNSIGNED NOT NULL COMMENT '訂單id' , `trade_no` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付平臺交易號' , `buyer_user` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付平臺用戶帳號' , `pay_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付金額' , `total_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單實際金額' , `subject` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '訂單名稱' , `payment` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付方式標記' , `payment_name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付方式名稱' , `business_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '業務類型（0默認, 1訂單, ...）' , `add_time` int(11) UNSIGNED NOT NULL COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `pay_type` (`payment`) USING BTREE , INDEX `order_id` (`order_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支付日志' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_payment` -- ---------------------------- DROP TABLE IF EXISTS `s_payment`; CREATE TABLE `s_payment` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名稱' , `payment` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一標記' , `logo` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'logo' , `version` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '插件版本' , `apply_version` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '適用系統版本' , `desc` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '插件描述' , `author` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '作者' , `author_url` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '作者主頁' , `element` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置項規則' , `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置數據' , `apply_terminal` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '適用終端 php一維數組json字符串存儲（pc, wap, app, alipay, weixin, baidu）' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `is_open_user` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否對用戶開放' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), UNIQUE INDEX `payment` (`payment`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支付方式' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_plugins` -- ---------------------------- DROP TABLE IF EXISTS `s_plugins`; CREATE TABLE `s_plugins` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `plugins` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一標記' , `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '應用數據' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), UNIQUE INDEX `plugins` (`plugins`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='應用' AUTO_INCREMENT=20 ; -- ---------------------------- -- Table structure for `s_power` -- ---------------------------- DROP TABLE IF EXISTS `s_power`; CREATE TABLE `s_power` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '權限id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '權限父級id' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '權限名稱' , `control` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '控制器名稱' , `action` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '方法名稱' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否顯示（0否，1是）' , `icon` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖標class' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='權限' AUTO_INCREMENT=351 ; -- ---------------------------- -- Table structure for `s_region` -- ---------------------------- DROP TABLE IF EXISTS `s_region`; CREATE TABLE `s_region` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名稱' , `level` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '級別類型（1:一級[所有省], 2：二級[所有市], 3:三級[所有區縣], 4:街道[所有街道]）' , `letters` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市首字母' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `pid` (`pid`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `sort` (`sort`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='地區' AUTO_INCREMENT=45057 ; -- ---------------------------- -- Table structure for `s_role` -- ---------------------------- DROP TABLE IF EXISTS `s_role`; CREATE TABLE `s_role` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色組id' , `name` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名稱' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色組' AUTO_INCREMENT=14 ; -- ---------------------------- -- Table structure for `s_role_power` -- ---------------------------- DROP TABLE IF EXISTS `s_role_power`; CREATE TABLE `s_role_power` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '關聯id' , `role_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '角色id' , `power_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '權限id' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `role_id` (`role_id`) USING BTREE , INDEX `power_id` (`power_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色與權限管理' AUTO_INCREMENT=2604 ; -- ---------------------------- -- Table structure for `s_screening_price` -- ---------------------------- DROP TABLE IF EXISTS `s_screening_price`; CREATE TABLE `s_screening_price` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分類id' , `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id' , `name` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名稱' , `min_price` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最小價格' , `max_price` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大價格' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '順序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `pid` (`pid`) USING BTREE , INDEX `is_enable` (`is_enable`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='篩選價格' AUTO_INCREMENT=32 ; -- ---------------------------- -- Table structure for `s_search_history` -- ---------------------------- DROP TABLE IF EXISTS `s_search_history`; CREATE TABLE `s_search_history` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `brand_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '品牌id' , `category_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分類id' , `keywords` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '搜索關鍵字' , `screening_price` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '搜索價格區間' , `order_by_field` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '排序類型（字段名稱）' , `order_by_type` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '排序方式（asc, desc）' , `ymd` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '日期 ymd' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='搜索日志' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_slide` -- ---------------------------- DROP TABLE IF EXISTS `s_slide`; CREATE TABLE `s_slide` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `platform` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pc' COMMENT '所屬平臺（pc PC網站, h5 H5手機網站, alipay 支付寶小程序, weixin 微信小程序, baidu 百度小程序）' , `event_type` tinyint(2) NOT NULL DEFAULT '-1' COMMENT '事件類型（0 WEB頁面, 1 內部頁面(小程序或APP內部地址), 2 外部小程序(同一個主體下的小程序appid), 3 打開地圖, 4 撥打電話）' , `event_value` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '事件值' , `images_url` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片地址' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '別名' , `bg_color` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'css背景色值' , `is_enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否啟用（0否，1是）' , `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `is_enable` (`is_enable`) USING BTREE , INDEX `sort` (`sort`) USING BTREE , INDEX `platform` (`platform`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='輪播圖片' AUTO_INCREMENT=14 ; -- ---------------------------- -- Table structure for `s_user` -- ---------------------------- DROP TABLE IF EXISTS `s_user`; CREATE TABLE `s_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `alipay_openid` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付寶openid' , `weixin_openid` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信openid' , `baidu_openid` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '百度openid' , `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '狀態（0正常, 1禁止發言, 2禁止登錄）' , `salt` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '配合密碼加密串' , `pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼' , `username` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶名' , `nickname` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶昵稱' , `mobile` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手機號碼' , `email` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '電子郵箱（最大長度60個字符）' , `gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性別（0保密，1女，2男）' , `avatar` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶頭像地址' , `province` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所在省' , `city` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所在市' , `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '生日' , `address` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址' , `integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '積分' , `referrer` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推薦人用戶id' , `referrer_giving_integral_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推薦贈送積分次數（0未贈送, 大于0則是贈送次數）' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已刪除（0否, 大于0刪除時間）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `alipay_openid` (`alipay_openid`) USING BTREE , INDEX `weixin_openid` (`weixin_openid`) USING BTREE , INDEX `mobile` (`mobile`) USING BTREE , INDEX `username` (`username`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶' AUTO_INCREMENT=91 ; -- ---------------------------- -- Table structure for `s_user_address` -- ---------------------------- DROP TABLE IF EXISTS `s_user_address`; CREATE TABLE `s_user_address` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '站點id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '站點所屬用戶id' , `alias` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '別名' , `name` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名' , `tel` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '電話' , `province` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在省' , `city` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在市' , `county` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在縣/區' , `address` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址' , `lng` decimal(13,10) UNSIGNED NOT NULL DEFAULT 0.0000000000 COMMENT '經度' , `lat` decimal(13,10) UNSIGNED NOT NULL DEFAULT 0.0000000000 COMMENT '緯度' , `is_default` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否默認地址（0否, 1是）' , `is_delete_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除（0否，1刪除時間戳）' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , `upd_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE , INDEX `is_enable` (`is_delete_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶地址' AUTO_INCREMENT=1 ; -- ---------------------------- -- Table structure for `s_user_integral_log` -- ---------------------------- DROP TABLE IF EXISTS `s_user_integral_log`; CREATE TABLE `s_user_integral_log` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id' , `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作類型（0減少, 1增加）' , `original_integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '原始積分' , `new_integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最新積分' , `msg` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作原因' , `operation_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作人員id' , `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間' , PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用戶積分日志' AUTO_INCREMENT=1 ; -- ---------------------------- -- Auto increment value for `s_admin` -- ---------------------------- ALTER TABLE `s_admin` AUTO_INCREMENT=4; -- ---------------------------- -- Auto increment value for `s_answer` -- ---------------------------- ALTER TABLE `s_answer` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_app_home_nav` -- ---------------------------- ALTER TABLE `s_app_home_nav` AUTO_INCREMENT=5; -- ---------------------------- -- Auto increment value for `s_article` -- ---------------------------- ALTER TABLE `s_article` AUTO_INCREMENT=30; -- ---------------------------- -- Auto increment value for `s_article_category` -- ---------------------------- ALTER TABLE `s_article_category` AUTO_INCREMENT=25; -- ---------------------------- -- Auto increment value for `s_brand` -- ---------------------------- ALTER TABLE `s_brand` AUTO_INCREMENT=3; -- ---------------------------- -- Auto increment value for `s_brand_category` -- ---------------------------- ALTER TABLE `s_brand_category` AUTO_INCREMENT=32; -- ---------------------------- -- Auto increment value for `s_cart` -- ---------------------------- ALTER TABLE `s_cart` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_config` -- ---------------------------- ALTER TABLE `s_config` AUTO_INCREMENT=86; -- ---------------------------- -- Auto increment value for `s_custom_view` -- ---------------------------- ALTER TABLE `s_custom_view` AUTO_INCREMENT=2; -- ---------------------------- -- Auto increment value for `s_express` -- ---------------------------- ALTER TABLE `s_express` AUTO_INCREMENT=15; -- ---------------------------- -- Auto increment value for `s_goods` -- ---------------------------- ALTER TABLE `s_goods` AUTO_INCREMENT=13; -- ---------------------------- -- Auto increment value for `s_goods_browse` -- ---------------------------- ALTER TABLE `s_goods_browse` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_goods_category` -- ---------------------------- ALTER TABLE `s_goods_category` AUTO_INCREMENT=893; -- ---------------------------- -- Auto increment value for `s_goods_category_join` -- ---------------------------- ALTER TABLE `s_goods_category_join` AUTO_INCREMENT=58; -- ---------------------------- -- Auto increment value for `s_goods_content_app` -- ---------------------------- ALTER TABLE `s_goods_content_app` AUTO_INCREMENT=102; -- ---------------------------- -- Auto increment value for `s_goods_favor` -- ---------------------------- ALTER TABLE `s_goods_favor` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_goods_photo` -- ---------------------------- ALTER TABLE `s_goods_photo` AUTO_INCREMENT=78; -- ---------------------------- -- Auto increment value for `s_goods_spec_base` -- ---------------------------- ALTER TABLE `s_goods_spec_base` AUTO_INCREMENT=114; -- ---------------------------- -- Auto increment value for `s_goods_spec_type` -- ---------------------------- ALTER TABLE `s_goods_spec_type` AUTO_INCREMENT=34; -- ---------------------------- -- Auto increment value for `s_goods_spec_value` -- ---------------------------- ALTER TABLE `s_goods_spec_value` AUTO_INCREMENT=221; -- ---------------------------- -- Auto increment value for `s_link` -- ---------------------------- ALTER TABLE `s_link` AUTO_INCREMENT=18; -- ---------------------------- -- Auto increment value for `s_message` -- ---------------------------- ALTER TABLE `s_message` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_navigation` -- ---------------------------- ALTER TABLE `s_navigation` AUTO_INCREMENT=32; -- ---------------------------- -- Auto increment value for `s_order` -- ---------------------------- ALTER TABLE `s_order` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_order_comments` -- ---------------------------- ALTER TABLE `s_order_comments` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_order_detail` -- ---------------------------- ALTER TABLE `s_order_detail` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_order_goods_inventory_log` -- ---------------------------- ALTER TABLE `s_order_goods_inventory_log` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_order_status_history` -- ---------------------------- ALTER TABLE `s_order_status_history` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_pay_log` -- ---------------------------- ALTER TABLE `s_pay_log` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_payment` -- ---------------------------- ALTER TABLE `s_payment` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_plugins` -- ---------------------------- ALTER TABLE `s_plugins` AUTO_INCREMENT=20; -- ---------------------------- -- Auto increment value for `s_power` -- ---------------------------- ALTER TABLE `s_power` AUTO_INCREMENT=351; -- ---------------------------- -- Auto increment value for `s_region` -- ---------------------------- ALTER TABLE `s_region` AUTO_INCREMENT=45057; -- ---------------------------- -- Auto increment value for `s_role` -- ---------------------------- ALTER TABLE `s_role` AUTO_INCREMENT=14; -- ---------------------------- -- Auto increment value for `s_role_power` -- ---------------------------- ALTER TABLE `s_role_power` AUTO_INCREMENT=2604; -- ---------------------------- -- Auto increment value for `s_screening_price` -- ---------------------------- ALTER TABLE `s_screening_price` AUTO_INCREMENT=32; -- ---------------------------- -- Auto increment value for `s_search_history` -- ---------------------------- ALTER TABLE `s_search_history` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_slide` -- ---------------------------- ALTER TABLE `s_slide` AUTO_INCREMENT=14; -- ---------------------------- -- Auto increment value for `s_user` -- ---------------------------- ALTER TABLE `s_user` AUTO_INCREMENT=91; -- ---------------------------- -- Auto increment value for `s_user_address` -- ---------------------------- ALTER TABLE `s_user_address` AUTO_INCREMENT=1; -- ---------------------------- -- Auto increment value for `s_user_integral_log` -- ---------------------------- ALTER TABLE `s_user_integral_log` AUTO_INCREMENT=1; ```