應用（分銷） · Niushop單商戶V5開發手冊

```[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; ```