-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `inventory`
--

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

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `log_name` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_type` varchar(255) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_type` varchar(255) DEFAULT NULL,
  `causer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `batch_uuid` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
(1, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 5, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":5,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-11T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:57:54.000000Z\",\"requester_id\":1},\"old\":{\"id\":5,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-10T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:57:54.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 09:44:30', '2024-08-21 09:44:30'),
(2, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 5, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":5,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-11T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":2,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:57:54.000000Z\",\"requester_id\":1},\"old\":{\"id\":5,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-11T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:57:54.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 09:53:52', '2024-08-21 09:53:52'),
(3, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 7, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":7,\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 09:58:04', '2024-08-21 09:58:04'),
(4, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 6, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":6,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"2024-08-21T14:59:28.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":3,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\",\"days\":9145},\"created_at\":\"2024-08-21T13:58:18.000000Z\",\"requester_id\":1},\"old\":{\"id\":6,\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-10T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:58:18.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 09:59:28', '2024-08-21 09:59:28'),
(5, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 7, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":7,\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":2,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":2,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1},\"old\":{\"id\":7,\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:01:59', '2024-08-21 10:01:59'),
(6, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 7, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":7,\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":2,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":2,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1},\"old\":{\"id\":7,\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":2,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":2,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:02:26', '2024-08-21 10:02:26'),
(7, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 7, 'App\\Models\\User', 1, '{\"old\":{\"id\":7,\"number\":\"\",\"request_date\":\"2007-11-05T03:31:00.000000Z\",\"complete_date\":\"2012-01-25T07:43:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":2,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":2,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Enim sed animi fugi\",\"final_comments\":\"Harum aliquid aut pa\",\"labour_hours\":97,\"action_requested\":\"Do nihil officia sit\",\"contractor_details\":{\"contractor_cost\":\"46\",\"contractor_code\":\"Quod sint distinctio\"},\"additional_costs\":{\"material_cost\":\"11\",\"total_hours\":\"79\",\"other_cost\":\"22\"},\"created_at\":\"2024-08-21T14:58:04.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:35', '2024-08-21 10:28:35'),
(8, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 5, 'App\\Models\\User', 1, '{\"old\":{\"id\":5,\"number\":\"\",\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"1972-10-11T14:49:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":2,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\"},\"created_at\":\"2024-08-21T13:57:54.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:38', '2024-08-21 10:28:38'),
(9, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 6, 'App\\Models\\User', 1, '{\"old\":{\"id\":6,\"number\":\"\",\"request_date\":\"1999-08-08T14:02:00.000000Z\",\"complete_date\":\"2024-08-21T14:59:28.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":3,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":2,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Non amet sunt porro\",\"final_comments\":\"Neque animi velit c\",\"labour_hours\":96,\"action_requested\":\"In optio maxime ea\",\"contractor_details\":{\"contractor_cost\":\"20\",\"contractor_code\":\"Maiores ipsa id eve\"},\"additional_costs\":{\"material_cost\":\"62\",\"total_hours\":\"63\",\"other_cost\":\"60\",\"days\":9145},\"created_at\":\"2024-08-21T13:58:18.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:43', '2024-08-21 10:28:43'),
(10, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 1, 'App\\Models\\User', 1, '{\"old\":{\"id\":1,\"number\":\"\",\"request_date\":\"2024-08-21T04:18:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"fm\",\"final_comments\":\"cm\",\"labour_hours\":0,\"action_requested\":\"di\",\"contractor_details\":{\"contractor_cost\":\"767\",\"contractor_code\":\"7f7\"},\"additional_costs\":{\"material_cost\":\"6567\",\"total_hours\":\"7\",\"other_cost\":\"7\"},\"created_at\":\"2024-08-21T04:19:58.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:47', '2024-08-21 10:28:47'),
(11, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 3, 'App\\Models\\User', 1, '{\"old\":{\"id\":3,\"number\":\"\",\"request_date\":\"2024-08-21T07:21:00.000000Z\",\"complete_date\":\"2024-08-21T14:18:31.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":2,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"cmas\\r\\n                                                as\",\"labour_hours\":232,\"action_requested\":\"red\",\"contractor_details\":{\"contractor_cost\":\"24\",\"contractor_code\":\"233\"},\"additional_costs\":{\"material_cost\":\"23.01\",\"total_hours\":\"233\",\"other_cost\":\"233\",\"days\":0},\"created_at\":\"2024-08-21T08:01:25.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:50', '2024-08-21 10:28:50'),
(12, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 4, 'App\\Models\\User', 1, '{\"old\":{\"id\":4,\"number\":\"\",\"request_date\":\"2024-08-21T13:45:00.000000Z\",\"complete_date\":\"2024-08-21T14:22:35.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":3,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"sda\",\"final_comments\":\"fc\",\"labour_hours\":213,\"action_requested\":\"efwesd\",\"contractor_details\":{\"contractor_cost\":\"32\",\"contractor_code\":\"asd23\"},\"additional_costs\":{\"material_cost\":\"33\",\"total_hours\":\"43\",\"other_cost\":\"23\",\"days\":0},\"created_at\":\"2024-08-21T13:46:55.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:28:53', '2024-08-21 10:28:53'),
(13, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 8, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":8,\"number\":\"1\",\"request_date\":\"2021-04-07T05:28:00.000000Z\",\"complete_date\":\"2023-10-06T20:46:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Doloribus ducimus a\",\"final_comments\":\"Porro culpa nesciunt\",\"labour_hours\":2,\"action_requested\":\"Illo sit voluptas e\",\"contractor_details\":{\"contractor_cost\":\"28\",\"contractor_code\":\"Voluptas eius labore\"},\"additional_costs\":{\"material_cost\":\"90\",\"total_hours\":\"12\",\"other_cost\":\"91\"},\"created_at\":\"2024-08-21T15:32:29.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:32:29', '2024-08-21 10:32:29'),
(14, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 8, 'App\\Models\\User', 1, '{\"old\":{\"id\":8,\"number\":\"1\",\"request_date\":\"2021-04-07T05:28:00.000000Z\",\"complete_date\":\"2023-10-06T20:46:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":1,\"general_comments\":\"Doloribus ducimus a\",\"final_comments\":\"Porro culpa nesciunt\",\"labour_hours\":2,\"action_requested\":\"Illo sit voluptas e\",\"contractor_details\":{\"contractor_cost\":\"28\",\"contractor_code\":\"Voluptas eius labore\"},\"additional_costs\":{\"material_cost\":\"90\",\"total_hours\":\"12\",\"other_cost\":\"91\"},\"created_at\":\"2024-08-21T15:32:29.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:36:12', '2024-08-21 10:36:12'),
(15, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 9, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":9,\"number\":null,\"request_date\":\"1975-02-22T08:47:00.000000Z\",\"complete_date\":\"1999-12-11T00:02:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Hic tempore eum seq\",\"final_comments\":\"Mollit iure animi d\",\"labour_hours\":10,\"action_requested\":\"Voluptatem Ratione\",\"contractor_details\":{\"contractor_cost\":\"4\",\"contractor_code\":\"Enim nemo maiores nu\"},\"additional_costs\":{\"material_cost\":\"85\",\"total_hours\":\"3\",\"other_cost\":\"47\"},\"created_at\":\"2024-08-21T15:37:05.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:37:05', '2024-08-21 10:37:05'),
(16, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 9, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":9,\"number\":\"Facility110009\",\"request_date\":\"1975-02-22T08:47:00.000000Z\",\"complete_date\":\"1999-12-11T00:02:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Hic tempore eum seq\",\"final_comments\":\"Mollit iure animi d\",\"labour_hours\":10,\"action_requested\":\"Voluptatem Ratione\",\"contractor_details\":{\"contractor_cost\":\"4\",\"contractor_code\":\"Enim nemo maiores nu\"},\"additional_costs\":{\"material_cost\":\"85\",\"total_hours\":\"3\",\"other_cost\":\"47\"},\"created_at\":\"2024-08-21T15:37:05.000000Z\",\"requester_id\":1},\"old\":{\"id\":9,\"number\":null,\"request_date\":\"1975-02-22T08:47:00.000000Z\",\"complete_date\":\"1999-12-11T00:02:00.000000Z\",\"wotype_id\":\"1\",\"wo_origin\":\"0\",\"zone_id\":\"1\",\"facility_id\":\"1\",\"time_type_id\":\"1\",\"trade_id\":\"1\",\"technician_id\":\"1\",\"task_id\":\"1\",\"task_type_id\":\"1\",\"status_id\":\"1\",\"priority_id\":\"1\",\"repair_center_id\":\"1\",\"vendor_id\":\"1\",\"building_id\":\"1\",\"floor_id\":\"2\",\"area_id\":\"1\",\"shift_id\":\"1\",\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Hic tempore eum seq\",\"final_comments\":\"Mollit iure animi d\",\"labour_hours\":\"10\",\"action_requested\":\"Voluptatem Ratione\",\"contractor_details\":{\"contractor_cost\":\"4\",\"contractor_code\":\"Enim nemo maiores nu\"},\"additional_costs\":{\"material_cost\":\"85\",\"total_hours\":\"3\",\"other_cost\":\"47\"},\"created_at\":\"2024-08-21T15:37:05.000000Z\",\"requester_id\":\"1\"}}', NULL, '2024-08-21 10:37:05', '2024-08-21 10:37:05'),
(17, 'work_order', 'deleted', 'App\\Models\\WorkOrder', 'deleted', 9, 'App\\Models\\User', 1, '{\"old\":{\"id\":9,\"number\":\"Facility110009\",\"request_date\":\"1975-02-22T08:47:00.000000Z\",\"complete_date\":\"1999-12-11T00:02:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":1,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Hic tempore eum seq\",\"final_comments\":\"Mollit iure animi d\",\"labour_hours\":10,\"action_requested\":\"Voluptatem Ratione\",\"contractor_details\":{\"contractor_cost\":\"4\",\"contractor_code\":\"Enim nemo maiores nu\"},\"additional_costs\":{\"material_cost\":\"85\",\"total_hours\":\"3\",\"other_cost\":\"47\"},\"created_at\":\"2024-08-21T15:37:05.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:37:37', '2024-08-21 10:37:37'),
(18, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 10, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":10,\"number\":null,\"request_date\":\"1980-01-04T07:44:00.000000Z\",\"complete_date\":\"2013-04-19T23:05:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Illo recusandae Aut\",\"final_comments\":\"Facere sit consequat\",\"labour_hours\":76,\"action_requested\":\"Vero dolor quas cons\",\"contractor_details\":{\"contractor_cost\":\"16\",\"contractor_code\":\"Voluptatem quis eum\"},\"additional_costs\":{\"material_cost\":\"82\",\"total_hours\":\"65\",\"other_cost\":\"49\"},\"created_at\":\"2024-08-21T15:38:30.000000Z\",\"requester_id\":1}}', NULL, '2024-08-21 10:38:30', '2024-08-21 10:38:30'),
(19, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 10, 'App\\Models\\User', 1, '{\"attributes\":{\"id\":10,\"number\":\"Facility1_100010\",\"request_date\":\"1980-01-04T07:44:00.000000Z\",\"complete_date\":\"2013-04-19T23:05:00.000000Z\",\"wotype_id\":1,\"wo_origin\":0,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Illo recusandae Aut\",\"final_comments\":\"Facere sit consequat\",\"labour_hours\":76,\"action_requested\":\"Vero dolor quas cons\",\"contractor_details\":{\"contractor_cost\":\"16\",\"contractor_code\":\"Voluptatem quis eum\"},\"additional_costs\":{\"material_cost\":\"82\",\"total_hours\":\"65\",\"other_cost\":\"49\"},\"created_at\":\"2024-08-21T15:38:30.000000Z\",\"requester_id\":1},\"old\":{\"id\":10,\"number\":null,\"request_date\":\"1980-01-04T07:44:00.000000Z\",\"complete_date\":\"2013-04-19T23:05:00.000000Z\",\"wotype_id\":\"1\",\"wo_origin\":\"0\",\"zone_id\":\"1\",\"facility_id\":\"1\",\"time_type_id\":\"1\",\"trade_id\":\"1\",\"technician_id\":\"1\",\"task_id\":\"1\",\"task_type_id\":\"1\",\"status_id\":\"2\",\"priority_id\":\"1\",\"repair_center_id\":\"1\",\"vendor_id\":\"1\",\"building_id\":\"1\",\"floor_id\":\"2\",\"area_id\":\"1\",\"shift_id\":\"1\",\"created_by\":1,\"edited_by\":null,\"general_comments\":\"Illo recusandae Aut\",\"final_comments\":\"Facere sit consequat\",\"labour_hours\":\"76\",\"action_requested\":\"Vero dolor quas cons\",\"contractor_details\":{\"contractor_cost\":\"16\",\"contractor_code\":\"Voluptatem quis eum\"},\"additional_costs\":{\"material_cost\":\"82\",\"total_hours\":\"65\",\"other_cost\":\"49\"},\"created_at\":\"2024-08-21T15:38:30.000000Z\",\"requester_id\":\"1\"}}', NULL, '2024-08-21 10:38:30', '2024-08-21 10:38:30'),
(20, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 11, NULL, NULL, '{\"attributes\":{\"id\":11,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:07.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:07', '2024-08-28 03:55:07'),
(21, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 11, NULL, NULL, '{\"attributes\":{\"id\":11,\"number\":\"Facility1_100011\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:07.000000Z\",\"requester_id\":1},\"old\":{\"id\":11,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:07.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:07', '2024-08-28 03:55:07'),
(22, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 12, NULL, NULL, '{\"attributes\":{\"id\":12,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:56', '2024-08-28 03:55:56'),
(23, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 12, NULL, NULL, '{\"attributes\":{\"id\":12,\"number\":\"Facility1_100012\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1},\"old\":{\"id\":12,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:56', '2024-08-28 03:55:56'),
(24, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 13, NULL, NULL, '{\"attributes\":{\"id\":13,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:56', '2024-08-28 03:55:56'),
(25, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 13, NULL, NULL, '{\"attributes\":{\"id\":13,\"number\":\"Facility1_100013\",\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1},\"old\":{\"id\":13,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T08:55:56.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:55:57', '2024-08-28 03:55:57'),
(26, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 14, NULL, NULL, '{\"attributes\":{\"id\":14,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:59:03.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:59:03', '2024-08-28 03:59:03'),
(27, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 14, NULL, NULL, '{\"attributes\":{\"id\":14,\"number\":\"Facility1_100014\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:59:03.000000Z\",\"requester_id\":1},\"old\":{\"id\":14,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T08:59:03.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 03:59:03', '2024-08-28 03:59:03'),
(28, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 15, NULL, NULL, '{\"attributes\":{\"id\":15,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(29, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 15, NULL, NULL, '{\"attributes\":{\"id\":15,\"number\":\"Facility1_100015\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":15,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(30, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 16, NULL, NULL, '{\"attributes\":{\"id\":16,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(31, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 16, NULL, NULL, '{\"attributes\":{\"id\":16,\"number\":\"Facility1_100016\",\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":16,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(32, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 17, NULL, NULL, '{\"attributes\":{\"id\":17,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(33, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 17, NULL, NULL, '{\"attributes\":{\"id\":17,\"number\":\"Facility1_100017\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":17,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:10:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:10:01', '2024-08-28 04:10:01'),
(34, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 18, NULL, NULL, '{\"attributes\":{\"id\":18,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01'),
(35, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 18, NULL, NULL, '{\"attributes\":{\"id\":18,\"number\":\"Facility1_100018\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":18,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01'),
(36, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 19, NULL, NULL, '{\"attributes\":{\"id\":19,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01'),
(37, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 19, NULL, NULL, '{\"attributes\":{\"id\":19,\"number\":\"Facility1_100019\",\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":19,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01');
INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
(38, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 20, NULL, NULL, '{\"attributes\":{\"id\":20,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01'),
(39, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 20, NULL, NULL, '{\"attributes\":{\"id\":20,\"number\":\"Facility1_100020\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":20,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:11:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:11:01', '2024-08-28 04:11:01'),
(40, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 21, NULL, NULL, '{\"attributes\":{\"id\":21,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(41, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 21, NULL, NULL, '{\"attributes\":{\"id\":21,\"number\":\"Facility1_100021\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":21,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(42, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 22, NULL, NULL, '{\"attributes\":{\"id\":22,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(43, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 22, NULL, NULL, '{\"attributes\":{\"id\":22,\"number\":\"Facility1_100022\",\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":22,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(44, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 23, NULL, NULL, '{\"attributes\":{\"id\":23,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(45, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 23, NULL, NULL, '{\"attributes\":{\"id\":23,\"number\":\"Facility1_100023\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":23,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:12:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:12:01', '2024-08-28 04:12:01'),
(46, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 24, NULL, NULL, '{\"attributes\":{\"id\":24,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:13:02', '2024-08-28 04:13:02'),
(47, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 24, NULL, NULL, '{\"attributes\":{\"id\":24,\"number\":\"Facility1_100024\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1},\"old\":{\"id\":24,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:13:02', '2024-08-28 04:13:02'),
(48, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 25, NULL, NULL, '{\"attributes\":{\"id\":25,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:13:02', '2024-08-28 04:13:02'),
(49, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 25, NULL, NULL, '{\"attributes\":{\"id\":25,\"number\":\"Facility1_100025\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1},\"old\":{\"id\":25,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:13:02.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:13:02', '2024-08-28 04:13:02'),
(50, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 26, NULL, NULL, '{\"attributes\":{\"id\":26,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(51, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 26, NULL, NULL, '{\"attributes\":{\"id\":26,\"number\":\"Facility1_100026\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":26,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(52, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 27, NULL, NULL, '{\"attributes\":{\"id\":27,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(53, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 27, NULL, NULL, '{\"attributes\":{\"id\":27,\"number\":\"Facility1_100027\",\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":27,\"number\":null,\"request_date\":\"2024-08-27T14:41:00.000000Z\",\"complete_date\":null,\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":213,\"action_requested\":\"do iy\",\"contractor_details\":{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"},\"additional_costs\":{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(54, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 28, NULL, NULL, '{\"attributes\":{\"id\":28,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(55, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 28, NULL, NULL, '{\"attributes\":{\"id\":28,\"number\":\"Facility1_100028\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":28,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:22:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:22:01', '2024-08-28 04:22:01'),
(56, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 29, NULL, NULL, '{\"attributes\":{\"id\":29,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:27:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:27:01', '2024-08-28 04:27:01'),
(57, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 29, NULL, NULL, '{\"attributes\":{\"id\":29,\"number\":\"Facility1_100029\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:27:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":29,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:27:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:27:01', '2024-08-28 04:27:01'),
(58, 'work_order', 'created', 'App\\Models\\WorkOrder', 'created', 30, NULL, NULL, '{\"attributes\":{\"id\":30,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:28:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:28:01', '2024-08-28 04:28:01'),
(59, 'work_order', 'updated', 'App\\Models\\WorkOrder', 'updated', 30, NULL, NULL, '{\"attributes\":{\"id\":30,\"number\":\"Facility1_100030\",\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:28:01.000000Z\",\"requester_id\":1},\"old\":{\"id\":30,\"number\":null,\"request_date\":\"2024-08-27T13:13:00.000000Z\",\"complete_date\":\"2024-08-28T18:13:00.000000Z\",\"wotype_id\":1,\"wo_origin\":1,\"zone_id\":1,\"facility_id\":1,\"time_type_id\":1,\"trade_id\":1,\"technician_id\":1,\"task_id\":1,\"task_type_id\":1,\"status_id\":2,\"priority_id\":1,\"repair_center_id\":1,\"vendor_id\":1,\"building_id\":1,\"floor_id\":2,\"area_id\":1,\"shift_id\":1,\"created_by\":null,\"edited_by\":1,\"general_comments\":\"gm\",\"final_comments\":\"pm\",\"labour_hours\":1213,\"action_requested\":\"do\",\"contractor_details\":{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"},\"additional_costs\":{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"},\"created_at\":\"2024-08-28T09:28:01.000000Z\",\"requester_id\":1}}', NULL, '2024-08-28 04:28:01', '2024-08-28 04:28:01');

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

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `area_type_id` bigint(20) UNSIGNED NOT NULL,
  `floor_id` bigint(20) UNSIGNED NOT NULL,
  `building_id` bigint(20) UNSIGNED NOT NULL,
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `facility_id` bigint(20) UNSIGNED NOT NULL,
  `room_number` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` (`id`, `code`, `area_type_id`, `floor_id`, `building_id`, `zone_id`, `facility_id`, `room_number`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'area2', 1, 2, 1, 1, 1, '958', 'Sunt aut et possimu', 1, '2024-08-20 22:54:03', '2024-08-20 22:54:03'),
