{"table_name":"amazon_fulfillment_feed_items","full_table_name":"wp_amazon_fulfillment_feed_items","description":"Stores amazon fulfillment feed items data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_amazon_fulfillment_feed_items` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `feed_id` int(11) NOT NULL, `order_id` varchar(64) NOT NULL, `order_item_id` varchar(64) NOT NULL, `quantity` int(11) NOT NULL, `ship_date` datetime NOT NULL, `carrier_code` varchar(64) NOT NULL, `carrier_name` varchar(128) NOT NULL, `tracking_number` varchar(128) NOT NULL, `ship_method` varchar(128) NOT NULL, `ship_from_address_name` varchar(255) NOT NULL, `ship_from_address_line1` varchar(255) NOT NULL, `ship_from_address_line2` varchar(255) NOT NULL, `ship_from_address_city` varchar(128) NOT NULL, `ship_from_address_state` varchar(128) NOT NULL, `ship_from_address_postal` varchar(64) NOT NULL, `ship_from_address_country` varchar(128) NOT NULL, `date_added` datetime NOT NULL );","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"feed_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"order_item_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"ship_date","type":"datetime","nullable":false,"primary_key":false},{"name":"carrier_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"carrier_name","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"tracking_number","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_method","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_line1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_line2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_from_address_city","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_state","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"ship_from_address_postal","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"ship_from_address_country","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-lister-for-amazon","name":"WP-Lister Lite for Amazon","active_installs":800,"version":"2.9.1","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-amazon/"}}