{"slug":"edara-connect","name":"Edara Connect","description":"Seamlessly integrates your WooCommerce store with Edara ERP to synchronize orders, inventory, and financial data in real-time.","author":"EDRAK Software","active_installs":20,"version":"2.0.5","wp_org_url":"https://wordpress.org/plugins/edara-connect/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"edara_cities","full_table_name":"wp_edara_cities","description":"Stores edara cities data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_cities` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `edara_id` int NOT NULL,\\n  `city_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `country_id` bigint unsigned NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_edara_id` (`edara_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_configuration","full_table_name":"wp_edara_configuration","description":"Stores edara configuration data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_configuration` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `config_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `config_value` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_config_key` (`config_key`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_countries","full_table_name":"wp_edara_countries","description":"Stores edara countries data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_countries` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `edara_id` int NOT NULL,\\n  `country_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_edara_id` (`edara_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_currencies","full_table_name":"wp_edara_currencies","description":"Stores edara currencies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_currencies` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `code` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `edara_id` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_customers","full_table_name":"wp_edara_customers","description":"Stores edara customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_customers` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `wc_customer_id` bigint unsigned NOT NULL,\\n  `type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `edara_id` int NOT NULL,\\n  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_wc_customer_id` (`wc_customer_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_logs","full_table_name":"wp_edara_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_logs` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `operation` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `details` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_orders","full_table_name":"wp_edara_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_orders` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `wc_order_id` bigint unsigned NOT NULL,\\n  `edara_order_id` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_wc_order_id` (`wc_order_id`),\\n  UNIQUE KEY `unique_edara_order_id` (`edara_order_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_products","full_table_name":"wp_edara_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_products` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `wc_product_id` bigint unsigned NOT NULL,\\n  `type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `edara_id` int NOT NULL,\\n  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_wc_product_id` (`wc_product_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"edara_stock_movements","full_table_name":"wp_edara_stock_movements","description":"Stores edara stock movements data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"edara_taxes","full_table_name":"wp_edara_taxes","description":"Stores edara taxes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_edara_taxes` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `percent` double NOT NULL,\\n  `edara_id` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":10}