```[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;
```
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)