
-- --------------------------------------------------------

--
-- Table structure for table `job_categories`
--

CREATE TABLE `job_categories` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `job_categories`
--

INSERT INTO `job_categories` (`id`, `deleted_at`, `created_at`, `updated_at`, `name`, `status`) VALUES
(1, NULL, NULL, NULL, 'Accounting & Finance', NULL),
(2, NULL, NULL, NULL, 'Admin', NULL),
(3, NULL, NULL, NULL, 'Consultancy', NULL),
(4, NULL, NULL, NULL, 'Creative & Design', NULL),
(5, NULL, NULL, NULL, 'Customer Services', NULL),
(6, NULL, NULL, NULL, 'Energy, Oil & Gas', NULL),
(7, NULL, NULL, NULL, 'Engineering', NULL),
(8, NULL, NULL, NULL, 'HR & Recruitment', NULL),
(9, NULL, NULL, NULL, 'Healthcare & Nursing', NULL),
(10, NULL, NULL, NULL, 'Hospitality & Catering', NULL),
(11, NULL, NULL, NULL, 'Information Technology (IT)', NULL),
(12, NULL, NULL, NULL, 'Legal', NULL),
(13, NULL, NULL, NULL, 'Logistics & Warehouse', NULL),
(14, NULL, NULL, NULL, 'Maintenance', NULL),
(15, NULL, NULL, NULL, 'Manufacturing', NULL),
(16, NULL, NULL, NULL, 'Other/General', NULL),
(17, NULL, NULL, NULL, 'PR, Advertising & Marketing', NULL),
(18, NULL, NULL, NULL, 'Part Time', NULL),
(19, NULL, NULL, NULL, 'Property', NULL),
(20, NULL, NULL, NULL, 'Retail', NULL),
(21, NULL, NULL, NULL, 'Sales', NULL),
(22, NULL, NULL, NULL, 'Scientific & QA', NULL),
(23, NULL, NULL, NULL, 'Teaching', NULL),
(24, NULL, NULL, NULL, 'Trade & Construction', NULL),
(25, NULL, NULL, NULL, 'Travel', NULL);
