{"table_name":"jobboard_applications","full_table_name":"wp_jobboard_applications","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"both","confidence":"high","create_sql":"CREATE TABLE `wp_jobboard_applications` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `job_id` bigint NOT NULL,\\n  `applicant_id` bigint NOT NULL,\\n  `applicant_name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `applicant_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `cover_letter` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `resume_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pending',\\n  `applied_date` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"job-board-by-ejobsitesoftware","name":"Job Board by ejobsitesoftware","active_installs":10,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/job-board-by-ejobsitesoftware/"}}