會員用戶模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_member` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用戶名', `password` char(32) NOT NULL DEFAULT '' COMMENT '密碼', `auth_key` varchar(32) DEFAULT NULL COMMENT '認證密鑰', `mobile` varchar(16) NOT NULL DEFAULT '' COMMENT '手機號碼', `avatar` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '頭像', `nickname` varchar(16) NOT NULL DEFAULT '' COMMENT '用戶昵稱', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性別，0=>未知，1=>男，2=>女', `wechat_openid` varchar(32) DEFAULT NULL COMMENT '微信openid', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `mobile` (`mobile`), UNIQUE KEY `auth_key` (`auth_key`), UNIQUE KEY `wechat_openid` (`wechat_openid`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='會員'; ~~~ ~~~[sql] CREATE TABLE `xi_member_address` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `consignee` varchar(16) NOT NULL DEFAULT '' COMMENT '收貨人', `mobile` varchar(16) NOT NULL DEFAULT '' COMMENT '手機', `email` varchar(32) NOT NULL COMMENT '郵箱', `country` int(11) unsigned NOT NULL DEFAULT '86' COMMENT '國家', `province` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '省份', `city` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '城市', `district` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地區', `twon` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '鄉鎮', `address` varchar(64) NOT NULL DEFAULT '' COMMENT '詳細地址', `zipcode` varchar(8) NOT NULL DEFAULT '' COMMENT '郵編', `longitude` varchar(16) NOT NULL COMMENT '經度', `latitude` varchar(16) NOT NULL COMMENT '緯度', `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否默認地址', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='會員地址'; ~~~ ~~~[sql] CREATE TABLE `xi_member_integral` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL COMMENT '會員ID', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `member_id` (`member_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='會員積分'; ~~~ ~~~[sql] CREATE TABLE `xi_member_integral_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `integral_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '積分ID', `operator_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作者ID', `recharge_sn` varchar(32) NOT NULL DEFAULT '' COMMENT '充值唯一編碼，生成規則用的是訂單sn號的規則', `operate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作，0=>購物獎勵，1=>購物兌換，2=>手動扣除，3=>手動充值', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `before` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動前', `after` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動后', `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '備注', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='會員積分記錄'; ~~~ ~~~[sql] CREATE TABLE `xi_member_wallet` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL COMMENT '會員ID', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `member_id` (`member_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='會員錢包'; ~~~ ~~~[sql] CREATE TABLE `xi_member_wallet_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `wallet_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '錢包ID', `operator_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作者ID', `recharge_sn` varchar(32) NOT NULL DEFAULT '' COMMENT '充值唯一編碼，生成規則用的是訂單sn號的規則', `operate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作，0=>會員提現，1=>會員充值，2=>手動扣除，3=>手動充值，4=>提現反駁補回余額，5=>購物消費，6=>分銷獎勵', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `before` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動前', `after` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動后', `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '備注', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='會員錢包記錄'; ~~~