营销（砍价） · 一点牛社区团购开发文档

```[sql] -- ---------------------------- -- Table structure for ns_promotion_bargain -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain`; CREATE TABLE `ns_promotion_bargain` ( `bargain_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍价id', `site_id` int(11) NOT NULL COMMENT '店铺id', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍价活动名称', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否参与分销（0不参与 1参与）', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '购买方式（0任意金额可购买 1砍到指定价格）', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍价金额类型（0固定金额 1随机金额）', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '帮砍价人数', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍价有效期（小时）', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL COMMENT '活动规则说明', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0未开始 1活动进行中 2活动已结束 3失效 4删除）', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态名称', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍价（0不支持 1支持）', PRIMARY KEY (`bargain_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 1820 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价活动表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_goods`; CREATE TABLE `ns_promotion_bargain_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `site_id` int(11) NOT NULL COMMENT '店铺id', `bargain_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'sku商品id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金额', `bargain_stock` int(11) NOT NULL DEFAULT 0 COMMENT '砍价库存', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底价', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍价活动名称', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否参与分销（0不参与 1参与）', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '购买方式（0任意金额可购买 1砍到指定价格）', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍价金额类型（0固定金额 1随机金额）', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '帮砍价人数', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍价有效期', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL COMMENT '活动规则说明', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0未开始 1活动进行中 2活动已结束 3已关闭）', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态名称', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍价（0不支持 1支持）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 AVG_ROW_LENGTH = 819 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价活动表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_launch -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_launch`; CREATE TABLE `ns_promotion_bargain_launch` ( `launch_id` int(11) NOT NULL AUTO_INCREMENT, `bargain_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价活动id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku_id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名称', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品图', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品原价', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底价', `buy_type` int(1) NOT NULL DEFAULT 0 COMMENT '购买方式（0任意金额可购买 1砍到指定价格）', `bargain_type` int(1) NOT NULL DEFAULT 0 COMMENT '砍价金额类型（0固定金额 1随机金额）', `need_num` int(11) NOT NULL DEFAULT 0 COMMENT '帮砍人数需达到数', `curr_num` int(11) NOT NULL DEFAULT 0 COMMENT '当前已帮砍人数', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '结束时间', `status` int(1) NOT NULL DEFAULT 0 COMMENT '0砍价中 1已成功 2未成功', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价发起用户', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '头像', `is_fenxiao` int(1) NOT NULL DEFAULT 0 COMMENT '是否参与分销（0不参与 1参与）', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金额', `curr_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '当前金额', `is_own` int(11) NOT NULL DEFAULT 0 COMMENT '是否自己砍价（0不支持 1支持）', PRIMARY KEY (`launch_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 963 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价发起表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_record`; CREATE TABLE `ns_promotion_bargain_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `launch_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价发起id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '帮砍会员id', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '头像', `money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '帮砍金额', `bargain_time` int(11) NOT NULL DEFAULT 0 COMMENT '帮砍时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;