```[sql] -- ---------------------------- -- Table structure for ns_promotion_manjian -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_manjian`; CREATE TABLE `ns_promotion_manjian` ( `manjian_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int(11) NOT NULL COMMENT '站点id', `manjian_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称', `manjian_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1全部商品参与 2指定商品 3指定商品不参与 ', `type` int(1) NOT NULL DEFAULT 0 COMMENT '条件类型 0:满N元 1:满N件', `goods_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品id集', `status` int(11) NOT NULL DEFAULT 0 COMMENT '状态（0未开始1进行中2已结束-1已关闭）', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '结束时间', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', `rule_json` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '{}' COMMENT '规则json', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`manjian_id`) USING BTREE, INDEX `IDX_ns_promotion_manjian_site_id`(`site_id`) USING BTREE, INDEX `IDX_ns_promotion_manjian_status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '满减活动' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_manjian_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_manjian_goods`; CREATE TABLE `ns_promotion_manjian_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `manjian_id` int(11) NOT NULL DEFAULT 0 COMMENT '满减活动id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `manjian_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1全部商品参与 2指定商品 3指定商品不参与 ', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0未开始1进行中2已结束-1已关闭）', `rule_json` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '满减规则json', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '结束时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 174 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '满减商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_mansong_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_mansong_record`; CREATE TABLE `ns_promotion_mansong_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manjian_id` int(11) NOT NULL DEFAULT 0 COMMENT '满减送活动id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `manjian_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '满减送活动名称', `point` int(11) NOT NULL DEFAULT 0 COMMENT '所送积分数', `coupon` int(11) NOT NULL DEFAULT 0 COMMENT '所送优惠券', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id', `member_id` int(11) NOT NULL DEFAULT 0, `order_sku_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '满足条件的商品规格id', `status` int(11) NOT NULL DEFAULT 0 COMMENT '0未发放 1已发放', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '满送记录表' ROW_FORMAT = Compact;