會員相關 · Niushop單商戶V3數據字典

```[sql] CREATE TABLE ns_member ( uid INT(11) NOT NULL COMMENT '用戶ID', member_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '前臺用戶名', member_level INT(11) NOT NULL DEFAULT 0 COMMENT '會員等級', member_label VARCHAR(255) NOT NULL DEFAULT '' COMMENT '會員標簽', memo VARCHAR(1000) DEFAULT NULL COMMENT '備注', reg_time INT(11) DEFAULT 0 COMMENT '注冊時間', PRIMARY KEY (uid) ) ENGINE = INNODB AVG_ROW_LENGTH = 147 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '前臺用戶表'; CREATE TABLE ns_member_account ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, uid INT(11) NOT NULL COMMENT '會員uid', shop_id INT(11) NOT NULL COMMENT '店鋪ID', point INT(11) NOT NULL DEFAULT 0 COMMENT '會員積分', balance DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '余額', coin INT(11) NOT NULL DEFAULT 0 COMMENT '購物幣', member_cunsum DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '會員消費', member_sum_point INT(11) NOT NULL DEFAULT 0 COMMENT '會員累計積分', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 3276 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員賬戶統計表'; CREATE TABLE ns_member_account_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', uid INT(11) NOT NULL DEFAULT 0 COMMENT '用戶ID', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', account_type INT(11) NOT NULL DEFAULT 1 COMMENT '賬戶類型1.積分2.余額3.購物幣', sign SMALLINT(6) NOT NULL DEFAULT 1 COMMENT '正負號', number DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '數量', from_type SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '產生方式1.商城訂單 2.訂單退還 3.兌換 4.充值 5.簽到 6.分享 7.注冊 8.提現 9提現退還 10.商家調整 11.營銷游戲 12.充值贈送', data_id INT(11) NOT NULL DEFAULT 0 COMMENT '相關表的數據ID', 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 = 108 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員流水賬表'; CREATE TABLE ns_member_balance_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 '修改日期', transfer_type INT(11) NOT NULL DEFAULT 1 COMMENT '轉賬方式 1 線下轉賬 2線上轉賬', transfer_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '轉賬銀行名稱', transfer_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '轉賬金額', transfer_status INT(11) DEFAULT 0 COMMENT '轉賬狀態 0未轉賬 1已轉賬 -1轉賬失敗', transfer_remark VARCHAR(255) DEFAULT '' COMMENT '轉賬備注', transfer_result VARCHAR(255) DEFAULT '' COMMENT '轉賬結果', transfer_no VARCHAR(255) DEFAULT '' COMMENT '轉賬流水號', transfer_account_no VARCHAR(255) DEFAULT '' COMMENT '轉賬銀行賬號', wx_withd_type INT(11) DEFAULT 0 COMMENT '1、公眾號 2、小程序', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員余額提現記錄表'; CREATE TABLE ns_member_bank_account ( id INT(11) NOT NULL AUTO_INCREMENT, uid INT(11) NOT NULL COMMENT '會員id', 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 '修改日期', account_type INT(11) DEFAULT 1 COMMENT '賬戶類型，1：銀行卡，2：微信，3：支付寶', account_type_name VARCHAR(30) DEFAULT '銀行卡' COMMENT '賬戶類型名稱：銀行卡，微信，支付寶', wx_account_type INT(11) DEFAULT 1 COMMENT '1、公眾號 2、小程序', 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 ns_member_behavior_records ( id INT(11) NOT NULL AUTO_INCREMENT, uid INT(11) NOT NULL COMMENT '會員id', type VARCHAR(255) DEFAULT NULL COMMENT '行為操作：1 簽到 2 點贊 3 分享 4 評論', create_time INT(11) NOT NULL COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2048 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員行為記錄表'; CREATE TABLE ns_member_express_address ( id INT(11) NOT NULL AUTO_INCREMENT, uid INT(11) NOT NULL COMMENT '會員基本資料表ID', consigner VARCHAR(255) NOT NULL DEFAULT '' COMMENT '收件人', mobile VARCHAR(11) NOT NULL DEFAULT '' COMMENT '手機', phone VARCHAR(20) NOT NULL DEFAULT '' COMMENT '固定電話', province INT(11) NOT NULL DEFAULT 0 COMMENT '省', city INT(11) NOT NULL DEFAULT 0 COMMENT '市', district INT(11) NOT NULL DEFAULT 0 COMMENT '區縣', address VARCHAR(255) NOT NULL DEFAULT '' COMMENT '詳細地址', zip_code VARCHAR(6) NOT NULL DEFAULT '' COMMENT '郵編', alias VARCHAR(50) NOT NULL DEFAULT '' COMMENT '地址別名', is_default INT(11) NOT NULL DEFAULT 0 COMMENT '默認收貨地址', PRIMARY KEY (id), INDEX IDX_member_express_address_uid (uid) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員收貨地址管理'; CREATE TABLE ns_member_favorites ( log_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '記錄ID', uid INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '會員ID', fav_id INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品或店鋪ID', fav_type VARCHAR(20) NOT NULL DEFAULT 'goods' COMMENT '類型:goods為商品,shop為店鋪,默認為商品', shop_id INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪ID', shop_name VARCHAR(20) NOT NULL DEFAULT '' COMMENT '店鋪名稱', shop_logo VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店鋪logo', goods_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '商品名稱', goods_image VARCHAR(300) DEFAULT NULL, log_price DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品收藏時價格', log_msg VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '收藏備注', fav_time INT(11) DEFAULT 0 COMMENT '收藏時間', PRIMARY KEY (log_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '收藏表'; CREATE TABLE ns_member_gift ( gift_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', uid INT(11) NOT NULL COMMENT '會員ID', promotion_gift_id INT(11) NOT NULL COMMENT '贈品活動ID', goods_id INT(11) NOT NULL COMMENT '贈品ID', goods_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '贈品名稱', goods_picture INT(11) NOT NULL DEFAULT 0 COMMENT '贈品圖片', num INT(11) NOT NULL DEFAULT 1 COMMENT '贈品數量', get_type INT(11) NOT NULL DEFAULT 1 COMMENT '獲取方式', get_type_id INT(11) NOT NULL COMMENT '獲取方式對應ID', `desc` TEXT NOT NULL COMMENT '說明', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (gift_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員贈品表'; CREATE TABLE ns_member_label ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '標簽id', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', label_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '標簽名稱', `desc` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '標簽描述', create_time INT(11) NOT NULL DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員標簽'; CREATE TABLE ns_member_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 '等級名稱', min_integral INT(11) NOT NULL DEFAULT 0 COMMENT '累計積分', goods_discount DECIMAL(3, 2) NOT NULL DEFAULT 1.00 COMMENT '折扣率', `desc` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '等級描述', is_default INT(11) NOT NULL DEFAULT 0 COMMENT '是否是默認', quota INT(11) NOT NULL DEFAULT 0 COMMENT '消費額度', `upgrade` INT(11) NOT NULL DEFAULT 1 COMMENT '升級條件 1.累計積分 2.消費額度 3.同時滿足', relation INT(11) NOT NULL DEFAULT 1 COMMENT '1.或 2. 且', buy_goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '購買商品id', order_num INT(11) NOT NULL DEFAULT 0 COMMENT '購買量', give_coupon VARCHAR(255) NOT NULL DEFAULT '' COMMENT '贈送優惠券優惠券id:數量,優惠券id:數量', give_point INT(11) NOT NULL DEFAULT 0 COMMENT '贈送積分', give_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '贈送余額', level INT(11) NOT NULL DEFAULT 0 COMMENT '等級排序', PRIMARY KEY (level_id) ) ENGINE = INNODB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員等級'; CREATE TABLE ns_member_level_records ( records_id INT(11) NOT NULL AUTO_INCREMENT, level_id INT(11) NOT NULL COMMENT '升級等級id', level INT(11) NOT NULL COMMENT '升級級別', level_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '等級名稱', create_time INT(11) NOT NULL DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (records_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2048 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員升級記錄表'; CREATE TABLE ns_member_recharge ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, recharge_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '支付金額', uid VARCHAR(255) NOT NULL COMMENT '用戶uid', out_trade_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '支付流水號', create_time VARCHAR(255) NOT NULL DEFAULT '0' COMMENT '創建時間', is_pay VARCHAR(255) NOT NULL DEFAULT '0' COMMENT '是否支付', status VARCHAR(255) NOT NULL DEFAULT '0' COMMENT '狀態', is_grant INT(1) NOT NULL DEFAULT 0 COMMENT '充值禮品是否發放 0未發放 1已發放', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員充值余額記錄'; CREATE TABLE ns_member_withdraw_setting ( id INT(10) NOT NULL AUTO_INCREMENT COMMENT '主鍵', shop_id INT(11) NOT NULL COMMENT '店鋪id（單店版為0）', withdraw_cash_min DECIMAL(10, 2) NOT NULL COMMENT '最低提現金額', withdraw_multiple INT(11) NOT NULL DEFAULT 0 COMMENT '提現倍數', withdraw_poundage INT(100) DEFAULT 0 COMMENT '提現手續費比率', withdraw_message VARCHAR(255) DEFAULT '' COMMENT '提現提示信息', withdraw_account_type VARCHAR(255) DEFAULT NULL COMMENT '提現支持賬號（目前只有銀聯卡）', create_time DATETIME DEFAULT NULL COMMENT '創建時間', modify_time DATETIME DEFAULT NULL COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員提現設置'; ```