(2, 'area b1', 2, 2, 1, 1, 1, '893', 'Odio autem odio sint', 1, '2024-08-20 22:54:33', '2024-08-20 22:54:33');

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

--
-- Table structure for table `area_types`
--

CREATE TABLE `area_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area_types`
--

INSERT INTO `area_types` (`id`, `code`, `description`, `created_at`, `updated_at`) VALUES
(1, 'area type1', 'desc', '2024-08-20 22:53:28', '2024-08-20 22:53:28'),
(2, 'area type2', 'desc', '2024-08-20 22:53:41', '2024-08-20 22:53:41');

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

--
-- Table structure for table `buildings`
--

CREATE TABLE `buildings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `facility_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `buildings`
--

INSERT INTO `buildings` (`id`, `name`, `facility_id`, `created_at`, `updated_at`) VALUES
(1, 'buillding1', 1, '2024-08-19 23:21:05', '2024-08-19 23:21:05'),
(2, 'buillding2', 2, '2024-08-19 23:21:14', '2024-08-19 23:21:14');

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

--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `facilities`
--

INSERT INTO `facilities` (`id`, `name`, `zone_id`, `created_at`, `updated_at`) VALUES
(1, 'Facility1', 1, '2024-08-19 23:20:43', '2024-08-19 23:20:43'),
(2, 'facility2', 2, '2024-08-19 23:20:52', '2024-08-19 23:20:52');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `floors`
--

