engdb.sql

-- MySQL dump 10.13  Distrib 8.0.43, for Win64 (x86_64)
--
-- Host: localhost    Database: engdb
-- ------------------------------------------------------
-- Server version	9.3.0

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!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`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `id` varchar(10) NOT NULL,
  `access_level` int DEFAULT NULL,
  `report_email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `admin_ibfk_1` FOREIGN KEY (`id`) REFERENCES `employee` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES ('1000000087',1,'1000000087@center.com'),('1000000093',1,'1000000093@center.com');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attendance`
--

DROP TABLE IF EXISTS `attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `status` enum('PRESENT','ABSENT') NOT NULL,
  `note` varchar(250) DEFAULT NULL,
  `enrollment_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `enrollment_id` (`enrollment_id`),
  CONSTRAINT `attendance_ibfk_1` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollment` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendance`
--

LOCK TABLES `attendance` WRITE;
/*!40000 ALTER TABLE `attendance` DISABLE KEYS */;
INSERT INTO `attendance` VALUES (1,'2025-12-08','PRESENT','',4),(2,'2025-12-08','ABSENT','Vắng không phép',4),(3,'2025-12-08','ABSENT','Vắng không phép',5),(4,'2025-12-08','ABSENT','Vắng không phép',5),(5,'2025-12-08','ABSENT','Vắng không phép',6),(6,'2025-12-08','PRESENT','',6),(7,'2025-12-08','PRESENT','',8),(8,'2025-12-08','PRESENT','',8),(9,'2025-12-08','PRESENT','',9),(10,'2025-12-08','ABSENT','Vắng không phép',9),(11,'2025-12-08','PRESENT','',15),(12,'2025-12-08','ABSENT','Vắng không phép',15),(13,'2025-12-08','PRESENT','',20),(14,'2025-12-08','PRESENT','',20),(15,'2025-12-08','PRESENT','',23),(16,'2025-12-08','PRESENT','',23),(17,'2025-12-08','PRESENT','',28),(18,'2025-12-08','ABSENT','Vắng không phép',28),(19,'2025-12-08','PRESENT','',31),(20,'2025-12-08','ABSENT','Vắng không phép',31),(21,'2025-12-08','ABSENT','Vắng không phép',33),(22,'2025-12-08','ABSENT','Vắng không phép',33),(23,'2025-12-08','PRESENT','',36),(24,'2025-12-08','PRESENT','',36),(25,'2025-12-08','ABSENT','Vắng không phép',38),(26,'2025-12-08','ABSENT','Vắng không phép',38),(27,'2025-12-08','PRESENT','',39),(28,'2025-12-08','PRESENT','',39),(29,'2025-12-08','ABSENT','Vắng không phép',40),(30,'2025-12-08','ABSENT','Vắng không phép',40),(31,'2025-12-08','ABSENT','Vắng không phép',44),(32,'2025-12-08','ABSENT','Vắng không phép',44),(33,'2025-12-08','ABSENT','Vắng không phép',50),(34,'2025-12-08','PRESENT','',50),(35,'2025-12-08','ABSENT','Vắng không phép',51),(36,'2025-12-08','ABSENT','Vắng không phép',51),(37,'2025-12-08','PRESENT','',52),(38,'2025-12-08','ABSENT','Vắng không phép',52),(39,'2025-12-08','ABSENT','Vắng không phép',55),(40,'2025-12-08','ABSENT','Vắng không phép',55),(41,'2025-12-08','PRESENT','',56),(42,'2025-12-08','PRESENT','',56),(43,'2025-12-08','ABSENT','Vắng không phép',58),(44,'2025-12-08','ABSENT','Vắng không phép',58),(45,'2025-12-08','PRESENT','',61),(46,'2025-12-08','ABSENT','Vắng không phép',61),(47,'2025-12-08','PRESENT','',72),(48,'2025-12-08','PRESENT','',72),(49,'2025-12-08','PRESENT','',73),(50,'2025-12-08','PRESENT','',73),(51,'2025-12-08','ABSENT','Vắng không phép',76),(52,'2025-12-08','PRESENT','',76),(53,'2025-12-08','ABSENT','Vắng không phép',77),(54,'2025-12-08','ABSENT','Vắng không phép',77),(55,'2025-12-08','ABSENT','Vắng không phép',78),(56,'2025-12-08','PRESENT','',78),(57,'2025-12-08','ABSENT','Vắng không phép',85),(58,'2025-12-08','ABSENT','Vắng không phép',85),(59,'2025-12-08','ABSENT','Vắng không phép',93),(60,'2025-12-08','ABSENT','Vắng không phép',93),(61,'2025-12-08','ABSENT','Vắng không phép',94),(62,'2025-12-08','ABSENT','Vắng không phép',94),(63,'2025-12-08','PRESENT','',105),(64,'2025-12-08','ABSENT','Vắng không phép',105),(65,'2025-12-08','ABSENT','Vắng không phép',107),(66,'2025-12-08','PRESENT','',107),(67,'2025-12-08','ABSENT','Vắng không phép',108),(68,'2025-12-08','PRESENT','',108),(69,'2025-12-08','PRESENT','',109),(70,'2025-12-08','ABSENT','Vắng không phép',109),(71,'2025-12-08','ABSENT','Vắng không phép',110),(72,'2025-12-08','PRESENT','',110),(73,'2025-12-08','ABSENT','Vắng không phép',117),(74,'2025-12-08','PRESENT','',117),(75,'2025-12-08','PRESENT','',119),(76,'2025-12-08','ABSENT','Vắng không phép',119),(77,'2025-12-08','ABSENT','Vắng không phép',120),(78,'2025-12-08','PRESENT','',120),(79,'2025-12-08','PRESENT','',121),(80,'2025-12-08','PRESENT','',121),(81,'2025-12-08','ABSENT','Vắng không phép',126),(82,'2025-12-08','PRESENT','',126),(83,'2025-12-08','ABSENT','Vắng không phép',134),(84,'2025-12-08','ABSENT','Vắng không phép',134),(85,'2025-12-08','ABSENT','Vắng không phép',138),(86,'2025-12-08','PRESENT','',138),(87,'2025-12-08','PRESENT','',146),(88,'2025-12-08','ABSENT','Vắng không phép',146),(89,'2025-12-08','ABSENT','Vắng không phép',152),(90,'2025-12-08','ABSENT','Vắng không phép',152),(91,'2025-12-08','ABSENT','Vắng không phép',153),(92,'2025-12-08','PRESENT','',153),(93,'2025-12-08','ABSENT','Vắng không phép',155),(94,'2025-12-08','ABSENT','Vắng không phép',155),(95,'2025-12-08','PRESENT','',158),(96,'2025-12-08','PRESENT','',158),(97,'2025-12-08','PRESENT','',159),(98,'2025-12-08','PRESENT','',159),(99,'2025-12-08','ABSENT','Vắng không phép',166),(100,'2025-12-08','ABSENT','Vắng không phép',166),(101,'2025-12-08','ABSENT','Vắng không phép',167),(102,'2025-12-08','ABSENT','Vắng không phép',167),(103,'2025-12-08','PRESENT','',174),(104,'2025-12-08','ABSENT','Vắng không phép',174),(105,'2025-12-08','PRESENT','',176),(106,'2025-12-08','PRESENT','',176),(107,'2025-12-08','ABSENT','Vắng không phép',178),(108,'2025-12-08','ABSENT','Vắng không phép',178),(109,'2025-12-08','ABSENT','Vắng không phép',179),(110,'2025-12-08','PRESENT','',179),(111,'2025-12-08','PRESENT','',180),(112,'2025-12-08','ABSENT','Vắng không phép',180);
/*!40000 ALTER TABLE `attendance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bill`
--

DROP TABLE IF EXISTS `bill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bill` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_date` datetime NOT NULL,
  `status` enum('UNPAID','PAID') NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `enrollment_id` int NOT NULL,
  `cashier_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `enrollment_id` (`enrollment_id`),
  KEY `cashier_id` (`cashier_id`),
  CONSTRAINT `bill_ibfk_1` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollment` (`id`),
  CONSTRAINT `bill_ibfk_2` FOREIGN KEY (`cashier_id`) REFERENCES `cashier` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bill`
--

LOCK TABLES `bill` WRITE;
/*!40000 ALTER TABLE `bill` DISABLE KEYS */;
INSERT INTO `bill` VALUES (1,'2025-01-10 07:46:34','PAID',5000000.00,4,'1020000008'),(2,'2025-11-23 13:33:54','PAID',1000000.00,5,'1020000129'),(3,'2025-09-15 08:36:50','PAID',1000000.00,6,'1020000106'),(4,'2025-09-07 06:33:27','PAID',3000000.00,8,'1020000006'),(5,'2025-08-06 15:15:02','PAID',1000000.00,9,'1020000091'),(6,'2025-11-05 16:07:41','PAID',1000000.00,15,'1020000131'),(7,'2025-09-04 02:31:38','UNPAID',3000000.00,20,'1020000086'),(8,'2025-11-11 03:44:23','UNPAID',1000000.00,23,'1020000006'),(9,'2025-03-28 02:31:31','PAID',1000000.00,28,'1020000003'),(10,'2025-10-13 03:30:15','PAID',5000000.00,31,'1020000091'),(11,'2025-07-30 07:49:00','UNPAID',2500000.00,33,'1020000045'),(12,'2025-09-21 16:07:15','PAID',5000000.00,36,'1020000003'),(13,'2025-03-05 07:26:58','UNPAID',3000000.00,38,'1020000129'),(14,'2024-12-11 05:29:30','PAID',5000000.00,39,'1020000006'),(15,'2025-11-21 22:31:26','PAID',3000000.00,40,'1020000086'),(16,'2025-02-03 08:24:59','UNPAID',5000000.00,44,'1020000106'),(17,'2025-10-25 14:58:13','PAID',5000000.00,50,'1020000008'),(18,'2025-02-28 02:09:44','PAID',1000000.00,51,'1020000045'),(19,'2025-09-23 03:58:17','PAID',5000000.00,52,'1020000006'),(20,'2025-07-21 22:04:41','PAID',5000000.00,55,'1020000061'),(21,'2025-08-28 23:11:26','PAID',5000000.00,56,'1020000091'),(22,'2024-12-10 23:00:20','PAID',3000000.00,58,'1020000045'),(23,'2025-05-21 01:26:05','PAID',5000000.00,61,'1020000129'),(24,'2025-01-28 00:44:12','PAID',5000000.00,72,'1020000086'),(25,'2025-02-04 03:28:06','PAID',5000000.00,73,'1020000006'),(26,'2025-06-15 23:46:09','PAID',5000000.00,76,'1020000008'),(27,'2025-07-06 19:12:39','PAID',3000000.00,77,'1020000129'),(28,'2024-12-25 14:17:55','PAID',2500000.00,78,'1020000008'),(29,'2025-06-23 02:50:31','PAID',1000000.00,85,'1020000045'),(30,'2025-04-12 10:29:00','PAID',5000000.00,93,'1020000045'),(31,'2025-03-05 01:59:30','PAID',2500000.00,94,'1020000131'),(32,'2025-08-26 18:37:48','UNPAID',1000000.00,105,'1020000003'),(33,'2025-02-15 09:08:36','UNPAID',3000000.00,107,'1020000129'),(34,'2025-06-04 23:36:43','PAID',1000000.00,108,'1020000129'),(35,'2025-04-11 14:31:49','PAID',5000000.00,109,'1020000131'),(36,'2025-08-24 14:00:09','PAID',5000000.00,110,'1020000061'),(37,'2025-11-16 21:05:15','PAID',2500000.00,117,'1020000131'),(38,'2025-05-30 12:46:54','UNPAID',2500000.00,119,'1020000008'),(39,'2025-03-09 12:45:13','PAID',5000000.00,120,'1020000003'),(40,'2025-08-18 18:09:02','UNPAID',1000000.00,121,'1020000003'),(41,'2025-08-14 03:58:33','PAID',1000000.00,126,'1020000106'),(42,'2025-09-20 16:54:39','PAID',5000000.00,134,'1020000131'),(43,'2025-03-26 13:55:20','PAID',1000000.00,138,'1020000106'),(44,'2025-08-28 21:37:23','UNPAID',5000000.00,146,'1020000106'),(45,'2025-09-10 09:51:35','PAID',5000000.00,152,'1020000003'),(46,'2025-02-20 22:47:13','UNPAID',1000000.00,153,'1020000006'),(47,'2025-01-17 15:11:26','PAID',5000000.00,155,'1020000091'),(48,'2025-04-24 11:55:51','UNPAID',2500000.00,158,'1020000006'),(49,'2025-06-18 00:01:14','UNPAID',3000000.00,159,'1020000131'),(50,'2025-03-25 08:14:21','UNPAID',1000000.00,166,'1020000131'),(51,'2025-04-25 14:15:29','UNPAID',5000000.00,167,'1020000006'),(52,'2025-07-06 20:05:58','PAID',5000000.00,174,'1020000129'),(53,'2025-07-26 06:00:15','PAID',5000000.00,176,'1020000045'),(54,'2025-03-29 10:43:42','PAID',2500000.00,178,'1020000131'),(55,'2025-03-04 06:16:17','PAID',5000000.00,179,'1020000106'),(75,'2025-12-14 13:29:18','PAID',1000000.00,205,'1020000106'),(79,'2025-12-14 16:07:03','PAID',5000000.00,209,'1020000086'),(80,'2025-12-14 16:23:53','PAID',5000000.00,210,'1020000086'),(81,'2025-12-14 20:35:52','PAID',5000000.00,211,'1020000131');
/*!40000 ALTER TABLE `bill` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cashier`
--

