模板介绍

模板说明

本模板把腾讯云套餐包信息拉取到本地MySQL数据库中

流程图

依赖组件

1.需要下载腾讯云短信分类的拉取套餐包信息组件。
2.需要添加字段名映射组件并对其进行配置。
3.需要创建相应的表结构或者用库表输出组件自动建表。

依赖字段名映射组件配置

源表字段                           目标字段
PackageCreateTime                  package_createTime
PackageExpiredTime                 package_expiredTime
PackageEffectiveTime               package_effectiveTime
PackageType                        package_type
CurrentUsage                       current_usage
PackageId                          package_id
PackageAmount                      package_amount

依赖表结构

CREATE TABLE `sms_packages_statistics`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_createTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包创建时间',
  `package_expiredTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包过期时间',
  `package_effectiveTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包生效时间',
  `package_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包类型,0表示赠送套餐包，1表示购买套餐包。',
  `current_usage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前使用套餐包条数',
  `package_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包ID',
  `package_amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '套餐包条数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;

使用评价