商品相關表 · Niushop單商戶V5開發手冊

```[sql] CREATE TABLE ns_album ( album_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, site_id int(11) NOT NULL DEFAULT 0 COMMENT '站點id', site_name varchar(255) NOT NULL DEFAULT '' COMMENT '站點名稱', album_name varchar(50) NOT NULL DEFAULT '' COMMENT '相冊,名稱', sort int(11) NOT NULL DEFAULT 0 COMMENT '排序', cover varchar(255) NOT NULL DEFAULT '' COMMENT '背景圖', `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '介紹', is_default tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否默認', update_time int(11) NOT NULL DEFAULT 0 COMMENT '更新時間', num int(11) NOT NULL DEFAULT 0 COMMENT '相冊圖片數', PRIMARY KEY (album_id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '相冊表'; CREATE TABLE ns_album_pic ( pic_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', pic_name varchar(255) NOT NULL DEFAULT '' COMMENT '名稱', pic_path varchar(255) NOT NULL DEFAULT '' COMMENT '路徑', pic_spec varchar(255) NOT NULL DEFAULT '' COMMENT '規格', site_id int(11) NOT NULL DEFAULT 0 COMMENT '站點id', update_time int(11) NOT NULL DEFAULT 0 COMMENT '更新時間', album_id int(11) NOT NULL DEFAULT 0 COMMENT '相冊id', PRIMARY KEY (pic_id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '相冊圖片表'; -- ---------------------------- -- Table structure for ns_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_goods`; CREATE TABLE `ns_goods` ( `goods_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品id', `goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `goods_class` int(11) NOT NULL DEFAULT 1 COMMENT '商品種類1.實物商品2.虛擬商品3.卡券商品', `goods_class_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品種類', `goods_attr_class` int(11) NOT NULL DEFAULT 1 COMMENT '商品類型id', `goods_attr_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品類型名稱', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '所屬店鋪id', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所屬店鋪名稱', `goods_image` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品主圖路徑', `goods_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品詳情', `goods_state` tinyint(4) NOT NULL DEFAULT 1 COMMENT '商品狀態（1.正常0下架）', `category_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品分類id,逗號隔開', `category_json` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類json字符串', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品價格（取第一個sku）', `market_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '市場價格（取第一個sku）', `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '成本價（取第一個sku）', `goods_stock` int(11) NOT NULL DEFAULT 0 COMMENT '商品庫存（總和）', `goods_stock_alarm` int(11) NOT NULL DEFAULT 0 COMMENT '庫存預警', `is_virtual` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否虛擬類商品（0實物1.虛擬）', `virtual_indate` int(11) NOT NULL DEFAULT 1 COMMENT '虛擬商品有效期', `is_free_shipping` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否免郵', `shipping_template` int(11) NOT NULL DEFAULT 0 COMMENT '指定運費模板', `goods_spec_format` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品規格格式', `goods_attr_format` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品屬性格式', `is_delete` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否已經刪除', `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '促銷語', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關鍵詞', `unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '單位', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `video_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '視頻', `sale_num` int(11) NOT NULL DEFAULT 0 COMMENT '銷量', `evaluate` int(11) NOT NULL DEFAULT 0 COMMENT '評價數', `evaluate_shaitu` int(11) NOT NULL DEFAULT 0 COMMENT '評價曬圖數', `evaluate_shipin` int(11) NOT NULL DEFAULT 0 COMMENT '評價視頻數', `evaluate_zhuiping` int(11) NOT NULL DEFAULT 0 COMMENT '評價追評數', `evaluate_haoping` int(11) NOT NULL DEFAULT 0 COMMENT '評價好評數', `evaluate_zhongping` int(11) NOT NULL DEFAULT 0 COMMENT '評價中評數', `evaluate_chaping` int(11) NOT NULL DEFAULT 0 COMMENT '評價差評數', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '參與分銷（0不參與 1參與）', `fenxiao_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '分銷傭金類型（1默認 2自行設置）', `supplier_id` int(11) NOT NULL DEFAULT 0 COMMENT '供應商id', `is_consume_discount` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與會員等級折扣', `discount_config` tinyint(1) NOT NULL DEFAULT 0 COMMENT '優惠設置（0默認 1自定義）', `discount_method` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '優惠方式（discount打折 manjian 滿減 fixed_price 指定價格）', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'sku_id', `promotion_addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '當前參與的營銷活動，逗號分隔（限時折扣、團購、拼團、秒殺、專題活動）', `goods_service_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品服務id', `label_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品分組id', `virtual_sale` int(11) NOT NULL DEFAULT 0 COMMENT '虛擬銷量', `max_buy` int(11) NOT NULL DEFAULT 0 COMMENT '限購', `min_buy` int(11) NOT NULL DEFAULT 0 COMMENT '起購數', PRIMARY KEY (`goods_id`) USING BTREE, INDEX `IDX_ns_goods_category_id`(`category_id`) USING BTREE, INDEX `IDX_ns_goods_goods_class`(`goods_class`) USING BTREE, INDEX `IDX_ns_goods_is_delete`(`is_delete`) USING BTREE, INDEX `IDX_ns_goods_site_id`(`site_id`) USING BTREE, INDEX `IDX_ns_goods_sku_id`(`sku_id`) USING BTREE, INDEX `IDX_ns_goods_sort`(`sort`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 AVG_ROW_LENGTH = 2891 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_attr_class -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_attr_class`; CREATE TABLE `ns_goods_attr_class` ( `class_id` int(11) NOT NULL AUTO_INCREMENT, `class_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '類型名稱', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '所屬店鋪id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序號', PRIMARY KEY (`class_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' 商品類型' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_attribute -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_attribute`; CREATE TABLE `ns_goods_attribute` ( `attr_id` int(11) NOT NULL AUTO_INCREMENT, `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '屬性名稱', `attr_class_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品類型id', `attr_class_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品類型名稱', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '屬性排序號', `is_query` int(11) NOT NULL DEFAULT 0 COMMENT '是否參與篩選', `is_spec` int(11) NOT NULL DEFAULT 0 COMMENT '是否是規格屬性', `attr_value_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '屬性值列表（\',\'隔開注意鍵值對）', `attr_value_format` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '屬性值格式json', `attr_type` int(11) NOT NULL DEFAULT 0 COMMENT '屬性類型（1.單選 2.多選3. 輸入注意輸入不參與篩選）', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', PRIMARY KEY (`attr_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品屬性' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_attribute_value -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_attribute_value`; CREATE TABLE `ns_goods_attribute_value` ( `attr_value_id` int(11) NOT NULL AUTO_INCREMENT, `attr_value_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '屬性值名稱', `attr_id` int(11) NOT NULL DEFAULT 0 COMMENT '屬性id', `attr_class_id` int(11) NOT NULL DEFAULT 0 COMMENT '類型id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', PRIMARY KEY (`attr_value_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品屬性值表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_browse -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_browse`; CREATE TABLE `ns_goods_browse` ( `id` int(11) NOT NULL AUTO_INCREMENT, `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '瀏覽人', `browse_time` int(11) NOT NULL DEFAULT 0 COMMENT '瀏覽時間', `site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站點id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'sku_id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', PRIMARY KEY (`id`) USING BTREE, INDEX `IDX_ns_goods_browse_member_id`(`member_id`) USING BTREE, INDEX `IDX_ns_goods_browse_sku_id`(`sku_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 AVG_ROW_LENGTH = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品瀏覽歷史' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_cart -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_cart`; CREATE TABLE `ns_goods_cart` ( `cart_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'sku_id', `num` int(11) NOT NULL DEFAULT 0 COMMENT '數量', PRIMARY KEY (`cart_id`) USING BTREE, INDEX `IDX_ns_goods_cart_member_id`(`member_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 963 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' 購物車' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_category -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_category`; CREATE TABLE `ns_goods_category` ( `category_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `category_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類名稱', `short_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '簡稱', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '分類上級', `level` int(11) NOT NULL DEFAULT 0 COMMENT '層級', `is_show` int(11) NOT NULL DEFAULT 0 COMMENT '是否顯示', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類圖片', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類頁面關鍵字', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類介紹', `attr_class_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯商品類型id', `attr_class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關聯商品類型名稱', `category_id_1` int(11) NOT NULL DEFAULT 0 COMMENT '一級分類id', `category_id_2` int(11) NOT NULL DEFAULT 0 COMMENT '二級分類id', `category_id_3` int(11) NOT NULL DEFAULT 0 COMMENT '三級分類id', `category_full_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組裝名稱', `image_adv` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類廣告圖', `commission_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '傭金比率%', PRIMARY KEY (`category_id`) USING BTREE, INDEX `pid_level`(`pid`, `level`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 AVG_ROW_LENGTH = 468 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' 商品分類' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_collect -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_collect`; CREATE TABLE `ns_goods_collect` ( `collect_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuid', `category_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品分類id', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `sku_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品價格', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖片', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '收藏時間', `site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站點id', PRIMARY KEY (`collect_id`) USING BTREE, INDEX `IDX_ns_goods_collect_member_id`(`member_id`) USING BTREE, INDEX `IDX_ns_goods_collect_sku_id`(`sku_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品收藏表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_evaluate -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_evaluate`; CREATE TABLE `ns_goods_evaluate` ( `evaluate_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '評價ID', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `website_id` int(11) NOT NULL DEFAULT 0 COMMENT '分站id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單ID', `order_no` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單編號', `order_goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單項ID', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuid', `sku_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `sku_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品價格', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖片', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '評價內容', `images` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '評價圖片', `explain_first` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '解釋內容', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '評價人id', `member_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '評價人名稱', `member_headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '評價人頭像', `is_anonymous` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示不是 1表示是匿名評價', `scores` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1-5分', `again_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '追加評價內容', `again_images` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '追評評價圖片', `again_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '追加解釋內容', `explain_type` int(11) NOT NULL DEFAULT 0 COMMENT '1好評2中評3差評', `is_show` int(1) NOT NULL DEFAULT 1 COMMENT '1顯示 0隱藏', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '評價時間', `again_time` int(11) NOT NULL DEFAULT 0 COMMENT '追加評價時間', `shop_desccredit` decimal(10,2) NOT NULL DEFAULT 5.00 COMMENT '描述分值', `shop_servicecredit` decimal(10,2) NOT NULL DEFAULT 5.00 COMMENT '服務分值', `shop_deliverycredit` decimal(10,2) NOT NULL DEFAULT 5.00 COMMENT '配送分值', PRIMARY KEY (`evaluate_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2048 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品評價表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_label -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_label`; CREATE TABLE `ns_goods_label` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `label_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標簽名稱', `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, `sort` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 3276 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品標簽' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_service -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_service`; CREATE TABLE `ns_goods_service` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `service_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '服務名稱', `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 366 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品服務' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_sku -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_sku`; CREATE TABLE `ns_goods_sku` ( `sku_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品sku_id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '所屬店鋪id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品sku名稱', `sku_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品sku編碼', `sku_spec_format` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sku規格格式', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'sku單價', `market_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'sku市場價', `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'sku成本價', `discount_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'sku折扣價（默認等于單價）', `promotion_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '活動類型1.限時折扣', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動結束時間', `stock` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku庫存', `weight` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '重量（單位g）', `volume` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '體積（單位立方米）', `click_num` int(11) NOT NULL DEFAULT 0 COMMENT '點擊量', `sale_num` int(11) NOT NULL DEFAULT 0 COMMENT '銷量', `collect_num` int(11) NOT NULL DEFAULT 0 COMMENT '收藏量', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sku主圖', `sku_images` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sku圖片', `goods_class` int(11) NOT NULL DEFAULT 1 COMMENT '商品種類1.實物商品2.虛擬商品3.卡券商品', `goods_class_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品種類', `goods_attr_class` int(11) NOT NULL DEFAULT 1 COMMENT '商品類型id', `goods_attr_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品類型名稱', `goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `goods_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品詳情', `goods_state` tinyint(4) NOT NULL DEFAULT 1 COMMENT '商品狀態（1.正常0下架）', `goods_stock_alarm` int(11) NOT NULL DEFAULT 0 COMMENT '庫存預警', `is_virtual` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否虛擬類商品（0實物1.虛擬）', `virtual_indate` int(11) NOT NULL DEFAULT 1 COMMENT '虛擬商品有效期', `is_free_shipping` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否免郵', `shipping_template` int(11) NOT NULL DEFAULT 0 COMMENT '指定運費模板', `goods_spec_format` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品規格格式', `goods_attr_format` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品屬性格式', `is_delete` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否已經刪除', `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '促銷語', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關鍵詞', `unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '單位', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `video_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '視頻', `evaluate` int(11) NOT NULL DEFAULT 0 COMMENT '評價數', `evaluate_shaitu` int(11) NOT NULL DEFAULT 0 COMMENT '曬圖評價數', `evaluate_shipin` int(11) NOT NULL DEFAULT 0 COMMENT '視頻評價數', `evaluate_zhuiping` int(11) NOT NULL DEFAULT 0 COMMENT '追評數', `spec_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '規格名稱', `evaluate_haoping` int(11) NOT NULL DEFAULT 0 COMMENT '好評數', `evaluate_zhongping` int(11) NOT NULL DEFAULT 0 COMMENT '中評數', `evaluate_chaping` int(11) NOT NULL DEFAULT 0 COMMENT '差評數', `supplier_id` int(11) NOT NULL DEFAULT 0 COMMENT '供應商id', `is_consume_discount` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與會員等級折扣', `discount_config` tinyint(1) NOT NULL DEFAULT 0 COMMENT '優惠設置（0默認 1自定義）', `discount_method` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '優惠方式（discount打折 manjian 滿減 fixed_price 指定價格）', `member_price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員價', `goods_service_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品服務id', `virtual_sale` int(11) NOT NULL DEFAULT 0 COMMENT '虛擬銷量', `max_buy` int(11) NOT NULL DEFAULT 0 COMMENT '限購', `min_buy` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`sku_id`) USING BTREE, INDEX `IDX_ns_goods_goods_class`(`goods_class`) USING BTREE, INDEX `IDX_ns_goods_is_delete`(`is_delete`) USING BTREE, INDEX `IDX_ns_goods_site_id`(`site_id`) USING BTREE, INDEX `IDX_ns_goods_sort`(`sort`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 48 AVG_ROW_LENGTH = 12920 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_goods_virtual -- ---------------------------- DROP TABLE IF EXISTS `ns_goods_virtual`; CREATE TABLE `ns_goods_virtual` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku_id', `sku_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '虛擬商品編碼', `is_veirfy` int(11) NOT NULL DEFAULT 0 COMMENT '是否已經核銷', `verify_time` int(11) NOT NULL DEFAULT 0 COMMENT '核銷時間', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '所屬人', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '虛擬商品圖片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 528 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶虛擬商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_supplier -- ---------------------------- DROP TABLE IF EXISTS `ns_supplier`; CREATE TABLE `ns_supplier` ( `supplier_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `supplier_site_id` int(10) NOT NULL DEFAULT 0 COMMENT '供應商站點', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商名稱', `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商logo', `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商簡介', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商關鍵字', `supplier_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商地址', `supplier_email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商郵箱', `supplier_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系電話', `supplier_qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '供應商qq', `supplier_weixin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人微信號', `account` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '賬戶金額', `account_withdraw` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '已提現金額', `account_withdraw_apply` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現中金額', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'admin' COMMENT '供應商管理員', `settlement_bank_account_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '結算銀行開戶名', `settlement_bank_account_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '結算公司銀行賬號', `settlement_bank_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '結算開戶銀行支行名稱', `settlement_bank_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '結算開戶銀行所在地', PRIMARY KEY (`supplier_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 292 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供應商' ROW_FORMAT = Compact; ```