|
|
CREATE DATABASE IF NOT EXISTS `db_ad` default character set utf8mb4 COLLATE utf8mb4_general_ci;
|
|
|
|
|
|
DROP TABLE IF EXISTS `tb_jl_v2_backdata`;
|
|
|
CREATE TABLE `tb_jl_v2_backdata` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`promotion_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代表巨量广告体验版的广告ID',
|
|
|
`project_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代表巨量广告体验版的项目ID',
|
|
|
`promotion_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '巨量广告体验版中的广告名称',
|
|
|
`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '巨量广告体验版中的项目名称',
|
|
|
`mid1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片素材宏参数(下发原始素材id)',
|
|
|
`mid2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题素材宏参数(下发原始素材id)',
|
|
|
`mid3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频素材宏参数(下发原始素材id)',
|
|
|
`mid4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '搭配试玩素材宏参数(下发原始素材id)',
|
|
|
`mid5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '落地页素材宏参数(下发原始素材id)',
|
|
|
`mid6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓下载详情页素材宏参数(下发原始素材id)',
|
|
|
`csite` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告投放位置',
|
|
|
`convert_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转化id',
|
|
|
`request_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求下发的id',
|
|
|
`track_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求下发的id&创意id的md5,16位',
|
|
|
`os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统平台',
|
|
|
`ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理 (User Agent)',
|
|
|
`geo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置信息',
|
|
|
`ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端发生广告点击事件的时间',
|
|
|
`model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机型号',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓的设备 ID 的 md5 摘要32位',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' IOS 6+的设备id字段,32位',
|
|
|
`idfa_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IOS 6+的设备id的md5摘要,32位',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android Q及更高版本的设备号,32位',
|
|
|
`oaid_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android Q及更高版本的设备号的md5摘要,32位',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '移动设备mac地址',
|
|
|
`callback_param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '一些跟广告信息相关的回调参数,内容是一个加密字符串,在调用事件回传接口的时候会用到',
|
|
|
`callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '直接把调用事件回传接口的url生成出来,广告主可以直接使用',
|
|
|
`advertiser_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告主id',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_tag`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `tb_jl_v1_backdata`;
|
|
|
CREATE TABLE `tb_jl_v1_backdata` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`aid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告计划id',
|
|
|
`aid_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告计划名称',
|
|
|
`cid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告创意 id',
|
|
|
`cid_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告创意名称',
|
|
|
`campaign_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' 广告组 id',
|
|
|
`campaign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告组名称',
|
|
|
`ctype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创意样式',
|
|
|
`csite` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告投放位置',
|
|
|
`convert_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转化id',
|
|
|
`request_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求下发的id',
|
|
|
`track_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求下发的id&创意id的md5,16位',
|
|
|
`os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统平台',
|
|
|
`ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理 (User Agent)',
|
|
|
`geo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置信息',
|
|
|
`ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端发生广告点击事件的时间',
|
|
|
`model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机型号',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓的设备 ID 的 md5 摘要32位',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' IOS 6+的设备id字段,32位',
|
|
|
`idfa_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IOS 6+的设备id的md5摘要,32位',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android Q及更高版本的设备号,32位',
|
|
|
`oaid_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android Q及更高版本的设备号的md5摘要,32位',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '移动设备mac地址',
|
|
|
`callback_param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '一些跟广告信息相关的回调参数,内容是一个加密字符串,在调用事件回传接口的时候会用到',
|
|
|
`callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '直接把调用事件回传接口的url生成出来,广告主可以直接使用',
|
|
|
`advertiser_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告主id',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_tag`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `tb_ks_new_backdata`;
|
|
|
CREATE TABLE `tb_ks_new_backdata` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告账户ID',
|
|
|
`aid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告组ID',
|
|
|
`cid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告创意 id',
|
|
|
`did` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告计划ID',
|
|
|
`dname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' 广告计划名称',
|
|
|
`photo_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '素材ID',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android设备标识计算MD5',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓广告唯一标示',
|
|
|
`imei_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android下的IMEI,hash',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'iOS下的idfa计算MD5',
|
|
|
`idfa_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'iOS下的idfa计算SHA1',
|
|
|
`mac_bak` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对 MAC 进行 MD5',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对 MAC 去除分隔符之后进行 MD5',
|
|
|
`ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端发生广告点击事件的时间',
|
|
|
`ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端UA',
|
|
|
`os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OS系统',
|
|
|
`model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机型号',
|
|
|
`call_back` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回调信息,编码一次的URL',
|
|
|
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户IP地址',
|
|
|
`csite` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告投放场景',
|
|
|
`ac_creative` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为高级创意',
|
|
|
`win_for_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仅支持搜索流量',
|
|
|
`callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '直接把调用事件回传接口的url生成出来,广告主可以直接使用',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_tag`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `tb_bd_new_backdata`;
|
|
|
CREATE TABLE `tb_bd_new_backdata` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`akey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '双方加密密钥',
|
|
|
`userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账户ID',
|
|
|
`aid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创意ID',
|
|
|
`pid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划ID',
|
|
|
`uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' 单元ID',
|
|
|
`callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '效果数据回传URL',
|
|
|
`ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击信息/曝光信息',
|
|
|
`click_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击或曝光唯一标识',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IOS设备标识',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Android设备标识',
|
|
|
`oaid_MD5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'oaid编码方式',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原文oaid',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mac地址',
|
|
|
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户IP地址',
|
|
|
`ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端UA',
|
|
|
`os_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OS系统',
|
|
|
`ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时间戳',
|
|
|
`interactions_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户对广告进行的所有交互操作',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_tag`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `tb_gdt_new_backdata`;
|
|
|
CREATE TABLE `tb_gdt_new_backdata` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告主id',
|
|
|
`click_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击id',
|
|
|
`click_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击时间',
|
|
|
`campaign_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ' 计划id',
|
|
|
`adgroup_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告组id',
|
|
|
`ad_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告id',
|
|
|
`device_os_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备类型',
|
|
|
`promoted_object_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用id',
|
|
|
`promoted_object_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '推广类型',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓设备id',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '苹果设备id',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mac 地址',
|
|
|
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mac地址',
|
|
|
`user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理(user_agent)',
|
|
|
`callback` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '直接提供上报信息回传接口的 url',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓系统移动终端补充设备标识',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_tag`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
--
|
|
|
--- fixme 方案1: 这个表不一定用(使用这个的话,就必须进行分表分库), 文件里面要收集的字段也参考这个
|
|
|
---
|
|
|
DROP TABLE IF EXISTS `tb_tf_source`;
|
|
|
CREATE TABLE `tb_tf_source` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`click_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击时间,时间戳',
|
|
|
`ad_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告名称',
|
|
|
`imei` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓设备id',
|
|
|
`idfa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '苹果设备id',
|
|
|
`mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mac地址',
|
|
|
`oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安卓系统移动终端补充设备标识',
|
|
|
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于监测链接的自定义带参格式',
|
|
|
`vpoint` int(20) NULL DEFAULT NULL COMMENT '用于区分广告配置的地方',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_imei`(`imei`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_mac`(`mac`) USING BTREE,
|
|
|
INDEX `idx_idfa`(`idfa`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`oaid`) USING BTREE,
|
|
|
INDEX `idx_oaid`(`tag`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
--
|
|
|
--- fixme 方案2: [推荐] 直接按文件存投放包的文件地址
|
|
|
---
|
|
|
DROP TABLE IF EXISTS `tb_tf_source`;
|
|
|
CREATE TABLE `tb_tf_source` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`gmt_create` datetime(0) NULL DEFAULT NULL,
|
|
|
`gmt_modified` datetime(0) NULL DEFAULT NULL,
|
|
|
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
|
`produce_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投放包的产生时间 例如 2023-1-2',
|
|
|
`ad_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '广告名称[多个用逗号]',
|
|
|
`category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投放类目',
|
|
|
`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
|
|
|
`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件存放地址',
|
|
|
`file_pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件密码',
|
|
|
`file_status` int(20) NULL DEFAULT NULL COMMENT '文件状态, 0-文件正常可用, 1-正在生成, 2-文件状态异常, 3-文件操作禁用',
|
|
|
`last_operator_time` datetime(0) NULL DEFAULT NULL COMMENT '最后操作时间',
|
|
|
`weight` int(20) NULL DEFAULT NULL COMMENT '权重值',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
INDEX `idx_produce_time`(`produce_time`) USING BTREE,
|
|
|
INDEX `idx_last_operator_time`(`last_operator_time`) USING BTREE
|
|
|
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|