CREATE TABLE `floors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `floor_code` varchar(255) NOT NULL,
  `floor_type` varchar(255) NOT NULL,
  `building_id` bigint(20) UNSIGNED NOT NULL,
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `facility_id` bigint(20) UNSIGNED NOT NULL,
  `floor_level_number` varchar(255) NOT NULL,
  `floor_description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `floors`
--

INSERT INTO `floors` (`id`, `floor_code`, `floor_type`, `building_id`, `zone_id`, `facility_id`, `floor_level_number`, `floor_description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'floor1', 'type', 2, 2, 2, '1', 'desc', 1, '2024-08-19 23:53:01', '2024-08-19 23:59:39'),
(2, 'floor2', 'type', 1, 1, 1, '1', 'desc', 1, '2024-08-20 00:00:37', '2024-08-20 00:00:37'),
(3, 'floor2', 'typ', 2, 2, 2, '2', 'desc', 1, '2024-08-20 22:52:07', '2024-08-20 22:52:07');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_10_19_125905_create_roles_table', 1),
(6, '2022_10_19_142014_add_role_to_users_table', 1),
(7, '2022_10_21_073030_create_permissions_table', 1),
(8, '2022_10_21_104024_create_permission_roles_table', 1),
(9, '2024_08_10_063632_create_task_types_table', 1),
(10, '2024_08_10_063633_create_tasks_table', 1),
(11, '2024_08_11_042139_create_zones_table', 1),
(12, '2024_08_11_069993_create_facilities_table', 1),
(13, '2024_08_12_150120_create_requesters_table', 1),
(14, '2024_08_13_073011_create_repair_centers_table', 1),
(15, '2024_08_13_074446_create_trades_table', 1),
(16, '2024_08_13_102646_create_priorities_table', 1),
(17, '2024_08_13_104421_create_technicians_table', 1),
(18, '2024_08_13_125040_create_wotypes_table', 1),
(19, '2024_08_15_154251_create_statuses_table', 1),
(20, '2024_08_16_033055_create_buildings_table', 1),
(21, '2024_08_16_034816_create_floors_table', 1),
(22, '2024_08_16_042219_create_area_types_table', 1),
(23, '2024_08_16_042220_create_areas_table', 1),
(24, '2024_08_16_120724_create_vendors_table', 1),
(25, '2024_08_16_120818_create_shifts_table', 1),
(26, '2024_08_17_052057_create_time_types_table', 1),
(27, '2024_08_17_052255_create_work_orders_table', 1),
(28, '2024_08_17_054414_create_technician_work_orders_table', 1),
(29, '2024_08_21_143848_create_activity_log_table', 2),
(30, '2024_08_21_143849_add_event_column_to_activity_log_table', 2),
(31, '2024_08_21_143850_add_batch_uuid_column_to_activity_log_table', 2),
(32, '2024_08_27_044130_create_preventive_maintenances_table', 3),
(33, '2024_08_27_050602_create_p_m_instructions_table', 3),
(34, '2024_08_27_130632_create_scheduling_options_pms_table', 3),
(35, '2024_08_27_131747_create_preventive_maintenance_technicians_table', 4);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Manage Roles', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(2, 'Manage Users', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(3, 'Manage Permissions', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(4, 'Manage Facilities', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(5, 'Manage Tasks', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(6, 'Manage Zones', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(7, 'Manage TaskTypes', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(8, 'Manage Requesters', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(9, 'Manage RepairCenters', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(10, 'Manage Trades', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(11, 'Manage Priorities', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(12, 'Manage Technicians', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(13, 'Manage Wotypes', '2024-08-17 08:04:09', '2024-08-17 08:04:09'),
(14, 'Manage Statuses', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(15, 'Manage Buildings', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(16, 'Manage Floors', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(17, 'Manage Areas', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(18, 'Manage AreaTypes', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(19, 'Manage Shifts', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(20, 'Manage Departments', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(21, 'Manage Vendors', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(22, 'Manage WorkOrders', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(23, 'Manage TimeTypes', '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(24, 'Edit Closed Order', '2024-08-21 09:09:45', '2024-08-21 09:09:45'),
(25, 'Reopen Closed Order', '2024-08-21 09:09:45', '2024-08-21 09:09:45'),
(26, 'view_logs', '2024-08-21 09:50:30', '2024-08-21 09:50:30'),
(27, 'Manage PreventiveMaintenance', '2024-08-27 02:53:52', '2024-08-27 02:53:52');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
(54, 1, 1, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(55, 1, 2, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(56, 1, 3, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(57, 1, 4, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(58, 1, 5, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(59, 1, 6, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(60, 1, 7, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(61, 1, 8, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(62, 1, 9, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(63, 1, 10, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(64, 1, 11, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(65, 1, 12, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(66, 1, 13, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(67, 1, 14, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(68, 1, 15, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(69, 1, 16, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(70, 1, 17, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(71, 1, 18, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(72, 1, 19, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(73, 1, 20, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(74, 1, 21, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(75, 1, 22, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(76, 1, 23, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(77, 1, 24, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(78, 1, 25, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(79, 1, 26, '2024-08-27 10:40:01', '2024-08-27 10:40:01'),
(80, 1, 27, '2024-08-27 10:40:01', '2024-08-27 10:40:01');

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

--
-- Table structure for table `pm_technician`
--

CREATE TABLE `pm_technician` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `technician_id` bigint(20) UNSIGNED NOT NULL,
  `preventive_maintenance_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pm_technician`
--

INSERT INTO `pm_technician` (`id`, `technician_id`, `preventive_maintenance_id`, `created_at`, `updated_at`) VALUES
(1, 2, 3, NULL, NULL),
(2, 2, 11, NULL, NULL);

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

--
-- Table structure for table `preventive_maintenances`
--

CREATE TABLE `preventive_maintenances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `complete_date` datetime DEFAULT NULL,
  `wotype_id` bigint(20) UNSIGNED NOT NULL,
  `wo_origin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = Not PM, 1 = PM',
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `facility_id` bigint(20) UNSIGNED NOT NULL,
  `time_type_id` bigint(20) UNSIGNED NOT NULL,
  `trade_id` bigint(20) UNSIGNED NOT NULL,
  `technician_id` bigint(20) UNSIGNED NOT NULL,
  `task_id` bigint(20) UNSIGNED NOT NULL,
  `task_type_id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED DEFAULT NULL,
  `priority_id` bigint(20) UNSIGNED DEFAULT NULL,
  `repair_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `building_id` bigint(20) UNSIGNED NOT NULL,
  `floor_id` bigint(20) UNSIGNED NOT NULL,
  `area_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `edited_by` bigint(20) UNSIGNED DEFAULT NULL,
  `requester_id` bigint(20) UNSIGNED DEFAULT NULL,
  `general_comments` longtext DEFAULT NULL,
  `final_comments` longtext DEFAULT NULL,
  `labour_hours` double NOT NULL COMMENT 'work order cannot be closed if this field is empty',
  `action_requested` longtext NOT NULL,
  `contractor_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`contractor_details`)),
  `additional_costs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`additional_costs`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `preventive_maintenances`
--

INSERT INTO `preventive_maintenances` (`id`, `number`, `request_date`, `complete_date`, `wotype_id`, `wo_origin`, `zone_id`, `facility_id`, `time_type_id`, `trade_id`, `technician_id`, `task_id`, `task_type_id`, `status_id`, `priority_id`, `repair_center_id`, `vendor_id`, `building_id`, `floor_id`, `area_id`, `shift_id`, `created_by`, `edited_by`, `requester_id`, `general_comments`, `final_comments`, `labour_hours`, `action_requested`, `contractor_details`, `additional_costs`, `created_at`, `updated_at`) VALUES
(3, 'Facility1_10003', '2024-08-27 13:13:00', '2024-08-28 18:13:00', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, NULL, 1, 1, 'gm', 'pm', 1213, 'do', '{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"}', '{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"}', '2024-08-27 08:20:39', '2024-08-27 09:24:24'),
(9, 'Facility1_10009', '2024-08-27 14:41:00', NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, NULL, 1, 1, 'gm', 'pm', 213, 'do iy', '{\"contractor_cost\":\"2333\",\"contractor_code\":\"2sd32\"}', '{\"material_cost\":\"23\",\"total_hours\":\"33\",\"other_cost\":\"23\"}', '2024-08-27 09:43:06', '2024-08-27 09:43:25'),
(11, 'Facility1_10003', '2024-08-27 13:13:00', '2024-08-28 18:13:00', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, NULL, 1, 1, 'gm', 'pm', 1213, 'do', '{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"}', '{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"}', '2024-08-28 04:04:45', '2024-08-28 04:04:45');

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

--
-- Table structure for table `priorities`
--

CREATE TABLE `priorities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `priorities`
--

INSERT INTO `priorities` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'urdent', 1, '2024-08-20 22:50:19', '2024-08-20 22:50:19'),
(2, 'not urgent', 1, '2024-08-20 22:50:34', '2024-08-20 22:50:34');

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

--
-- Table structure for table `p_m_instructions`
--

CREATE TABLE `p_m_instructions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(255) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 1,
  `preventive_maintenance_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `p_m_instructions`
--

INSERT INTO `p_m_instructions` (`id`, `description`, `order`, `preventive_maintenance_id`, `created_at`, `updated_at`) VALUES
(23, 'step1', 1, 9, '2024-08-27 09:43:25', '2024-08-27 09:43:25'),
(24, 'step2', 2, 9, '2024-08-27 09:43:25', '2024-08-27 09:43:25'),
(30, 'do 1', 1, 3, '2024-08-28 04:01:00', '2024-08-28 04:01:00'),
(31, 'do 2', 2, 3, '2024-08-28 04:01:00', '2024-08-28 04:01:00'),
(32, 'do 1', 1, 11, '2024-08-28 04:04:45', '2024-08-28 04:04:45'),
(33, 'do 2', 2, 11, '2024-08-28 04:04:45', '2024-08-28 04:04:45');

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

--
-- Table structure for table `repair_centers`
--

CREATE TABLE `repair_centers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `repair_centers`
--

INSERT INTO `repair_centers` (`id`, `name`, `description`, `ordering`, `created_at`, `updated_at`) VALUES
(1, 'repair center', 'desc', 2, '2024-08-18 21:24:33', '2024-08-18 21:24:33'),
(2, 'repair center 2', 'desc', 4, '2024-08-18 21:24:52', '2024-08-18 21:24:52');

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

--
-- Table structure for table `requesters`
--

CREATE TABLE `requesters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requesters`
--

INSERT INTO `requesters` (`id`, `name`, `email`, `phone`, `created_at`, `updated_at`) VALUES
(1, 'requester', 'requester@gmail.com', '01231234324', '2024-08-21 04:03:11', NULL);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'SuperAdmin', '2024-08-17 08:04:10', '2024-08-17 08:04:10');

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