DROP TABLE IF EXISTS `cashier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cashier` (
  `id` varchar(10) NOT NULL,
  `shift` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `cashier_ibfk_1` FOREIGN KEY (`id`) REFERENCES `employee` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cashier`
--

LOCK TABLES `cashier` WRITE;
/*!40000 ALTER TABLE `cashier` DISABLE KEYS */;
INSERT INTO `cashier` VALUES ('1020000003','Sáng (7h-12h)'),('1020000006','Chiều (13h-17h)'),('1020000008','Chiều (13h-17h)'),('1020000045','Chiều (13h-17h)'),('1020000061','Chiều (13h-17h)'),('1020000086','Tối (17h-21h)'),('1020000091','Chiều (13h-17h)'),('1020000106','Sáng (7h-12h)'),('1020000129','Tối (17h-21h)'),('1020000131','Tối (17h-21h)');
/*!40000 ALTER TABLE `cashier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `classroom`
--

DROP TABLE IF EXISTS `classroom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `classroom` (
  `id` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `max_student` int NOT NULL,
  `teacher_id` varchar(10) NOT NULL,
  `course_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `teacher_id` (`teacher_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `classroom_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `teacher` (`id`),
  CONSTRAINT `classroom_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `classroom`
--

LOCK TABLES `classroom` WRITE;
/*!40000 ALTER TABLE `classroom` DISABLE KEYS */;
INSERT INTO `classroom` VALUES ('CL001','Lớp C010-1','2025-03-29','2025-06-27',11,'1010000080','C010'),('CL002','Lớp C012-2','2025-08-31','2025-11-29',30,'1010000022','C012'),('CL003','Lớp C019-3','2025-11-14','2026-02-12',24,'1010000134','C019'),('CL004','Lớp C010-4','2025-07-21','2025-10-19',17,'1010000053','C010'),('CL005','Lớp C004-5','2025-06-13','2025-09-11',28,'1010000110','C004'),('CL006','Lớp C020-6','2025-02-28','2025-05-29',12,'1010000022','C020'),('CL007','Lớp C020-7','2025-11-27','2026-02-25',27,'1010000071','C020'),('CL008','Lớp C004-8','2024-12-18','2025-03-18',17,'1010000134','C004'),('CL009','Lớp C008-9','2025-09-08','2025-12-07',16,'1010000142','C008'),('CL010','Lớp C020-10','2025-06-02','2025-08-31',15,'1010000016','C020'),('CL011','Lớp C009-11','2025-08-06','2025-11-04',12,'1010000135','C009'),('CL012','Lớp C017-12','2025-07-28','2025-10-26',14,'1010000083','C017'),('CL013','Lớp C018-13','2025-10-24','2026-01-22',29,'1010000135','C018'),('CL014','Lớp C006-14','2025-08-25','2025-11-23',20,'1010000134','C006'),('CL015','Lớp C002-15','2025-02-13','2025-05-14',24,'1010000080','C002'),('CL016','Lớp C005-16','2025-08-02','2025-10-31',27,'1010000134','C005'),('CL017','Lớp C010-17','2025-05-28','2025-08-26',29,'1010000142','C010'),('CL018','Lớp C005-18','2025-04-09','2025-07-08',15,'1010000053','C005'),('CL019','Lớp C012-19','2025-07-20','2025-10-18',14,'1010000080','C012'),('CL020','Lớp C009-20','2025-04-14','2025-07-13',19,'1010000029','C009'),('CL021','Lớp C005-21','2025-05-23','2025-08-21',16,'1010000065','C005'),('CL022','Lớp C005-22','2025-07-16','2025-10-14',21,'1010000016','C005'),('CL023','Lớp C005-23','2025-10-02','2025-12-31',18,'1010000065','C005'),('CL024','Lớp C010-24','2025-11-09','2026-02-07',20,'1010000134','C010'),('CL025','Lớp C011-25','2025-11-08','2026-02-06',30,'1010000053','C011'),('CL026','Lớp C014-26','2025-08-09','2025-11-07',27,'1010000142','C014'),('CL027','Lớp C002-27','2025-02-01','2025-05-02',12,'1010000080','C002'),('CL028','Lớp C007-28','2025-06-24','2025-09-22',24,'1010000142','C007'),('CL029','Lớp C015-29','2025-05-23','2025-08-21',27,'1010000134','C015'),('CL030','Lớp C017-30','2025-05-09','2025-08-07',12,'1010000065','C017'),('CL031','Lớp C008-31','2025-03-10','2025-06-08',29,'1010000063','C008'),('CL032','Lớp C015-32','2025-04-30','2025-07-29',16,'1010000071','C015'),('CL033','Lớp C004-33','2025-05-04','2025-08-02',19,'1010000016','C004'),('CL034','Lớp C004-34','2025-04-01','2025-06-30',26,'1010000134','C004'),('CL035','Lớp C005-35','2025-03-11','2025-06-09',12,'1010000110','C005'),('CL036','Lớp C015-36','2025-02-28','2025-05-29',16,'1010000142','C015'),('CL037','Lớp C002-37','2025-03-17','2025-06-15',21,'1010000111','C002'),('CL038','Lớp C019-38','2025-03-11','2025-06-09',16,'1010000041','C019'),('CL039','Lớp C008-39','2025-07-04','2025-10-02',20,'1010000083','C008'),('CL040','Lớp C013-40','2025-07-24','2025-10-22',12,'1010000083','C013'),('CL041','Lớp C020-41','2025-11-09','2026-02-07',14,'1010000134','C020'),('CL042','Lớp C020-42','2025-12-03','2026-03-03',16,'1010000053','C020'),('CL043','Lớp C018-43','2025-11-16','2026-02-14',28,'1010000065','C018'),('CL044','Lớp C015-44','2025-05-01','2025-07-30',24,'1010000135','C015'),('CL045','Lớp C006-45','2025-12-08','2026-03-08',20,'1010000071','C006'),('CL046','Lớp C006-46','2025-06-02','2025-08-31',16,'1010000111','C006'),('CL047','Lớp C014-47','2025-03-10','2025-06-08',24,'1010000134','C014'),('CL048','Lớp C006-48','2025-07-28','2025-10-26',25,'1010000029','C006'),('CL049','Lớp C005-49','2025-04-18','2025-07-17',20,'1010000071','C005'),('CL050','Lớp C011-50','2025-08-07','2025-11-05',13,'1010000053','C011');
/*!40000 ALTER TABLE `classroom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `course`
--

DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course` (
  `id` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `age` enum('KIDS','TEEN','ADULT') NOT NULL,
  `level` enum('BEGINNER','INTERMEDIATE','ADVANCED') NOT NULL,
  `duration_hour` varchar(10) NOT NULL,
  `course_description` varchar(250) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `course`
--

LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
INSERT INTO `course` VALUES ('C001','Tiếng Anh Giao Tiếp - 1',3000000.00,'ADULT','ADVANCED','36h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385339/eng_general_h83uep.webp'),('C002','Tiếng Anh Trẻ Em - 2',1000000.00,'KIDS','INTERMEDIATE','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385343/eng_kids2_g7mo9u.jpg'),('C003','TOEIC Basic - 3',2500000.00,'TEEN','ADVANCED','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765434561/toeic_jh6mhe.webp'),('C004','Business English - 4',5000000.00,'ADULT','ADVANCED','36h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385343/eng_teeen_fwpqte.webp'),('C005','Business English - 5',5000000.00,'TEEN','INTERMEDIATE','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385345/toeic_lis_s4ksfw.webp'),('C006','Tiếng Anh Giao Tiếp - 6',5000000.00,'ADULT','ADVANCED','48h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385339/eng_comm_pctfiv.jpg'),('C007','English for IT - 7',1000000.00,'TEEN','ADVANCED','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1764749341/course_placeholder1_l14zh8.jpg'),('C008','Tiếng Anh Giao Tiếp - 8',1000000.00,'KIDS','INTERMEDIATE','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1764749339/course_placeholder2_zmqagp.jpg'),('C009','Business English - 9',2500000.00,'KIDS','INTERMEDIATE','72h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1764749338/course_placeholder6_rpibb7.jpg'),('C010','Tiếng Anh Giao Tiếp - 10',5000000.00,'TEEN','BEGINNER','48h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1764749339/course_placeholder2_zmqagp.jpg'),('C011','IELTS Foundation - 11',1000000.00,'TEEN','BEGINNER','36h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385121/ielts3_xldfyy.webp'),('C012','Business English - 12',5000000.00,'TEEN','ADVANCED','24h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385339/eng_comm_pctfiv.jpg'),('C013','IELTS Foundation - 13',2500000.00,'TEEN','INTERMEDIATE','72h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385339/eng_general_h83uep.webp'),('C014','Business English - 14',2500000.00,'ADULT','ADVANCED','48h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385343/eng_teeen_fwpqte.webp'),('C015','English for IT - 15',3000000.00,'TEEN','INTERMEDIATE','72h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385121/eng_gram_2_fv29b9.jpg'),('C016','IELTS Foundation - 16',3000000.00,'KIDS','INTERMEDIATE','36h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385343/eng_kids4_qh4zmq.jpg'),('C017','Tiếng Anh Giao Tiếp - 17',5000000.00,'TEEN','INTERMEDIATE','48h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385343/eng_teeen_fwpqte.webp'),('C018','Business English - 18',3000000.00,'TEEN','BEGINNER','36h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385340/eng_general2_bksudo.avif'),('C019','Tiếng Anh Giao Tiếp - 19',3000000.00,'ADULT','INTERMEDIATE','72h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385340/eng_grma_wh48wz.jpg'),('C020','Tiếng Anh Giao Tiếp - 20',5000000.00,'KIDS','BEGINNER','48h','Khóa học chất lượng cao','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765385121/eng_kids1_hfnxlp.webp');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee` (
  `id` varchar(10) NOT NULL,
  `salary` decimal(10,2) NOT NULL,
  `hired_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee`
--

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES ('1000000087',8000000.00,'2025-07-19'),('1000000093',8000000.00,'2022-03-31'),('1010000016',12000000.00,'2023-11-21'),('1010000022',15000000.00,'2025-03-01'),('1010000029',12000000.00,'2024-11-28'),('1010000041',20000000.00,'2022-08-09'),('1010000053',15000000.00,'2022-01-09'),('1010000063',12000000.00,'2021-04-11'),('1010000065',8000000.00,'2024-05-15'),('1010000071',12000000.00,'2022-12-13'),('1010000080',8000000.00,'2023-02-10'),('1010000083',20000000.00,'2024-04-27'),('1010000110',12000000.00,'2021-12-24'),('1010000111',8000000.00,'2025-05-14'),('1010000134',20000000.00,'2025-03-09'),('1010000135',20000000.00,'2022-06-16'),('1010000142',8000000.00,'2021-06-20'),('1020000003',12000000.00,'2022-02-23'),('1020000006',12000000.00,'2023-12-23'),('1020000008',15000000.00,'2021-02-13'),('1020000045',15000000.00,'2023-06-04'),('1020000061',8000000.00,'2022-06-10'),('1020000086',12000000.00,'2025-10-01'),('1020000091',20000000.00,'2022-09-13'),('1020000106',20000000.00,'2024-01-23'),('1020000129',15000000.00,'2024-04-22'),('1020000131',20000000.00,'2023-06-15');
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `enrollment`
--

DROP TABLE IF EXISTS `enrollment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enrollment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `register_date` date NOT NULL,
  `status` enum('PENDING','APPROVED','REJECTED') NOT NULL,
  `student_id` varchar(10) NOT NULL,
  `class_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `student_id` (`student_id`),
  KEY `class_id` (`class_id`),
  CONSTRAINT `enrollment_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`),
  CONSTRAINT `enrollment_ibfk_2` FOREIGN KEY (`class_id`) REFERENCES `classroom` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `enrollment`
--

LOCK TABLES `enrollment` WRITE;
/*!40000 ALTER TABLE `enrollment` DISABLE KEYS */;
INSERT INTO `enrollment` VALUES (1,'2025-08-10','REJECTED','1030000001','CL039'),(2,'2025-02-02','PENDING','1030000001','CL033'),(3,'2025-04-12','REJECTED','1030000002','CL038'),(4,'2025-03-12','APPROVED','1030000002','CL046'),(5,'2025-02-01','APPROVED','1030000004','CL025'),(6,'2025-10-31','APPROVED','1030000005','CL037'),(7,'2025-09-29','PENDING','1030000005','CL020'),(8,'2025-03-17','APPROVED','1030000007','CL032'),(9,'2025-07-09','APPROVED','1030000007','CL037'),(10,'2025-02-13','PENDING','1030000009','CL015'),(11,'2025-07-04','REJECTED','1030000009','CL033'),(12,'2025-09-07','REJECTED','1030000010','CL037'),(13,'2025-09-09','PENDING','1030000011','CL043'),(14,'2025-07-27','PENDING','1030000012','CL017'),(15,'2025-01-21','APPROVED','1030000013','CL039'),(16,'2025-11-20','PENDING','1030000014','CL014'),(17,'2025-12-01','PENDING','1030000015','CL026'),(18,'2025-05-30','REJECTED','1030000017','CL032'),(19,'2025-06-12','REJECTED','1030000018','CL011'),(20,'2025-02-25','APPROVED','1030000018','CL003'),(21,'2025-09-02','PENDING','1030000019','CL038'),(22,'2025-02-16','REJECTED','1030000019','CL027'),(23,'2025-07-29','APPROVED','1030000020','CL031'),(24,'2025-04-26','REJECTED','1030000021','CL022'),(25,'2025-07-31','PENDING','1030000021','CL042'),(26,'2025-03-14','REJECTED','1030000023','CL021'),(27,'2025-09-09','PENDING','1030000023','CL008'),(28,'2025-10-15','APPROVED','1030000024','CL037'),(29,'2025-01-11','PENDING','1030000024','CL013'),(30,'2025-07-06','REJECTED','1030000025','CL021'),(31,'2025-06-18','APPROVED','1030000025','CL001'),(32,'2025-11-24','REJECTED','1030000026','CL023'),(33,'2025-02-27','APPROVED','1030000026','CL020'),(34,'2025-04-01','REJECTED','1030000027','CL003'),(35,'2025-05-08','PENDING','1030000027','CL004'),(36,'2025-03-24','APPROVED','1030000028','CL023'),(37,'2025-06-24','PENDING','1030000030','CL001'),(38,'2025-02-24','APPROVED','1030000031','CL043'),(39,'2025-04-24','APPROVED','1030000032','CL046'),(40,'2025-10-31','APPROVED','1030000032','CL038'),(41,'2025-05-14','PENDING','1030000033','CL003'),(42,'2025-04-09','PENDING','1030000034','CL045'),(43,'2025-09-17','REJECTED','1030000034','CL022'),(44,'2024-12-16','APPROVED','1030000035','CL030'),(45,'2024-12-24','PENDING','1030000036','CL026'),(46,'2025-02-20','PENDING','1030000036','CL044'),(47,'2025-02-22','REJECTED','1030000037','CL043'),(48,'2025-07-30','PENDING','1030000038','CL049'),(49,'2025-10-26','REJECTED','1030000039','CL016'),(50,'2025-02-09','APPROVED','1030000039','CL022'),(51,'2025-11-01','APPROVED','1030000040','CL027'),(52,'2025-07-12','APPROVED','1030000042','CL030'),(53,'2025-06-03','PENDING','1030000043','CL045'),(54,'2025-01-08','PENDING','1030000044','CL050'),(55,'2025-03-15','APPROVED','1030000046','CL001'),(56,'2025-06-20','APPROVED','1030000046','CL034'),(57,'2025-03-29','PENDING','1030000047','CL041'),(58,'2025-09-01','APPROVED','1030000048','CL044'),(59,'2025-06-14','REJECTED','1030000048','CL028'),(60,'2025-05-20','REJECTED','1030000049','CL016'),(61,'2025-10-20','APPROVED','1030000050','CL041'),(62,'2025-04-09','REJECTED','1030000050','CL035'),(63,'2025-11-02','REJECTED','1030000051','CL038'),(64,'2025-08-26','PENDING','1030000051','CL030'),(65,'2025-09-22','PENDING','1030000052','CL003'),(66,'2025-12-06','PENDING','1030000052','CL038'),(67,'2025-09-05','REJECTED','1030000054','CL009'),(68,'2025-11-12','REJECTED','1030000054','CL029'),(69,'2025-09-04','REJECTED','1030000055','CL001'),(70,'2025-05-06','REJECTED','1030000055','CL032'),(71,'2024-12-29','PENDING','1030000056','CL039'),(72,'2025-11-08','APPROVED','1030000056','CL041'),(73,'2025-11-28','APPROVED','1030000057','CL048'),(74,'2025-01-21','REJECTED','1030000058','CL015'),(75,'2025-11-19','REJECTED','1030000058','CL025'),(76,'2024-12-30','APPROVED','1030000059','CL010'),(77,'2025-04-16','APPROVED','1030000059','CL003'),(78,'2025-02-08','APPROVED','1030000060','CL020'),(79,'2025-09-30','REJECTED','1030000060','CL043'),(80,'2025-03-21','REJECTED','1030000062','CL012'),(81,'2025-08-03','PENDING','1030000064','CL004'),(82,'2025-09-13','PENDING','1030000066','CL028'),(83,'2025-07-13','REJECTED','1030000067','CL005'),(84,'2025-05-27','REJECTED','1030000067','CL023'),(85,'2025-04-06','APPROVED','1030000068','CL037'),(86,'2025-07-08','PENDING','1030000068','CL016'),(87,'2025-11-22','PENDING','1030000069','CL036'),(88,'2025-05-18','PENDING','1030000070','CL011'),(89,'2025-11-04','REJECTED','1030000072','CL024'),(90,'2025-11-28','REJECTED','1030000072','CL049'),(91,'2025-06-13','REJECTED','1030000073','CL018'),(92,'2025-05-02','REJECTED','1030000074','CL032'),(93,'2025-03-03','APPROVED','1030000074','CL022'),(94,'2025-08-27','APPROVED','1030000075','CL020'),(95,'2025-01-11','REJECTED','1030000076','CL042'),(96,'2025-09-16','PENDING','1030000077','CL039'),(97,'2025-01-08','PENDING','1030000077','CL041'),(98,'2025-10-10','PENDING','1030000078','CL002'),(99,'2025-08-08','REJECTED','1030000078','CL027'),(100,'2025-01-12','REJECTED','1030000079','CL034'),(101,'2025-06-22','PENDING','1030000081','CL023'),(102,'2024-12-14','PENDING','1030000082','CL027'),(103,'2025-11-04','REJECTED','1030000082','CL043'),(104,'2025-08-21','REJECTED','1030000084','CL034'),(105,'2025-07-22','APPROVED','1030000085','CL031'),(106,'2025-06-25','PENDING','1030000085','CL024'),(107,'2025-04-15','APPROVED','1030000088','CL032'),(108,'2025-09-18','APPROVED','1030000088','CL031'),(109,'2025-10-21','APPROVED','1030000089','CL035'),(110,'2025-07-27','APPROVED','1030000089','CL049'),(111,'2025-01-14','PENDING','1030000090','CL016'),(112,'2025-11-22','PENDING','1030000090','CL014'),(113,'2025-07-14','PENDING','1030000092','CL046'),(114,'2025-03-09','PENDING','1030000094','CL045'),(115,'2024-12-15','PENDING','1030000094','CL023'),(116,'2024-12-24','REJECTED','1030000095','CL014'),(117,'2025-10-10','APPROVED','1030000095','CL020'),(118,'2025-01-14','REJECTED','1030000096','CL027'),(119,'2025-10-23','APPROVED','1030000096','CL026'),(120,'2025-12-05','APPROVED','1030000097','CL030'),(121,'2025-09-17','APPROVED','1030000098','CL037'),(122,'2025-04-08','REJECTED','1030000098','CL047'),(123,'2025-01-12','PENDING','1030000099','CL020'),(124,'2025-10-20','REJECTED','1030000099','CL047'),(125,'2025-07-24','PENDING','1030000100','CL032'),(126,'2025-11-10','APPROVED','1030000100','CL027'),(127,'2025-05-09','REJECTED','1030000101','CL016'),(128,'2025-09-09','REJECTED','1030000102','CL021'),(129,'2025-01-26','REJECTED','1030000103','CL019'),(130,'2025-10-03','REJECTED','1030000104','CL003'),(131,'2025-11-19','PENDING','1030000105','CL035'),(132,'2025-07-19','PENDING','1030000107','CL011'),(133,'2025-12-08','REJECTED','1030000107','CL041'),(134,'2025-12-03','APPROVED','1030000108','CL014'),(135,'2025-12-01','PENDING','1030000109','CL012'),(136,'2025-08-02','PENDING','1030000112','CL001'),(137,'2025-07-02','REJECTED','1030000113','CL045'),(138,'2025-11-08','APPROVED','1030000113','CL037'),(139,'2025-11-15','PENDING','1030000114','CL007'),(140,'2025-02-22','REJECTED','1030000114','CL025'),(141,'2025-03-25','PENDING','1030000115','CL003'),(142,'2025-04-01','REJECTED','1030000116','CL047'),(143,'2025-02-07','PENDING','1030000117','CL004'),(144,'2025-11-25','REJECTED','1030000118','CL024'),(145,'2025-02-17','PENDING','1030000118','CL015'),(146,'2025-07-25','APPROVED','1030000119','CL046'),(147,'2025-03-05','REJECTED','1030000120','CL045'),(148,'2025-01-30','REJECTED','1030000121','CL030'),(149,'2025-01-27','REJECTED','1030000122','CL003'),(150,'2025-11-13','REJECTED','1030000122','CL020'),(151,'2025-03-06','REJECTED','1030000123','CL041'),(152,'2025-03-18','APPROVED','1030000123','CL035'),(153,'2025-06-18','APPROVED','1030000124','CL025'),(154,'2025-10-10','REJECTED','1030000124','CL024'),(155,'2025-04-04','APPROVED','1030000125','CL012'),(156,'2025-02-02','PENDING','1030000125','CL047'),(157,'2025-09-19','REJECTED','1030000126','CL029'),(158,'2025-08-04','APPROVED','1030000127','CL020'),(159,'2025-03-23','APPROVED','1030000128','CL029'),(160,'2025-02-25','PENDING','1030000128','CL048'),(161,'2025-01-07','REJECTED','1030000130','CL040'),(162,'2025-01-29','REJECTED','1030000132','CL030'),(163,'2025-11-21','PENDING','1030000133','CL025'),(164,'2025-10-31','PENDING','1030000133','CL009'),(165,'2025-08-22','PENDING','1030000136','CL028'),(166,'2025-05-15','APPROVED','1030000137','CL050'),(167,'2025-02-16','APPROVED','1030000138','CL014'),(168,'2025-02-23','PENDING','1030000138','CL021'),(169,'2025-11-11','REJECTED','1030000139','CL003'),(170,'2025-07-24','PENDING','1030000139','CL035'),(171,'2024-12-14','REJECTED','1030000140','CL024'),(172,'2025-04-23','PENDING','1030000140','CL005'),(173,'2025-07-04','PENDING','1030000141','CL001'),(174,'2025-08-20','APPROVED','1030000141','CL016'),(175,'2025-06-12','REJECTED','1030000143','CL011'),(176,'2025-08-28','APPROVED','1030000143','CL033'),(177,'2025-01-26','REJECTED','1030000144','CL047'),(178,'2025-09-27','APPROVED','1030000144','CL026'),(179,'2025-10-20','APPROVED','1030000145','CL035'),(180,'2025-09-21','APPROVED','1030000146','CL016'),(181,'2025-03-23','PENDING','1030000147','CL043'),(205,'2025-12-14','APPROVED','1031188073','CL037'),(209,'2025-12-14','APPROVED','1036227247','CL045'),(210,'2025-12-14','APPROVED','1036227247','CL033'),(211,'2025-12-14','APPROVED','1031188073','CL042');
/*!40000 ALTER TABLE `enrollment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grade_component`
--

DROP TABLE IF EXISTS `grade_component`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grade_component` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `weight` double NOT NULL,
  `course_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `grade_component_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grade_component`
--

LOCK TABLES `grade_component` WRITE;
/*!40000 ALTER TABLE `grade_component` DISABLE KEYS */;
INSERT INTO `grade_component` VALUES (1,'Mid-term',0.4,'C001'),(2,'Final-term',0.6,'C001'),(3,'Mid-term',0.4,'C002'),(4,'Final-term',0.6,'C002'),(5,'Mid-term',0.4,'C003'),(6,'Final-term',0.6,'C003'),(7,'Mid-term',0.4,'C004'),(8,'Final-term',0.6,'C004'),(9,'Mid-term',0.4,'C005'),(10,'Final-term',0.6,'C005'),(11,'Mid-term',0.4,'C006'),(12,'Final-term',0.6,'C006'),(13,'Mid-term',0.4,'C007'),(14,'Final-term',0.6,'C007'),(15,'Mid-term',0.4,'C008'),(16,'Final-term',0.6,'C008'),(17,'Mid-term',0.4,'C009'),(18,'Final-term',0.6,'C009'),(19,'Mid-term',0.4,'C010'),(20,'Final-term',0.6,'C010'),(21,'Mid-term',0.4,'C011'),(22,'Final-term',0.6,'C011'),(23,'Mid-term',0.4,'C012'),(24,'Final-term',0.6,'C012'),(25,'Mid-term',0.4,'C013'),(26,'Final-term',0.6,'C013'),(27,'Mid-term',0.4,'C014'),(28,'Final-term',0.6,'C014'),(29,'Mid-term',0.4,'C015'),(30,'Final-term',0.6,'C015'),(31,'Mid-term',0.4,'C016'),(32,'Final-term',0.6,'C016'),(33,'Mid-term',0.4,'C017'),(34,'Final-term',0.6,'C017'),(35,'Mid-term',0.4,'C018'),(36,'Final-term',0.6,'C018'),(37,'Mid-term',0.4,'C019'),(38,'Final-term',0.6,'C019'),(39,'Mid-term',0.4,'C020'),(40,'Final-term',0.6,'C020');
/*!40000 ALTER TABLE `grade_component` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedule_detail`
--

DROP TABLE IF EXISTS `schedule_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schedule_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day` enum('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY','SUNDAY') NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `class_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `class_id` (`class_id`),
  CONSTRAINT `schedule_detail_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `classroom` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedule_detail`
--

LOCK TABLES `schedule_detail` WRITE;
/*!40000 ALTER TABLE `schedule_detail` DISABLE KEYS */;
INSERT INTO `schedule_detail` VALUES (1,'SATURDAY','07:30:00','09:00:00','CL001'),(2,'WEDNESDAY','07:30:00','09:00:00','CL001'),(3,'THURSDAY','15:30:00','17:00:00','CL002'),(4,'SATURDAY','15:30:00','17:00:00','CL002'),(5,'TUESDAY','09:30:00','11:00:00','CL003'),(6,'THURSDAY','09:30:00','11:00:00','CL003'),(7,'SUNDAY','18:00:00','19:30:00','CL004'),(8,'FRIDAY','18:00:00','19:30:00','CL004'),(9,'TUESDAY','09:30:00','11:00:00','CL005'),(10,'SUNDAY','09:30:00','11:00:00','CL005'),(11,'THURSDAY','09:30:00','11:00:00','CL006'),(12,'SUNDAY','09:30:00','11:00:00','CL006'),(13,'TUESDAY','13:30:00','15:00:00','CL007'),(14,'SUNDAY','13:30:00','15:00:00','CL007'),(15,'TUESDAY','09:30:00','11:00:00','CL008'),(16,'SATURDAY','09:30:00','11:00:00','CL008'),(17,'SUNDAY','13:30:00','15:00:00','CL009'),(18,'THURSDAY','13:30:00','15:00:00','CL009'),(19,'THURSDAY','18:00:00','19:30:00','CL010'),(20,'SATURDAY','18:00:00','19:30:00','CL010'),(21,'SUNDAY','18:00:00','19:30:00','CL011'),(22,'MONDAY','18:00:00','19:30:00','CL011'),(23,'WEDNESDAY','07:30:00','09:00:00','CL012'),(24,'SATURDAY','07:30:00','09:00:00','CL012'),(25,'WEDNESDAY','17:45:00','19:15:00','CL013'),(26,'THURSDAY','17:45:00','19:15:00','CL013'),(27,'SUNDAY','13:30:00','15:00:00','CL014'),(28,'MONDAY','13:30:00','15:00:00','CL014'),(29,'TUESDAY','15:30:00','17:00:00','CL015'),(30,'SATURDAY','15:30:00','17:00:00','CL015'),(31,'MONDAY','07:30:00','09:00:00','CL016'),(32,'WEDNESDAY','07:30:00','09:00:00','CL016'),(33,'MONDAY','17:45:00','19:15:00','CL017'),(34,'SUNDAY','17:45:00','19:15:00','CL017'),(35,'WEDNESDAY','07:30:00','09:00:00','CL018'),(36,'TUESDAY','07:30:00','09:00:00','CL018'),(37,'FRIDAY','15:30:00','17:00:00','CL019'),(38,'WEDNESDAY','15:30:00','17:00:00','CL019'),(39,'THURSDAY','15:30:00','17:00:00','CL020'),(40,'WEDNESDAY','15:30:00','17:00:00','CL020'),(41,'TUESDAY','07:30:00','09:00:00','CL021'),(42,'FRIDAY','07:30:00','09:00:00','CL021'),(43,'SATURDAY','17:45:00','19:15:00','CL022'),(44,'THURSDAY','17:45:00','19:15:00','CL022'),(45,'TUESDAY','13:30:00','15:00:00','CL023'),(46,'MONDAY','13:30:00','15:00:00','CL023'),(47,'TUESDAY','17:45:00','19:15:00','CL024'),(48,'MONDAY','17:45:00','19:15:00','CL024'),(49,'TUESDAY','19:45:00','21:15:00','CL025'),(50,'MONDAY','19:45:00','21:15:00','CL025'),(51,'SATURDAY','19:45:00','21:15:00','CL026'),(52,'FRIDAY','19:45:00','21:15:00','CL026'),(53,'WEDNESDAY','09:30:00','11:00:00','CL027'),(54,'MONDAY','09:30:00','11:00:00','CL027'),(55,'FRIDAY','15:30:00','17:00:00','CL028'),(56,'THURSDAY','15:30:00','17:00:00','CL028'),(57,'SATURDAY','07:30:00','09:00:00','CL029'),(58,'MONDAY','07:30:00','09:00:00','CL029'),(59,'THURSDAY','15:30:00','17:00:00','CL030'),(60,'SUNDAY','15:30:00','17:00:00','CL030'),(61,'SUNDAY','15:30:00','17:00:00','CL031'),(62,'THURSDAY','15:30:00','17:00:00','CL031'),(63,'SUNDAY','13:30:00','15:00:00','CL032'),(64,'THURSDAY','13:30:00','15:00:00','CL032'),(65,'FRIDAY','19:45:00','21:15:00','CL033'),(66,'SUNDAY','19:45:00','21:15:00','CL033'),(67,'MONDAY','17:45:00','19:15:00','CL034'),(68,'FRIDAY','17:45:00','19:15:00','CL034'),(69,'TUESDAY','19:45:00','21:15:00','CL035'),(70,'FRIDAY','19:45:00','21:15:00','CL035'),(71,'TUESDAY','07:30:00','09:00:00','CL036'),(72,'FRIDAY','07:30:00','09:00:00','CL036'),(73,'MONDAY','13:30:00','15:00:00','CL037'),(74,'FRIDAY','13:30:00','15:00:00','CL037'),(75,'MONDAY','09:30:00','11:00:00','CL038'),(76,'SATURDAY','09:30:00','11:00:00','CL038'),(77,'FRIDAY','17:45:00','19:15:00','CL039'),(78,'SATURDAY','17:45:00','19:15:00','CL039'),(79,'THURSDAY','19:45:00','21:15:00','CL040'),(80,'FRIDAY','19:45:00','21:15:00','CL040'),(81,'TUESDAY','17:45:00','19:15:00','CL041'),(82,'SUNDAY','17:45:00','19:15:00','CL041'),(83,'THURSDAY','18:00:00','19:30:00','CL042'),(84,'SUNDAY','18:00:00','19:30:00','CL042'),(85,'THURSDAY','09:30:00','11:00:00','CL043'),(86,'SUNDAY','09:30:00','11:00:00','CL043'),(87,'THURSDAY','15:30:00','17:00:00','CL044'),(88,'TUESDAY','15:30:00','17:00:00','CL044'),(89,'SUNDAY','07:30:00','09:00:00','CL045'),(90,'SATURDAY','07:30:00','09:00:00','CL045'),(91,'TUESDAY','07:30:00','09:00:00','CL046'),(92,'FRIDAY','07:30:00','09:00:00','CL046'),(93,'MONDAY','09:30:00','11:00:00','CL047'),(94,'THURSDAY','09:30:00','11:00:00','CL047'),(95,'SATURDAY','09:30:00','11:00:00','CL048'),(96,'THURSDAY','09:30:00','11:00:00','CL048'),(97,'THURSDAY','13:30:00','15:00:00','CL049'),(98,'WEDNESDAY','13:30:00','15:00:00','CL049'),(99,'MONDAY','17:45:00','19:15:00','CL050'),(100,'TUESDAY','17:45:00','19:15:00','CL050');
/*!40000 ALTER TABLE `schedule_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `score`
--

DROP TABLE IF EXISTS `score`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `score` double NOT NULL,
  `enrollment_id` int NOT NULL,
  `grade_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `enrollment_id` (`enrollment_id`),
  KEY `grade_id` (`grade_id`),
  CONSTRAINT `score_ibfk_1` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollment` (`id`),
  CONSTRAINT `score_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grade_component` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `score`
--

LOCK TABLES `score` WRITE;
/*!40000 ALTER TABLE `score` DISABLE KEYS */;
INSERT INTO `score` VALUES (1,6.5,4,11),(2,8,4,12),(3,8.5,5,21),(4,6.1,5,22),(5,5.5,6,3),(6,6.8,6,4),(7,9.1,8,29),(8,7.4,8,30),(9,7.6,9,3),(10,8,9,4),(11,5.7,15,15),(12,5.3,15,16),(13,5.7,20,37),(14,8.8,20,38),(15,6.4,23,15),(16,6.8,23,16),(17,8,28,3),(18,8.7,28,4),(19,10,31,19),(20,9.5,31,20),(21,7.5,33,17),(22,6.3,33,18),(23,9.7,36,9),(24,8.6,36,10),(25,8.3,38,35),(26,7.2,38,36),(27,6.8,39,11),(28,9.8,39,12),(29,6.3,40,37),(30,9.7,40,38),(31,5.2,44,33),(32,5.9,44,34),(33,8.1,50,9),(34,8.6,50,10),(35,6.3,51,3),(36,8.6,51,4),(37,9.9,52,33),(38,5,52,34),(39,6.2,55,19),(40,6.5,55,20),(41,7.8,56,7),(42,9.9,56,8),(43,6.5,58,29),(44,6.5,58,30),(45,5.9,61,39),(46,9.6,61,40),(47,7.5,72,39),(48,9.8,72,40),(49,9.7,73,11),(50,8.8,73,12),(51,6.4,76,39),(52,7.5,76,40),(53,8.6,77,37),(54,5.9,77,38),(55,6.5,78,17),(56,7.2,78,18),(57,6.1,85,3),(58,7.3,85,4),(59,7.4,93,9),(60,5.1,93,10),(61,5.8,94,17),(62,8,94,18),(63,7.9,105,15),(64,7.6,105,16),(65,5.6,107,29),(66,9.6,107,30),(67,7.6,108,15),(68,8.2,108,16),(69,5,109,9),(70,8.4,109,10),(71,8.1,110,9),(72,8.3,110,10),(73,6.3,117,17),(74,8.5,117,18),(75,9,119,27),(76,5.9,119,28),(77,5.6,120,33),(78,7.9,120,34),(79,7.1,121,3),(80,6.1,121,4),(81,7,126,3),(82,6.2,126,4),(83,9.9,134,11),(84,8.7,134,12),(85,5.1,138,3),(86,8.8,138,4),(87,5,146,11),(88,7.7,146,12),(89,7.3,152,9),(90,9.1,152,10),(91,9.5,153,21),(92,7.7,153,22),(93,5.9,155,33),(94,9.7,155,34),(95,7.2,158,17),(96,9.2,158,18),(97,7.7,159,29),(98,9.8,159,30),(99,7.7,166,21),(100,5.5,166,22),(101,8.5,167,11),(102,5.1,167,12),(103,9.7,174,9),(104,6.6,174,10),(105,8.4,176,7),(106,10,176,8),(107,5.8,178,27),(108,7.3,178,28),(109,9.4,179,9),(110,9.3,179,10),(111,9.4,180,9),(112,6.3,180,10);
/*!40000 ALTER TABLE `score` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student` (
  `id` varchar(10) NOT NULL,
  `emergency_contact` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `student_ibfk_1` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student`
--

LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES ('1030000001','0972854179'),('1030000002','0957574527'),('1030000004','0955790768'),('1030000005','0939322888'),('1030000007','0994047564'),('1030000009','0905962385'),('1030000010','0966393652'),('1030000011','0989757160'),('1030000012','0976838896'),('1030000013','0950422506'),('1030000014','0949125016'),('1030000015','0984284942'),('1030000017','0915973439'),('1030000018','0963633296'),('1030000019','0963346831'),('1030000020','0976115297'),('1030000021','0998552834'),('1030000023','0969385541'),('1030000024','0960615381'),('1030000025','0918643541'),('1030000026','0987235458'),('1030000027','0939198819'),('1030000028','0975744977'),('1030000030','0978615463'),('1030000031','0968385326'),('1030000032','0942382158'),('1030000033','0937060406'),('1030000034','0972918994'),('1030000035','0919939853'),('1030000036','0959132179'),('1030000037','0986262807'),('1030000038','0902016848'),('1030000039','0954101010'),('1030000040','0907924301'),('1030000042','0923653490'),('1030000043','0905338723'),('1030000044','0916469805'),('1030000046','0926643745'),('1030000047','0917552035'),('1030000048','0961043148'),('1030000049','0940325639'),('1030000050','0921985124'),('1030000051','0970518929'),('1030000052','0960287238'),('1030000054','0949743455'),('1030000055','0954382081'),('1030000056','0987618624'),('1030000057','0977409022'),('1030000058','0936114279'),('1030000059','0961480784'),('1030000060','0978566709'),('1030000062','0972903851'),('1030000064','0983430674'),('1030000066','0970535004'),('1030000067','0971238211'),('1030000068','0910767574'),('1030000069','0925864264'),('1030000070','0904247743'),('1030000072','0905719232'),('1030000073','0962816219'),('1030000074','0984061827'),('1030000075','0946139081'),('1030000076','0953162302'),('1030000077','0983172253'),('1030000078','0958304457'),('1030000079','0946126293'),('1030000081','0973256832'),('1030000082','0982466640'),('1030000084','0929942844'),('1030000085','0985515980'),('1030000088','0996341565'),('1030000089','0986512040'),('1030000090','0921947659'),('1030000092','0995861017'),('1030000094','0936271180'),('1030000095','0907566586'),('1030000096','0956985809'),('1030000097','0906696259'),('1030000098','0914400690'),('1030000099','0947023278'),('1030000100','0924994583'),('1030000101','0972193392'),('1030000102','0932493261'),('1030000103','0987762373'),('1030000104','0903621056'),('1030000105','0950904618'),('1030000107','0977181816'),('1030000108','0986488588'),('1030000109','0998944044'),('1030000112','0963403900'),('1030000113','0913523645'),('1030000114','0971269447'),('1030000115','0929723223'),('1030000116','0933574013'),('1030000117','0918161518'),('1030000118','0904744530'),('1030000119','0963509921'),('1030000120','0907549144'),('1030000121','0976958935'),('1030000122','0902898369'),('1030000123','0996736058'),('1030000124','0968937754'),('1030000125','0952952600'),('1030000126','0951961178'),('1030000127','0932229702'),('1030000128','0916710012'),('1030000130','0989402280'),('1030000132','0992165024'),('1030000133','0952942280'),('1030000136','0969741632'),('1030000137','0976978731'),('1030000138','0988151469'),('1030000139','0941748015'),('1030000140','0965592755'),('1030000141','0966607097'),('1030000143','0930777378'),('1030000144','0914909000'),('1030000145','0990016907'),('1030000146','0997953732'),('1030000147','0953718467'),('1031188073',NULL),('1032545918',NULL),('1036227247',NULL),('1039259734',NULL);
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teacher`
--

DROP TABLE IF EXISTS `teacher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teacher` (
  `id` varchar(10) NOT NULL,
  `major` varchar(100) DEFAULT NULL,
  `degree` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `teacher_ibfk_1` FOREIGN KEY (`id`) REFERENCES `employee` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teacher`
--

LOCK TABLES `teacher` WRITE;
/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;
INSERT INTO `teacher` VALUES ('1010000016','Linguistics','Thạc sĩ'),('1010000022','Sư phạm Anh','Thạc sĩ'),('1010000029','Linguistics','Chứng chỉ quốc tế'),('1010000041','Ngôn ngữ Anh','Chứng chỉ quốc tế'),('1010000053','TESOL','Thạc sĩ'),('1010000063','Sư phạm Anh','Thạc sĩ'),('1010000065','Ngôn ngữ Anh','Thạc sĩ'),('1010000071','TESOL','Cử nhân'),('1010000080','Ngôn ngữ Anh','Cử nhân'),('1010000083','Linguistics','Thạc sĩ'),('1010000110','Linguistics','Chứng chỉ quốc tế'),('1010000111','Ngôn ngữ Anh','Cử nhân'),('1010000134','TESOL','Thạc sĩ'),('1010000135','TESOL','Cử nhân'),('1010000142','TESOL','Thạc sĩ');
/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` varchar(10) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(100) NOT NULL,
  `gender` int NOT NULL,
  `phone_number` varchar(10) DEFAULT NULL,
  `dob` date NOT NULL,
  `address` varchar(250) DEFAULT NULL,
  `avatar` varchar(500) DEFAULT 'https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png',
  `username` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  `status` tinyint DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('1000000087','Tú Bảo Bùi','1000000087@center.com',1,'0902449454','1978-04-18','37 Hoàng Ngõ, JaneXã, 489857','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1000000087','123',1,'admin'),('1000000093','Tùng Trí Bùi','1000000093@center.com',1,'0907018541','2003-06-09','656 Mai Khu, JaneThành phố, 816635','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1000000093','123',1,'admin'),('1010000016','Khoa Phạm','1010000016@center.com',1,'0999097069','1999-08-31','761 Jane Dãy, Huyện JohnPhường, 646167','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000016','123',1,'teacher'),('1010000022','Quý cô Hương Đặng','1010000022@center.com',0,'0983318538','1977-06-05','JohnThị xã, 11 Jane Làng, 224686','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000022','123',1,'teacher'),('1010000029','Nhật Thị Trần','1010000029@center.com',1,'0935959126','1985-12-17','992 Trần Tổ, Thị xã JaneThành phố, 163083','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000029','202cb962ac59075b964b07152d234b70',1,'teacher'),('1010000041','Hạnh Văn Trần','1010000041@center.com',1,'0958629721','1979-02-16','468 Dương Ngõ, JaneHuyện, 891908','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000041','123',1,'teacher'),('1010000053','Lâm Trần','1010000053@center.com',1,'0935030247','1998-01-19','791 Mai Số, Quận JohnThị xã, 330739','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000053','123',1,'teacher'),('1010000063','Chị An Lê','1010000063@center.com',1,'0951252078','1995-03-19','1 Hoàng Ngõ, JohnXã, 731211','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000063','123',1,'teacher'),('1010000065','Thành Đức Dương','1010000065@center.com',0,'0912747721','2002-01-26','4 Nguyễn Khu, Thị xã JanePhường, 225845','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000065','123',1,'teacher'),('1010000071','Chị Hải Đặng','1010000071@center.com',1,'0977529058','1991-04-20','3 Jane Hẻm, JohnXã, 569950','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000071','123',1,'teacher'),('1010000080','Hải Thị Vũ','1010000080@center.com',0,'0947869836','1997-01-17','2 Trần Số, Thị xã JaneXã, 750258','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000080','123',1,'teacher'),('1010000083','Ông Hoàng Mai','1010000083@center.com',1,'0988700083','1991-03-22','652 John Hẻm, Quận JaneThành phố, 606374','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000083','123',1,'teacher'),('1010000110','Anh Huy Phạm','1010000110@center.com',1,'0930617308','1978-07-21','745 Hoàng Hẻm, Quận JaneXã, 761550','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000110','123',1,'teacher'),('1010000111','Lan Đặng','1010000111@center.com',0,'0922719333','1971-03-09','63 Dương Làng, Thị xã JohnHuyện, 896750','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000111','123',1,'teacher'),('1010000134','Ánh Phạm','1010000134@center.com',1,'0932697042','2001-11-27','5 Nguyễn Đường, Quận JaneQuận, 512140','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000134','123',1,'teacher'),('1010000135','Quang Quang Hoàng','1010000135@center.com',0,'0969146182','1984-08-19','098 Đặng Làng, JohnHuyện, 293436','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000135','123',1,'teacher'),('1010000142','Hải Văn Nguyễn','1010000142@center.com',0,'0941725609','1987-10-01','422 John Tổ, Huyện JohnHuyện, 706455','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1010000142','123',1,'teacher'),('1020000003','Nhật Bùi','1020000003@center.com',0,'0914289594','1994-02-07','7 Phạm Tổ, Quận JohnQuận, 942368','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000003','123',1,'cashier'),('1020000006','Chị An Trần','1020000006@center.com',0,'0927933876','2000-07-01','8 Mai Làng, Thị xã JaneThị xã, 616586','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000006','123',1,'cashier'),('1020000008','Chị An Hoàng','1020000008@center.com',1,'0977628952','1991-07-08','139 Jane Ngõ, JohnThành phố, 734917','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000008','123',1,'cashier'),('1020000045','Ông Trọng Phạm','1020000045@center.com',0,'0901752568','1970-10-22','811 Nguyễn Tổ, Thành phố JohnHuyện, 771480','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000045','123',1,'cashier'),('1020000061','Ngọc Phạm','1020000061@center.com',1,'0905009133','1971-06-20','056 John Dãy, JohnHuyện, 427105','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000061','123',1,'cashier'),('1020000086','Hồng Bùi','1020000086@center.com',0,'0969511826','1989-04-07','3 Jane Làng, JohnQuận, 527565','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000086','123',1,'cashier'),('1020000091','Bà Lan Lê','1020000091@center.com',0,'0949249770','1973-09-09','696 Trần Ngõ, JohnQuận, 260398','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000091','123',1,'cashier'),('1020000106','Hà Xuân Phạm','1020000106@center.com',0,'0922559993','1977-08-29','06 Jane Đường, JohnXã, 463927','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000106','123',1,'cashier'),('1020000129','Lâm Hữu Mai','1020000129@center.com',1,'0956414635','1987-11-03','801 John Số, JaneThị xã, 462066','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000129','123',1,'cashier'),('1020000131','Quang Phú Vũ','1020000131@center.com',0,'0951702045','1987-01-04','073 Đặng Dãy, JaneQuận, 598536','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1020000131','123',1,'cashier'),('1030000001','Kim Thị Vũ','1030000001@center.com',0,'0967558933','2017-05-01','59 John Khu, Thành phố JaneXã, 839426','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000001','123',1,'student'),('1030000002','Bà Hà Trần','1030000002@center.com',1,'0920578183','2011-03-04','65 Jane Dãy, JohnXã, 114723','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000002','123',1,'student'),('1030000004','Ông Vũ Đặng','1030000004@center.com',1,'0997005461','2017-03-21','JohnHuyện, 1 Mai Làng, 938260','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000004','123',1,'student'),('1030000005','Bảo Trần','1030000005@center.com',0,'0937318989','2013-01-12','23 John Khu, JohnThành phố, 811693','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000005','123',1,'student'),('1030000007','Thành Hoàng','1030000007@center.com',0,'0959259979','2003-11-11','304 John Tổ, Huyện JaneThành phố, 205494','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000007','123',1,'student'),('1030000009','Chị Yến Trần','1030000009@center.com',0,'0998224740','2016-03-29','0 Hoàng Ngõ, JohnQuận, 175467','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000009','123',1,'student'),('1030000010','Quang Bùi','1030000010@center.com',1,'0927852896','2006-01-26','916 Jane Tổ, JohnPhường, 805314','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000010','123',1,'student'),('1030000011','Cô Vi Lê','1030000011@center.com',0,'0918708012','2005-06-12','972 Jane Số, JaneThị xã, 978351','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000011','123',1,'student'),('1030000012','Hoàng Mai','1030000012@center.com',1,'0947311534','2000-05-11','08 Lê Làng, JaneXã, 401861','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000012','123',1,'student'),('1030000013','Nhiên Trí Vũ','1030000013@center.com',0,'0902677561','2013-02-20','935 John Làng, JanePhường, 806504','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000013','202cb962ac59075b964b07152d234b70',1,'student'),('1030000014','An Hữu Hoàng','1030000014@center.com',0,'0913844879','2014-03-02','714 Jane Dãy, Thành phố JaneHuyện, 427216','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000014','202cb962ac59075b964b07152d234b70',1,'student'),('1030000015','Ông Huy Phạm','1030000015@center.com',1,'0912910606','2018-08-08','Quận JohnThị xã, 03 John Ngõ, 299711','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000015','123',1,'student'),('1030000017','Bảo Vũ','1030000017@center.com',1,'0996007570','2000-07-26','4 Đặng Đường, JanePhường, 556592','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000017','123',1,'student'),('1030000018','Tùng Xuân Phạm','1030000018@center.com',0,'0956688184','2012-09-18','245 Đặng Ngõ, JohnThành phố, 382719','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000018','123',1,'student'),('1030000019','Chị Khoa Vũ','1030000019@center.com',0,'0976001315','2012-03-20','17 John Khu, Thành phố JaneThị xã, 976147','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000019','123',1,'student'),('1030000020','Khoa Bảo Trần','1030000020@center.com',0,'0957251402','2003-04-27','55 Jane Ngõ, JaneThành phố, 416568','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000020','123',1,'student'),('1030000021','Hoàng Xuân Hoàng','1030000021@center.com',0,'0912533695','2012-09-18','133 Jane Đường, Thị xã JaneThị xã, 612353','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000021','123',1,'student'),('1030000023','Hạnh Hoàng Nguyễn','1030000023@center.com',1,'0959288653','2007-04-14','765 John Dãy, Thị xã JaneXã, 619470','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000023','123',1,'student'),('1030000024','Châu Mai Bảo Phạm','1030000024@center.com',1,'0917317490','2018-05-28','555 John Khu, Thị xã JanePhường, 840685','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000024','202cb962ac59075b964b07152d234b70',1,'student'),('1030000025','Ông Vũ Mai','1030000025@center.com',1,'0906734659','2001-04-11','407 Lê Hẻm, JaneXã, 500799','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000025','123',1,'student'),('1030000026','Duyên Trần','1030000026@center.com',1,'0913284738','2017-07-24','6 Jane Số, JaneXã, 714872','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000026','123',1,'student'),('1030000027','Cô Dương Nguyễn','1030000027@center.com',1,'0963407891','2006-02-16','17 Vũ Số, JaneThành phố, 271751','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000027','123',1,'student'),('1030000028','Chị Hạnh Đặng','1030000028@center.com',1,'0957181610','2001-10-29','27 John Tổ, JohnXã, 588928','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000028','123',1,'student'),('1030000030','Tú Thế Lê','1030000030@center.com',0,'0953127067','2013-02-15','3 Jane Dãy, JohnThị xã, 473873','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000030','123',1,'student'),('1030000031','An Nguyễn','1030000031@center.com',1,'0948351697','2016-06-23','9 John Ngõ, JaneThành phố, 252767','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765438224/english-center-avatars/course_placeholder_o3bl1g.jpg','1030000031','202cb962ac59075b964b07152d234b70',1,'student'),('1030000032','Khoa Bảo Trần','1030000032@center.com',1,'0951897337','2003-07-02','20 Bùi Số, Thị xã JanePhường, 364855','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000032','123',1,'student'),('1030000033','Thành Trần','1030000033@center.com',1,'0959776560','2004-01-25','52 John Tổ, Quận JohnThành phố, 314738','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000033','123',1,'student'),('1030000034','Nhật Nguyễn','1030000034@center.com',0,'0978594631','2009-11-30','3 John Dãy, Thị xã JanePhường, 370762','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000034','123',1,'student'),('1030000035','Cô Lâm Đặng','1030000035@center.com',1,'0919374836','2011-05-03','85 John Ngõ, JohnThị xã, 254063','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000035','123',1,'student'),('1030000036','Chị Thành Mai','1030000036@center.com',1,'0935039358','2008-03-13','56 John Đường, JohnPhường, 176767','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000036','123',1,'student'),('1030000037','Quý cô Hạnh Mai','1030000037@center.com',1,'0945094415','2014-02-12','6 Đặng Ngõ, Thị xã JanePhường, 654914','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000037','123',1,'student'),('1030000038','Hồng Bùi','1030000038@center.com',0,'0906428792','2000-03-22','35 Dương Ngõ, Thành phố JaneThành phố, 685295','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000038','123',1,'student'),('1030000039','Quý cô Kim Lê','1030000039@center.com',0,'0981581997','2014-04-14','58 Jane Dãy, Thị xã JohnHuyện, 101932','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000039','123',1,'student'),('1030000040','Quý ông Nam Phạm','1030000040@center.com',0,'0953257678','2010-02-04','9 Jane Dãy, Thị xã JohnXã, 899009','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000040','123',1,'student'),('1030000042','An Trần','1030000042@center.com',1,'0930539672','2008-11-13','832 Jane Khu, JohnXã, 648468','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000042','123',1,'student'),('1030000043','Cô Hồng Mai','1030000043@center.com',0,'0910811212','2013-08-30','75 John Ngõ, Thị xã JaneXã, 590673','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000043','123',1,'student'),('1030000044','Bà Thành Dương','1030000044@center.com',1,'0913559483','2014-01-22','8 Dương Đường, JaneQuận, 881408','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000044','123',1,'student'),('1030000046','Chị Vi Hoàng','1030000046@center.com',0,'0948407022','2009-09-25','56 Jane Số, JohnThị xã, 843259','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000046','123',1,'student'),('1030000047','Bà Bảo Phạm','1030000047@center.com',1,'0999214259','2006-04-17','76 John Dãy, Thành phố JaneThành phố, 345397','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000047','123',1,'student'),('1030000048','Bảo Đặng','1030000048@center.com',1,'0910770628','2001-11-16','949 Jane Tổ, JaneThành phố, 762573','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000048','123',1,'student'),('1030000049','Khoa Mai Dương','1030000049@center.com',1,'0956577864','2008-08-08','40 John Hẻm, JohnHuyện, 786426','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000049','123',1,'student'),('1030000050','Lan Trần','1030000050@center.com',1,'0963308615','2014-06-28','3 Phạm Tổ, Thành phố JaneHuyện, 661933','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000050','123',1,'student'),('1030000051','Bác Anh Nguyễn','1030000051@center.com',0,'0976719091','2017-09-12','385 John Khu, JaneXã, 503357','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000051','123',1,'student'),('1030000052','Châu Đặng','1030000052@center.com',1,'0929107408','2008-02-07','777 Jane Dãy, JaneThành phố, 189774','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000052','123',1,'student'),('1030000054','Quang Đặng','1030000054@center.com',0,'0993152036','2014-09-25','8 Jane Dãy, JaneHuyện, 343047','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000054','123',1,'student'),('1030000055','Hương Hoàng','1030000055@center.com',1,'0925557882','2003-04-21','340 Nguyễn Ngõ, JaneThành phố, 873097','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000055','123',1,'student'),('1030000056','Quang Thế Phạm','1030000056@center.com',1,'0995011744','2008-02-09','5 Jane Dãy, JohnQuận, 949083','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000056','123',1,'student'),('1030000057','Vân Mai','1030000057@center.com',0,'0903321556','2011-02-03','622 John Làng, JohnQuận, 868145','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000057','123',1,'student'),('1030000058','Chị Kim Đặng','1030000058@center.com',0,'0930763855','2004-06-12','0 Dương Dãy, JohnQuận, 682507','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000058','123',1,'student'),('1030000059','Quý cô Nhật Dương','1030000059@center.com',1,'0959401075','2018-07-07','29 Phạm Tổ, JaneThành phố, 318799','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000059','123',1,'student'),('1030000060','Linh Phạm','1030000060@center.com',0,'0918640454','2011-08-12','52 Nguyễn Tổ, Quận JaneThành phố, 614963','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000060','123',1,'student'),('1030000062','Huy Hữu Nguyễn','1030000062@center.com',0,'0990946978','2013-11-11','916 Lê Đường, Quận JohnHuyện, 348911','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000062','123',1,'student'),('1030000064','Dũng Bùi','1030000064@center.com',0,'0905552134','2000-11-11','15 Lê Dãy, Huyện JohnPhường, 889554','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000064','123',1,'student'),('1030000066','Châu Thị Nguyễn','1030000066@center.com',1,'0992916937','2009-03-24','94 Jane Số, JohnThành phố, 693534','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000066','123',1,'student'),('1030000067','Quang Phú Lê','1030000067@center.com',1,'0972779577','2005-02-22','0 Jane Tổ, JaneHuyện, 618897','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000067','123',1,'student'),('1030000068','Khoa Bảo Lê','1030000068@center.com',0,'0957727304','1999-12-21','25 Jane Khu, Thành phố JaneHuyện, 970469','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000068','123',1,'student'),('1030000069','Chị Hà Lê','1030000069@center.com',1,'0973887020','2019-08-30','44 Nguyễn Số, JaneXã, 652877','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000069','123',1,'student'),('1030000070','Dũng Hoàng Bùi','1030000070@center.com',0,'0987120021','2004-10-04','9 Đặng Dãy, Thị xã JohnThành phố, 479817','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765637326/english-center-avatars/3d15788a759ad4ab55ab7bd773fb83e8_tbsy2y.jpg','1030000070','202cb962ac59075b964b07152d234b70',1,'student'),('1030000072','Ông Trung Lê','1030000072@center.com',1,'0915119647','2014-12-04','6 Vũ Số, JaneThành phố, 421932','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000072','123',1,'student'),('1030000073','Chi Nguyễn','1030000073@center.com',0,'0910027345','2008-06-17','66 Jane Tổ, Huyện JaneThành phố, 517430','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000073','123',1,'student'),('1030000074','Anh Hưng Trần','1030000074@center.com',1,'0919978909','2019-03-12','131 Nguyễn Tổ, Huyện JaneQuận, 901879','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000074','123',1,'student'),('1030000075','Huy Lê','1030000075@center.com',1,'0966067341','2004-12-14','0 John Hẻm, JohnPhường, 963774','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000075','123',1,'student'),('1030000076','Ánh Mai','1030000076@center.com',1,'0928138978','2013-02-10','1 John Khu, Huyện JanePhường, 843097','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000076','123',1,'student'),('1030000077','Anh Mai','1030000077@center.com',0,'0991642681','2015-06-20','Thị xã JohnThành phố, 8 Jane Ngõ, 302256','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000077','123',1,'student'),('1030000078','Anh Bảo Mai','1030000078@center.com',0,'0966885933','2005-05-11','80 Jane Đường, Thành phố JaneXã, 469434','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000078','123',1,'student'),('1030000079','Bác Thành Mai','1030000079@center.com',0,'0914635103','2012-04-03','Quận JaneThành phố, 2 Jane Làng, 146283','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000079','123',1,'student'),('1030000081','Nhiên Dương','1030000081@center.com',0,'0900545379','2013-12-17','36 Jane Ngõ, Thành phố JaneThành phố, 285689','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000081','123',1,'student'),('1030000082','Khoa Văn Đặng','1030000082@center.com',0,'0922226415','2015-06-20','10 Vũ Đường, Thành phố JaneHuyện, 203269','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000082','123',1,'student'),('1030000084','Mai Phạm','1030000084@center.com',1,'0961130762','2009-07-08','32 Dương Tổ, Thị xã JohnQuận, 712002','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000084','123',1,'student'),('1030000085','Dương Bùi','1030000085@center.com',1,'0906505925','2005-10-15','Thành phố JaneXã, 019 John Số, 925966','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000085','123',1,'student'),('1030000088','Duyên Hoàng','1030000088@center.com',1,'0992418834','2016-01-31','956 John Hẻm, JohnThị xã, 866511','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000088','123',1,'student'),('1030000089','Kim Đức Dương','1030000089@center.com',0,'0904392176','2015-08-28','62 Mai Ngõ, JaneQuận, 759139','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000089','123',1,'student'),('1030000090','Châu Thị Phạm','1030000090@center.com',0,'0968057878','2008-09-13','60 Mai Số, Thị xã JaneThị xã, 863233','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000090','123',1,'student'),('1030000092','Chị An Mai','1030000092@center.com',0,'0962412244','2004-07-19','4 Trần Số, JohnHuyện, 758480','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000092','123',1,'student'),('1030000094','Cô Khoa Hoàng','1030000094@center.com',1,'0967220099','2017-07-13','9 Jane Hẻm, JohnThành phố, 110995','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000094','123',1,'student'),('1030000095','Thành Dương','1030000095@center.com',0,'0961211563','2010-10-08','94 Phạm Hẻm, Quận JohnPhường, 990834','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000095','123',1,'student'),('1030000096','Quý cô Khoa Phạm','1030000096@center.com',0,'0959472600','2014-11-05','09 Jane Hẻm, JohnThị xã, 941318','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000096','123',1,'student'),('1030000097','Hải Hoàng','1030000097@center.com',1,'0996776077','2013-09-21','791 Mai Dãy, JaneHuyện, 289811','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000097','123',1,'student'),('1030000098','Bà Lan Vũ','1030000098@center.com',0,'0953160985','2004-10-28','69 Mai Ngõ, JaneQuận, 954035','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000098','123',1,'student'),('1030000099','Hạnh Lê','1030000099@center.com',0,'0951801788','2012-03-02','0 John Đường, Thị xã JanePhường, 823959','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000099','123',1,'student'),('1030000100','Nhật Mai','1030000100@center.com',0,'0986606761','2011-10-02','033 Vũ Khu, Thành phố JaneHuyện, 633702','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000100','123',1,'student'),('1030000101','Vũ Quang Vũ','1030000101@center.com',1,'0921287998','2019-06-16','23 Phạm Dãy, JaneThị xã, 742165','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000101','123',1,'student'),('1030000102','Cô Kim Đặng','1030000102@center.com',1,'0989929648','2016-12-15','5 Bùi Khu, JanePhường, 396857','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000102','123',1,'student'),('1030000103','Nhật Vũ','1030000103@center.com',1,'0958740071','2004-01-16','257 John Số, JaneXã, 584206','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000103','123',1,'student'),('1030000104','Quý cô Vân Vũ','1030000104@center.com',1,'0987031215','2016-06-30','756 Jane Đường, Thị xã JohnHuyện, 310031','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000104','123',1,'student'),('1030000105','Phúc Đức Lê','1030000105@center.com',0,'0990278836','2012-04-29','680 John Làng, Thị xã JohnThành phố, 645490','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000105','123',1,'student'),('1030000107','Bảo Trí Hoàng','1030000107@center.com',1,'0968251290','2017-07-12','1 Nguyễn Hẻm, Thị xã JohnXã, 792088','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000107','123',1,'student'),('1030000108','Trung Bảo Mai','1030000108@center.com',0,'0921238678','2016-12-17','7 Jane Dãy, Thị xã JaneQuận, 536435','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000108','123',1,'student'),('1030000109','Thành Trần','1030000109@center.com',1,'0987253720','2019-02-28','35 Bùi Đường, JohnXã, 524526','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000109','123',1,'student'),('1030000112','Bà Lan Mai','1030000112@center.com',1,'0972856009','2018-05-28','979 Jane Đường, Thị xã JaneXã, 866614','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000112','123',1,'student'),('1030000113','Cô Ngọc Nguyễn','1030000113@center.com',0,'0901824656','2004-07-02','1 Vũ Tổ, JohnQuận, 490739','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000113','123',1,'student'),('1030000114','Bảo Hữu Dương','1030000114@center.com',0,'0963357115','2010-09-28','231 Jane Dãy, Huyện JohnThành phố, 525866','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000114','123',1,'student'),('1030000115','Cô Ánh Bùi','1030000115@center.com',1,'0946357595','2019-11-10','3 John Dãy, JaneXã, 663297','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000115','123',1,'student'),('1030000116','Hà Hoàng','1030000116@center.com',1,'0943845282','2016-09-13','95 Trần Đường, Thành phố JaneQuận, 588376','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000116','123',1,'student'),('1030000117','Tú Hoàng','1030000117@center.com',1,'0986324537','2015-02-25','68 Phạm Khu, Thành phố JohnHuyện, 757399','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000117','123',1,'student'),('1030000118','Ông Minh Dương','1030000118@center.com',1,'0992562114','2014-09-23','692 John Ngõ, JohnThành phố, 759890','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000118','123',1,'student'),('1030000119','Anh Bùi','1030000119@center.com',1,'0962812523','2003-11-12','3 Jane Đường, Thị xã JohnPhường, 370383','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000119','123',1,'student'),('1030000120','Hoàng Phú Trần','1030000120@center.com',0,'0905690134','2019-01-12','91 John Dãy, Quận JaneThành phố, 684884','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000120','123',1,'student'),('1030000121','Chị Yến Phạm','1030000121@center.com',1,'0970058481','2013-07-07','24 Mai Làng, Thị xã JaneQuận, 390267','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000121','123',1,'student'),('1030000122','Hương Đặng','1030000122@center.com',1,'0944943590','2010-06-06','190 Trần Hẻm, JohnXã, 681616','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000122','123',1,'student'),('1030000123','Bảo Quang Bùi','1030000123@center.com',1,'0955807976','2017-01-15','197 Lê Khu, Thị xã JaneThành phố, 124017','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000123','123',1,'student'),('1030000124','Dương Vũ','1030000124@center.com',0,'0965019004','2002-07-12','84 John Hẻm, JohnThị xã, 538929','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000124','123',1,'student'),('1030000125','Nhiên Phạm','1030000125@center.com',1,'0993095888','2008-07-23','16 Lê Đường, Thị xã JaneThành phố, 350074','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000125','123',1,'student'),('1030000126','Hạnh Trần','1030000126@center.com',1,'0972836814','2006-02-24','586 John Dãy, JaneThị xã, 552465','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000126','123',1,'student'),('1030000127','Ông Phúc Mai','1030000127@center.com',1,'0932948289','2012-02-04','422 Mai Đường, Quận JanePhường, 264462','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000127','123',1,'student'),('1030000128','Chị Xuân Hoàng','1030000128@center.com',1,'0922801644','2005-08-26','0 Phạm Đường, JohnThị xã, 630085','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000128','123',1,'student'),('1030000130','Vũ Lê','1030000130@center.com',0,'0950164600','2019-11-16','081 Phạm Dãy, Huyện JohnXã, 254912','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000130','123',1,'student'),('1030000132','Quang Hữu Bùi','1030000132@center.com',0,'0932474853','2019-08-18','9 John Số, Huyện JohnXã, 247078','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000132','123',1,'student'),('1030000133','Bác Anh Bùi','1030000133@center.com',1,'0908092200','2010-03-14','3 Dương Ngõ, Quận JohnHuyện, 932471','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000133','123',1,'student'),('1030000136','Anh Trọng Hoàng','1030000136@center.com',1,'0940703123','2017-02-20','069 John Ngõ, JaneHuyện, 763684','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000136','123',1,'student'),('1030000137','Cô Linh Lê','1030000137@center.com',1,'0996318436','2010-09-10','JaneThị xã, 17 John Khu, 686076','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000137','123',1,'student'),('1030000138','Khoa Mai Bùi','1030000138@center.com',0,'0976947452','2005-05-07','191 Jane Khu, Thị xã JaneHuyện, 923264','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000138','123',1,'student'),('1030000139','Hải Đặng','1030000139@center.com',1,'0934022326','2017-04-04','090 John Số, JaneThành phố, 428507','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000139','123',1,'student'),('1030000140','Cô Nhật Bùi','1030000140@center.com',1,'0969547234','2019-08-24','360 Jane Hẻm, JaneThị xã, 973826','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000140','123',1,'student'),('1030000141','Yến Dương','1030000141@center.com',0,'0931343344','2018-05-23','3 John Dãy, JaneHuyện, 321914','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000141','123',1,'student'),('1030000143','Thành Phạm','1030000143@center.com',1,'0956753105','2008-07-28','88 John Tổ, JaneThị xã, 668547','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000143','123',1,'student'),('1030000144','Quý ông Minh Trần','1030000144@center.com',1,'0937212327','2007-05-26','5 John Hẻm, Thành phố JanePhường, 692661','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000144','123',1,'student'),('1030000145','Hải Trần','1030000145@center.com',0,'0971256904','2017-10-11','76 Hoàng Dãy, JohnXã, 139419','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000145','123',1,'student'),('1030000146','Thành Tấn Mai','1030000146@center.com',1,'0937303558','2000-03-03','15 Hoàng Làng, Thành phố JohnXã, 476120','https://res.cloudinary.com/du9oap5y2/image/upload/v1764921187/user_icon_izjcfk.png','1030000146','123',1,'student'),('1030000147','Linh Lê','1030000147@center.com',1,'0911799922','2011-07-15','03 Đặng Hẻm, Thị xã JohnThị xã, 829120','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765361778/english-center-avatars/2f49dfa3f97e24eec56d24e9d704c43b_ddw5fn.jpg','1030000147','202cb962ac59075b964b07152d234b70',1,'student'),('1031188073','Nguyễn Thanh Mẫn','dephucau@gmail.com',1,'0364341310','2005-08-03','TpHCM','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765720255/english-center-avatars/98fe1406f067647fce19a40ac18ca428_yqukqz.jpg','man','202cb962ac59075b964b07152d234b70',1,'student'),('1032545918','Lee Sang Hyeok','faker@gmail.com',1,'0364341333','1997-01-01','Seoul, Korea','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765435896/english-center-avatars/22f92c9ca40c8e37d71d5b9e3b6a902d_tyh8gc.jpg','faker','202cb962ac59075b964b07152d234b70',1,'student'),('1036227247','Kim Thư','gamerdeplao@gmail.com',0,'0353393862','2005-05-10','Phù Mỹ, Bình Định','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765703201/english-center-avatars/368013655_1327108141511366_2055704540199510668_n_g2zeed.jpg','kimthu','202cb962ac59075b964b07152d234b70',1,'student'),('1039259734','Thanh Mẫn','gamerdeplao@gmail.com',1,'0364341927','2005-01-01','binh duong','https://res.cloudinary.com/dmhnfoc9i/image/upload/v1765719218/english-center-avatars/3d15788a759ad4ab55ab7bd773fb83e8_kuqhvl.jpg','man123','202cb962ac59075b964b07152d234b70',1,'student');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-12-15 20:25:12