```[sql]
-- ----------------------------
-- Table structure for ns_fenxiao
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao`;
CREATE TABLE `ns_fenxiao` (
`fenxiao_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NULL DEFAULT 0 COMMENT '站點id',
`fenxiao_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分銷商編號',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分銷店鋪名',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '聯系電話',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員ID',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '分銷商等級id',
`level_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等級名稱',
`parent` int(11) NOT NULL DEFAULT 0 COMMENT '上級ID',
`grand_parent` int(11) NOT NULL DEFAULT 0 COMMENT '上上級id',
`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 '提現中傭金',
`status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '狀態(1已審核 2拒絕 -1已凍結)',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`audit_time` int(11) NOT NULL DEFAULT 0 COMMENT '成為經分銷商時間',
`lock_time` int(11) NOT NULL DEFAULT 0 COMMENT '凍結時間',
`one_fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級分銷訂單總數',
`one_fenxiao_order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級分銷訂單總額',
`one_child_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級下線人數',
`one_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級下線分銷商',
`two_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '二級下線分銷商',
`total_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '累計傭金',
PRIMARY KEY (`fenxiao_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1170 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷商表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_account
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_account`;
CREATE TABLE `ns_fenxiao_account` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '賬單編號',
`fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分銷商ID',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分銷商名稱',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '費用',
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '類型(withdraw提現 order訂單結算)',
`type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '類型名稱',
`relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯id',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷商流水表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_apply
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_apply`;
CREATE TABLE `ns_fenxiao_apply` (
`apply_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分銷商店鋪名',
`parent` int(11) NOT NULL DEFAULT 0 COMMENT '上級分銷商ID',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員ID',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '聯系電話',
`nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶昵稱',
`headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶頭像',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '申請等級',
`level_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等級名稱',
`order_complete_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單完成-消費金額',
`order_complete_num` int(10) NOT NULL DEFAULT 0 COMMENT '訂單完成-消費次數',
`reg_time` int(11) NOT NULL DEFAULT 0 COMMENT '注冊時間',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '申請時間',
`update_time` int(11) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '申請狀態(1申請中 2通過 -1拒絕)',
PRIMARY KEY (`apply_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷商申請表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_goods
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods`;
CREATE TABLE `ns_fenxiao_goods` (
`fenxiao_goods_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
`one_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '一級傭金',
`two_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '二級傭金',
`three_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '三級傭金',
`state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與',
PRIMARY KEY (`fenxiao_goods_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_fenxiao_goods_collect
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods_collect`;
CREATE TABLE `ns_fenxiao_goods_collect` (
`collect_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id',
`fenxiao_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',
`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_fenxiao_goods_collect_member_id`(`member_id`) USING BTREE,
INDEX `IDX_ns_fenxiao_goods_collect_sku_id`(`sku_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷商關注商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_goods_sku
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods_sku`;
CREATE TABLE `ns_fenxiao_goods_sku` (
`goods_sku_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuID',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '分銷等級ID',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級傭金比例',
`one_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級傭金金額',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二級傭金比例',
`two_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二級傭金金額',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三級傭金比例',
`three_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三級傭金金額',
PRIMARY KEY (`goods_sku_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 256 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷商品sku表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_level
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_level`;
CREATE TABLE `ns_fenxiao_level` (
`level_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`level_num` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等級權重',
`level_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等級名稱',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級傭金比例',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二級傭金比例',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三級傭金比例',
`upgrade_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '升級方式(0滿足任意條件 1滿足全部條件)',
`fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '訂單總數',
`fenxiao_order_meney` decimal(10,2) NULL DEFAULT 0.00 COMMENT '訂單總金額',
`one_fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級分銷訂單總數',
`one_fenxiao_order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級分銷訂單總額',
`order_num` int(11) NOT NULL DEFAULT 0 COMMENT '自購訂單總數',
`order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '自購訂單總額',
`child_num` int(11) NOT NULL DEFAULT 0 COMMENT '下線人數',
`child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '下線分銷商人數',
`one_child_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級下線人數',
`one_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '一級下線分銷商',
`status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '狀態(0關閉 1啟用)',
`create_time` int(11) NOT NULL DEFAULT 0,
`update_time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`level_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分銷等級配置表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_order
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_order`;
CREATE TABLE `ns_fenxiao_order` (
`fenxiao_order_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單ID',
`order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號',
`order_goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單項ID',
`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_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuid',
`sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品sku名稱',
`sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖片',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品賣價',
`num` int(11) NOT NULL DEFAULT 0 COMMENT '商品數量',
`real_goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品總價',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人ID',
`member_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人名稱',
`member_mobile` 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 '購買人詳細地址',
`commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '總傭金',
`commission_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '分銷總比率',
`one_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '一級分銷商ID',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級分銷比例',
`one_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一級分銷傭金',
`one_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '一級分銷商名',
`two_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '二級分銷商ID',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二級分銷比例',
`two_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二級分銷傭金',
`two_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二級分銷商名',
`three_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '三級分銷商ID',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三級分銷比例',
`three_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三級分銷傭金',
`three_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '三級分銷商名',
`is_settlement` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否結算',
`is_refund` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否退款',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
PRIMARY KEY (`fenxiao_order_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_fenxiao_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_withdraw`;
CREATE TABLE `ns_fenxiao_withdraw` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`withdraw_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現流水號',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id',
`fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分銷商id',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分銷商名稱',
`withdraw_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現類型(weixin-微信 alipay-支付寶 balance-余額 bank銀行卡)',
`bank_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現銀行名稱',
`account_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現銀行賬號',
`realname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現賬戶姓名',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現金額',
`withdraw_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現手續費率',
`withdraw_rate_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現手續費金額',
`real_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '實際到賬金額',
`status` smallint(6) NOT NULL DEFAULT 1 COMMENT '當前狀態 1待審核 2已審核 -1 已拒絕',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '申請日期',
`payment_time` int(11) NOT NULL DEFAULT 0 COMMENT '到賬日期',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改日期',
`transfer_type` int(11) NOT NULL DEFAULT 1 COMMENT '轉賬方式 1 線下轉賬 2線上轉賬',
`transfer_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轉賬銀行名稱',
`transfer_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轉賬備注',
`transfer_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轉賬流水號',
`transfer_account_no` 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 = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員余額提現記錄表' ROW_FORMAT = Compact;
```
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)