-- Table structure for table `member_evaluation_header`
--

CREATE TABLE `member_evaluation_header` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `evaluation_id` int(11) NOT NULL,
  `evaluation_type` varchar(100) NOT NULL DEFAULT 'Self',
  `leader_name` varchar(250) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `date_time_started` datetime DEFAULT NULL,
  `date_time_ended` datetime DEFAULT NULL,
  `status_id` 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 `member_evaluation_header`
--

INSERT INTO `member_evaluation_header` (`id`, `member_id`, `evaluation_id`, `evaluation_type`, `leader_name`, `role_id`, `date_time_started`, `date_time_ended`, `status_id`, `created_at`, `updated_at`) VALUES
(1, 4, 1, 'Self', NULL, NULL, '2022-08-04 21:02:59', NULL, 2, '2022-08-04 15:32:59', '2023-02-08 13:13:17'),
(2, 5, 2, 'Self', NULL, NULL, '2022-08-05 03:06:08', NULL, 2, '2022-08-04 21:36:08', '2022-08-04 21:37:40'),
(3, 7, 3, 'Self', NULL, NULL, '2022-08-05 15:54:59', NULL, 1, '2022-08-05 10:24:59', '2022-08-05 10:24:59'),
(4, 8, 4, 'Self', NULL, NULL, '2022-08-06 00:20:38', NULL, 1, '2022-08-05 18:50:38', '2022-08-05 18:50:38'),
(5, 9, 5, 'Self', NULL, NULL, '2022-08-07 16:52:58', NULL, 2, '2022-08-07 11:22:58', '2022-08-07 11:24:50'),
(6, 10, 6, 'Self', NULL, NULL, '2022-08-07 17:23:04', NULL, 2, '2022-08-07 11:53:04', '2022-08-07 11:54:39'),
(7, 11, 7, 'Self', NULL, NULL, '2022-08-08 00:41:23', NULL, 2, '2022-08-07 19:11:23', '2022-08-07 19:12:57'),
(8, 12, 8, 'Self', NULL, NULL, '2022-08-08 04:33:48', NULL, 2, '2022-08-07 23:03:48', '2022-08-07 23:05:23'),
(9, 13, 9, 'Self', NULL, NULL, '2022-08-08 05:36:35', NULL, 1, '2022-08-08 00:06:35', '2022-08-08 00:06:35'),
(10, 14, 10, 'Self', NULL, NULL, '2022-08-09 00:25:31', NULL, 2, '2022-08-08 18:55:31', '2022-08-08 18:57:02'),
(11, 16, 11, 'Self', NULL, NULL, '2022-08-09 23:44:20', NULL, 2, '2022-08-09 18:14:20', '2022-08-09 18:15:33'),
(12, 18, 12, 'Self', NULL, NULL, '2022-08-10 01:33:14', NULL, 2, '2022-08-09 20:03:14', '2022-08-09 20:04:47'),
(13, 18, 13, 'Self', NULL, NULL, '2022-08-10 01:35:35', NULL, 1, '2022-08-09 20:05:35', '2022-08-09 20:05:35'),
(14, 19, 14, 'Self', NULL, NULL, '2022-08-10 01:45:35', NULL, 2, '2022-08-09 20:15:35', '2022-08-09 20:17:03'),
(15, 20, 15, 'Self', NULL, NULL, '2022-08-11 00:48:46', NULL, 2, '2022-08-10 19:18:46', '2022-08-10 19:20:06'),
(16, 21, 16, 'Self', NULL, NULL, '2022-08-11 03:08:09', NULL, 2, '2022-08-10 21:38:09', '2022-08-10 21:39:38'),
(17, 22, 17, 'Self', NULL, NULL, '2022-08-11 04:34:25', NULL, 2, '2022-08-10 23:04:25', '2022-08-10 23:06:12'),
(18, 23, 18, 'Self', NULL, NULL, '2022-08-11 07:16:47', NULL, 2, '2022-08-11 01:46:47', '2022-08-11 01:47:54'),
(19, 24, 19, 'Self', NULL, NULL, '2022-08-11 12:59:16', NULL, 1, '2022-08-11 07:29:16', '2022-08-11 07:29:16'),
(20, 25, 20, 'Self', NULL, NULL, '2022-08-12 00:44:53', NULL, 2, '2022-08-11 19:14:53', '2022-08-11 19:16:19'),
(21, 26, 21, 'Self', NULL, NULL, '2022-08-12 03:19:27', NULL, 2, '2022-08-11 21:49:27', '2022-08-11 22:10:24'),
(22, 27, 22, 'Self', NULL, NULL, '2022-08-12 03:44:00', NULL, 1, '2022-08-11 22:14:00', '2022-08-11 22:14:00'),
(23, 28, 23, 'Self', NULL, NULL, '2022-08-13 02:49:49', NULL, 2, '2022-08-12 21:19:49', '2022-08-12 21:21:14'),
(24, 29, 24, 'Self', NULL, NULL, '2022-08-13 03:24:01', NULL, 2, '2022-08-12 21:54:01', '2022-08-12 21:55:30'),
(25, 31, 25, 'Self', NULL, NULL, '2022-08-15 01:55:46', NULL, 2, '2022-08-14 20:25:46', '2022-08-14 20:26:59'),
(26, 32, 26, 'Self', NULL, NULL, '2022-08-17 16:21:01', NULL, 2, '2022-08-17 10:51:01', '2022-08-17 10:52:13'),
(27, 33, 27, 'Self', NULL, NULL, '2022-08-18 11:18:27', NULL, 2, '2022-08-18 05:48:27', '2022-08-18 05:49:53'),
(28, 34, 28, 'Self', NULL, NULL, '2022-08-22 01:26:08', NULL, 2, '2022-08-21 19:56:08', '2022-08-21 19:57:19'),
(29, 35, 29, 'Self', NULL, NULL, '2022-08-22 05:37:48', NULL, 2, '2022-08-22 00:07:48', '2022-08-22 00:08:55'),
(30, 36, 30, 'Self', NULL, NULL, '2022-08-26 01:46:40', NULL, 2, '2022-08-25 20:16:40', '2022-08-25 20:17:40'),
(31, 37, 31, 'Self', NULL, NULL, '2022-08-28 05:36:45', NULL, 2, '2022-08-28 00:06:45', '2022-08-28 00:08:11'),
(32, 38, 32, 'Self', NULL, NULL, '2022-08-28 05:52:19', NULL, 2, '2022-08-28 00:22:19', '2022-08-28 00:23:30'),
(33, 39, 33, 'Self', NULL, NULL, '2022-08-28 06:06:33', NULL, 2, '2022-08-28 00:36:33', '2022-08-28 00:37:56'),
(34, 40, 34, 'Self', NULL, NULL, '2022-08-28 06:37:09', NULL, 2, '2022-08-28 01:07:09', '2022-08-28 01:09:44'),
(35, 41, 35, 'Self', NULL, NULL, '2022-08-29 01:50:05', NULL, 2, '2022-08-28 20:20:05', '2022-08-28 20:21:12'),
(36, 42, 36, 'Self', NULL, NULL, '2022-09-01 01:14:09', NULL, 1, '2022-08-31 19:44:09', '2022-08-31 19:44:09'),
(37, 44, 37, 'Self', NULL, NULL, '2022-09-04 02:28:17', NULL, 2, '2022-09-03 20:58:17', '2022-09-03 20:59:43'),
(38, 45, 38, 'Self', NULL, NULL, '2022-09-18 16:36:09', NULL, 2, '2022-09-18 11:06:09', '2022-09-18 11:07:20'),
(39, 46, 39, 'Self', NULL, NULL, '2022-09-18 17:11:17', NULL, 2, '2022-09-18 11:41:17', '2022-09-18 11:43:55'),
(40, 46, 40, 'Self', NULL, NULL, '2022-09-18 17:28:11', NULL, 1, '2022-09-18 11:58:11', '2022-09-18 11:58:11'),
(41, 47, 41, 'Self', NULL, NULL, '2022-09-19 02:50:36', NULL, 2, '2022-09-18 21:20:36', '2022-09-18 21:21:30'),
(42, 47, 42, 'Self', NULL, NULL, '2022-09-19 02:52:09', NULL, 2, '2022-09-18 21:22:09', '2022-09-18 21:43:09'),
(43, 48, 43, 'Self', NULL, NULL, '2022-09-24 13:45:17', NULL, 2, '2022-09-24 08:15:17', '2022-09-24 08:16:25'),
(44, 48, 44, 'Self', NULL, NULL, '2022-09-24 13:46:48', NULL, 1, '2022-09-24 08:16:48', '2022-09-24 08:16:48'),
(45, 49, 45, 'Self', NULL, NULL, '2022-09-25 05:10:58', NULL, 2, '2022-09-24 23:40:58', '2022-09-24 23:44:24'),
(46, 49, 46, 'Self', NULL, NULL, '2022-09-25 05:15:26', NULL, 1, '2022-09-24 23:45:26', '2022-09-24 23:45:26'),
(47, 50, 47, 'Self', NULL, NULL, '2022-11-01 10:07:09', NULL, 2, '2022-11-01 04:37:09', '2022-11-01 04:38:05'),
(48, 51, 48, 'Self', NULL, NULL, '2022-11-09 05:47:30', NULL, 2, '2022-11-09 00:17:30', '2022-11-09 00:19:53'),
(49, 52, 49, 'Self', NULL, NULL, '2022-11-09 05:55:06', NULL, 1, '2022-11-09 00:25:06', '2022-11-09 00:25:06'),
(50, 53, 50, 'Self', NULL, NULL, '2022-11-10 14:12:53', NULL, 2, '2022-11-10 08:42:53', '2022-11-10 08:44:02'),
(51, 54, 51, 'Self', NULL, NULL, '2022-11-10 23:39:36', NULL, 2, '2022-11-10 18:09:36', '2022-11-10 18:10:38'),
(52, 55, 52, 'Self', NULL, NULL, '2022-11-11 00:18:35', NULL, 2, '2022-11-10 18:48:35', '2022-11-10 18:50:00'),
(53, 56, 53, 'Self', NULL, NULL, '2022-11-11 04:18:30', NULL, 2, '2022-11-10 22:48:30', '2022-11-10 22:50:57'),
(54, 58, 54, 'Self', NULL, NULL, '2022-11-11 06:36:35', NULL, 2, '2022-11-11 01:06:35', '2022-11-11 01:07:33'),
(55, 59, 55, 'Self', NULL, NULL, '2022-11-11 06:54:24', NULL, 2, '2022-11-11 01:24:24', '2022-11-11 01:25:34'),
(56, 60, 56, 'Self', NULL, NULL, '2022-11-11 16:27:24', NULL, 1, '2022-11-11 10:57:24', '2022-11-11 10:57:24'),
(57, 61, 57, 'Self', NULL, NULL, '2022-11-14 08:12:05', NULL, 2, '2022-11-14 02:42:05', '2022-11-14 02:47:52'),
(58, 62, 58, 'Self', NULL, NULL, '2022-11-14 08:27:10', NULL, 2, '2022-11-14 02:57:10', '2022-11-14 02:58:28'),
(59, 63, 59, 'Self', NULL, NULL, '2022-11-16 15:04:46', NULL, 2, '2022-11-16 09:34:46', '2022-11-16 09:36:10'),
(60, 64, 60, 'Self', NULL, NULL, '2022-11-18 00:46:25', NULL, 2, '2022-11-17 19:16:25', '2022-11-17 19:22:00'),
(61, 65, 61, 'Self', NULL, NULL, '2022-11-18 03:09:02', NULL, 1, '2022-11-17 21:39:02', '2022-11-17 21:39:02'),
(62, 66, 62, 'Self', NULL, NULL, '2022-11-18 07:02:50', NULL, 2, '2022-11-18 01:32:50', '2022-11-18 01:33:56'),
(63, 67, 63, 'Self', NULL, NULL, '2022-11-19 08:03:52', NULL, 2, '2022-11-19 02:33:52', '2022-11-19 02:52:46'),
(64, 68, 64, 'Self', NULL, NULL, '2022-11-20 01:31:41', NULL, 1, '2022-11-19 20:01:41', '2022-11-19 20:01:41'),
(65, 69, 65, 'Self', NULL, NULL, '2022-11-21 00:00:04', NULL, 2, '2022-11-20 18:30:04', '2022-11-20 18:31:22'),
(66, 70, 66, 'Self', NULL, NULL, '2022-11-21 11:46:58', NULL, 2, '2022-11-21 06:16:58', '2022-11-21 06:18:40'),
(67, 71, 67, 'Self', NULL, NULL, '2022-11-22 00:35:16', NULL, 2, '2022-11-21 19:05:16', '2022-11-21 19:06:11'),
(68, 71, 68, 'Self', NULL, NULL, '2022-11-22 00:36:51', NULL, 1, '2022-11-21 19:06:51', '2022-11-21 19:06:51'),
(69, 72, 69, 'Self', NULL, NULL, '2022-11-23 12:45:22', NULL, 2, '2022-11-23 07:15:22', '2022-11-23 07:17:39'),
(70, 73, 70, 'Self', NULL, NULL, '2022-11-24 00:55:37', NULL, 2, '2022-11-23 19:25:37', '2022-11-23 19:26:54'),
(71, 74, 71, 'Self', NULL, NULL, '2022-11-26 06:38:10', NULL, 2, '2022-11-26 01:08:10', '2022-11-26 01:09:04'),
(72, 75, 72, 'Self', NULL, NULL, '2022-11-26 07:19:01', NULL, 2, '2022-11-26 01:49:01', '2022-11-26 01:50:32'),
(73, 75, 73, 'Self', NULL, NULL, '2022-11-26 07:26:12', NULL, 1, '2022-11-26 01:56:12', '2022-11-26 01:56:12'),
(74, 76, 74, 'Self', NULL, NULL, '2022-11-28 04:25:41', NULL, 2, '2022-11-27 22:55:41', '2022-11-27 22:58:14'),
(75, 77, 75, 'Self', NULL, NULL, '2022-11-29 13:21:22', NULL, 1, '2022-11-29 07:51:22', '2022-11-29 07:51:22'),
(76, 78, 76, 'Self', NULL, NULL, '2022-11-30 00:03:41', NULL, 2, '2022-11-29 18:33:41', '2022-11-29 18:35:33'),
(77, 79, 77, 'Self', NULL, NULL, '2022-12-01 00:35:33', NULL, 2, '2022-11-30 19:05:33', '2022-11-30 19:07:33'),
(78, 80, 78, 'Self', NULL, NULL, '2022-12-03 12:13:25', NULL, 2, '2022-12-03 06:43:25', '2022-12-03 06:45:28'),
(79, 81, 79, 'Self', NULL, NULL, '2022-12-05 12:07:12', NULL, 1, '2022-12-05 06:37:12', '2022-12-05 06:37:12'),
(80, 82, 80, 'Self', NULL, NULL, '2022-12-05 12:09:18', NULL, 2, '2022-12-05 06:39:18', '2022-12-05 06:43:31'),
(81, 83, 81, 'Self', NULL, NULL, '2022-12-13 06:12:21', NULL, 1, '2022-12-13 00:42:21', '2022-12-13 00:42:21'),
(82, 84, 82, 'Self', NULL, NULL, '2022-12-13 06:14:07', NULL, 1, '2022-12-13 00:44:07', '2022-12-13 00:44:07'),
(83, 86, 83, 'Self', NULL, NULL, '2022-12-13 10:56:00', NULL, 1, '2022-12-13 05:26:00', '2022-12-13 05:26:00'),
(84, 72, 84, 'Self', NULL, NULL, '2022-12-14 06:51:25', NULL, 2, '2022-12-14 01:21:25', '2023-02-08 04:08:30'),
(85, 87, 85, 'Self', NULL, NULL, '2022-12-15 00:48:19', NULL, 2, '2022-12-14 19:18:19', '2022-12-14 19:21:03'),
(86, 88, 86, 'Self', NULL, NULL, '2022-12-16 00:40:23', NULL, 2, '2022-12-15 19:10:23', '2022-12-15 19:11:49'),
(87, 89, 87, 'Self', NULL, NULL, '2022-12-16 00:51:40', NULL, 2, '2022-12-15 19:21:40', '2022-12-15 19:22:29'),
(88, 90, 88, 'Self', NULL, NULL, '2022-12-19 14:08:50', NULL, 1, '2022-12-19 08:38:50', '2022-12-19 08:38:50'),
(89, 93, 89, 'Self', NULL, NULL, '2023-01-03 00:15:36', NULL, 2, '2023-01-02 18:45:36', '2023-01-02 18:46:58'),
(90, 94, 90, 'Self', NULL, NULL, '2023-01-26 15:25:19', NULL, 2, '2023-01-26 09:55:19', '2023-01-26 09:56:43'),
(91, 95, 91, 'Self', NULL, NULL, '2023-01-27 06:10:16', NULL, 1, '2023-01-27 00:40:16', '2023-01-27 00:40:16'),
(92, 96, 92, 'Self', NULL, NULL, '2023-01-27 12:38:04', NULL, 1, '2023-01-27 07:08:04', '2023-01-27 07:08:04'),
(93, 97, 93, 'Self', NULL, NULL, '2023-01-27 17:42:46', NULL, 1, '2023-01-27 12:12:46', '2023-01-27 12:12:46'),
(94, 98, 94, 'Self', NULL, NULL, '2023-01-28 00:18:03', NULL, 2, '2023-01-27 18:48:03', '2023-01-27 18:49:24'),
(95, 99, 95, 'Self', NULL, NULL, '2023-01-28 00:26:39', NULL, 1, '2023-01-27 18:56:39', '2023-01-27 18:56:39'),
(96, 100, 96, 'Self', NULL, NULL, '2023-01-28 00:31:45', NULL, 2, '2023-01-27 19:01:45', '2023-01-27 19:03:29'),
(97, 101, 97, 'Self', NULL, NULL, '2023-01-28 01:28:57', NULL, 2, '2023-01-27 19:58:57', '2023-01-27 20:00:08'),
(98, 102, 98, 'Self', NULL, NULL, '2023-01-29 08:14:23', NULL, 1, '2023-01-29 02:44:23', '2023-01-29 02:44:23'),
(99, 103, 99, 'Self', NULL, NULL, '2023-02-01 18:58:56', NULL, 1, '2023-02-01 13:28:56', '2023-02-01 13:28:56'),
(100, 72, 100, 'Self', NULL, NULL, '2023-02-08 23:46:49', NULL, 2, '2023-02-08 18:16:49', '2023-02-08 18:18:26'),
(101, 104, 101, 'Self', NULL, NULL, '2023-02-09 00:06:22', NULL, 2, '2023-02-08 18:36:22', '2023-02-08 18:42:54'),
(102, 105, 102, 'Self', NULL, NULL, '2023-02-09 00:17:45', NULL, 1, '2023-02-08 18:47:45', '2023-02-08 18:47:45'),
(103, 106, 103, 'Self', NULL, NULL, '2023-02-09 00:23:10', NULL, 2, '2023-02-08 18:53:10', '2023-02-08 18:54:10'),
(104, 107, 104, 'Self', NULL, NULL, '2023-02-09 00:27:06', NULL, 2, '2023-02-08 18:57:06', '2023-02-08 18:58:20'),
(105, 108, 105, 'Self', NULL, NULL, '2023-02-09 00:30:25', NULL, 2, '2023-02-08 19:00:25', '2023-02-08 19:01:39'),
(106, 109, 106, 'Self', NULL, NULL, '2023-02-09 04:43:37', NULL, 2, '2023-02-08 23:13:37', '2023-02-08 23:16:41'),
(107, 110, 107, 'Self', NULL, NULL, '2023-02-09 04:51:12', NULL, 2, '2023-02-08 23:21:12', '2023-02-08 23:22:06'),
(108, 4, 108, 'Self', NULL, NULL, '2023-02-09 05:33:16', NULL, 1, '2023-02-09 00:03:16', '2023-02-09 00:03:16'),
(109, 72, 109, 'Self', NULL, NULL, '2023-02-09 05:45:56', NULL, 2, '2023-02-09 00:15:56', '2023-02-09 00:18:38'),
(110, 72, 110, 'Self', NULL, NULL, '2023-02-09 05:50:54', NULL, 2, '2023-02-09 00:20:54', '2023-02-09 00:22:20'),
(111, 94, 111, 'Self', NULL, NULL, '2023-02-09 06:00:43', NULL, 2, '2023-02-09 00:30:43', '2023-02-09 00:32:36'),
(112, 111, 112, 'Self', NULL, NULL, '2023-02-09 08:37:40', NULL, 2, '2023-02-09 03:07:40', '2023-02-09 03:08:45'),
(113, 112, 113, 'Self', NULL, NULL, '2023-02-09 09:45:34', NULL, 2, '2023-02-09 04:15:34', '2023-02-09 04:18:20'),
(114, 113, 114, 'Self', NULL, NULL, '2023-02-10 00:20:32', NULL, 2, '2023-02-09 18:50:32', '2023-02-09 18:51:55'),
(115, 114, 115, 'Self', NULL, NULL, '2023-02-10 15:02:12', NULL, 2, '2023-02-10 09:32:12', '2023-02-10 09:34:03'),
(116, 114, 116, 'Self', NULL, NULL, '2023-02-10 15:16:16', NULL, 1, '2023-02-10 09:46:16', '2023-02-10 09:46:16'),
(117, 115, 117, 'Self', NULL, NULL, '2023-02-16 00:05:03', NULL, 2, '2023-02-15 18:35:03', '2023-02-15 18:36:19'),
(118, 72, 118, 'Self', NULL, NULL, '2023-03-10 06:33:02', NULL, 2, '2023-03-10 01:03:02', '2023-03-10 01:05:15'),
(119, 72, 119, 'Self', NULL, NULL, '2023-03-10 11:52:56', NULL, 2, '2023-03-10 06:22:56', '2023-03-19 18:28:55'),
(120, 116, 120, 'Self', NULL, NULL, '2023-03-11 03:02:32', NULL, 2, '2023-03-10 21:32:32', '2023-03-10 21:34:34'),
(122, 69, 121, 'Self', NULL, NULL, '2023-04-13 00:02:42', NULL, 2, '2023-04-12 18:32:42', '2023-04-12 18:41:24'),
(123, 69, 122, 'Self', NULL, NULL, '2023-04-13 04:43:39', NULL, 2, '2023-04-12 23:13:39', '2023-04-12 23:18:02'),
(124, 69, 123, 'Self', NULL, NULL, '2023-04-22 05:58:39', NULL, 2, '2023-04-22 00:28:39', '2023-04-26 18:37:06'),
(125, 69, 125, 'Leader', 'Sanil', NULL, '2023-04-26 03:34:02', NULL, 2, '2023-04-25 22:04:02', '2023-04-25 22:05:49'),
(126, 69, 126, 'Leader', 'Sanil Nair', NULL, '2023-04-27 00:18:38', NULL, 1, '2023-04-26 18:48:38', '2023-04-26 18:48:38'),
(127, 69, 127, 'Leader', 'Sanil1', NULL, '2023-04-27 00:19:35', NULL, 1, '2023-04-26 18:49:35', '2023-04-26 18:49:35'),
(128, 69, 128, 'Leader', 'Sanil2', NULL, '2023-04-27 00:30:36', NULL, 1, '2023-04-26 19:00:36', '2023-04-26 19:00:36'),
(129, 69, 129, 'Self', NULL, NULL, '2023-04-27 09:18:18', NULL, 1, '2023-04-27 03:48:18', '2023-04-27 03:48:18'),
(130, 69, 130, 'Leader', 'Sanil3', NULL, '2023-04-27 09:21:30', NULL, 2, '2023-04-27 03:51:30', '2023-04-27 23:14:07'),
(131, 118, 131, 'Self', NULL, NULL, '2023-05-02 06:46:21', NULL, 1, '2023-05-02 01:16:21', '2023-05-02 01:16:21'),
(132, 119, 132, 'Self', NULL, NULL, '2023-07-14 01:04:21', NULL, 2, '2023-07-13 19:34:21', '2023-07-13 19:35:52'),
(133, 120, 133, 'Self', NULL, NULL, '2023-10-17 10:43:09', NULL, 2, '2023-10-17 05:13:09', '2023-10-17 05:15:00');

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

