From 35309b932b738d5a8537e53207d28004a8da0f89 Mon Sep 17 00:00:00 2001 From: gongzuming <gongzuming> Date: 星期五, 20 九月 2024 17:17:04 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v2' --- src/main/v2_sql.sql | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 insertions(+), 0 deletions(-) diff --git a/src/main/v2_sql.sql b/src/main/v2_sql.sql new file mode 100644 index 0000000..815b293 --- /dev/null +++ b/src/main/v2_sql.sql @@ -0,0 +1,33 @@ +CREATE TABLE `flower`.`t_coupon_template` ( + `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键', + `coupon_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券代码（唯一）', + `coupon_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称', + `coupon_description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '优惠券描述(使用规则)', + `coupon_amount` int(11) NULL DEFAULT NULL COMMENT '发放数量', + `coupon_discount_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券类型（COUPON_TYPE）满减和无门槛', + `coupon_discount_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠券面值 折扣值（百分比或金额）', + `min_order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用条件，最小订单金额（可选）=》使用条件', + `max_discount_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '最大折扣金额（可选，仅对百分比折扣类型适用）', + `get_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领取渠道（COUPON_GET_TYPE）首页弹窗、活动入口、领券中心', + `get_user_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领取用户类型（COUPON_GET_USER_TYPE）全部用户，指定用户', + `get_start_date` datetime NULL DEFAULT NULL COMMENT '领取开始时间', + `get_end_date` datetime NULL DEFAULT NULL COMMENT '领取结束时间', + `get_limit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '每人限领', + `usage_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用时间类型（COUPON_USAGE_TYPE）与领取时间一致、固定时间、领取后有效', + `usage_time_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领取后有效类型（COUPON_USAGE_TIME_TYPE）天、小时、分钟', + `usage_time_num` int(11) NULL DEFAULT NULL COMMENT '领取后有效时间整数，比如90（天，小时，分钟）', + `usage_limit` int(11) NULL DEFAULT NULL COMMENT '使用次数限制', + `usage_per_user` int(11) NULL DEFAULT NULL COMMENT '每个用户的使用次数限制', + `usage_start_date` datetime NULL DEFAULT NULL COMMENT '使用开始时间', + `usage_end_date` datetime NULL DEFAULT NULL COMMENT '使用结束时间', + `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'active' COMMENT '优惠券状态(COUPON_STATUS)', + `vip_flag` tinyint(4) NULL DEFAULT 0 COMMENT '会员标志', + `vip_grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员等级', + `create_by` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + `update_by` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', + `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间', + `deleted` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `coupon_code`(`coupon_code`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; \ No newline at end of file -- Gitblit v1.9.3