--
-- Table structure for table `scheduling_options_pms`
--

CREATE TABLE `scheduling_options_pms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `daily` varchar(255) NOT NULL,
  `weekly` varchar(255) NOT NULL,
  `monthly` varchar(255) NOT NULL,
  `yearly_month` varchar(255) NOT NULL,
  `yearly_day` varchar(255) NOT NULL,
  `preventive_maintenance_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scheduling_options_pms`
--

INSERT INTO `scheduling_options_pms` (`id`, `daily`, `weekly`, `monthly`, `yearly_month`, `yearly_day`, `preventive_maintenance_id`, `created_at`, `updated_at`) VALUES
(1, 'every_weekday', 'Wednesday', 'first_day', 'November', '16', 3, '2024-08-27 08:20:39', '2024-08-27 09:24:24'),
(5, 'every_weekday', 'Monday', 'first_monday', 'February', '15', 9, '2024-08-27 09:43:06', '2024-08-27 09:43:06'),
(7, 'every_weekday', 'Thursday', 'first_day', 'November', '16', 11, '2024-08-28 04:04:45', '2024-08-28 04:04:45');

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

--
-- Table structure for table `shifts`
--

CREATE TABLE `shifts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `work_days` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`work_days`)),
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shifts`
--

INSERT INTO `shifts` (`id`, `work_days`, `start_time`, `end_time`, `created_at`, `updated_at`) VALUES
(1, '[\"Tuesday\",\"Wednesday\"]', '00:10:00', '21:10:00', '2024-08-19 23:10:43', '2024-08-19 23:10:43');

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Assigned', 1, '2024-08-20 22:49:43', '2024-08-20 22:49:43'),
(2, 'Pending', 1, '2024-08-20 22:49:51', '2024-08-20 22:49:51'),
(3, 'Completed', 1, '2024-08-20 22:50:01', '2024-08-20 22:50:01'),
(4, 'On Hold', 1, '2024-08-20 22:50:01', '2024-08-20 22:50:01'),
(5, 'Cancelled', 1, '2024-08-20 22:50:01', '2024-08-20 22:50:01');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `task_type_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `name`, `task_type_id`, `created_at`, `updated_at`) VALUES
(1, 'task1', 1, '2024-08-20 22:49:01', '2024-08-20 22:49:01'),
(2, 'task2', 2, '2024-08-20 22:49:09', '2024-08-20 22:49:09');

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

