MariaDB [app_17339]> show create table attribution\G
*************************** 1. row ***************************
       Table: attribution
Create Table: CREATE TABLE `attribution` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `device_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `install_id` bigint(20) NOT NULL,
  `attribution_prompt` varchar(32) DEFAULT NULL,
  `attribution_action` varchar(32) DEFAULT NULL,
  `prompt_date` datetime DEFAULT NULL,
  `attribution_date` datetime DEFAULT NULL,
  `network_id` int(11) DEFAULT NULL,
  `campaign_id` bigint(20) DEFAULT NULL,
  `site_id` varchar(512) DEFAULT NULL,
  `creative_id` varchar(512) DEFAULT NULL,
  `identifiers` text DEFAULT NULL,
  `ad_information` text DEFAULT NULL,
  `device_information` text DEFAULT NULL,
  `country_code2` char(2) DEFAULT NULL,
  `country_code3` char(3) DEFAULT NULL,
  `date_last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `device_id` (`device_id`),
  KEY `network_id` (`network_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35506 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED
1 row in set (0.000 sec)

MariaDB [app_17339]>