all_data.sql

-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: uni_dms
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!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 */;
/*!40101 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 `admin_users`
--

DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_users`
--

LOCK TABLES `admin_users` WRITE;
/*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
INSERT INTO `admin_users` VALUES (1,'admin','$2y$12$LTLX0c6VE/8.s2HveoT5POZvBuUXWQWTk39UqXd0YTL6bIbwCcP9y%','System Administrator','2026-04-02 18:47:26');
/*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `degrees`
--

DROP TABLE IF EXISTS `degrees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `degrees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `duration` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `medium` varchar(50) DEFAULT NULL,
  `type` enum('Undergraduate','Postgraduate','Diploma') DEFAULT 'Undergraduate',
  `faculty` varchar(255) DEFAULT NULL,
  `degree_type` varchar(50) DEFAULT NULL,
  `stream_requirement` varchar(100) DEFAULT NULL,
  `min_zscore` decimal(4,2) DEFAULT NULL,
  `career_paths` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `department_id` (`department_id`),
  CONSTRAINT `degrees_ibfk_1` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `degrees`
--

LOCK TABLES `degrees` WRITE;
/*!40000 ALTER TABLE `degrees` DISABLE KEYS */;
INSERT INTO `degrees` VALUES (1,1,'Bachelor of Science in Mathematics','4 years','Theory-driven mathematics degree with research opportunities.','English','Undergraduate','Faculty of Science','BSc','Maths',1.95,'Academia, Finance, Data Science'),(2,3,'Bachelor of Science in Civil Engineering','4 years','Civil engineering degree preparing students for infrastructure design.','English','Undergraduate','Faculty of Engineering','BScEng','Physical Science',1.85,'Construction, Project Management, Consulting'),(3,4,'Bachelor of Science in Information Technology','4 years','Practical IT degree with industry-grade labs.','English','Undergraduate','Faculty of Information Technology','BSc','Physical Science',2.05,'Software Development, Cybersecurity, Product Management'),(4,5,'Bachelor of Science in Data Science','4 years','Data science program blending statistics and engineering.','English','Undergraduate','Faculty of Information Technology','BSc','Maths',2.20,'Data Analytics, AI, Research'),(5,2,'Bachelor of Science in Applied Statistics','4 years','Statistics degree for research and analytics careers.','English','Undergraduate','Faculty of Science','BSc','Maths',1.90,'Research, Finance, Public Sector');
/*!40000 ALTER TABLE `degrees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `faculty_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `faculty_id` (`faculty_id`),
  CONSTRAINT `departments_ibfk_1` FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES (1,1,'Department of Mathematics'),(2,1,'Department of Statistics'),(3,2,'Department of Civil Engineering'),(4,3,'Department of Computer Science'),(5,3,'Department of Information Systems');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `extracurricular_activities`
--

DROP TABLE IF EXISTS `extracurricular_activities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `extracurricular_activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(100) DEFAULT 'General',
  `description` text DEFAULT NULL,
  `is_available` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `university_id` (`university_id`),
  CONSTRAINT `extracurricular_activities_ibfk_1` FOREIGN KEY (`university_id`) REFERENCES `universities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `extracurricular_activities`
--

LOCK TABLES `extracurricular_activities` WRITE;
/*!40000 ALTER TABLE `extracurricular_activities` DISABLE KEYS */;
INSERT INTO `extracurricular_activities` VALUES (1,1,'Colombo Debate Union','Clubs','Competitive debating and public speaking academy.',1,'2026-04-02 18:47:26'),(2,2,'Peradeniya Adventure Squad','Sports','Outdoor adventure club organizing hiking and camping.',1,'2026-04-02 18:47:26');
/*!40000 ALTER TABLE `extracurricular_activities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faculties`
--

DROP TABLE IF EXISTS `faculties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `university_id` (`university_id`),
  CONSTRAINT `faculties_ibfk_1` FOREIGN KEY (`university_id`) REFERENCES `universities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faculties`
--

LOCK TABLES `faculties` WRITE;
/*!40000 ALTER TABLE `faculties` DISABLE KEYS */;
INSERT INTO `faculties` VALUES (1,1,'Faculty of Science'),(2,2,'Faculty of Engineering'),(3,1,'Faculty of Information Technology');
/*!40000 ALTER TABLE `faculties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `flat_zscores`
--

DROP TABLE IF EXISTS `flat_zscores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flat_zscores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `degree_name` varchar(255) DEFAULT NULL,
  `university_name` varchar(255) DEFAULT NULL,
  `subject1` varchar(50) DEFAULT NULL,
  `subject2` varchar(50) DEFAULT NULL,
  `subject3` varchar(50) DEFAULT NULL,
  `colombo` float DEFAULT NULL,
  `gampaha` float DEFAULT NULL,
  `kalutara` float DEFAULT NULL,
  `matale` float DEFAULT NULL,
  `kandy` float DEFAULT NULL,
  `nuwara_eliya` float DEFAULT NULL,
  `galle` float DEFAULT NULL,
  `matara` float DEFAULT NULL,
  `hambantota` float DEFAULT NULL,
  `jaffna` float DEFAULT NULL,
  `kilinochchi` float DEFAULT NULL,
  `mannar` float DEFAULT NULL,
  `mullaitivu` float DEFAULT NULL,
  `vavuniya` float DEFAULT NULL,
  `trincomalee` float DEFAULT NULL,
  `batticaloa` float DEFAULT NULL,
  `ampara` float DEFAULT NULL,
  `puttalam` float DEFAULT NULL,
  `kurunegala` float DEFAULT NULL,
  `anuradhapura` float DEFAULT NULL,
  `polonnaruwa` float DEFAULT NULL,
  `badulla` float DEFAULT NULL,
  `monaragala` float DEFAULT NULL,
  `ratnapura` float DEFAULT NULL,
  `kegalle` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `flat_zscores`
--

LOCK TABLES `flat_zscores` WRITE;
/*!40000 ALTER TABLE `flat_zscores` DISABLE KEYS */;
INSERT INTO `flat_zscores` VALUES (1,'MEDICINE','University of Colombo','Biology','Chemistry','Physics',2.3517,2.4035,2.3684,2.7472,2.5573,2.4495,2.3763,2.3541,2.3528,2.36,2.4083,1.7011,1.7011,2.424,2.3765,2.3823,2.4008,2.4331,2.3664,2.3916,2.3838,2.3702,2.3627,2.3684,2.4686),(2,'MEDICINE','University of Peradeniya','Biology','Chemistry','Physics',2.1679,2.2114,2.202,2.2337,2.1677,2.2599,2.1838,2.1711,2.1721,2.1763,2.212,1.404,1.4834,2.1704,1.6024,2.1818,2.1724,2.1971,2.1739,2.1711,1.5721,2.1702,2.2093,2.1907,2.1976),(3,'MEDICINE','University of Sri Jayewardenepura','Biology','Chemistry','Physics',2.1207,2.1252,2.1212,1.5017,2.1276,1.3882,2.1311,2.1209,2.1361,2.1271,2.1622,1.4093,1.0376,2.1323,2.1392,1.3792,2.1247,2.1336,2.1206,2.1316,2.1368,2.1237,1.8284,2.1236,2.1405),(4,'MEDICINE','University of Kelaniya','Biology','Chemistry','Physics',2.0428,2.0445,2.0467,2.0418,2.0483,2.0845,2.0613,2.0722,2.0422,2.0406,1.0498,1.6063,1.2232,1.5846,2.0601,2.0717,2.0475,2.048,2.0443,2.0417,2.0664,2.0538,2.0473,2.0406,2.0547),(5,'MEDICINE','University of Jaffna','Biology','Chemistry','Physics',1.8869,1.714,1.8709,1.7284,1.8282,1.717,1.8401,1.8572,1.5586,1.8586,1.7451,1.7074,1.7788,1.7107,1.7719,1.8126,1.8552,1.7079,1.8295,1.7114,1.7588,1.7435,1.7114,1.8102,1.8298),(6,'MEDICINE','University of Ruhuna','Biology','Chemistry','Physics',1.9739,1.9826,1.9765,2.0065,1.9735,1.9828,1.9731,1.981,1.9723,0.8754,1.3265,1.3623,2.0336,1.4085,1.3356,1.9984,1.9871,1.9981,1.9761,1.984,2.0015,1.99,1.9904,1.9796,1.9739),(7,'MEDICINE','University of Moratuwa','Biology','Chemistry','Physics',1.9185,1.9296,1.9184,1.2629,1.9209,1.9703,1.9167,1.9168,1.9306,1.0192,1.3885,1.2343,0.6872,1.257,1.9246,1.2117,1.9159,1.9373,1.9395,1.9326,1.9504,1.2711,1.9518,1.9182,1.9234),(8,'MEDICINE','Eastern University','Biology','Chemistry','Physics',1.9521,1.2295,1.2295,1.2295,1.8334,1.5393,1.2295,1.9481,1.2295,1.2395,1.2295,1.6131,1.2295,1.5661,1.6629,1.7625,1.807,1.6559,1.2295,1.6606,1.5814,1.2295,1.6362,1.7602,1.2295),(9,'MEDICINE','Rajarata University of Sri Lanka','Biology','Chemistry','Physics',1.8923,1.8819,1.891,1.8807,1.8844,1.8987,1.8821,1.8937,1.9324,1.1899,1.1998,1.9274,1.6294,2.0263,1.8836,1.8925,1.8837,1.8784,1.8789,1.8784,1.885,1.8807,1.9014,1.8772,1.8802),(10,'MEDICINE','Sabaragamuwa University of Sri Lanka','Biology','Chemistry','Physics',1.8839,1.7239,1.8613,1.7269,1.8268,1.4374,1.8344,1.8598,1.7785,1.3351,1.8571,1.0307,1.3113,1.2908,1.364,1.7647,1.8268,1.7561,1.8354,1.4009,1.7753,1.7632,1.7286,1.7813,1.8332),(11,'MEDICINE','Wayamba University of Sri Lanka','Biology','Chemistry','Physics',1.8844,1.7779,1.8591,1.7754,1.8131,1.7931,1.8312,1.8604,1.7989,1.7325,1.7325,1.7325,1.7325,1.7325,1.7862,1.7993,1.8152,1.7751,1.8186,1.779,1.78,1.7325,1.8033,1.7887,1.8206),(12,'MEDICINE','Uva Wellassa University','Biology','Chemistry','Physics',1.8893,1.7173,1.0404,1.0404,1.0404,1.5388,1.8352,1.5106,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.682,1.0404,1.0404,1.5233,1.0404,1.7301,1.8748,1.0404),(13,'DENTAL SURGERY','University of Peradeniya','Biology','Chemistry','Physics',1.8293,1.6946,1.8356,1.7257,1.7962,0.5623,1.8171,1.8302,1.7758,1.8361,1.6782,0.5623,1.6538,0.5623,0.5623,1.7593,1.7938,1.6545,1.8112,1.6592,0.5623,1.7375,0.5623,1.7637,1.8058),(14,'DENTAL SURGERY','University of Sri Jayewardenepura','Biology','Chemistry','Physics',1.8283,1.0005,1.835,1.7263,0.6952,1.5299,1.4882,1.4123,1.5369,0.5907,1.4123,1.5449,1.4123,1.5526,1.6355,0.9555,0.1443,1.4123,0.7878,1.6397,1.5004,1.0338,1.6241,0.4951,1.055),(15,'VETERINARY SCIENCE','University of Peradeniya','Biology','Chemistry','Physics',1.7683,1.666,1.7739,1.7064,1.7766,1.5014,1.7758,1.7843,1.7739,1.7256,1.6525,1.5081,1.6381,1.513,1.6335,1.714,1.7754,1.6325,1.7795,1.6258,1.4618,1.7199,1.5953,1.7556,1.7593),(16,'BIOCHEMISTRY & MOLECULAR BIOLOGY','University of Colombo','Biology','Chemistry','Physics',1.7958,1.6837,1.8033,1.6962,1.7727,1.5219,1.7941,1.7612,1.7713,1.8056,1.5353,1.5368,1.4995,1.5032,1.6277,1.7484,1.741,1.6444,1.7978,1.6198,1.4577,1.7072,1.569,1.736,1.7558),(17,'AGRICULTURAL TECHNOLOGY & MANAGEMENT','University of Peradeniya','Accounting','Business Statistics','Economics',1.3103,1.2666,1.3915,1.3837,1.3761,1.274,1.3836,1.3573,1.3956,1.3066,1.224,1.0367,0.9756,1.2406,1.3445,1.3145,1.2847,1.2587,1.376,1.3555,1.3517,1.3546,1.3388,1.3768,1.3958),(18,'AGRICULTURE','University of Jaffna','Biology','Chemistry','Physics',0.7425,0.7549,0.8398,0.8328,0.877,0.7491,0.7838,0.8417,0.9608,0.7592,1.3605,1.2247,0.9905,0.7733,0.8475,0.7507,0.7714,0.7433,0.8194,0.7443,0.8022,0.7521,0.7433,0.7841,0.9638),(19,'AGRICULTURE','Eastern University','Biology','Chemistry','Physics',0.6968,0.6345,2.1862,1.3579,0.8219,0.5643,0.7825,1.2933,0.8399,1.877,0.5012,0.6012,0.6048,0.6219,0.7006,0.7402,0.7663,0.6287,0.8324,0.7483,0.6254,0.7949,0.7379,0.7971,1.2661),(20,'AGRICULTURE','Rajarata University of Sri Lanka','Biology','Chemistry','Physics',0.856,0.8515,0.8497,0.867,0.8461,0.9644,0.856,0.8463,0.8448,1.6744,1.5664,1.5235,1.6429,0.8461,1.9382,0.9077,0.87,0.8554,0.8432,0.8446,0.8535,0.8443,0.9645,0.8679,0.8481),(21,'AGRICULTURE','Sabaragamuwa University of Sri Lanka','Biology','Chemistry','Physics',0.8864,0.8772,0.8511,0.876,0.8658,1.7038,0.8476,0.8568,0.8505,0.864,1.3807,1.3635,1.2535,1.0018,0.944,0.8707,0.8782,0.9823,0.8466,0.8791,1.3636,0.8479,0.978,0.8568,0.8488),(22,'AGRICULTURE','Wayamba University of Sri Lanka','Biology','Chemistry','Physics',0.774,0.775,0.8456,0.7815,0.8226,0.7928,0.7868,0.8255,1.03,0.8245,1.3024,0.8114,0.782,1.4716,1.4187,0.8639,0.7766,0.8088,0.814,0.7754,0.8033,0.7997,0.7842,0.7971,0.8788),(23,'FOOD SCIENCE & NUTRITION','Wayamba University of Sri Lanka','Biology','Chemistry','Physics',1.2507,1.2023,1.3034,1.1976,1.27,1.15,1.2983,1.2954,1.2782,1.3383,1.0777,1.1288,0.9761,1.3072,1.2216,1.1667,1.3276,1.182,1.2634,1.2263,1.0015,1.2661,1.2477,1.2552,1.2787),(24,'FOOD SCIENCE & TECHNOLOGY','University of Peradeniya','Biology','Chemistry','Physics',1.5155,1.5225,1.5596,1.5572,1.5401,1.3732,1.5249,1.5279,1.5548,1.5168,0.9873,1.2621,1.0614,1.5613,1.855,1.5516,1.6636,1.5855,1.518,1.5922,1.4798,1.4307,1.2915,1.5138,1.5298),(25,'FOOD SCIENCE & TECHNOLOGY','University of Sri Jayewardenepura','Biology','Chemistry','Physics',1.4832,1.6137,1.4886,1.4206,1.5032,1.4206,1.4909,1.4867,1.5018,1.5066,1.2532,1.283,0.9865,1.0917,1.1956,1.4078,1.4938,1.4844,1.4843,1.5075,1.2238,1.489,1.4839,1.4957,1.5024),(26,'FOOD SCIENCE & TECHNOLOGY','Sabaragamuwa University of Sri Lanka','Biology','Chemistry','Physics',1.3548,1.1852,1.4467,1.3071,1.2235,1.0563,1.4626,1.4611,1.4865,1.3203,0.955,1.3077,0.6412,1.3227,1.1702,1.1386,1.2912,1.1741,1.3743,1.2375,0.9268,1.2414,1.2627,1.428,1.3214),(27,'BIOLOGICAL SCIENCE','University of Colombo','Biology','Chemistry','Physics',1.6763,1.425,1.6801,1.676,1.6828,1.4971,1.7027,1.6879,1.6831,1.7169,1.7492,0.5439,0.5752,0.7209,1.2373,1.1797,1.679,1.7492,1.6782,1.2571,1.7492,1.6993,1.7492,1.6789,1.7219),(28,'INFORMATION COMMUNICATION TECHNOLOGY','Rajarata University of Sri Lanka','Any','Any','Any',1.3093,1.3078,1.3678,1.3244,1.3143,NULL,1.319,1.3708,1.3232,1.3191,NULL,NULL,NULL,1.6092,NULL,1.3336,1.3531,1.3607,1.3087,1.3081,NULL,1.3153,1.4399,1.3136,1.3316),(29,'INFORMATION COMMUNICATION TECHNOLOGY','University of Vavuniya, Sri Lanka','Any','Any','Any',0.9957,1.0597,1.1115,NULL,1.0452,0.7393,1.208,NULL,NULL,1.0424,0.7644,1.0269,NULL,0.7387,0.7827,1.0522,0.9723,0.5638,1.2342,1.1234,0.7616,1.151,0.9637,1.1071,1.2728),(30,'INFORMATION COMMUNICATION TECHNOLOGY','Uva Wellassa University','Any','Any','Any',1.4149,1.4277,1.4458,1.6619,1.4339,1.4586,1.416,1.421,1.4271,1.5612,1.4769,1.4505,NULL,1.5851,1.7163,1.4486,1.4265,NULL,1.4134,1.4247,1.6761,1.4407,NULL,1.4467,1.421),(31,'PHYSICAL SCIENCE -ICT','University of Sri Jayewardenepura','Combined Mathematics','Physics','ICT',1.1908,1.1345,1.1845,NULL,1.1124,NULL,1.162,1.1164,NULL,1.0998,NULL,NULL,NULL,NULL,NULL,1.2323,NULL,NULL,1.0998,NULL,NULL,NULL,NULL,1.1566,1.1909),(32,'PHYSICAL SCIENCE -ICT','University of Kelaniya','Combined Mathematics','Physics','ICT',1.1866,1.166,1.2014,0.8941,1.0946,0.4277,1.2264,1.2083,1.0391,1.0986,0.5722,0.6337,0.0388,0.6811,0.6716,0.8356,0.5862,0.7157,1.2189,1.0364,0.7627,0.8586,0.937,1.3198,NULL),(33,'TRANSLATION STUDIES','University of Kelaniya','Any','Any','Any',1.4103,1.5729,1.4806,NULL,1.3807,NULL,1.3632,1.3626,1.4886,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.3898,1.5464,1.3598,NULL,NULL,1.3493,1.4802,1.3633,1.3517),(34,'TRANSLATION STUDIES','University of Jaffna','Any','Any','Any',0.368,1.5504,0.9418,NULL,1.1325,1.2474,1.2569,NULL,NULL,1.2782,1.1581,1.141,1.1309,1.0733,1.461,1.1763,1.1062,1.111,1.0581,1.0245,NULL,1.0642,NULL,0.9524,1.4848),(35,'TRANSLATION STUDIES','Eastern University','Any','Any','Any',0.3629,-0.2409,0.7202,0.959,NULL,1.2544,1.0091,0.4792,0.7277,1.2542,NULL,NULL,NULL,NULL,1.0663,1.3005,1.1194,NULL,NULL,NULL,1.24,NULL,1.2288,1.0892,0.9773),(36,'TRANSLATION STUDIES','Sabaragamuwa University of Sri Lanka','Any','Any','Any',1.1323,1.2243,1.2748,1.3284,1.2239,1.1365,1.3108,1.2614,1.2174,NULL,NULL,NULL,NULL,0.8947,1.1143,NULL,1.1321,1.0474,1.2767,1.2467,1.2668,1.302,1.2875,1.2129,1.2682),(37,'FILM & TELEVISION STUDIES','University of Kelaniya','Any','Any','Any',1.1583,1.1127,1.097,1.1714,1.0077,1.2121,1.0667,1.2136,1.0386,NULL,NULL,NULL,NULL,0.5614,NULL,NULL,1.0108,0.5864,1.1039,1.1439,NULL,0.6067,0.7993,1.0445,1.1578),(38,'PROJECT MANAGEMENT','University of Vavuniya, Sri Lanka','Accounting','Business Statistics','Economics',1.247,1.2222,1.2551,1.25,1.2085,1.2333,1.2303,1.265,1.2456,1.131,0.946,0.8494,1.0971,1.1236,1.2643,1.1718,1.1659,1.1432,1.2554,1.2436,1.248,1.1986,1.1596,1.2167,1.2549),(39,'TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','University of Sri Jayewardenepura','Any','Any','Any',1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832,1.0832),(40,'TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','University of Kelaniya','Any','Any','Any',1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387,1.0387),(41,'TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','Sabaragamuwa University of Sri Lanka','Any','Any','Any',0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117,0.8117),(42,'VISUAL ARTS','Unknown University','Any','Any','Any',0.5315,0.8515,1.0227,0.5271,0.0982,NULL,0.3292,1.1681,1.1122,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.5326,-0.1208,1.0163,1.0994,0.9694,0.8007,0.8194,1.1146,0.8924),(43,'MUSIC','University of Sri Jayewardenepura','Any','Any','Any',0.123,0.4842,1.0121,NULL,1.0062,1.103,0.8914,0.809,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.4124,0.4099,0.6443,1.0226,0.3826,0.6952,0.6099,0.8747),(44,'MUSIC','Unknown University','Any','Any','Any',0.4263,0.4165,0.558,0.6548,0.7579,0.0416,0.3576,0.8129,0.8204,NULL,NULL,NULL,NULL,1.1697,0.2963,NULL,-0.0562,0.3987,0.8186,0.6988,0.8875,0.8321,0.3954,0.7685,0.7549),(45,'DANCE','Unknown University','Any','Any','Any',0.6736,0.7234,0.8036,0.9088,0.9023,0.3513,0.8266,0.9345,0.8554,NULL,NULL,NULL,NULL,NULL,0.7114,NULL,0.9084,0.8006,0.9726,0.8802,1.0144,0.5671,0.9636,0.9461,0.8235),(46,'DRAMA & THEATRE','Unknown University','Any','Any','Any',0.7988,0.93,0.7708,1.0102,0.4495,-0.0313,0.7974,0.5847,0.2127,NULL,NULL,NULL,NULL,NULL,0.8805,NULL,0.9779,0.9737,1.0072,1.0473,0.8492,0.9378,0.7035,0.4883,0.7332),(47,'ART & DESIGN','University of Jaffna','Any','Any','Any',NULL,NULL,0.5401,NULL,0.0905,0.4648,-0.318,NULL,NULL,0.5392,-0.1328,0.5451,0.4236,NULL,0.4401,0.4818,0.0716,0.5182,NULL,0.5615,0.8098,NULL,NULL,NULL,NULL),(48,'MUSIC','University of Jaffna','Any','Any','Any',0.333,NULL,NULL,0.4766,-0.3197,-0.137,NULL,NULL,NULL,0.4041,-0.266,0.5185,0.4687,0.146,0.2517,0.1242,-0.7518,NULL,NULL,NULL,NULL,-0.4263,NULL,0.3277,1.0916),(49,'DANCE','University of Jaffna','Any','Any','Any',0.1082,-0.0258,NULL,NULL,-0.1414,-0.5522,NULL,NULL,NULL,0.4982,0.0461,0.3532,0.0187,0.2858,0.1343,0.4758,-0.2114,NULL,NULL,NULL,NULL,-0.2802,NULL,-0.5849,NULL),(50,'VISUAL & TECHNOLOGICAL ARTS','Swami Vipulananda Institute of Aesthetic Studies','Any','Any','Any',NULL,NULL,NULL,-0.1961,0.7345,0.4364,NULL,NULL,NULL,0.0511,NULL,0.0364,0.5031,NULL,-0.2308,-0.3346,-0.1498,0.2707,NULL,-0.3148,0.1438,NULL,NULL,-0.0486,0.506),(51,'MUSIC','Swami Vipulananda Institute of Aesthetic Studies','Any','Any','Any',0.5904,NULL,0.4717,0.1644,-0.4646,-0.3608,NULL,NULL,NULL,0.1727,NULL,-0.0179,0.1743,0.8642,-0.4184,0.1586,-0.0022,NULL,NULL,NULL,NULL,-0.2506,NULL,-0.0067,NULL),(52,'DANCE','Swami Vipulananda Institute of Aesthetic Studies','Any','Any','Any',-0.4587,NULL,-0.0127,NULL,-0.3773,-0.0454,NULL,NULL,NULL,0.4436,0.0287,0.2395,0.2583,0.3834,-0.432,0.5702,0.4605,NULL,NULL,NULL,NULL,-0.1256,NULL,0.2069,-0.3294),(53,'DRAMA & THEATRE','Swami Vipulananda Institute of Aesthetic Studies','Any','Any','Any',NULL,0.0426,NULL,-0.1572,-0.1919,0.2174,NULL,NULL,NULL,0.851,0.8762,0.712,0.7996,0.5193,0.9294,0.901,0.695,-0.3525,NULL,NULL,-0.2942,0.2536,NULL,0.2055,0.5105),(54,'BIOLOGICAL SCIENCE','University of Peradeniya','Biology','Chemistry','Physics',1.5223,1.5237,1.5306,1.5303,1.522,NULL,1.522,1.5398,1.5416,1.5286,NULL,NULL,NULL,NULL,1.5537,1.5291,1.5583,1.5684,1.5262,1.5316,NULL,1.5286,NULL,1.5228,1.5275),(55,'BIOLOGICAL SCIENCE','University of Sri Jayewardenepura','Biology','Chemistry','Physics',1.4661,1.4683,1.4672,1.4677,1.4672,1.4705,1.4695,1.4706,1.4675,1.467,NULL,NULL,NULL,NULL,NULL,1.4677,1.5019,1.4826,1.4668,1.4706,NULL,1.4797,1.5682,1.4683,1.4706),(56,'BIOLOGICAL SCIENCE','University of Kelaniya','Biology','Chemistry','Physics',1.4074,1.4075,1.4108,1.4236,1.4077,NULL,1.41,1.4255,1.4126,1.4459,NULL,NULL,NULL,NULL,NULL,1.4174,1.4297,1.4216,1.413,1.4134,1.4386,1.4117,1.4347,1.4099,1.4115),(57,'BIOLOGICAL SCIENCE','University of Jaffna','Biology','Chemistry','Physics',1.3405,1.1314,1.3636,1.1434,1.2149,1.1783,1.3784,1.1355,1.1593,1.2472,1.2491,NULL,NULL,1.2182,1.1836,1.1654,1.1368,1.1363,1.1691,1.1359,1.1405,1.1489,1.2006,1.1387,1.1329),(58,'BIOLOGICAL SCIENCE','University of Ruhuna','Biology','Chemistry','Physics',1.3291,1.2994,1.3042,1.2923,1.291,1.3369,1.3157,1.2887,1.2869,1.4033,NULL,NULL,NULL,NULL,NULL,NULL,1.3162,1.3919,1.2875,1.2862,1.2956,1.3094,1.2935,1.2882,1.2955),(59,'BIOLOGICAL SCIENCE','Eastern University','Biology','Chemistry','Physics',NULL,0.9855,NULL,1.0242,1.2058,0.9897,NULL,1.0455,1.2,NULL,NULL,NULL,0.9991,NULL,0.9869,0.997,0.9914,1.0206,1.1741,0.9935,1.0094,0.9912,0.9888,1.0597,1.1361),(60,'BIOLOGICAL SCIENCE','South Eastern University of Sri Lanka','Biology','Chemistry','Physics',NULL,0.8145,NULL,0.9715,NULL,0.5016,NULL,1.0867,1.1875,NULL,0.5093,0.5493,0.6885,0.43,0.7338,0.9108,0.9785,0.7405,NULL,0.9148,0.7749,0.8879,0.7366,1.2011,NULL),(61,'APPLIED SCIENCES (BIO.SC)','Rajarata University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.0659,1.0824,1.0824,1.0775,1.0644,1.1881,1.0906,1.0733,1.0796,1.0834,NULL,NULL,NULL,NULL,1.1568,1.082,1.2513,1.1077,1.0665,1.071,1.1036,1.1011,1.0762,1.1479,1.0683),(62,'APPLIED SCIENCES (BIO.SC)','Sabaragamuwa University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.0475,1.099,1.0861,NULL,1.0597,NULL,1.0844,1.0597,1.046,1.0711,NULL,NULL,NULL,NULL,NULL,NULL,1.047,1.0611,1.0451,1.0483,NULL,1.051,1.053,1.0559,1.045),(63,'APPLIED SCIENCES (BIO.SC)','University of Vavuniya, Sri Lanka','Combined Mathematics','Physics','Chemistry',0.9798,0.7099,NULL,0.971,NULL,0.5028,NULL,0.9301,1.0152,0.9917,0.5106,0.6943,0.5344,0.7266,0.7358,0.8198,0.9268,0.6614,NULL,0.8835,0.6723,0.8507,0.742,0.8356,NULL),(64,'ENGINEERING','University of Peradeniya','Combined Mathematics','Physics','Chemistry',1.8993,1.9004,1.8993,1.9395,1.9062,1.9043,1.9083,1.9034,1.911,1.9123,NULL,1.9762,NULL,1.9837,1.9472,1.9029,1.9514,1.9096,1.9059,1.9065,1.9166,1.9027,1.9489,1.9069,1.9015),(65,'ENGINEERING','University of Sri Jayewardenepura','Combined Mathematics','Physics','Chemistry',1.8173,1.8238,1.8256,NULL,1.8299,NULL,1.8308,1.8589,1.8333,1.8166,NULL,NULL,NULL,NULL,NULL,1.8335,1.8573,1.8804,1.8173,1.8462,1.8192,1.8168,NULL,1.8169,1.8784),(66,'ENGINEERING','University of Jaffna','Combined Mathematics','Physics','Chemistry',NULL,1.5419,NULL,1.355,1.5938,1.374,NULL,NULL,NULL,1.6341,1.5263,NULL,1.4026,1.5431,1.3606,1.4557,1.3617,1.3489,1.6078,1.3575,1.3548,1.3977,1.3537,NULL,NULL),(67,'ENGINEERING','University of Ruhuna','Combined Mathematics','Physics','Chemistry',1.7896,1.6191,1.7439,1.6413,1.6175,1.6321,1.7726,1.8598,1.677,1.699,1.6248,1.7861,1.7731,1.6545,1.6581,1.6231,1.6193,1.6637,1.624,1.6381,1.6258,1.617,1.6886,1.6393,1.6336),(68,'ENGINEERING','University of Moratuwa','Combined Mathematics','Physics','Chemistry',2.0708,2.0715,2.0778,2.1285,2.1012,2.1317,2.0711,2.0708,2.0774,2.0735,2.1312,NULL,2.6297,2.1521,2.0845,2.1131,2.0731,2.072,2.0742,2.0834,2.0805,2.0729,2.1018,2.0821,2.0864),(69,'ENGINEERING','South Eastern University of Sri Lanka','Combined Mathematics','Physics','Chemistry',NULL,NULL,NULL,1.283,NULL,0.9915,NULL,NULL,NULL,NULL,1.5908,0.9977,0.8496,0.8926,1.002,NULL,1.3611,1.156,NULL,1.3247,0.9744,1.5593,1.2636,NULL,NULL),(70,'ENGINEERING  (EM)','University of Moratuwa','Combined Mathematics','Physics','Chemistry',1.6128,1.523,1.6372,1.5485,1.6052,1.2766,1.6177,1.6211,1.5316,1.3428,1.4093,1.0591,0.7279,1.0141,1.3231,1.4554,1.3556,1.4397,1.5901,1.3359,1.5149,1.474,1.61,1.5618,1.6191),(71,'ENGINEERING  (TM)','University of Moratuwa','Combined Mathematics','Physics','Chemistry',1.6254,1.5573,1.6217,1.3858,1.5863,1.2477,1.6418,1.6303,1.5542,1.3633,1.4223,0.7844,0.7512,1.0891,1.1033,1.357,1.3961,1.4443,1.5863,1.3581,1.5136,1.5063,1.613,1.6072,1.6215),(72,'QUANTITY SURVEYING','University of Moratuwa','Any','Any','Any',1.454,1.4383,1.4837,1.26,1.4399,1.1906,1.4652,1.4847,1.4738,1.3728,1.3933,0.9649,0.8133,1.1327,1.1632,1.3099,1.3332,1.1753,1.4789,1.3119,1.1543,1.3928,1.2924,1.4814,1.4976),(73,'COMPUTER SCIENCE','University of Colombo','Combined Mathematics','Physics','ICT',1.6607,1.6646,1.6729,NULL,1.6662,NULL,1.6641,1.6684,1.6617,1.6718,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.7143,1.677,1.6989,NULL,1.6846,NULL,1.7736,1.6896),(74,'COMPUTER SCIENCE','University of Sri Jayewardenepura','Combined Mathematics','Physics','ICT',1.5804,1.5831,1.5816,NULL,NULL,NULL,1.5831,1.6012,1.6017,1.5804,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.5775,1.5809),(75,'COMPUTER SCIENCE','University of Kelaniya','Combined Mathematics','Physics','ICT',1.5846,1.6109,1.5755,NULL,1.5706,NULL,1.5707,1.6007,1.5746,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.5985,NULL,NULL,NULL,NULL,NULL,NULL,1.5702,1.6243),(76,'COMPUTER SCIENCE','University of Jaffna','Combined Mathematics','Physics','ICT',1.3958,1.1987,NULL,NULL,1.1849,NULL,NULL,NULL,NULL,1.3857,1.2435,NULL,NULL,NULL,1.3243,1.1767,1.2216,1.1762,1.2362,1.1889,NULL,1.1798,NULL,1.251,1.2068),(77,'COMPUTER SCIENCE','University of Ruhuna','Combined Mathematics','Physics','ICT',1.4176,1.4118,1.4253,NULL,1.4118,NULL,1.4368,NULL,1.4324,NULL,1.4432,NULL,NULL,NULL,NULL,NULL,NULL,1.5461,1.4242,NULL,NULL,1.4112,NULL,1.4163,1.43),(78,'COMPUTER SCIENCE','Trincomalee Campus, Eastern University, Sri Lanka','Combined Mathematics','Physics','ICT',NULL,1.1877,NULL,0.7375,1.0294,0.7166,NULL,NULL,NULL,1.3817,NULL,0.4759,0.4575,0.5855,0.5849,1.1293,1.064,0.8402,1.2762,1.0512,0.6562,1.0916,0.9039,1.3607,1.3014),(79,'PHYSICAL SCIENCE','University of Colombo','Combined Mathematics','Physics','Chemistry',1.4027,1.4028,1.4071,NULL,1.4051,1.4025,1.4033,1.4072,1.4044,1.4109,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.4555,1.4033,1.466,NULL,NULL,NULL,1.4046,1.4037),(80,'PHYSICAL SCIENCE','University of Peradeniya','Combined Mathematics','Physics','Chemistry',1.289,1.2924,1.2942,1.2953,1.2874,1.4071,1.289,1.2876,1.2906,1.2947,NULL,NULL,NULL,NULL,NULL,1.3465,NULL,1.2894,1.2989,1.3136,NULL,1.291,NULL,1.3243,1.2926),(81,'PHYSICAL SCIENCE','University of Sri Jayewardenepura','Combined Mathematics','Physics','Chemistry',1.2351,1.2322,1.2333,NULL,1.2451,NULL,1.2413,1.2326,1.2322,1.2454,NULL,NULL,NULL,NULL,NULL,NULL,1.2609,NULL,1.2336,NULL,NULL,1.2558,NULL,1.2331,1.2457),(82,'PHYSICAL SCIENCE','University of Kelaniya','Combined Mathematics','Physics','Chemistry',1.14,1.1415,1.1393,1.1891,1.1415,NULL,1.1407,1.1394,1.1401,1.1424,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.1401,1.1423,1.1471,NULL,1.1571,1.218,1.1615,1.1417),(83,'PHYSICAL SCIENCE','University of Jaffna','Combined Mathematics','Physics','Chemistry',0.9527,0.8866,1.031,0.8668,0.9485,0.8758,NULL,NULL,NULL,0.9421,0.9653,NULL,NULL,NULL,NULL,0.8644,0.905,0.8917,0.9577,0.8624,0.8872,0.8774,0.8638,0.9081,0.9881),(84,'PHYSICAL SCIENCE','University of Ruhuna','Combined Mathematics','Physics','Chemistry',1.0667,1.0668,1.0664,1.0864,1.0692,NULL,1.0763,1.1148,1.07,NULL,1.0711,NULL,NULL,NULL,NULL,1.0747,1.1077,1.0663,1.0674,1.0661,NULL,1.0705,1.0822,1.0692,1.0705),(85,'PHYSICAL SCIENCE','Eastern University','Combined Mathematics','Physics','Chemistry',0.9551,0.9392,1.0295,0.7518,0.9573,0.6325,NULL,NULL,NULL,0.9613,0.715,NULL,NULL,NULL,0.7345,0.7492,0.7802,0.6233,0.9627,0.7366,0.6544,0.8759,0.7269,0.9095,0.9882),(86,'PHYSICAL SCIENCE','South Eastern University of Sri Lanka','Combined Mathematics','Physics','Chemistry',0.9551,0.9097,1.0305,0.766,0.9537,0.3413,NULL,NULL,NULL,0.9778,0.5508,0.3005,0.1576,0.2648,0.2116,0.8315,0.8012,0.5541,NULL,0.7544,0.4831,0.9158,0.715,0.9163,NULL),(87,'SURVEYING SCIENCE','Sabaragamuwa University of Sri Lanka','Any','Any','Any',1.0726,1.0307,1.1373,0.9115,1.1331,0.9032,1.1156,1.1967,1.1648,1.1933,1.0961,0.6937,0.6691,0.5994,0.9109,1.1073,1.1392,0.9851,1.1294,1.0705,0.9086,1.0986,1.15,1.1278,1.1071),(88,'APPLIED SCIENCES  (PHY.SC)','Rajarata University of Sri Lanka','Combined Mathematics','Physics','Chemistry',0.9673,0.9703,0.9679,1.0151,0.9686,NULL,0.9684,0.9681,0.9723,1.0063,NULL,NULL,NULL,NULL,NULL,0.9703,0.9849,NULL,0.995,0.9775,NULL,0.9712,0.991,0.9826,0.9686),(89,'APPLIED SCIENCES  (PHY.SC)','Sabaragamuwa University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.035,1.035,1.0328,NULL,1.0323,NULL,1.0305,1.0355,1.0378,1.0328,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.0352,NULL,NULL,1.0426,NULL,1.0404,1.0418),(90,'APPLIED SCIENCES  (PHY.SC)','Wayamba University of Sri Lanka','Combined Mathematics','Physics','Chemistry',0.9202,0.9219,0.943,0.9225,0.9203,NULL,0.9433,0.945,0.9439,0.9303,NULL,NULL,NULL,NULL,NULL,0.9337,0.9255,1.0065,0.9202,0.949,0.9488,0.9252,0.9228,0.9232,0.9409),(91,'APPLIED SCIENCES  (PHY.SC)','University of Vavuniya, Sri Lanka','Combined Mathematics','Physics','Chemistry',0.8808,0.86,0.9439,0.7211,0.8947,NULL,NULL,NULL,1.0609,0.8597,0.8399,NULL,NULL,NULL,0.8321,0.7606,0.7226,0.7953,0.9046,0.7264,0.7501,0.8285,0.8244,0.838,NULL),(92,'APPLIED SCIENCES  (PHY.SC)','Trincomalee Campus, Eastern University, Sri Lanka','Combined Mathematics','Physics','Chemistry',0.8795,0.8551,0.9957,0.656,0.9075,0.3008,0.9509,NULL,NULL,0.8597,0.5409,0.2564,-0.0096,0.1837,0.2091,0.7558,0.6975,0.5049,0.8987,0.7152,0.4551,0.8186,0.6776,0.8408,NULL),(93,'MANAGEMENT','University of Colombo','Accounting','Business Statistics','Economics',1.6258,1.6258,1.6505,1.6558,1.6374,1.6291,1.6258,1.629,1.6331,1.671,1.7671,NULL,1.7216,NULL,1.6743,1.8404,1.6742,1.6454,1.6439,1.6442,NULL,1.6507,1.6386,1.6374,1.645),(94,'MANAGEMENT','University of Peradeniya','Accounting','Business Statistics','Economics',1.5149,1.516,1.5152,1.5195,1.516,1.5214,1.546,1.5237,1.5181,1.5514,1.6352,1.5225,1.5814,1.7075,1.5232,1.5225,1.5329,1.5242,1.5248,1.5305,NULL,1.5177,1.6071,1.5212,1.5157),(95,'MANAGEMENT','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',1.6277,1.6276,1.6323,1.6462,1.632,1.6614,1.6309,1.6269,1.6425,1.6323,1.7552,1.7765,1.9551,1.6901,1.6425,1.644,1.659,1.6478,1.6323,1.6291,1.6583,1.633,1.628,1.6417,1.6269),(96,'MANAGEMENT','University of Kelaniya','Accounting','Business Statistics','Economics',1.5541,1.5547,1.5565,1.5629,1.5634,1.5583,1.5546,1.5557,1.5583,NULL,NULL,NULL,NULL,NULL,1.5984,1.5629,1.5634,1.5539,1.5546,1.5546,1.5832,1.5546,1.5597,1.5539,1.5543),(97,'MANAGEMENT','University of Jaffna','Accounting','Business Statistics','Economics',1.3309,1.2952,NULL,1.256,1.2069,1.0607,NULL,NULL,1.1506,1.0632,1.1018,1.1173,1.1405,1.0744,1.0726,1.074,1.1105,1.0952,1.2911,1.1358,1.0608,1.211,1.3038,1.2127,1.4089),(98,'MANAGEMENT','University of Ruhuna','Accounting','Business Statistics','Economics',1.3902,1.391,1.3902,1.3909,1.3913,1.4025,1.3916,1.3902,1.3975,1.482,NULL,1.4043,NULL,NULL,1.4419,1.417,1.3914,1.3931,1.3974,1.4173,1.4014,1.3917,1.3902,1.3927,1.3913),(99,'MANAGEMENT','Eastern University','Accounting','Business Statistics','Economics',1.3233,1.3642,NULL,NULL,1.2146,1.0325,NULL,NULL,1.1543,1.002,1.0094,0.9684,0.9981,0.9721,0.855,1.0313,0.9855,1.1391,NULL,1.1835,1.0587,1.22,NULL,1.2099,NULL),(100,'MANAGEMENT','South Eastern University of Sri Lanka','Accounting','Business Statistics','Economics',1.3729,NULL,NULL,NULL,1.2055,1.0556,NULL,NULL,1.1557,1.0296,NULL,0.9923,NULL,1.04,0.8568,1.0483,0.9851,1.1745,NULL,NULL,NULL,NULL,NULL,1.2084,NULL),(101,'MANAGEMENT','Rajarata University of Sri Lanka','Accounting','Business Statistics','Economics',1.3161,1.29,1.3345,1.2521,1.2373,1.2417,1.3005,1.3226,1.2392,NULL,NULL,NULL,1.4426,1.2366,1.2366,1.2518,1.24,1.2406,1.279,1.2373,1.2594,1.2422,1.2605,1.2373,1.3385),(102,'MANAGEMENT','Sabaragamuwa University of Sri Lanka','Accounting','Business Statistics','Economics',1.3186,1.303,1.3328,1.3081,1.3184,1.3172,1.3024,1.3254,1.3035,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.319,1.3731,1.3027,1.3306,1.3061,1.3025,1.3045,1.3056,1.3376),(103,'MANAGEMENT','Wayamba University of Sri Lanka','Accounting','Business Statistics','Economics',1.3215,1.3078,1.3381,1.3146,1.3111,1.3078,1.323,1.3761,1.3468,1.3165,NULL,1.3931,NULL,NULL,1.3162,1.3396,1.336,1.3136,1.3081,1.3317,1.3125,1.3209,1.3262,1.3168,1.3382),(104,'REAL ESTATE MANAGEMENT & VALUATION','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',1.4791,1.4162,1.4561,1.4621,1.4452,1.4303,1.4835,1.4499,1.4462,1.3895,1.3616,1.3356,0.966,1.486,1.4234,1.491,1.4484,1.3474,1.4864,1.4246,1.4686,1.4661,1.4331,1.4769,1.491),(105,'COMMERCE','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',1.5329,1.5312,1.533,1.5336,1.5387,NULL,1.5308,1.538,NULL,NULL,NULL,NULL,NULL,1.5929,NULL,1.6037,NULL,NULL,1.5416,1.5467,1.624,1.5359,NULL,1.577,1.5467),(106,'COMMERCE','University of Kelaniya','Accounting','Business Statistics','Economics',1.4484,1.4504,1.4524,1.4534,1.4509,1.4578,1.4505,1.4581,1.456,NULL,NULL,1.4842,NULL,1.5004,NULL,1.4643,1.4745,1.4488,1.4534,1.4494,1.4664,1.4527,1.478,1.4523,1.4491),(107,'COMMERCE','University of Jaffna','Accounting','Business Statistics','Economics',1.2653,1.2333,1.2478,1.2476,1.2406,NULL,1.2354,1.2448,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.396,1.2251,NULL,NULL,NULL,1.2273,NULL,1.2897),(108,'COMMERCE','Eastern University','Accounting','Business Statistics','Economics',1.2645,1.2356,1.2573,1.1853,1.1525,0.9916,1.2335,1.2264,1.1297,0.992,NULL,NULL,NULL,NULL,1.1387,0.9995,1.0385,1.0194,1.1991,1.0371,1.0206,1.1346,1.1629,1.1614,1.3031),(109,'COMMERCE','South Eastern University of Sri Lanka','Accounting','Business Statistics','Economics',1.2652,1.2415,1.2655,1.2045,1.1521,0.9038,1.2497,1.2486,1.1253,0.9554,0.9002,0.8637,0.8983,0.8828,0.7867,0.9608,0.932,1.0296,1.2044,1.0328,1.0332,1.1362,1.2001,1.1698,1.2922),(110,'MANAGEMENT AND PUBLIC POLICY','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',1.4487,1.3833,1.3928,1.4387,1.4004,1.435,1.3986,1.4105,1.3801,1.3396,1.2535,1.4093,1.1083,1.4451,1.4661,1.3797,1.3942,1.4306,1.3872,1.3808,1.444,1.3768,1.354,1.4285,1.397),(111,'BUSINESS INFORMATION SYSTEMS (HONOURS) (BIS)','University of Sri Jayewardenepura','Any','Any','Any',1.8539,1.8091,1.8223,1.4611,1.6746,1.4603,1.7008,1.8499,1.7737,1.626,1.59,1.6063,1.2232,1.5748,1.6041,1.7903,1.5531,1.7853,1.7639,1.6862,1.6645,1.6563,1.8354,1.7522,1.793),(112,'FINANCIAL ENGINEERING','University of Kelaniya','Combined Mathematics','Physics','Chemistry',1.6718,1.6844,1.6566,1.6634,1.5737,1.525,1.6403,1.6323,1.5586,1.4054,1.345,0.8549,0.8791,1.2761,1.3764,1.6692,1.4548,1.5496,1.5818,1.6127,1.4422,1.6573,1.524,1.496,1.6222),(113,'BANKING & INSURANCE','University of Vavuniya, Sri Lanka','Any','Any','Any',1.2358,1.233,1.267,1.2012,1.1943,1.1047,1.2676,1.262,1.2117,1.0513,1.0025,0.7953,1.0215,0.9619,1.1019,1.1726,0.9505,1.0691,1.2323,1.135,1.0386,1.2073,1.1817,1.1932,1.254),(114,'SERVICE MANAGEMENT','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Accounting','Business Statistics','Economics',1.2922,1.2168,1.276,1.1687,1.1511,1.0057,1.294,1.2648,1.2395,1.0192,0.9211,0.7186,0.6872,0.9308,1.0179,0.9443,0.9749,1.259,1.1897,1.2214,0.994,1.2869,1.229,1.2077,1.2633),(115,'LAW','University of Colombo','Any','Any','Any',1.9595,1.9631,1.9479,1.9674,1.9568,1.9872,1.9481,1.9469,1.9481,1.9574,2.0071,1.9489,1.9931,2.0501,1.9648,1.9889,1.9483,1.962,1.9497,1.9611,1.9491,1.9468,2.0022,1.9491,1.9586),(116,'LAW','University of Peradeniya','Any','Any','Any',1.9132,1.9165,1.9245,1.919,1.9157,NULL,NULL,NULL,NULL,1.91,1.9279,1.926,2.0482,1.9297,1.9471,1.9366,1.9136,NULL,1.9138,1.9105,1.9219,1.9208,1.9161,1.9172,1.9069),(117,'LAW','University of Jaffna','Any','Any','Any',1.8486,1.781,NULL,1.8643,1.815,1.7558,NULL,NULL,NULL,1.8999,NULL,NULL,NULL,NULL,1.834,1.8059,1.8907,1.7659,1.8658,1.8814,1.7849,1.87,1.8574,1.7983,1.8518),(118,'ARTS','University of Colombo','Any','Any','Any',1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852,1.6852),(119,'ARTS','University of Peradeniya','Any','Any','Any',1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106,1.5106),(120,'ARTS','University of Sri Jayewardenepura','Any','Any','Any',1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138,1.5138),(121,'ARTS','University of Kelaniya','Any','Any','Any',1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123,1.4123),(122,'ARTS','University of Jaffna','Any','Any','Any',1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661,1.1661),(123,'ARTS','University of Ruhuna','Any','Any','Any',1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397,1.3397),(124,'ARTS','Eastern University','Any','Any','Any',1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335,1.1335),(125,'ARTS','South Eastern University of Sri Lanka','Any','Any','Any',1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247,1.2247),(126,'ARTS','Rajarata University of Sri Lanka','Any','Any','Any',1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933,1.2933),(127,'ARTS  (SP) / MASS MEDIA','University of Colombo','Any','Any','Any',1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837,1.1837),(128,'ARTS (SP) / PERFORMING ARTS','University of Colombo','Any','Any','Any',1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348,1.1348),(129,'ARTS (SAB) - A  [Arts Stream] (Sabaragamuwa University of Sri Lanka)','Unknown University','Any','Any','Any',1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283,1.3283),(130,'ARTS (SAB) - B  [Commerce Stream] (Sabaragamuwa University of Sri Lanka)','Unknown University','Accounting','Business Statistics','Economics',1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556,1.1556),(131,'ARTS-INFORMATION TECHNOLOGY','University of Sri Jayewardenepura','Any','Any','Any',1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946,1.7946),(132,'AQUATIC BIORESOURCES','University of Sri Jayewardenepura','Any','Any','Any',1.1393,1.0532,1.1761,1.0948,1.0372,0.9319,1.1377,1.1809,1.1351,0.9825,0.3227,0.5198,0.3951,0.7431,1.0314,1.0105,1.182,0.8794,0.9967,0.9294,0.9326,1.093,1.006,1.1215,1.138),(133,'URBAN BIORESOURCES','University of Sri Jayewardenepura','Any','Any','Any',1.0297,0.9707,1.0337,0.9398,0.9062,0.9813,1.0536,1.038,1.0378,0.9652,0.3406,0.522,0.4186,1.0122,0.9657,1.0377,0.9415,0.7978,0.9627,0.9864,0.7205,1.0631,1.0021,0.9697,0.921),(134,'SOCIAL WORK','University of Peradeniya','Any','Any','Any',1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492,1.7492),(135,'SOCIAL WORK','University of Sri Jayewardenepura','Any','Any','Any',1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011,1.7011),(136,'HUMAN RESOURCE DEVELOPMENT','Uva Wellassa University','Any','Any','Any',1.3949,1.4482,1.4318,1.4869,1.5533,1.6088,1.4875,1.5859,1.4987,1.5062,1.615,1.404,1.4834,1.4734,1.6058,1.6065,1.6068,1.498,1.5081,1.5567,1.6321,1.5795,1.5128,1.4636,1.577),(137,'PRIMARY EDUCATION','University of Colombo','Any','Any','Any',1.4494,1.702,1.7079,1.5056,1.5017,1.3873,1.8082,1.7735,1.8504,NULL,NULL,NULL,1.0376,1.569,1.6928,NULL,1.6609,1.6847,1.8086,1.7313,1.6646,1.8282,1.8284,1.8004,1.7213),(138,'MANAGEMENT STUDIES (TV) - A','Unknown University','Accounting','Business Statistics','Economics',1.1965,1.2001,1.2171,1.1947,1.1513,0.9381,1.2149,1.2222,1.1296,0.9812,1.0498,0.8087,0.7184,0.9043,0.8481,0.9529,0.9276,1.0078,1.1917,1.0496,1.0096,1.1434,1.1589,1.1698,1.2164),(139,'MANAGEMENT STUDIES (TV) - B','University of Vavuniya, Sri Lanka','Accounting','Business Statistics','Economics',NULL,1.3018,1.3272,1.3356,1.2887,1.2903,1.3614,1.311,1.3101,1.2881,1.3206,1.3623,1.2937,1.4085,1.3231,1.3608,1.2983,1.2912,1.2904,1.291,NULL,1.2877,1.2913,1.3037,1.2891),(140,'MANAGEMENT STUDIES (TV) - B','University of Vavuniya, Sri Lanka','Accounting','Business Statistics','Economics',1.2185,1.2407,1.262,1.2884,1.2629,1.2768,1.2768,1.2758,1.2821,1.1653,1.2385,1.2543,NULL,1.257,1.2725,1.2117,1.2741,1.2795,1.2867,1.2758,1.2613,1.2711,1.2886,1.2692,1.2837),(141,'COMMUNICATION STUDIES','Trincomalee Campus, Eastern University, Sri Lanka','Any','Any','Any',1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295,1.2295),(142,'FINANCIAL ECONOMICS','University of Sri Jayewardenepura','Any','Any','Any',1.734,1.759,1.8109,1.7483,1.784,1.7238,1.6606,1.6807,1.8133,1.701,1.1998,1.2269,1.6294,1.7049,1.729,1.7072,1.35,1.7649,1.8129,1.6345,1.5478,1.6392,1.8095,1.7602,1.8097),(143,'CREATIVE MUSIC TECHNOLOGY & PRODUCTION','University of Sri Jayewardenepura','Any','Any','Any',1.4056,1.408,1.4833,1.364,1.4836,1.4693,1.4374,1.4177,1.4165,1.1292,1.1851,1.0307,1.1313,1.2908,1.2423,1.5004,1.287,1.2702,1.3127,1.4009,1.3583,1.3543,1.3927,1.4692,1.3994),(144,'PEACE & CONFLICT RESOLUTION','University of Kelaniya','Combined Mathematics','Physics','ICT',1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325,1.7325),(145,'ISLAMIC STUDIES','South Eastern University of Sri Lanka','Any','Any','Any',1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404,1.0404),(146,'ARABIC  LANGUAGE','South Eastern University of Sri Lanka','Any','Any','Any',0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623,0.5623),(147,'ARCHITECTURE','University of Moratuwa','Any','Any','Any',1.1819,1.0005,1.0094,0.7945,0.6333,0.6952,0.8565,1.0482,1.159,0.5263,NULL,NULL,NULL,NULL,1.003,0.9555,0.4143,NULL,0.7878,0.6766,1.0769,1.0338,1.0651,1.0611,0.6715),(148,'DESIGN','University of Moratuwa','Any','Any','Any',0.6815,0.8012,0.1606,0.2855,0.6144,0.4703,0.2837,0.3383,0.3272,0.7016,NULL,NULL,NULL,NULL,0.7905,0.4288,NULL,0.7454,-0.6554,0.3075,1.1736,0.023,0.6042,0.4951,0.7549),(149,'LANDSCAPE ARCHITECTURE','University of Moratuwa','Any','Any','Any',0.3447,0.4966,0.1241,NULL,0.3811,NULL,-0.4374,-0.1558,0.869,NULL,NULL,NULL,NULL,NULL,NULL,0.6797,NULL,NULL,0.4728,0.4488,NULL,0.2934,0.6335,0.5762,0.1324),(150,'URBAN INFORMATICS AND PLANNING','University of Moratuwa','Any','Any','Any',1.2136,1.1776,1.226,1.1327,1.1862,0.9851,1.2211,1.2178,1.2402,1.1509,1.0055,1.0302,0.782,0.7852,1.202,1.2412,1.1952,1.0976,1.1787,1.1015,1.0088,1.2271,1.1375,1.2338,1.1556),(151,'FASHION DESIGN & PRODUCT DEVELOPMENT','University of Moratuwa','Any','Any','Any',0.5674,0.16,0.4009,0.3987,0.7513,0.0804,0.435,-0.0244,0.4698,NULL,NULL,NULL,NULL,NULL,NULL,0.7725,0.0851,1.5823,0.2877,0.4044,NULL,0.4619,0.8954,0.1671,0.8502),(152,'ARTIFICIAL INTELLIGENCE','University of Moratuwa','Combined Mathematics','Physics','ICT',2.2536,2.3053,2.1862,2.0932,2.0451,1.9212,2.3586,2.2919,1.9352,2.275,2.2256,1.8449,0.9173,1.4036,1.4382,1.3773,2.1208,1.6831,2.2686,2.0194,1.6899,1.7794,1.6092,2.3459,1.956),(153,'INFORMATION TECHNOLOGY (IT)','University of Moratuwa','Any','Any','Any',1.673,1.5516,1.6681,1.498,1.5673,1.3359,1.7169,1.7311,1.6714,1.7201,1.5666,1.5265,1.6429,1.3569,1.5694,1.5669,1.4792,1.5031,1.5802,1.4144,1.5193,1.4803,1.4574,1.6038,1.5957),(154,'INFORMATION TECHNOLOGY & MANAGEMENT','University of Moratuwa','Accounting','Business Statistics','Economics',1.7009,1.6172,1.726,1.3805,1.5197,1.196,1.7018,1.6877,1.545,1.6493,1.5604,1.3635,1.2535,1.3404,1.3801,1.6856,1.4032,1.3725,1.6696,1.538,1.4278,1.6084,1.7028,1.6918,1.5652),(155,'FACILITIES MANAGEMENT','University of Moratuwa','Accounting','Business Statistics','Economics',1.5279,1.4646,1.4772,1.4187,1.4668,1.3277,1.5387,1.5401,1.4362,1.3523,1.087,1.3204,0.8578,1.4716,1.4495,1.5037,1.4246,1.3826,1.3408,1.4611,1.367,1.4786,1.294,1.484,1.5054),(156,'TRANSPORT MANAGEMENT & LOGISTICS ENGINEERING (TMLE)','University of Moratuwa','Combined Mathematics','Physics','Chemistry',1.7608,1.6644,1.7408,1.3965,1.6717,1.4923,1.7666,1.754,1.6034,1.6058,1.3041,0.9606,0.8922,1.076,1.1689,1.2971,1.3085,1.6518,1.6018,1.4704,1.7157,1.6308,1.5315,1.6,1.6305),(157,'BUSINESS SCIENCE','University of Moratuwa','Any','Any','Any',1.9302,1.8007,1.8275,1.585,1.6237,1.7231,1.7322,1.8344,1.6082,1.5365,1.1112,1.5261,1.0614,1.5642,1.5103,1.6549,1.4671,1.5669,1.6088,1.6694,1.4748,1.7881,1.5333,1.662,1.8758),(158,'MANAGEMENT AND INFORMATION TECHNOLOGY  (MIT) (BIO SCIENCE  STREAM)','University of Kelaniya','Accounting','Business Statistics','Economics',1.4223,1.4152,1.4725,1.1956,1.3799,1.2084,1.4206,1.4475,1.4715,1.5066,0.9873,1.283,0.9865,1.0917,1.3613,1.4597,1.4078,1.2378,1.4652,1.3979,1.2298,1.4307,1.2915,1.4878,1.4743),(159,'MANAGEMENT AND INFORMATION TECHNOLOGY  (MIT) (OTHER STREAM)','University of Kelaniya','Accounting','Business Statistics','Economics',1.4522,1.4525,1.4552,1.2905,1.4255,1.0659,1.4664,1.4823,1.4865,1.4832,1.2532,0.8017,0.655,1.0101,1.0959,1.2986,1.1961,1.2441,1.4531,1.3295,1.1968,1.3899,1.2645,1.4763,1.4599),(160,'INDUSTRIAL STATISTICS & MATHEMATICAL FINANCE','University of Colombo','Any','Any','Any',1.4991,1.425,1.4482,1.2373,1.4877,0.9885,1.4971,1.4519,1.3956,1.3934,1.0812,0.5439,0.5752,0.7209,0.991,1.1632,1.1797,1.2356,1.3559,1.2571,1.1214,1.3862,1.2627,1.4696,1.4398),(161,'FINANCIAL MATHEMATICS AND INDUSTRIAL STATISTICS','University of Ruhuna','Any','Any','Any',1.2946,1.2724,1.3397,1.1401,1.2445,0.9467,1.3217,1.3354,1.2883,1.3125,0.9258,0.4915,0.5028,0.6282,0.9003,1.1414,1.1654,1.0905,1.2235,1.2082,0.8997,1.307,1.1214,1.2429,1.2593),(162,'STATISTICS & OPERATIONS RESEARCH','University of Peradeniya','Any','Any','Any',1.4013,1.411,1.3997,1.2703,1.4329,1.0846,1.4614,1.4423,1.4161,1.4489,1.1908,0.5798,0.5134,0.6349,1.0992,1.2838,1.2402,1.174,1.3564,1.2881,1.1071,1.3757,1.2152,1.3824,1.4333),(163,'GEOGRAPHICAL INFORMATION SCIENCE','University of Peradeniya','Any','Any','Any',1.8821,1.9386,2.0067,1.7796,1.9892,1.964,1.9225,2.0075,1.9936,2.011,1.8642,1.9387,1.8842,1.8609,1.9927,2.0244,1.9931,1.843,1.9631,1.8899,1.8043,1.9101,2.0211,1.9234,1.8946),(164,'INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)','Rajarata University of Sri Lanka','Combined Mathematics','Physics','ICT',1.2931,1.2888,1.298,1.291,1.295,NULL,1.288,1.2961,1.3009,1.309,NULL,NULL,NULL,NULL,1.3697,1.29,1.3624,1.3384,1.2958,1.3059,NULL,1.2903,NULL,1.2921,1.3047),(165,'INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)','University of Vavuniya, Sri Lanka','Combined Mathematics','Physics','ICT',1.1864,1.2194,1.2451,1.2507,1.1677,0.7939,1.2775,1.2699,1.1536,1.2357,0.8754,1.0182,0.5233,1.1384,1.1494,1.1955,1.1825,1.0247,1.2195,1.12,1.0186,1.2117,1.1485,1.1816,1.2641),(166,'INFORMATION SYSTEMS','University of Colombo','Any','Any','Any',1.7906,1.7959,1.817,1.7898,1.7941,1.9191,1.798,1.8163,1.8426,1.8243,NULL,NULL,NULL,NULL,NULL,NULL,1.8722,NULL,1.8508,1.905,NULL,2.2297,NULL,1.8466,1.8422),(167,'INFORMATION SYSTEMS','University of Sri Jayewardenepura','Any','Any','Any',1.7618,1.7435,1.752,NULL,NULL,1.7511,1.7467,1.7521,1.7603,1.7491,NULL,NULL,NULL,NULL,NULL,1.7734,1.7532,NULL,1.7748,1.7732,1.7871,NULL,1.7558,1.7576,1.7493),(168,'INFORMATION SYSTEMS','Sabaragamuwa University of Sri Lanka','Any','Any','Any',1.4087,1.3329,1.4583,1.368,1.2759,0.9223,1.5993,1.5133,1.3447,1.3395,1.0448,1.2542,0.9323,0.848,1.272,1.2644,1.2891,1.0575,1.3599,1.26,1.1775,1.3417,1.2506,1.3994,1.3837),(169,'SOFTWARE ENGINEERING','University of Sri Jayewardenepura','Combined Mathematics','Physics','Chemistry',1.5155,1.5143,1.5266,NULL,1.5188,NULL,1.518,1.5203,1.5198,1.518,NULL,NULL,NULL,NULL,NULL,NULL,1.6271,NULL,1.525,NULL,NULL,NULL,NULL,1.5206,1.5186),(170,'SOFTWARE ENGINEERING','University of Kelaniya','Combined Mathematics','Physics','Chemistry',1.5391,1.5402,1.5389,NULL,1.7117,NULL,1.553,1.5422,1.5396,1.5357,NULL,NULL,NULL,NULL,NULL,1.8835,NULL,NULL,1.54,NULL,NULL,NULL,NULL,1.5366,1.5639),(171,'SOFTWARE ENGINEERING','Sabaragamuwa University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.4183,1.3337,1.3903,1.1177,1.3914,0.9131,1.4645,NULL,NULL,1.4525,1.2968,0.8645,0.7034,0.9069,0.9977,1.2905,1.2821,1.0922,1.3537,1.2306,0.963,1.3523,1.1498,1.4223,1.4059),(172,'AYURVEDA MEDICINE & SURGERY','University of Colombo','Biology','Chemistry','Physics',1.2599,1.2698,1.2537,1.4962,1.2676,1.3473,1.2528,1.271,1.2585,1.3316,NULL,NULL,NULL,NULL,1.3017,1.2755,1.2508,1.2547,1.2632,1.2928,NULL,1.3033,1.2645,1.2623,1.2536),(173,'AYURVEDA MEDICINE & SURGERY','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Biology','Chemistry','Physics',1.1247,0.9585,1.1998,0.9652,1.0288,0.8614,1.2437,1.1537,1.1598,1.0034,1.097,1.0868,0.8618,1.1197,1.1215,1.0265,1.145,1.0297,1.1054,1.0715,0.8619,1.0745,1.1024,1.1298,1.1734),(174,'UNANI MEDICINE & SURGERY','University of Colombo','Biology','Chemistry','Physics',1.0928,0.8221,1.1018,1.0347,1.1027,0.8029,1.0765,0.9831,1.0733,1.0428,0.6221,1.1948,0.7712,1.1605,1.1548,1.21,1.2006,1.1361,1.0881,0.7915,0.7312,0.9089,1.0658,0.8395,1.0382),(175,'SIDDHA MEDICINE & SURGERY','University of Jaffna','Biology','Chemistry','Physics',0.5447,-0.0386,0.7884,NULL,0.8705,0.4723,NULL,NULL,NULL,0.7736,0.6993,0.5741,0.8175,0.9546,0.8644,0.7576,0.7845,0.5338,0.7416,0.6216,0.6182,0.6552,NULL,0.9822,0.7568),(176,'SIDDHA MEDICINE & SURGERY','Trincomalee Campus, Eastern University, Sri Lanka','Biology','Chemistry','Physics',0.6683,0.7541,0.779,0.7608,0.7223,0.7899,0.7633,0.7978,0.737,0.8474,0.9549,NULL,NULL,0.761,0.748,0.792,0.7546,NULL,0.7318,0.6725,0.7126,0.7002,0.6683,0.7223,0.7585),(177,'INDIGENOUS MEDICINAL RESOURCES','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',0.7139,0.7147,0.8376,0.7408,0.8539,0.6609,0.8289,0.8645,0.8545,0.7151,0.3054,0.8151,0.252,0.5145,0.7753,0.7772,0.7461,0.6182,0.7877,0.7036,0.8476,0.7288,0.8446,0.784,0.8147),(178,'HEALTH INFORMATION AND COMMUNICATION TECHNOLOGY','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',1.0215,1.0236,1.1129,1.1491,1.1356,0.9457,1.1581,1.1494,1.056,0.9579,0.9808,1.0313,0.029,0.3886,0.902,0.9958,0.9567,0.5011,1.1654,1.0948,0.8358,1.1321,0.9491,1.0995,1.1731),(179,'HEALTH TOURISM AND HOSPITALITY MANAGEMENT','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Accounting','Business Statistics','Economics',1.2336,1.2058,1.2299,1.2134,1.14,0.9839,1.2543,1.2507,1.1412,0.9436,0.8961,0.7275,0.6779,0.8814,1.0065,1.0064,0.9259,1.0313,1.1946,1.0837,1.172,1.1283,1.2529,1.195,1.2131),(180,'BIOMEDICAL TECHNOLOGY','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',1.07,1.0427,1.0926,1.1305,1.1436,0.9741,1.1475,1.181,1.0516,0.9955,0.8974,0.7262,0.3671,0.7914,1.2077,1.2079,1.0174,1.1208,1.1604,1.1071,1.0152,1.102,1.0396,1.0855,1.1823),(181,'INDIGENOUS PHARMACEUTICAL TECHNOLOGY','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',0.9828,0.9494,1.0898,1.1008,1.069,0.9636,1.0899,1.1079,1.0483,0.8739,0.6861,1.0794,0.251,0.7229,0.9898,1.023,0.9584,0.6671,1.0902,1.0414,1.019,1.0962,1.0071,1.0711,1.1035),(182,'YOGA AND PARAPSYCHOLOGY','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',1.2791,1.245,1.2757,1.2634,1.2697,1.2655,1.2872,1.2951,1.2886,1.2797,1.1256,1.0472,1.2288,1.2064,1.2397,1.276,1.2899,1.2619,1.2863,1.276,1.2777,1.3002,1.2908,1.2879,1.3046),(183,'SOCIAL STUDIES IN INDIGENOUS KNOWLEDGE','Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','Any','Any','Any',1.2964,1.2563,1.318,1.2851,1.2767,1.3031,1.303,1.3118,1.3137,1.1325,1.2716,1.231,1.1298,1.2616,1.2692,1.2422,1.3108,1.2726,1.2914,1.2694,1.2828,1.283,1.3253,1.286,1.3342),(184,'HEALTH PROMOTION','Rajarata University of Sri Lanka','Any','Any','Any',0.7395,0.7158,0.8623,0.8839,0.8806,0.7208,0.8572,0.8821,0.854,0.8401,0.9014,0.7696,0.5902,0.8915,0.9407,0.7876,0.9392,0.8131,0.9068,0.8464,0.7339,0.8394,0.9284,0.9014,0.8982),(185,'NURSING','University of Colombo','Any','Any','Any',1.3266,1.3313,1.3321,1.332,1.4256,NULL,1.3353,1.3346,1.3417,1.3535,NULL,1.3633,NULL,NULL,1.3372,1.3452,1.3273,1.3316,1.3393,1.3435,NULL,1.3687,1.35,1.3375,1.3731),(186,'NURSING','University of Peradeniya','Any','Any','Any',1.2937,1.2802,1.2746,1.293,1.2958,1.4127,1.285,1.2817,1.298,1.3058,1.318,NULL,1.4559,NULL,1.275,1.2819,1.2859,1.2773,NULL,1.2848,NULL,1.2917,1.3032,1.2792,1.2849),(187,'NURSING','University of Sri Jayewardenepura','Any','Any','Any',1.2517,1.2666,1.25,NULL,1.2587,1.249,1.2511,1.2695,1.2523,1.2625,NULL,NULL,1.2493,1.2604,1.2536,1.3248,1.2589,1.2657,1.2483,1.2577,1.2565,1.2569,1.279,1.2532,1.254),(188,'NURSING','University of Jaffna','Any','Any','Any',0.9795,0.9844,1.1731,1.0753,1.003,0.977,NULL,NULL,NULL,1.1082,1.2149,1.129,NULL,1.0213,1.2121,1.14,1.2027,0.9952,1.0457,0.9872,0.9817,0.9868,1.276,1.0611,1.1443),(189,'NURSING','University of Ruhuna','Any','Any','Any',1.0351,1.0385,1.1415,1.1037,1.0398,1.09,1.1519,1.1111,1.1486,NULL,1.1044,1.1607,1.2075,NULL,1.1519,1.1838,1.1173,1.1038,1.0494,1.035,1.1309,1.0382,1.0802,1.0576,1.0697),(190,'NURSING','Eastern University','Any','Any','Any',0.9135,0.7793,NULL,0.9377,1.0288,0.8176,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.9276,1.1689,1.1274,1.1333,0.8405,NULL,NULL,0.8964,NULL,1.1926,NULL,NULL),(191,'PHARMACY','University of Peradeniya','Any','Any','Any',1.6132,1.6367,1.6024,1.6051,1.648,NULL,NULL,1.6114,1.6231,1.6235,NULL,NULL,NULL,NULL,NULL,1.6296,1.6049,NULL,1.6228,1.6103,NULL,1.6342,NULL,1.6302,NULL),(192,'PHARMACY','University of Sri Jayewardenepura','Any','Any','Any',1.5832,1.6159,1.6287,NULL,NULL,NULL,1.5939,1.5859,1.5936,1.5832,NULL,NULL,NULL,NULL,NULL,1.5903,1.5895,1.6319,1.5936,NULL,NULL,1.5932,NULL,1.5843,1.5941),(193,'PHARMACY','University of Jaffna','Any','Any','Any',1.2179,1.1654,1.4814,1.4527,1.3706,1.0619,NULL,NULL,NULL,1.5677,1.4619,1.4508,1.3083,1.3145,1.5061,1.5429,1.5889,1.4031,1.4712,1.3682,1.2869,1.4454,1.3328,1.5307,1.4392),(194,'PHARMACY','University of Ruhuna','Any','Any','Any',1.514,1.5077,1.5105,1.5392,1.5407,NULL,1.5031,1.5331,1.5494,NULL,NULL,NULL,NULL,NULL,1.5591,1.5352,1.5711,1.5491,1.5203,1.5807,NULL,1.5027,1.5108,1.5123,1.5109),(195,'MEDICAL LABORATORY SCIENCES','University of Peradeniya','Any','Any','Any',1.7384,NULL,1.7454,NULL,1.7272,NULL,1.7456,1.7208,1.7265,1.7491,NULL,NULL,NULL,NULL,NULL,1.7192,1.7264,NULL,1.7195,NULL,NULL,NULL,NULL,NULL,1.7512),(196,'MEDICAL LABORATORY SCIENCES','University of Sri Jayewardenepura','Any','Any','Any',1.6896,NULL,1.69,NULL,1.6928,NULL,1.6935,1.695,1.7155,1.7031,NULL,NULL,NULL,NULL,NULL,1.6967,1.6993,NULL,1.6946,NULL,NULL,1.7064,NULL,1.6913,1.6974),(197,'MEDICAL LABORATORY SCIENCES','University of Jaffna','Any','Any','Any',1.4388,1.3287,NULL,1.5788,1.5143,1.2582,NULL,NULL,NULL,1.6488,1.6448,1.4631,1.4696,1.3808,1.5169,NULL,1.6713,1.4963,1.608,1.4527,1.3785,1.4661,1.4893,NULL,1.6278),(198,'MEDICAL LABORATORY SCIENCES','University of Ruhuna','Any','Any','Any',1.6021,1.6302,1.6416,NULL,1.6196,NULL,1.6003,1.6664,1.6352,1.689,NULL,NULL,NULL,NULL,NULL,1.6446,1.6631,NULL,1.6077,NULL,NULL,1.6196,NULL,1.635,1.6053),(199,'RADIOGRAPHY','University of Peradeniya','Any','Any','Any',1.447,1.4774,1.5364,1.5392,1.5319,1.483,1.5032,1.6003,1.5743,1.6332,1.4354,1.4413,1.5469,1.3469,1.6349,1.6191,1.6278,1.459,1.6038,1.5696,1.4065,1.5526,1.4564,1.5669,1.6324),(200,'MEDICAL IMAGING TECHNOLOGY','University of Colombo','Any','Any','Any',1.5903,1.5088,1.579,1.4396,1.4713,1.4545,1.5699,1.5073,1.6186,1.5873,1.4854,1.4038,1.4903,1.4791,1.535,1.5842,1.6142,1.492,1.585,1.583,1.3744,1.586,1.5024,1.6176,1.5922),(201,'PHYSIOTHERAPY','University of Colombo','Any','Any','Any',1.669,1.6674,1.7026,1.667,1.6671,NULL,1.6999,1.7194,1.6938,1.6664,NULL,NULL,NULL,NULL,NULL,1.6715,1.7001,NULL,1.6797,NULL,NULL,1.6824,NULL,1.6943,1.7387),(202,'PHYSIOTHERAPY','University of Peradeniya','Any','Any','Any',1.6606,1.6075,1.7134,NULL,1.6553,1.4233,NULL,1.7187,1.7558,1.6658,1.6376,1.5116,1.6146,1.4806,1.6021,NULL,1.736,1.6132,1.66,1.6166,1.4468,1.6527,1.4632,1.6538,1.6881),(203,'OCCUPATIONAL THERAPY','University of Kelaniya','Any','Any','Any',1.3944,1.3145,1.4456,1.3797,1.3818,1.2552,1.4577,1.4129,1.4285,1.4795,1.3427,1.4067,1.2816,1.4339,1.4502,1.4943,1.4848,1.4769,1.4668,1.3258,1.3563,1.4132,1.2791,1.4445,1.4977),(204,'OPTOMETRY','University of Sri Jayewardenepura','Any','Any','Any',1.4666,1.4645,1.4468,1.4895,1.4647,1.4475,1.4708,1.4549,1.5537,1.5425,1.4117,1.4331,1.4905,1.4687,1.5098,1.5307,1.5469,1.4987,1.5011,1.3664,1.2836,1.4453,1.5313,1.5015,1.5439),(205,'ENVIRONMENTAL CONSERVATION & MANAGEMENT','University of Kelaniya','Accounting','Business Statistics','Economics',1.1106,1.1026,1.0805,1.0292,1.0616,0.8314,1.1504,1.1435,1.1347,0.867,0.5521,0.5385,0.8814,0.9434,1.1331,1.0115,1.0226,0.9798,1.0458,1.0202,1.0902,1.0534,1.1207,1.1434,1.1518),(206,'APPLIED CHEMISTRY','University of Kelaniya','Any','Any','Any',1.5659,1.5667,1.5538,1.4972,1.5882,1.3647,1.5376,1.4829,1.5634,1.4963,1.0891,1.1535,1.0912,1.2666,1.32,1.5076,1.5635,1.4688,1.5618,1.5328,1.4369,1.5388,1.5006,1.5494,1.5317),(207,'ELECTRONICS AND COMPUTER SCIENCE','University of Kelaniya','Combined Mathematics','Physics','ICT',1.5081,1.4938,1.5367,1.3092,1.5116,1.1424,1.5092,1.5434,1.5009,1.4371,1.2903,0.9348,0.6216,1.018,1.0824,1.2892,1.2629,1.2436,1.5001,1.3398,0.9694,1.4192,1.3398,1.525,1.4711),(208,'ACCOUNTING INFORMATION SYSTEMS','University of Kelaniya','Accounting','Business Statistics','Economics',1.6391,1.6468,1.6579,1.4151,1.5794,1.3003,1.6369,1.6695,1.5501,1.4681,0.7479,0.6244,0.5527,0.678,1.5713,1.6048,1.5308,1.6553,1.5581,1.5492,1.3761,1.5734,1.5653,1.63,1.6427),(209,'FISHERIES & MARINE SCIENCES','University of Ruhuna','Any','Any','Any',0.8913,0.8411,0.922,0.9128,0.8721,0.8127,0.8972,0.9336,0.9328,0.7046,0.3617,0.4609,0.5134,0.9313,0.7641,0.7533,0.8616,0.8125,0.8814,0.7447,0.674,0.874,0.8727,0.9185,0.8444),(210,'MARINE AND FRESHWATER SCIENCES','University of Ruhuna','Any','Any','Any',1.0396,1.0016,1.0272,0.7995,0.9922,1.0248,1.0586,1.0483,1.0513,0.8839,0.8032,0.9279,0.3215,0.6186,0.9457,1.0259,0.9701,0.9809,1.0537,0.9417,0.8567,1.0211,1.0634,1.0331,0.9994),(211,'ANIMAL SCIENCE & FISHERIES','University of Peradeniya','Any','Any','Any',1.1032,1.1331,1.1886,1.143,1.1463,1.0597,1.1403,1.1604,1.1935,1.1748,0.9491,0.5901,0.4596,0.6329,1.1193,1.0772,1.0441,1.0743,1.1049,1.0446,0.9891,1.1167,1.1172,1.1501,1.1558),(212,'FOOD  PRODUCTION','Unknown University','Any','Any','Any',0.9373,0.9869,1.022,0.9994,1.0095,1.0268,1.0448,0.9769,1.0085,0.8984,0.6882,0.7177,0.5314,0.9459,1.0021,0.846,0.9011,0.9771,1.0229,0.9546,0.7676,0.9534,1.0085,0.9943,1.027),(213,'FOOD BUSINESS MANAGEMENT','Sabaragamuwa University of Sri Lanka','Accounting','Business Statistics','Economics',0.9259,0.9554,0.9223,0.9517,0.9628,0.7714,0.9674,0.9897,0.9851,0.8587,0.5153,0.2956,0.6229,0.4658,0.9878,0.9578,0.9619,0.7392,0.9545,0.8184,0.8983,0.9593,0.9052,0.9264,0.9846),(214,'FOOD BUSINESS MANAGEMENT','Unknown University','Accounting','Business Statistics','Economics',1.2435,1.2364,1.2334,1.1585,1.203,0.9775,1.229,1.2477,1.1206,0.8849,0.8796,0.7517,0.8604,0.912,0.9926,0.9482,0.9233,1.0083,1.1925,1.0401,1.1574,1.1278,1.2105,1.1867,1.2305),(215,'MANAGEMENT AND INFORMATION TECHNOLOGY (SEUSL)','South Eastern University of Sri Lanka','Accounting','Business Statistics','Economics',1.2856,1.2937,1.3497,1.4746,1.443,1.3376,1.3558,1.4357,1.3867,1.3433,1.538,1.5052,1.4435,1.4977,1.5241,1.5065,1.5206,1.5042,1.3647,1.4636,1.3628,1.4252,1.4069,1.3079,1.4113),(216,'DATA SCIENCE','Sabaragamuwa University of Sri Lanka','Any','Any','Any',1.3814,1.387,1.3872,1.236,1.3762,1.2257,1.4089,1.4076,1.4224,1.4259,1.2348,0.7682,0.6054,0.6229,1.05,1.2626,1.3289,1.1417,1.3534,1.2259,1.1758,1.3483,1.2611,1.4049,1.3974),(217,'PHYSICAL EDUCATION','University of Jaffna','Combined Mathematics','Physics','Chemistry',0.1365,0.5475,NULL,0.6124,NULL,-0.0792,NULL,0.1001,NULL,0.2944,NULL,NULL,0.7574,NULL,-0.2306,0.1024,0.6801,-0.2278,0.4272,0.3524,NULL,0.2289,NULL,0.7803,0.2629),(218,'PHYSICAL EDUCATION','Sabaragamuwa University of Sri Lanka','Combined Mathematics','Physics','Chemistry',-0.1095,-0.4784,NULL,-0.1515,0.1351,-0.3123,0.1039,-0.5668,-0.0938,0.3528,0.1664,0.1743,0.2719,0.3663,NULL,0.4504,0.2004,-0.168,-0.3987,0.1824,-0.0408,0.2578,0.2703,-0.7545,0.1676),(219,'SPORTS SCIENCE & MANAGEMENT','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',0.8289,0.9155,0.8426,0.8636,0.8748,0.847,0.8984,0.9124,NULL,0.8721,NULL,NULL,NULL,1.0588,0.9759,NULL,1.0333,0.9466,0.8665,0.85,0.9775,0.833,NULL,0.93,0.8966),(220,'SPORTS SCIENCE & MANAGEMENT','University of Kelaniya','Accounting','Business Statistics','Economics',0.5798,0.7582,0.7035,0.6097,0.744,NULL,0.6909,0.7731,0.5628,NULL,NULL,NULL,NULL,0.5719,NULL,0.6054,NULL,NULL,0.5562,0.7678,0.7367,0.5935,0.5801,NULL,0.5732),(221,'SPORTS SCIENCE & MANAGEMENT','Sabaragamuwa University of Sri Lanka','Accounting','Business Statistics','Economics',0.4888,-0.1626,-0.2065,0.8853,0.4116,0.1834,0.3927,0.2599,0.49,0.6115,0.0956,NULL,0.3803,NULL,0.0235,0.4821,0.4801,0.1603,0.3657,0.4967,0.0804,0.6339,0.4768,-0.0956,NULL),(222,'SPEECH AND HEARING SCIENCES','University of Kelaniya','Any','Any','Any',1.3877,1.3424,1.2478,1.3028,1.3671,0.9172,1.3765,1.3449,1.3397,1.4003,1.3422,1.2648,1.182,1.272,1.4007,1.3971,1.4065,1.275,1.3459,1.3136,0.9842,1.344,1.2289,1.226,1.3731),(223,'TOURISM & HOSPITALITY MANAGEMENT','Rajarata University of Sri Lanka','Accounting','Business Statistics','Economics',1.4945,1.4048,1.4651,1.4397,1.4091,1.4293,1.4182,1.4715,NULL,1.51,1.5857,NULL,1.5029,NULL,NULL,1.6006,1.4471,1.5244,1.4041,1.427,1.399,1.4292,1.4333,1.4634,1.4464),(224,'TOURISM & HOSPITALITY MANAGEMENT','Sabaragamuwa University of Sri Lanka','Accounting','Business Statistics','Economics',1.303,1.3428,1.3724,1.3754,1.3661,1.4407,1.4107,1.4063,1.3666,1.221,1.4654,1.4064,1.4767,1.2185,1.3933,1.3114,1.3455,1.2758,1.4046,1.3462,1.3089,1.4573,1.4607,1.2946,1.4694),(225,'AGRICULTURAL RESOURCE MANAGEMENT AND TECHNOLOGY','University of Ruhuna','Accounting','Business Statistics','Economics',0.9192,0.8307,0.984,0.9598,0.9401,0.8125,1.0039,0.9462,0.9682,0.7469,0.8117,0.3741,0.5291,0.8493,0.7554,0.7932,0.9588,0.7669,0.9194,0.924,0.7918,0.9093,0.8995,0.9602,0.9897),(226,'AGRI BUSINESS MANAGEMENT','University of Ruhuna','Accounting','Business Statistics','Economics',0.9828,0.9284,1.007,0.9431,0.9285,0.7754,0.9754,0.9771,0.9522,0.7743,0.4048,0.2779,0.3823,0.9417,0.7907,0.8239,0.9204,0.7944,0.9162,0.9381,0.8093,0.9273,0.9776,0.9356,0.9588),(227,'GREEN TECHNOLOGY','University of Ruhuna','Any','Any','Any',1.0443,0.9351,1.0786,0.9615,1.0101,0.852,1.0811,1.0918,1.0572,1.0694,0.6273,1.0505,0.3647,0.7026,0.9192,1.0191,0.8646,0.9535,0.9803,0.9849,0.9525,0.9457,1.0574,1.0127,1.0112),(228,'SCIENCE AND TECHNOLOGY','Uva Wellassa University','Any','Any','Any',1.0236,0.9976,1.0601,0.9654,1.0082,0.912,1.0519,1.0943,1.1019,1.094,0.7951,0.9383,0.6794,0.9635,1.0759,1.0323,1.031,0.9185,1.0651,1.0273,0.828,1.0537,0.9669,0.9753,1.0956),(229,'COMPUTER SCIENCE & TECHNOLOGY','Uva Wellassa University','Combined Mathematics','Physics','ICT',1.2941,1.1699,1.2849,1.1732,1.2216,1.0673,1.2587,1.3235,1.3187,1.3485,1.1275,1.0824,1.2219,1.0841,1.2697,1.232,1.2735,1.0592,1.2842,1.2085,1.0282,1.2242,1.0116,1.2796,1.3226),(230,'ENTREPRENEURSHIP AND MANAGEMENT','Uva Wellassa University','Accounting','Business Statistics','Economics',1.2822,1.2757,1.2602,1.2355,1.2254,1.0932,1.284,1.2796,1.2316,1.1131,0.9802,0.8596,0.8159,1.0541,1.1173,1.11,0.9931,1.0675,1.2547,1.1571,1.2253,1.194,1.2334,1.2446,1.2821),(231,'ANIMAL PRODUCTION AND FOOD TECHNOLOGY','Uva Wellassa University','Any','Any','Any',0.7701,0.7661,0.8871,0.8824,0.8498,0.7058,0.8733,0.9076,0.8643,0.7256,0.6678,0.5581,0.3239,0.7464,0.8851,0.744,0.9,0.6585,0.8277,0.7634,0.6766,0.8034,0.7763,0.8061,0.8617),(232,'EXPORT AGRICULTURE','Uva Wellassa University','Biology','Chemistry','Physics',0.8401,0.7879,0.8714,0.9044,0.8382,0.7145,0.8908,0.8841,0.8653,0.7371,0.4377,0.3927,0.429,0.5637,0.8534,0.7244,0.8389,0.7222,0.8445,0.8054,0.7855,0.8441,0.7865,0.8296,0.8681),(233,'INDUSTRIAL INFORMATION TECHNOLOGY','Uva Wellassa University','Any','Any','Any',1.3669,1.3118,1.3509,1.4109,1.3043,1.0824,1.3679,1.3536,1.2944,1.3144,1.0354,1.347,0.8604,0.9705,1.3928,1.4115,1.3319,1.0876,1.3507,1.2057,1.3667,1.334,1.3072,1.372,1.3403),(234,'MINERAL RESOURCES AND TECHNOLOGY','Uva Wellassa University','Any','Any','Any',0.9133,0.9126,0.9933,0.9444,0.9906,0.8311,0.9747,0.9867,0.9696,0.9174,0.8466,0.5109,0.4277,0.831,0.9784,0.9758,0.9726,0.7891,0.9761,0.9382,0.7359,0.9857,0.9656,0.9253,0.9551),(235,'AQUATIC RESOURCES TECHNOLOGY','Uva Wellassa University','Any','Any','Any',0.744,0.728,0.8257,0.7759,0.8074,0.6851,0.8402,0.8374,0.8286,0.7051,0.4743,0.5031,0.334,0.6033,0.7472,0.7269,0.7465,0.6344,0.8049,0.7017,0.7677,0.7462,0.7358,0.802,0.8368),(236,'HOSPITALITY, TOURISM AND EVENTS MANAGEMENT','Uva Wellassa University','Accounting','Business Statistics','Economics',1.2658,1.262,1.2496,1.2207,1.2033,1.1611,1.2738,1.2795,1.2182,0.9549,0.8835,0.7582,0.7112,0.8753,1.0606,0.9441,0.9773,1.1076,1.2356,1.1644,1.1477,1.168,1.1976,1.2336,1.2753),(237,'ENGLISH LANGUAGE & APPLIED LINGUISTICS','Uva Wellassa University','Any','Any','Any',1.2801,1.3352,1.4323,1.3983,1.3841,1.3705,1.4035,1.3884,1.5055,1.4538,1.5039,1.5272,1.4179,1.4097,1.3831,1.5067,1.5146,1.4601,1.3843,1.3815,1.2791,1.5201,1.3977,1.3212,1.4185),(238,'PLANTATION MANAGEMENT AND TECHNOLOGY','Uva Wellassa University','Accounting','Business Statistics','Economics',0.773,0.7692,0.8464,0.7569,0.8156,0.6344,0.85,0.8357,0.8414,0.7834,0.4875,0.2434,0.4287,0.447,0.6021,0.6983,0.6983,0.6082,0.8467,0.78,0.7226,0.8105,0.7252,0.8128,0.8401),(239,'POLYMER SCIENCE AND INDUSTRIAL MANAGEMENT','University of Sri Jayewardenepura','Accounting','Business Statistics','Economics',1.4979,1.466,1.5229,1.4826,1.4984,1.4796,1.5164,1.4392,1.4688,1.4761,0.9408,1.0718,0.943,1.1247,1.1796,1.4006,1.4644,1.4604,1.4136,1.4316,1.3042,1.5299,1.3482,1.5335,1.5363),(240,'ENGINEERING TECHNOLOGY (ET)','University of Colombo','Combined Mathematics','Physics','Chemistry',1.9193,1.9486,1.9463,2.2593,1.9398,1.9463,1.9123,1.9226,1.97,NULL,NULL,NULL,NULL,NULL,2.0771,1.9901,1.9678,1.9375,1.913,1.9713,NULL,1.9157,NULL,1.9242,1.9446),(241,'ENGINEERING TECHNOLOGY (ET)','University of Sri Jayewardenepura','Combined Mathematics','Physics','Chemistry',2.1286,2.1105,2.1195,2.1418,2.1408,2.1308,2.1197,2.1226,2.4779,2.2461,NULL,NULL,NULL,2.1168,NULL,2.2022,2.3402,2.1403,2.1127,2.1616,2.2471,2.2117,2.616,2.1193,2.1115),(242,'ENGINEERING TECHNOLOGY (ET)','University of Kelaniya','Combined Mathematics','Physics','Chemistry',1.7753,1.7754,1.7707,1.8603,1.8001,1.7776,1.7738,1.7748,1.8455,1.8114,1.8159,NULL,NULL,1.9699,NULL,1.8268,1.7932,1.8405,1.7794,1.7783,2.0054,1.823,NULL,1.7703,1.8233),(243,'ENGINEERING TECHNOLOGY (ET)','University of Jaffna','Combined Mathematics','Physics','Chemistry',1.2135,1.3176,1.4008,NULL,NULL,0.9145,1.2817,1.3735,1.1605,0.7875,0.1107,0.3371,0.0441,0.0551,0.833,0.9517,0.9865,0.6585,1.3228,1.2442,1.0065,1.3101,1.0418,1.2786,1.3052),(244,'ENGINEERING TECHNOLOGY (ET)','University of Ruhuna','Combined Mathematics','Physics','Chemistry',1.5195,1.554,1.5259,1.5362,1.516,1.5924,1.5255,1.519,1.5256,NULL,NULL,NULL,NULL,NULL,1.5571,NULL,NULL,1.6494,1.5285,1.5582,1.5898,1.5399,1.6063,1.5147,1.5249),(245,'ENGINEERING TECHNOLOGY (ET)','Rajarata University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.1999,1.2613,1.3521,1.3716,1.207,1.1706,1.3036,1.3545,1.1581,1.3237,NULL,NULL,NULL,NULL,1.1522,1.1606,1.1526,1.2363,1.3038,1.2423,1.1587,1.2474,1.1687,1.2825,1.338),(246,'ENGINEERING TECHNOLOGY (ET)','Sabaragamuwa University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.2214,1.2605,1.3126,NULL,1.2266,1.3102,1.2869,1.369,1.2247,NULL,NULL,NULL,NULL,NULL,1.3142,NULL,1.2841,1.2864,1.3041,1.3181,1.2776,1.261,1.5043,1.2614,NULL),(247,'ENGINEERING TECHNOLOGY (ET)','Wayamba University of Sri Lanka','Combined Mathematics','Physics','Chemistry',1.3456,1.3412,1.3524,1.3816,1.3418,1.4422,1.3995,1.3646,1.4154,1.6314,NULL,NULL,NULL,NULL,1.7237,1.3711,1.4733,1.4574,1.3518,1.3678,1.3579,1.3401,1.3555,1.3525,1.3576),(248,'ENGINEERING TECHNOLOGY (ET)','Uva Wellassa University','Combined Mathematics','Physics','Chemistry',1.2079,1.2563,1.4004,NULL,1.2168,1.0981,1.2779,1.3487,1.1577,1.2019,NULL,NULL,NULL,NULL,1.1414,1.1054,1.0867,1.0916,1.3027,1.2246,1.0856,1.2869,1.0773,1.2602,1.3045),(249,'BIOSYSTEMS TECHNOLOGY (BST)','University of Colombo','Any','Any','Any',1.6656,1.6312,1.6336,1.6352,1.6453,1.8665,1.6469,1.6541,1.6545,NULL,NULL,1.6402,NULL,1.8337,1.6575,1.6401,1.6556,1.8753,1.6246,1.6597,1.7713,1.6305,1.7346,1.67,1.6595),(250,'BIOSYSTEMS TECHNOLOGY (BST)','University of Sri Jayewardenepura','Any','Any','Any',1.9411,1.9012,1.8918,2.0913,1.8918,1.9161,1.9939,1.9717,1.9367,NULL,NULL,NULL,NULL,2.0014,2.1108,1.9325,1.894,1.9165,1.8953,1.9357,1.9739,1.8941,2.0424,1.8972,1.8954),(251,'BIOSYSTEMS TECHNOLOGY (BST)','University of Kelaniya','Any','Any','Any',1.5012,1.5356,1.527,1.5466,1.5387,NULL,1.52,1.5216,1.5196,NULL,NULL,NULL,1.617,1.5282,1.6189,1.5561,NULL,1.5134,1.5167,1.5423,NULL,1.5401,1.5319,1.5042,1.5194),(252,'BIOSYSTEMS TECHNOLOGY (BST)','University of Jaffna','Any','Any','Any',0.8167,0.8032,0.8584,NULL,1.08,0.9895,0.8231,1.0421,1.0681,0.8588,0.8878,0.8637,NULL,0.9093,0.8207,0.7988,0.8502,0.8039,0.994,1.0572,0.9488,1.0376,0.951,0.9849,1.1536),(253,'BIOSYSTEMS TECHNOLOGY (BST)','University of Ruhuna','Any','Any','Any',1.4048,1.3972,1.4438,1.4859,1.4681,1.4668,1.41,1.4214,1.3974,NULL,NULL,NULL,NULL,NULL,1.4208,1.5058,1.405,1.4014,1.4574,1.4843,NULL,1.4066,1.3983,1.3986,1.4087),(254,'BIOSYSTEMS TECHNOLOGY (BST)','Eastern University','Any','Any','Any',0.4446,0.6227,0.8894,NULL,1.0825,0.9919,0.7854,1.0736,0.9949,0.5714,0.0654,0.6354,0.0957,0.4532,0.5524,0.7152,0.7681,0.2876,1.0303,1.066,0.7287,1.0529,NULL,0.9973,NULL),(255,'BIOSYSTEMS TECHNOLOGY (BST)','South Eastern University of Sri Lanka','Any','Any','Any',0.445,0.6565,0.8724,NULL,1.0702,1.0304,0.7731,1.0396,0.9944,0.6156,0.4601,0.6559,0.0455,0.515,0.5828,0.7139,0.7372,0.2653,0.994,NULL,0.6995,NULL,0.9584,1.0239,NULL),(256,'BIOSYSTEMS TECHNOLOGY (BST)','Rajarata University of Sri Lanka','Any','Any','Any',1.1511,1.1139,1.1332,1.1318,1.171,1.1708,1.3873,1.156,1.2072,1.1571,NULL,NULL,NULL,NULL,NULL,1.4755,1.1286,1.117,1.159,1.124,NULL,1.1296,1.227,1.1224,1.1719),(257,'BIOSYSTEMS TECHNOLOGY (BST)','Sabaragamuwa University of Sri Lanka','Any','Any','Any',1.1164,1.1014,1.1353,NULL,1.096,1.0967,1.1204,1.0964,1.1457,1.1899,NULL,NULL,NULL,1.1063,1.1078,1.1112,1.1374,1.1535,1.0997,1.1082,1.3952,1.1205,1.0967,1.0971,1.1643),(258,'BIOSYSTEMS TECHNOLOGY (BST)','Wayamba University of Sri Lanka','Any','Any','Any',1.2398,1.2561,1.3671,1.2497,1.2631,1.2406,1.24,1.275,1.3117,1.2428,NULL,NULL,NULL,NULL,1.3284,NULL,1.4875,1.2424,1.2655,1.2449,1.2855,1.27,1.2519,1.2384,1.2523),(259,'BIOSYSTEMS TECHNOLOGY (BST)','Uva Wellassa University','Any','Any','Any',1.1736,1.1369,1.1366,1.1413,1.1711,1.1332,1.1388,1.1437,1.1326,1.1328,NULL,1.4024,NULL,1.322,1.1502,1.1299,1.1407,1.1441,1.1272,1.1489,1.1741,1.1882,1.2191,1.135,1.1721),(260,'INFORMATION COMMUNICATION TECHNOLOGY','University of Colombo','Any','Any','Any',1.886,1.919,NULL,NULL,1.8891,1.9756,1.9217,1.9084,2.0416,NULL,NULL,2.2304,NULL,NULL,NULL,1.8992,1.957,1.9772,1.9019,1.923,2.0409,1.9087,NULL,1.9068,1.9097),(261,'INFORMATION COMMUNICATION TECHNOLOGY','University of Sri Jayewardenepura','Any','Any','Any',2.0626,2.0708,2.0798,2.1236,2.0561,2.4326,2.3834,2.0464,2.0765,2.1084,NULL,NULL,NULL,NULL,2.0553,2.0553,2.1102,2.4885,2.0958,2.0673,NULL,2.0883,2.0761,2.0827,2.0478),(262,'INFORMATION COMMUNICATION TECHNOLOGY','University of Kelaniya','Any','Any','Any',1.7683,1.8013,1.8305,1.8357,1.7892,1.8818,1.8059,1.7767,1.8209,1.7676,NULL,NULL,NULL,1.7729,NULL,1.831,1.7707,1.9934,1.7828,1.7664,NULL,1.8044,1.8152,1.7701,1.7705),(263,'INFORMATION COMMUNICATION TECHNOLOGY','University of Ruhuna','Any','Any','Any',1.5883,1.6052,1.6903,1.6561,1.594,NULL,1.5999,1.5893,1.5898,1.6281,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.6447,1.5869,1.7115,NULL,1.5959,1.6005,1.6291,1.5961),(264,'INFORMATION COMMUNICATION TECHNOLOGY','Eastern University','Any','Any','Any',0.9987,1.0592,1.197,NULL,1.0534,0.7402,1.1809,NULL,1.197,NULL,NULL,1.0676,-0.0701,0.5467,0.8795,1.0809,0.9998,0.6048,1.2297,1.1131,0.7009,1.2014,0.9926,1.1137,1.1976),(265,'INFORMATION COMMUNICATION TECHNOLOGY','South Eastern University of Sri Lanka','Any','Any','Any',1.107,1.0944,1.1482,1.3559,1.1341,NULL,1.1733,1.3959,1.1067,1.0939,NULL,NULL,NULL,NULL,1.0945,1.6575,1.1245,NULL,1.2266,1.1569,1.1079,1.1573,1.1042,1.1332,1.2107);
/*!40000 ALTER TABLE `flat_zscores` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subjects`
--

DROP TABLE IF EXISTS `subjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `degree_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `degree_id` (`degree_id`),
  CONSTRAINT `subjects_ibfk_1` FOREIGN KEY (`degree_id`) REFERENCES `degrees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subjects`
--

LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `universities`
--

DROP TABLE IF EXISTS `universities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `universities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `universities`
--

LOCK TABLES `universities` WRITE;
/*!40000 ALTER TABLE `universities` DISABLE KEYS */;
INSERT INTO `universities` VALUES (1,'University of Colombo','Colombo','Leading university in Sri Lanka','images/colombo.jpg'),(2,'University of Peradeniya','Peradeniya','Beautiful campus with diverse faculties','images/university of peradeniya.jfif'),(5,'University of Sri Jayewardenepura','Sri Lanka','A premier Sri Lankan university.','images/University-of-Sri-Jayewardenepura.jpg'),(6,'University of Kelaniya','Sri Lanka','A premier Sri Lankan university.','images/university of Kelaniya.webp'),(7,'University of Moratuwa','Sri Lanka','A premier Sri Lankan university.','images/university of moratuwa.jpg'),(8,'University of Jaffna','Sri Lanka','A premier Sri Lankan university.','images/university of jaffna.JPG'),(9,'Eastern University','Sri Lanka','A premier Sri Lankan university.','images/eastern university of moratuwa.jpg'),(10,'South Eastern University of Sri Lanka','Sri Lanka','A premier Sri Lankan university.','images/seusl.jpg'),(11,'Rajarata University of Sri Lanka','Sri Lanka','A premier Sri Lankan university.','images/rajarata university.jpg'),(12,'Wayamba University of Sri Lanka','Sri Lanka','A premier Sri Lankan university.','images/wayamba.jpg'),(13,'Sabaragamuwa University of Sri Lanka','Sri Lanka','A premier Sri Lankan university.','images/sabaragamuwa.jpg'),(14,'Uva Wellassa University','Sri Lanka','A premier Sri Lankan university.','images/uwa wellassa.jpg'),(15,'University of Ruhuna','Sri Lanka','A premier Sri Lankan university.','images/university of ruhuna.jpg'),(19,'University of Vavuniya, Sri Lanka',NULL,NULL,NULL),(20,'Unknown University',NULL,NULL,NULL),(21,'Swami Vipulananda Institute of Aesthetic Studies',NULL,NULL,NULL),(22,'University of Trincomalee',NULL,NULL,NULL),(23,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka',NULL,NULL,NULL);
/*!40000 ALTER TABLE `universities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `university_degrees`
--

DROP TABLE IF EXISTS `university_degrees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `university_degrees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university` varchar(255) DEFAULT NULL,
  `degree` varchar(255) DEFAULT NULL,
  `stream` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `university_degrees`
--

LOCK TABLES `university_degrees` WRITE;
/*!40000 ALTER TABLE `university_degrees` DISABLE KEYS */;
INSERT INTO `university_degrees` VALUES (1,'University of Colombo','MEDICINE','Bio'),(2,'University of Peradeniya','MEDICINE','Bio'),(3,'University of Sri Jayewardenepura','MEDICINE','Bio'),(4,'University of Kelaniya','MEDICINE','Bio'),(5,'University of Jaffna','MEDICINE','Bio'),(6,'University of Ruhuna','MEDICINE','Bio'),(7,'University of Moratuwa','MEDICINE','Bio'),(8,'Eastern University','MEDICINE','Bio'),(9,'Rajarata University of Sri Lanka','MEDICINE','Bio'),(10,'Sabaragamuwa University of Sri Lanka','MEDICINE','Bio'),(11,'Wayamba University of Sri Lanka','MEDICINE','Bio'),(12,'Uva Wellassa University','MEDICINE','Bio'),(13,'University of Peradeniya','DENTAL SURGERY','Bio'),(14,'University of Sri Jayewardenepura','DENTAL SURGERY','Bio'),(15,'University of Peradeniya','VETERINARY SCIENCE','Bio'),(16,'University of Colombo','BIOCHEMISTRY & MOLECULAR BIOLOGY','Bio'),(17,'University of Peradeniya','AGRICULTURAL TECHNOLOGY & MANAGEMENT','Commerce'),(18,'University of Jaffna','AGRICULTURE','Bio'),(19,'Eastern University','AGRICULTURE','Bio'),(20,'Rajarata University of Sri Lanka','AGRICULTURE','Bio'),(21,'Sabaragamuwa University of Sri Lanka','AGRICULTURE','Bio'),(22,'Wayamba University of Sri Lanka','AGRICULTURE','Bio'),(23,'Wayamba University of Sri Lanka','FOOD SCIENCE & NUTRITION','Bio'),(24,'University of Peradeniya','FOOD SCIENCE & TECHNOLOGY','Bio'),(25,'University of Sri Jayewardenepura','FOOD SCIENCE & TECHNOLOGY','Bio'),(26,'Sabaragamuwa University of Sri Lanka','FOOD SCIENCE & TECHNOLOGY','Bio'),(27,'University of Colombo','BIOLOGICAL SCIENCE','Bio'),(28,'Rajarata University of Sri Lanka','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(29,'University of Vavuniya, Sri Lanka','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(30,'Uva Wellassa University','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(31,'University of Sri Jayewardenepura','PHYSICAL SCIENCE -ICT','Maths'),(32,'University of Kelaniya','PHYSICAL SCIENCE -ICT','Maths'),(33,'University of Kelaniya','TRANSLATION STUDIES','Arts'),(34,'University of Jaffna','TRANSLATION STUDIES','Arts'),(35,'Eastern University','TRANSLATION STUDIES','Arts'),(36,'Sabaragamuwa University of Sri Lanka','TRANSLATION STUDIES','Arts'),(37,'University of Kelaniya','FILM & TELEVISION STUDIES','Arts'),(38,'University of Vavuniya, Sri Lanka','PROJECT MANAGEMENT','Commerce'),(39,'University of Sri Jayewardenepura','TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','Arts'),(40,'University of Kelaniya','TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','Arts'),(41,'Sabaragamuwa University of Sri Lanka','TEACHING ENGLISH AS A SECOND LANGUAGE (TESL)','Arts'),(42,'Unknown University','VISUAL ARTS','Arts'),(43,'University of Sri Jayewardenepura','MUSIC','Arts'),(44,'Unknown University','MUSIC','Arts'),(45,'Unknown University','DANCE','Arts'),(46,'Unknown University','DRAMA & THEATRE','Arts'),(47,'University of Jaffna','ART & DESIGN','Arts'),(48,'University of Jaffna','MUSIC','Arts'),(49,'University of Jaffna','DANCE','Arts'),(50,'Swami Vipulananda Institute of Aesthetic Studies','VISUAL & TECHNOLOGICAL ARTS','Arts'),(51,'Swami Vipulananda Institute of Aesthetic Studies','MUSIC','Arts'),(52,'Swami Vipulananda Institute of Aesthetic Studies','DANCE','Arts'),(53,'Swami Vipulananda Institute of Aesthetic Studies','DRAMA & THEATRE','Arts'),(54,'University of Peradeniya','BIOLOGICAL SCIENCE','Bio'),(55,'University of Sri Jayewardenepura','BIOLOGICAL SCIENCE','Bio'),(56,'University of Kelaniya','BIOLOGICAL SCIENCE','Bio'),(57,'University of Jaffna','BIOLOGICAL SCIENCE','Bio'),(58,'University of Ruhuna','BIOLOGICAL SCIENCE','Bio'),(59,'Eastern University','BIOLOGICAL SCIENCE','Bio'),(60,'South Eastern University of Sri Lanka','BIOLOGICAL SCIENCE','Bio'),(61,'Rajarata University of Sri Lanka','APPLIED SCIENCES (BIO.SC)','Maths'),(62,'Sabaragamuwa University of Sri Lanka','APPLIED SCIENCES (BIO.SC)','Maths'),(63,'University of Vavuniya, Sri Lanka','APPLIED SCIENCES (BIO.SC)','Maths'),(64,'University of Peradeniya','ENGINEERING','Maths'),(65,'University of Sri Jayewardenepura','ENGINEERING','Maths'),(66,'University of Jaffna','ENGINEERING','Maths'),(67,'University of Ruhuna','ENGINEERING','Maths'),(68,'University of Moratuwa','ENGINEERING','Maths'),(69,'South Eastern University of Sri Lanka','ENGINEERING','Maths'),(70,'University of Moratuwa','ENGINEERING  (EM)','Maths'),(71,'University of Moratuwa','ENGINEERING  (TM)','Maths'),(72,'University of Moratuwa','QUANTITY SURVEYING','Arts'),(73,'University of Colombo','COMPUTER SCIENCE','Maths'),(74,'University of Sri Jayewardenepura','COMPUTER SCIENCE','Maths'),(75,'University of Kelaniya','COMPUTER SCIENCE','Maths'),(76,'University of Jaffna','COMPUTER SCIENCE','Maths'),(77,'University of Ruhuna','COMPUTER SCIENCE','Maths'),(78,'Trincomalee Campus, Eastern University, Sri Lanka','COMPUTER SCIENCE','Maths'),(79,'University of Colombo','PHYSICAL SCIENCE','Maths'),(80,'University of Peradeniya','PHYSICAL SCIENCE','Maths'),(81,'University of Sri Jayewardenepura','PHYSICAL SCIENCE','Maths'),(82,'University of Kelaniya','PHYSICAL SCIENCE','Maths'),(83,'University of Jaffna','PHYSICAL SCIENCE','Maths'),(84,'University of Ruhuna','PHYSICAL SCIENCE','Maths'),(85,'Eastern University','PHYSICAL SCIENCE','Maths'),(86,'South Eastern University of Sri Lanka','PHYSICAL SCIENCE','Maths'),(87,'Sabaragamuwa University of Sri Lanka','SURVEYING SCIENCE','Arts'),(88,'Rajarata University of Sri Lanka','APPLIED SCIENCES  (PHY.SC)','Maths'),(89,'Sabaragamuwa University of Sri Lanka','APPLIED SCIENCES  (PHY.SC)','Maths'),(90,'Wayamba University of Sri Lanka','APPLIED SCIENCES  (PHY.SC)','Maths'),(91,'University of Vavuniya, Sri Lanka','APPLIED SCIENCES  (PHY.SC)','Maths'),(92,'Trincomalee Campus, Eastern University, Sri Lanka','APPLIED SCIENCES  (PHY.SC)','Maths'),(93,'University of Colombo','MANAGEMENT','Commerce'),(94,'University of Peradeniya','MANAGEMENT','Commerce'),(95,'University of Sri Jayewardenepura','MANAGEMENT','Commerce'),(96,'University of Kelaniya','MANAGEMENT','Commerce'),(97,'University of Jaffna','MANAGEMENT','Commerce'),(98,'University of Ruhuna','MANAGEMENT','Commerce'),(99,'Eastern University','MANAGEMENT','Commerce'),(100,'South Eastern University of Sri Lanka','MANAGEMENT','Commerce'),(101,'Rajarata University of Sri Lanka','MANAGEMENT','Commerce'),(102,'Sabaragamuwa University of Sri Lanka','MANAGEMENT','Commerce'),(103,'Wayamba University of Sri Lanka','MANAGEMENT','Commerce'),(104,'University of Sri Jayewardenepura','REAL ESTATE MANAGEMENT & VALUATION','Commerce'),(105,'University of Sri Jayewardenepura','COMMERCE','Commerce'),(106,'University of Kelaniya','COMMERCE','Commerce'),(107,'University of Jaffna','COMMERCE','Commerce'),(108,'Eastern University','COMMERCE','Commerce'),(109,'South Eastern University of Sri Lanka','COMMERCE','Commerce'),(110,'University of Sri Jayewardenepura','MANAGEMENT AND PUBLIC POLICY','Commerce'),(111,'University of Sri Jayewardenepura','BUSINESS INFORMATION SYSTEMS (HONOURS) (BIS)','Arts'),(112,'University of Kelaniya','FINANCIAL ENGINEERING','Maths'),(113,'University of Vavuniya, Sri Lanka','BANKING & INSURANCE','Arts'),(114,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','SERVICE MANAGEMENT','Commerce'),(115,'University of Colombo','LAW','Arts'),(116,'University of Peradeniya','LAW','Arts'),(117,'University of Jaffna','LAW','Arts'),(118,'University of Colombo','ARTS','Arts'),(119,'University of Peradeniya','ARTS','Arts'),(120,'University of Sri Jayewardenepura','ARTS','Arts'),(121,'University of Kelaniya','ARTS','Arts'),(122,'University of Jaffna','ARTS','Arts'),(123,'University of Ruhuna','ARTS','Arts'),(124,'Eastern University','ARTS','Arts'),(125,'South Eastern University of Sri Lanka','ARTS','Arts'),(126,'Rajarata University of Sri Lanka','ARTS','Arts'),(127,'University of Colombo','ARTS  (SP) / MASS MEDIA','Arts'),(128,'University of Colombo','ARTS (SP) / PERFORMING ARTS','Arts'),(129,'Unknown University','ARTS (SAB) - A  [Arts Stream] (Sabaragamuwa University of Sri Lanka)','Arts'),(130,'Unknown University','ARTS (SAB) - B  [Commerce Stream] (Sabaragamuwa University of Sri Lanka)','Commerce'),(131,'University of Sri Jayewardenepura','ARTS-INFORMATION TECHNOLOGY','Arts'),(132,'University of Sri Jayewardenepura','AQUATIC BIORESOURCES','Arts'),(133,'University of Sri Jayewardenepura','URBAN BIORESOURCES','Arts'),(134,'University of Peradeniya','SOCIAL WORK','Arts'),(135,'University of Sri Jayewardenepura','SOCIAL WORK','Arts'),(136,'Uva Wellassa University','HUMAN RESOURCE DEVELOPMENT','Arts'),(137,'University of Colombo','PRIMARY EDUCATION','Arts'),(138,'Unknown University','MANAGEMENT STUDIES (TV) - A','Commerce'),(139,'University of Vavuniya, Sri Lanka','MANAGEMENT STUDIES (TV) - B','Commerce'),(140,'University of Vavuniya, Sri Lanka','MANAGEMENT STUDIES (TV) - B','Commerce'),(141,'Trincomalee Campus, Eastern University, Sri Lanka','COMMUNICATION STUDIES','Arts'),(142,'University of Sri Jayewardenepura','FINANCIAL ECONOMICS','Arts'),(143,'University of Sri Jayewardenepura','CREATIVE MUSIC TECHNOLOGY & PRODUCTION','Arts'),(144,'University of Kelaniya','PEACE & CONFLICT RESOLUTION','Maths'),(145,'South Eastern University of Sri Lanka','ISLAMIC STUDIES','Arts'),(146,'South Eastern University of Sri Lanka','ARABIC  LANGUAGE','Arts'),(147,'University of Moratuwa','ARCHITECTURE','Arts'),(148,'University of Moratuwa','DESIGN','Arts'),(149,'University of Moratuwa','LANDSCAPE ARCHITECTURE','Arts'),(150,'University of Moratuwa','URBAN INFORMATICS AND PLANNING','Arts'),(151,'University of Moratuwa','FASHION DESIGN & PRODUCT DEVELOPMENT','Arts'),(152,'University of Moratuwa','ARTIFICIAL INTELLIGENCE','Maths'),(153,'University of Moratuwa','INFORMATION TECHNOLOGY (IT)','Arts'),(154,'University of Moratuwa','INFORMATION TECHNOLOGY & MANAGEMENT','Commerce'),(155,'University of Moratuwa','FACILITIES MANAGEMENT','Commerce'),(156,'University of Moratuwa','TRANSPORT MANAGEMENT & LOGISTICS ENGINEERING (TMLE)','Maths'),(157,'University of Moratuwa','BUSINESS SCIENCE','Arts'),(158,'University of Kelaniya','MANAGEMENT AND INFORMATION TECHNOLOGY  (MIT) (BIO SCIENCE  STREAM)','Commerce'),(159,'University of Kelaniya','MANAGEMENT AND INFORMATION TECHNOLOGY  (MIT) (OTHER STREAM)','Commerce'),(160,'University of Colombo','INDUSTRIAL STATISTICS & MATHEMATICAL FINANCE','Arts'),(161,'University of Ruhuna','FINANCIAL MATHEMATICS AND INDUSTRIAL STATISTICS','Arts'),(162,'University of Peradeniya','STATISTICS & OPERATIONS RESEARCH','Arts'),(163,'University of Peradeniya','GEOGRAPHICAL INFORMATION SCIENCE','Arts'),(164,'Rajarata University of Sri Lanka','INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)','Maths'),(165,'University of Vavuniya, Sri Lanka','INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)','Maths'),(166,'University of Colombo','INFORMATION SYSTEMS','Arts'),(167,'University of Sri Jayewardenepura','INFORMATION SYSTEMS','Arts'),(168,'Sabaragamuwa University of Sri Lanka','INFORMATION SYSTEMS','Arts'),(169,'University of Sri Jayewardenepura','SOFTWARE ENGINEERING','Maths'),(170,'University of Kelaniya','SOFTWARE ENGINEERING','Maths'),(171,'Sabaragamuwa University of Sri Lanka','SOFTWARE ENGINEERING','Maths'),(172,'University of Colombo','AYURVEDA MEDICINE & SURGERY','Bio'),(173,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','AYURVEDA MEDICINE & SURGERY','Bio'),(174,'University of Colombo','UNANI MEDICINE & SURGERY','Bio'),(175,'University of Jaffna','SIDDHA MEDICINE & SURGERY','Bio'),(176,'Trincomalee Campus, Eastern University, Sri Lanka','SIDDHA MEDICINE & SURGERY','Bio'),(177,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','INDIGENOUS MEDICINAL RESOURCES','Arts'),(178,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','HEALTH INFORMATION AND COMMUNICATION TECHNOLOGY','Arts'),(179,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','HEALTH TOURISM AND HOSPITALITY MANAGEMENT','Commerce'),(180,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','BIOMEDICAL TECHNOLOGY','Arts'),(181,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','INDIGENOUS PHARMACEUTICAL TECHNOLOGY','Arts'),(182,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','YOGA AND PARAPSYCHOLOGY','Arts'),(183,'Gampaha Wickramarachchi University of Indigenous Medicine, Sri Lanka','SOCIAL STUDIES IN INDIGENOUS KNOWLEDGE','Arts'),(184,'Rajarata University of Sri Lanka','HEALTH PROMOTION','Arts'),(185,'University of Colombo','NURSING','Arts'),(186,'University of Peradeniya','NURSING','Arts'),(187,'University of Sri Jayewardenepura','NURSING','Arts'),(188,'University of Jaffna','NURSING','Arts'),(189,'University of Ruhuna','NURSING','Arts'),(190,'Eastern University','NURSING','Arts'),(191,'University of Peradeniya','PHARMACY','Arts'),(192,'University of Sri Jayewardenepura','PHARMACY','Arts'),(193,'University of Jaffna','PHARMACY','Arts'),(194,'University of Ruhuna','PHARMACY','Arts'),(195,'University of Peradeniya','MEDICAL LABORATORY SCIENCES','Arts'),(196,'University of Sri Jayewardenepura','MEDICAL LABORATORY SCIENCES','Arts'),(197,'University of Jaffna','MEDICAL LABORATORY SCIENCES','Arts'),(198,'University of Ruhuna','MEDICAL LABORATORY SCIENCES','Arts'),(199,'University of Peradeniya','RADIOGRAPHY','Arts'),(200,'University of Colombo','MEDICAL IMAGING TECHNOLOGY','Arts'),(201,'University of Colombo','PHYSIOTHERAPY','Arts'),(202,'University of Peradeniya','PHYSIOTHERAPY','Arts'),(203,'University of Kelaniya','OCCUPATIONAL THERAPY','Arts'),(204,'University of Sri Jayewardenepura','OPTOMETRY','Arts'),(205,'University of Kelaniya','ENVIRONMENTAL CONSERVATION & MANAGEMENT','Commerce'),(206,'University of Kelaniya','APPLIED CHEMISTRY','Arts'),(207,'University of Kelaniya','ELECTRONICS AND COMPUTER SCIENCE','Maths'),(208,'University of Kelaniya','ACCOUNTING INFORMATION SYSTEMS','Commerce'),(209,'University of Ruhuna','FISHERIES & MARINE SCIENCES','Arts'),(210,'University of Ruhuna','MARINE AND FRESHWATER SCIENCES','Arts'),(211,'University of Peradeniya','ANIMAL SCIENCE & FISHERIES','Arts'),(212,'Unknown University','FOOD  PRODUCTION','Arts'),(213,'Sabaragamuwa University of Sri Lanka','FOOD BUSINESS MANAGEMENT','Commerce'),(214,'Unknown University','FOOD BUSINESS MANAGEMENT','Commerce'),(215,'South Eastern University of Sri Lanka','MANAGEMENT AND INFORMATION TECHNOLOGY (SEUSL)','Commerce'),(216,'Sabaragamuwa University of Sri Lanka','DATA SCIENCE','Arts'),(217,'University of Jaffna','PHYSICAL EDUCATION','Maths'),(218,'Sabaragamuwa University of Sri Lanka','PHYSICAL EDUCATION','Maths'),(219,'University of Sri Jayewardenepura','SPORTS SCIENCE & MANAGEMENT','Commerce'),(220,'University of Kelaniya','SPORTS SCIENCE & MANAGEMENT','Commerce'),(221,'Sabaragamuwa University of Sri Lanka','SPORTS SCIENCE & MANAGEMENT','Commerce'),(222,'University of Kelaniya','SPEECH AND HEARING SCIENCES','Arts'),(223,'Rajarata University of Sri Lanka','TOURISM & HOSPITALITY MANAGEMENT','Commerce'),(224,'Sabaragamuwa University of Sri Lanka','TOURISM & HOSPITALITY MANAGEMENT','Commerce'),(225,'University of Ruhuna','AGRICULTURAL RESOURCE MANAGEMENT AND TECHNOLOGY','Commerce'),(226,'University of Ruhuna','AGRI BUSINESS MANAGEMENT','Commerce'),(227,'University of Ruhuna','GREEN TECHNOLOGY','Arts'),(228,'Uva Wellassa University','SCIENCE AND TECHNOLOGY','Arts'),(229,'Uva Wellassa University','COMPUTER SCIENCE & TECHNOLOGY','Maths'),(230,'Uva Wellassa University','ENTREPRENEURSHIP AND MANAGEMENT','Commerce'),(231,'Uva Wellassa University','ANIMAL PRODUCTION AND FOOD TECHNOLOGY','Arts'),(232,'Uva Wellassa University','EXPORT AGRICULTURE','Bio'),(233,'Uva Wellassa University','INDUSTRIAL INFORMATION TECHNOLOGY','Arts'),(234,'Uva Wellassa University','MINERAL RESOURCES AND TECHNOLOGY','Arts'),(235,'Uva Wellassa University','AQUATIC RESOURCES TECHNOLOGY','Arts'),(236,'Uva Wellassa University','HOSPITALITY, TOURISM AND EVENTS MANAGEMENT','Commerce'),(237,'Uva Wellassa University','ENGLISH LANGUAGE & APPLIED LINGUISTICS','Arts'),(238,'Uva Wellassa University','PLANTATION MANAGEMENT AND TECHNOLOGY','Commerce'),(239,'University of Sri Jayewardenepura','POLYMER SCIENCE AND INDUSTRIAL MANAGEMENT','Commerce'),(240,'University of Colombo','ENGINEERING TECHNOLOGY (ET)','Maths'),(241,'University of Sri Jayewardenepura','ENGINEERING TECHNOLOGY (ET)','Maths'),(242,'University of Kelaniya','ENGINEERING TECHNOLOGY (ET)','Maths'),(243,'University of Jaffna','ENGINEERING TECHNOLOGY (ET)','Maths'),(244,'University of Ruhuna','ENGINEERING TECHNOLOGY (ET)','Maths'),(245,'Rajarata University of Sri Lanka','ENGINEERING TECHNOLOGY (ET)','Maths'),(246,'Sabaragamuwa University of Sri Lanka','ENGINEERING TECHNOLOGY (ET)','Maths'),(247,'Wayamba University of Sri Lanka','ENGINEERING TECHNOLOGY (ET)','Maths'),(248,'Uva Wellassa University','ENGINEERING TECHNOLOGY (ET)','Maths'),(249,'University of Colombo','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(250,'University of Sri Jayewardenepura','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(251,'University of Kelaniya','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(252,'University of Jaffna','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(253,'University of Ruhuna','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(254,'Eastern University','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(255,'South Eastern University of Sri Lanka','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(256,'Rajarata University of Sri Lanka','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(257,'Sabaragamuwa University of Sri Lanka','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(258,'Wayamba University of Sri Lanka','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(259,'Uva Wellassa University','BIOSYSTEMS TECHNOLOGY (BST)','Arts'),(260,'University of Colombo','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(261,'University of Sri Jayewardenepura','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(262,'University of Kelaniya','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(263,'University of Ruhuna','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(264,'Eastern University','INFORMATION COMMUNICATION TECHNOLOGY','Arts'),(265,'South Eastern University of Sri Lanka','INFORMATION COMMUNICATION TECHNOLOGY','Arts');
/*!40000 ALTER TABLE `university_degrees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_preferences`
--

DROP TABLE IF EXISTS `user_preferences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_preferences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `stream` varchar(100) DEFAULT NULL,
  `university` varchar(255) DEFAULT NULL,
  `degree` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_preferences`
--

LOCK TABLES `user_preferences` WRITE;
/*!40000 ALTER TABLE `user_preferences` DISABLE KEYS */;
INSERT INTO `user_preferences` VALUES (1,'praveen','a.r.s.praveenfernando@gmail.com','Male','Physical Science','University of Moratuwa','ARTIFICIAL INTELLIGENCE','2026-04-03 05:28:24'),(2,'rajeewa','fassainssin@gmail.com','Male','Physical Science','University of Moratuwa','ENGINEERING','2026-04-03 05:35:47'),(3,'sudarsha','vergin.fernando@gmail.com','Male','Commerce','University of Sri Jayewardenepura','MEDICINE','2026-04-03 05:58:53'),(4,'praveen','rxckdeaddogs@gmail.com','Male','Physical Science','University of Moratuwa','DESIGN','2026-04-03 06:23:45'),(5,'jhhg','ramanathan.praveen456@gmail.com','Male','Engineering Technology','University of Peradeniya','ENGINEERING','2026-04-03 07:11:37');
/*!40000 ALTER TABLE `user_preferences` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'student','$2y$10$Vfvn5My7za1jGVGxa1Vje.3Xks77FNyNGWaSjERHWDQ6A9Rwwss/e%','Sample Student','student@example.com','2026-04-02 18:47:26');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zscore_cutoffs`
--

DROP TABLE IF EXISTS `zscore_cutoffs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zscore_cutoffs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `degree_id` int(11) DEFAULT NULL,
  `stream` enum('Maths','Bio','Commerce','Arts') DEFAULT NULL,
  `cutoff` decimal(4,3) DEFAULT NULL,
  `year` year(4) DEFAULT NULL,
  `subject1` varchar(50) DEFAULT NULL,
  `subject2` varchar(50) DEFAULT NULL,
  `subject3` varchar(50) DEFAULT NULL,
  `district` varchar(50) DEFAULT 'All',
  PRIMARY KEY (`id`),
  KEY `degree_id` (`degree_id`),
  CONSTRAINT `zscore_cutoffs_ibfk_1` FOREIGN KEY (`degree_id`) REFERENCES `degrees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zscore_cutoffs`
--

LOCK TABLES `zscore_cutoffs` WRITE;
/*!40000 ALTER TABLE `zscore_cutoffs` DISABLE KEYS */;
INSERT INTO `zscore_cutoffs` VALUES (6,1,'Maths',1.980,2025,'Combined Mathematics','Physics','Chemistry','All'),(7,2,'Maths',1.900,2025,'Combined Mathematics','Physics','Chemistry','All'),(8,3,'Maths',2.100,2025,'Combined Mathematics','Physics','ICT','All'),(9,4,'Maths',2.250,2025,'Combined Mathematics','Physics','ICT','All'),(10,5,'Maths',1.920,2025,'Combined Mathematics','Physics','Chemistry','All');
/*!40000 ALTER TABLE `zscore_cutoffs` 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-04-03 13:52:35