{"slug":"wc-zoho-inventory","name":"Integration of WooCommerce and Zoho Inventory","description":"Visit plugin's website","author":"formsintegrations","active_installs":20,"version":"2.8","wp_org_url":"https://wordpress.org/plugins/wc-zoho-inventory/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bit_wc_zoho_inventory_integration","full_table_name":"wp_bit_wc_zoho_inventory_integration","description":"Stores bit wc zoho inventory integration data created by this plugin.","detection_method":"both","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"integration_details","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT(20) unsigned","nullable":false,"primary_key":false},{"name":"api_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_obj","type":"TEXT","nullable":true,"primary_key":false},{"name":"generated_at","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_bit_wc_zoho_inventory_integration` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `integration_details` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bit_wc_zoho_inventory_log","full_table_name":"wp_bit_wc_zoho_inventory_log","description":"A logging table that records activity, events, or audit history.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bit_wc_zoho_inventory_log` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `api_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `response_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `response_obj` text COLLATE utf8mb4_unicode_520_ci,\\n  `generated_at` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}