-- MySQL dump 10.13  Distrib 8.0.45, for Linux (x86_64)
--
-- Host: localhost    Database: onlineleave
-- ------------------------------------------------------
-- Server version	8.0.45-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 `criteria`
--

DROP TABLE IF EXISTS `criteria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `criteria` (
  `criteria_id` int NOT NULL AUTO_INCREMENT,
  `criteria_school` int NOT NULL,
  `criteria_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `criteria_recommendation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `criteria_from` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `criteria_to` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `criteria_member` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`criteria_id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `criteria`
--

LOCK TABLES `criteria` WRITE;
/*!40000 ALTER TABLE `criteria` DISABLE KEYS */;
INSERT INTO `criteria` VALUES (1,1,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 13:53:09','2026-02-04 18:19:15'),(2,1,'Date',NULL,'0.5','2','Select from Member','2025-04-30 13:53:32','2025-04-30 13:53:32'),(3,1,'Date',NULL,'2.5','5','Select from Member','2025-04-30 13:53:45','2025-04-30 13:53:45'),(4,1,'Date',NULL,'5.5',NULL,'Director','2025-04-30 13:54:06','2025-04-30 13:54:06'),(5,14,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:21:16','2025-04-30 14:21:16'),(6,2,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:21:25','2025-04-30 14:21:25'),(7,14,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:21:27','2025-04-30 14:21:27'),(8,14,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:21:42','2025-04-30 14:21:42'),(9,2,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:21:45','2025-04-30 14:21:45'),(10,14,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:21:54','2025-04-30 14:21:54'),(11,14,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:22:03','2025-04-30 14:22:03'),(12,2,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:22:07','2025-04-30 14:22:07'),(13,2,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:22:21','2025-04-30 14:22:21'),(14,3,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:25:50','2025-04-30 14:25:50'),(15,3,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:26:04','2025-04-30 14:26:04'),(16,3,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:26:22','2025-04-30 14:26:22'),(17,3,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:26:40','2025-04-30 14:26:40'),(18,4,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:33:33','2025-04-30 14:33:33'),(19,4,'Date',NULL,'0.5','5','Select from Member','2025-04-30 14:33:45','2025-04-30 14:33:45'),(20,4,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:34:02','2025-04-30 14:34:02'),(21,5,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:35:38','2025-04-30 14:35:38'),(22,5,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:35:51','2025-04-30 14:35:51'),(23,5,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:36:26','2025-04-30 14:36:26'),(24,5,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:36:41','2025-04-30 14:36:41'),(25,6,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:38:55','2025-04-30 14:38:55'),(26,6,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:39:13','2025-04-30 14:39:13'),(27,6,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:39:24','2025-04-30 14:39:24'),(28,6,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:39:56','2025-04-30 14:39:56'),(29,15,'Date',NULL,'0.5',NULL,'Select from Member','2025-04-30 14:40:03','2025-04-30 14:40:03'),(30,16,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:41:50','2025-04-30 14:41:50'),(31,16,'Date',NULL,'0.5','5','Select from Member','2025-04-30 14:42:07','2025-04-30 14:42:07'),(32,16,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:42:19','2025-04-30 14:42:19'),(33,7,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:42:51','2025-04-30 14:42:51'),(34,7,'Date',NULL,'0.5','5','Select from Member','2025-04-30 14:43:02','2025-04-30 14:43:02'),(35,7,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:43:11','2025-04-30 14:43:11'),(36,17,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:45:00','2025-04-30 14:45:00'),(37,8,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:45:11','2025-04-30 14:45:11'),(38,17,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:45:20','2025-04-30 14:45:20'),(39,8,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:45:22','2025-04-30 14:45:22'),(40,8,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:45:34','2025-04-30 14:45:34'),(41,17,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:45:35','2025-04-30 14:45:35'),(42,8,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:45:42','2025-04-30 14:45:42'),(43,17,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:45:44','2025-04-30 14:45:44'),(44,18,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:48:02','2025-04-30 14:48:02'),(45,18,'Date',NULL,'0.5','2','Select from Member','2025-04-30 14:48:15','2025-04-30 14:48:15'),(46,18,'Date',NULL,'2.5','5','Select from Member','2025-04-30 14:48:25','2025-04-30 14:48:25'),(47,9,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:48:27','2025-04-30 14:48:27'),(48,18,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:48:34','2025-04-30 14:48:34'),(49,9,'Date',NULL,'0.5',NULL,'Select from Member','2025-04-30 14:48:43','2025-05-02 18:42:59'),(50,19,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:54:52','2025-04-30 14:54:52'),(51,19,'Date',NULL,'0.5','5.5','Select from Member','2025-04-30 14:55:04','2025-04-30 14:55:04'),(52,19,'Date',NULL,'5.5',NULL,'Director','2025-04-30 14:55:13','2025-04-30 14:55:13'),(53,20,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 14:59:15','2025-04-30 14:59:15'),(54,20,'Date',NULL,'0.5',NULL,'Select from Member','2025-04-30 14:59:30','2025-04-30 14:59:30'),(55,21,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:01:28','2025-04-30 15:01:28'),(56,21,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:01:57','2025-04-30 15:01:57'),(57,21,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:02:19','2025-04-30 15:02:19'),(58,21,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:02:27','2025-04-30 15:02:27'),(59,10,'Date',NULL,'0.5',NULL,'Select from Member','2025-04-30 15:02:27','2025-04-30 15:02:27'),(60,11,'Date',NULL,'0.5',NULL,'Select from Member','2025-04-30 15:04:01','2025-04-30 15:04:01'),(61,12,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:04:51','2025-04-30 15:04:51'),(62,22,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:05:03','2025-04-30 15:05:03'),(63,12,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:06:04','2025-04-30 15:06:04'),(64,12,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:06:16','2025-04-30 15:06:16'),(65,12,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:06:31','2025-04-30 15:06:31'),(66,22,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:06:43','2025-04-30 15:06:43'),(67,22,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:08:07','2025-04-30 15:08:07'),(68,22,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:08:14','2025-04-30 15:08:14'),(69,13,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:08:43','2025-04-30 15:08:43'),(70,13,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:08:56','2025-04-30 15:08:56'),(71,13,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:09:45','2025-04-30 15:11:03'),(72,13,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:11:53','2025-04-30 15:11:53'),(73,23,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:18:27','2025-04-30 15:18:27'),(74,23,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:18:36','2025-04-30 15:18:36'),(75,23,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:18:45','2025-04-30 15:18:45'),(76,23,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:18:53','2025-04-30 15:18:53'),(77,24,'Date',NULL,'0.5','5','Select from Member','2025-04-30 15:27:26','2025-04-30 15:27:26'),(78,24,'Date',NULL,'5.5',NULL,'Select from Member','2025-04-30 15:27:34','2025-04-30 15:27:34'),(79,25,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-04-30 15:28:10','2025-04-30 15:28:10'),(80,25,'Date',NULL,'0.5','2','Select from Member','2025-04-30 15:28:21','2025-04-30 15:28:21'),(81,25,'Date',NULL,'2.5','5','Select from Member','2025-04-30 15:28:33','2025-04-30 15:28:33'),(82,25,'Date',NULL,'5.5',NULL,'Director','2025-04-30 15:28:39','2025-04-30 15:28:39'),(83,26,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-05-01 16:09:46','2025-05-01 16:09:46'),(84,26,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-05-01 16:09:54','2025-05-01 16:09:54'),(85,26,'Date',NULL,'0.5','2','Select from Member','2025-05-01 16:10:06','2025-05-01 16:10:06'),(86,26,'Date',NULL,'2.5','5','Select from Member','2025-05-01 16:10:23','2025-05-01 16:10:23'),(87,26,'Date',NULL,'5.5',NULL,'Director','2025-05-01 16:10:33','2025-05-01 16:10:33'),(88,27,'Approve','Approval Recommended',NULL,NULL,'Select from Member','2025-05-01 16:13:54','2025-05-01 16:13:54'),(89,27,'Date',NULL,'0.5','2','Select from Member','2025-05-01 16:14:06','2025-05-01 16:14:06'),(90,27,'Date',NULL,'2.5','5','Select from Member','2025-05-01 16:14:18','2025-05-01 16:14:18'),(91,27,'Date',NULL,'5.5',NULL,'Director','2025-05-01 16:14:26','2025-05-01 16:14:26');
/*!40000 ALTER TABLE `criteria` 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 2026-05-28 10:00:02