--
-- Table structure for table `task_types`
--

CREATE TABLE `task_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `task_types`
--

INSERT INTO `task_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'task type1', '2024-08-18 21:26:16', '2024-08-18 21:26:16'),
(2, 'task type2', '2024-08-18 21:26:28', '2024-08-18 21:26:28');

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

--
-- Table structure for table `technicians`
--

CREATE TABLE `technicians` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tech_code` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `zone_id` bigint(20) NOT NULL,
  `trade_id` bigint(20) UNSIGNED DEFAULT NULL,
  `repair_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `technicians`
--

INSERT INTO `technicians` (`id`, `tech_code`, `first_name`, `last_name`, `full_name`, `zone_id`, `trade_id`, `repair_center_id`, `title`, `phone`, `email`, `status`, `is_admin`, `created_at`, `updated_at`) VALUES
(1, 'Cumque qui ad aut no', 'Sade', 'Wheeler', 'Clementine Holloway', 1, 2, 2, 'Rerum nostrud dolore', '+1 (227) 149-7286', 'jopugopola@mailinator.com', 1, 1, '2024-08-20 22:46:27', '2024-08-20 22:46:27'),
(2, 'Id voluptatibus et m', 'Libby', 'Sweeney', 'Liberty Bolton', 1, 1, 1, 'Est ea accusamus ven', '+1 (632) 867-9595', 'dipaqap@mailinator.com', 1, 1, '2024-08-20 22:47:58', '2024-08-20 22:47:58');

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

