Create kochava_skan_conv_report table

 avatar
unknown
mysql
2 years ago
1.8 kB
6
Indexable
CREATE TABLE `saconv.kochava_skan_conv_report` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_range_start_utc` datetime(6) DEFAULT NULL,
  `date_range_end_utc` datetime(6) DEFAULT NULL,
  `ko_account_name` varchar(255) DEFAULT NULL,
  `ko_account_id` bigint(20) DEFAULT NULL,
  `advertiser_app_store_id` bigint(20) DEFAULT NULL,
  `ko_app_name` varchar(255) DEFAULT NULL,
  `ko_app_id` bigint(20) DEFAULT NULL,
  `ko_app_guid` varchar(255) DEFAULT NULL,
  `sk_version` decimal(2,1) DEFAULT NULL,
  `sk_ad_network_id` varchar(255) DEFAULT NULL,
  `ko_media_partner_name` varchar(255) DEFAULT NULL,
  `ko_media_partner_id` bigint(20) DEFAULT NULL,
  `sk_campaign_id` bigint(20) DEFAULT NULL,
  `campaign_name` varchar(255) DEFAULT NULL,
  `conversion_model` varchar(255) DEFAULT NULL,
  `measurement_window` varchar(255) DEFAULT NULL,
  `conversion_value_description` varchar(255) DEFAULT NULL,
  `conversion_value` bigint(20) DEFAULT NULL,
  `sk_publisher_app_store_id` bigint(20) DEFAULT NULL,
  `site_id` varchar(255) DEFAULT NULL,
  `sk_installs` bigint(20) DEFAULT NULL,
  `sk_redownloads` bigint(20) DEFAULT NULL,
  `token_id` varchar(255) DEFAULT NULL,
  `sk_source_identifier` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_kochava_skan_conv_report_conversion_model` (`conversion_model`),
  KEY `idx_kochava_skan_conv_report_conversion_value_description` (`conversion_value_description`),
  KEY `idx_kochava_skan_conv_report_sk_publisher_app_store_id` (`sk_publisher_app_store_id`),
  KEY `idx_kochava_skan_conv_report_date_range_start_utc` (`date_range_start_utc`),
  KEY `idx_kochava_skan_conv_report_date_range_end_utc` (`date_range_end_utc`),
  KEY `idx_kochava_skan_conv_report_advertiser_app_store_id` (`advertiser_app_store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=302 DEFAULT CHARSET=latin1;
Editor is loading...