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

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 NULL COMMENT '会员卡名称',
  `card_subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员卡副标题',
  `valid_time_unit` tinyint(4) NOT NULL COMMENT '有效时长单位，周，月，季，年',
  `valid_time` int(10) NOT NULL COMMENT '有效时长(周期)，表示几周，几个月',
  `starttime` datetime(0) NULL DEFAULT NULL COMMENT '有效期开始日期',
  `endtime` datetime(0) NULL DEFAULT NULL COMMENT '有效期结束日期',
  `json_remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JSON备注',
  `card_explain` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员卡使用说明',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
  `state` tinyint(4) NULL DEFAULT NULL COMMENT '状态',
  `addtime` datetime(0) NULL DEFAULT NULL COMMENT '添加日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mcs_membercard_config
-- ----------------------------
DROP TABLE IF EXISTS `mcs_membercard_config`;
CREATE TABLE `mcs_membercard_config`  (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'guid主键',
  `mcard_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联会员卡ID',
  `ref_type` tinyint(4) NULL DEFAULT NULL COMMENT '关联类型',
  `ref_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联ID',
  `img_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址',
  `count` int(10) NULL DEFAULT NULL COMMENT '数量',
  `time_interval` int(10) NULL DEFAULT NULL COMMENT '间隔天数',
  `valid_time` int(10) NULL DEFAULT NULL COMMENT '有效天数',
  `json_remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JSON备注',
  `state` tinyint(1) NULL DEFAULT 0 COMMENT '状态',
  `addtime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mcs_membercard_log
-- ----------------------------
DROP TABLE IF EXISTS `mcs_membercard_log`;
CREATE TABLE `mcs_membercard_log`  (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'guid主键',
  `task_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源任务ID 如：用户会员卡ID   ',
  `user_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联用户ID',
  `ref_type` tinyint(4) NULL DEFAULT NULL COMMENT '来源类型 如 产品，优惠券',
  `ref_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源ID',
  `get_count` int(10) NULL DEFAULT NULL COMMENT '领取数量',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
  `addtime` datetime(0) NULL DEFAULT NULL COMMENT '添加日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mcs_membercard_user
-- ----------------------------
DROP TABLE IF EXISTS `mcs_membercard_user`;
CREATE TABLE `mcs_membercard_user`  (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'guid主键',
  `mcard_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联会员卡ID',
  `card_num` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员卡编号',
  `user_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
  `starttime` datetime(0) NULL DEFAULT NULL COMMENT '有效期开始日期',
  `endtime` datetime(0) NULL DEFAULT NULL COMMENT '有效期结束日期',
  `ref_order_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联订单id',
  `ref_order_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联订单号',
  `json_remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JSON备注',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '会员卡状态',
  `addtime` datetime(0) NULL DEFAULT NULL COMMENT '添加日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mcs_membercard_user_coupons
-- ----------------------------
DROP TABLE IF EXISTS `mcs_membercard_user_coupons`;
CREATE TABLE `mcs_membercard_user_coupons`  (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `mcard_id` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员卡id',
  `coupon_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券id',
  `uid` char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `count` int(10) NULL DEFAULT NULL COMMENT '数量',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '优惠券状态99未领取，100已领取，110已失效',
  `batchnum` int(10) NULL DEFAULT NULL COMMENT '批次',
  `valid_days` int(10) NULL DEFAULT NULL COMMENT '有效天数',
  `gettime` datetime(0) NULL DEFAULT NULL COMMENT '领取时间',
  `starttime` datetime(0) NULL DEFAULT NULL COMMENT '有效开始时间',
  `endtime` datetime(0) NULL DEFAULT NULL COMMENT '有效结束时间',
  `addtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;