會員相關表 · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_member -- ---------------------------- DROP TABLE IF EXISTS `ns_member`; CREATE TABLE `ns_member` ( `member_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(11) NULL DEFAULT 0 COMMENT '站點id', `source_member` int(11) NOT NULL DEFAULT 0 COMMENT '推薦人', `fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分銷商（分銷有效）', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是分銷商', `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶名', `nickname` varchar(50) 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 '手機號', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '郵箱', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶密碼（MD5）', `status` int(11) NOT NULL DEFAULT 1 COMMENT '用戶狀態用戶狀態默認為1', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶頭像', `member_level` int(11) NOT NULL DEFAULT 0 COMMENT '用戶等級', `member_level_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員等級名稱', `member_label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',' COMMENT '用戶標簽', `member_label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員標簽名稱', `qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'qq號', `qq_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'qq互聯id', `wx_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信用戶openid', `weapp_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信小程序openid', `wx_unionid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信unionid', `ali_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付寶賬戶id', `baidu_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '百度賬戶id', `toutiao_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頭條賬號', `douyin_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '抖音小程序openid', `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '當前登錄ip', `login_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'h5' COMMENT '當前登錄的操作終端類型', `login_time` int(11) NOT NULL DEFAULT 0 COMMENT '當前登錄時間', `last_login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次登錄ip', `last_login_type` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'h5' COMMENT '上次登錄的操作終端類型', `last_login_time` int(11) NOT NULL DEFAULT 0 COMMENT '上次登錄時間', `login_num` int(11) NOT NULL DEFAULT 0 COMMENT '登錄次數', `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真實姓名', `sex` smallint(6) NOT NULL DEFAULT 0 COMMENT '性別 0保密 1男 2女', `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '定位地址', `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '出生日期', `reg_time` int(11) NOT NULL DEFAULT 0 COMMENT '注冊時間', `point` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '積分', `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '余額', `growth` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '成長值', `balance_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '現金余額(可提現)', `account5` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '賬戶5', `is_auth` int(11) NOT NULL DEFAULT 0 COMMENT '是否認證', `sign_time` int(11) NOT NULL DEFAULT 0 COMMENT '最后一次簽到時間', `sign_days_series` int(11) NOT NULL DEFAULT 0 COMMENT '持續簽到天數', `pay_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '交易密碼', `order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '付款后-消費金額', `order_complete_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單完成-消費金額', `order_num` int(11) NOT NULL DEFAULT 0 COMMENT '付款后-消費次數', `order_complete_num` int(11) NOT NULL DEFAULT 0 COMMENT '訂單完成-消費次數', `balance_withdraw_apply` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現中余額', `balance_withdraw` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '已提現余額', PRIMARY KEY (`member_id`) USING BTREE, INDEX `IDX_sys_user_user_email`(`email`) USING BTREE, INDEX `IDX_sys_user_user_name`(`username`) USING BTREE, INDEX `IDX_sys_user_user_password`(`password`) USING BTREE, INDEX `IDX_sys_user_user_tel`(`mobile`) USING BTREE, INDEX `IDX_sys_user_wx_openid`(`wx_openid`) USING BTREE, INDEX `IDX_sys_user_wx_unionid`(`wx_unionid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 AVG_ROW_LENGTH = 558 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統用戶表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_account -- ---------------------------- DROP TABLE IF EXISTS `ns_member_account`; CREATE TABLE `ns_member_account` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '用戶id', `account_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'point' COMMENT '賬戶類型', `account_data` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '賬戶數據', `from_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '來源類型', `type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '來源類型名稱', `type_tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關聯關鍵字', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注信息', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶名', `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '郵箱', PRIMARY KEY (`id`) USING BTREE, INDEX `IDX_ns_member_account_account_type`(`account_type`) USING BTREE, INDEX `IDX_ns_member_account_create_time`(`create_time`) USING BTREE, INDEX `IDX_ns_member_account_from_type`(`from_type`) USING BTREE, INDEX `IDX_ns_member_account_member_id`(`member_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 35 AVG_ROW_LENGTH = 153 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '賬戶流水' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_address -- ---------------------------- DROP TABLE IF EXISTS `ns_member_address`; CREATE TABLE `ns_member_address` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶姓名', `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機', `telephone` varchar(255) 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(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度', `latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度', `is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否是默認地址', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 264 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶地址管理' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_auth -- ---------------------------- DROP TABLE IF EXISTS `ns_member_auth`; CREATE TABLE `ns_member_auth` ( `auth_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員ID', `member_username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員用戶名', `auth_card_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '實名姓名', `auth_card_no` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '實名身份證', `auth_card_hand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '申請人手持身份證電子版', `auth_card_front` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '申請人身份證正面', `auth_card_back` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '申請人身份證反面', `status` int(11) NOT NULL DEFAULT 0 COMMENT '審核狀態0待審核1.已審核-1已拒絕', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '審核意見', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `audit_time` int(11) NOT NULL DEFAULT 0 COMMENT '審核通過時間', PRIMARY KEY (`auth_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員實名認證表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_bank_account -- ---------------------------- DROP TABLE IF EXISTS `ns_member_bank_account`; CREATE TABLE `ns_member_bank_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `member_id` int(11) NOT NULL COMMENT '會員id', `realname` varchar(50) 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 '手機號', `withdraw_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '賬戶類型 alipay-支付寶 bank銀行卡', `branch_bank_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '銀行名稱', `bank_account` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '銀行賬號', `is_default` int(11) NOT NULL DEFAULT 0 COMMENT '是否默認賬號', `create_time` int(11) NULL DEFAULT 0 COMMENT '創建日期', `modify_time` int(11) NULL DEFAULT 0 COMMENT '修改日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 862 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員提現賬號' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_label -- ---------------------------- DROP TABLE IF EXISTS `ns_member_label`; CREATE TABLE `ns_member_label` ( `label_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '標簽id', `site_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'site_id', `label_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標簽名稱', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', PRIMARY KEY (`label_id`) USING BTREE, INDEX `IDX_nc_member_label_label_id`(`label_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_member_level -- ---------------------------- DROP TABLE IF EXISTS `ns_member_level`; CREATE TABLE `ns_member_level` ( `level_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '會員等級', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `level_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等級名稱', `sort` int(11) NOT NULL DEFAULT 1 COMMENT '等級排序列', `growth` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '所需成長值', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `is_default` int(11) NOT NULL DEFAULT 0 COMMENT '是否默認，0：否，1：是', `is_free_shipping` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否包郵', `consume_discount` decimal(10,2) NOT NULL DEFAULT 100.00 COMMENT '消費折扣', `point_feedback` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '積分回饋倍率', `send_point` int(11) NOT NULL DEFAULT 0 COMMENT '贈送積分（等級禮包）', `send_balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '贈送紅包（等級禮包）', `send_coupon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '贈送優惠券', PRIMARY KEY (`level_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員等級' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_log -- ---------------------------- DROP TABLE IF EXISTS `ns_member_log`; CREATE TABLE `ns_member_log` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作行為插件', `action_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作行為名稱', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 309 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員操作日志表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_recharge -- ---------------------------- DROP TABLE IF EXISTS `ns_member_recharge`; CREATE TABLE `ns_member_recharge` ( `recharge_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `recharge_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '套餐名稱', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面', `face_value` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '面值', `buy_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '購買金額', `point` int(11) NOT NULL DEFAULT 0 COMMENT '積分', `growth` int(11) NOT NULL DEFAULT 0 COMMENT '成長值', `coupon_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '優惠券ID', `sale_num` int(11) NOT NULL DEFAULT 0 COMMENT '發放數量', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（1正常 2關閉）', PRIMARY KEY (`recharge_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員充值套餐' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_recharge_card -- ---------------------------- DROP TABLE IF EXISTS `ns_member_recharge_card`; CREATE TABLE `ns_member_recharge_card` ( `card_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `recharge_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '套餐ID', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `card_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '充值卡號', `recharge_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '套餐名稱', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面', `face_value` decimal(11, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '面值', `point` int(11) NOT NULL DEFAULT 0 COMMENT '積分', `growth` int(11) NOT NULL DEFAULT 0 COMMENT '成長值', `coupon_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '優惠券ID', `buy_price` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '購買金額', `member_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '會員ID', `member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員頭像', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員昵稱', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單ID', `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `from_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '獲取來源', `use_status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '使用狀態（1未使用 2已使用）', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `use_time` int(11) NOT NULL DEFAULT 0 COMMENT '使用時間', PRIMARY KEY (`card_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 862 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '充值卡' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_recharge_order -- ---------------------------- DROP TABLE IF EXISTS `ns_member_recharge_order`; CREATE TABLE `ns_member_recharge_order` ( `order_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `recharge_id` int(11) NOT NULL DEFAULT 0 COMMENT '套餐ID', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單流水號', `recharge_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '套餐名稱', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面', `face_value` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '面值', `buy_price` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '價格', `point` int(11) NOT NULL DEFAULT 0 COMMENT '積分', `growth` int(11) NOT NULL DEFAULT 0 COMMENT '成長值', `coupon_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '優惠券ID', `price` int(11) NOT NULL DEFAULT 0 COMMENT '實付金額', `pay_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付方式', `pay_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付方式名稱', `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '支付狀態（1未支付 2已支付）', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `pay_time` int(11) NOT NULL DEFAULT 0 COMMENT '支付時間', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '用戶ID', `member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶頭像', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶昵稱', `order_from` varchar(50) 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 '訂單來源名稱', PRIMARY KEY (`order_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '充值卡訂單' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_member_withdraw -- ---------------------------- DROP TABLE IF EXISTS `ns_member_withdraw`; CREATE TABLE `ns_member_withdraw` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `withdraw_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現交易號', `member_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員姓名', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `transfer_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '轉賬提現類型', `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真實姓名', `apply_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現申請金額', `rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現手續費比率', `service_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現手續費', `money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提現到賬金額', `apply_time` int(11) NOT NULL DEFAULT 0 COMMENT '申請時間', `audit_time` int(11) NOT NULL DEFAULT 0 COMMENT '審核時間', `payment_time` int(11) NOT NULL DEFAULT 0 COMMENT '轉賬時間', `status` int(11) NOT NULL DEFAULT 0 COMMENT '狀態0待審核1.待轉賬2已轉賬 -1拒絕', `memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `refuse_reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '拒絕理由', `member_headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提現狀態名稱', `transfer_type_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轉賬方式名稱', `bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '銀行名稱', `account_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收款賬號', `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機號', `certificate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '憑證', `certificate_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '憑證說明', `account_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '賬號', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員提現表' ROW_FORMAT = Compact;