会员相关表 · 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;