應用（積分兌換） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_exchange -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_exchange`; CREATE TABLE `ns_promotion_exchange` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT ' 站點id', `type` int(11) NOT NULL DEFAULT 1 COMMENT '兌換形式', `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '兌換類型名稱', `type_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '兌換名稱', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖片', `stock` int(11) NOT NULL DEFAULT 0 COMMENT '當前庫存', `pay_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付類型（0積分 1積分加錢）', `point` int(11) NOT NULL DEFAULT 0 COMMENT '積分數', `market_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '市場價', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '兌換價', `limit_num` int(11) NOT NULL DEFAULT 1 COMMENT '限制兌換數量', `delivery_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '物流費用（禮品有效）', `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '余額紅包（余額有效）', `state` int(11) NOT NULL DEFAULT 1 COMMENT '狀態（上下架）', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '兌換說明', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1820 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '積分兌換' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_exchange_order -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_exchange_order`; CREATE TABLE `ns_promotion_exchange_order` ( `order_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '對應會員', `out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水號（線上支付有效）', `point` int(11) NOT NULL DEFAULT 0 COMMENT '兌換積分數', `exchange_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '兌換價格', `delivery_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '郵費', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '實際應付金額', `express_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流單號（禮品發貨）', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `pay_time` int(11) NOT NULL DEFAULT 0 COMMENT '兌換成功時間', `exchange_id` int(11) NOT NULL DEFAULT 0 COMMENT '兌換商品id', `exchange_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '兌換商品名稱', `exchange_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '兌換商品圖片', `num` int(11) NOT NULL DEFAULT 0 COMMENT '兌換數量', `order_status` int(11) NOT NULL DEFAULT 0 COMMENT '狀態', `type` int(11) NOT NULL DEFAULT 0 COMMENT '類型', `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '類型名稱', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '姓名', `mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機號', `telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '電話', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省id', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '市id', `district_id` int(11) NOT NULL DEFAULT 0 COMMENT '區縣id', `community_id` int(11) NOT NULL DEFAULT 0 COMMENT '社區id', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '地址信息', `full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址信息', `longitude` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度', `latitude` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度', `buyer_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '買家留言', `order_from` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單來源', `order_from_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單來源名稱', `type_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯id', `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '贈送紅包', `site_id` int(11) NOT NULL DEFAULT 0, `delivery_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流類型', `delivery_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送方式名稱', `delivery_status` int(11) NOT NULL DEFAULT 0 COMMENT '發貨狀態', `delivery_status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發貨狀態名稱', `delivery_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送單號', `delivery_store_id` int(11) NOT NULL DEFAULT 0 COMMENT '門店id', `delivery_store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門店名稱', `delivery_store_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '門店信息', `buyer_ask_delivery_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '到達時間', `relate_order_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯訂單', PRIMARY KEY (`order_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 910 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '積分兌換訂單' ROW_FORMAT = Compact;