{"table_name":"aza_targets","full_table_name":"wp_aza_targets","description":"Stores aza targets data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_targets ( promo_code bigint(10) unsigned NOT NULL, visitor_id varchar(32) NOT NULL, target_timestamp int(11) unsigned NOT NULL, target_id bigint(20) unsigned NOT NULL, target_page_id bigint(20) unsigned, target_page_author bigint(20) unsigned NOT NULL, type varchar(20), KEY promo_code (promo_code), UNIQUE KEY target (target_id, type) ) $collate;\");","columns":[{"name":"promo_code","type":"bigint(10) unsigned","nullable":false,"primary_key":false},{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"target_timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"target_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"target_page_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"target_page_author","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false}],"plugin":{"slug":"azexo-advertising-analytics","name":"AZEXO Advertising Analytics","active_installs":10,"version":"1.27.3","wp_org_url":"https://wordpress.org/plugins/azexo-advertising-analytics/"}}