--
-- Table structure for table `technician_work_order`
--

CREATE TABLE `technician_work_order` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `technician_id` bigint(20) UNSIGNED NOT NULL,
  `work_order_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `technician_work_order`
--

INSERT INTO `technician_work_order` (`id`, `technician_id`, `work_order_id`, `created_at`, `updated_at`) VALUES
(13, 2, 29, NULL, NULL),
(14, 2, 30, NULL, NULL);

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

--
-- Table structure for table `time_types`
--

CREATE TABLE `time_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` longtext NOT NULL,
  `rate` double NOT NULL,
  `wotype_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `time_types`
--

INSERT INTO `time_types` (`id`, `description`, `rate`, `wotype_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Non ea]', 76.04, 1, 1, '2024-08-17 08:24:11', '2024-08-17 08:30:15');

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

--
-- Table structure for table `trades`
--

CREATE TABLE `trades` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `repair_center_id` bigint(20) UNSIGNED NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trades`
--

INSERT INTO `trades` (`id`, `name`, `repair_center_id`, `ordering`, `created_at`, `updated_at`) VALUES
(1, 'trade', 1, 12, '2024-08-20 22:46:01', '2024-08-20 22:46:01'),
(2, 'trade2', 2, 213, '2024-08-20 22:46:12', '2024-08-20 22:46:12');

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Amazon', '2024-08-20 22:50:57', '2024-08-20 22:50:57'),
(2, 'ebay', '2024-08-20 22:51:04', '2024-08-20 22:51:04');

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

--
-- Table structure for table `work_orders`
--

CREATE TABLE `work_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `complete_date` datetime DEFAULT NULL,
  `wotype_id` bigint(20) UNSIGNED NOT NULL,
  `wo_origin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = Not PM, 1 = PM',
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `facility_id` bigint(20) NOT NULL,
  `time_type_id` bigint(20) UNSIGNED NOT NULL,
  `trade_id` bigint(20) UNSIGNED NOT NULL,
  `technician_id` bigint(20) UNSIGNED NOT NULL,
  `task_id` bigint(20) UNSIGNED NOT NULL,
  `task_type_id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED DEFAULT NULL,
  `priority_id` bigint(20) UNSIGNED DEFAULT NULL,
  `repair_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `building_id` bigint(20) UNSIGNED NOT NULL,
  `floor_id` bigint(20) UNSIGNED NOT NULL,
  `area_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `edited_by` bigint(20) UNSIGNED DEFAULT NULL,
  `general_comments` longtext DEFAULT NULL,
  `final_comments` longtext DEFAULT NULL,
  `labour_hours` double NOT NULL COMMENT 'work order cannot be closed if this field is empty',
  `action_requested` longtext NOT NULL,
  `contractor_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`contractor_details`)),
  `additional_costs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`additional_costs`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `requester_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_orders`
--

INSERT INTO `work_orders` (`id`, `number`, `request_date`, `complete_date`, `wotype_id`, `wo_origin`, `zone_id`, `facility_id`, `time_type_id`, `trade_id`, `technician_id`, `task_id`, `task_type_id`, `status_id`, `priority_id`, `repair_center_id`, `vendor_id`, `building_id`, `floor_id`, `area_id`, `shift_id`, `created_by`, `edited_by`, `general_comments`, `final_comments`, `labour_hours`, `action_requested`, `contractor_details`, `additional_costs`, `created_at`, `updated_at`, `requester_id`) VALUES
(29, 'Facility1_100029', '2024-08-27 13:13:00', '2024-08-28 18:13:00', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, NULL, 1, 'gm', 'pm', 1213, 'do', '{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"}', '{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"}', '2024-08-28 04:27:01', '2024-08-28 04:27:01', 1),
(30, 'Facility1_100030', '2024-08-27 13:13:00', '2024-08-28 18:13:00', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, NULL, 1, 'gm', 'pm', 1213, 'do', '{\"contractor_cost\":\"12\",\"contractor_code\":\"32sd\"}', '{\"material_cost\":\"43\",\"total_hours\":\"23\",\"other_cost\":\"243\"}', '2024-08-28 04:28:01', '2024-08-28 04:28:01', 1);

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

--
-- Table structure for table `wotypes`
--

CREATE TABLE `wotypes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_pm` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wotypes`
--

