```[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;
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)