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