{"table_name":"contacts","full_table_name":"wp_contacts","description":"Stores contacts data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `contacts` ( `contact_id` BIGINT NOT NULL , `order_key` VARCHAR(255) NOT NULL , `payment_type` VARCHAR(255) NOT NULL , `payment_status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL , `check_date` DATETIME NOT NULL , `ip` VARCHAR(255) NOT NULL , `order_parent` BIGINT NOT NULL , `source` VARCHAR(255) NOT NULL , `product_id` BIGINT NOT NULL , `customer_id` BIGINT NOT NULL , `coupon` VARCHAR(255) NOT NULL , `tax` FLOAT NOT NULL , `licence_key` VARCHAR(255) NOT NULL , `licence_to` VARCHAR(255) NOT NULL , `order_type` VARCHAR(255) , `connected_id` BIGINT NOT NULL , PRIMARY KEY (`contact_id`), KEY `fkIdx_159` (`product_id`), CONSTRAINT `products_to_contacts` FOREIGN KEY `fkIdx_159` (`product_id`) REFERENCES `products` (`product_id`), KEY `fkIdx_163` (`customer_id`), CONSTRAINT `customers_to_contacts` FOREIGN KEY `fkIdx_163` (`customer_id`) REFERENCES `customers` (`customer_id`) );","columns":[{"name":"contact_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"order_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"check_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"order_parent","type":"BIGINT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"coupon","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"tax","type":"FLOAT","nullable":false,"primary_key":false},{"name":"licence_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"licence_to","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"order_type","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"connected_id","type":"BIGINT","nullable":false,"primary_key":false}],"plugin":{"slug":"email-reminders","name":"Email Reminders","active_installs":200,"version":"2.0.7","wp_org_url":"https://wordpress.org/plugins/email-reminders/"}}