{"slug":"job-board-by-ejobsitesoftware","name":"Job Board by ejobsitesoftware","description":"A comprehensive job board plugin with features like job posting, job search, applications, employer/jobseeker dashboards, and more.","author":"jobboardsoftware","active_installs":10,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/job-board-by-ejobsitesoftware/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"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","columns":[],"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"},{"table_name":"jobboard_saved_jobs","full_table_name":"wp_jobboard_saved_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_jobboard_saved_jobs` (\\n  `id` bigint NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint NOT NULL,\\n  `job_id` bigint NOT NULL,\\n  `saved_date` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `user_job` (`user_id`,`job_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}