-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: repayment
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `log_web_activity`
--

DROP TABLE IF EXISTS `log_web_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_web_activity` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `USER_ID` int NOT NULL,
  `TYPE` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `KEY_ID` int DEFAULT NULL,
  `MODULE` text NOT NULL,
  `SOURCE` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_web_activity`
--

LOCK TABLES `log_web_activity` WRITE;
/*!40000 ALTER TABLE `log_web_activity` DISABLE KEYS */;
INSERT INTO `log_web_activity` VALUES (4,4,'VISIT',0,'studentgetedit','','2025-07-24 16:22:27','2025-07-24 16:22:27'),(5,4,'VISIT',102,'studentgetedit','','2025-07-24 16:22:41','2025-07-24 16:22:41'),(6,4,'VISIT',0,'studentgetedit','','2025-07-25 09:53:01','2025-07-25 09:53:01'),(8,4,'VISIT',0,'academicgetedit','','2025-07-25 09:54:17','2025-07-25 09:54:17'),(10,4,'VISIT',0,'academicstatusgetedit','','2025-07-25 09:54:22','2025-07-25 09:54:22'),(15,4,'VISIT',2,'advisorview','','2025-07-25 09:59:57','2025-07-25 09:59:57'),(16,4,'VISIT',0,'academicgetedit','','2025-07-25 10:05:48','2025-07-25 10:05:48'),(17,4,'VISIT',0,'academicgetedit','','2025-07-25 10:05:51','2025-07-25 10:05:51'),(18,4,'VISIT',0,'usergetedit','','2025-07-25 10:22:05','2025-07-25 10:22:05'),(19,4,'VISIT',0,'usergetedit','','2025-07-25 10:48:35','2025-07-25 10:48:35'),(20,4,'VISIT',1,'usergetedit','','2025-07-25 10:49:00','2025-07-25 10:49:00'),(21,4,'VISIT',0,'usergetedit','','2025-07-25 10:49:03','2025-07-25 10:49:03'),(22,4,'VISIT',102,'repayment_installments_loan','','2025-07-25 13:20:13','2025-07-25 13:20:13'),(23,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:28:33','2025-07-25 13:28:33'),(24,4,'VISIT',0,'studentgetedit','','2025-07-25 13:28:51','2025-07-25 13:28:51'),(25,4,'VISIT',0,'studentgetedit','','2025-07-25 13:30:52','2025-07-25 13:30:52'),(26,4,'VISIT',0,'advisorgetedit','','2025-07-25 13:30:59','2025-07-25 13:30:59'),(27,4,'VISIT',102,'repayment_installments_loan','','2025-07-25 13:31:08','2025-07-25 13:31:08'),(28,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:31:18','2025-07-25 13:31:18'),(29,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:31:23','2025-07-25 13:31:23'),(30,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:33:53','2025-07-25 13:33:53'),(31,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:34:22','2025-07-25 13:34:22'),(32,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:34:51','2025-07-25 13:34:51'),(33,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:36:33','2025-07-25 13:36:33'),(34,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:37:20','2025-07-25 13:37:20'),(35,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:40:34','2025-07-25 13:40:34'),(36,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:41:03','2025-07-25 13:41:03'),(37,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:41:12','2025-07-25 13:41:12'),(38,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:43:21','2025-07-25 13:43:21'),(39,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 13:44:53','2025-07-25 13:44:53'),(40,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:02:01','2025-07-25 14:02:01'),(41,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:02:27','2025-07-25 14:02:27'),(42,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:03:02','2025-07-25 14:03:02'),(43,4,'VISIT',102,'set_total_repayment_plan','set_loan_tt_id=>63///rev=>2///','2025-07-25 14:03:36','2025-07-25 14:03:36'),(44,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:04:44','2025-07-25 14:04:44'),(45,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:05:59','2025-07-25 14:05:59'),(46,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:06:22','2025-07-25 14:06:22'),(47,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:07:04','2025-07-25 14:07:04'),(48,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:07:08','2025-07-25 14:07:08'),(49,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:07:30','2025-07-25 14:07:30'),(50,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:10:21','2025-07-25 14:10:21'),(51,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:11:54','2025-07-25 14:11:54'),(52,4,'VISIT',102,'repayment_installments_loan','','2025-07-25 14:12:15','2025-07-25 14:12:15'),(53,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:12:17','2025-07-25 14:12:17'),(54,4,'VISIT',105,'repayment_installments_loan','','2025-07-25 14:31:55','2025-07-25 14:31:55'),(55,4,'VISIT',105,'set_total_repayment_plan_view','set_loan_tt_id=>64///rev=>1///','2025-07-25 14:31:57','2025-07-25 14:31:57'),(56,4,'VISIT',0,'add_repayment_onetime','','2025-07-25 14:33:35','2025-07-25 14:33:35'),(57,4,'VISIT',0,'studentgetedit','','2025-07-25 14:36:33','2025-07-25 14:36:33'),(58,4,'VISIT',0,'studentgetedit','','2025-07-25 14:37:12','2025-07-25 14:37:12'),(59,4,'VISIT',0,'advisorgetedit','','2025-07-25 14:37:25','2025-07-25 14:37:25'),(60,4,'VISIT',17,'academicgetedit','','2025-07-25 14:37:35','2025-07-25 14:37:35'),(61,4,'VISIT',18,'academicgetedit','','2025-07-25 14:37:45','2025-07-25 14:37:45'),(62,4,'VISIT',0,'academicgetedit','','2025-07-25 14:38:14','2025-07-25 14:38:14'),(63,4,'VISIT',0,'academicgetedit','','2025-07-25 14:38:51','2025-07-25 14:38:51'),(64,4,'VISIT',0,'academicgetedit','','2025-07-25 14:39:56','2025-07-25 14:39:56'),(65,4,'VISIT',0,'studentgetedit','','2025-07-25 14:40:05','2025-07-25 14:40:05'),(66,4,'VISIT',0,'academicgetedit','','2025-07-25 14:41:41','2025-07-25 14:41:41'),(67,4,'VISIT',0,'academicgetedit','','2025-07-25 14:42:57','2025-07-25 14:42:57'),(68,4,'VISIT',0,'academicgetedit','','2025-07-25 14:44:10','2025-07-25 14:44:10'),(69,4,'VISIT',1,'academicstatusgetedit','','2025-07-25 14:44:15','2025-07-25 14:44:15'),(70,4,'VISIT',1,'curriculumgetedit','','2025-07-25 14:45:12','2025-07-25 14:45:12'),(71,4,'VISIT',1,'schoolgetedit','','2025-07-25 14:45:36','2025-07-25 14:45:36'),(72,4,'VISIT',1,'scholarshipprogramgetedit','','2025-07-25 14:45:56','2025-07-25 14:45:56'),(73,4,'VISIT',1,'nationalityedit','','2025-07-25 14:46:19','2025-07-25 14:46:19'),(74,4,'VISIT',0,'nationalityedit','','2025-07-25 14:46:38','2025-07-25 14:46:38'),(75,4,'VISIT',2,'titlegetedit','','2025-07-25 14:48:12','2025-07-25 14:48:12'),(76,4,'VISIT',102,'repayment_installments_loan','','2025-07-25 14:49:26','2025-07-25 14:49:26'),(77,4,'VISIT',102,'set_total_repayment_plan_view','set_loan_tt_id=>63///rev=>1///','2025-07-25 14:49:28','2025-07-25 14:49:28'),(78,4,'VISIT',102,'repayment_installments_loan','','2025-07-25 14:50:48','2025-07-25 14:50:48'),(79,4,'VISIT',0,'add_repayment_onetime','','2025-07-25 14:51:00','2025-07-25 14:51:00'),(80,4,'VISIT',0,'add_repayment_onetime','','2025-07-25 14:53:22','2025-07-25 14:53:22'),(81,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:53:31','2025-07-25 14:53:31'),(82,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:54:36','2025-07-25 14:54:36'),(83,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:54:38','2025-07-25 14:54:38'),(84,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:54:41','2025-07-25 14:54:41'),(85,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:55:01','2025-07-25 14:55:01'),(86,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:55:33','2025-07-25 14:55:33'),(87,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:56:23','2025-07-25 14:56:23'),(88,4,'VISIT',0,'add_repayment_onetime','','2025-07-25 14:57:13','2025-07-25 14:57:13'),(89,4,'VISIT',0,'add_repayment_installments','','2025-07-25 14:57:23','2025-07-25 14:57:23'),(90,4,'VISIT',0,'add_repayment_onetime','','2025-07-25 14:58:44','2025-07-25 14:58:44'),(91,4,'VISIT',0,'add_repayment_onetime','','2025-07-29 11:14:18','2025-07-29 11:14:18'),(92,4,'VISIT',0,'add_repayment_onetime','','2025-07-29 11:14:31','2025-07-29 11:14:31'),(93,4,'VISIT',0,'add_repayment_installments','','2025-07-29 11:14:36','2025-07-29 11:14:36'),(94,4,'VISIT',102,'repayment_installments_loan','','2025-09-22 13:55:24','2025-09-22 13:55:24'),(95,4,'VISIT',102,'repayment_installments_loan','','2025-09-22 13:56:54','2025-09-22 13:56:54');
/*!40000 ALTER TABLE `log_web_activity` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-07 10:00:13