--
-- 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, '2021_09_12_170322_create_role_table', 1),
(6, '2021_09_13_013734_create_focus_area_table', 1),
(7, '2021_09_13_015044_create_focus_area_accountabilities_table', 1),
(8, '2021_09_13_040057_create_fa_acc_maturity_level_table', 1),
(9, '2021_09_13_102424_create_member_evaluation_header_table', 1),
(10, '2021_09_13_102438_create_member_evaluation_child_table', 1);

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

--
-- Table structure for table `objectives`
--

CREATE TABLE `objectives` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `objectives` varchar(255) DEFAULT NULL,
  `goals` 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 `objectives`
--

INSERT INTO `objectives` (`id`, `member_id`, `objectives`, `goals`, `created_at`, `updated_at`) VALUES
(1, 4, '<p><span style=\"color: rgb(230, 0, 0);\"><span class=\"ql-cursor\">﻿</span></span>HR Business Alignment <strong>OGSM</strong></p>', '<p>HR Business Alignment <strong style=\"color: rgb(230, 0, 0);\">OGSM</strong></p>', '2023-05-17 07:38:15', '2023-05-18 12:17:20'),
(4, 69, '<p>Grow? Global Brand Equity in the Silver OEM Market</p>', '<p>- Price premium over competition from x to y</p><p>- Product Design</p><p>- Customer Satisfaction</p><p>- Global sales revenue</p><p>- Average transaction value</p><p>- Customer lifetime value</p><p>- Rate of sustained growth</p>', '2023-05-22 18:51:23', '2023-05-22 18:51:23'),
(5, 4, '<p>HR Business Alignment <strong>OGSM1</strong></p>', '<p>HR Business Alignment <strong>OGSM1</strong></p>', '2023-05-22 20:36:52', '2023-05-22 20:36:52'),
(6, 4, '<p>Objectives</p>', '<p>Goals</p>', '2023-05-22 20:48:02', '2023-05-22 20:48:02');

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

--
-- Table structure for table `ogsm`
--

CREATE TABLE `ogsm` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `leader` 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 `ogsm`
--

