分銷相關 · Niushop單商戶V3數據字典

```[sql] CREATE TABLE nfx_commission_distribution ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL COMMENT '對應的店鋪ID', promoter_id INT(11) NOT NULL COMMENT '對應的推廣員ID', order_id INT(11) NOT NULL COMMENT '對應的訂單ID', order_goods_id INT(11) NOT NULL COMMENT '對應的訂單項ID', goods_money DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總金額實際賣價', goods_cost DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總成本', goods_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品利潤', promoter_level INT(11) NOT NULL COMMENT '對應推廣員級次0本店1下級創造2下下級創造', goods_commission_rate DECIMAL(10, 2) NOT NULL COMMENT '商品對應拿出的利潤比率', commission_rate DECIMAL(10, 2) NOT NULL COMMENT '獲取的傭金比率', commission_money DECIMAL(10, 4) NOT NULL COMMENT '獲取的傭金金額', is_issue TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否已經發放 0 未發放 1已發放', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '推廣員分銷傭金'; CREATE TABLE nfx_commission_partner ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL COMMENT '對應的店鋪ID', partner_id INT(11) NOT NULL COMMENT '對應的股東ID', partner_level INT(11) NOT NULL DEFAULT 0 COMMENT '獲取傭金的股東等級', order_partner_id INT(11) NOT NULL DEFAULT 0 COMMENT '產生訂單的股東', order_id INT(11) NOT NULL COMMENT '對應的訂單ID', order_goods_id INT(11) NOT NULL COMMENT '對應的訂單項ID', goods_return DECIMAL(10, 4) NOT NULL COMMENT '商品利潤', goods_money DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總金額實際賣價', goods_cost DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總成本', goods_commission_rate DECIMAL(10, 2) NOT NULL COMMENT '商品利潤分成總比率', commission_rate DECIMAL(10, 2) NOT NULL COMMENT '獲取的傭金比率', commission_money DECIMAL(10, 4) NOT NULL COMMENT '獲取的傭金金額', is_issue TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否已經發放 0未發放 1已發放', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '股東分紅傭金'; CREATE TABLE nfx_commission_partner_global ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, serial_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '單據編號', records_id INT(11) NOT NULL DEFAULT 0 COMMENT '記錄id', shop_id INT(11) NOT NULL COMMENT '店鋪ID', partner_id INT(11) NOT NULL COMMENT '股東ID', uid INT(11) NOT NULL COMMENT '股東會員ID', yingye_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '時間段內分紅的店鋪總額', shop_value INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪總分值', partner_value INT(11) NOT NULL DEFAULT 0 COMMENT '股東分值', partner_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東分紅傭金比率(分值比率)', fenhong_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '分紅金額', start_time INT(11) DEFAULT 0 COMMENT '開始時間', end_time INT(11) DEFAULT 0 COMMENT '結束時間', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '全球分紅傭金記錄表'; CREATE TABLE nfx_commission_partner_global_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', shop_id INT(11) NOT NULL COMMENT '店鋪ID', fenhong_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '分紅總金額', start_time INT(11) DEFAULT 0 COMMENT '分紅開始時間', end_time INT(11) DEFAULT 0 COMMENT '分紅結束時間', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '股東分紅整體記錄表'; CREATE TABLE nfx_commission_region_agent ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主鍵', shop_id INT(11) NOT NULL COMMENT '店鋪id', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', region_agent_id INT(11) NOT NULL COMMENT '區域代理ID', uid INT(11) NOT NULL COMMENT '會員ID', promoter_id INT(11) NOT NULL COMMENT '推廣員id', order_id INT(11) NOT NULL COMMENT '對應的訂單ID', order_goods_id INT(11) NOT NULL COMMENT '對應的訂單項ID', goods_money DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總金額實際賣價', goods_cost DECIMAL(10, 2) NOT NULL COMMENT '訂單項商品總成本', goods_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品利潤', goods_commission_rate DECIMAL(10, 2) DEFAULT 0.00 COMMENT '商品利潤分成總比率', commission_type INT(11) NOT NULL DEFAULT 0 COMMENT '代理級別1.省級2.市級3.區級', commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '傭金比率', commission DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '實際傭金金額', is_issue TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否發放 0未發放 1已發放', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '備注', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '區域代理傭金列表'; CREATE TABLE nfx_goods_commission_rate ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, goods_id INT(11) NOT NULL COMMENT '商品ID', is_open TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否啟用分銷', distribution_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '分銷傭金比率', partner_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東分紅傭金比率', global_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東全球分紅比率', distribution_team_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '分銷團隊分紅傭金比率', partner_team_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東團隊分紅傭金比率', regionagent_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '區域代理分紅傭金比率', channelagent_commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '渠道代理分紅傭金比率', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 136 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '商品傭金比率設置'; CREATE TABLE nfx_partner ( partner_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '股東ID', promoter_id INT(11) NOT NULL DEFAULT 0 COMMENT '推廣員ID', parent_partner INT(11) NOT NULL COMMENT '上級股東', uid INT(11) NOT NULL COMMENT '會員ID', shop_id INT(11) NOT NULL COMMENT '店鋪ID', partner_level INT(11) NOT NULL COMMENT '股東等級', is_audit TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否審核通過', is_lock TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否被凍結', register_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', audit_time INT(11) DEFAULT 0 COMMENT '審核通過時間', lock_time INT(11) DEFAULT 0 COMMENT '凍結時間', PRIMARY KEY (partner_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '股東表'; CREATE TABLE nfx_partner_level ( level_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '等級ID', level_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '等級條件（團隊銷售額）', level_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '等級名稱', commission_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東分紅傭金比率', global_value DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '全球分紅分值', global_weight DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '全球分紅權重', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (level_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '股東等級'; CREATE TABLE nfx_promoter ( promoter_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '推廣員ID', promoter_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '推廣員編號', parent_promoter INT(11) NOT NULL DEFAULT 0 COMMENT '上級推廣員id', uid INT(11) NOT NULL COMMENT '推廣員對應會員ID', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', promoter_level INT(11) NOT NULL DEFAULT 0 COMMENT '推廣員等級', promoter_shop_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '推廣員店鋪名稱', commission_cash DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '已提現傭金', commossion_total DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '傭金總額', order_total DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '銷售總額', is_lock TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否被凍結', is_audit TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否已審核', qrcode VARCHAR(255) NOT NULL DEFAULT '' COMMENT '推廣二維碼', memo VARCHAR(255) NOT NULL DEFAULT '' COMMENT '備注', lock_time INT(11) DEFAULT 0 COMMENT '凍結時間', audit_time INT(11) DEFAULT 0 COMMENT '審核通過時間', regidter_time INT(11) DEFAULT 0 COMMENT '申請時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', background_img VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店鋪背景圖', PRIMARY KEY (promoter_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1260 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '推廣員表'; CREATE TABLE nfx_promoter_goods ( id INT(11) NOT NULL AUTO_INCREMENT, promoter_id INT(11) NOT NULL DEFAULT 0 COMMENT '推廣員id', goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '商品id', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 348 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '推廣員商品'; CREATE TABLE nfx_promoter_level ( level_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '等級ID', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', level_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '等級名稱', level_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '等級升級條件（銷售額）', level_0 DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '本店銷售傭金比率', level_1 DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '給上級的傭金比率', level_2 DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '給上上級的傭金比率', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (level_id) ) ENGINE = INNODB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 4096 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '推廣員等級'; CREATE TABLE nfx_promoter_region_agent ( region_agent_id INT(10) NOT NULL AUTO_INCREMENT COMMENT '表主鍵', shop_id INT(11) NOT NULL COMMENT '店鋪id', promoter_id INT(11) NOT NULL COMMENT '推廣員ID', uid INT(11) NOT NULL COMMENT '會員ID', agent_type INT(11) NOT NULL DEFAULT 0 COMMENT '代理類型1.省代，2，市代3，區域代理', agent_provinceid INT(11) NOT NULL DEFAULT 0 COMMENT '代理省份id', agent_cityid INT(11) NOT NULL DEFAULT 0 COMMENT '代理市id', agent_districtid INT(11) NOT NULL DEFAULT 0 COMMENT '代理區域id', is_audit INT(11) NOT NULL DEFAULT 0 COMMENT '是否已經通過0.待審核1.通過-1.審核不通過2.取消', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '操作備注', reg_time INT(11) DEFAULT 0 COMMENT '申請時間', audit_time INT(11) DEFAULT 0 COMMENT '通過時間', cancel_time INT(11) DEFAULT 0 COMMENT '取消時間', real_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '真實姓名', agent_mobile VARCHAR(11) NOT NULL DEFAULT '' COMMENT '手機號', agent_address VARCHAR(255) NOT NULL DEFAULT '' COMMENT '地址', PRIMARY KEY (region_agent_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '推廣員區域代理'; CREATE TABLE nfx_shop_commission_withdraw_config ( shop_id INT(11) NOT NULL COMMENT '店鋪Id', min_cash_money DECIMAL(10, 2) NOT NULL DEFAULT 100.00 COMMENT '最低提現金額為元', div_money DECIMAL(10, 2) NOT NULL DEFAULT 100.00 COMMENT '提現金額為的整數倍', PRIMARY KEY (shop_id) ) ENGINE = INNODB AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '傭金（體現條件）提現條件（交易完成后即可提現）'; CREATE TABLE nfx_shop_config ( id INT(11) NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', is_distribution_enable TINYINT(4) NOT NULL DEFAULT 0 COMMENT '分銷是否啟用 1開啟 0關閉', is_distribution_audit TINYINT(4) NOT NULL DEFAULT 0 COMMENT '推廣員是否需要審核 0不審核 1審核', is_regional_agent TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否開啟區域代理 1開啟 0關閉', is_partner_enable TINYINT(4) NOT NULL DEFAULT 0 COMMENT '股東分紅是否開啟 1開啟 0關閉', is_global_enable TINYINT(4) NOT NULL DEFAULT 0 COMMENT '全球分紅是否開啟', create_date INT(11) DEFAULT 0 COMMENT '創建時間', modify_date INT(11) DEFAULT 0 COMMENT '修改時間', is_distribution_start TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否開啟推廣員申請 1開啟 0關閉', is_distribution_set TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否將以前普通會員設置為推廣員 1開啟 0關閉', distribution_use TINYINT(4) NOT NULL DEFAULT 0 COMMENT '分銷傭金使用 0利潤 1銷售價格', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 1820 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪的分銷配置表'; CREATE TABLE nfx_shop_member_association ( id INT(10) NOT NULL AUTO_INCREMENT COMMENT '表主鍵', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', uid INT(11) NOT NULL COMMENT '會員ID', source_uid INT(11) NOT NULL DEFAULT 0 COMMENT '來源會員ID', promoter_id INT(11) NOT NULL DEFAULT 0 COMMENT '自身推廣員ID', qrcode_template_id INT(11) NOT NULL DEFAULT 0 COMMENT '推廣二維碼模板ID', partner_id INT(11) NOT NULL DEFAULT 0 COMMENT '自身股東id', is_promoter TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否是推廣員', is_partner TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否是股東', region_center_id TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否是區域代理', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 481 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪會員關聯表'; CREATE TABLE nfx_shop_region_agent_config ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL COMMENT '店鋪ID', is_open TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否啟用', province_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '省代比率', city_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '市代比率', district_rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '區代比率', application_require_province DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '省級申請業績條件', application_require_city DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '市代申請銷售條件', application_require_district DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '區代申請銷售條件', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 4096 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '分銷區域代理設置'; CREATE TABLE nfx_user_account ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', shop_id INT(11) NOT NULL COMMENT '店鋪ID', uid INT(11) NOT NULL COMMENT '用戶ID', commission DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '總傭金', commission_cash DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '可提現傭金', commission_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '已提現傭金', commission_locked DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '凍結中的金額', commission_promoter DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '分銷傭金', commission_partner DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東分紅', commission_partner_global DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東全球分紅', commission_region_agent DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '區域代理傭金', commission_partner_team DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '股東團隊分紅', commission_promoter_team DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '推廣員團隊分紅', commission_channelagent DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '渠道代理分紅', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '最新時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1170 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '用戶店鋪賬戶統計'; CREATE TABLE nfx_user_account_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主鍵', uid INT(11) NOT NULL COMMENT '會員ID', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID，0標示平臺', batchcode VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', money DECIMAL(10, 4) NOT NULL DEFAULT 0.0000 COMMENT '發生金額', account_type INT(11) NOT NULL DEFAULT 0 COMMENT '發生方式', type_alis_id INT(11) NOT NULL DEFAULT 0 COMMENT '發生相關ID', is_display TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否顯示', is_calculate TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否參與計算', text VARCHAR(255) NOT NULL DEFAULT '' COMMENT '描述', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 234 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員賬戶賬單(傭金)'; CREATE TABLE nfx_user_account_type ( type_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '類型ID', type_name VARCHAR(50) NOT NULL COMMENT '類型名稱', sign TINYINT(1) NOT NULL DEFAULT 1 COMMENT '傭金或支出', PRIMARY KEY (type_id) ) ENGINE = INNODB AUTO_INCREMENT = 11 AVG_ROW_LENGTH = 3276 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員賬戶獲取或者減少類型'; CREATE TABLE nfx_user_bank_account ( id INT(11) NOT NULL AUTO_INCREMENT, uid INT(11) NOT NULL COMMENT '會員id', bank_type VARCHAR(50) NOT NULL DEFAULT '1' COMMENT '賬號類型 1銀行卡2支付寶', branch_bank_name VARCHAR(50) DEFAULT NULL COMMENT '支行信息', realname VARCHAR(50) NOT NULL DEFAULT '' COMMENT '真實姓名', account_number VARCHAR(50) NOT NULL DEFAULT '' COMMENT '銀行賬號', mobile VARCHAR(20) NOT NULL DEFAULT '' COMMENT '手機號', is_default INT(11) NOT NULL DEFAULT 0 COMMENT '是否默認賬號', create_date INT(11) DEFAULT 0 COMMENT '創建日期', modify_date INT(11) DEFAULT 0 COMMENT '修改日期', PRIMARY KEY (id), INDEX IDX_member_bank_account_uid (uid) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員提現賬號'; CREATE TABLE nfx_user_commission_withdraw ( id INT(11) NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL COMMENT '店鋪編號', withdraw_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '提現流水號', uid INT(11) NOT NULL COMMENT '分銷商id', bank_name VARCHAR(50) NOT NULL COMMENT '提現銀行名稱', account_number VARCHAR(50) NOT NULL COMMENT '提現銀行賬號', realname VARCHAR(10) NOT NULL COMMENT '提現賬戶姓名', mobile VARCHAR(20) NOT NULL COMMENT '手機', cash DECIMAL(10, 2) NOT NULL COMMENT '提現金額', status SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '當前狀態 0已申請(等待處理) 1已同意 -1 已拒絕', memo VARCHAR(255) NOT NULL DEFAULT '' COMMENT '備注', ask_for_date INT(11) DEFAULT 0 COMMENT '提現日期', payment_date INT(11) DEFAULT 0 COMMENT '到賬日期', modify_date INT(11) DEFAULT 0 COMMENT '修改日期', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '傭金提現記錄表'; ```