会签 数据库表设计_商城会员卡数据库表设计

数据库表设计

会员卡表

会员卡配置表

用户购买会员卡表

用户领取优惠券记录表

mysql脚本

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mcs_member_card
-- ----------------------------
DROP TABLE IF EXISTS `mcs_member_card`;
CREATE TABLE `mcs_member_card`  (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'guid主键',
  `site_id` int(10) NULL DEFAULT NULL COMMENT '站点',
  `member_level` tinyint(4) NULL DEFAULT NULL COMMENT '会员级别',
  `card_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认图片',
  `card_amount` bigint(20) NULL DEFAULT NULL COMMENT '会员卡金额',
  `card_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NUL