INSERT INTO `wotypes` (`id`, `name`, `is_pm`, `created_at`, `updated_at`) VALUES
(1, 'wotype1', 1, '2024-08-17 08:08:44', '2024-08-17 08:08:44');

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

--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zones`
--

INSERT INTO `zones` (`id`, `code`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'MCK', 'MCK, CELINA, CHEC, FVC, PSTC', 1, '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(2, 'PLANO', 'PLANO, WC, SHC', 1, '2024-08-17 08:04:10', '2024-08-17 08:04:10'),
(3, 'FRISCO', 'FRISCO, ALLEN, CY', 1, '2024-08-17 08:04:10', '2024-08-17 08:04:10');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

--
-- Indexes for table `areas`
--
ALTER TABLE `areas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `areas_area_type_id_foreign` (`area_type_id`),
  ADD KEY `areas_floor_id_foreign` (`floor_id`),
  ADD KEY `areas_building_id_foreign` (`building_id`),
  ADD KEY `areas_zone_id_foreign` (`zone_id`),
  ADD KEY `areas_facility_id_foreign` (`facility_id`);

--
-- Indexes for table `area_types`
--
ALTER TABLE `area_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `buildings`
--
ALTER TABLE `buildings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `buildings_facility_id_foreign` (`facility_id`);

--
-- Indexes for table `facilities`
--
ALTER TABLE `facilities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `facilities_zone_id_foreign` (`zone_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `floors`
--
ALTER TABLE `floors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `floors_building_id_foreign` (`building_id`),
  ADD KEY `floors_zone_id_foreign` (`zone_id`),
  ADD KEY `floors_facility_id_foreign` (`facility_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_role_id_foreign` (`role_id`),
  ADD KEY `permission_role_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `pm_technician`
--
ALTER TABLE `pm_technician`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pm_technician_technician_id_foreign` (`technician_id`),
  ADD KEY `pm_technician_preventive_maintenance_id_foreign` (`preventive_maintenance_id`);

--
-- Indexes for table `preventive_maintenances`
--
ALTER TABLE `preventive_maintenances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `preventive_maintenances_wotype_id_foreign` (`wotype_id`),
  ADD KEY `preventive_maintenances_zone_id_foreign` (`zone_id`),
  ADD KEY `preventive_maintenances_facility_id_foreign` (`facility_id`),
  ADD KEY `preventive_maintenances_time_type_id_foreign` (`time_type_id`),
  ADD KEY `preventive_maintenances_trade_id_foreign` (`trade_id`),
  ADD KEY `preventive_maintenances_technician_id_foreign` (`technician_id`),
  ADD KEY `preventive_maintenances_task_id_foreign` (`task_id`),
  ADD KEY `preventive_maintenances_task_type_id_foreign` (`task_type_id`),
  ADD KEY `preventive_maintenances_status_id_foreign` (`status_id`),
  ADD KEY `preventive_maintenances_priority_id_foreign` (`priority_id`),
  ADD KEY `preventive_maintenances_repair_center_id_foreign` (`repair_center_id`),
  ADD KEY `preventive_maintenances_vendor_id_foreign` (`vendor_id`),
  ADD KEY `preventive_maintenances_building_id_foreign` (`building_id`),
  ADD KEY `preventive_maintenances_floor_id_foreign` (`floor_id`),
  ADD KEY `preventive_maintenances_area_id_foreign` (`area_id`),
  ADD KEY `preventive_maintenances_shift_id_foreign` (`shift_id`),
  ADD KEY `preventive_maintenances_created_by_foreign` (`created_by`),
  ADD KEY `preventive_maintenances_edited_by_foreign` (`edited_by`),
  ADD KEY `preventive_maintenances_requester_id_foreign` (`requester_id`);

--
-- Indexes for table `priorities`
--
ALTER TABLE `priorities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `p_m_instructions`
--
ALTER TABLE `p_m_instructions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `p_m_instructions_preventive_maintenance_id_foreign` (`preventive_maintenance_id`);

--
-- Indexes for table `repair_centers`
--
ALTER TABLE `repair_centers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `requesters`
--
ALTER TABLE `requesters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `scheduling_options_pms`
--
ALTER TABLE `scheduling_options_pms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `scheduling_options_pms_preventive_maintenance_id_foreign` (`preventive_maintenance_id`);

--
-- Indexes for table `shifts`
--
ALTER TABLE `shifts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tasks_task_type_id_foreign` (`task_type_id`);

--
-- Indexes for table `task_types`
--
ALTER TABLE `task_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `technicians`
--
ALTER TABLE `technicians`
  ADD PRIMARY KEY (`id`),
  ADD KEY `technicians_trade_id_foreign` (`trade_id`),
  ADD KEY `technicians_repair_center_id_foreign` (`repair_center_id`);

--
-- Indexes for table `technician_work_order`
--
ALTER TABLE `technician_work_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `technician_work_order_technician_id_foreign` (`technician_id`),
  ADD KEY `technician_work_order_work_order_id_foreign` (`work_order_id`);

--
-- Indexes for table `time_types`
--
ALTER TABLE `time_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `time_types_wotype_id_foreign` (`wotype_id`);

