平台化

- 新品标杆-排期表

- 新品标杆-商品审核

- 新品扶持-商品审核

前端分支：feature/22266-平台化爆版4.6.0

后端分支：feature/爆版v4.6

报名机会 ：fmys_supply_new_goods_activity

报名商品：fmys_supply_new_goods_activity_goods

报名记录:fmys_supply_new_goods_activity_record

下面五个指标是crm的库

退货率：pss_data_supply_day_index.reject_goods_rate_30

新增粉丝：pss_data_supply_month_index.add_fans

新款：pss_data_supply_month_index.total_new_goods_no

复购：pss_data_supply_day_index.pay_rebuy_rate_30

动销率:pss_data_supply_day_index.new_sale_rate_accumulate

CREATE TABLE `fmys_supply_new_goods_activity_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supply_id` int(11) NOT NULL COMMENT '供应商ID',
  `shop_id` int(11) NOT NULL COMMENT '店铺ID',
  `shop_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '报名时间',
  `sale_date` int(11) NOT NULL DEFAULT 0 COMMENT '排期时间',
  `activity_type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型{1:新品标杆，2：新品扶持}',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '排期状态{1:排期中,2:排期确定}',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `supply_id`(`supply_id`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商新品活动报名'

CREATE TABLE `fmys_supply_new_goods_activity_goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `goods_no` int(11) NOT NULL COMMENT '货号',
  `supply_id` int(11) NOT NULL DEFAULT 0 COMMENT '供应商ID',
  `discount_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '折扣信息',
  `first_stock` int(11) NOT NULL DEFAULT 0 COMMENT '首批库存',
  `scheduling_time` smallint(5) NOT NULL DEFAULT 0 COMMENT '加单货期',
  `activity_type` tinyint(1) NULL DEFAULT NULL COMMENT '{1:新品标杆,2:新品扶持}',
  `record_id` int(11) NOT NULL COMMENT '报名ID',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '报名状态{0未审核,1:通过,2:驳回:3:取消}',
  `no_pass_reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驳回原因',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '提交时间',
  `check_time` int(11) NULL DEFAULT 0 COMMENT '审核时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `record_id`(`record_id`) USING BTREE,
  INDEX `goods_no`(`goods_no`) USING BTREE,
  INDEX `supply_id`(`supply_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '新品活动报名商品'

CREATE TABLE `fmys_supply_new_goods_activity`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `supply_id` int(11) NOT NULL COMMENT '供应商ID',
  `num` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '固定次数',
  `prize_num` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '奖励次数',
  `type` tinyint(1) NOT NULL COMMENT '类型{1:新款主推,2:新品扶持}',
  `auto_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx(supply_id,type)`(`supply_id`, `type`) USING BTREE,
  INDEX `supply_id`(`supply_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci