INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `subject_id`, `causer_type`, `causer_id`, `properties`, `created_at`, `updated_at`) VALUES
(1508, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 10:54:50', '2024-04-25 10:54:50'),
(1509, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25 12:25:00\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 12:35:01\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25T10:25:00.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T10:35:01.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-25 10:54:50', '2024-04-25 10:54:50'),
(1510, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-status\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25 12:54:50\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"student_no\": \"67934946\", \"updated_at\": \"2024-04-25 12:54:50\", \"std_reg_status_id\": \"6\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25T10:54:50.000000Z\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"student_no\": \"67934946\", \"updated_at\": \"2024-04-25T10:54:50.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-25 11:18:55', '2024-04-25 11:18:55'),
(1511, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-status\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25 12:54:50\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"student_no\": \"67934946\", \"updated_at\": \"2024-04-25 13:18:55\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25T10:54:50.000000Z\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"student_no\": \"67934946\", \"updated_at\": \"2024-04-25T11:18:55.000000Z\", \"std_reg_status_id\": \"6\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-25 11:19:04', '2024-04-25 11:19:04'),
(1512, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/confirm-courses\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25 12:54:50\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 13:19:04\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25T10:54:50.000000Z\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T11:19:04.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-25 11:21:17', '2024-04-25 11:21:17'),
(1513, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-courses-approval\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25 12:54:50\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 13:21:17\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-25T10:54:50.000000Z\", \"program_id\": \"7\", \"session_id\": \"2\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T11:21:17.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}}', '2024-04-25 11:22:02', '2024-04-25 11:22:02'),
(1514, 'default', 'created', 'App\\Models\\StudentProgress', NULL, NULL, NULL, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:34:35', '2024-04-25 13:34:35'),
(1515, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:41:10', '2024-04-25 13:41:10'),
(1516, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:41:10', '2024-04-25 13:41:10'),
(1517, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:47:15', '2024-04-25 13:47:15'),
(1518, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:47:15', '2024-04-25 13:47:15'),
(1519, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:47:45', '2024-04-25 13:47:45'),
(1520, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:47:45', '2024-04-25 13:47:45'),
(1521, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:48:06', '2024-04-25 13:48:06'),
(1522, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:48:06', '2024-04-25 13:48:06'),
(1523, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:48:24', '2024-04-25 13:48:24'),
(1524, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:48:24', '2024-04-25 13:48:24'),
(1525, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:49:32', '2024-04-25 13:49:32'),
(1526, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:49:32', '2024-04-25 13:49:32'),
(1527, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:49:47', '2024-04-25 13:49:47'),
(1528, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:49:47', '2024-04-25 13:49:47'),
(1529, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:49:53', '2024-04-25 13:49:53'),
(1530, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:49:53', '2024-04-25 13:49:53'),
(1531, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:50:08', '2024-04-25 13:50:08'),
(1532, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:50:08', '2024-04-25 13:50:08'),
(1533, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:55:09', '2024-04-25 13:55:09'),
(1534, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:55:09', '2024-04-25 13:55:09'),
(1535, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-25 13:55:15', '2024-04-25 13:55:15'),
(1536, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-25 13:55:15', '2024-04-25 13:55:15'),
(1537, 'default', 'created', 'App\\Models\\DegreeSchemeImplementation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/degree-scheme-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"program_id\": 3}, \"old_values\": []}', '2024-04-26 07:41:39', '2024-04-26 07:41:39'),
(1538, 'default', 'created', 'App\\Models\\DegreeSchemeImplementation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/degree-scheme-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"program_id\": 4}, \"old_values\": []}', '2024-04-26 07:41:39', '2024-04-26 07:41:39'),
(1539, 'default', 'created', 'App\\Models\\DegreeSchemeImplementation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/degree-scheme-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"program_id\": 5}, \"old_values\": []}', '2024-04-26 07:41:39', '2024-04-26 07:41:39'),
(1540, 'default', 'created', 'App\\Models\\DegreeSchemeImplementation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/degree-scheme-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"program_id\": 6}, \"old_values\": []}', '2024-04-26 07:41:39', '2024-04-26 07:41:39'),
(1541, 'default', 'created', 'App\\Models\\DegreeSchemeImplementation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/degree-scheme-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"program_id\": 7}, \"old_values\": []}', '2024-04-26 07:41:39', '2024-04-26 07:41:39'),
(1542, 'default', 'deleted', 'App\\Models\\StudentCourse', 5, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 5, \"ip_address\": \"::1\", \"new_values\": {\"id\": 5, \"course_id\": \"8\", \"created_at\": \"2024-04-25 12:54:50\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 12:54:50\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 5, \"course_id\": \"8\", \"created_at\": \"2024-04-25T10:54:50.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T10:54:50.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:21', '2024-04-26 14:03:21'),
(1543, 'default', 'deleted', 'App\\Models\\StudentCourse', 6, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 6, \"ip_address\": \"::1\", \"new_values\": {\"id\": 6, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:41:10\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:41:10\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 6, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:41:10.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:41:10.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:23', '2024-04-26 14:03:23'),
(1544, 'default', 'deleted', 'App\\Models\\StudentCourse', 7, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:47:15\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:47:15\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 7, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:47:15.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:47:15.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:24', '2024-04-26 14:03:24'),
(1545, 'default', 'deleted', 'App\\Models\\StudentCourse', 8, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 8, \"ip_address\": \"::1\", \"new_values\": {\"id\": 8, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:47:45\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:47:45\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 8, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:47:45.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:47:45.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:25', '2024-04-26 14:03:25'),
(1546, 'default', 'deleted', 'App\\Models\\StudentCourse', 9, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 9, \"ip_address\": \"::1\", \"new_values\": {\"id\": 9, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:48:06\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:48:06\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 9, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:48:06.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:48:06.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:25', '2024-04-26 14:03:25'),
(1547, 'default', 'deleted', 'App\\Models\\StudentCourse', 10, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 10, \"ip_address\": \"::1\", \"new_values\": {\"id\": 10, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:48:24\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:48:24\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 10, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:48:24.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:48:24.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:26', '2024-04-26 14:03:26'),
(1548, 'default', 'deleted', 'App\\Models\\StudentCourse', 11, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 11, \"ip_address\": \"::1\", \"new_values\": {\"id\": 11, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:49:32\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:49:32\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 11, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:49:32.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:49:32.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:27', '2024-04-26 14:03:27'),
(1549, 'default', 'deleted', 'App\\Models\\StudentCourse', 12, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 12, \"ip_address\": \"::1\", \"new_values\": {\"id\": 12, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:49:47\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:49:47\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 12, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:49:47.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:49:47.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:27', '2024-04-26 14:03:27'),
(1550, 'default', 'deleted', 'App\\Models\\StudentCourse', 13, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 13, \"ip_address\": \"::1\", \"new_values\": {\"id\": 13, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:49:53\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:49:53\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 13, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:49:53.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:49:53.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:28', '2024-04-26 14:03:28'),
(1551, 'default', 'deleted', 'App\\Models\\StudentCourse', 14, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 14, \"ip_address\": \"::1\", \"new_values\": {\"id\": 14, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:50:08\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:50:08\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 14, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:50:08.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:50:08.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:28', '2024-04-26 14:03:28'),
(1552, 'default', 'deleted', 'App\\Models\\StudentCourse', 15, 'App\\Models\\User', 33, '{\"url\": \"http://newsrms/course-delete\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 15, \"ip_address\": \"::1\", \"new_values\": {\"id\": 15, \"course_id\": \"8\", \"created_at\": \"2024-04-25 15:55:09\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25 15:55:09\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}, \"old_values\": {\"id\": 15, \"course_id\": \"8\", \"created_at\": \"2024-04-25T13:55:09.000000Z\", \"student_id\": \"1\", \"updated_at\": \"2024-04-25T13:55:09.000000Z\", \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": \"3\", \"academic_session_id\": \"2\"}}', '2024-04-26 14:03:29', '2024-04-26 14:03:29'),
(1553, 'default', 'created', 'App\\Models\\ResultsPublication', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/results-publication\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"published\", \"year_id\": \"1\", \"session_id\": \"4\"}, \"old_values\": []}', '2024-04-27 17:19:28', '2024-04-27 17:19:28'),
(1554, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-27 17:26:46', '2024-04-27 17:26:46'),
(1555, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-27 17:26:46', '2024-04-27 17:26:46'),
(1556, 'default', 'created', 'App\\Models\\Student', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"user_id\": 39, \"entry_year\": \"2024\", \"program_id\": 7, \"student_no\": \"66623106\", \"student_status\": \"active\"}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1557, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"4\", \"student_id\": 1, \"std_reg_status_id\": \"1\"}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1558, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 6, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1559, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 7, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1560, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1561, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:31:20', '2024-04-27 17:31:20'),
(1562, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 109454, \"quotation_year\": \"2024\", \"quotation_amount\": \"2000\", \"academic_session_id\": \"4\", \"quotation_description\": \"first quote\"}, \"old_values\": []}', '2024-04-27 17:31:43', '2024-04-27 17:31:43'),
(1563, 'default', 'created', 'App\\Models\\Student', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"user_id\": 40, \"entry_year\": \"2024\", \"program_id\": 7, \"student_no\": \"78139682\", \"student_status\": \"active\"}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1564, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"4\", \"student_id\": 1, \"std_reg_status_id\": \"1\"}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1565, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 6, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1566, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 7, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1567, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1568, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-27 17:44:05', '2024-04-27 17:44:05'),
(1569, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 989747, \"quotation_year\": \"2024\", \"quotation_amount\": \"2000\", \"academic_session_id\": \"4\", \"quotation_description\": \"first quote\"}, \"old_values\": []}', '2024-04-27 17:45:28', '2024-04-27 17:45:28'),
(1570, 'default', 'created', 'App\\Models\\StudentReceipt', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"receipt_no\": \"RPT9715538999\", \"student_id\": 1, \"cash_book_id\": \"1\", \"receipt_year\": \"2024\", \"receipt_amount\": \"2000\", \"academic_session_id\": \"4\", \"receipt_description\": \"Full payment\"}, \"old_values\": []}', '2024-04-27 17:46:01', '2024-04-27 17:46:01'),
(1571, 'default', 'created', 'App\\Models\\StudentInvoice', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"invoice_no\": \"INV6298851367\", \"student_id\": 1, \"invoice_year\": \"2024\", \"invoice_amount\": 2000, \"invoice_type_id\": 1, \"academic_session_id\": 4, \"invoice_description\": \"\"}, \"old_values\": []}', '2024-04-27 17:46:01', '2024-04-27 17:46:01'),
(1572, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": 0, \"entry_type\": \"invoice\", \"invoice_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714236361X01iqQ\", \"running_balance\": 2000}, \"old_values\": []}', '2024-04-27 17:46:01', '2024-04-27 17:46:01'),
(1573, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": \"2000\", \"entry_type\": \"receipt\", \"receipt_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"17142363614PN6K5\", \"running_balance\": 0}, \"old_values\": []}', '2024-04-27 17:46:01', '2024-04-27 17:46:01'),
(1574, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:44:05\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27 19:44:05\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:44:05.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27T16:44:05.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-27 17:46:01', '2024-04-27 17:46:01'),
(1575, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"6\", \"final_exam\": 15, \"student_id\": \"78139682\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-27 18:13:14', '2024-04-27 18:13:14'),
(1576, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 39, \"grade\": \"F\", \"student_marking_id\": 1}, \"old_values\": []}', '2024-04-27 18:13:14', '2024-04-27 18:13:14'),
(1577, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"7\", \"final_exam\": 15, \"student_id\": \"78139682\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-27 18:13:33', '2024-04-27 18:13:33'),
(1578, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 39, \"grade\": \"F\", \"student_marking_id\": 2}, \"old_values\": []}', '2024-04-27 18:13:33', '2024-04-27 18:13:33'),
(1579, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"8\", \"final_exam\": 15, \"student_id\": \"78139682\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-27 18:13:59', '2024-04-27 18:13:59'),
(1580, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 39, \"grade\": \"F\", \"student_marking_id\": 3}, \"old_values\": []}', '2024-04-27 18:13:59', '2024-04-27 18:13:59'),
(1581, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"4\", \"final_exam\": 15, \"student_id\": \"78139682\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-27 18:14:11', '2024-04-27 18:14:11'),
(1582, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 39, \"grade\": \"F\", \"student_marking_id\": 4}, \"old_values\": []}', '2024-04-27 18:14:11', '2024-04-27 18:14:11'),
(1583, 'default', 'updated', 'App\\Models\\StudentMarking', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"ca_exam\": \"24\", \"course_id\": 6, \"created_at\": \"2024-04-27 20:13:14\", \"final_exam\": \"55\", \"student_id\": \"78139682\", \"updated_at\": \"2024-04-27 20:13:14\", \"academic_year_id\": 1, \"academic_session_id\": 4}, \"old_values\": {\"id\": 1, \"ca_exam\": \"24\", \"course_id\": 6, \"created_at\": \"2024-04-27T17:13:14.000000Z\", \"final_exam\": \"15\", \"student_id\": 78139682, \"updated_at\": \"2024-04-27T17:13:14.000000Z\", \"academic_year_id\": 1, \"academic_session_id\": 4}}', '2024-04-27 18:14:27', '2024-04-27 18:14:27'),
(1584, 'default', 'updated', 'App\\Models\\StudentMarkingTotal', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"mark\": 79, \"grade\": \"A+\", \"created_at\": \"2024-04-27 20:13:14\", \"updated_at\": \"2024-04-27 20:13:14\", \"student_marking_id\": 1}, \"old_values\": {\"id\": 1, \"mark\": \"39\", \"grade\": \"F\", \"created_at\": \"2024-04-27T17:13:14.000000Z\", \"updated_at\": \"2024-04-27T17:13:14.000000Z\", \"student_marking_id\": 1}}', '2024-04-27 18:14:27', '2024-04-27 18:14:27'),
(1585, 'default', 'updated', 'App\\Models\\StudentMarking', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"ca_exam\": \"24\", \"course_id\": 7, \"created_at\": \"2024-04-27 20:13:33\", \"final_exam\": \"55\", \"student_id\": \"78139682\", \"updated_at\": \"2024-04-27 20:13:33\", \"academic_year_id\": 1, \"academic_session_id\": 4}, \"old_values\": {\"id\": 2, \"ca_exam\": \"24\", \"course_id\": 7, \"created_at\": \"2024-04-27T17:13:33.000000Z\", \"final_exam\": \"15\", \"student_id\": 78139682, \"updated_at\": \"2024-04-27T17:13:33.000000Z\", \"academic_year_id\": 1, \"academic_session_id\": 4}}', '2024-04-27 18:14:31', '2024-04-27 18:14:31'),
(1586, 'default', 'updated', 'App\\Models\\StudentMarkingTotal', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"mark\": 79, \"grade\": \"A+\", \"created_at\": \"2024-04-27 20:13:33\", \"updated_at\": \"2024-04-27 20:13:33\", \"student_marking_id\": 2}, \"old_values\": {\"id\": 2, \"mark\": \"39\", \"grade\": \"F\", \"created_at\": \"2024-04-27T17:13:33.000000Z\", \"updated_at\": \"2024-04-27T17:13:33.000000Z\", \"student_marking_id\": 2}}', '2024-04-27 18:14:31', '2024-04-27 18:14:31'),
(1587, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"2\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-27 18:16:09', '2024-04-27 18:16:09'),
(1588, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-27 18:16:09', '2024-04-27 18:16:09'),
(1589, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"2\"}, \"old_values\": []}', '2024-04-27 18:16:09', '2024-04-27 18:16:09'),
(1590, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:44:05\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27 19:46:01\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:44:05.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27T16:46:01.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-27 18:16:09', '2024-04-27 18:16:09'),
(1591, 'default', 'created', 'App\\Models\\FeeSetup', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/store-fee-setup-program\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"entry_year\": \"2024\", \"program_id\": \"7\", \"minimum_amount\": \"2000\", \"program_amount\": \"3500\", \"fee_category_id\": 2, \"fee_description\": \"semester 2 fees\", \"minimum_other_fees\": \"1\", \"academic_session_id\": \"5\", \"minimum_amount_type\": \"actual\"}, \"old_values\": []}', '2024-04-27 18:31:14', '2024-04-27 18:31:14'),
(1592, 'default', 'created', 'App\\Models\\FeeSetup', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/store-fee-setup-program\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"entry_year\": \"2024\", \"program_id\": \"7\", \"minimum_amount\": \"2000\", \"program_amount\": \"3500\", \"fee_category_id\": 2, \"fee_description\": \"semester 2 fees\", \"minimum_other_fees\": \"1\", \"academic_session_id\": \"5\", \"minimum_amount_type\": \"actual\"}, \"old_values\": []}', '2024-04-29 12:36:15', '2024-04-29 12:36:15'),
(1593, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"5\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-29 13:10:24', '2024-04-29 13:10:24'),
(1594, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"5\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-29 13:10:58', '2024-04-29 13:10:58'),
(1595, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 13:10:58', '2024-04-29 13:10:58'),
(1596, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 13:10:58', '2024-04-29 13:10:58'),
(1597, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 10, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:10:58', '2024-04-29 13:10:58');
INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `subject_id`, `causer_type`, `causer_id`, `properties`, `created_at`, `updated_at`) VALUES
(1598, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 11, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:10:58', '2024-04-29 13:10:58'),
(1599, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 12, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:10:59', '2024-04-29 13:10:59'),
(1600, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 13, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:10:59', '2024-04-29 13:10:59'),
(1601, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 14, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:10:59', '2024-04-29 13:10:59'),
(1602, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:44:05\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27 20:16:09\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:44:05.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-27T17:16:09.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 13:10:59', '2024-04-29 13:10:59'),
(1603, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 562076, \"quotation_year\": \"2024\", \"quotation_amount\": \"3500\", \"academic_session_id\": \"5\", \"quotation_description\": \"semester 2 fees\"}, \"old_values\": []}', '2024-04-29 13:12:19', '2024-04-29 13:12:19'),
(1604, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 443886, \"quotation_year\": \"2024\", \"quotation_amount\": \"3500\", \"academic_session_id\": \"5\", \"quotation_description\": \"semester 2 fees\"}, \"old_values\": []}', '2024-04-29 13:13:44', '2024-04-29 13:13:44'),
(1605, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 570443, \"quotation_year\": \"2024\", \"quotation_amount\": \"3500\", \"academic_session_id\": \"5\", \"quotation_description\": \"semester 2 fees\"}, \"old_values\": []}', '2024-04-29 13:15:33', '2024-04-29 13:15:33'),
(1606, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 151827, \"quotation_year\": \"2024\", \"quotation_amount\": \"3500\", \"academic_session_id\": \"5\", \"quotation_description\": \"se\"}, \"old_values\": []}', '2024-04-29 13:26:23', '2024-04-29 13:26:23'),
(1607, 'default', 'created', 'App\\Models\\Student', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"user_id\": 42, \"entry_year\": \"2024\", \"program_id\": 7, \"student_no\": \"37804233\", \"student_status\": \"active\"}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1608, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"4\", \"student_id\": 1, \"std_reg_status_id\": \"1\"}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1609, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 6, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1610, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 7, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1611, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1612, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 13:34:03', '2024-04-29 13:34:03'),
(1613, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 900488, \"quotation_year\": \"2024\", \"quotation_amount\": \"2000\", \"academic_session_id\": \"4\", \"quotation_description\": \"first semester\"}, \"old_values\": []}', '2024-04-29 13:34:57', '2024-04-29 13:34:57'),
(1614, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 678176, \"quotation_year\": \"2024\", \"quotation_amount\": \"2000\", \"academic_session_id\": \"4\", \"quotation_description\": \"first semester\"}, \"old_values\": []}', '2024-04-29 13:35:54', '2024-04-29 13:35:54'),
(1615, 'default', 'created', 'App\\Models\\StudentReceipt', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"receipt_no\": \"RPT9459131908\", \"student_id\": 1, \"cash_book_id\": \"1\", \"receipt_year\": \"2024\", \"receipt_amount\": \"2000\", \"academic_session_id\": \"4\", \"receipt_description\": \"Full payment\"}, \"old_values\": []}', '2024-04-29 13:36:30', '2024-04-29 13:36:30'),
(1616, 'default', 'created', 'App\\Models\\StudentInvoice', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"invoice_no\": \"INV9442190035\", \"student_id\": 1, \"invoice_year\": \"2024\", \"invoice_amount\": 2000, \"invoice_type_id\": 1, \"academic_session_id\": 4, \"invoice_description\": \"\"}, \"old_values\": []}', '2024-04-29 13:36:30', '2024-04-29 13:36:30'),
(1617, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": 0, \"entry_type\": \"invoice\", \"invoice_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714394190gv00fj\", \"running_balance\": 2000}, \"old_values\": []}', '2024-04-29 13:36:30', '2024-04-29 13:36:30'),
(1618, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": \"2000\", \"entry_type\": \"receipt\", \"receipt_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714394190Yn7WVr\", \"running_balance\": 0}, \"old_values\": []}', '2024-04-29 13:36:30', '2024-04-29 13:36:30'),
(1619, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:34:03\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:34:03\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:34:03.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:34:03.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 13:36:30', '2024-04-29 13:36:30'),
(1620, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 42, '{\"url\": \"http://newsrms/confirm-courses\", \"action\": \"updated\", \"browser\": \"Chrome\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:34:03\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:36:30\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"pending\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:34:03.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:36:30.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 13:43:02', '2024-04-29 13:43:02'),
(1621, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-courses-approval\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:34:03\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:43:02\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:34:03.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:43:02.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"pending\"}}', '2024-04-29 13:43:28', '2024-04-29 13:43:28'),
(1622, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"6\", \"final_exam\": 55, \"student_id\": \"37804233\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 13:45:01', '2024-04-29 13:45:01'),
(1623, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 1}, \"old_values\": []}', '2024-04-29 13:45:01', '2024-04-29 13:45:01'),
(1624, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"7\", \"final_exam\": 55, \"student_id\": \"37804233\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 13:45:22', '2024-04-29 13:45:22'),
(1625, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 2}, \"old_values\": []}', '2024-04-29 13:45:22', '2024-04-29 13:45:22'),
(1626, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"8\", \"final_exam\": 55, \"student_id\": \"37804233\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 13:45:54', '2024-04-29 13:45:54'),
(1627, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 3}, \"old_values\": []}', '2024-04-29 13:45:54', '2024-04-29 13:45:54'),
(1628, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"4\", \"final_exam\": 15, \"student_id\": \"37804233\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 13:46:24', '2024-04-29 13:46:24'),
(1629, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 39, \"grade\": \"F\", \"student_marking_id\": 4}, \"old_values\": []}', '2024-04-29 13:46:24', '2024-04-29 13:46:24'),
(1630, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"5\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1631, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"1\", \"course_status_id\": 3, \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1632, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 10, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1633, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 11, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1634, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 12, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1635, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 13, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1636, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 14, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1637, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:34:03\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:43:28\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:34:03.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:43:28.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"confirmed\"}}', '2024-04-29 13:46:44', '2024-04-29 13:46:44'),
(1638, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 42, '{\"url\": \"http://newsrms/confirm-courses\", \"action\": \"updated\", \"browser\": \"Chrome\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:46:44\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:46:44\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:46:44.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:46:44.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 13:47:41', '2024-04-29 13:47:41'),
(1639, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-courses-approval\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 15:46:44\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 15:47:41\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T12:46:44.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T12:47:41.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}}', '2024-04-29 13:47:55', '2024-04-29 13:47:55'),
(1640, 'default', 'created', 'App\\Models\\Student', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"user_id\": 43, \"entry_year\": \"2024\", \"program_id\": 7, \"student_no\": \"68767541\", \"student_status\": \"active\"}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1641, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"4\", \"student_id\": 1, \"std_reg_status_id\": \"1\"}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1642, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 6, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1643, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 7, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1644, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 8, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1645, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-activation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 4, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:22:53', '2024-04-29 19:22:53'),
(1646, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 253655, \"quotation_year\": \"2024\", \"quotation_amount\": \"2000\", \"academic_session_id\": \"4\", \"quotation_description\": \"semester 1\"}, \"old_values\": []}', '2024-04-29 19:23:35', '2024-04-29 19:23:35'),
(1647, 'default', 'created', 'App\\Models\\StudentReceipt', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"receipt_no\": \"RPT1648899071\", \"student_id\": 1, \"cash_book_id\": \"1\", \"receipt_year\": \"2024\", \"receipt_amount\": \"2000\", \"academic_session_id\": \"4\", \"receipt_description\": \"Full payment\"}, \"old_values\": []}', '2024-04-29 19:25:24', '2024-04-29 19:25:24'),
(1648, 'default', 'created', 'App\\Models\\StudentInvoice', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"invoice_no\": \"INV3548212496\", \"student_id\": 1, \"invoice_year\": \"2024\", \"invoice_amount\": 2000, \"invoice_type_id\": 1, \"academic_session_id\": 4, \"invoice_description\": \"\"}, \"old_values\": []}', '2024-04-29 19:25:24', '2024-04-29 19:25:24'),
(1649, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": 0, \"entry_type\": \"invoice\", \"invoice_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714415124uC0HV0\", \"running_balance\": 2000}, \"old_values\": []}', '2024-04-29 19:25:24', '2024-04-29 19:25:24'),
(1650, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": \"2000\", \"entry_type\": \"receipt\", \"receipt_id\": 1, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714415124BuxcYt\", \"running_balance\": 0}, \"old_values\": []}', '2024-04-29 19:25:24', '2024-04-29 19:25:24'),
(1651, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:22:53\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:22:53\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:22:53.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:22:53.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 19:25:24', '2024-04-29 19:25:24'),
(1652, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"4\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 19:28:05', '2024-04-29 19:28:05'),
(1653, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 1}, \"old_values\": []}', '2024-04-29 19:28:05', '2024-04-29 19:28:05'),
(1654, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"7\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 19:28:27', '2024-04-29 19:28:27'),
(1655, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 2}, \"old_values\": []}', '2024-04-29 19:28:27', '2024-04-29 19:28:27'),
(1656, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"8\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 19:28:53', '2024-04-29 19:28:53'),
(1657, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 3}, \"old_values\": []}', '2024-04-29 19:28:53', '2024-04-29 19:28:53'),
(1658, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"6\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 19:29:45', '2024-04-29 19:29:45'),
(1659, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 4}, \"old_values\": []}', '2024-04-29 19:29:45', '2024-04-29 19:29:45'),
(1660, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"1\", \"program_id\": 7, \"session_id\": \"5\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-29 19:30:26', '2024-04-29 19:30:26'),
(1661, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 10, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1662, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 11, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1663, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 12, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1664, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 13, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1665, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 14, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 1, \"course_status_id\": 1, \"academic_session_id\": 5}, \"old_values\": []}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1666, 'default', 'updated', 'App\\Models\\StudentProgress', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:22:53\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:25:24\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 1, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:22:53.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:25:24.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 19:30:27', '2024-04-29 19:30:27'),
(1667, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 43, '{\"url\": \"http://newsrms/confirm-courses\", \"action\": \"updated\", \"browser\": \"Chrome\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:30:27\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:30:27\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:30:27.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:30:27.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-29 19:31:18', '2024-04-29 19:31:18'),
(1668, 'default', 'created', 'App\\Models\\StudentQuotation', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/create-quotation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"unused\", \"student_id\": 1, \"quotation_no\": 139872, \"quotation_year\": \"2024\", \"quotation_amount\": \"3500\", \"academic_session_id\": \"5\", \"quotation_description\": \"sem2\"}, \"old_values\": []}', '2024-04-29 19:31:21', '2024-04-29 19:31:21'),
(1669, 'default', 'created', 'App\\Models\\StudentReceipt', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"receipt_no\": \"RPT3832776614\", \"student_id\": 1, \"cash_book_id\": \"1\", \"receipt_year\": \"2024\", \"receipt_amount\": \"3500\", \"academic_session_id\": \"5\", \"receipt_description\": \"Full payment\"}, \"old_values\": []}', '2024-04-29 19:31:54', '2024-04-29 19:31:54'),
(1670, 'default', 'created', 'App\\Models\\StudentInvoice', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"invoice_no\": \"INV8653093949\", \"student_id\": 1, \"invoice_year\": \"2024\", \"invoice_amount\": 3000, \"invoice_type_id\": 1, \"academic_session_id\": 5, \"invoice_description\": \"\"}, \"old_values\": []}', '2024-04-29 19:31:54', '2024-04-29 19:31:54'),
(1671, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 3000, \"credit\": 0, \"entry_type\": \"invoice\", \"invoice_id\": 2, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"17144155148cEA6G\", \"running_balance\": 3000}, \"old_values\": []}', '2024-04-29 19:31:54', '2024-04-29 19:31:54'),
(1672, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 3000, \"credit\": \"3500\", \"entry_type\": \"receipt\", \"receipt_id\": 2, \"student_id\": 1, \"description\": \"Full payment\", \"reference_no\": \"1714415514dw0EVA\", \"running_balance\": -500}, \"old_values\": []}', '2024-04-29 19:31:54', '2024-04-29 19:31:54'),
(1673, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:30:27\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:31:18\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"pending\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:30:27.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:31:18.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"pending\"}}', '2024-04-29 19:31:54', '2024-04-29 19:31:54'),
(1674, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/student-courses-approval\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:30:27\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:31:55\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:30:27.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:31:55.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"pending\"}}', '2024-04-29 19:33:50', '2024-04-29 19:33:50'),
(1675, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"14\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 19:34:46', '2024-04-29 19:34:46'),
(1676, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 5}, \"old_values\": []}', '2024-04-29 19:34:46', '2024-04-29 19:34:46'),
(1677, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"11\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 19:35:03', '2024-04-29 19:35:03'),
(1678, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 6}, \"old_values\": []}', '2024-04-29 19:35:03', '2024-04-29 19:35:03'),
(1679, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"12\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 19:35:21', '2024-04-29 19:35:21'),
(1680, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 7}, \"old_values\": []}', '2024-04-29 19:35:21', '2024-04-29 19:35:21'),
(1681, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"13\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 19:35:42', '2024-04-29 19:35:42'),
(1682, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 8}, \"old_values\": []}', '2024-04-29 19:35:42', '2024-04-29 19:35:42'),
(1683, 'default', 'created', 'App\\Models\\StudentMarking', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"ca_exam\": 24, \"course_id\": \"10\", \"final_exam\": 55, \"student_id\": \"68767541\", \"academic_year_id\": \"1\", \"academic_session_id\": \"5\"}, \"old_values\": []}', '2024-04-29 19:36:00', '2024-04-29 19:36:00'),
(1684, 'default', 'created', 'App\\Models\\StudentMarkingTotal', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/upload-student-marks\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"mark\": 79, \"grade\": \"A+\", \"student_marking_id\": 9}, \"old_values\": []}', '2024-04-29 19:36:00', '2024-04-29 19:36:00'),
(1685, 'default', 'updated', 'App\\Models\\StudentMarking', 9, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 9, \"ip_address\": \"::1\", \"new_values\": {\"id\": 9, \"ca_exam\": \"24\", \"course_id\": 10, \"created_at\": \"2024-04-29 21:36:00\", \"final_exam\": \"15\", \"student_id\": \"68767541\", \"updated_at\": \"2024-04-29 21:36:00\", \"academic_year_id\": 1, \"academic_session_id\": 5}, \"old_values\": {\"id\": 9, \"ca_exam\": \"24\", \"course_id\": 10, \"created_at\": \"2024-04-29T18:36:00.000000Z\", \"final_exam\": \"55\", \"student_id\": 68767541, \"updated_at\": \"2024-04-29T18:36:00.000000Z\", \"academic_year_id\": 1, \"academic_session_id\": 5}}', '2024-04-29 19:36:24', '2024-04-29 19:36:24'),
(1686, 'default', 'updated', 'App\\Models\\StudentMarkingTotal', 9, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/update-student-marking\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 9, \"ip_address\": \"::1\", \"new_values\": {\"id\": 9, \"mark\": 39, \"grade\": \"F\", \"created_at\": \"2024-04-29 21:36:00\", \"updated_at\": \"2024-04-29 21:36:00\", \"student_marking_id\": 9}, \"old_values\": {\"id\": 9, \"mark\": \"79\", \"grade\": \"A+\", \"created_at\": \"2024-04-29T18:36:00.000000Z\", \"updated_at\": \"2024-04-29T18:36:00.000000Z\", \"student_marking_id\": 9}}', '2024-04-29 19:36:24', '2024-04-29 19:36:24'),
(1687, 'default', 'updated', 'App\\Models\\ResultsPublication', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/results-publication-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"status\": \"unpublished\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:19:28\", \"session_id\": \"4\", \"updated_at\": \"2024-04-27 19:19:28\"}, \"old_values\": {\"id\": 1, \"status\": \"published\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:19:28.000000Z\", \"session_id\": \"4\", \"updated_at\": \"2024-04-27T16:19:28.000000Z\"}}', '2024-04-29 19:37:00', '2024-04-29 19:37:00'),
(1688, 'default', 'updated', 'App\\Models\\ResultsPublication', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/results-publication-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"status\": \"published\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:19:28\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29 21:37:00\"}, \"old_values\": {\"id\": 1, \"status\": \"unpublished\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:19:28.000000Z\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29T18:37:00.000000Z\"}}', '2024-04-29 19:37:14', '2024-04-29 19:37:14'),
(1689, 'default', 'updated', 'App\\Models\\ResultsPublication', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/results-publication-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"status\": \"unpublished\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:19:28\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29 21:37:14\"}, \"old_values\": {\"id\": 1, \"status\": \"published\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:19:28.000000Z\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29T18:37:14.000000Z\"}}', '2024-04-29 19:40:14', '2024-04-29 19:40:14'),
(1690, 'default', 'updated', 'App\\Models\\ResultsPublication', 1, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/results-publication-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 1, \"ip_address\": \"::1\", \"new_values\": {\"id\": 1, \"status\": \"published\", \"year_id\": \"1\", \"created_at\": \"2024-04-27 19:19:28\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29 21:40:14\"}, \"old_values\": {\"id\": 1, \"status\": \"unpublished\", \"year_id\": \"1\", \"created_at\": \"2024-04-27T16:19:28.000000Z\", \"session_id\": \"4\", \"updated_at\": \"2024-04-29T18:40:14.000000Z\"}}', '2024-04-29 19:47:26', '2024-04-29 19:47:26');
INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `subject_id`, `causer_type`, `causer_id`, `properties`, `created_at`, `updated_at`) VALUES
(1691, 'default', 'created', 'App\\Models\\StudentProgress', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"year\": \"2024\", \"year_id\": \"2\", \"program_id\": 7, \"session_id\": \"4\", \"student_id\": 1, \"std_reg_status_id\": 1}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1692, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 10, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": \"2\", \"course_status_id\": 3, \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1693, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 15, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 2, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1694, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 17, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 2, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1695, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 20, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 2, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1696, 'default', 'created', 'App\\Models\\StudentCourse', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"course_id\": 22, \"student_id\": 1, \"intake_year\": \"2024\", \"academic_year_id\": 2, \"course_status_id\": 1, \"academic_session_id\": 4}, \"old_values\": []}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1697, 'default', 'updated', 'App\\Models\\StudentProgress', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/end-comments-generation\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29 21:30:27\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:33:50\", \"std_reg_status_id\": 7, \"courses_confirmation\": \"confirmed\"}, \"old_values\": {\"id\": 2, \"year\": \"2024\", \"year_id\": \"1\", \"created_at\": \"2024-04-29T18:30:27.000000Z\", \"program_id\": \"7\", \"session_id\": \"5\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:33:50.000000Z\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"confirmed\"}}', '2024-04-29 19:50:18', '2024-04-29 19:50:18'),
(1698, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"closed\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-30 07:11:58', '2024-04-30 07:11:58'),
(1699, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"closed\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"1\"}, \"old_values\": []}', '2024-04-30 07:16:13', '2024-04-30 07:16:13'),
(1700, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"closed\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"1\"}, \"old_values\": []}', '2024-04-30 07:16:49', '2024-04-30 07:16:49'),
(1701, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"closed\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"1\"}, \"old_values\": []}', '2024-04-30 07:25:18', '2024-04-30 07:25:18'),
(1702, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"open\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-30 07:25:29', '2024-04-30 07:25:29'),
(1703, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"open\", \"user_id\": \"2\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-30 07:25:50', '2024-04-30 07:25:50'),
(1704, 'default', 'created', 'App\\Models\\LecturerLock', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"status\": \"open\", \"user_id\": \"44\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": []}', '2024-04-30 07:36:51', '2024-04-30 07:36:51'),
(1705, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 09:36:51\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T06:36:51.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 07:52:44', '2024-04-30 07:52:44'),
(1706, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 09:52:44\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T06:52:44.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 07:52:49', '2024-04-30 07:52:49'),
(1707, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 09:52:49\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T06:52:49.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 07:52:51', '2024-04-30 07:52:51'),
(1708, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 09:52:51\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T06:52:51.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 08:18:52', '2024-04-30 08:18:52'),
(1709, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 10:18:52\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T07:18:52.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 08:33:34', '2024-04-30 08:33:34'),
(1710, 'default', 'updated', 'App\\Models\\LecturerLock', 7, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/lecturer-lock-update\", \"action\": \"updated\", \"browser\": \"Firefox\", \"item_id\": 7, \"ip_address\": \"::1\", \"new_values\": {\"id\": 7, \"status\": \"open\", \"user_id\": 44, \"created_at\": \"2024-04-30 09:36:51\", \"updated_at\": \"2024-04-30 10:33:34\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}, \"old_values\": {\"id\": 7, \"status\": \"closed\", \"user_id\": 44, \"created_at\": \"2024-04-30T06:36:51.000000Z\", \"updated_at\": \"2024-04-30T07:33:34.000000Z\", \"academic_year_id\": \"1\", \"academic_session_id\": \"4\"}}', '2024-04-30 08:33:41', '2024-04-30 08:33:41'),
(1711, 'default', 'created', 'App\\Models\\StudentReceipt', NULL, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"receipt_no\": \"RPT1714623837\", \"student_id\": 1, \"cash_book_id\": \"1\", \"receipt_year\": \"2024\", \"receipt_amount\": \"2000\", \"academic_session_id\": \"4\", \"receipt_description\": \"extra payment\"}, \"old_values\": []}', '2024-04-30 08:45:04', '2024-04-30 08:45:04'),
(1712, 'default', 'created', 'App\\Models\\StudentInvoice', NULL, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"invoice_no\": \"INV4500803746\", \"student_id\": 1, \"invoice_year\": \"2024\", \"invoice_amount\": 2000, \"invoice_type_id\": 1, \"academic_session_id\": 4, \"invoice_description\": \"\"}, \"old_values\": []}', '2024-04-30 08:45:04', '2024-04-30 08:45:04'),
(1713, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": 0, \"entry_type\": \"invoice\", \"invoice_id\": 3, \"student_id\": 1, \"description\": \"extra payment\", \"reference_no\": \"17144631044Vtc8p\", \"running_balance\": 2000}, \"old_values\": []}', '2024-04-30 08:45:04', '2024-04-30 08:45:04'),
(1714, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 2000, \"credit\": \"2000\", \"entry_type\": \"receipt\", \"receipt_id\": 3, \"student_id\": 1, \"description\": \"extra payment\", \"reference_no\": \"1714463104toSjvE\", \"running_balance\": 0}, \"old_values\": []}', '2024-04-30 08:45:04', '2024-04-30 08:45:04'),
(1715, 'default', 'updated', 'App\\Models\\StudentProgress', 3, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-student-receipt\", \"action\": \"updated\", \"browser\": \"Chrome\", \"item_id\": 3, \"ip_address\": \"::1\", \"new_values\": {\"id\": 3, \"year\": \"2024\", \"year_id\": \"2\", \"created_at\": \"2024-04-29 21:50:18\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29 21:50:18\", \"std_reg_status_id\": \"2\", \"courses_confirmation\": \"unconfirmed\"}, \"old_values\": {\"id\": 3, \"year\": \"2024\", \"year_id\": \"2\", \"created_at\": \"2024-04-29T18:50:18.000000Z\", \"program_id\": \"7\", \"session_id\": \"4\", \"student_id\": \"1\", \"updated_at\": \"2024-04-29T18:50:18.000000Z\", \"std_reg_status_id\": \"1\", \"courses_confirmation\": \"unconfirmed\"}}', '2024-04-30 08:45:04', '2024-04-30 08:45:04'),
(1716, 'default', 'created', 'App\\Models\\StudentFinancialStatement', NULL, 'App\\Models\\User', 44, '{\"url\": \"http://newsrms/add-refund\", \"action\": \"created\", \"browser\": \"Chrome\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"debit\": 0, \"credit\": \"2000\", \"entry_type\": \"refunds\", \"receipt_id\": 3, \"student_id\": 1, \"description\": \"Wrong payment\", \"reference_no\": \"RFD1714463275Fmqalv\", \"running_balance\": -2000}, \"old_values\": []}', '2024-04-30 08:47:55', '2024-04-30 08:47:55'),
(1717, 'default', 'created', 'App\\Models\\CourseManager', NULL, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/course-managers-store\", \"action\": \"created\", \"browser\": \"Firefox\", \"item_id\": null, \"ip_address\": \"::1\", \"new_values\": {\"user_id\": \"45\", \"course_id\": \"10\"}, \"old_values\": []}', '2024-04-30 10:37:38', '2024-04-30 10:37:38'),
(1718, 'default', 'deleted', 'App\\Models\\CourseManager', 2, 'App\\Models\\User', 1, '{\"url\": \"http://newsrms/course-managers-delete2\", \"action\": \"deleted\", \"browser\": \"Firefox\", \"item_id\": 2, \"ip_address\": \"::1\", \"new_values\": {\"id\": 2, \"user_id\": 1, \"course_id\": 5, \"created_at\": \"2024-04-24 12:16:53\", \"updated_at\": \"2024-04-24 12:16:53\"}, \"old_values\": {\"id\": 2, \"user_id\": 1, \"course_id\": 5, \"created_at\": \"2024-04-24T10:16:53.000000Z\", \"updated_at\": \"2024-04-24T10:16:53.000000Z\"}}', '2024-04-30 10:38:03', '2024-04-30 10:38:03');

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

--
-- Table structure for table `applicant`
--

CREATE TABLE IF NOT EXISTS `applicant` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `applicant_no` varchar(255) DEFAULT NULL,
  `next_of_kin` varchar(255) DEFAULT NULL,
  `next_of_kin_phone` varchar(255) DEFAULT NULL,
  `program_id` int DEFAULT NULL,
  `entry_year` varchar(255) DEFAULT NULL,
  `highschool_name` varchar(255) DEFAULT NULL,
  `institution_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `highest_qualification` varchar(255) DEFAULT NULL,
  `tetiary_compl_date` varchar(255) DEFAULT NULL,
  `highschool_compl_date` varchar(255) DEFAULT NULL,
  `exam_board_id` int DEFAULT NULL,
  `application_mode_id` int DEFAULT NULL,
  `applicant_type_id` int DEFAULT NULL,
  `applicant_status` varchar(255) DEFAULT NULL,
  `transcript_file_path` varchar(500) DEFAULT NULL,
  `certificate_file_path` varchar(500) DEFAULT NULL,
  `other_doc1_path` varchar(255) DEFAULT NULL,
  `other_doc2_path` varchar(255) DEFAULT NULL,
  `other_doc3_path` varchar(255) DEFAULT NULL,
  `other_doc4_path` varchar(255) DEFAULT NULL,
  `application_receipt_file_path` varchar(500) DEFAULT NULL,
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `updated_at` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  PRIMARY KEY (`id`),
  KEY `applicant_FK` (`user_id`),
  KEY `applicant_FK_1` (`program_id`),
  KEY `applicant_FK_2` (`exam_board_id`),
  KEY `applicant_FK_3` (`application_mode_id`),
  KEY `applicant_FK_4` (`applicant_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `applicant_files`
--

CREATE TABLE IF NOT EXISTS `applicant_files` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `applicant_id` bigint UNSIGNED NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_type_id` bigint NOT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `applicant_id` (`applicant_id`),
  KEY `file_type_id` (`file_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `applicant_subject`
--

CREATE TABLE IF NOT EXISTS `applicant_subject` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `applicant_id` bigint UNSIGNED NOT NULL,
  `subject_id` int NOT NULL,
  `exam_board_id` int NOT NULL,
  `subject_grade` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `applicant_subject_FK` (`applicant_id`),
  KEY `applicant_subject_FK_1` (`subject_id`),
  KEY `applicant_subject_FK_2` (`exam_board_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `applicant_type`
--

CREATE TABLE IF NOT EXISTS `applicant_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `applicant_type_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `applicant_type`
--

INSERT INTO `applicant_type` (`id`, `applicant_type_name`, `created_at`, `updated_at`) VALUES
(1, 'Undergraduate', '2022-09-05 13:58:37', '2022-09-05 13:58:37'),
(2, 'Postgraduate', '2022-09-05 13:58:37', '2022-09-05 13:58:37');

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

--
-- Table structure for table `application_mode`
--

CREATE TABLE IF NOT EXISTS `application_mode` (
  `id` int NOT NULL AUTO_INCREMENT,
  `application_mode_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `application_mode`
--

INSERT INTO `application_mode` (`id`, `application_mode_name`, `created_at`, `updated_at`) VALUES
(1, 'Online', '2022-09-05 13:58:07', '2022-09-05 13:58:07'),
(2, 'Manual', '2022-09-05 13:58:07', '2022-09-05 13:58:07');

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

--
-- Table structure for table `audit_trails`
--

CREATE TABLE IF NOT EXISTS `audit_trails` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_by` bigint UNSIGNED NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_values` json DEFAULT NULL,
  `new_values` json DEFAULT NULL,
  `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_trails_action_by_foreign` (`action_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `balances`
--

CREATE TABLE IF NOT EXISTS `balances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int NOT NULL,
  `amount` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `cash_books`
--

CREATE TABLE IF NOT EXISTS `cash_books` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `courses`
--

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `marking_scheme_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_type_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `courses_FK` (`course_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_manager`
--

CREATE TABLE IF NOT EXISTS `course_manager` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int NOT NULL,
  `user_id` int NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_manager_FK_1` (`course_id`),
  KEY `course_manager_FK` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_prerequisite`
--

CREATE TABLE IF NOT EXISTS `course_prerequisite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int NOT NULL,
  `prerequisite_course_id` int NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_prerequisite_FK` (`course_id`),
  KEY `course_prerequisite_FK_1` (`prerequisite_course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_status`
--

CREATE TABLE IF NOT EXISTS `course_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` enum('active','exempted','repeated') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `course_status`
--

INSERT INTO `course_status` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'active', '2024-01-03 15:11:10', '2024-01-03 15:11:10'),
(2, 'exempted', '2024-01-03 15:11:34', '2024-01-03 15:11:34'),
(3, 'repeated', '2024-01-03 15:11:34', '2024-01-03 15:11:34');

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

--
-- Table structure for table `course_type`
--

CREATE TABLE IF NOT EXISTS `course_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_point` double NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_type`
--

INSERT INTO `course_type` (`id`, `course_type_name`, `course_point`, `created_at`, `updated_at`) VALUES
(1, 'Half Course', 2.5, '2022-08-11 14:03:48', '2022-08-11 14:03:48'),
(2, 'Full Course', 5, '2022-08-11 14:03:48', '2022-08-11 14:03:48');

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

--
-- Table structure for table `degree_scheme`
--

CREATE TABLE IF NOT EXISTS `degree_scheme` (
  `id` int NOT NULL AUTO_INCREMENT,
  `scheme_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `degree_scheme_details`
--

CREATE TABLE IF NOT EXISTS `degree_scheme_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `degree_scheme_id` int NOT NULL,
  `low_point` varchar(255) NOT NULL,
  `high_point` varchar(255) NOT NULL,
  `degree` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `degree_scheme_details_FK` (`degree_scheme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `degree_scheme_implementation`
--

CREATE TABLE IF NOT EXISTS `degree_scheme_implementation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `degree_scheme_id` int DEFAULT NULL,
  `program_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `degree_scheme_implementation_FK` (`degree_scheme_id`),
  KEY `degree_scheme_implementation_FK_1` (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `email_attatment`
--

CREATE TABLE IF NOT EXISTS `email_attatment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `end_comments`
--

CREATE TABLE IF NOT EXISTS `end_comments` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `program_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lower_bound` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upper_bound` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `exam_board`
--

CREATE TABLE IF NOT EXISTS `exam_board` (
  `id` int NOT NULL AUTO_INCREMENT,
  `board_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `exam_board`
--

INSERT INTO `exam_board` (`id`, `board_name`, `created_at`, `updated_at`) VALUES
(1, 'ECZ', '2022-09-05 13:44:51', '2022-09-05 13:44:51'),
(2, 'Grade12ES', '2022-09-05 13:44:51', '2022-09-05 13:44:51'),
(3, 'Certificate', '2022-09-05 13:44:51', '2022-09-05 13:44:51'),
(4, 'Diploma', '2022-09-05 13:44:51', '2022-09-05 13:44:51'),
(5, 'Degree', '2022-09-05 13:44:51', '2022-09-05 13:44:51');

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

--
-- Table structure for table `faculty`
--

CREATE TABLE IF NOT EXISTS `faculty` (
  `id` int NOT NULL AUTO_INCREMENT,
  `faculty_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_courses`
--

CREATE TABLE IF NOT EXISTS `failed_courses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_no` varchar(50) NOT NULL,
  `course_id` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fee_category`
--

CREATE TABLE IF NOT EXISTS `fee_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fee_category` varchar(255) NOT NULL,
  `craeted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fee_category`
--

INSERT INTO `fee_category` (`id`, `fee_category`, `craeted_at`, `updated_at`) VALUES
(1, 'Course', '2024-04-19 12:39:23', '2024-04-19 12:39:23'),
(2, 'Program', '2024-04-19 12:39:23', '2024-04-19 12:39:23'),
(3, 'Other', '2024-04-19 12:39:33', '2024-04-19 12:39:33');

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

--
-- Table structure for table `fee_setup_course`
--

CREATE TABLE IF NOT EXISTS `fee_setup_course` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int NOT NULL,
  `fee_setup_id` int NOT NULL,
  `course_amount` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fee_setup_course_FK` (`course_id`),
  KEY `fee_setup_course_FK_1` (`fee_setup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `fee_setup_other`
--

CREATE TABLE IF NOT EXISTS `fee_setup_other` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fee_type_id` int NOT NULL,
  `fee_amount` int NOT NULL,
  `fee_setup_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fee_setup_other_FK` (`fee_setup_id`),
  KEY `fee_setup_other_FK_1` (`fee_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `fee_type`
--

CREATE TABLE IF NOT EXISTS `fee_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fee_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fee_type`
--

INSERT INTO `fee_type` (`id`, `fee_name`, `created_at`, `updated_at`) VALUES
(1, 'Registration Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(2, 'Caution Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(3, 'Examination Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(4, 'Student Identity Card', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(5, 'Residential Registration fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(6, 'Late Registration', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(7, 'Zaou Student Union', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(8, 'Graduation', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(9, 'Initial Balance-SRMS', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(10, 'ICT Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(11, 'Library Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(12, 'Maintenance Fee', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(13, 'Teaching Practice', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(14, 'Moot Court', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(15, 'Dessertation And Research', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(16, 'Field Work-Practice', '2023-01-11 11:58:49', '2023-01-11 11:58:49'),
(17, 'Course Overload', '2023-01-11 11:58:49', '2023-01-11 11:58:49');

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

--
-- Table structure for table `file_type`
--

CREATE TABLE IF NOT EXISTS `file_type` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_type_name` enum('degree','diploma','certificate','other') NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `file_type`
--

INSERT INTO `file_type` (`id`, `file_type_name`, `created_at`, `updated_at`) VALUES
(1, 'degree', NULL, NULL),
(2, 'diploma', NULL, NULL),
(3, 'other', NULL, NULL),
(4, 'certificate', NULL, NULL);

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

--
-- Table structure for table `finance_report`
--

CREATE TABLE IF NOT EXISTS `finance_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `transaction_type` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_id` (`student_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `grading_scheme`
--

CREATE TABLE IF NOT EXISTS `grading_scheme` (
  `id` int NOT NULL AUTO_INCREMENT,
  `scheme` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `grading_scheme_details`
--

CREATE TABLE IF NOT EXISTS `grading_scheme_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `grading_scheme_id` int NOT NULL,
  `high_mark` varchar(255) NOT NULL,
  `low_mark` varchar(255) NOT NULL,
  `grade` varchar(255) NOT NULL,
  `point` varchar(255) NOT NULL,
  `course_comment` enum('pass','fail') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'fail',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `grading_scheme_details_FK` (`grading_scheme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `grading_scheme_implementation`
--

CREATE TABLE IF NOT EXISTS `grading_scheme_implementation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `grading_scheme_id` int DEFAULT NULL,
  `program_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `grading_scheme_implementation_FK` (`grading_scheme_id`),
  KEY `grading_scheme_implementation_FK_1` (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `institution`
--

CREATE TABLE IF NOT EXISTS `institution` (
  `id` int NOT NULL AUTO_INCREMENT,
  `institution_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institution_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institution_logo_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `studen_statement_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_letter_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transcript_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirmation_slip_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(3, 'default', '{\"uuid\":\"1c9a8b89-abbf-4b20-842f-08a518fc5968\",\"displayName\":\"App\\\\Jobs\\\\ProcessEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ProcessEmail\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\ProcessEmail\\\":11:{s:10:\\\"applicants\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Applicant\\\";s:2:\\\"id\\\";a:1:{i:0;N;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1699358604, 1699358604),
(4, 'default', '{\"uuid\":\"6640b653-5635-4aa6-a522-f6b9e38aca35\",\"displayName\":\"App\\\\Jobs\\\\ProcessEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ProcessEmail\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\ProcessEmail\\\":11:{s:10:\\\"applicants\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Applicant\\\";s:2:\\\"id\\\";a:1:{i:0;N;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1699358682, 1699358682),
(5, 'default', '{\"uuid\":\"4d1dbaed-83ce-474c-907a-e34666a33850\",\"displayName\":\"App\\\\Jobs\\\\ProcessEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ProcessEmail\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\ProcessEmail\\\":11:{s:10:\\\"applicants\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Applicant\\\";s:2:\\\"id\\\";a:1:{i:0;N;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1699358722, 1699358722),
(6, 'default', '{\"uuid\":\"a5ecc97f-7a16-468b-913b-27409ebf634b\",\"displayName\":\"App\\\\Jobs\\\\ProcessEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ProcessEmail\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\ProcessEmail\\\":11:{s:10:\\\"applicants\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Applicant\\\";s:2:\\\"id\\\";a:1:{i:0;N;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1699358737, 1699358737);

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

--
-- Table structure for table `marking_scheme`
--

CREATE TABLE IF NOT EXISTS `marking_scheme` (
  `id` int NOT NULL AUTO_INCREMENT,
  `scheme` varchar(255) NOT NULL,
  `ca_exam` varchar(255) NOT NULL,
  `final_exam` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(53, '2022_08_10_070359_create_academic_session_table', 1),
(54, '2022_08_10_070359_create_academic_year_table', 1),
(55, '2022_08_10_070359_create_course_manager_table', 1),
(56, '2022_08_10_070359_create_course_prerequisite_table', 1),
(57, '2022_08_10_070359_create_course_type_table', 1),
(58, '2022_08_10_070359_create_courses_table', 1),
(59, '2022_08_10_070359_create_faculty_table', 1),
(60, '2022_08_10_070359_create_failed_jobs_table', 1),
(61, '2022_08_10_070359_create_instituition_table', 1),
(62, '2022_08_10_070359_create_password_resets_table', 1),
(63, '2022_08_10_070359_create_program_structure_table', 1),
(64, '2022_08_10_070359_create_programs_table', 1),
(65, '2022_08_10_070359_create_role_table', 1),
(66, '2022_08_10_070359_create_users_table', 1),
(67, '2022_08_10_070400_add_foreign_keys_to_course_prerequisite_table', 1),
(68, '2022_08_10_070400_add_foreign_keys_to_courses_table', 1),
(69, '2022_08_10_070400_add_foreign_keys_to_program_structure_table', 1),
(70, '2022_08_10_070400_add_foreign_keys_to_programs_table', 1),
(71, '2022_08_10_070400_add_foreign_keys_to_users_table', 1),
(72, '2019_12_14_000001_create_personal_access_tokens_table', 2),
(73, '2023_01_05_143835_create_jobs_table', 3),
(74, '2023_04_18_101730_create_academic_session_table', 0),
(75, '2023_04_18_101730_create_academic_year_table', 0),
(76, '2023_04_18_101730_create_applicant_table', 0),
(77, '2023_04_18_101730_create_applicant_files_table', 0),
(78, '2023_04_18_101730_create_applicant_steps_table', 0),
(79, '2023_04_18_101730_create_applicant_subject_table', 0),
(80, '2023_04_18_101730_create_applicant_type_table', 0),
(81, '2023_04_18_101730_create_application_mode_table', 0),
(82, '2023_04_18_101730_create_courses_table', 0),
(83, '2023_04_18_101730_create_course_manager_table', 0),
(84, '2023_04_18_101730_create_course_prerequisite_table', 0),
(85, '2023_04_18_101730_create_course_type_table', 0),
(86, '2023_04_18_101730_create_email_attatment_table', 0),
(87, '2023_04_18_101730_create_exam_board_table', 0),
(88, '2023_04_18_101730_create_faculty_table', 0),
(89, '2023_04_18_101730_create_failed_jobs_table', 0),
(90, '2023_04_18_101730_create_fee_category_table', 0),
(91, '2023_04_18_101730_create_fee_setup_table', 0),
(92, '2023_04_18_101730_create_fee_setup_course_table', 0),
(93, '2023_04_18_101730_create_fee_setup_other_table', 0),
(94, '2023_04_18_101730_create_fee_type_table', 0),
(95, '2023_04_18_101730_create_file_type_table', 0),
(96, '2023_04_18_101730_create_grading_scheme_table', 0),
(97, '2023_04_18_101730_create_grading_scheme_details_table', 0),
(98, '2023_04_18_101730_create_grading_scheme_implementation_table', 0),
(99, '2023_04_18_101730_create_institution_table', 0),
(100, '2023_04_18_101730_create_jobs_table', 0),
(101, '2023_04_18_101730_create_marking_scheme_table', 0),
(102, '2023_04_18_101730_create_marking_scheme_implementation_table', 0),
(103, '2023_04_18_101730_create_password_resets_table', 0),
(104, '2023_04_18_101730_create_payment_type_table', 0),
(105, '2023_04_18_101730_create_personal_access_tokens_table', 0),
(106, '2023_04_18_101730_create_programs_table', 0),
(107, '2023_04_18_101730_create_program_structure_table', 0),
(108, '2023_04_18_101730_create_program_structure_details_table', 0),
(109, '2023_04_18_101730_create_role_table', 0),
(110, '2023_04_18_101730_create_student_table', 0),
(111, '2023_04_18_101730_create_student_invoice_table', 0),
(112, '2023_04_18_101730_create_student_invoice_details_table', 0),
(113, '2023_04_18_101730_create_student_invoice_type_table', 0),
(114, '2023_04_18_101730_create_student_optional_courses_table', 0),
(115, '2023_04_18_101730_create_student_payment_table', 0),
(116, '2023_04_18_101730_create_student_quotation_table', 0),
(117, '2023_04_18_101730_create_student_quotation_details_table', 0),
(118, '2023_04_18_101730_create_student_receipt_table', 0),
(119, '2023_04_18_101730_create_student_receipt_details_table', 0),
(120, '2023_04_18_101730_create_student_registration_table', 0),
(121, '2023_04_18_101730_create_subject_table', 0),
(122, '2023_04_18_101730_create_template_letter_table', 0),
(123, '2023_04_18_101730_create_users_table', 0),
(124, '2023_04_18_101731_add_foreign_keys_to_applicant_table', 0),
(125, '2023_04_18_101731_add_foreign_keys_to_applicant_steps_table', 0),
(126, '2023_04_18_101731_add_foreign_keys_to_applicant_subject_table', 0),
(127, '2023_04_18_101731_add_foreign_keys_to_courses_table', 0),
(128, '2023_04_18_101731_add_foreign_keys_to_course_prerequisite_table', 0),
(129, '2023_04_18_101731_add_foreign_keys_to_fee_setup_table', 0),
(130, '2023_04_18_101731_add_foreign_keys_to_fee_setup_course_table', 0),
(131, '2023_04_18_101731_add_foreign_keys_to_fee_setup_other_table', 0),
(132, '2023_04_18_101731_add_foreign_keys_to_grading_scheme_details_table', 0),
(133, '2023_04_18_101731_add_foreign_keys_to_grading_scheme_implementation_table', 0),
(134, '2023_04_18_101731_add_foreign_keys_to_marking_scheme_implementation_table', 0),
(135, '2023_04_18_101731_add_foreign_keys_to_programs_table', 0),
(136, '2023_04_18_101731_add_foreign_keys_to_program_structure_table', 0),
(137, '2023_04_18_101731_add_foreign_keys_to_program_structure_details_table', 0),
(138, '2023_04_18_101731_add_foreign_keys_to_student_table', 0),
(139, '2023_04_18_101731_add_foreign_keys_to_student_invoice_table', 0),
(140, '2023_04_18_101731_add_foreign_keys_to_student_invoice_details_table', 0),
(141, '2023_04_18_101731_add_foreign_keys_to_student_optional_courses_table', 0),
(142, '2023_04_18_101731_add_foreign_keys_to_student_payment_table', 0),
(143, '2023_04_18_101731_add_foreign_keys_to_student_quotation_table', 0),
(144, '2023_04_18_101731_add_foreign_keys_to_student_quotation_details_table', 0),
(145, '2023_04_18_101731_add_foreign_keys_to_student_receipt_table', 0),
(146, '2023_04_18_101731_add_foreign_keys_to_student_receipt_details_table', 0),
(147, '2023_04_18_101731_add_foreign_keys_to_student_registration_table', 0),
(148, '2023_04_18_101731_add_foreign_keys_to_users_table', 0),
(151, '2023_10_19_174107_create_lecturer_locks_table', 4),
(152, '2024_01_21_185404_create_activity_log_table', 5),
(156, '2024_01_28_193041_create_end_comments_table', 6),
(162, '2024_02_02_115455_create_student_end_comments_table', 7),
(163, '2024_02_01_115746_create_audit_trails_table', 8);

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

--
-- Table structure for table `payment_type`
--

CREATE TABLE IF NOT EXISTS `payment_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_type` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `programs`
--

CREATE TABLE IF NOT EXISTS `programs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `program_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `program_structure_id` int DEFAULT NULL,
  `faculty_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `programs_FK` (`faculty_id`),
  KEY `program_structure_id` (`program_structure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `program_structure`
--

CREATE TABLE IF NOT EXISTS `program_structure` (
  `id` int NOT NULL AUTO_INCREMENT,
  `program_structure_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `academic_path_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2024-04-26 12:10:23', '2024-04-26 12:10:23'),
(2, 'lecturer', '2024-04-26 12:10:23', '2024-04-26 12:10:23'),
(3, 'IT', '2024-04-26 12:10:23', '2024-04-26 12:10:23'),
(4, 'finance', '2024-04-26 12:10:23', '2024-04-26 12:10:23'),
(5, 'student', '2024-04-26 12:10:23', '2024-04-26 12:10:23');

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

--
-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `student_no` varchar(255) NOT NULL,
  `program_id` int NOT NULL,
  `entry_year` varchar(255) NOT NULL,
  `student_status` enum('active','inactive','suspended') DEFAULT 'active',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_FK` (`user_id`),
  KEY `student_FK_1` (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_credit_notes`
--

CREATE TABLE IF NOT EXISTS `student_credit_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `invoice_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_debit_notes`
--

CREATE TABLE IF NOT EXISTS `student_debit_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `invoice_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_financial_statement`
--

CREATE TABLE IF NOT EXISTS `student_financial_statement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` varchar(255) DEFAULT NULL,
  `invoice_id` varchar(255) DEFAULT NULL,
  `receipt_id` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `credit` varchar(255) DEFAULT '0',
  `debit` varchar(255) DEFAULT '0',
  `entry_type` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `running_balance` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_invoice_details`
--

CREATE TABLE IF NOT EXISTS `student_invoice_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_invoice_id` int NOT NULL,
  `fee_type_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_invoice_details_FK` (`student_invoice_id`),
  KEY `student_invoice_details_FK_1` (`fee_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_invoice_type`
--

CREATE TABLE IF NOT EXISTS `student_invoice_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_type_name` varchar(255) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_marking_total`
--

CREATE TABLE IF NOT EXISTS `student_marking_total` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_marking_id` int NOT NULL,
  `mark` varchar(255) NOT NULL,
  `grade` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_marking_total_FK` (`student_marking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_payment`
--

CREATE TABLE IF NOT EXISTS `student_payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int NOT NULL,
  `amount` varchar(255) NOT NULL,
  `reference_no` varchar(255) NOT NULL,
  `payment_type_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_payment_FK` (`student_id`),
  KEY `student_payment_FK_1` (`payment_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_quotation_details`
--

CREATE TABLE IF NOT EXISTS `student_quotation_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_quotation_id` int NOT NULL,
  `fee_type_id` int NOT NULL,
  `program_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_quotation_details_FK` (`student_quotation_id`),
  KEY `student_quotation_details_FK_1` (`fee_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_receipt_details`
--

CREATE TABLE IF NOT EXISTS `student_receipt_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_receipt_id` int NOT NULL,
  `fee_type_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_receipt_details_FK` (`student_receipt_id`),
  KEY `student_receipt_details_FK_1` (`fee_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_refunds`
--

CREATE TABLE IF NOT EXISTS `student_refunds` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `receipt_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student_registration_status`
--

CREATE TABLE IF NOT EXISTS `student_registration_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `student_registration_status`
--

INSERT INTO `student_registration_status` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'pending payment', '2024-01-03 13:39:04', '2024-01-03 13:39:04'),
(2, 'registered', '2024-01-03 13:39:04', '2024-03-20 12:19:21'),
(3, 'pending course appro', '2024-01-03 13:39:42', '2024-01-03 13:39:42'),
(4, 'excluded', '2024-01-03 13:39:42', '2024-01-03 13:39:42'),
(5, 'expelled', '2024-01-03 13:39:42', '2024-01-03 13:39:42'),
(6, 'withdrawn', '2024-01-03 13:40:00', '2024-01-03 13:40:00'),
(7, 'completed', '2024-03-25 13:33:20', '2024-03-25 13:33:20'),
(8, 'repeat', '2024-03-27 10:53:12', '2024-03-27 10:53:12');

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

--
-- Table structure for table `student_status_tracking`
--

CREATE TABLE IF NOT EXISTS `student_status_tracking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_no` varchar(50) NOT NULL,
  `previous_status` varchar(50) NOT NULL,
  `new_status` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `subject`
--

CREATE TABLE IF NOT EXISTS `subject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `subject_name`, `created_at`, `updated_at`) VALUES
(2, 'Geography', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(3, 'Mathematics', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(4, 'Addma', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(5, 'History', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(10, 'Local language', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(11, 'French', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(25, 'Science', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(27, 'Chemistry', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(28, 'Literature', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(29, 'T.D ', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(30, 'Commerce', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(31, 'Accounts', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(33, 'Music', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(34, 'Metal Work', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(35, 'Wood Work', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(50, 'Biology', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(51, 'Physics', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(53, 'Agriculture', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(54, 'Art and Design', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(55, 'Business Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(56, 'Computer Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(57, 'Foreign Languange', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(58, 'Economics', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(59, 'F&N', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(61, 'Religious Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(64, 'Civic Education', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(67, 'Ecomomics', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(68, 'General Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(69, 'Social Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(72, 'Comp Studies', '2022-09-05 13:56:38', '2022-09-05 13:56:38'),
(78, 'PE', '2022-09-05 13:56:38', '2022-09-05 13:56:38');

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

--
-- Table structure for table `template_letter`
--

CREATE TABLE IF NOT EXISTS `template_letter` (
  `id` int NOT NULL AUTO_INCREMENT,
  `letter_name` varchar(255) NOT NULL,
  `letter` longtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `template_letter`
--

INSERT INTO `template_letter` (`id`, `letter_name`, `letter`, `created_at`, `updated_at`) VALUES
(4, 'Admissions', '<br style=\"box-sizing: inherit;\"><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\"><span style=\"box-sizing: inherit;float: right;\">{Institution Address}<br></span></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\"><span style=\"box-sizing: inherit;\"><br></span></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\"><span style=\"box-sizing: inherit;\">{Date}</span></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\"><span style=\"font-size: 12.576px; box-sizing: inherit;\">Dear {Name}</span><br></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\">We are pleased to inform you that you have been admitted to the class of {Intake} to study {Program} in the {Faculty} at {Institution}. You will find a \r\nfull admission package attached to this admission letter.&nbsp;It includes \r\nall the documents needed to follow up the registration which have to be \r\nsubmitted within a week. Congratulations. We are\r\n looking forward to seeing you. <span style=\"box-sizing: inherit;\"> <br></span></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\"><span style=\"box-sizing: inherit;\">Yours Sincerely,</span></p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\">Admissions Officer,</p><p style=\"box-sizing: inherit; margin-bottom: 1.5em; border: 0px; color: rgb(34, 34, 34); font-family: Merriweather, serif; font-size: 12.576px; letter-spacing: normal;\">{Institution}<i>.<br></i><br></p>', '2022-12-28 13:20:30', '2023-12-04 10:06:15');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `applicant`
--
ALTER TABLE `applicant`
  ADD CONSTRAINT `applicant_FK` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `applicant_FK_1` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`),
  ADD CONSTRAINT `applicant_FK_2` FOREIGN KEY (`exam_board_id`) REFERENCES `exam_board` (`id`),
  ADD CONSTRAINT `applicant_FK_3` FOREIGN KEY (`application_mode_id`) REFERENCES `application_mode` (`id`),
  ADD CONSTRAINT `applicant_FK_4` FOREIGN KEY (`applicant_type_id`) REFERENCES `applicant_type` (`id`);

--
-- Constraints for table `applicant_subject`
--
ALTER TABLE `applicant_subject`
  ADD CONSTRAINT `applicant_subject_FK` FOREIGN KEY (`applicant_id`) REFERENCES `applicant` (`id`),
  ADD CONSTRAINT `applicant_subject_FK_1` FOREIGN KEY (`subject_id`) REFERENCES `subject` (`id`),
  ADD CONSTRAINT `applicant_subject_FK_2` FOREIGN KEY (`exam_board_id`) REFERENCES `exam_board` (`id`);

--
-- Constraints for table `audit_trails`
--
ALTER TABLE `audit_trails`
  ADD CONSTRAINT `audit_trails_action_by_foreign` FOREIGN KEY (`action_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `courses`
--
ALTER TABLE `courses`
  ADD CONSTRAINT `courses_FK` FOREIGN KEY (`course_type_id`) REFERENCES `course_type` (`id`);

--
-- Constraints for table `course_prerequisite`
--
ALTER TABLE `course_prerequisite`
  ADD CONSTRAINT `course_prerequisite_FK` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`),
  ADD CONSTRAINT `course_prerequisite_FK_1` FOREIGN KEY (`prerequisite_course_id`) REFERENCES `courses` (`id`);

--
-- Constraints for table `degree_scheme_details`
--
ALTER TABLE `degree_scheme_details`
  ADD CONSTRAINT `degree_scheme_details_FK` FOREIGN KEY (`degree_scheme_id`) REFERENCES `degree_scheme` (`id`);

--
-- Constraints for table `degree_scheme_implementation`
--
ALTER TABLE `degree_scheme_implementation`
  ADD CONSTRAINT `degree_scheme_implementation_FK` FOREIGN KEY (`degree_scheme_id`) REFERENCES `degree_scheme` (`id`),
  ADD CONSTRAINT `degree_scheme_implementation_FK_1` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`);

--
-- Constraints for table `fee_setup_course`
--
ALTER TABLE `fee_setup_course`
  ADD CONSTRAINT `fee_setup_course_FK` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`),
  ADD CONSTRAINT `fee_setup_course_FK_1` FOREIGN KEY (`fee_setup_id`) REFERENCES `fee_setup` (`id`);

--
-- Constraints for table `fee_setup_other`
--
ALTER TABLE `fee_setup_other`
  ADD CONSTRAINT `fee_setup_other_FK` FOREIGN KEY (`fee_setup_id`) REFERENCES `fee_setup` (`id`),
  ADD CONSTRAINT `fee_setup_other_FK_1` FOREIGN KEY (`fee_type_id`) REFERENCES `fee_type` (`id`);

--
-- Constraints for table `grading_scheme_details`
--
ALTER TABLE `grading_scheme_details`
  ADD CONSTRAINT `grading_scheme_details_FK` FOREIGN KEY (`grading_scheme_id`) REFERENCES `grading_scheme` (`id`);

--
-- Constraints for table `grading_scheme_implementation`
--
ALTER TABLE `grading_scheme_implementation`
  ADD CONSTRAINT `grading_scheme_implementation_FK` FOREIGN KEY (`grading_scheme_id`) REFERENCES `grading_scheme` (`id`),
  ADD CONSTRAINT `grading_scheme_implementation_FK_1` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`);

--
-- Constraints for table `programs`
--
ALTER TABLE `programs`
  ADD CONSTRAINT `programs_FK` FOREIGN KEY (`faculty_id`) REFERENCES `faculty` (`id`),
  ADD CONSTRAINT `programs_ibfk_1` FOREIGN KEY (`program_structure_id`) REFERENCES `program_structure` (`id`);
COMMIT;
set Foreign_key_checks = 1;