INSERT INTO `ogsm` (`id`, `member_id`, `title`, `leader`, `created_at`, `updated_at`) VALUES
(1, 4, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley', 'Finance Manager', '2023-05-18 01:53:21', '2023-05-18 01:57:17'),
(2, 69, 'Globally Recognised Best-In-Class One-Stop OEM Jewelry Manufacturer\nFinancial Target/Aim: 2019 US$ 9M to 2025 - US$ 14M Revenue', 'Level 2', '2023-05-18 02:09:29', '2023-05-18 21:35:46'),
(3, 120, NULL, NULL, '2023-10-17 05:20:54', '2023-10-17 05:20:54');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_details`
--

CREATE TABLE `payment_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `intent_id` varchar(255) NOT NULL,
  `request_id` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `merchant_order_id` varchar(255) NOT NULL,
  `descriptor` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `intent_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`intent_details`)),
  `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 `payment_details`
--

INSERT INTO `payment_details` (`id`, `member_id`, `intent_id`, `request_id`, `amount`, `currency`, `merchant_order_id`, `descriptor`, `status`, `intent_details`, `created_at`, `updated_at`) VALUES
(1, 94, 'int_hkdm7fvnmghnk8q8n53', '20230126202333263996', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdm7fvnmghnk8q8n53\",\"request_id\":\"20230126202333263996\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm95vnlghnk99crhy_8q8n53\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"03\",\"expiry_year\":\"2026\",\"name\":\"demo\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6zcwgghnk9cmtqn\",\"status\":\"CREATED\",\"created_at\":\"2023-01-26T20:24:06+0000\",\"updated_at\":\"2023-01-26T20:24:06+0000\"},\"payment_intent_id\":\"int_hkdm7fvnmghnk8q8n53\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"997432707001_407356174887998\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"632096\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-26T20:24:06+0000\",\"updated_at\":\"2023-01-26T20:24:11+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"147f90db-8b24-436f-90ab-0c9e3a3bb2c6\",\"ip_address\":\"49.15.138.17\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"firefox\",\"ip_network_address\":\"49.15.138.17\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"31\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-26T20:23:34+0000\",\"updated_at\":\"2023-01-26T20:24:11+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ3NjQ2NTEsImV4cCI6MTY3NDc2ODI1MSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG03ZnZubWdobms4cThuNTMiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.KuJWfxm4KdX5xXeq61eF5IYMPN_5zXEVC08NNyQrdjU\",\"base_amount\":100}', '2023-01-26 14:54:12', '2023-01-26 14:54:12'),
(2, 95, 'int_hkdmvxtglgho0fk2jxw', '20230127061054469567', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmvxtglgho0fk2jxw\",\"request_id\":\"20230127061054469567\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm95vnlgho0h1tjlo_fk2jxw\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2027\",\"name\":\"Testing\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmldwgpgho0h52k4a\",\"status\":\"CREATED\",\"created_at\":\"2023-01-27T06:12:26+0000\",\"updated_at\":\"2023-01-27T06:12:26+0000\"},\"payment_intent_id\":\"int_hkdmvxtglgho0fk2jxw\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"740666681164_295442256851244\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"457914\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-27T06:12:26+0000\",\"updated_at\":\"2023-01-27T06:12:31+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"3290dd10-9b57-48cc-9859-382c06604224\",\"ip_address\":\"5.62.43.237\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"5.62.43.237\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-27T06:10:55+0000\",\"updated_at\":\"2023-01-27T06:12:31+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ3OTk5NTEsImV4cCI6MTY3NDgwMzU1MSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG12eHRnbGdobzBmazJqeHciLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.5_y7nCj9IdcZgUWCgjNOE7PcbBmExC1r-wWwsMuAOGA\",\"base_amount\":100}', '2023-01-27 00:42:31', '2023-01-27 00:42:31'),
(3, 72, 'int_hkdm95vnlgho0p0nqp9', '20230127062026747114', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdm95vnlgho0p0nqp9\",\"request_id\":\"20230127062026747114\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmvxtglgho0ppwsta_p0nqp9\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2023\",\"name\":\"Testing\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmldwgpgho0psnt3w\",\"status\":\"CREATED\",\"created_at\":\"2023-01-27T06:21:10+0000\",\"updated_at\":\"2023-01-27T06:21:10+0000\"},\"payment_intent_id\":\"int_hkdm95vnlgho0p0nqp9\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"724108312088_236677246490077\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"863181\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-27T06:21:10+0000\",\"updated_at\":\"2023-01-27T06:21:14+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"eb51a224-7343-4aaa-976c-a6e6e540889c\",\"ip_address\":\"5.62.43.237\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"5.62.43.237\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-27T06:20:27+0000\",\"updated_at\":\"2023-01-27T06:21:14+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4MDA0NzQsImV4cCI6MTY3NDgwNDA3NCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG05NXZubGdobzBwMG5xcDkiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.5yjMPgTDFLM4oX9qRh4ZZ3KySGQ01hRkV3NHAEVSwts\",\"base_amount\":100}', '2023-01-27 00:51:15', '2023-01-27 00:51:15'),
(4, 96, 'int_hkdmvr9zxghob8v2u74', '20230127124313678160', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmvr9zxghob8v2u74\",\"request_id\":\"20230127124313678160\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmcjzngghob9jw0im_8v2u74\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"05\",\"expiry_year\":\"2024\",\"name\":\"Testing\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6zcwgghob9mqt7i\",\"status\":\"CREATED\",\"created_at\":\"2023-01-27T12:43:57+0000\",\"updated_at\":\"2023-01-27T12:43:57+0000\"},\"payment_intent_id\":\"int_hkdmvr9zxghob8v2u74\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"960706251322_173489147580626\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"169016\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-27T12:43:57+0000\",\"updated_at\":\"2023-01-27T12:44:02+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"6accbefa-794d-4507-a6cb-dabe5f4159b8\",\"ip_address\":\"159.242.227.17\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"159.242.227.17\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-27T12:43:15+0000\",\"updated_at\":\"2023-01-27T12:44:02+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4MjM0NDIsImV4cCI6MTY3NDgyNzA0MiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG12cjl6eGdob2I4djJ1NzQiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.VZZpkXRAp5lCAk88-BidbX8m96nivGLwYzHY82tYH78\",\"base_amount\":100}', '2023-01-27 07:14:02', '2023-01-27 07:14:02'),
(5, 97, 'int_hkdm4r89dghojilegaz', '20230127174316851590', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdm4r89dghojilegaz\",\"request_id\":\"20230127174316851590\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmcjzngghojj3s1f5_ilegaz\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"02\",\"expiry_year\":\"2033\",\"name\":\"demo\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6zcwgghojj69xii\",\"status\":\"CREATED\",\"created_at\":\"2023-01-27T17:43:49+0000\",\"updated_at\":\"2023-01-27T17:43:49+0000\"},\"payment_intent_id\":\"int_hkdm4r89dghojilegaz\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"207768965837_360380566717963\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"072221\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-27T17:43:49+0000\",\"updated_at\":\"2023-01-27T17:43:53+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"70c46a9c-072e-4c45-b3e3-bf818d86dae8\",\"ip_address\":\"42.104.144.16\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"firefox\",\"ip_network_address\":\"42.104.144.16\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-27T17:43:18+0000\",\"updated_at\":\"2023-01-27T17:43:53+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4NDE0MzMsImV4cCI6MTY3NDg0NTAzMywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG00cjg5ZGdob2ppbGVnYXoiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.8rGy4R2NRpEJT5cBkiD745ifL2CN_StUwXOV5GZ_sjg\",\"base_amount\":100}', '2023-01-27 12:13:53', '2023-01-27 12:13:53'),
(6, 98, 'int_hkdmcjzngghoufupb89', '20230128001935802664', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmcjzngghoufupb89\",\"request_id\":\"20230128001935802664\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm4r89dghouguk8yr_fupb89\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"08\",\"expiry_year\":\"2028\",\"name\":\"Testing by Sanil 28Jan2023\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6zcwgghougxqs5n\",\"status\":\"CREATED\",\"created_at\":\"2023-01-28T00:20:37+0000\",\"updated_at\":\"2023-01-28T00:20:37+0000\"},\"payment_intent_id\":\"int_hkdmcjzngghoufupb89\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"994951744756_221341496414764\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"871959\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-28T00:20:37+0000\",\"updated_at\":\"2023-01-28T00:20:42+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"40eee59b-d1dc-49e7-8323-4765c0973454\",\"ip_address\":\"5.62.43.228\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"5.62.43.228\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-28T00:19:37+0000\",\"updated_at\":\"2023-01-28T00:20:42+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4NjUyNDIsImV4cCI6MTY3NDg2ODg0MiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1janpuZ2dob3VmdXBiODkiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.4qeZAPzirGQg2gv783McKz52vm_90D8SPoaKimjrrP0\",\"base_amount\":100}', '2023-01-27 18:50:42', '2023-01-27 18:50:42'),
(7, 100, 'int_hkdmcjzngghoutrmq5z', '20230128003337386807', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmcjzngghoutrmq5z\",\"request_id\":\"20230128003337386807\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmvr9zxghouug2nlg_trmq5z\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"08\",\"expiry_year\":\"2027\",\"name\":\"Test by Sanil\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmldwgpghouuj6c0z\",\"status\":\"CREATED\",\"created_at\":\"2023-01-28T00:34:19+0000\",\"updated_at\":\"2023-01-28T00:34:19+0000\"},\"payment_intent_id\":\"int_hkdmcjzngghoutrmq5z\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"795518666648_776373319408320\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"810331\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-28T00:34:19+0000\",\"updated_at\":\"2023-01-28T00:34:24+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"65ec70b2-6d61-4df7-b158-39f58e2878dc\",\"ip_address\":\"5.62.43.228\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"5.62.43.228\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-28T00:33:38+0000\",\"updated_at\":\"2023-01-28T00:34:24+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4NjYwNjQsImV4cCI6MTY3NDg2OTY2NCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1janpuZ2dob3V0cm1xNXoiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.Zvf2mDVteVVStksTUHj3iGx7WJ5NOsWKeiimDjoS9Dc\",\"base_amount\":100}', '2023-01-27 19:04:24', '2023-01-27 19:04:24'),
(8, 101, 'int_hkdmcjzngghowdzd4ox', '20230128013016485557', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmcjzngghowdzd4ox\",\"request_id\":\"20230128013016485557\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmvr9zxghoweui890_dzd4ox\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2027\",\"name\":\"Testing\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmldwgpghowexzk4s\",\"status\":\"CREATED\",\"created_at\":\"2023-01-28T01:31:09+0000\",\"updated_at\":\"2023-01-28T01:31:09+0000\"},\"payment_intent_id\":\"int_hkdmcjzngghowdzd4ox\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"312151136730_549480218405273\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"789331\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-28T01:31:09+0000\",\"updated_at\":\"2023-01-28T01:31:15+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"63211185-d1b8-493d-940a-2e2d6b7243b0\",\"ip_address\":\"5.62.43.228\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"5.62.43.228\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-28T01:30:17+0000\",\"updated_at\":\"2023-01-28T01:31:15+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ4Njk0NzUsImV4cCI6MTY3NDg3MzA3NSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1janpuZ2dob3dkemQ0b3giLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.JGRgWsCJ742lTOJiGn5cX7GAfJK0R8TUkxFGH68rxaU\",\"base_amount\":100}', '2023-01-27 20:01:15', '2023-01-27 20:01:15'),
(9, 102, 'int_hkdmcjzngghqb8fzzht', '20230129081457205660', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmcjzngghqb8fzzht\",\"request_id\":\"20230129081457205660\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmcjzngghqb92v2o6_8fzzht\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"05\",\"expiry_year\":\"2024\",\"name\":\"Test 2\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6zcwgghqb95pizn\",\"status\":\"CREATED\",\"created_at\":\"2023-01-29T08:15:36+0000\",\"updated_at\":\"2023-01-29T08:15:36+0000\"},\"payment_intent_id\":\"int_hkdmcjzngghqb8fzzht\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"029010091860_304291298233098\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"371855\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-01-29T08:15:36+0000\",\"updated_at\":\"2023-01-29T08:15:41+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"9c132238-9e0c-4b9d-9ce9-d8a810e6beea\",\"ip_address\":\"111.92.116.94\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"111.92.116.94\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"30\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-01-29T08:14:58+0000\",\"updated_at\":\"2023-01-29T08:15:41+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzQ5ODAxNDEsImV4cCI6MTY3NDk4Mzc0MSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1janpuZ2docWI4Znp6aHQiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.qNxSaiKxOVmjfFWj59gsHdy-a2g6SeShTcQf92vtJBk\",\"base_amount\":100}', '2023-01-29 02:45:41', '2023-01-29 02:45:41'),
(10, 103, 'int_hkdmk2rg8ghu435afdx', '20230201185956427127', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmk2rg8ghu435afdx\",\"request_id\":\"20230201185956427127\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmk2rg8ghu43gs6go_35afdx\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"02\",\"expiry_year\":\"2033\",\"name\":\"NAME\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmlsh76ghu43iyyq4\",\"status\":\"CREATED\",\"created_at\":\"2023-02-01T19:00:16+0000\",\"updated_at\":\"2023-02-01T19:00:16+0000\"},\"payment_intent_id\":\"int_hkdmk2rg8ghu435afdx\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"596718908781_043954848555536\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"540413\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-01T19:00:16+0000\",\"updated_at\":\"2023-02-01T19:00:20+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"846c0b21-d156-47d2-b34c-7281dcc82c42\",\"ip_address\":\"49.15.138.15\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"firefox\",\"ip_network_address\":\"49.15.138.15\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"26\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-01T18:59:57+0000\",\"updated_at\":\"2023-02-01T19:00:20+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzUyNzgwMjAsImV4cCI6MTY3NTI4MTYyMCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1rMnJnOGdodTQzNWFmZHgiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.xAZxVZvjusVWSr86hIkm3eFsCT4AgStl1mMG6tZrhVA\",\"base_amount\":100}', '2023-02-01 13:30:20', '2023-02-01 13:30:20'),
(11, 104, 'int_hkdmnxc6dgi22dzojk5', '20230209000651337295', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmnxc6dgi22dzojk5\",\"request_id\":\"20230209000651337295\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmlgwbggi22h8i6cl_dzojk5\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2026\",\"name\":\"SANIL KUMAR\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmd527lgi22hbcc5o\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T00:10:09+0000\",\"updated_at\":\"2023-02-09T00:10:09+0000\"},\"payment_intent_id\":\"int_hkdmnxc6dgi22dzojk5\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"623083896650_812105894418396\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"681281\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T00:10:09+0000\",\"updated_at\":\"2023-02-09T00:10:13+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"6009e425-c2bc-43df-a26a-9b4b12bf2a61\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T00:06:52+0000\",\"updated_at\":\"2023-02-09T00:10:13+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MDE0MTMsImV4cCI6MTY3NTkwNTAxMywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1ueGM2ZGdpMjJkem9qazUiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.Pf1h10rkYi2lXxwM6Xeaqr68_2vbrv3Vfjn_SbUUm2U\",\"base_amount\":100}', '2023-02-08 18:40:14', '2023-02-08 18:40:14'),
(12, 106, 'int_hkdmlgwbggi22vbbt0n', '20230209002419374213', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmlgwbggi22vbbt0n\",\"request_id\":\"20230209002419374213\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmqcpjwgi22vpoqz1_vbbt0n\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"08\",\"expiry_year\":\"2027\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm25m9qgi22vs96tf\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T00:24:44+0000\",\"updated_at\":\"2023-02-09T00:24:44+0000\"},\"payment_intent_id\":\"int_hkdmlgwbggi22vbbt0n\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"569103899340_311553633198882\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"884743\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T00:24:44+0000\",\"updated_at\":\"2023-02-09T00:24:48+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"a0f87922-f514-4a93-acf1-ff0578c2111d\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T00:24:20+0000\",\"updated_at\":\"2023-02-09T00:24:48+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MDIyODgsImV4cCI6MTY3NTkwNTg4OCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1sZ3diZ2dpMjJ2YmJ0MG4iLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.qpmhxuwGYAwnB8WJfPKkHVkeB2kfeYaCteg5_QH4yQk\",\"base_amount\":100}', '2023-02-08 18:54:49', '2023-02-08 18:54:49'),
(13, 107, 'int_hkdmqcpjwgi22zw9ylf', '20230209002856609187', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmqcpjwgi22zw9ylf\",\"request_id\":\"20230209002856609187\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmlgwbggi230bw7q8_zw9ylf\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"07\",\"expiry_year\":\"2025\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmd527lgi230ec1zc\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T00:29:23+0000\",\"updated_at\":\"2023-02-09T00:29:23+0000\"},\"payment_intent_id\":\"int_hkdmqcpjwgi22zw9ylf\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"044586925789_210508007387298\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"348067\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T00:29:23+0000\",\"updated_at\":\"2023-02-09T00:29:27+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"03f09a2e-3ca2-488d-a4da-efe86b01fbd5\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T00:28:57+0000\",\"updated_at\":\"2023-02-09T00:29:27+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MDI1NjcsImV4cCI6MTY3NTkwNjE2NywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1xY3Bqd2dpMjJ6dzl5bGYiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.xyX5FZThuYtoMkHVQcbFUo1q6Y4dxqV7MWMPKZ-Jp-c\",\"base_amount\":100}', '2023-02-08 18:59:27', '2023-02-08 18:59:27'),
(14, 108, 'int_hkdmlgwbggi232z2z5x', '20230209003202541229', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmlgwbggi232z2z5x\",\"request_id\":\"20230209003202541229\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmqcpjwgi233f1if4_2z2z5x\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"04\",\"expiry_year\":\"2025\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm25m9qgi233hqaui\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T00:32:30+0000\",\"updated_at\":\"2023-02-09T00:32:30+0000\"},\"payment_intent_id\":\"int_hkdmlgwbggi232z2z5x\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"325413125425_205945707302550\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"338622\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T00:32:30+0000\",\"updated_at\":\"2023-02-09T00:32:34+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"4b65317c-e000-405b-9327-74619239974e\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T00:32:03+0000\",\"updated_at\":\"2023-02-09T00:32:34+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MDI3NTQsImV4cCI6MTY3NTkwNjM1NCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1sZ3diZ2dpMjMyejJ6NXgiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.1q0_xViJrV0uNms68x5wHqVq_Lt2OhpvvyzJ-MHbknM\",\"base_amount\":100}', '2023-02-08 19:02:35', '2023-02-08 19:02:35'),
(15, 109, 'int_hkdmnxc6dgi2a1aja60', '20230209044418356250', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmnxc6dgi2a1aja60\",\"request_id\":\"20230209044418356250\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmqcpjwgi2a1qpfcs_1aja60\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"04\",\"expiry_year\":\"2025\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmd527lgi2a1tcp8l\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T04:44:46+0000\",\"updated_at\":\"2023-02-09T04:44:46+0000\"},\"payment_intent_id\":\"int_hkdmnxc6dgi2a1aja60\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"059298460632_817894037618725\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"072074\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T04:44:46+0000\",\"updated_at\":\"2023-02-09T04:44:50+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"04846bd0-78f6-4f0b-a10f-3060687f5339\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T04:44:19+0000\",\"updated_at\":\"2023-02-09T04:44:50+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MTc4OTAsImV4cCI6MTY3NTkyMTQ5MCwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1ueGM2ZGdpMmExYWphNjAiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.9wWlZGszXTgAEs4KuOfOPZau65hAE387dJC95d9FsBg\",\"base_amount\":100}', '2023-02-08 23:14:51', '2023-02-08 23:14:51'),
(16, 110, 'int_hkdmnxc6dgi2a9wjh7n', '20230209045259194514', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmnxc6dgi2a9wjh7n\",\"request_id\":\"20230209045259194514\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmnxc6dgi2aafuvxv_9wjh7n\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"08\",\"expiry_year\":\"2027\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmd527lgi2aai9olc\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T04:53:32+0000\",\"updated_at\":\"2023-02-09T04:53:32+0000\"},\"payment_intent_id\":\"int_hkdmnxc6dgi2a9wjh7n\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"880007169972_906060637307740\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"803328\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T04:53:32+0000\",\"updated_at\":\"2023-02-09T04:53:36+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"5ae5d291-138b-4cb0-82a6-f6f34c0b55aa\",\"ip_address\":\"156.146.35.172\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.172\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T04:53:00+0000\",\"updated_at\":\"2023-02-09T04:53:36+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MTg0MTYsImV4cCI6MTY3NTkyMjAxNiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1ueGM2ZGdpMmE5d2poN24iLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.F5a-VPNAdLFMobotvgd2TIFj498lI1eiUnPwPTxTtHQ\",\"base_amount\":100}', '2023-02-08 23:23:36', '2023-02-08 23:23:36'),
(17, 111, 'int_hkdmnxc6dgi2gisb01g', '20230209083936620197', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmnxc6dgi2gisb01g\",\"request_id\":\"20230209083936620197\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmqcpjwgi2gjdlf73_isb01g\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2027\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmd527lgi2gjfvsfz\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T08:40:13+0000\",\"updated_at\":\"2023-02-09T08:40:13+0000\"},\"payment_intent_id\":\"int_hkdmnxc6dgi2gisb01g\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"115061296853_012374805597735\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"463366\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T08:40:13+0000\",\"updated_at\":\"2023-02-09T08:40:17+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"1e561b3e-f371-43e0-9d9f-c7f47f0fb21d\",\"ip_address\":\"156.146.35.176\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.176\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T08:39:37+0000\",\"updated_at\":\"2023-02-09T08:40:17+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MzIwMTcsImV4cCI6MTY3NTkzNTYxNywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1ueGM2ZGdpMmdpc2IwMWciLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.91dwFCrSkKWvkPy3-SEWCy3o30b1im7YmbGqcOliciU\",\"base_amount\":100}', '2023-02-09 03:10:17', '2023-02-09 03:10:17'),
(18, 112, 'int_hkdmjdzt7gi2if9l7e2', '20230209094837468564', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmjdzt7gi2if9l7e2\",\"request_id\":\"20230209094837468564\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm8s7g5gi2ighxxms_f9l7e2\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"08\",\"expiry_year\":\"2024\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdms4kn5gi2igktc80\",\"status\":\"CREATED\",\"created_at\":\"2023-02-09T09:49:53+0000\",\"updated_at\":\"2023-02-09T09:49:53+0000\"},\"payment_intent_id\":\"int_hkdmjdzt7gi2if9l7e2\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"597460272414_616056012832172\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"347615\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-09T09:49:53+0000\",\"updated_at\":\"2023-02-09T09:49:57+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"02ea7dfe-7422-42a3-a538-024837e570f5\",\"ip_address\":\"156.146.35.176\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"156.146.35.176\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-09T09:48:38+0000\",\"updated_at\":\"2023-02-09T09:49:57+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5MzYxOTcsImV4cCI6MTY3NTkzOTc5NywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1qZHp0N2dpMmlmOWw3ZTIiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.D1QJS0tFNX9HzmNDLkJdZlQMUcKaMxTZHDcL9cRp9v0\",\"base_amount\":100}', '2023-02-09 04:19:58', '2023-02-09 04:19:58'),
(19, 113, 'int_hkdmv7pxfgi36i76teb', '20230210002217383777', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmv7pxfgi36i76teb\",\"request_id\":\"20230210002217383777\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmjdzt7gi36islafq_i76teb\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2026\",\"name\":\"RICHARD\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdms4kn5gi36ivgw2p\",\"status\":\"CREATED\",\"created_at\":\"2023-02-10T00:22:54+0000\",\"updated_at\":\"2023-02-10T00:22:54+0000\"},\"payment_intent_id\":\"int_hkdmv7pxfgi36i76teb\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"173179150976_480820293736198\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"063869\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-10T00:22:54+0000\",\"updated_at\":\"2023-02-10T00:22:59+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"95851a9a-7c39-4ed2-ba61-ee229b7647ca\",\"ip_address\":\"77.234.43.142\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"77.234.43.142\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-10T00:22:18+0000\",\"updated_at\":\"2023-02-10T00:22:59+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzU5ODg1NzksImV4cCI6MTY3NTk5MjE3OSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG12N3B4ZmdpMzZpNzZ0ZWIiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.3e8tVPl9G9OheudBBOMgDTgSgPj47WwsH-1FM1Uyaes\",\"base_amount\":100}', '2023-02-09 18:52:59', '2023-02-09 18:52:59'),
(20, 114, 'int_hkdmw7kv8gi3utf89e0', '20230210150418782465', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmw7kv8gi3utf89e0\",\"request_id\":\"20230210150418782465\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm7pqwlgi3uufv3o6_tf89e0\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"07\",\"expiry_year\":\"2028\",\"name\":\"SANIL NAIR\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmj8hwfgi3uuixdnj\",\"status\":\"CREATED\",\"created_at\":\"2023-02-10T15:05:21+0000\",\"updated_at\":\"2023-02-10T15:05:21+0000\"},\"payment_intent_id\":\"int_hkdmw7kv8gi3utf89e0\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"165330074536_699488372909882\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"702495\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-10T15:05:21+0000\",\"updated_at\":\"2023-02-10T15:05:26+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"8b153608-d5e0-48ce-8d11-fade27037260\",\"ip_address\":\"185.102.219.217\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"185.102.219.217\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"22\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-10T15:04:20+0000\",\"updated_at\":\"2023-02-10T15:05:26+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzYwNDE1MjYsImV4cCI6MTY3NjA0NTEyNiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG13N2t2OGdpM3V0Zjg5ZTAiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.YKUA0QruxrFIY_tetESyhbA6ochGuFpQmFS1czHSl9U\",\"base_amount\":100}', '2023-02-10 09:35:26', '2023-02-10 09:35:26');
INSERT INTO `payment_details` (`id`, `member_id`, `intent_id`, `request_id`, `amount`, `currency`, `merchant_order_id`, `descriptor`, `status`, `intent_details`, `created_at`, `updated_at`) VALUES
(21, 115, 'int_hkdmm84dfgi9s93k5cj', '20230216000741042049', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmm84dfgi9s93k5cj\",\"request_id\":\"20230216000741042049\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmd55clgi9s9l0swt_93k5cj\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"05\",\"expiry_year\":\"2025\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmf5kddgi9s9nmauk\",\"status\":\"CREATED\",\"created_at\":\"2023-02-16T00:08:11+0000\",\"updated_at\":\"2023-02-16T00:08:11+0000\"},\"payment_intent_id\":\"int_hkdmm84dfgi9s93k5cj\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"429947684345_926018446849437\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"134204\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-02-16T00:08:11+0000\",\"updated_at\":\"2023-02-16T00:08:16+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"41bf544a-7ba9-430d-99c4-5168160ca1b8\",\"ip_address\":\"116.68.99.12\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"116.68.99.12\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"20\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-02-16T00:07:42+0000\",\"updated_at\":\"2023-02-16T00:08:16+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzY1MDYwOTYsImV4cCI6MTY3NjUwOTY5NiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1tODRkZmdpOXM5M2s1Y2oiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.LwKFbuU3nxFJorj_ssX7XttClt0bbJwvOuzbhaqbwn0\",\"base_amount\":100}', '2023-02-15 18:38:16', '2023-02-15 18:38:16'),
(22, 116, 'int_hkdmz89w2giza3kc6jb', '20230311030653130406', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmz89w2giza3kc6jb\",\"request_id\":\"20230311030653130406\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmz89w2giza51xhsd_3kc6jb\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2024\",\"name\":\"TEST\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm4jkx2giza551gq7\",\"status\":\"CREATED\",\"created_at\":\"2023-03-11T03:08:24+0000\",\"updated_at\":\"2023-03-11T03:08:24+0000\"},\"payment_intent_id\":\"int_hkdmz89w2giza3kc6jb\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"062929166675_578468659755226\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"325053\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-03-11T03:08:24+0000\",\"updated_at\":\"2023-03-11T03:08:29+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"a96f0e75-4c5f-4b14-8e08-4f5c5c767698\",\"ip_address\":\"111.92.75.88\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"111.92.75.88\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"19\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-03-11T03:06:54+0000\",\"updated_at\":\"2023-03-11T03:08:29+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2Nzg1MDQxMDksImV4cCI6MTY3ODUwNzcwOSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG16ODl3MmdpemEza2M2amIiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.sN3UaKD6DNJV7L0L-17H5J7oXv0D45zm1n2Ku9f9A8c\",\"base_amount\":100}', '2023-03-10 21:38:29', '2023-03-10 21:38:29'),
(23, 117, 'int_hkdmmf5qwgja5dkc48z', '20230320234218913508', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmmf5qwgja5dkc48z\",\"request_id\":\"20230320234218913508\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmmf5qwgja5f4s84b_dkc48z\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2025\",\"name\":\"Test\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmm9qthgja5f7ewqi\",\"status\":\"CREATED\",\"created_at\":\"2023-03-20T23:43:55+0000\",\"updated_at\":\"2023-03-20T23:43:55+0000\"},\"payment_intent_id\":\"int_hkdmmf5qwgja5dkc48z\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"674193121947_873282944477687\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"739277\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-03-20T23:43:55+0000\",\"updated_at\":\"2023-03-20T23:43:59+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"c61fa13e-095f-4541-a6b1-de15d2157cda\",\"ip_address\":\"111.92.80.37\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"111.92.80.37\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"20\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-03-20T23:42:20+0000\",\"updated_at\":\"2023-03-20T23:43:59+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2NzkzNTU4MzksImV4cCI6MTY3OTM1OTQzOSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1tZjVxd2dqYTVka2M0OHoiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.5wr_WurR13Y_Y2Td6QELZn1i6cyEGoYrpSg8LiUEPEg\",\"base_amount\":100}', '2023-03-20 18:14:00', '2023-03-20 18:14:00'),
(24, 69, 'int_hkdm95hqqgjziiul50f', '20230412235100455795', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdm95hqqgjziiul50f\",\"request_id\":\"20230412235100455795\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmwrlcggjzik6mt7n_iul50f\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"09\",\"expiry_year\":\"2026\",\"name\":\"SANIL\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdm6jhkngjzikafemn\",\"status\":\"CREATED\",\"created_at\":\"2023-04-12T23:52:23+0000\",\"updated_at\":\"2023-04-12T23:52:23+0000\"},\"payment_intent_id\":\"int_hkdm95hqqgjziiul50f\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"040957469303_718939233438998\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"054086\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-04-12T23:52:23+0000\",\"updated_at\":\"2023-04-12T23:52:29+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"29617130-d58b-4eca-ae09-332775f64598\",\"ip_address\":\"116.68.100.237\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"116.68.100.237\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"23\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-04-12T23:51:02+0000\",\"updated_at\":\"2023-04-12T23:52:29+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2ODEzNDM1NDksImV4cCI6MTY4MTM0NzE0OSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG05NWhxcWdqemlpdWw1MGYiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.6sjWiSl9_qWXZhbZczNlSyGkVJ4XLkYVYhPOcf8LrwU\",\"base_amount\":100}', '2023-04-12 18:22:29', '2023-04-12 18:22:29'),
(25, 19, 'int_hkdmhzgt9gk6kveczbn', '20230419093841740482', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmhzgt9gk6kveczbn\",\"request_id\":\"20230419093841740482\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdmd2cxngk6kw1xjgb_veczbn\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"12\",\"expiry_year\":\"2025\",\"name\":\"Rich C\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmqp9nvgk6kwg5dik\",\"status\":\"CREATED\",\"created_at\":\"2023-04-19T09:39:23+0000\",\"updated_at\":\"2023-04-19T09:39:23+0000\"},\"payment_intent_id\":\"int_hkdmhzgt9gk6kveczbn\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"445140208324_015911875021974\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"880428\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-04-19T09:39:23+0000\",\"updated_at\":\"2023-04-19T09:39:47+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"45649b7c-67f3-447c-8abe-118a03a67e38\",\"ip_address\":\"124.122.192.214\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"124.122.192.214\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"-1\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-04-19T09:38:44+0000\",\"updated_at\":\"2023-04-19T09:39:47+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2ODE4OTcxODcsImV4cCI6MTY4MTkwMDc4NywidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1oemd0OWdrNmt2ZWN6Ym4iLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.CS5xf_wvc9o04KXGAiPvdTxpnJV7rH8VD9w03yD5gxE\",\"base_amount\":100}', '2023-04-19 04:09:47', '2023-04-19 04:09:47'),
(26, 119, 'int_hkdmmpdb6gmt09x0p2k', '20230714010803845445', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"id\":\"int_hkdmmpdb6gmt09x0p2k\",\"request_id\":\"20230714010803845445\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"latest_payment_attempt\":{\"id\":\"att_hkdm9v6cdgmt0am9uo1_9x0p2k\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"12\",\"expiry_year\":\"2028\",\"name\":\"SANIL TESTING\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmvzw6fgmt0apacfz\",\"status\":\"CREATED\",\"created_at\":\"2023-07-14T01:08:47+0000\",\"updated_at\":\"2023-07-14T01:08:47+0000\"},\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"payment_intent_id\":\"int_hkdmmpdb6gmt09x0p2k\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"780266932714_893586976361678\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"885743\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-07-14T01:08:47+0000\",\"updated_at\":\"2023-07-14T01:08:52+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"f1c1fd0e-f963-4bc8-98c1-bbb2596b7779\",\"ip_address\":\"202.83.40.32\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"chrome\",\"ip_network_address\":\"202.83.40.32\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"85\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"}},\"created_at\":\"2023-07-14T01:08:05+0000\",\"updated_at\":\"2023-07-14T01:08:52+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2ODkyOTY5MzIsImV4cCI6MTY4OTMwMDUzMiwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1tcGRiNmdtdDA5eDBwMmsiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.EjrV2XlERVVlv-sLLA_sQQG6XYgU1YpEhiJquIteJms\",\"base_amount\":100}', '2023-07-13 19:38:52', '2023-07-13 19:38:52'),
(27, 120, 'int_hkdmdfhgmgpq6wc8la6', '20231017104537390423', 100, 'USD', 'Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a', 'Cathy Testing', 'SUCCEEDED', '{\"latest_payment_attempt\":{\"id\":\"att_hkdmwkscqgpq6xe0w8g_wc8la6\",\"amount\":100,\"currency\":\"USD\",\"payment_method\":{\"type\":\"card\",\"card\":{\"expiry_month\":\"12\",\"expiry_year\":\"2023\",\"name\":\"PRADEEP\",\"bin\":\"40355010\",\"last4\":\"0008\",\"brand\":\"visa\",\"issuer_country_code\":\"US\",\"card_type\":\"DEBIT\",\"fingerprint\":\"FTZd09K9OAPutJpassrvqPgpY\\/c=\",\"cvc_check\":\"pass\",\"billing\":{\"first_name\":\"\",\"last_name\":\"\"},\"issuer_name\":\"SOCIETE GENERALE\",\"is_commercial\":false,\"number_type\":\"PAN\"},\"id\":\"mtd_hkdmmmsp7gpq6xg5o9h\",\"status\":\"CREATED\",\"created_at\":\"2023-10-17T10:46:42+0000\",\"updated_at\":\"2023-10-17T10:46:42+0000\"},\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"payment_intent_id\":\"int_hkdmdfhgmgpq6wc8la6\",\"status\":\"CAPTURE_REQUESTED\",\"provider_transaction_id\":\"465197153987_242446110736433\",\"provider_original_response_code\":\"00\",\"authorization_code\":\"230140\",\"captured_amount\":100,\"refunded_amount\":0,\"created_at\":\"2023-10-17T10:46:42+0000\",\"updated_at\":\"2023-10-17T10:46:45+0000\",\"settle_via\":\"airwallex\",\"device\":{\"device_id\":\"c07a3e46-78c4-49c3-8d22-aa9482f8b8f4\",\"ip_address\":\"42.104.146.70\",\"host_name\":\"https:\\/\\/onehrstag.com\",\"cookies_accepted\":\"true\",\"http_browser_type\":\"firefox\",\"ip_network_address\":\"42.104.146.70\"},\"authentication_data\":{\"ds_data\":{\"retry_count_for_auth_decline\":0},\"fraud_data\":{\"action\":\"ACCEPT\",\"score\":\"5\"},\"avs_result\":\"U\",\"cvc_result\":\"Y\",\"cvc_code\":\"M\"},\"payment_method_options\":{\"card\":[]}},\"id\":\"int_hkdmdfhgmgpq6wc8la6\",\"request_id\":\"20231017104537390423\",\"amount\":100,\"currency\":\"USD\",\"merchant_order_id\":\"Merchant_Order_a7f9baf8-884a-4def-ba85-d1f9be83470a\",\"descriptor\":\"Cathy Testing\",\"status\":\"SUCCEEDED\",\"captured_amount\":100,\"created_at\":\"2023-10-17T10:45:38+0000\",\"updated_at\":\"2023-10-17T10:46:45+0000\",\"client_secret\":\"eyJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTc1Mzk2MDUsImV4cCI6MTY5NzU0MzIwNSwidHlwZSI6ImNsaWVudC1zZWNyZXQiLCJwYWRjIjoiSEsiLCJhY2NvdW50X2lkIjoiZGI3MTZjZDEtZGVhYS00YWUxLTg0NjYtNmQ3NDBkZmVmY2ZmIiwiaW50ZW50X2lkIjoiaW50X2hrZG1kZmhnbWdwcTZ3YzhsYTYiLCJidXNpbmVzc19uYW1lIjoiZGVtbyBDYXBhYmlsaXR5U29sdXRpb24ifQ.LXkEyVlTGoGZPnFLrbZH5SsDGJQrSpPLCvVHaZ444ms\",\"base_amount\":100}', '2023-10-17 05:16:45', '2023-10-17 05:16:45');

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_development_plan`
--

CREATE TABLE `personal_development_plan` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `focus_area_id` int(11) NOT NULL,
  `fa_accountability_id` int(11) NOT NULL,
  `current_maturity_level` int(11) DEFAULT NULL,
  `maturity_level_aspiration` int(11) 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 `personal_development_plan`
--

INSERT INTO `personal_development_plan` (`id`, `member_id`, `focus_area_id`, `fa_accountability_id`, `current_maturity_level`, `maturity_level_aspiration`, `created_at`, `updated_at`) VALUES
(1, 4, 1, 1, 313, 317, '2023-05-22 00:26:59', '2023-05-22 13:52:59'),
(2, 4, 1, 2, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(3, 4, 1, 3, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(4, 4, 1, 4, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(5, 4, 1, 5, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(6, 4, 2, 6, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(7, 4, 2, 7, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(8, 4, 2, 8, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(9, 4, 2, 9, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(10, 4, 2, 10, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(11, 4, 2, 11, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(12, 4, 2, 12, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(13, 4, 2, 13, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(14, 4, 2, 14, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(15, 4, 2, 15, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(16, 4, 2, 16, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(17, 4, 2, 17, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(18, 4, 2, 18, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(19, 4, 2, 19, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(20, 4, 2, 20, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(21, 4, 3, 21, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(22, 4, 3, 22, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(23, 4, 3, 23, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(24, 4, 4, 24, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(25, 4, 4, 25, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(26, 4, 4, 26, NULL, NULL, '2023-05-22 00:26:59', '2023-05-22 00:26:59'),
(27, 69, 1, 1, 315, 314, '2023-05-22 02:25:22', '2023-05-22 02:25:39'),
(28, 69, 1, 2, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(29, 69, 1, 3, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(30, 69, 1, 4, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(31, 69, 1, 5, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(32, 69, 2, 6, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(33, 69, 2, 7, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(34, 69, 2, 8, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(35, 69, 2, 9, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(36, 69, 2, 10, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(37, 69, 2, 11, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(38, 69, 2, 12, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(39, 69, 2, 13, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(40, 69, 2, 14, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(41, 69, 2, 15, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(42, 69, 2, 16, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(43, 69, 2, 17, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(44, 69, 2, 18, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(45, 69, 2, 19, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(46, 69, 2, 20, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(47, 69, 3, 21, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(48, 69, 3, 22, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(49, 69, 3, 23, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(50, 69, 4, 24, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(51, 69, 4, 25, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(52, 69, 4, 26, NULL, NULL, '2023-05-22 02:25:22', '2023-05-22 02:25:22'),
(53, 120, 1, 1, 315, 313, '2023-10-17 05:19:56', '2023-10-17 05:20:17'),
(54, 120, 1, 2, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(55, 120, 1, 3, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(56, 120, 1, 4, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(57, 120, 1, 5, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(58, 120, 2, 6, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(59, 120, 2, 7, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(60, 120, 2, 8, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(61, 120, 2, 9, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(62, 120, 2, 10, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(63, 120, 2, 11, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(64, 120, 2, 12, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(65, 120, 2, 13, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(66, 120, 2, 14, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(67, 120, 2, 15, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(68, 120, 2, 16, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(69, 120, 2, 17, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(70, 120, 2, 18, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(71, 120, 2, 19, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(72, 120, 2, 20, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(73, 120, 3, 21, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(74, 120, 3, 22, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(75, 120, 3, 23, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(76, 120, 4, 24, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(77, 120, 4, 25, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56'),
(78, 120, 4, 26, NULL, NULL, '2023-10-17 05:19:56', '2023-10-17 05:19:56');

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

--
-- Table structure for table `personal_development_plan_level1_master`
--

CREATE TABLE `personal_development_plan_level1_master` (
  `id` int(10) UNSIGNED NOT NULL,
  `level1` 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 `personal_development_plan_level1_master`
--

INSERT INTO `personal_development_plan_level1_master` (`id`, `level1`, `created_at`, `updated_at`) VALUES
(1, 'Learning By Doing', NULL, NULL),
(2, 'Learning Through Others', NULL, NULL),
(3, 'Learning Through Resources', NULL, NULL);

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

--
-- Table structure for table `personal_development_plan_level2_master`
--

CREATE TABLE `personal_development_plan_level2_master` (
  `id` int(10) UNSIGNED NOT NULL,
  `level1_id` int(11) NOT NULL,
  `level2` 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 `personal_development_plan_level2_master`
--

INSERT INTO `personal_development_plan_level2_master` (`id`, `level1_id`, `level2`, `created_at`, `updated_at`) VALUES
(37, 1, 'On-the-job Assignments', NULL, NULL),
(38, 1, 'Work Experience', NULL, NULL),
(39, 1, 'Join a relevant Project', NULL, NULL),
(40, 1, 'Job Rotation', NULL, NULL),
(41, 1, 'Increased Responsibility', NULL, NULL),
(42, 1, 'Coach Others', NULL, NULL),
(43, 1, 'Mentor Others', NULL, NULL),
(44, 1, 'Counsel Others', NULL, NULL),
(45, 1, 'Conduct Research', NULL, NULL),
(46, 1, 'Promotion', NULL, NULL),
(47, 1, 'Shadow Learning', NULL, NULL),
(48, 1, 'Study Visit', NULL, NULL),
(49, 1, 'Undertake a high risk assignment (new or turnaround business)', NULL, NULL),
(50, 1, 'Present at an industry forum', NULL, NULL),
(51, 1, 'Undertake a stretch assignment', NULL, NULL),
(52, 1, 'Other  [to be crowd sourced and categorised accordingly]', NULL, NULL),
(53, 2, 'Appoint a Coach', NULL, NULL),
(54, 2, 'Undertake Counseling', NULL, NULL),
(55, 2, 'Set up a Mentor relationship', NULL, NULL),
(56, 2, 'Feedback received from others', NULL, NULL),
(57, 2, 'Knowledge Sharing/Transfer Knowledge', NULL, NULL),
(58, 2, 'Market Visit', NULL, NULL),
(59, 2, 'Join a Network(s)', NULL, NULL),
(60, 2, 'Shadow Learning', NULL, NULL),
(61, 2, 'Attend Conference(s)', NULL, NULL),
(62, 2, 'Attend Exhibition(s)', NULL, NULL),
(63, 2, 'Attend Exhibition(s)', NULL, NULL),
(64, 2, 'Attend Seminar(s)', NULL, NULL),
(65, 2, 'Join a Professional Association(s) / Industry Group(s)', NULL, NULL),
(66, 2, 'Activate relevant Membership(s)', NULL, NULL),
(67, 2, 'Activate relevant Membership(s)', NULL, NULL),
(68, 2, 'Other  [to be crowd sourced and categorised accordingly]', NULL, NULL),
(69, 3, 'Classroom Training / Instructor Led Courses', NULL, NULL),
(70, 3, 'eLearning Programs', NULL, NULL),
(71, 3, 'Formal Education Programs (Tertiary, Vocational studies etc)', NULL, NULL),
(72, 3, 'Reading Journals, books, magazines, newspapers, blogs', NULL, NULL),
(73, 3, 'Virtual Learning Events', NULL, NULL),
(74, 3, 'Webinars)', NULL, NULL),
(75, 3, 'Other  [to be crowd sourced and categorised accordingly]', NULL, NULL);

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

--
-- Table structure for table `personal_development_plan_list`
--

CREATE TABLE `personal_development_plan_list` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `personal_development_plan_id` int(11) NOT NULL,
  `action` varchar(255) DEFAULT NULL,
  `smart_goal` varchar(255) DEFAULT NULL,
  `when` varchar(255) DEFAULT NULL,
  `how` varchar(255) DEFAULT NULL,
  `level1_id` int(11) DEFAULT NULL,
  `level2_id` int(11) DEFAULT NULL,
  `details` 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 `personal_development_plan_list`
--

INSERT INTO `personal_development_plan_list` (`id`, `member_id`, `personal_development_plan_id`, `action`, `smart_goal`, `when`, `how`, `level1_id`, `level2_id`, `details`, `created_at`, `updated_at`) VALUES
(1, 69, 27, 'This is a test', 'This is a test', NULL, NULL, 1, 48, 'Study Visit to mdfdfsfdsj', '2023-05-22 02:29:02', '2023-05-22 02:29:02'),
(2, 4, 1, 'Test', 'SMART GOAL', NULL, NULL, 1, 47, 'Testing.........', '2023-05-22 13:53:23', '2023-05-22 13:53:23');

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

--
-- Table structure for table `post_activities`
--

CREATE TABLE `post_activities` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `post_type` int(11) NOT NULL COMMENT '1: post, 2: sub post',
  `activity_type` int(11) NOT NULL DEFAULT 0 COMMENT '1: like, 2: love',
  `is_viewed` int(11) NOT NULL DEFAULT 0 COMMENT '1: true',
  `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 `post_activities`
--

INSERT INTO `post_activities` (`id`, `member_id`, `post_id`, `post_type`, `activity_type`, `is_viewed`, `created_at`, `updated_at`) VALUES
(2, 72, 7, 1, 2, 0, '2023-02-09 03:31:35', '2023-02-09 03:31:35'),
(3, 72, 8, 1, 2, 0, '2023-02-09 03:33:07', '2023-02-09 03:33:07'),
(4, 112, 10, 1, 2, 0, '2023-02-09 04:23:23', '2023-02-09 04:23:23');

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

--
-- Table structure for table `post_activities_count`
--

CREATE TABLE `post_activities_count` (
  `id` int(10) UNSIGNED NOT NULL,
  `post_type` int(11) NOT NULL COMMENT '1: post, 2: sub post',
  `post_id` int(11) NOT NULL,
  `likes` int(11) NOT NULL DEFAULT 0,
  `loves` int(11) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  `comments` 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;

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

--
-- Table structure for table `post_tag`
--

CREATE TABLE `post_tag` (
  `id` int(10) UNSIGNED NOT NULL,
  `tag_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `created_by` 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 `post_tag`
--

INSERT INTO `post_tag` (`id`, `tag_id`, `post_id`, `created_by`, `created_at`, `updated_at`) VALUES
(3, 36, 2, 4, '2023-02-07 18:43:14', '2023-02-07 18:43:14'),
(4, 43, 3, 4, '2023-02-07 18:52:10', '2023-02-07 18:52:10'),
(5, 29, 1, 4, '2023-02-07 18:54:24', '2023-02-07 18:54:24'),
(7, 37, 4, 111, '2023-02-09 03:17:51', '2023-02-09 03:17:51'),
(9, 73, 6, 111, '2023-02-09 03:23:57', '2023-02-09 03:23:57'),
(13, 1, 7, 4, '2023-02-09 03:30:53', '2023-02-09 03:30:53'),
(14, 2, 9, 72, '2023-02-09 03:48:26', '2023-02-09 03:48:26'),
(15, 2, 10, 112, '2023-02-09 04:23:00', '2023-02-09 04:23:00');

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

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `original_file_name` varchar(255) NOT NULL,
  `extension` varchar(255) NOT NULL,
  `description` 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 `resources`
--

INSERT INTO `resources` (`id`, `member_id`, `category_id`, `sub_category_id`, `file_name`, `original_file_name`, `extension`, `description`, `created_at`, `updated_at`) VALUES
(1, 4, 3, 23, '1675933722310whatmatters.com_okrs_and_ogsm.pdf', 'whatmatters.com_OKRs_and_OGSM.pdf', 'pdf', 'OGSM and OKRs - whats the difference', '2023-02-09 03:38:42', '2023-02-09 03:38:42');

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_name` 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 `role`
--

INSERT INTO `role` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'HR President', '2021-10-19 01:32:44', NULL),
(2, 'HR Vice President', '2021-10-19 01:32:44', NULL),
(3, 'HR Director', '2021-10-19 01:32:44', NULL),
(4, 'HR Personal Manager', '2021-10-19 01:32:44', NULL),
(5, 'HR Factory Manager ( Hi-Tech)', '2021-10-19 01:32:44', NULL),
(6, 'HR Factory Manager (Low-Tech)', '2021-10-19 01:32:44', NULL),
(7, 'HR Officer or HR Supervisor', '2021-10-19 01:32:44', NULL),
(8, 'Strategic Individual Contributor', '2021-10-19 01:32:44', NULL),
(9, 'Operational Individual Contributor', '2021-10-19 01:32:44', NULL),
(10, 'Transactional Individual Contributor', '2021-10-19 01:32:44', NULL),
(11, 'HR Trainee or Intern', '2021-10-19 01:32:44', NULL);

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

--
-- Table structure for table `role_evaluation`
--

CREATE TABLE `role_evaluation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_name` 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 `role_evaluation`
--

INSERT INTO `role_evaluation` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'Generalist Global HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(2, 'Generalist Regional HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(3, 'Generalist Country HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(4, 'Generalist large company HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(5, 'Generalist medium Company HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(6, 'Generalist start up Company HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(7, 'Generalist small Company HR Leader (HOHR or Director)', '2023-03-07 12:23:33', NULL),
(8, 'Generalist HR Manager', '2023-03-07 12:23:33', NULL),
(9, 'Generalist HR Officer or Supervisor', '2023-03-07 12:23:33', NULL),
(10, 'Specialist Reward (C&B) Manager', '2023-03-07 12:23:33', NULL),
(11, 'Specialist OD Manager', '2023-03-07 12:23:33', NULL),
(12, 'Specialist Recruitment Manager', '2023-03-07 12:23:33', NULL),
(13, 'Specialist L&D Manager', '2023-03-07 12:23:33', NULL),
(14, 'Specialist HR Administation Manager', '2023-03-07 12:23:33', NULL),
(15, 'HR Process Executive or Specialist', '2023-03-07 12:23:33', NULL),
(16, 'Generalist HR Executive', '2023-03-07 12:23:33', NULL),
(17, 'HR Trainee', '2023-03-07 12:23:33', NULL),
(18, 'HR Intern', '2023-03-07 12:23:33', NULL);

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

--
-- Table structure for table `senior_leadership_alignment`
--

CREATE TABLE `senior_leadership_alignment` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `leader` varchar(255) DEFAULT NULL,
  `completed_status` int(11) NOT NULL DEFAULT 0 COMMENT '0: Not Cmpleted 1: Completed',
  `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 `senior_leadership_alignment`
--

INSERT INTO `senior_leadership_alignment` (`id`, `member_id`, `title`, `leader`, `completed_status`, `created_at`, `updated_at`) VALUES
(1, 4, 'Senior Leadership Alignment', 'Senior Leadership Alignment', 0, '2023-05-24 07:21:27', '2023-05-24 07:21:27'),
(2, 69, '25 M by 2025', 'SLeader 1', 0, '2023-05-24 18:28:30', '2023-05-24 18:28:30'),
(3, 4, 'Senior Leadership Alignment', 'Senior Leadership Alignment', 0, '2023-05-24 21:01:55', '2023-05-24 21:01:55');

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

--
-- Table structure for table `senior_leadership_alignment_objectives`
--

CREATE TABLE `senior_leadership_alignment_objectives` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `senior_leadership_alignment_id` int(11) NOT NULL,
  `objectives` varchar(255) DEFAULT NULL,
  `goals` 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 `senior_leadership_alignment_objectives`
--

INSERT INTO `senior_leadership_alignment_objectives` (`id`, `member_id`, `senior_leadership_alignment_id`, `objectives`, `goals`, `created_at`, `updated_at`) VALUES
(1, 69, 2, '<p>Test Objetisdfi 		</p>', '<p>Test Goals</p>', '2023-05-24 18:28:51', '2023-05-24 18:28:51'),
(2, 4, 3, '<h3>Senior Leadership Alignment</h3><p><br></p>', '<h3>Senior Leadership Alignment</h3><p><br></p>', '2023-05-24 21:02:14', '2023-05-24 21:02:14');

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

--
-- Table structure for table `senior_leadership_alignment_strategies`
--

CREATE TABLE `senior_leadership_alignment_strategies` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `objectives_id` int(11) NOT NULL,
  `strategy` varchar(255) NOT NULL,
  `measures` 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 `senior_leadership_alignment_strategies`
--

INSERT INTO `senior_leadership_alignment_strategies` (`id`, `member_id`, `objectives_id`, `strategy`, `measures`, `created_at`, `updated_at`) VALUES
(1, 69, 1, '<p>Measures 1</p>', '<p>Measures 1</p>', '2023-05-24 18:29:07', '2023-05-24 18:29:07'),
(2, 69, 1, '<p>Measures 2</p>', '<p>Measures 2</p>', '2023-05-24 18:29:25', '2023-05-24 18:29:25');

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

--
-- Table structure for table `strategies`
--

CREATE TABLE `strategies` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `objectives_id` int(11) DEFAULT NULL,
  `strategy` varchar(255) DEFAULT NULL,
  `measures` 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 `strategies`
--

INSERT INTO `strategies` (`id`, `member_id`, `objectives_id`, `strategy`, `measures`, `created_at`, `updated_at`) VALUES
(1, 4, 1, '<p>HR Business Alignment OGSM  Testing</p>', '<p>HR Business Alignment OGSM</p>', '2023-05-17 07:38:23', '2023-05-22 20:36:27'),
(2, 4, 1, 'HR Business Alignment OGSM', 'HR Business Alignment OGSM', '2023-05-17 07:38:32', '2023-05-17 07:38:32'),
(8, 4, 1, '<p> HR Business Alignment OGSM  </p><p> HR Business Alignment <span style=\"color: rgb(230, 0, 0);\">OGSM  </span></p>', '<p> HR Business Alignment OGSM  </p><p> HR Business Alignment <span style=\"color: rgb(230, 0, 0);\">OGSM  </span></p>', '2023-05-18 12:16:39', '2023-05-18 12:16:39'),
(11, 4, 5, '<p>HR Business Alignment <strong>OGSM STRATEGY</strong></p>', '<p>HR Business Alignment <strong>OGSM MEASURES</strong></p>', '2023-05-22 20:37:12', '2023-05-22 20:40:02'),
(13, 4, 6, '<p>Measures</p>', '<p>Measures</p>', '2023-05-22 20:48:31', '2023-05-22 20:48:31'),
(14, 4, 6, '<p>meas</p>', '<p>meas</p>', '2023-05-22 20:52:44', '2023-05-22 20:52:44'),
(17, 4, 6, '<p>Strategies</p>', '<p>Measures</p>', '2023-05-22 21:25:18', '2023-05-22 21:25:18'),
(18, 69, 4, '<p>Grow global e-commerce customers by leveraging strengths (design, product development, customer service, on-time delivery, quality, effective cost structure)</p>', '<p>From x to y customers</p><p>From x to $3M</p>', '2023-05-22 21:27:56', '2023-05-22 21:29:17'),
(19, 69, 4, '<p>Grow global brand customers by leveraging strengths (design, product development, customer service, on-time delivery, quality, effective cost structure)</p>', '<p>From x to y customers</p><p>From x to $3M</p>', '2023-05-22 21:28:54', '2023-05-22 21:28:54');

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

--
-- Table structure for table `tag`
--

CREATE TABLE `tag` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `created_by` 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 `tag`
--

INSERT INTO `tag` (`id`, `parent_id`, `tag`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'OGSM', 1, NULL, NULL),
(2, 1, 'Business Planning', 1, NULL, NULL),
(3, 1, 'Business Planning', 1, NULL, NULL),
(4, 2, 'KPIs', 1, NULL, NULL),
(5, 2, 'Performance Objectives', 1, NULL, NULL),
(6, 2, 'OKRs', 1, NULL, NULL),
(7, 3, 'Capabilities', 1, NULL, NULL),
(8, 3, 'Maturity Matrix', 1, NULL, NULL),
(9, 3, 'Functional Capabilities', 1, NULL, NULL),
(10, 4, 'Transformation and Change Management', 1, NULL, NULL),
(11, 4, 'Structure Development', 1, NULL, NULL),
(12, 4, 'Accountability Matrix', 1, NULL, NULL),
(13, 5, 'Workplace Culture', 1, NULL, NULL),
(14, 5, 'Career Growth', 1, NULL, NULL),
(15, 5, 'Employee Experience', 1, NULL, NULL),
(16, 6, 'HR Admin Strategies', 1, NULL, NULL),
(17, 6, 'HR Admin Operations', 1, NULL, NULL),
(18, 6, 'HR Admin Outsourcing', 1, NULL, NULL),
(19, 7, 'ER Strategies', 1, NULL, NULL),
(20, 7, 'ER Policy', 1, NULL, NULL),
(21, 7, 'ER Process', 1, NULL, NULL),
(22, 8, 'Diversity Management', 1, NULL, NULL),
(23, 8, 'Inclusion Management', 1, NULL, NULL),
(24, 8, 'Equity Management', 1, NULL, NULL),
(25, 9, 'Labour Law', 1, NULL, NULL),
(26, 9, 'Collective Bargaining', 1, NULL, NULL),
(27, 9, 'Union Management', 1, NULL, NULL),
(28, 10, 'PM Process', 1, NULL, NULL),
(29, 10, 'PM Engagement', 1, NULL, NULL),
(30, 10, 'PM Administration', 1, NULL, NULL),
(31, 11, 'Reward Definitions', 1, NULL, NULL),
(32, 11, 'Reward Policy', 1, NULL, NULL),
(33, 11, 'Reward Process', 1, NULL, NULL),
(34, 12, 'Talent Policy', 1, NULL, NULL),
(35, 12, 'Talent Evaluation', 1, NULL, NULL),
(36, 12, 'Talent Process', 1, NULL, NULL),
(37, 13, 'Sourcing Strategies', 1, NULL, NULL),
(38, 13, 'Interview Management', 1, NULL, NULL),
(39, 13, 'Graduate Hiring', 1, NULL, NULL),
(40, 13, 'Recruitment Agencies', 1, NULL, NULL),
(41, 14, 'L&D Strategies', 1, NULL, NULL),
(42, 14, 'L&D Policy', 1, NULL, NULL),
(43, 14, 'L&D Operations', 1, NULL, NULL),
(44, 15, 'HR Project Leadership', 1, NULL, NULL),
(45, 15, 'HR Project Governance', 1, NULL, NULL),
(46, 15, 'HR Project Stakeholder Management', 1, NULL, NULL),
(47, 16, 'Requirement Definition', 1, NULL, NULL),
(48, 16, 'Digitisation', 1, NULL, NULL),
(49, 16, 'Automation', 1, NULL, NULL),
(50, 17, 'Legislation', 1, NULL, NULL),
(51, 17, 'Dashboard', 1, NULL, NULL),
(52, 17, 'Workplace Management', 1, NULL, NULL),
(53, 18, 'Internal Communication Strategies', 1, NULL, NULL),
(54, 18, 'Internal Communication Policies', 1, NULL, NULL),
(55, 18, 'Internal Communication Process', 1, NULL, NULL),
(56, 19, 'Expat Taxation', 1, NULL, NULL),
(57, 19, 'Expat Benefits', 1, NULL, NULL),
(58, 19, 'Expat Relocation', 1, NULL, NULL),
(59, 20, 'Location Evaluation', 1, NULL, NULL),
(60, 20, 'Lease Management', 1, NULL, NULL),
(61, 20, 'Faciliities Services', 1, NULL, NULL),
(62, 21, 'HR Financial Metrics', 1, NULL, NULL),
(63, 21, 'HR Financial Budgeting', 1, NULL, NULL),
(64, 21, 'HR Financial Dashboards', 1, NULL, NULL),
(65, 22, 'HR Performance Metrics Strategies', 1, NULL, NULL),
(66, 22, 'HR Performance  Options', 1, NULL, NULL),
(67, 22, 'HR Performance Metrics Management', 1, NULL, NULL),
(68, 23, 'HR Governance Structure', 1, NULL, NULL),
(69, 23, 'HR Project Management', 1, NULL, NULL),
(70, 23, 'HR Project Operations', 1, NULL, NULL),
(71, 24, 'HR Strategy Innovation & Creativity', 1, NULL, NULL),
(72, 24, 'HR Policy Innovation & Creativity', 1, NULL, NULL),
(73, 24, 'HR System Innovation & Creativity', 1, NULL, NULL),
(74, 25, 'HR Maturity Governance', 1, NULL, NULL),
(75, 25, 'HR Maturity Matrix', 1, NULL, NULL),
(76, 25, 'HR Maturity Dashboard', 1, NULL, NULL),
(77, 26, 'HR 4.0', 1, NULL, NULL),
(78, 26, 'RPA', 1, NULL, NULL),
(79, 26, 'Digital Solutions', 1, NULL, NULL);

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

--
-- Table structure for table `third_level_subject`
--

CREATE TABLE `third_level_subject` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `subject` text NOT NULL,
  `created_by` 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 `third_level_subject`
--

INSERT INTO `third_level_subject` (`id`, `parent_id`, `subject`, `created_by`, `created_at`, `updated_at`) VALUES
(11, 2, 'Models', 4, '2022-11-11 01:35:00', '2022-11-11 01:35:00'),
(12, 2, 'Systems', 4, '2022-11-11 01:35:15', '2022-11-11 01:35:15'),
(13, 3, 'Capability Assessment and Planning Tools', 4, '2022-11-21 19:09:09', '2022-11-21 19:09:09'),
(14, 4, 'Organizational Innovation', 4, '2022-11-23 18:02:44', '2022-11-23 18:02:44'),
(17, 1, 'Strategies', 4, '2022-11-26 02:07:42', '2022-11-26 02:07:42'),
(18, 1, 'Models', 4, '2022-11-26 02:07:50', '2022-11-26 02:07:50'),
(19, 1, 'Case Studies', 4, '2022-11-26 02:08:01', '2022-11-26 02:08:01');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `location` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` int(11) NOT NULL DEFAULT 0,
  `profile_photo` varchar(250) DEFAULT NULL,
  `remember_token` varchar(100) 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 `users`
--

INSERT INTO `users` (`id`, `name`, `location`, `email`, `email_verified_at`, `password`, `role`, `profile_photo`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'deepunbabu@gmail.com', NULL, 'deepunbabu@gmail.com', NULL, '$2y$10$/c64Jahx6zeQFSaru0n8f.qKODxYPfGXwViGQ1/k09KcpRMXUodLC', 0, NULL, NULL, '2022-08-04 15:23:50', '2022-08-04 15:23:50'),
(2, 'deepunbabu+1@gmail.com', NULL, 'deepunbabu+1@gmail.com', NULL, '$2y$10$uWxrdNL/AHVuFW0nWahnTOGTHGC/SBJsqKYa85XFAKbtl3NhM2/6u', 0, NULL, NULL, '2022-08-04 15:25:30', '2022-08-04 15:25:30'),
(3, 'deepunbabu+12@gmail.com', NULL, 'deepunbabu+12@gmail.com', NULL, '$2y$10$Pks3WoFAvbNSJdBo/wgGiesj5bZiEYTwJOGcVkELvVFDoWL2l8jQK', 0, NULL, NULL, '2022-08-04 15:30:29', '2022-08-04 15:30:29'),
(4, 'admin', 'Las Vegas, NV, USA', 'admin@onehr.com', NULL, '$2y$10$nMGSOGksJ.CNrlFx9yh./OKD.uTY9NdA05FubemM.PhmEe2pMYy0O', 1, NULL, NULL, '2022-08-04 15:32:20', '2023-02-06 04:54:03'),
(5, 'skn3086+10@gmail.com', 'Kochi, Kerala, India', 'skn3086+10@gmail.com', NULL, '$2y$10$IYT2AlfxA/JKQlxPRkJoiefQcRc3/FER3Se/HwGHiTn106BgF08/i', 0, NULL, NULL, '2022-08-04 21:35:46', '2022-08-04 21:35:59'),
(6, 'skn3086+100@gmail.com', 'Andheri, Maharashtra, India', 'skn3086+100@gmail.com', NULL, '$2y$10$p0P5c90MMNKqZbzFjUY1fOlbLykXfNYXLkLYPHaxADpDKlST/JR.m', 0, NULL, NULL, '2022-08-05 10:15:42', '2022-08-05 10:17:04'),
(7, 'skn3086+101@gmail.com', 'Andheri, Maharashtra, India', 'skn3086+101@gmail.com', NULL, '$2y$10$W5pjBw1nYsYzA7yU6TlWAOyBC4CC/ytYEfE1hICjkuXbmopuLQHMS', 0, NULL, NULL, '2022-08-05 10:24:01', '2022-08-05 10:24:13'),
(8, 'skn3086+30000@gmail.com', 'Kaloor, Kochi, Kerala, India', 'skn3086+30000@gmail.com', NULL, '$2y$10$DpZAZkuIZc/vSsLuoqVvS.62GZvItauFizb6.N0bvo1Uj1mZxAlgq', 0, NULL, NULL, '2022-08-05 18:50:14', '2022-08-05 18:50:29'),
(9, 'skn3086+300@gmail.com', 'Ayodhya, Uttar Pradesh, India', 'skn3086+300@gmail.com', NULL, '$2y$10$bl7ETubbTLuaBaA88XEdkuQxtMhTmRw4hm5kGxF3qfECUJD4xOL56', 0, NULL, NULL, '2022-08-07 11:22:30', '2022-08-07 11:22:46'),
(10, 'skn3086+400@gmail.com', 'Angamaly, Kerala, India', 'skn3086+400@gmail.com', NULL, '$2y$10$FClW9ewix/zCtX4SHkslkOLdJYsh2t/xqC4T29S75X4a2kmYUf2Jm', 0, NULL, NULL, '2022-08-07 11:52:32', '2022-08-07 11:52:55'),
(11, 'skn3086+301@gmail.com', 'Kaloor, Kochi, Kerala, India', 'skn3086+301@gmail.com', NULL, '$2y$10$TspM1vZwLjnn1.LH7SCoA.kdAVmrE5dv4DgwQMCoyAuapxJXLU3.6', 0, NULL, NULL, '2022-08-07 19:10:49', '2022-08-07 19:11:08'),
(12, 'skn3086+1@gmail.com', 'Fort Kochi, Kochi, Kerala, India', 'skn3086+1@gmail.com', NULL, '$2y$10$R/1LpVVJnNM3tX4je8PBV.s00JEAc4TdyeBW1G4zudviPK0eh4u9G', 0, NULL, NULL, '2022-08-07 23:03:15', '2022-08-07 23:03:37'),
(13, 'skn3086+23@gmail.com', 'Cherthala, Kerala, India', 'skn3086+23@gmail.com', NULL, '$2y$10$oYfS3nehiQutdpoYE76aRe1QV1wYDmvDsOIZ0oD/UndmO5NCNz3Ui', 0, NULL, NULL, '2022-08-08 00:05:52', '2022-08-08 00:06:18'),
(14, 'skn3086+10000@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+10000@gmail.com', NULL, '$2y$10$9yTCmwai47emZb0jYmxw2.OGZ4XaBn7e8Ukdb9woWkrOFQ4MLLtaC', 0, NULL, NULL, '2022-08-08 18:54:57', '2022-08-08 18:55:10'),
(16, 'skn3086+40000@gmail.com', 'Palarivattom, Kochi, Kerala, India', 'skn3086+40000@gmail.com', NULL, '$2y$10$UcfRurBIkkEvYwVqdamm.OX/ASoaLnobeODMAkiHQ.Qod32gsDH0i', 0, NULL, NULL, '2022-08-09 18:13:50', '2022-08-09 18:14:11'),
(17, 'richardcowley@me.com', NULL, 'richardcowley@me.com', NULL, '$2y$10$63ho8md6vO3i4woAfEJ.Juxz9ss80ksqhVY2UU9OkMJ3Gfmo2a7wC', 0, NULL, NULL, '2022-08-09 18:23:08', '2022-08-09 18:23:08'),
(18, 'skn3086+3001@gmail.com', 'Bangkok Hospital, Soi Phetchaburi 47 Yaek 10, Bang Kapi, Huai Khwang, Bangkok, Thailand', 'skn3086+3001@gmail.com', NULL, '$2y$10$mFkZnKNLiV1pW7iDiMZz9O3ZL7a5OObAUBNYiDRBMbC2pTxdya2F.', 0, NULL, NULL, '2022-08-09 20:02:24', '2022-08-09 20:02:58'),
(19, 'richard.cowley@workammo.com', 'Phloen Chit Road, Lumphini, Pathum Wan, Bangkok, Thailand', 'richard.cowley@workammo.com', NULL, '$2y$10$Z96Wz7LjtcwXI/Lii1.K7.PMS6fNHh6LKQx5CHm0oCgEAXgN./mOe', 0, NULL, NULL, '2022-08-09 20:14:20', '2022-08-09 20:15:05'),
(20, 'skn3086+1112@gmail.com', 'Bang Na, Bangkok, Thailand', 'skn3086+1112@gmail.com', NULL, '$2y$10$nNBYTXyMLJOjATQrA4QB2OlXUug/cpmVzIZLSeRB0qILSEW6LMBTi', 0, NULL, NULL, '2022-08-10 19:18:11', '2022-08-10 19:18:34'),
(21, 'skn3086+30010@gmail.com', 'Koratty, Kerala, India', 'skn3086+30010@gmail.com', NULL, '$2y$10$ePa07lZbwH3rRqMlx.0T.eUGe92tLGUyLmG937nO8KoCZF0FaqKDO', 0, NULL, NULL, '2022-08-10 21:37:38', '2022-08-10 21:38:00'),
(22, 'skn3086+190221@gmail.com', 'Karuvelipady, Thoppumpady, Kochi, Kerala, India', 'skn3086+190221@gmail.com', NULL, '$2y$10$YY4lTInvrF/85g4BSvkqpuM23p4DuzSIOxG6Lzj5NmlfJjKPIUnke', 0, NULL, NULL, '2022-08-10 23:04:03', '2022-08-10 23:04:16'),
(23, 'deepu.babu+200@sellogs.com', 'Kakkanad Junction, Thrikkakara, Kakkanad, Kerala', 'deepu.babu+200@sellogs.com', NULL, '$2y$10$b/araNY4WwnK/f/.aTi1oeTexQlEMZ3TlGWaZSu9xTvyC1kU8u8zm', 0, NULL, NULL, '2022-08-11 01:45:42', '2022-08-11 01:46:00'),
(24, 'deepunbabu+300@gmail.com', 'Kalady, Kerala, India', 'deepunbabu+300@gmail.com', NULL, '$2y$10$2mLbbUGQGFbMf3pGBAzQ8ueKZgx91wcsL8T8p04BXnXCKZhDz4g9e', 0, NULL, NULL, '2022-08-11 07:28:42', '2022-08-11 07:29:03'),
(25, 'skn3086+30009@gmail.com', 'Chowara, Kerala, India', 'skn3086+30009@gmail.com', NULL, '$2y$10$2ZZFq833to6XLe/VvcSD0.H2L7VQ6J1O0/9yjc8RZTTuQurf.KQEG', 0, NULL, NULL, '2022-08-11 19:14:13', '2022-08-11 19:14:29'),
(26, 'skn3086+30050@gmail.com', 'Ramapuram, Chennai, Tamil Nadu, India', 'skn3086+30050@gmail.com', NULL, '$2y$10$2unEYKAcntvkqL3swWIuYunerValQ1moD9kPvoAadNdo2mJu1.oDm', 0, NULL, NULL, '2022-08-11 21:49:01', '2022-08-11 21:49:16'),
(27, 'skn3086+30051@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+30051@gmail.com', NULL, '$2y$10$vEOq.BwNYTdh2wH99Bcks.bJ99QefsGiaeEk9SGpu0hcgDDWal6YO', 0, NULL, NULL, '2022-08-11 22:13:41', '2022-08-11 22:13:52'),
(28, 'skn3086+2345@gmail.com', 'Edapally, Kochi, Kerala, India', 'skn3086+2345@gmail.com', NULL, '$2y$10$VNzFzBPH19VvgLvX7yXDROwTwMlKnegBf2rozGSGBZ9yTjc.ENCdu', 0, NULL, NULL, '2022-08-12 21:19:05', '2022-08-12 21:19:35'),
(29, 'skn3086+30099@gmail.com', 'Kakkanad, Kerala, India', 'skn3086+30099@gmail.com', NULL, '$2y$10$h3TPhC7TgwdQHsYqEb0CBuqWvJcH.nh7Sm65aQ21uF2AY4LVvJrrW', 0, NULL, NULL, '2022-08-12 21:53:33', '2022-08-12 21:53:46'),
(30, 'skn3086+300120@gmail.com', NULL, 'skn3086+300120@gmail.com', NULL, '$2y$10$Fabv/jobZj.iMkCul1xgd.5Q3b7H4qYaJ7mVa2bV14YznvGoY6Xim', 0, NULL, NULL, '2022-08-12 22:01:15', '2022-08-12 22:01:15'),
(31, 'skn3086+19023@gmail.com', 'Thoppumpady Junction, Thoppumpady, Kochi, Kerala', 'skn3086+19023@gmail.com', NULL, '$2y$10$inFFZoAN5/aoWQgrsI7YKuxDERYl.lPztBITHuweimWQTaoB2RHpS', 0, NULL, NULL, '2022-08-14 20:25:12', '2022-08-14 20:25:36'),
(32, 'skn3086+190229@gmail.com', 'Rajakkad, Kerala, India', 'skn3086+190229@gmail.com', NULL, '$2y$10$yWL5anyg.YcF5bKJRPv2sOjnWIVxj71yN2PfLOJbk6bH8dYDHXsqy', 0, NULL, NULL, '2022-08-17 10:50:37', '2022-08-17 10:50:52'),
(33, 'skn3086+19024@gmail.com', 'Kalavoor, Alappuzha, Kerala, India', 'skn3086+19024@gmail.com', NULL, '$2y$10$fdrc0Ud7sMM986qnOEcLlO85vyvKz8v46jnaltfL5cyyVSRlzS1/S', 0, NULL, NULL, '2022-08-18 05:47:59', '2022-08-18 05:48:18'),
(34, 'skn3086+191022@gmail.com', 'Kolenchery, Kerala, India', 'skn3086+191022@gmail.com', NULL, '$2y$10$Ek9ZsmE4fnu2o4o6n3F13en9LhF32seZn2ZqZWZcjIUsoYe5walNe', 0, NULL, NULL, '2022-08-21 19:55:40', '2022-08-21 19:55:58'),
(35, 'skn3086+119022@gmail.com', 'Kakkanad, Kerala, India', 'skn3086+119022@gmail.com', NULL, '$2y$10$mI.x6SJwMKeINA97PdAuueI8.8slf8.HzVzHbnKfnLvcx43D3wbim', 0, NULL, NULL, '2022-08-22 00:07:22', '2022-08-22 00:07:39'),
(36, 'skn3086+219022@gmail.com', 'Thottappally, Purakkad, Kerala, India', 'skn3086+219022@gmail.com', NULL, '$2y$10$UXiH5qnU0zhLiqyeZuRALOYq0wGD4XOY3U05wKzcrli1e5qHio6Ua', 0, NULL, NULL, '2022-08-25 20:16:09', '2022-08-25 20:16:23'),
(37, 'skn3086+1339022@gmail.com', 'Parramatta NSW, Australia', 'skn3086+1339022@gmail.com', NULL, '$2y$10$IkorZAZLryddgnGbR1k0Dulq.71QvyDQsoTUMS3vJ9I57hbb/XZRK', 0, NULL, NULL, '2022-08-28 00:06:17', '2022-08-28 00:06:32'),
(38, 'skn3086+190722@gmail.com', 'Kattappana, Kerala, India', 'skn3086+190722@gmail.com', NULL, '$2y$10$zbGc2aEUKb8KILcNVAqESOrNenNXsbqOtn6SO7b7GWj4Jr7usFkiu', 0, NULL, NULL, '2022-08-28 00:21:53', '2022-08-28 00:22:08'),
(39, 'skn3086+1944022@gmail.com', 'Karunagappally, Kerala, India', 'skn3086+1944022@gmail.com', NULL, '$2y$10$sEpwWT5Dz5BV4k1UQHnknuRFWhDpF4N5jWNgD6ngitwH7uVe/alSO', 0, NULL, NULL, '2022-08-28 00:36:01', '2022-08-28 00:36:22'),
(40, 'skn3086+1000000@gmail.com', 'Kalamassery, Kochi, Kerala, India', 'skn3086+1000000@gmail.com', NULL, '$2y$10$j83ke/L.xOuOF/VmEBbqeuHPaa82q7xo6OJ/q4HAzVVP7mQaJ61ZK', 0, NULL, NULL, '2022-08-28 01:04:19', '2022-08-28 01:04:35'),
(41, 'skn3086+1904422@gmail.com', 'Thrikkakara, Edappally, Ernakulam, Kerala, India', 'skn3086+1904422@gmail.com', NULL, '$2y$10$/TLvtreJFNbsfjyczGETQOjI8.PMQzEVKkC0J9pt2wjXMh2JNqCvC', 0, NULL, NULL, '2022-08-28 20:19:31', '2022-08-28 20:19:56'),
(42, 'skn3086+1907722@gmail.com', 'Goa Beach Hotel, Baga, Goa, India', 'skn3086+1907722@gmail.com', NULL, '$2y$10$9p1KjD3hjE2Fq8C92vw2uudw9kWRmlHOg5Y0Yv7phrOexR.2j5XFu', 0, NULL, NULL, '2022-08-31 19:43:27', '2022-08-31 19:43:58'),
(43, 'deepunbabu+11@gmail.com', 'Aluva, Kerala, India', 'deepunbabu+11@gmail.com', NULL, '$2y$10$biSUCDYNbr9E7kiFSXHqxeUAooXMLZq2oA2s4auMY3UAXtvpyZAMq', 0, NULL, NULL, '2022-09-03 14:42:47', '2022-09-03 14:43:11'),
(44, 'skn3086+179022@gmail.com', 'Kulathur, Tamil Nadu, India', 'skn3086+179022@gmail.com', NULL, '$2y$10$vSRpF9VzGjqHb/q31FiD7eqw7dbsRiNBgF7/CG7FYfUon9Ip4Br.C', 0, NULL, NULL, '2022-09-03 20:56:57', '2022-09-03 20:57:37'),
(45, 'skn3086+1902332@gmail.com', 'Kochi, Kerala, India', 'skn3086+1902332@gmail.com', NULL, '$2y$10$9zhIX2NuUnUYVBBRzJw0gOw6r4DU.Ei3zBZVCwmKDXRxGOhYkLpPO', 0, NULL, NULL, '2022-09-18 11:05:42', '2022-09-18 11:05:59'),
(46, 'deepunbabu+100@gmail.com', 'Kalamassery, Kochi, Kerala, India', 'deepunbabu+100@gmail.com', NULL, '$2y$10$.LJYF19RQ9ACzAuaWEBwy.rKfISEx8fYDFOa.dGS4jdO94QgL0/OO', 0, NULL, NULL, '2022-09-18 11:40:29', '2022-09-18 11:40:49'),
(47, 'skn3086+110@gmail.com', 'Kozhencherry, Kerala, India', 'skn3086+110@gmail.com', NULL, '$2y$10$IdSF3T0Ihc6lea/xHny3geVLHiwCn.BYI9jtb9Xg7H/kyhn3/V62e', 0, NULL, NULL, '2022-09-18 21:20:08', '2022-09-18 21:20:25'),
(48, 'skn3086+19104422@gmail.com', 'Kochangadi, Chullickal, Kochi, Kerala, India', 'skn3086+19104422@gmail.com', NULL, '$2y$10$QCq8aOC3H8JmCcgE0MH/LuQ0zNi6ZADQ4JwVQBFHVC/wMjB5BB46i', 0, NULL, NULL, '2022-09-24 08:14:33', '2022-09-24 08:14:45'),
(49, 'skn3086+303000@gmail.com', 'Chelari, Thenhipalam, Kerala, India', 'skn3086+303000@gmail.com', NULL, '$2y$10$eMUt8d6fTxpkcRgjj8FkC.xK3./Cdhg26kQnGmr.0hxxw5XVjU/By', 0, NULL, NULL, '2022-09-24 23:40:33', '2022-09-24 23:40:49'),
(50, 'skn3086+32000@gmail.com', 'Kochi, Kerala, India', 'skn3086+32000@gmail.com', NULL, '$2y$10$DfWytjwgP2tH.u9mhOESa.bCDsQBeSOk18Yfgqj04rOr6Cc7mUBWm', 0, NULL, NULL, '2022-11-01 04:36:49', '2022-11-01 04:37:00'),
(51, 'skn3086+1902233@gmail.com', 'Kaladi, Kerala, India', 'skn3086+1902233@gmail.com', NULL, '$2y$10$Uv9iPGSSu/KIROR0vwbWV.Q5cnMMuF2elZOIwrD6stcDCSy7qJ9ey', 0, NULL, NULL, '2022-11-09 00:17:00', '2022-11-09 00:17:14'),
(52, 'skn3086+303232000@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+303232000@gmail.com', NULL, '$2y$10$4XjOvB.xp.zf.OSt1FNNg.GYlbCDiZ1gynpC515OPA.9nmi7St8gm', 0, NULL, NULL, '2022-11-09 00:24:45', '2022-11-09 00:24:57'),
(53, 'skn3086+1332321@gmail.com', 'Vadakkencherry, Kerala, India', 'skn3086+1332321@gmail.com', NULL, '$2y$10$RLVndH/5LqAIbLFscuiyHuvWJyt8UoKqB3fXuPu0QCfJks4VxmiAi', 0, NULL, NULL, '2022-11-10 08:42:24', '2022-11-10 08:42:43'),
(54, 'skn3086+1902532@gmail.com', 'Varkala, Kerala, India', 'skn3086+1902532@gmail.com', NULL, '$2y$10$6zfA79Km2G3ynxvtFxfv1.82xUEkcSWFgx4HBCHni33xqow3GRvxG', 0, NULL, NULL, '2022-11-10 18:09:02', '2022-11-10 18:09:22'),
(55, 'skn3086+4211@gmail.com', 'Bangkok, Thailand', 'skn3086+4211@gmail.com', NULL, '$2y$10$f/Bdxa1Uj0tIcDxmk04wr..dn5jsPm1a5kpG3pd.XuPyGK9olgDUe', 0, NULL, NULL, '2022-11-10 18:48:03', '2022-11-10 18:48:18'),
(56, 'skn3086+13321@gmail.com', 'Kaloor, Kochi, Kerala, India', 'skn3086+13321@gmail.com', NULL, '$2y$10$SUF6o5JPCThU2g1LZ/EkH.XRhfD0TZHIplLqI4fEEyipP7aeMk5vm', 0, NULL, NULL, '2022-11-10 22:47:55', '2022-11-10 22:48:09'),
(57, 'skn3086+132321@gmail.com', 'Pottakuzhi - Mamangalam Road, Mamangalam, Elamakkara, Ernakulam, Kerala, India', 'skn3086+132321@gmail.com', NULL, '$2y$10$EB5cGvxHTN.AH0XZet3PfeTD7zoibVg1Zj1x7be/h9jhI8FxW2NHG', 0, NULL, NULL, '2022-11-11 01:05:12', '2022-11-11 01:05:31'),
(58, 'skn3086+1323321@gmail.com', 'Karunagappally, Kerala, India', 'skn3086+1323321@gmail.com', NULL, '$2y$10$HMWuB.e/ktdyZHRbRQOQpOM0stccQTF5AtmZsatYlTe38gI6JK2.6', 0, NULL, NULL, '2022-11-11 01:06:15', '2022-11-11 01:06:26'),
(59, 'richard.cowley+1@workammo.com', 'KOCHI AIRPORT, Nedumbassery, Kerala, India', 'richard.cowley+1@workammo.com', NULL, '$2y$10$i.HFPE.54pC46Fq00/R/6eVU83xB9dy3ga2F4zV2mpjwMcIYnHB4G', 0, NULL, NULL, '2022-11-11 01:23:34', '2022-11-11 01:24:03'),
(60, 'skn3086+112451@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+112451@gmail.com', NULL, '$2y$10$s6Xa20yXbwgQma0UhY5uMeaaOwHMEZlSGgFeUJdu32odFm/lwyzAu', 0, NULL, NULL, '2022-11-11 10:56:56', '2022-11-11 10:57:13'),
(61, 'skn3086+11312986@gmail.com', 'Vazhakkala, Kochi, Kerala, India', 'skn3086+11312986@gmail.com', NULL, '$2y$10$zoduPDfUzNMpmutCdOjXJOBBkw2IVYIjh7YS7ithE0jtYUdHTRwd.', 0, NULL, NULL, '2022-11-14 02:41:31', '2022-11-14 02:41:56'),
(62, 'skn3086+14455551@gmail.com', 'Varkala, Kerala, India', 'skn3086+14455551@gmail.com', NULL, '$2y$10$53OOkT/.tILQtKLasXQuLuMUQy8754zFIKU8FSH8Ao9FgLZ3VVMdG', 0, NULL, NULL, '2022-11-14 02:56:47', '2022-11-14 02:57:01'),
(63, 'skn3086+10000001@gmail.com', 'Chelari, Thenhipalam, Kerala, India', 'skn3086+10000001@gmail.com', NULL, '$2y$10$SPJ1L5UPaWNHFvT2T1EmhexF0H/PqYGLI2/tDklyGxmX3cBKBVru2', 0, NULL, NULL, '2022-11-16 09:34:17', '2022-11-16 09:34:37'),
(64, 'skn3086+11987654@gmail.com', 'Chowara, Kerala, India', 'skn3086+11987654@gmail.com', NULL, '$2y$10$8OFLZwILV49d4ioABf1oG.1aVf6M3kSGqwmc8jfRv93NMhWYP6flW', 0, NULL, NULL, '2022-11-17 19:15:58', '2022-11-17 19:16:15'),
(65, 'skn3086+1010@gmail.com', 'Kaloor, Kochi, Kerala, India', 'skn3086+1010@gmail.com', NULL, '$2y$10$yX/1fgm75Hc2P8jf1vVJ0uUXDzIohOHKaBHKQe5dGgjD/mZvv/7pi', 0, NULL, NULL, '2022-11-17 21:38:40', '2022-11-17 21:38:52'),
(66, 'skn3086+100100@gmail.com', 'Chalakudy, Kerala, India', 'skn3086+100100@gmail.com', NULL, '$2y$10$h/yTeMFR73PoWVsIHIp07u6tf95D1CyGiViWzD1YoD5gpRfv2c8mK', 0, NULL, NULL, '2022-11-18 01:32:29', '2022-11-18 01:32:43'),
(67, 'skn3086+2020@gmail.com', 'Angamaly, Kerala, India', 'skn3086+2020@gmail.com', NULL, '$2y$10$Qfwz/UMtj2aoSWwYj5oDUerMm/3DdHLXn.cI0cyeer6rJFFHXFQMu', 0, NULL, NULL, '2022-11-19 02:33:28', '2022-11-19 02:33:44'),
(68, 'skn3086+3030@gmail.com', 'Kalpathy, Palakkad, Kerala, India', 'skn3086+3030@gmail.com', NULL, '$2y$10$Bn.gfhrVOetA25aLAm.BJeJh8Ngbt//kjpJHeJRW7jQb0oUAFpknu', 0, NULL, NULL, '2022-11-19 20:01:23', '2022-11-19 20:01:33'),
(69, 'Sanil', 'Athani, Kerala, India', 'skn3086+4040@gmail.com', NULL, '$2y$10$QGDWEZRa4EbUj25vOew77u8J19VHYD04wznvaXC2YiI7M2Xi1wo32', 0, '1681356548407sanil-photo-200.jpg', NULL, '2022-11-20 18:29:38', '2023-04-12 21:59:08'),
(70, 'skn3086+14561222@gmail.com', 'Madurai, Tamil Nadu, India', 'skn3086+14561222@gmail.com', NULL, '$2y$10$.LfpgaYVhfidmVG4J07UNOsAa0qz69VS3CiNYFp.1JGLdx6UzxAzC', 0, NULL, NULL, '2022-11-21 06:16:34', '2022-11-21 06:16:46'),
(71, 'skn3086+30300@gmail.com', 'Koyilandy, Kerala, India', 'skn3086+30300@gmail.com', NULL, '$2y$10$a8exG7RKRhaRnk5IVF6CUOSijMHV580IuTwrFdqC4vZVXnlmtvvPS', 0, NULL, NULL, '2022-11-21 19:04:47', '2022-11-21 19:05:07'),
(72, 'Sanil', 'Kalamassery, Kochi, Kerala, India', 'skn3086+40400@gmail.com', NULL, '$2y$10$fOqCAbZx8BWT9Myu1up2B.B49thJYKwOI2DoeRymm4X6OysVJ03n.', 0, NULL, NULL, '2022-11-23 07:14:53', '2023-02-07 06:38:25'),
(73, 'richard.cowley+2@workammo.com', 'Kulathoor, Thiruvananthapuram, Kerala, India', 'richard.cowley+2@workammo.com', NULL, '$2y$10$NZIy/JaUfZrjErqZ.HRHbeB0ww5VRuA9SpG4AWeoS3oY2Ci4Gj.e.', 0, NULL, NULL, '2022-11-23 19:24:59', '2022-11-23 19:25:22'),
(74, 'skn3086+50500@gmail.com', 'Alathur, Kerala, India', 'skn3086+50500@gmail.com', NULL, '$2y$10$MAmO3AZ28iJRrQ94qwy7geZyyzMaoAHFMXodFAdighqJw1Z2GmrYe', 0, NULL, NULL, '2022-11-26 01:07:37', '2022-11-26 01:07:56'),
(75, 'skn3086+1100@gmail.com', 'Kalamassery, Kochi, Kerala, India', 'skn3086+1100@gmail.com', NULL, '$2y$10$2KEwmp866.Lw4y0VrT6ehOMtQcdvxMgwOuaRazWXbZYuyBCbP7Yze', 0, NULL, NULL, '2022-11-26 01:48:35', '2022-11-26 01:48:49'),
(76, 'skn3086+60600@gmail.com', 'Kakkanad, Kerala, India', 'skn3086+60600@gmail.com', NULL, '$2y$10$BN91vgQjGJaBNfdRgjVYGepX5JAUHaLXomCEdBXkuouydeabO6yRS', 0, NULL, NULL, '2022-11-27 22:54:00', '2022-11-27 22:54:50'),
(77, 'deepunbabu+1234@gmail.com', 'Kalupur Railway Station Road, Kapasia Bazar, Sakar Bazzar, Kalupur, Ahmedabad, Gujarat, India', 'deepunbabu+1234@gmail.com', NULL, '$2y$10$s0hOBwNjFPnMufvF2TzJoumDibAj9/JAAUDqnIyS.UvflGT4Fb/Zq', 0, NULL, NULL, '2022-11-29 07:50:58', '2022-11-29 07:51:09'),
(78, 'skn3086+10001000@gmail.com', 'Kurumassery, Kurumaseri, Kerala, India', 'skn3086+10001000@gmail.com', NULL, '$2y$10$FGPPnvURHqSUgJ4cgPQfZu6pKuAV0DGXxa6X.cXqRqBc/yVsHjAXy', 0, NULL, NULL, '2022-11-29 18:30:19', '2022-11-29 18:31:09'),
(79, 'skn3086+8080@gmail.com', 'Koratty, Kerala, India', 'skn3086+8080@gmail.com', NULL, '$2y$10$/sacaPRr5Mps8SXxCgB4B./frwfGKUYRWu9F9vibMkFOKhyTA1zm.', 0, NULL, NULL, '2022-11-30 19:01:19', '2022-11-30 19:05:10'),
(80, 'skn3086+9090@gmail.com', 'Perumbavoor, Kerala, India', 'skn3086+9090@gmail.com', NULL, '$2y$10$mnp5gNT..nn4aZ6p9Ic5MursO7a7QWokRJ6CKKjtFGk7UIVPETxoa', 0, NULL, NULL, '2022-12-03 06:43:01', '2022-12-03 06:43:13'),
(81, 'skn3086+990990@gmail.com', 'Kothamangalam, Kerala, India', 'skn3086+990990@gmail.com', NULL, '$2y$10$xplUrKn2JLDorHx5k5iYbu/0SbqU6neyhBwlLIpybe3zqTGEnSLQ6', 0, NULL, NULL, '2022-12-05 06:36:42', '2022-12-05 06:37:02'),
(82, 'skn3086+99909990@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+99909990@gmail.com', NULL, '$2y$10$AUii4eQFohnxVEVUlmOyLO.7z6vQYKUUHZaCoMQakwl.9N1r8jsKe', 0, NULL, NULL, '2022-12-05 06:38:32', '2022-12-05 06:38:45'),
(83, 'skn3086+3086@gmail.com', 'Koruthodu, Kerala, India', 'skn3086+3086@gmail.com', NULL, '$2y$10$SgVdpFTCoAd9MXSaDJHvXObCuOSTxhtXwsOlGcO6yzHYDxOkHZHAW', 0, NULL, NULL, '2022-12-13 00:41:56', '2022-12-13 00:42:09'),
(84, 'skn3086+30861@gmail.com', 'Kalamassery, Kochi, Kerala, India', 'skn3086+30861@gmail.com', NULL, '$2y$10$KDKJMAyRirFoVOUsbMS9p.4pXJdLmAP9FTCodEdBwMlyLTeSVgYi6', 0, NULL, NULL, '2022-12-13 00:43:40', '2022-12-13 00:43:52'),
(85, 'skn3086+30862@gmail.com', 'Kurumassery, Kurumaseri, Kerala, India', 'skn3086+30862@gmail.com', NULL, '$2y$10$EZRVpGHyYxsne2zVH7oDzOqt/slafHDF/jrhqM5xAx9Baj4MK46LK', 0, NULL, NULL, '2022-12-13 03:31:41', '2022-12-13 03:31:54'),
(86, 'skn3086+30004@gmail.com', 'Kacheripady, Kochi, Kerala, India', 'skn3086+30004@gmail.com', NULL, '$2y$10$rwu6K57PWbS3/hl8B7nkMu6WSu/yydu.SDhqga04vIuyecdpzNOrS', 0, NULL, NULL, '2022-12-13 05:25:29', '2022-12-13 05:25:40'),
(87, 'skn3086+404001@gmail.com', 'Karaikudi, Tamil Nadu, India', 'skn3086+404001@gmail.com', NULL, '$2y$10$WMH/.KbgbsuC7CSgrX52R.j2viwDBwnrmQuYvnpRcmJHsHlFv5JD.', 0, NULL, NULL, '2022-12-14 19:17:55', '2022-12-14 19:18:10'),
(88, 'skn3086+404002@gmail.com', 'Karukappilly, Kerala, India', 'skn3086+404002@gmail.com', NULL, '$2y$10$DSujHmzoniG8qS6r0wtnlu11UkfACHNasci8NI8HiZR.I8D78mrDq', 0, NULL, NULL, '2022-12-15 19:10:00', '2022-12-15 19:10:12'),
(89, 'skn3086+404003@gmail.com', 'Ponnani, Kerala, India', 'skn3086+404003@gmail.com', NULL, '$2y$10$o9bzcOj5izVRjih5x2uuEOOXIaJDIXQoLExfmmJD7McNCuWaEl7hm', 0, NULL, NULL, '2022-12-15 19:21:15', '2022-12-15 19:21:32'),
(90, 'skn3086+4040900@gmail.com', 'Thirunelly, Kerala, India', 'skn3086+4040900@gmail.com', NULL, '$2y$10$8qC6PD9sc4og5Fa.6qMy9eE5gwGJcXbEzD0s28GB7rhrB5gs8/ES2', 0, NULL, NULL, '2022-12-19 08:38:27', '2022-12-19 08:38:41'),
(91, 'skn3086+404900@gmail.com', 'Rajasthan University Campus, Talvandi, Jaipur, Rajasthan, India', 'skn3086+404900@gmail.com', NULL, '$2y$10$OuJpyUW7kKQDYhJg2dXLSObmqTP4ATH09eUR5eoPomK4mr.Q97QT6', 0, NULL, NULL, '2022-12-19 08:40:30', '2022-12-19 08:40:44'),
(92, 'skn3086+4043020@gmail.com', 'Cherai Beach, Vypin, Kochi, Kerala', 'skn3086+4043020@gmail.com', NULL, '$2y$10$ae5.daAPjXW7V7BpwS9RmuWAFwVCXbEQVaWzQCByASexT8fejuvqi', 0, NULL, NULL, '2022-12-20 18:40:28', '2022-12-20 18:40:39'),
(93, 'skn3086+a1@gmail.com', 'Athirappilly, Vettilappara, Pariyaram, Kerala, India', 'skn3086+a1@gmail.com', NULL, '$2y$10$DuPufcz7hTo/K73.fLIU1.WwkvTh4fhw/MvOt/kTQt0HIbXekKCOu', 0, NULL, NULL, '2023-01-02 18:45:12', '2023-01-02 18:45:27'),
(94, 'skn3086+800800@gmail.com', 'Mundakayam, Kerala, India', 'skn3086+800800@gmail.com', NULL, '$2y$10$sQ4Gl1fkfELu86Ldcbg84uc.71NHf4PbwBUwoOUqZOdaGB4F5zqtu', 0, NULL, NULL, '2023-01-26 09:54:56', '2023-01-26 09:55:09'),
(95, 'skn3086+800801@gmail.com', 'Kaloor, Kochi, Kerala, India', 'skn3086+800801@gmail.com', NULL, '$2y$10$4Gp0axq9HBuJ1NaXNXPJQ.jy9l01yR.z4CyZw4u9kB4MbSYRl2OTC', 0, NULL, NULL, '2023-01-27 00:38:12', '2023-01-27 00:39:46'),
(96, 'skn3086+800803@gmail.com', 'Chalakudy, Kerala, India', 'skn3086+800803@gmail.com', NULL, '$2y$10$6Q8n7yavT3VTl2A7vBuhiO.6L2zqrvXn/ydrZ/G4XXypaNfxbEKtq', 0, NULL, NULL, '2023-01-27 07:07:39', '2023-01-27 07:07:51'),
(97, 'deepunbabu+1000@gmail.com', 'Perumbavoor, Kerala, India', 'deepunbabu+1000@gmail.com', NULL, '$2y$10$uhQEqQ7jKCfvyQ0.j1FWFekwE3q6KW5spc5Gv5pR5uuRHvFD1pYka', 0, NULL, NULL, '2023-01-27 12:12:14', '2023-01-27 12:12:41'),
(98, 'skn3086+800804@gmail.com', 'Sultan Bathery, Kerala, India', 'skn3086+800804@gmail.com', NULL, '$2y$10$Q2dAR6p4fJ.JeftAohMjFO7mkR4tpwYEngL5/yTBDG5Gy3/8UUnuy', 0, NULL, NULL, '2023-01-27 18:46:58', '2023-01-27 18:47:52'),
(99, 'skn3086+800805@gmail.com', 'Munnar, Kerala, India', 'skn3086+800805@gmail.com', NULL, '$2y$10$0loyV8zXx1PhiTU32ca9YunKVE0es8XkH3Ec4qtB/rYTKBdGmwo6q', 0, NULL, NULL, '2023-01-27 18:54:53', '2023-01-27 18:55:47'),
(100, 'skn3086+800807@gmail.com', 'Chalakudy, Kerala, India', 'skn3086+800807@gmail.com', NULL, '$2y$10$Qz1OJ2BRxHwgWU/jja5.wuSRMda2gbbAMoXhvKEAJU/Fd7aJxpks6', 0, NULL, NULL, '2023-01-27 19:01:18', '2023-01-27 19:01:36'),
(101, 'skn3086+800806@gmail.com', 'Chottanikkara, Thrippunithura, Ernakulam, Kerala, India', 'skn3086+800806@gmail.com', NULL, '$2y$10$cplm0TP5IaHdh0ySbitHn.OZVnIVIJu7HECuY99/jlpsbakRz060m', 0, NULL, NULL, '2023-01-27 19:58:36', '2023-01-27 19:58:49'),
(102, 'skn3086+800808@gmail.com', 'Keerikkad, Kerala, India', 'skn3086+800808@gmail.com', NULL, '$2y$10$a4D887St2pBB4DmN9J0gJ.75Z6hww3qmQqLQFx.in1rYmnduxvg2a', 0, NULL, NULL, '2023-01-29 02:43:59', '2023-01-29 02:44:13'),
(103, 'deepunbabu+0987@gmail.com', 'Kalyan, Maharashtra, India', 'deepunbabu+0987@gmail.com', NULL, '$2y$10$.ODBiiI9cazhzAHQDAPM8.0wJ3HvtaRYrksG.r0OsxnqbOtj5gkVm', 0, NULL, NULL, '2023-02-01 13:28:37', '2023-02-01 13:28:49'),
(104, 'Richard Cowley', 'Koyilandy, Kerala, India', 'skn3086+800810@gmail.com', NULL, '$2y$10$sJID2VIKMDWzvD4yQQ0BcOOd1G38RQioOiw2t1wV/N8WKoVV/rNwe', 0, NULL, NULL, '2023-02-08 18:35:15', '2023-02-08 18:40:40'),
(105, 'skn3086+800811@gmail.com', 'Gokarna, Karnataka, India', 'skn3086+800811@gmail.com', NULL, '$2y$10$5JIg7y9cpn/k4fYvWKZSc.APq6NoIRlaWN1Np68K7Lw92XCUYNIC2', 0, NULL, NULL, '2023-02-08 18:47:14', '2023-02-08 18:47:30'),
(106, 'skn3086+800812@gmail.com', 'Mattancherry, Kochi, Kerala, India', 'skn3086+800812@gmail.com', NULL, '$2y$10$gW3GBrHMF2LQpGTtzDnFyuIK8lbaq9RNisKB8LtXg1Hi5tcRTijFC', 0, NULL, NULL, '2023-02-08 18:50:18', '2023-02-08 18:51:47'),
(107, 'skn3086+800813@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+800813@gmail.com', NULL, '$2y$10$x6QnQvV7K4I4qzOnaCsjauYSO9tbbLAevSvHuTAdJ69Ueoi0P2Gc.', 0, NULL, NULL, '2023-02-08 18:56:41', '2023-02-08 18:56:58'),
(108, 'skn3086+800814@gmail.com', 'Chemmannur, Kerala, India', 'skn3086+800814@gmail.com', NULL, '$2y$10$Wt56f4V8hJpw5DWP3FarIOC/EyEf8fgPymyf/PENQDBLrkODrBOda', 0, NULL, NULL, '2023-02-08 19:00:00', '2023-02-08 19:00:15'),
(109, 'skn3086+800815@gmail.com', 'Thammanam, Ernakulam, Kerala, India', 'skn3086+800815@gmail.com', NULL, '$2y$10$rjUMVxoKj7.A9UyudVGMpOP7j7yduAGboZXbJdXPa5NROkUlII0e.', 0, NULL, NULL, '2023-02-08 23:11:24', '2023-02-08 23:12:51'),
(110, 'skn3086+800816@gmail.com', 'Munnar Top Station, View Point, View Point Path, Munnar, Kerala, India', 'skn3086+800816@gmail.com', NULL, '$2y$10$1BPNzAysFsHwZjrTnRcFce5xTq0MgmmUSQ45ohQHlDtkfYQqZpdUu', 0, NULL, NULL, '2023-02-08 23:19:07', '2023-02-08 23:21:02'),
(111, 'Suresh', 'Karukutty, Kerala, India', 'skn3086+800820@gmail.com', NULL, '$2y$10$gJ7TnlAru6ZfGrUkZvHwzO9ko63fDmAuE/fwlhXSh51YhNwa4.iSK', 0, NULL, NULL, '2023-02-09 03:07:18', '2023-02-09 03:15:09'),
(112, 'skn3086+991@gmail.com', 'Kadukutty, Kerala, India', 'skn3086+991@gmail.com', NULL, '$2y$10$pGTByaJgRAFJ1IvJm..Vn.PgTgcWVNkHJLT/U.EwRCyrekVHccdUy', 0, NULL, NULL, '2023-02-09 04:15:00', '2023-02-09 04:15:20'),
(113, 'Richard', 'Mananthavady, Kerala, India', 'skn3086+409999@gmail.com', NULL, '$2y$10$WwLhP1TgNibvFcqNe/Lo.OBetGLRKfmPYydeNcMMCR8WHHXFzh28C', 0, NULL, NULL, '2023-02-09 18:49:51', '2023-02-09 18:54:56'),
(114, 'skn3086+5001@gmail.com', 'Vathuruthy, Willingdon Island, Kochi, Kerala, India', 'skn3086+5001@gmail.com', NULL, '$2y$10$4zLFmStk556e8ijo02a3rezIL3OF6cePQLX2OrIZTBZpSQHTWnrmG', 0, NULL, NULL, '2023-02-10 09:30:59', '2023-02-10 09:32:00'),
(115, 'skn3086+40899@gmail.com', 'Vypin, Fort Vypin, Puthuvype, Kochi, Kerala', 'skn3086+40899@gmail.com', NULL, '$2y$10$SiprVgLqid7JTID/.LkDP.RgLL8HqgikXm1f/tT.3rYbc9zSEepJW', 0, NULL, NULL, '2023-02-15 18:34:40', '2023-02-15 18:34:55'),
(116, 'Sushil Khanna', 'Karunagappally, Kerala, India', 'skn3086+40400900@gmail.com', NULL, '$2y$10$YevsFVSadVi/187uk3eA6uoY.LiKZox1q7gruBdNcI8YAz8kYTNu6', 0, NULL, NULL, '2023-03-10 21:32:04', '2023-03-10 21:38:50'),
(117, 'skn3086+40400123@gmail.com', 'Sreekariyam, Thiruvananthapuram, Kerala, India', 'skn3086+40400123@gmail.com', NULL, '$2y$10$uGxNBXF.pdV8T59v8USLEe.ECfR5AZSTeF4Hb8CilAcaI5b9KbU9e', 0, NULL, NULL, '2023-03-20 18:10:10', '2023-03-20 18:10:26'),
(118, 'skn3086+4041@gmail.com', 'Kozhikode, Kerala, India', 'skn3086+4041@gmail.com', NULL, '$2y$10$iIv7YbSA9Vzhs3zd5DkKB.WGMnoXy2YggRBJ0XIGKc/fxN4XW1w.S', 0, NULL, NULL, '2023-05-02 01:15:35', '2023-05-02 01:15:47'),
(119, 'skn3086+2000@gmail.com', 'Rameswaram, Tamil Nadu, India', 'skn3086+2000@gmail.com', NULL, '$2y$10$qzRFdyvvdnkf7pukg8qfk.dcFUH3p9Bp1nJUDnc77bG.glAp715Jy', 0, NULL, NULL, '2023-07-13 19:33:43', '2023-07-13 19:34:01'),
(120, 'pradeepvakkayil+100@gmail.com', 'Chalakudy, Kerala, India', 'pradeepvakkayil+100@gmail.com', NULL, '$2y$10$CQ.QpT5wcyU5JECFLYLbpeoJjKO0c0AdugDic/Owh4.NUTNGLDolS', 0, NULL, NULL, '2023-10-17 05:09:06', '2023-10-17 05:09:25');

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

--
-- Table structure for table `user_verification_status`
--

CREATE TABLE `user_verification_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `mobile_number` tinyint(1) NOT NULL DEFAULT 0,
  `location` tinyint(1) NOT NULL DEFAULT 0,
  `evaluation` 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 `user_verification_status`
--

INSERT INTO `user_verification_status` (`id`, `member_id`, `mobile_number`, `location`, `evaluation`, `created_at`, `updated_at`) VALUES
(1, 4, 2, 1, 1, '2022-08-04 15:32:20', '2023-02-09 00:03:16'),
(2, 5, 2, 1, 1, '2022-08-04 21:35:46', '2022-08-04 21:36:08'),
(3, 6, 2, 0, 0, '2022-08-05 10:15:42', '2022-08-05 10:15:46'),
(4, 7, 2, 1, 1, '2022-08-05 10:24:01', '2022-08-05 10:24:59'),
(5, 8, 2, 1, 1, '2022-08-05 18:50:14', '2022-08-05 18:50:38'),
(6, 9, 2, 1, 1, '2022-08-07 11:22:30', '2022-08-07 11:22:58'),
(7, 10, 2, 1, 1, '2022-08-07 11:52:32', '2022-08-07 11:53:04'),
(8, 11, 2, 1, 1, '2022-08-07 19:10:49', '2022-08-07 19:11:23'),
(9, 12, 2, 1, 1, '2022-08-07 23:03:15', '2022-08-07 23:03:48'),
(10, 13, 2, 1, 1, '2022-08-08 00:05:52', '2022-08-08 00:06:35'),
(11, 14, 2, 1, 1, '2022-08-08 18:54:57', '2022-08-08 18:55:31'),
(12, 16, 2, 1, 1, '2022-08-09 18:13:50', '2022-08-09 18:14:20'),
(13, 17, 0, 0, 0, '2022-08-09 18:23:08', '2022-08-09 18:23:08'),
(14, 18, 2, 1, 1, '2022-08-09 20:02:24', '2022-08-09 20:05:35'),
(15, 19, 2, 1, 1, '2022-08-09 20:14:20', '2022-08-09 20:15:35'),
(16, 20, 2, 1, 1, '2022-08-10 19:18:11', '2022-08-10 19:18:46'),
(17, 21, 2, 1, 1, '2022-08-10 21:37:38', '2022-08-10 21:38:09'),
(18, 22, 2, 1, 1, '2022-08-10 23:04:03', '2022-08-10 23:04:25'),
(19, 23, 2, 1, 1, '2022-08-11 01:45:42', '2022-08-11 01:46:47'),
(20, 24, 2, 1, 1, '2022-08-11 07:28:42', '2022-08-11 07:29:16'),
(21, 25, 2, 1, 1, '2022-08-11 19:14:13', '2022-08-11 19:14:53'),
(22, 26, 2, 1, 1, '2022-08-11 21:49:01', '2022-08-11 21:49:27'),
(23, 27, 2, 1, 1, '2022-08-11 22:13:41', '2022-08-11 22:14:00'),
(24, 28, 2, 1, 1, '2022-08-12 21:19:05', '2022-08-12 21:19:49'),
(25, 29, 2, 1, 1, '2022-08-12 21:53:33', '2022-08-12 21:54:01'),
(26, 30, 2, 0, 0, '2022-08-12 22:01:15', '2022-08-12 22:01:19'),
(27, 31, 2, 1, 1, '2022-08-14 20:25:12', '2022-08-14 20:25:46'),
(28, 32, 2, 1, 1, '2022-08-17 10:50:37', '2022-08-17 10:51:01'),
(29, 33, 2, 1, 1, '2022-08-18 05:47:59', '2022-08-18 05:48:27'),
(30, 34, 2, 1, 1, '2022-08-21 19:55:40', '2022-08-21 19:56:08'),
(31, 35, 2, 1, 1, '2022-08-22 00:07:22', '2022-08-22 00:07:48'),
(32, 36, 2, 1, 1, '2022-08-25 20:16:09', '2022-08-25 20:16:40'),
(33, 37, 2, 1, 1, '2022-08-28 00:06:17', '2022-08-28 00:06:45'),
(34, 38, 2, 1, 1, '2022-08-28 00:21:53', '2022-08-28 00:22:19'),
(35, 39, 2, 1, 1, '2022-08-28 00:36:01', '2022-08-28 00:36:33'),
(36, 40, 2, 1, 1, '2022-08-28 01:04:19', '2022-08-28 01:07:09'),
(37, 41, 2, 1, 1, '2022-08-28 20:19:31', '2022-08-28 20:20:05'),
(38, 42, 2, 1, 1, '2022-08-31 19:43:27', '2022-08-31 19:44:09'),
(39, 43, 2, 0, 0, '2022-09-03 14:42:47', '2022-09-03 14:42:50'),
(40, 44, 2, 1, 1, '2022-09-03 20:56:57', '2022-09-03 20:58:17'),
(41, 45, 2, 1, 1, '2022-09-18 11:05:42', '2022-09-18 11:06:09'),
(42, 46, 2, 1, 1, '2022-09-18 11:40:29', '2022-09-18 11:58:11'),
(43, 47, 2, 1, 1, '2022-09-18 21:20:08', '2022-09-18 21:43:09'),
(44, 48, 2, 1, 1, '2022-09-24 08:14:33', '2022-09-24 08:16:48'),
(45, 49, 2, 1, 1, '2022-09-24 23:40:33', '2022-09-24 23:45:26'),
(46, 50, 2, 1, 1, '2022-11-01 04:36:49', '2022-11-01 04:38:05'),
(47, 51, 2, 1, 1, '2022-11-09 00:17:00', '2022-11-09 00:19:53'),
(48, 52, 2, 1, 1, '2022-11-09 00:24:45', '2022-11-09 00:25:06'),
(49, 53, 2, 1, 1, '2022-11-10 08:42:24', '2022-11-10 08:44:02'),
(50, 54, 2, 1, 1, '2022-11-10 18:09:02', '2022-11-10 18:10:38'),
(51, 55, 2, 1, 1, '2022-11-10 18:48:03', '2022-11-10 18:50:00'),
(52, 56, 2, 1, 1, '2022-11-10 22:47:55', '2022-11-10 22:50:57'),
(53, 57, 2, 1, 0, '2022-11-11 01:05:12', '2022-11-11 01:05:36'),
(54, 58, 2, 1, 1, '2022-11-11 01:06:15', '2022-11-11 01:07:33'),
(55, 59, 2, 1, 1, '2022-11-11 01:23:34', '2022-11-11 01:25:34'),
(56, 60, 2, 1, 1, '2022-11-11 10:56:56', '2022-11-11 10:57:24'),
(57, 61, 2, 1, 1, '2022-11-14 02:41:31', '2022-11-14 02:47:52'),
(58, 62, 2, 1, 1, '2022-11-14 02:56:47', '2022-11-14 02:58:28'),
(59, 63, 2, 1, 1, '2022-11-16 09:34:17', '2022-11-16 09:36:10'),
(60, 64, 2, 1, 1, '2022-11-17 19:15:58', '2022-11-17 19:22:00'),
(61, 65, 2, 1, 1, '2022-11-17 21:38:40', '2022-11-17 21:39:02'),
(62, 66, 2, 1, 1, '2022-11-18 01:32:29', '2022-11-18 01:33:56'),
(63, 67, 2, 1, 1, '2022-11-19 02:33:28', '2022-11-19 02:52:46'),
(64, 68, 2, 1, 1, '2022-11-19 20:01:23', '2022-11-19 20:01:41'),
(65, 69, 2, 1, 1, '2022-11-20 18:29:38', '2023-04-27 23:14:07'),
(66, 70, 2, 1, 1, '2022-11-21 06:16:34', '2022-11-21 06:18:40'),
(67, 71, 2, 1, 1, '2022-11-21 19:04:47', '2022-11-21 19:06:51'),
(68, 72, 2, 1, 1, '2022-11-23 07:14:53', '2023-03-19 18:28:55'),
(69, 73, 2, 1, 1, '2022-11-23 19:24:59', '2022-11-23 19:26:54'),
(70, 74, 2, 1, 1, '2022-11-26 01:07:37', '2022-11-26 01:09:04'),
(71, 75, 2, 1, 1, '2022-11-26 01:48:35', '2022-11-26 01:56:12'),
(72, 76, 2, 1, 1, '2022-11-27 22:54:00', '2022-11-27 22:58:14'),
(73, 77, 2, 1, 1, '2022-11-29 07:50:58', '2022-11-29 07:51:22'),
(74, 78, 2, 1, 1, '2022-11-29 18:30:19', '2022-11-29 18:35:33'),
(75, 79, 2, 1, 1, '2022-11-30 19:01:19', '2022-11-30 19:07:33'),
(76, 80, 2, 1, 1, '2022-12-03 06:43:01', '2022-12-03 06:45:28'),
(77, 81, 2, 1, 1, '2022-12-05 06:36:42', '2022-12-05 06:37:24'),
(78, 82, 2, 1, 1, '2022-12-05 06:38:32', '2022-12-05 06:43:31'),
(79, 83, 2, 1, 1, '2022-12-13 00:41:56', '2022-12-13 00:42:21'),
(80, 84, 2, 1, 1, '2022-12-13 00:43:40', '2022-12-13 00:44:07'),
(81, 85, 2, 1, 0, '2022-12-13 03:31:41', '2022-12-13 03:31:57'),
(82, 86, 2, 1, 1, '2022-12-13 05:25:29', '2022-12-13 05:26:00'),
(83, 87, 2, 1, 1, '2022-12-14 19:17:55', '2022-12-14 19:21:03'),
(84, 88, 2, 1, 1, '2022-12-15 19:10:00', '2022-12-15 19:11:49'),
(85, 89, 2, 1, 1, '2022-12-15 19:21:15', '2022-12-15 19:22:29'),
(86, 90, 2, 1, 1, '2022-12-19 08:38:27', '2022-12-19 08:38:50'),
(87, 91, 2, 1, 0, '2022-12-19 08:40:30', '2022-12-19 08:40:48'),
(88, 92, 2, 1, 0, '2022-12-20 18:40:28', '2022-12-20 18:40:43'),
(89, 93, 2, 1, 1, '2023-01-02 18:45:12', '2023-01-02 18:46:58'),
(90, 94, 2, 1, 1, '2023-01-26 09:54:56', '2023-02-09 00:32:36'),
(91, 95, 2, 1, 1, '2023-01-27 00:38:12', '2023-01-27 00:40:16'),
(92, 96, 2, 1, 1, '2023-01-27 07:07:39', '2023-01-27 07:08:04'),
(93, 97, 2, 1, 1, '2023-01-27 12:12:14', '2023-01-27 12:12:46'),
(94, 98, 2, 1, 1, '2023-01-27 18:46:58', '2023-01-27 18:49:24'),
(95, 99, 2, 1, 1, '2023-01-27 18:54:53', '2023-01-27 18:56:38'),
(96, 100, 2, 1, 1, '2023-01-27 19:01:18', '2023-01-27 19:03:29'),
(97, 101, 2, 1, 1, '2023-01-27 19:58:36', '2023-01-27 20:00:08'),
(98, 102, 2, 1, 1, '2023-01-29 02:43:59', '2023-01-29 02:44:23'),
(99, 103, 2, 1, 1, '2023-02-01 13:28:38', '2023-02-01 13:28:56'),
(100, 104, 2, 1, 1, '2023-02-08 18:35:15', '2023-02-08 18:42:54'),
(101, 105, 2, 1, 1, '2023-02-08 18:47:14', '2023-02-08 18:47:45'),
(102, 106, 2, 1, 1, '2023-02-08 18:50:18', '2023-02-08 18:54:10'),
(103, 107, 2, 1, 1, '2023-02-08 18:56:41', '2023-02-08 18:58:20'),
(104, 108, 2, 1, 1, '2023-02-08 19:00:00', '2023-02-08 19:01:39'),
(105, 109, 2, 1, 1, '2023-02-08 23:11:24', '2023-02-08 23:16:41'),
(106, 110, 2, 1, 1, '2023-02-08 23:19:07', '2023-02-08 23:22:06'),
(107, 111, 2, 1, 1, '2023-02-09 03:07:18', '2023-02-09 03:08:45'),
(108, 112, 2, 1, 1, '2023-02-09 04:15:00', '2023-02-09 04:18:20'),
(109, 113, 2, 1, 1, '2023-02-09 18:49:51', '2023-02-09 18:51:55'),
(110, 114, 2, 1, 1, '2023-02-10 09:30:59', '2023-02-10 09:46:16'),
(111, 115, 2, 1, 1, '2023-02-15 18:34:40', '2023-02-15 18:36:19'),
(112, 116, 2, 1, 1, '2023-03-10 21:32:04', '2023-03-10 21:34:34'),
(113, 117, 2, 1, 1, '2023-03-20 18:10:10', '2023-03-20 18:12:02'),
(114, 118, 2, 1, 1, '2023-05-02 01:15:35', '2023-05-02 01:16:21'),
(115, 119, 2, 1, 1, '2023-07-13 19:33:43', '2023-07-13 19:35:52'),
(116, 120, 2, 1, 1, '2023-10-17 05:09:06', '2023-10-17 05:15:00');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `event`
--
ALTER TABLE `event`
  ADD PRIMARY KEY (`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 `fa_acc_maturity_level`
--
ALTER TABLE `fa_acc_maturity_level`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `discussion_member_post`
--
ALTER TABLE `discussion_member_post`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `post_activities_count`
--
ALTER TABLE `post_activities_count`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `user_verification_status`
--
ALTER TABLE `user_verification_status`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;
COMMIT;