--
-- Indexes for table `trades`
--
ALTER TABLE `trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trades_repair_center_id_foreign` (`repair_center_id`);

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `work_orders`
--
ALTER TABLE `work_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `work_orders_wotype_id_foreign` (`wotype_id`),
  ADD KEY `work_orders_zone_id_foreign` (`zone_id`),
  ADD KEY `work_orders_time_type_id_foreign` (`time_type_id`),
  ADD KEY `work_orders_trade_id_foreign` (`trade_id`),
  ADD KEY `work_orders_technician_id_foreign` (`technician_id`),
  ADD KEY `work_orders_task_id_foreign` (`task_id`),
  ADD KEY `work_orders_task_type_id_foreign` (`task_type_id`),
  ADD KEY `work_orders_status_id_foreign` (`status_id`),
  ADD KEY `work_orders_prioritiy_id_foreign` (`priority_id`),
  ADD KEY `work_orders_repair_center_id_foreign` (`repair_center_id`),
  ADD KEY `work_orders_vendor_id_foreign` (`vendor_id`),
  ADD KEY `work_orders_building_id_foreign` (`building_id`),
  ADD KEY `work_orders_floor_id_foreign` (`floor_id`),
  ADD KEY `work_orders_area_id_foreign` (`area_id`),
  ADD KEY `work_orders_shift_id_foreign` (`shift_id`),
  ADD KEY `work_orders_created_by_foreign` (`created_by`),
  ADD KEY `work_orders_edited_by_foreign` (`edited_by`);

--
-- Indexes for table `wotypes`
--
ALTER TABLE `wotypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zones`
--
ALTER TABLE `zones`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `areas`
--
ALTER TABLE `areas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `area_types`
--
ALTER TABLE `area_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `buildings`
--
ALTER TABLE `buildings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `facilities`
--
ALTER TABLE `facilities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `floors`
--
ALTER TABLE `floors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `permission_role`
--
ALTER TABLE `permission_role`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `pm_technician`
--
ALTER TABLE `pm_technician`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `preventive_maintenances`
--
ALTER TABLE `preventive_maintenances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `priorities`
--
ALTER TABLE `priorities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `p_m_instructions`
--
ALTER TABLE `p_m_instructions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `repair_centers`
--
ALTER TABLE `repair_centers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `requesters`
--
ALTER TABLE `requesters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `scheduling_options_pms`
--
ALTER TABLE `scheduling_options_pms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `shifts`
--
ALTER TABLE `shifts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `task_types`
--
ALTER TABLE `task_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `technicians`
--
ALTER TABLE `technicians`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `technician_work_order`
--
ALTER TABLE `technician_work_order`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `time_types`
--
ALTER TABLE `time_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `trades`
--
ALTER TABLE `trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `work_orders`
--
ALTER TABLE `work_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `wotypes`
--
ALTER TABLE `wotypes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `zones`
--
ALTER TABLE `zones`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `areas`
--
ALTER TABLE `areas`
  ADD CONSTRAINT `areas_area_type_id_foreign` FOREIGN KEY (`area_type_id`) REFERENCES `area_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `areas_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `areas_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `areas_floor_id_foreign` FOREIGN KEY (`floor_id`) REFERENCES `floors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `areas_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `buildings`
--
ALTER TABLE `buildings`
  ADD CONSTRAINT `buildings_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `facilities`
--
ALTER TABLE `facilities`
  ADD CONSTRAINT `facilities_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `floors`
--
ALTER TABLE `floors`
  ADD CONSTRAINT `floors_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `floors_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `floors_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pm_technician`
--
ALTER TABLE `pm_technician`
  ADD CONSTRAINT `pm_technician_preventive_maintenance_id_foreign` FOREIGN KEY (`preventive_maintenance_id`) REFERENCES `preventive_maintenances` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pm_technician_technician_id_foreign` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `preventive_maintenances`
--
ALTER TABLE `preventive_maintenances`
  ADD CONSTRAINT `preventive_maintenances_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_edited_by_foreign` FOREIGN KEY (`edited_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_floor_id_foreign` FOREIGN KEY (`floor_id`) REFERENCES `floors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_priority_id_foreign` FOREIGN KEY (`priority_id`) REFERENCES `priorities` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_repair_center_id_foreign` FOREIGN KEY (`repair_center_id`) REFERENCES `repair_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_requester_id_foreign` FOREIGN KEY (`requester_id`) REFERENCES `requesters` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_shift_id_foreign` FOREIGN KEY (`shift_id`) REFERENCES `shifts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_task_type_id_foreign` FOREIGN KEY (`task_type_id`) REFERENCES `task_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_technician_id_foreign` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_time_type_id_foreign` FOREIGN KEY (`time_type_id`) REFERENCES `time_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_trade_id_foreign` FOREIGN KEY (`trade_id`) REFERENCES `trades` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `preventive_maintenances_wotype_id_foreign` FOREIGN KEY (`wotype_id`) REFERENCES `wotypes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `preventive_maintenances_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `p_m_instructions`
--
ALTER TABLE `p_m_instructions`
  ADD CONSTRAINT `p_m_instructions_preventive_maintenance_id_foreign` FOREIGN KEY (`preventive_maintenance_id`) REFERENCES `preventive_maintenances` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `scheduling_options_pms`
--
ALTER TABLE `scheduling_options_pms`
  ADD CONSTRAINT `scheduling_options_pms_preventive_maintenance_id_foreign` FOREIGN KEY (`preventive_maintenance_id`) REFERENCES `preventive_maintenances` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_task_type_id_foreign` FOREIGN KEY (`task_type_id`) REFERENCES `task_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `technicians`
--
ALTER TABLE `technicians`
  ADD CONSTRAINT `technicians_repair_center_id_foreign` FOREIGN KEY (`repair_center_id`) REFERENCES `repair_centers` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `technicians_trade_id_foreign` FOREIGN KEY (`trade_id`) REFERENCES `trades` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `technician_work_order`
--
ALTER TABLE `technician_work_order`
  ADD CONSTRAINT `technician_work_order_technician_id_foreign` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `technician_work_order_work_order_id_foreign` FOREIGN KEY (`work_order_id`) REFERENCES `work_orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `time_types`
--
ALTER TABLE `time_types`
  ADD CONSTRAINT `time_types_wotype_id_foreign` FOREIGN KEY (`wotype_id`) REFERENCES `wotypes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trades`
--
ALTER TABLE `trades`
  ADD CONSTRAINT `trades_repair_center_id_foreign` FOREIGN KEY (`repair_center_id`) REFERENCES `repair_centers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `work_orders`
--
ALTER TABLE `work_orders`
  ADD CONSTRAINT `work_orders_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_edited_by_foreign` FOREIGN KEY (`edited_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_floor_id_foreign` FOREIGN KEY (`floor_id`) REFERENCES `floors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_prioritiy_id_foreign` FOREIGN KEY (`priority_id`) REFERENCES `priorities` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_repair_center_id_foreign` FOREIGN KEY (`repair_center_id`) REFERENCES `repair_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_shift_id_foreign` FOREIGN KEY (`shift_id`) REFERENCES `shifts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_task_type_id_foreign` FOREIGN KEY (`task_type_id`) REFERENCES `task_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_technician_id_foreign` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_time_type_id_foreign` FOREIGN KEY (`time_type_id`) REFERENCES `time_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_trade_id_foreign` FOREIGN KEY (`trade_id`) REFERENCES `trades` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_orders_wotype_id_foreign` FOREIGN KEY (`wotype_id`) REFERENCES `wotypes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_orders_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;
COMMIT;

