
-- ----------------------------
-- Table structure for xy_coupon
-- ----------------------------
DROP TABLE IF EXISTS `xy_coupon`;
CREATE TABLE `xy_coupon`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NULL DEFAULT 0,
  `alias_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  `discount` tinyint(3) NULL DEFAULT NULL,
  `satisfy_price` decimal(10, 2) NULL DEFAULT NULL,
  `superposition` tinyint(1) NULL DEFAULT 0,
  `use_start_time` int(10) NULL DEFAULT NULL,
  `vip_level` tinyint(3) NULL DEFAULT 0,
  `status` tinyint(1) NULL DEFAULT 1,
  `limit_sum` tinyint(2) NULL DEFAULT 1,
  `stock` int(10) NULL DEFAULT 0,
  `surplus_stock` int(10) NULL DEFAULT 0,
  `del_sum` int(10) NULL DEFAULT 0,
  `update_time` int(10) NULL DEFAULT NULL,
  `create_time` int(10) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '优惠券' ROW_FORMAT = Dynamic;
