Create kochava_skan_conv_report table
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...