Final_pj.sql

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 14, 2021 at 06:23 AM
-- Server version: 10.4.13-MariaDB
-- PHP Version: 7.4.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `Final_pj`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `FirstName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `LastName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `password`, `FirstName`, `LastName`) VALUES
(987, '$2y$10$fuhjD03IKwn0HeQhSN5BtuwkpVhMC7mNWWbYqSl5bAM9Z5CF1rIK6', 'Samson', 'Butterfly');

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

--
-- Table structure for table `advisor`
--

CREATE TABLE `advisor` (
  `std_id` bigint(20) UNSIGNED NOT NULL,
  `tch_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advisor`
--

INSERT INTO `advisor` (`std_id`, `tch_id`) VALUES
(60030401003, 12345),
(60030508003, 12345),
(61030508003, 12345),
(62070503402, 12345),
(62070503414, 12345),
(62070503414, 5059767071),
(62070503448, 12345),
(62070603003, 12345);

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

--
-- Table structure for table `classinfo`
--

CREATE TABLE `classinfo` (
  `ClassCode` varchar(7) NOT NULL,
  `ClassName` varchar(90) NOT NULL,
  `DepartmentID` int(11) NOT NULL,
  `Credit` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `classinfo`
--

INSERT INTO `classinfo` (`ClassCode`, `ClassName`, `DepartmentID`, `Credit`) VALUES
('ANI220', 'Production Design', 29, 3),
('ANI221', '2D Animation', 29, 3),
('APE111', 'MANUFACTURING PROCESSES', 10, 3),
('APE121', 'ENGINEERING DRAWING', 10, 3),
('APE211', 'ENGINEERING MATERIAL LABORATORY FOR AUTOMOTIVE PART MANUFACTURING', 10, 1),
('APE231', 'THERMODYNAMICS', 10, 3),
('APE241', 'AUTOMOTIVE BODY MANUFACTURING', 10, 2),
('APE321', 'MACHINE TOOLS', 10, 3),
('APE324', 'FORMING PROCESS', 10, 3),
('APE443', 'OPERATIONS MANAGEMENT IN AUTOMOTIVE INDUSTRIES', 10, 3),
('APE447', 'AUTOMOTIVE PART MANUFACTURING ENGINEERING LABORATORY', 10, 1),
('APE471', 'ENGINEERING PROJECT STUDY', 10, 1),
('ARC115', 'Design Sketch', 24, 3),
('ARC117', 'Design Fundamentals I', 24, 4),
('ARC226', 'History of Architecture and Interior Architecture II', 24, 3),
('ARC241', 'Architectural Design I', 24, 6),
('ARC343', 'Architectural Design III', 24, 6),
('ARC354', 'Site Planning and Landscape Architecture', 24, 3),
('ARC445', 'Architectural Design V', 24, 6),
('ARC494', 'Professional Practice and Legal Aspects', 24, 3),
('ARC501 ', 'Thesis Preparation', 24, 3),
('ARC591', 'Cooperative Learning', 24, 6),
('CHE100', 'INTRODUCTION TO CHEMICAL ENGINEERING', 1, 1),
('CHE210', 'INDUSTRIAL ORGANIC CHEMISTRY', 1, 3),
('CHE231', 'FUNDAMENTALS OF MOMENTUM, HEAT AND MASS TRANSFER', 1, 4),
('CHE241', 'THERMODYNAMICS I', 1, 3),
('CHE334', 'HEAT TRANSFER AND EQUIPMENT DESIGN', 1, 3),
('CHE343', 'CHEMICAL KINETICS AND REACTOR DESIGN', 1, 3),
('CHE451', 'MECHANICAL DESIGN OF PROCESS EQUIPMENT', 1, 3),
('CHE471', 'ENGINEERING MATERIALS AND SELECTION', 1, 3),
('CHE473', 'CHEMICAL PLANT SAFETY', 1, 3),
('CHE482', 'CHEMICAL ENGINEERING LABORATORY II', 1, 2),
('CHE483', 'UNDERGRADUATE SEMINAR', 1, 1),
('CHE484', 'CHEMICAL ENGINEERING PROJECT I', 1, 1),
('CHE494', 'SPECIAL TOPICS III : CHEMICAL PROCESS SIMULATION AND APPLICATIONS', 1, 3),
('CHHD101', 'CONCEPTS OF HEALTH AND HEALTH CARE SYSTEMS', 3, 1),
('CHHD201', 'FUNDAMENTAL MOLECULAR GENETICS', 3, 3),
('CHHD202', 'COMMUNICABLE AND NON-COMMUNICABLE DISEASES', 3, 3),
('CHHD307', 'INTRODUCTION TO NUTRITION AND HEALTH', 3, 3),
('CHHD308', 'CLINICAL MICROBIOLOGY', 3, 3),
('CHM101', 'GENERAL CHEMISTRY', 12, 4),
('CHM103', 'FUNDAMENTAL CHEMISTRY', 12, 3),
('CHM160', 'CHEMISTRY LABORATORY', 12, 1),
('CHM212', 'ORGANIC CHEMISTRY II', 12, 3),
('CHM214', 'ORGANIC CHEMISTRY', 12, 3),
('CHM215', 'ORGANIC CHEMISTRY', 12, 3),
('CHM321', 'INSTRUMENTAL METHODS OF CHEMICAL ANALYSIS I', 12, 3),
('CHM332', 'INORGANIC CHEMISTRY II', 12, 3),
('CHM341', 'PHYSICAL CHEMISTRY I', 12, 3),
('CHM451', 'NANOTECHNOLOGY', 12, 3),
('CHM495', 'INDUSTRIAL COOPERATIVE LEARNING', 12, 3),
('CMD111', 'Fundamentals of Typographic Communication', 27, 3),
('CMD212', 'Communication and Visual Representation\r\n', 27, 4),
('CMD222', 'Theory of Communication', 27, 3),
('CMD314', 'Communication and Interaction', 27, 4),
('CMD325', 'Psychology for Designers', 27, 3),
('CMD401', 'Communication Design Project Preparation', 27, 3),
('CMD453', 'Cooperative Study', 27, 6),
('CMM110', 'VISUAL LABORATORY', 15, 3),
('CMM133', 'SYNTAX, SEMANTICS AND PRAGMATICS OF PROGRAMING LANGUAGES', 15, 2),
('CMM134', 'OBJECT-ORIENTED PROGRAMMING', 15, 2),
('CMM210', 'COMPOSITING', 15, 2),
('CMM211', 'GRAPHIC DESIGN', 15, 2),
('CMM215', 'PAGE LAYOUT AND TYPOGRAPHY DESIGN', 15, 2),
('CMM331', 'IMAGE PROCESSING', 15, 2),
('CMM332', 'PHYSICS FOR ELECTRONIC, LIGHT SND SOUND', 15, 2),
('CMM421', 'NETWORKING', 15, 2),
('CMM463', 'ANIMATION STUDIO III', 15, 2),
('CPE100', 'COMPUTER PROGRAMMING FOR ENGINEERS', 3, 3),
('CPE101', 'ENGINEERING EXPLORATION', 3, 3),
('CPE102', 'COMPUTER PROGRAMMING BASICS', 3, 3),
('CPE103', 'DISCRETE MATHEMATICS', 3, 3),
('CPE111', 'PROGRAMMING WITH DATA STRUCTURES', 3, 3),
('CPE121', 'DISCRETE MATHEMATICS FOR COMPUTER ENGINEERS', 3, 3),
('CPE122', 'BASIC CIRCUITS AND ELECTRONICS', 3, 3),
('CPE212', 'ALGORITHM DESIGN', 3, 3),
('CPE223', 'DIGITAL ELECTRONICS AND LOGIC DESIGN', 3, 3),
('CPE231', 'DATABASE SYSTEMS', 3, 3),
('CPE315', 'SIGNALS AND LINEAR SYSTEMS', 3, 3),
('CPE325', 'BIG DATA', 3, 3),
('CPE326', 'OPERATING SYSTEMS', 3, 3),
('CPE327', 'SOFTWARE ENGINEERING', 3, 3),
('CPE332', 'PROFESSIONAL ISSUES IN COMPUTER ENGINEERING', 3, 1),
('CPE341', 'COMPUTER NETWORK', 3, 3),
('CPE342', 'JAVA PROGRAMMING LANGUAGE', 3, 3),
('CPE352', 'DATA SCIENCES', 3, 3),
('CPE353', 'DESIGN OF EXPERIMENT', 3, 3),
('CPE374', 'HUMAN-COMPUTER INTERACTION', 3, 3),
('CPE376', 'INTELLIGENT ROBOT PROGRAMMING', 3, 3),
('CPE381', 'DATA SECURITY FOR MULTIMEDIA COMMUNICATIONS', 3, 3),
('CPE383', 'DATA PRIVACY AND SECURITY', 3, 3),
('CPE393', 'SPECIAL TOPIC III : CODING IN ARTIFICIAL INTELLIGENCE', 3, 3),
('CPE401', 'COMPUTER ENGINEERING PROJECT I', 3, 3),
('CPE403', 'INDEPENDENT STUDY I', 3, 3),
('CPE405', 'WORK-INTEGRATED LEARNING I', 3, 6),
('CPE467', 'GAME DESIGN AND DEVELOPMENT', 3, 3),
('CPE494', 'SPECIAL TOPIC IV : COMMERCIALIZING YOUR PROJECT', 3, 3),
('CPE999', 'DemoWeb', 3, 3),
('CSC101', 'Computing Inventions and Innovations', 22, 1),
('CSC102', 'Introduction to Programming', 22, 3),
('CSC210', 'Analysis and Design of Algorithms', 22, 3),
('CSC213', 'System Analysis and Design', 22, 3),
('CSC319', 'Advanced Java', 22, 3),
('CSC340', 'Artificial Intelligence', 22, 3),
('CSC490', 'Capstone Project Writing', 22, 3),
('CSS111', 'EXPLORING COMPUTER SCIENCE', 11, 4),
('CSS112', 'COMPUTER PROGRAMMING', 11, 3),
('CSS113', 'INTRODUCTION TO COMPUTER AND DATA PROCESSING', 11, 3),
('CSS114', 'ELEMENTARY COMPUTER PROGRAMMING', 11, 3),
('CSS222', 'OBJECT-ORIENTED PROGRAMMING', 11, 3),
('CSS223', 'DATA STRUCTURES', 11, 3),
('CSS225', 'DATABASE SYSTEMS', 11, 3),
('CSS321', 'SOFTWARE ENGINEERING I', 11, 3),
('CSS331', 'INTRODUCTION TO ARTIFICIAL INTELLIGENCE', 11, 3),
('CSS341', 'INTRODUCTION TO DATA SCIENCE', 11, 3),
('CSS361', 'TECHNOPRENEURSHIP', 11, 3),
('CSS421', 'INTRODUCTION TO COMPUTATIONAL INTELLIGENCE', 11, 3),
('CSS422', 'HUMAN-COMPUTER INTERACTION', 11, 3),
('CSS461', 'ELECTRONIC COMMERCE SYSTEM', 11, 3),
('CTE111', 'CIVIL ENGINEERING DRAWING ', 16, 3),
('CTE112', 'CIVIL ENGINEERING DRAWING II', 16, 3),
('CTE212', 'CONSTRUCTION TECHNIQUES WORKSHOP I', 16, 3),
('CTE220', 'CONCRETE AND CONSTRUCTION MATERIALS', 16, 3),
('CTE241', 'SOIL MECHANICS', 16, 3),
('CTE242', 'SOIL MECHANICS LABORATORY', 16, 1),
('CTE304', 'LEARNING MANAGEMENT AND MICRO - TEACHING FOR CIVIL ENGINEERING', 16, 3),
('CTE321', 'REINFORCED CONCRETE DESIGN I', 16, 3),
('CTE322', 'STRUCTURAL ANALYSIS I', 16, 3),
('CVE100', 'COMPUTER PROGRAMMING FOR CIVIL ENGINEERING', 2, 3),
('CVE101', 'WORLD OF CIVIL ENGINEERING', 2, 2),
('CVE111', 'WORLD OF CIVIL ENGINEERING', 2, 3),
('CVE112', 'CIVIL ENGINEERING WORKSHOP', 2, 1),
('CVE221', 'SURVEYING', 2, 3),
('CVE223', 'SURVEYING PRACTICES', 2, 1),
('CVE231', 'ENGINEERING MECHANICS', 2, 3),
('CVE232', 'ENGINEERING MECHANICS II', 2, 2),
('CVE233', 'MECHANICS OF MATERIALS', 2, 3),
('CVE236', 'CIVIL ENGINEERING MATERIALS', 2, 2),
('CVE335', 'CEMENT AND CONCRETE MATERIALS', 2, 3),
('CVE336', 'MATERIALS TESTING LABORATORY', 2, 1),
('CVE337', 'STRUCTURAL ANALYSIS I', 2, 3),
('CVE338', 'STRUCTURAL ANALYSIS II', 2, 3),
('CVE362', 'SOIL MECHANICS', 2, 3),
('CVE363', 'SOIL MECHANICS LABORATORY', 2, 1),
('CVE382', 'HYDRAULIC ENGINEERING', 2, 3),
('CVE385', 'HYDROLOGY', 2, 3),
('CVE386', 'HYDROSPHERE', 2, 3),
('CVE394', 'HYDRAULICS LABORATORY', 2, 1),
('CVE401', 'CIVIL ENGINEERING PROJECT PROPOSAL', 2, 1),
('CVE414', 'CONSTRUCTION ESTIMATING AND SPECIFICATIONS', 2, 3),
('CVE415', 'CONSTRUCTION MANAGEMENT', 2, 3),
('CVE448', 'FUNDAMENTAL OF FINITE ELEMENT METHOD', 2, 3),
('DIP101', 'Design Innovation Studio I', 26, 6),
('DIP111', 'Art and Design Fundamentals', 26, 3),
('DIP201', 'Design Innovation Studio III', 26, 6),
('DIP211', 'Information Design', 26, 3),
('DIP301', 'Design Innovation Studio V', 26, 6),
('DIP311', 'Sustainable Design', 26, 3),
('DIP401', 'Design Innovation Studio VII', 26, 6),
('DIP431', 'Moral, Legal and Professional Practice', 26, 3),
('ECE101', 'DIGITAL CIRCUIT DESIGN', 18, 3),
('ECE260', 'MICROPROCESSOR', 18, 3),
('ECE302', 'ELECTRONIC COMMUNICATION', 18, 3),
('ECE386', 'ELECTRONIC TECHNOLOGY LABORATORY II', 18, 2),
('ECE441', 'OPTICAL COMMUNICATION ENGINEERING', 18, 3),
('EEE100', 'ELECTROTECHNOLOGY (POWER)', 7, 3),
('EEE102', 'ELECTROTECHNOLOGY I (POWER)', 7, 3),
('EEE111', 'ELECTRIC CIRCUIT ANALYSIS', 7, 3),
('EEE190', 'ELECTRICAL PRACTICE', 7, 1),
('EEE260', 'ELECTRICAL INSTRUMENTS AND MEASUREMENTS', 7, 3),
('EEE270', 'ELECTRONICS ENGINEERING', 7, 3),
('EEE321', 'ELECTRICAL MACHINES II', 7, 3),
('EEE322', 'ELECTROMAGNETIC FIELDS', 7, 3),
('EEE361', 'ILLUMINATION ENGINEERING', 7, 3),
('EEE380', 'CONTROL SYSTEMS', 7, 3),
('EEE401', 'SPECIAL TOPIC I : ELECTRICAL SAFETY FOR INDUSTRY', 7, 3),
('EEE402', 'SPECIAL TOPIC II : RAILWAY ELECTRIFICATION', 7, 3),
('EEE424', 'ELECTRIC DRIVES', 7, 3),
('EIE105', 'COMPUTER PROGRAMMING FOR ELECTRICAL COMMUNICATION AND ELECTRONIC ENGINEERING', 5, 3),
('EIE205', 'ELECTRONIC ENGINEERING PRACTICE', 5, 1),
('EIE210', 'ELECTRONIC DEVICES AND CIRCUIT DESIGN I', 5, 3),
('EIE301', 'PROBABILITY AND STATISTICS FOR ENGINEERS', 5, 3),
('EIE312', 'ELECTRONIC ENGINEERING LABORATORY', 5, 1),
('EIE325', 'ELECTROMAGNETIC FIELDS AND WAVES', 5, 3),
('EIE370', 'SEMINAR', 5, 1),
('EIE422', 'DATA COMMUNICATION', 5, 3),
('ENV210', 'FUNDAMENTALS IN ENVIRONMENTAL ENGINEERING', 8, 2),
('ENV213', 'SURVEYING FOR ENVIRONMENTAL ENGINEERING', 8, 3),
('ENV341', 'UNIT OPERATION IN ENVIRONMENTAL ENGINEERING', 8, 3),
('ENV344', 'BIOLOGICAL UNIT PROCESSES IN ENVIRONMENTAL ENGINEERING', 8, 3),
('ENV401', 'ENVIRONMENTAL ENGINEERING PROJECT PROPOSAL', 8, 1),
('ENV434', 'ENVIRONMENTAL IMPACT ASSESSMENT AND MANAGEMENT', 8, 3),
('ENV442', 'WATER SUPPLY ENGINEERING', 8, 3),
('ENV451', 'WASTEWATER COLLECTION AND WATER DISTRIBUTION SYSTEMS', 8, 3),
('EPE200', 'ELECTRICAL MACHINES', 18, 3),
('ETM101', 'FUNDAMENTAL ARTS', 17, 2),
('ETM102', 'MASS COMMUNICATION', 17, 3),
('ETM103', 'PHOTOGRAPHY I', 17, 3),
('ETM104', 'FUNDAMENTAL BROADCASTING', 17, 2),
('ETM202', 'ADVERTISING AND PUBLIC RELATIONS', 17, 2),
('ETM211', 'LEARNING PSYCHOLOGY', 17, 2),
('ETM312', 'STATISTICS FOR FUNDAMENTAL RESEARCH', 17, 2),
('ETM361', 'PRESENTATION SKILLS II', 17, 3),
('ETM472', 'EDUCATIONAL TECHNOLOGY AND MASS COMMUNICATION PROJECT', 17, 3),
('FMI220', 'Fundamentals of Moving Image', 29, 3),
('FMI221', 'Storytelling', 29, 3),
('FMI350', 'Experimental Film Project', 29, 3),
('FRA121', 'Electronic Circuits for Robotics and Automation Engineering', 32, 3),
('FRA141', 'Computer Programming for Robotics and Automation Engineering I', 32, 3),
('FRA142', 'Computer Programming for Robotics and Automation Engineering II', 32, 3),
('FRA261', 'Robotics and Automation Engineering Lab II', 32, 3),
('FRA262', 'Inventor Studio', 32, 3),
('FRA300', 'Industrial Training', 32, 2),
('FRA321', 'Image Processing and Analysis', 32, 3),
('FRA451', 'Manufacturing and Automation', 32, 3),
('FRA452', 'Manufacturing Process', 32, 3),
('FST311', 'FOOD CHEMISTRY I', 14, 2),
('FST331', 'FOOD ENGINEERING I', 14, 3),
('FST341', 'FOOD PROCESSING I', 14, 2),
('FST471', 'PRODUCT DEVELOPMENT', 14, 3),
('FST481', 'FOOD SAFETY AND QUALITY MANAGEMENT', 14, 3),
('GEN101', 'Physical education', 33, 3),
('GEN111', 'Man and ethics of living', 33, 3),
('GEN121', 'Learning and problem solving skills', 33, 3),
('GEN201', 'Art and science of cooking and eating', 33, 3),
('GEN211', 'The philosophy of sufficiency economy', 33, 3),
('GEN223', 'Disaster preparedness', 33, 3),
('GEN224', 'Liveable city', 33, 3),
('GEN231', 'Miracle of thinking', 33, 3),
('GEN232', 'Community based research and innovation', 33, 3),
('GEN241', 'Beauty of life', 33, 3),
('GEN242', 'Chinese philosophy and ways of life', 33, 3),
('GEN301', 'Holistic health development', 33, 3),
('GEN311', 'Ethics in science-based society', 33, 3),
('GEN321', 'The history of civilization', 33, 3),
('GEN331', 'Man and reasoning', 33, 3),
('GEN341', 'Thai indigeous knowledge', 33, 3),
('GEN351', 'Modern management and leadership', 33, 3),
('GEN352', 'Technology and innovation for sustainable development', 33, 3),
('GEN353', 'Managerial psychology', 33, 3),
('GEN411', 'Personality development and public speaking', 33, 3),
('GEN412', 'Science and art of living and working', 33, 3),
('GEN421', 'Integrative social sciences', 33, 3),
('GEN441', 'Culture and excursion', 33, 3),
('GRD220', 'Elements of Graphic Design', 29, 3),
('GRD221', 'Illustration', 29, 3),
('INA211', 'Color, Materials and Presentation', 25, 3),
('INA241', 'Interior Architectural Design I', 25, 6),
('INA242', 'Interior Architectural Design II', 25, 4),
('INA435', 'Research Methods for Interior Architecture', 25, 3),
('INA445', 'Interior Arch. Design V', 25, 6),
('INA446', 'Interior Arch. Design VI', 25, 6),
('INA464', 'Interior Shop Drawing and Detail', 25, 3),
('INC102', 'FUNDAMENTAL OF INSTRUMENTATION AND PROCESS CONTROL', 4, 3),
('INC111', 'ELECTRIC CIRCUIT ANALYSIS', 4, 3),
('INC121', 'ELECTRIC CIRCUIT ANALYSIS I', 4, 2),
('INC171', 'SYSTEMS ENGINEERING EXPLORATION', 4, 2),
('INC221', 'ELECTRONICS DEVICES AND CIRCUIT DESIGN', 4, 3),
('INC222', 'LOGIC THEORY AND DIGITAL CIRCUIT DESIGN', 4, 3),
('INC223', 'ELECTRONICS FOR AUTOMATION SYSTEM', 4, 3),
('INC301', 'WORK INTEGRATED LEARNING PREPARATION', 4, 2),
('INC311', 'ENGINEERING STATISTICS AND QUALITY SYSTEM', 4, 3),
('INC331', 'INDUSTRIAL PROCESS MEASUREMENT', 4, 3),
('INC401', 'WORK INTEGRATED LEARNING I: ROUTINE WORK', 4, 3),
('INC402', 'WORK INTEGRATED LEARNING II: PROJECT', 4, 6),
('INC403', 'WORK INTEGRATED LEARNING III: KNOWLEDGE', 4, 3),
('INT100', 'Information Technology Fundamentals', 23, 3),
('INT101', 'Programming Fundamentals', 23, 3),
('INT201', 'Client-Side Web Programming I', 23, 2),
('INT202', 'Server-Side Web Programming I', 23, 2),
('INT308', 'Security II', 23, 2),
('INT319', 'Information Technology Professional Practice', 23, 4),
('INT366', 'Capstone Information Technology Project II', 23, 3),
('LAN225', 'History of Landscape Architecture', 28, 3),
('LAN241', 'Landscape Architectural Design I', 28, 6),
('LAN252', 'Planting Design Principles', 28, 3),
('LAN332', 'Contemporary Landscape Design and Environmental Sustainability', 28, 3),
('LAN353', 'Forestry', 28, 3),
('LAN445', 'Landscape Architectural Design V: Studio Co-lab', 28, 6),
('LAN482', 'Innovative Technology', 28, 3),
('LAN501 ', 'Thesis Preparation', 28, 3),
('LAN594', 'Exhibition and Event Management', 28, 3),
('MDA110', 'Drawing I', 29, 3),
('MDA112', 'Photography Basic', 29, 3),
('MDT110', 'Graphic Media Design', 30, 3),
('MDT111', 'Interface Psychology', 30, 3),
('MDT210', 'Applied Statistics for Media', 30, 3),
('MDT211', 'Computer Programming for Media II', 30, 3),
('MDT311', 'Database System', 30, 3),
('MDT370', 'Project Study', 30, 1),
('MDT470', 'Media Project II', 30, 2),
('MDT471', 'Co-operative Education', 30, 9),
('MEE101', 'MATERIALS SCIENCE AND ENGINEERING', 6, 3),
('MEE111', 'ENGINEERING DRAWING', 6, 3),
('MEE115', 'ENGINEERING DRAWING', 6, 3),
('MEE211', 'ENGINEERING MECHANICS I', 6, 3),
('MEE212', 'ENGINEERING MECHANICS II', 6, 3),
('MEE213', 'MECHANICS OF SOLIDS', 6, 3),
('MEE214', 'ENGINEERING MECHANICS', 6, 3),
('MEE216', 'COMPUTER AIDED DRAWING', 6, 1),
('MEE312', 'MECHANICS OF MACHINERY', 6, 3),
('MEE313', 'MACHINE DESIGN', 6, 3),
('MEE321', 'HEAT TRANSFER', 6, 3),
('MEE461', 'CAPSTONE DESIGN PROJECT I', 6, 3),
('MEE462', 'MECHANICAL ENGINEERING PROJECT II', 6, 3),
('MIC101', 'GENERAL BIOLOGY', 3, 14),
('MIC191', 'GENERAL BIOLOGY LABORATORY', 14, 1),
('MIC211', 'BACTERIOLOGY', 14, 2),
('MIC321', 'BASIC BIOPROCESS ENGINEERING', 14, 2),
('MIC324', 'BIOSAFETY', 14, 2),
('MIC497', 'SEMINAR', 14, 1),
('MIC498', 'INDEPENDENT STUDY I', 14, 1),
('MMD112', 'Perspective of Science', 31, 3),
('MMD142', 'Technology and management media equipment', 31, 3),
('MMD220', 'Medical and Science Model I', 31, 3),
('MMD233', 'Video production for medical media and science 1', 31, 3),
('MMD310', 'Pathology and Medical Microbiology', 31, 3),
('MMD321', 'Critical Thinking for Design', 31, 3),
('MMD470', 'Project I', 31, 1),
('MMD480', 'Work Integrated Learning I : Routine Work', 31, 3),
('MMD481', 'Work Integrated Learning II : Project', 31, 3),
('MNE422', 'ENERGY AUDIT', 6, 3),
('MTA101', 'Fundamental of Media', 29, 3),
('MTA202', 'Presentation Skills', 29, 3),
('MTA304', 'Project Management for Media', 29, 3),
('MTE111', 'ENGINEERING DRAWING', 19, 3),
('MTE112', 'INDUSTRIAL MATERIAL AND BASIC TECHNICAL TOOLS', 19, 3),
('MTE171', 'AUTOMOTIVE TECHNOLOGY I', 19, 3),
('MTE211', 'ELECTRICAL AND INSTRUMENTATION TECHNOLOGY', 19, 3),
('MTE231', 'ENGINEERING STATICS', 19, 3),
('MTE233', 'ENGINEERING DYNAMICS', 19, 3),
('MTE241', 'THERMODYNAMICS', 19, 3),
('MTE342', 'HEAT TRANSFER', 19, 3),
('MTE351', 'FUNDAMENTAL OF DYNAMICS SYSTEMS AND CONTROLS', 19, 3),
('MTE452', 'PNEUMATIC AND HYDRAULICS SYSTEMS', 19, 3),
('MTE461', 'MECHANICAL TECHNOLOGY LABORATORY I', 19, 2),
('PHY100', 'CONCEPTUAL PHYSICS', 13, 2),
('PHY101', 'GENERAL PHYSICS FOR SCIENCE STUDENTS I', 13, 3),
('PHY103', 'GENERAL PHYSICS FOR ENGINEERING STUDENTS I', 13, 3),
('PHY104', 'GENERAL PHYSICS FOR ENGINEERING STUDENTS II', 13, 3),
('PHY191', 'GENERAL PHYSICS LABORATORY I', 13, 1),
('PHY290', 'MODERN AND ADVANCED PHYSICS LABORATORY', 13, 1),
('PHY301', 'ANALYTICAL MECHANICS', 13, 3),
('PHY302', 'ELECTRICITY AND MAGNETISM', 13, 3),
('PHY423', 'NANOTECHNOLOGY I', 13, 3),
('PHY431', 'INTRODUCTION TO RADIOLOGICAL HEALTH', 13, 3),
('PPT101', 'BASIC PRINTING AND PACKAGING TECHNOLOGY', 20, 3),
('PPT111', 'LAY-OUT DESIGN', 20, 3),
('PPT201', 'STATISTICS AND ANALYSIS FOR PRINTING AND PACKAGING', 20, 3),
('PPT212', 'PACKAGING DESIGN', 20, 3),
('PPT351', 'PACKAGING DYNAMICS', 20, 3),
('PPT354', 'DISTRIBUTION PACKAGING', 20, 3),
('PPT491', 'CO-OPERATIVE EDUCATION PRACTICE', 20, 9),
('PPT492', 'PROJECT STUDY', 20, 1),
('PRE103', 'PRODUCTION TECHNOLOGY', 9, 2),
('PRE113', 'COMPUTER PROGRAMMING FOR ENGINEERS', 9, 3),
('PRE115', 'PRODUCTION DRAWING', 9, 3),
('PRE133', 'ENGINEERING MATERIALS', 9, 3),
('PRE141', 'MANUFACTURING PROCESS', 9, 3),
('PRE151', 'ENGINEERING MATERIALS', 9, 3),
('PRE211', 'ADVANCED MACHINE TOOLS', 9, 2),
('PRE242', 'METALLURGY', 9, 3),
('PRE251', 'SIGNAL AND MEASUREMENT SYSTEM', 9, 3),
('PRE315', 'MECHANICS OF SOLIDS AND MACHINE DESIGN', 9, 3),
('PRE323', 'WELDING ENGINEERING', 9, 3),
('PRE331', 'THERMODYNAMICS', 9, 3),
('PRE332', 'MECHANICAL ENGINEERING LABORATORY', 9, 1),
('PRE432', 'FAILURE ANALYSIS', 9, 3),
('PRE454', 'MACHINE VISION', 9, 3),
('PTE101', 'BASIC TECHNICAL SKILL PRACTICES', 21, 1),
('PTE111', 'ENGINEERING DRAWING', 21, 3),
('PTE251', 'ENGINEERING MATERIAL', 21, 3),
('PTE261', 'MANUFACTURING PROCESSES', 21, 3),
('PTE324', 'WELDING TECHNOLOGY II', 21, 3),
('PTE344', 'MACHINE TOOL TECHNOLOGY II', 21, 3),
('PTE351', 'ENGINEERING METALLURGY', 21, 3),
('PTE406', 'TEACHING FOR SAFETY ENGINEERING', 21, 3),
('PTE442', 'TOOL ENGINEERING', 21, 3);

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

--
-- Table structure for table `classSec`
--

CREATE TABLE `classSec` (
  `ClassCode` varchar(7) CHARACTER SET utf8 NOT NULL,
  `SectionNo` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `classSec`
--

INSERT INTO `classSec` (`ClassCode`, `SectionNo`) VALUES
('ANI220', 1),
('ANI221', 1),
('APE111', 1),
('APE121', 1),
('APE121', 2),
('APE211', 1),
('APE231', 1),
('APE241', 1),
('APE321', 1),
('APE324', 1),
('APE443', 1),
('APE447', 1),
('APE471', 1),
('ARC115', 1),
('ARC117', 1),
('ARC226', 1),
('ARC241', 1),
('ARC343', 1),
('ARC354', 1),
('ARC445', 1),
('ARC494', 1),
('ARC501', 1),
('ARC591', 1),
('CHE100', 1),
('CHE100', 31),
('CHE210', 1),
('CHE210', 31),
('CHE231', 1),
('CHE231', 31),
('CHE241', 1),
('CHE241', 31),
('CHE334', 1),
('CHE334', 31),
('CHE343', 1),
('CHE343', 31),
('CHE451', 1),
('CHE451', 31),
('CHE471', 1),
('CHE471', 31),
('CHE473', 1),
('CHE473', 2),
('CHE473', 31),
('CHE482', 1),
('CHE482', 2),
('CHE482', 31),
('CHE483', 1),
('CHE483', 31),
('CHE484', 1),
('CHE484', 31),
('CHE494', 1),
('CHE494', 31),
('CHHD101', 1),
('CHHD201', 1),
('CHHD202', 1),
('CHHD307', 1),
('CHHD308', 1),
('CHM101', 1),
('CHM101', 2),
('CHM103', 1),
('CHM103', 2),
('CHM103', 3),
('CHM103', 31),
('CHM103', 32),
('CHM160', 1),
('CHM160', 2),
('CHM160', 3),
('CHM160', 4),
('CHM160', 5),
('CHM212', 1),
('CHM214', 1),
('CHM215', 1),
('CHM321', 1),
('CHM332', 1),
('CHM341', 1),
('CHM451', 1),
('CHM495', 1),
('CMD111', 1),
('CMD212', 1),
('CMD222', 1),
('CMD314', 1),
('CMD325', 1),
('CMD401', 1),
('CMD453', 1),
('CMM110', 1),
('CMM133', 1),
('CMM134', 1),
('CMM210', 1),
('CMM211', 1),
('CMM215', 1),
('CMM331', 1),
('CMM332', 1),
('CMM421', 1),
('CMM463', 1),
('CPE100', 1),
('CPE100', 2),
('CPE100', 3),
('CPE100', 31),
('CPE100', 32),
('CPE100', 33),
('CPE100', 34),
('CPE100', 99),
('CPE101', 1),
('CPE101', 2),
('CPE101', 31),
('CPE101', 32),
('CPE101', 33),
('CPE102', 1),
('CPE103', 1),
('CPE111', 99),
('CPE121', 1),
('CPE121', 2),
('CPE121', 31),
('CPE121', 32),
('CPE122', 99),
('CPE212', 1),
('CPE212', 2),
('CPE212', 31),
('CPE212', 32),
('CPE223', 1),
('CPE223', 2),
('CPE223', 31),
('CPE223', 32),
('CPE231', 1),
('CPE231', 2),
('CPE315', 1),
('CPE315', 2),
('CPE325', 31),
('CPE326', 1),
('CPE326', 2),
('CPE326', 3),
('CPE326', 31),
('CPE326', 32),
('CPE327', 1),
('CPE327', 2),
('CPE327', 3),
('CPE327', 31),
('CPE327', 32),
('CPE332', 1),
('CPE332', 2),
('CPE332', 3),
('CPE332', 31),
('CPE332', 32),
('CPE341', 31),
('CPE342', 1),
('CPE342', 31),
('CPE352', 1),
('CPE353', 1),
('CPE374', 1),
('CPE374', 31),
('CPE376', 1),
('CPE376', 31),
('CPE381', 1),
('CPE381', 31),
('CPE383', 1),
('CPE393', 1),
('CPE393', 31),
('CPE401', 1),
('CPE401', 2),
('CPE401', 31),
('CPE401', 32),
('CPE403', 31),
('CPE405', 31),
('CPE467', 1),
('CPE467', 31),
('CPE494', 1),
('CPE494', 31),
('CPE999', 2),
('CSC101', 1),
('CSC101', 2),
('CSC102', 1),
('CSC210', 1),
('CSC213', 1),
('CSC319', 1),
('CSC340', 1),
('CSC490', 1),
('CSS111', 1),
('CSS111', 2),
('CSS112', 1),
('CSS112', 2),
('CSS113', 1),
('CSS114', 1),
('CSS114', 2),
('CSS222', 1),
('CSS222', 2),
('CSS223', 1),
('CSS225', 1),
('CSS321', 1),
('CSS331', 1),
('CSS341', 1),
('CSS361', 1),
('CSS421', 1),
('CSS422', 1),
('CSS461', 1),
('CTE111', 1),
('CTE112', 1),
('CTE212', 1),
('CTE220', 1),
('CTE241', 1),
('CTE242', 1),
('CTE304', 1),
('CTE321', 1),
('CTE322', 1),
('CVE100', 1),
('CVE100', 2),
('CVE101', 31),
('CVE111', 1),
('CVE111', 2),
('CVE111', 33),
('CVE112', 1),
('CVE221', 1),
('CVE221', 2),
('CVE221', 31),
('CVE223', 1),
('CVE223', 2),
('CVE223', 31),
('CVE231', 31),
('CVE232', 1),
('CVE232', 2),
('CVE233', 1),
('CVE233', 2),
('CVE236', 31),
('CVE236', 32),
('CVE335', 31),
('CVE336', 1),
('CVE336', 2),
('CVE336', 3),
('CVE336', 4),
('CVE337', 31),
('CVE337', 32),
('CVE338', 1),
('CVE338', 2),
('CVE362', 1),
('CVE362', 31),
('CVE362', 32),
('CVE363', 1),
('CVE363', 2),
('CVE363', 31),
('CVE363', 32),
('CVE382', 31),
('CVE385', 1),
('CVE385', 2),
('CVE385', 31),
('CVE386', 32),
('CVE394', 1),
('CVE394', 2),
('CVE394', 31),
('CVE394', 32),
('CVE394', 33),
('CVE401', 1),
('CVE401', 31),
('CVE414', 1),
('CVE414', 31),
('CVE415', 1),
('CVE415', 31),
('CVE448', 1),
('CVE448', 31),
('DIP101', 1),
('DIP111', 1),
('DIP201', 1),
('DIP211', 1),
('DIP301', 1),
('DIP311', 1),
('DIP401', 1),
('DIP431', 1),
('ECE101', 1),
('ECE260', 1),
('ECE302', 1),
('ECE386', 1),
('ECE441', 1),
('EEE100', 1),
('EEE100', 2),
('EEE100', 31),
('EEE102', 1),
('EEE102', 2),
('EEE102', 3),
('EEE102', 4),
('EEE102', 5),
('EEE111', 1),
('EEE111', 99),
('EEE190', 1),
('EEE190', 2),
('EEE260', 1),
('EEE270', 1),
('EEE321', 1),
('EEE321', 2),
('EEE322', 1),
('EEE361', 1),
('EEE380', 1),
('EEE380', 2),
('EEE401', 1),
('EEE402', 1),
('EEE424', 1),
('EIE105', 31),
('EIE105', 32),
('EIE205', 31),
('EIE210', 31),
('EIE301', 31),
('EIE312', 31),
('EIE325', 31),
('EIE370', 31),
('EIE422', 31),
('ENV210', 1),
('ENV210', 2),
('ENV210', 31),
('ENV213', 1),
('ENV213', 31),
('ENV341', 1),
('ENV341', 31),
('ENV344', 1),
('ENV344', 31),
('ENV401', 1),
('ENV401', 31),
('ENV434', 1),
('ENV434', 31),
('ENV442', 1),
('ENV442', 31),
('ENV451', 1),
('ENV451', 31),
('EPE200', 1),
('ETM101', 1),
('ETM101', 2),
('ETM102', 1),
('ETM102', 2),
('ETM103', 1),
('ETM103', 2),
('ETM104', 1),
('ETM104', 2),
('ETM202', 1),
('ETM202', 2),
('ETM211', 1),
('ETM211', 2),
('ETM312', 1),
('ETM312', 2),
('ETM361', 1),
('ETM472', 1),
('ETM472', 2),
('FMI220', 1),
('FMI221', 1),
('FMI350', 1),
('FRA121', 1),
('FRA141', 1),
('FRA141', 2),
('FRA141', 3),
('FRA142', 1),
('FRA261', 1),
('FRA262', 1),
('FRA300', 1),
('FRA321', 1),
('FRA451', 1),
('FRA451', 2),
('FRA452', 1),
('FST311', 1),
('FST331', 1),
('FST341', 1),
('FST471', 1),
('FST481', 1),
('GEN101', 1),
('GEN101', 2),
('GEN101', 3),
('GEN111', 1),
('GEN111', 2),
('GEN111', 3),
('GEN121', 1),
('GEN121', 2),
('GEN121', 3),
('GEN201', 1),
('GEN201', 2),
('GEN201', 3),
('GEN211', 1),
('GEN211', 2),
('GEN211', 3),
('GEN223', 1),
('GEN223', 2),
('GEN223', 3),
('GEN224', 1),
('GEN224', 2),
('GEN224', 3),
('GEN231', 1),
('GEN231', 2),
('GEN231', 3),
('GEN232', 1),
('GEN232', 2),
('GEN232', 3),
('GEN241', 1),
('GEN241', 2),
('GEN241', 3),
('GEN242', 1),
('GEN242', 2),
('GEN242', 3),
('GEN301', 1),
('GEN301', 2),
('GEN301', 3),
('GEN311', 1),
('GEN311', 2),
('GEN311', 3),
('GEN321', 1),
('GEN321', 2),
('GEN321', 3),
('GEN331', 1),
('GEN331', 2),
('GEN331', 3),
('GEN341', 1),
('GEN341', 2),
('GEN341', 3),
('GEN351', 1),
('GEN351', 2),
('GEN351', 3),
('GEN352', 1),
('GEN352', 2),
('GEN352', 3),
('GEN353', 1),
('GEN353', 2),
('GEN353', 3),
('GEN411', 1),
('GEN411', 2),
('GEN411', 3),
('GEN412', 1),
('GEN412', 2),
('GEN412', 3),
('GEN421', 1),
('GEN421', 2),
('GEN421', 3),
('GEN441', 1),
('GEN441', 2),
('GEN441', 3),
('GRD220', 1),
('GRD221', 1),
('INA211', 1),
('INA241', 1),
('INA242', 1),
('INA435', 1),
('INA445', 1),
('INA446', 1),
('INA464', 1),
('INC102', 1),
('INC102', 2),
('INC102', 3),
('INC111', 1),
('INC121', 1),
('INC121', 2),
('INC171', 1),
('INC171', 2),
('INC221', 1),
('INC221', 2),
('INC222', 1),
('INC222', 2),
('INC222', 31),
('INC223', 31),
('INC301', 2),
('INC311', 31),
('INC331', 1),
('INC331', 2),
('INC331', 31),
('INC401', 1),
('INC402', 1),
('INC403', 1),
('INT100', 1),
('INT101', 1),
('INT201', 1),
('INT202', 1),
('INT202', 2),
('INT308', 1),
('INT308', 2),
('INT319', 1),
('INT319', 2),
('INT366', 1),
('LAN225', 1),
('LAN241', 1),
('LAN252', 1),
('LAN332', 1),
('LAN353', 1),
('LAN445', 1),
('LAN482', 1),
('LAN501', 1),
('LAN594', 1),
('MDA110', 1),
('MDA112', 1),
('MDT110', 1),
('MDT111', 1),
('MDT210', 1),
('MDT211', 1),
('MDT311', 1),
('MDT370', 1),
('MDT470', 1),
('MDT471', 1),
('MEE101', 1),
('MEE101', 2),
('MEE101', 99),
('MEE111', 1),
('MEE111', 2),
('MEE111', 3),
('MEE111', 4),
('MEE115', 1),
('MEE115', 31),
('MEE211', 1),
('MEE212', 1),
('MEE213', 1),
('MEE214', 1),
('MEE214', 2),
('MEE214', 3),
('MEE214', 4),
('MEE214', 5),
('MEE214', 99),
('MEE216', 1),
('MEE216', 2),
('MEE216', 3),
('MEE312', 1),
('MEE313', 1),
('MEE313', 2),
('MEE313', 3),
('MEE321', 1),
('MEE321', 2),
('MEE321', 3),
('MEE461', 1),
('MEE462', 1),
('MIC101', 31),
('MIC191', 1),
('MIC191', 2),
('MIC191', 3),
('MIC191', 4),
('MIC191', 5),
('MIC211', 1),
('MIC321', 1),
('MIC324', 1),
('MIC497', 1),
('MIC498', 1),
('MMD112', 1),
('MMD142', 1),
('MMD220', 1),
('MMD233', 1),
('MMD310', 1),
('MMD321', 1),
('MMD470', 1),
('MMD480', 1),
('MMD481', 1),
('MNE422', 1),
('MTA101', 1),
('MTA202', 1),
('MTA304', 1),
('MTE111', 1),
('MTE112', 1),
('MTE171', 1),
('MTE211', 1),
('MTE231', 1),
('MTE233', 1),
('MTE241', 1),
('MTE342', 1),
('MTE351', 1),
('MTE452', 1),
('MTE461', 1),
('PHY100', 1),
('PHY101', 1),
('PHY101', 2),
('PHY101', 3),
('PHY101', 4),
('PHY101', 5),
('PHY103', 1),
('PHY103', 2),
('PHY103', 3),
('PHY103', 4),
('PHY103', 5),
('PHY104', 99),
('PHY191', 1),
('PHY191', 2),
('PHY191', 3),
('PHY191', 4),
('PHY191', 5),
('PHY290', 1),
('PHY301', 1),
('PHY302', 1),
('PHY423', 1),
('PHY431', 1),
('PPT101', 1),
('PPT101', 2),
('PPT111', 1),
('PPT111', 2),
('PPT201', 1),
('PPT201', 2),
('PPT212', 1),
('PPT212', 2),
('PPT351', 1),
('PPT354', 1),
('PPT491', 1),
('PPT491', 2),
('PPT492', 1),
('PPT492', 2),
('PRE103', 99),
('PRE113', 1),
('PRE113', 99),
('PRE115', 1),
('PRE115', 2),
('PRE115', 3),
('PRE133', 1),
('PRE133', 99),
('PRE141', 1),
('PRE141', 2),
('PRE141', 3),
('PRE141', 99),
('PRE151', 1),
('PRE151', 31),
('PRE211', 1),
('PRE211', 2),
('PRE242', 1),
('PRE242', 2),
('PRE251', 1),
('PRE315', 1),
('PRE315', 2),
('PRE315', 3),
('PRE323', 1),
('PRE323', 2),
('PRE331', 1),
('PRE332', 1),
('PRE432', 1),
('PRE454', 1),
('PTE101', 1),
('PTE111', 1),
('PTE251', 1),
('PTE261', 1),
('PTE324', 1),
('PTE344', 1),
('PTE351', 1),
('PTE406', 1),
('PTE442', 1);

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

--
-- Table structure for table `depInfo`
--

CREATE TABLE `depInfo` (
  `DepartmentID` int(11) NOT NULL,
  `DepartmentName` varchar(100) NOT NULL,
  `Address` text NOT NULL,
  `FacultyID` int(11) NOT NULL,
  `Contact` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `depInfo`
--

INSERT INTO `depInfo` (`DepartmentID`, `DepartmentName`, `Address`, `FacultyID`, `Contact`) VALUES
(1, 'Chemical Engineering', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', 1, '024709220-30'),
(2, 'Civil Engineering', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', 1, ' 024709134-5'),
(3, 'Computer Engineering', '10th-11th Floor, Witsawawattana Building, 126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', 1, ' 024709388'),
(4, 'Control System and Instrumentation Engineering', '6th Floor, Classroom Building4, 126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', 1, ' 024709096'),
(5, 'Electronics and Telecommunication Engineering', '9th-10th Floor, Classroom Building4, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 1, '024709070-1'),
(6, 'Mechanical Engineering', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 1, '084709123'),
(7, 'Electrical Engineering', '4th Floor, Classroom Building4, 126, Pracha Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 1, '024709043'),
(8, 'Environmental Engineering', '6th Floor, Classroom Building5, 126, Pracha Uthit Road, Bang Mod, Thung Khru, Bangkok 10140  Thailand', 1, '024709163'),
(9, 'Production Engineering', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 1, '024709175-7'),
(10, 'Tool and Materials Engineering', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 1, '024709213'),
(11, 'Mathematics', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 2, '024708822'),
(12, 'Chemistry', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 2, '024708843'),
(13, 'Physics', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 2, '024708876'),
(14, 'Microbiology', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 2, '024708887'),
(15, 'Computer and Information Technology', '6th Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708500'),
(16, 'Civil Technology Education', '2nd Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708508'),
(17, 'Education Communications and Technology', '9th Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '0247085656'),
(18, 'Electrical Technology Education', '2nd Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708000'),
(19, 'Mechanical Technology Education', '4th Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708526'),
(20, 'Printing and Packaging Technology', '2nd Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708574'),
(21, 'Production Technology Education', '7th Floor, Faculty of Industrial Education and Technology Class3 Building, 126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 3, '024708554'),
(22, 'Computer Science', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 4, '024709850'),
(23, 'Information Technology', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 4, '024709850'),
(24, 'Architecture', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', 5, '024707887-8'),
(25, 'Interior Architecture', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', 5, '024707887-8'),
(26, 'Design Innovation', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', 5, '024707887-8'),
(27, 'Communication Design', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', 5, '024707887-8'),
(28, 'Landscape Architechture', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', 5, '024707887-8'),
(29, 'Media Arts', 'A1 Media Technology and Applied Art, 49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham, Bang Khun Thian, Bangkok 10150, Thailand.', 5, '024707603'),
(30, 'Media Technology', 'A1 Media Technology and Applied Art, 49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham, Bang Khun Thian, Bangkok 10150, Thailand', 5, '024707603'),
(31, 'Medical and Science Media', 'A1 Media Technology and Applied Art, 49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham, Bang Khun Thian, Bangkok 10150, Thailand', 5, '024707603'),
(32, 'Robotics and Automation Engineering', '126 Pracha-Uthit Road, Bang Mod, Thung Khru, Bangkok 10140 Thailand', 6, '024709715-6'),
(33, 'Project to establish a general education office', '126 Pracha Uthit Road Bang Mot Thung Khru Bangkok 10140 Thailand', 7, '24708716');

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

--
-- Table structure for table `facInfo`
--

CREATE TABLE `facInfo` (
  `FacultyID` int(11) NOT NULL,
  `FacultyName` varchar(100) NOT NULL,
  `Address` text NOT NULL,
  `Contact` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `facInfo`
--

INSERT INTO `facInfo` (`FacultyID`, `FacultyName`, `Address`, `Contact`) VALUES
(1, 'Faculty of Engineering', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024709017'),
(2, 'Faculty of Science', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024708805'),
(3, 'Faculty of Industrial Education and Technology', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024708508 '),
(4, 'School of Information Technology', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024708000'),
(5, 'School of Architecture and Design', '49 Soi Thian Thale 25, Bang Khun Thian Chai Thale Road, Tha Kham Bang Khun Thian, Bangkok 10150 Thailand', '024707887'),
(6, 'Institute of Field Robotics', '126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024709690'),
(7, 'The School of Liberal Arts', ' 126 Pracha Uthit Road, Bang Mot, Thung Khru, Bangkok 10140 Thailand', '024708716');

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

--
-- Table structure for table `programInfo`
--

CREATE TABLE `programInfo` (
  `ProgramID` int(11) NOT NULL,
  `DepartmentID` int(11) NOT NULL,
  `ProgramName` varchar(50) NOT NULL,
  `TuitionFee` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `programInfo`
--

INSERT INTO `programInfo` (`ProgramID`, `DepartmentID`, `ProgramName`, `TuitionFee`) VALUES
(1, 1, 'International', 56000),
(2, 1, 'Regular', 12000),
(3, 2, 'International', 56000),
(4, 2, 'Regular', 12000),
(5, 3, 'International', 56000),
(6, 3, 'Regular', 12000),
(7, 3, 'Health Data Science', 21000),
(8, 4, 'International', 56000),
(9, 4, 'Regular', 12000),
(10, 4, 'Cooperative learning', 42000),
(11, 5, 'International', 56000),
(12, 5, 'Regular', 12000),
(13, 6, 'Regular', 12000),
(14, 6, 'Mechanical and Energy Engineering', 42000),
(15, 6, 'Automotive Engineering', 56000),
(16, 7, 'Regular', 12000),
(17, 8, 'International', 56000),
(18, 8, 'Regular', 12000),
(19, 9, 'Regular', 12000),
(20, 9, 'Co-operative Education', 12000),
(21, 9, 'Mechatronics Engineering', 12000),
(22, 10, 'Tool Engineering', 12000),
(23, 10, 'Materials Engineering', 12000),
(24, 10, 'Automotive Part Manufacturing Engineering', 56000),
(25, 11, 'Mathematics', 12000),
(26, 11, 'Statistics', 12000),
(27, 11, 'Applied Computer Science', 12000),
(28, 12, 'Chemistry', 12000),
(29, 13, 'Applied Physics (Bilingual Program)', 56000),
(30, 14, 'Microbiology', 12000),
(31, 14, 'Food Science and Technology', 12000),
(32, 15, 'Applied Computer Science-Multimedia', 12000),
(33, 16, 'Civil Engineering (5 Years Program)', 12000),
(34, 17, 'Educational Technology and Mass Communication', 12000),
(35, 18, 'Electrical Engineering (5 Years Program)', 12000),
(36, 19, 'Mechanical Engineering (5 Years Program)', 12000),
(37, 20, 'Packaging and Printing Technology', 12000),
(38, 21, 'Production Engineering (5 Years Program)', 12000),
(39, 17, 'Industrial Technology', 12000),
(40, 22, 'Computer Science (English Program)', 56000),
(41, 23, 'Information Technology', 12000),
(42, 24, 'International', 56000),
(43, 25, 'International', 56000),
(44, 26, 'International', 56000),
(45, 27, 'International', 56000),
(46, 28, 'International', 56000),
(47, 29, 'Regular', 12000),
(48, 30, 'Regular', 12000),
(49, 31, 'Regular', 12000),
(50, 32, 'Regular', 12000);

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

--
-- Table structure for table `register`
--

CREATE TABLE `register` (
  `RegisterID` bigint(20) UNSIGNED NOT NULL,
  `std_id` bigint(20) UNSIGNED NOT NULL,
  `semester` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `PayStatus` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `register`
--

INSERT INTO `register` (`RegisterID`, `std_id`, `semester`, `year`, `PayStatus`) VALUES
(28, 62070503402, 2, 2563, 0),
(29, 62070503448, 2, 2563, 0),
(30, 60030401003, 2, 2563, 0),
(31, 60030404003, 2, 2563, 0),
(32, 61030408003, 2, 2563, 0),
(33, 62070508003, 2, 2563, 0),
(34, 62070509003, 2, 2563, 0),
(35, 61030409003, 2, 2563, 0),
(36, 60030501003, 2, 2563, 0),
(39, 62070503414, 2, 2563, 1);

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

--
-- Table structure for table `registerDetail`
--

CREATE TABLE `registerDetail` (
  `RegisterID` bigint(20) UNSIGNED NOT NULL,
  `SectionNo` int(11) NOT NULL,
  `ClassCode` varchar(7) CHARACTER SET utf8 NOT NULL,
  `Grade` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registerDetail`
--

INSERT INTO `registerDetail` (`RegisterID`, `SectionNo`, `ClassCode`, `Grade`) VALUES
(28, 2, 'CPE100', '4.00'),
(29, 2, 'CPE100', '4.00'),
(30, 99, 'CPE111', NULL),
(30, 2, 'CPE121', NULL),
(30, 2, 'CPE223', NULL),
(30, 1, 'CPE231', NULL),
(30, 3, 'GEN101', NULL),
(30, 2, 'GEN111', NULL),
(31, 99, 'CPE111', NULL),
(31, 2, 'CPE121', NULL),
(31, 2, 'CPE223', NULL),
(31, 1, 'CPE231', NULL),
(31, 3, 'GEN101', NULL),
(31, 2, 'GEN111', NULL),
(32, 99, 'CPE111', NULL),
(32, 2, 'CPE121', NULL),
(32, 2, 'CPE223', NULL),
(32, 1, 'CPE231', NULL),
(32, 3, 'GEN101', NULL),
(32, 2, 'GEN111', NULL),
(33, 99, 'CPE111', NULL),
(33, 2, 'CPE121', NULL),
(33, 1, 'CPE231', NULL),
(33, 3, 'GEN101', NULL),
(33, 2, 'GEN111', NULL),
(34, 99, 'CPE111', NULL),
(34, 2, 'CPE121', NULL),
(34, 2, 'CPE223', NULL),
(34, 1, 'CPE231', NULL),
(34, 3, 'GEN101', NULL),
(34, 2, 'GEN111', NULL),
(35, 99, 'CPE111', NULL),
(35, 2, 'CPE121', NULL),
(35, 2, 'CPE223', NULL),
(35, 1, 'CPE231', NULL),
(35, 3, 'GEN101', NULL),
(35, 2, 'GEN111', NULL),
(36, 99, 'CPE111', NULL),
(36, 2, 'CPE121', NULL),
(36, 2, 'CPE223', NULL),
(36, 1, 'CPE231', NULL),
(36, 3, 'GEN101', NULL),
(36, 2, 'GEN111', NULL),
(39, 99, 'CPE111', '3.50'),
(39, 2, 'CPE121', '4.00'),
(39, 2, 'CPE223', '3.00'),
(39, 1, 'CPE231', '3.50'),
(39, 3, 'GEN101', '4.00'),
(39, 2, 'GEN111', '4.00');

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

--
-- Table structure for table `tchUser`
--

CREATE TABLE `tchUser` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `FirstName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `LastName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `BirthDate` date NOT NULL,
  `Gender` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `CitizenID` bigint(20) NOT NULL,
  `Email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Personal_email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Grad_from` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Grad_degree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `DepartmentID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tchUser`
--

INSERT INTO `tchUser` (`id`, `password`, `FirstName`, `LastName`, `BirthDate`, `Gender`, `CitizenID`, `Email`, `Personal_email`, `Grad_from`, `Grad_degree`, `DepartmentID`) VALUES
(12345, '$2y$10$9QromNBvq.3kQPTUbDZUpONf6jWPZE7og6LaVvZ7DoZyDTOOAd9X2', 'Jordan', 'Henderson', '2021-06-02', 'M', 13424414, 'jd@mail.kmutt.ac.th', 'hendo@gmail.com', 'Oxford', 'Doctor', 3),
(23988333, '$2y$10$OqKIJvkR9OPj0nhlJEs33ueQlg8yQomsv7fvPSeqSNzlxntxN0aPG', 'Jena', 'Hiyene', '1984-07-12', 'F', 9387721234, 'jena@mail.kmutt.ac.th', 'jenaZaa@hotmail.com', 'Oxford', 'Doctor', 7),
(1295820700, '$2y$10$xL6p1ACwUuUKipDcPdULD.db9fVlIEFWbHTPkwqTXT3MUNeQ9GdIK', 'Tharin', 'Glomgliang', '1975-10-20', 'M', 4929002310971, 'Tharin@mail.kmutt.ac.th', 'Tharin@gmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Master', 17),
(1473067385, '$2y$10$/nJC5zITBdlqI12G3pDm..laay9WLc7QYvYuUPudUquD9N.TicD22', 'Davin', 'Haruetai', '1964-07-13', 'M', 2431644832063, 'Davin@mail.kmutt.ac.th', 'Davin@mail.kmutt.ac.th', 'University of California, Los Angeles', 'Doctor', 11),
(1580530803, '$2y$10$OR4ki5nkG3mZ.zlRPYc9xe8rnyOVn7s28P6rt0n40ughzHb.OvVnG', 'Chanakan', 'Wronbum', '1968-05-20', 'M', 4926319790376, 'Chanakan@mail.kmutt.ac.th', 'Chanakan@hotmail.com', 'Royal Institute of Technology', 'Doctor', 27),
(2020626715, '$2y$10$/H1TrI02p1U1R1nNCpKOUOv5Z7OsRwDcPNPisSB9ipPxmImGw6WMa', 'Anissa', 'Mungman', '1976-11-25', 'F', 8716428015542, 'Anissa@mail.kmutt.ac.th', 'Anissa@hotmail.com', 'Thammasat University', 'Master', 12),
(2290495006, '$2y$10$RVNsT5vzqWZvFKFoqp2UvuYY6SN/ER2aTDaL.6kn.Bd8V8G/WArbe', 'Melyssa', 'Prempreedee', '1965-07-27', 'F', 7364712935790, 'Melyssa@mail.kmutt.ac.th', 'Melyssa@yahoo.com', 'University College London', 'Doctor', 15),
(2418554830, '$2y$10$mnwZY1PB.AY2HmHwRtotD.lGt4Ayp8gyGT3QygNdburmTVzBxJjaO', 'Darunphorn', 'Soungri', '1971-05-11', 'F', 7365718193470, 'Darunphorn@mail.kmutt.ac.th', 'Darunphorn@hotmail.com', 'Thammasart University', 'Doctor', 16),
(2573852252, '$2y$10$dl5Q4Bdd3Y1T9OSMZDiBD.RgCoea55h56UTNS2IuhvuPCh.gz5I2q', 'Akkarawin', 'Trinon', '1984-07-12', 'M', 1016660042760, 'Akkarawin@mail.kmutt.ac.th', 'Akkarawin@hotmail.com', 'Brown University', 'Doctor', 3),
(2626271766, '$2y$10$JG4tudL3UGpjCR17nNVNzexjek6ivvYf9UV591o0QjajJdNuEWQJu', 'Kanchaphon', 'Treegon', '1971-01-16', 'F', 1718602698143, 'Kanchaphon@mail.kmutt.ac.th', 'Kanchaphon@gmail.com', 'Kasetsart University', 'Bachelor', 5),
(2648111168, '$2y$10$Q.B4S85Y8n5c8yYsWucWtexMgQHQ9XVMoRGWKRrsjL67xmgQ5bDy6', 'Thanaphon', 'Doamis', '1967-04-18', 'F', 7839063280387, 'Thanaphon@mail.kmutt.ac.th', 'Thanaphon@hotmail.com', 'University of Tsukuba', 'Doctor', 4),
(2737966936, '$2y$10$ik9kWHDY2caLnqItMoe8p.juv7//o3Bz.dZY95q/swuTkOXRZsLKO', 'Kanwara', 'Kharunee', '1969-01-13', 'F', 5985384737394, 'Kanwara@mail.kmutt.ac.th', 'Kanwara@gmail.com', 'University College London', 'Doctor', 24),
(2947546786, '$2y$10$o/elupFYLQfbain4Z2sS5OrL4UaeFJXNFU6fot5/kowv6mECRmIm.', 'Kritphon', 'Mongun', '1978-08-18', 'M', 3151700364554, 'Kritphon@mail.kmutt.ac.th', 'Kritphon@gmail.com', 'Thammasat University', 'Doctor', 22),
(3265577265, '$2y$10$g4c0Z/a5lun24f1mhy..5.0GXe/xhEgithl.CakTVI3bvohU3/4gy', 'Kachasorn', 'Kagree', '1973-05-03', 'M', 7516499779944, 'Kachasorn@mail.kmutt.ac.th', 'Kachasorn@yahoo.com', 'University of Tsukuba', 'Master', 31),
(3358697266, '$2y$10$1kQsTmMaX41e7pUQ9O/Y3epD3CNdeme5lUjeg0yasGPncU6owP9yi', 'Naruechit', 'Chanmee', '1975-04-30', 'M', 1142798289696, 'Naruechit@mail.kmutt.ac.th', 'Naruechit@hotmail.com', 'Mae Fah Luang University', 'Master', 22),
(3393705434, '$2y$10$YvkM3P97OgUR804FHSN85.sxcIJcyk.8EMRgnW.pidsHuHmp00YiW', 'Kanyapach', 'Howada', '1968-03-31', 'F', 3797022964863, 'Kanyapach@mail.kmutt.ac.th', 'Kanyapach@gmail.com', 'Technical University of Denmark', 'Doctor', 11),
(3431167552, '$2y$10$WZ1jexRxX.RdFgLkUHFFfO2CIZXdiTTi3BZB/bouLNaFO0ZHBBI1W', 'Kawinthida', 'Darun', '1986-11-19', 'F', 5900624943513, 'Kawinthida@mail.kmutt.ac.th', 'Kawinthida@hotmail.com', 'Chulalongkorn University', 'Master', 23),
(3601392723, '$2y$10$WeXZUvR5MXDNn2.fxSw5deiE1H4PsbV16gK5nibumMBzPs5.E0D6S', 'Nathaporn', 'Donsan', '1970-11-11', 'F', 3560943075307, 'Nathaporn@mail.kmutt.ac.th', 'Nathaporn@hotmail.com', 'King Mongkut\'s Institute of Technology Ladkrabang', 'Master', 28),
(4140069633, '$2y$10$6bPFzyAunRA4OizWUAW72eqVLM1nF46cQrs9endb6c3FGKb3tCnLC', 'Phakkawat', 'Wanboon', '1973-02-14', 'M', 8633723145812, 'Phakkawat@mail.kmutt.ac.th', 'Phakkawat@gmail.com', 'Carnegie Mellon University', 'Doctor', 5),
(4181277143, '$2y$10$Ke4Ey9I/hNJPH1dAqJ2PvOSRbnFmxpmXPn4u6QdgOzFjOl.jvkPn2', 'Thanita', 'Boonma', '1967-09-15', 'F', 4040865304753, 'Thanita@mail.kmutt.ac.th', 'Thanita@hotmail.com', 'Chiang Mai University', 'Doctor', 18),
(4703750162, '$2y$10$OdnB9C5ppI3BfZhgz65FhuEEQsSPktc.4y09NkUpMDvnoaV9FC4nG', 'Monphorn', 'Rakkarakrit', '1967-03-10', 'F', 5037265022138, 'Monphorn@mail.kmutt.ac.th', 'Monphorn@hotmail.com', 'University College London', 'Doctor', 6),
(4727233431, '$2y$10$vvzKB1ocw2hj7EZGHkitE.JZJss9bHXhzw4yS9662XHJ3.K9Lj1h6', 'Thanin', 'Mongkon', '1964-05-25', 'M', 1610073745286, 'Thanin@mail.kmutt.ac.th', 'Thanin@gmail.com', 'King Mongkut\'s Institute of Technology Ladkrabang', 'Doctor', 13),
(4811488498, '$2y$10$8ohuHfeBhSgZ7OGrMBCH5egLoMbOk8tyuv5DcJaPvzkoMfFRpxOL6', 'Jarukorn', 'Thingthim', '1980-12-15', 'M', 5845872540848, 'Jarukorn@mail.kmutt.ac.th', 'Jarukorn@hotmail.com', 'Technical University of Denmark', 'Doctor', 20),
(4880653762, '$2y$10$fPhvFw4kXPNy50C8SLlwaehysoCQTy6Zj.sNcVLVL5tCjPEy1zGfq', 'Narawitch', 'Mongkon', '1966-08-26', 'M', 5053017061483, 'Narawitch@mail.kmutt.ac.th', 'Narawitch@gmail.com', 'Columbia University', 'Doctor', 22),
(4923116824, '$2y$10$lVxhPMfJs8RdkXMP/w2gBu/60QxmEyUXbBKDRzVB4WuqEOcB7xWUu', 'Ananda', 'Sukkasem', '1985-12-18', 'M', 2492335840561, 'Ananda@mail.kmutt.ac.th', 'Ananda@gmail.com', 'University of Tokyo', 'Bachelor', 10),
(4954770857, '$2y$10$cafwPUgzLM3dXDjZ16IvcOwhptf12VtKZEV7Pj4oiJWaSv9eHBBCm', 'Natthinee', 'Marin', '1989-04-14', 'F', 6877412345505, 'Natthinee@mail.kmutt.ac.th', 'Natthinee@hotmail.com', 'Chulalongkorn University', 'Master', 19),
(5059767071, '$2y$10$NQhM5Rv3F4AF9lC7ku/2TexP9dTbpVzI8k4tY1ZCdlMVk4pQ.WAJK', 'Surasak', 'Kanwee', '1969-04-01', 'M', 4082662325013, 'surasak@mail.kmutt.ac.th', 'surasak@gmail.com', 'Harvard University', 'Doctor', 1),
(5194678540, '$2y$10$.UXwaA3j4USLbFTHMurxquOa6IlM8oFjLAJo3rMcXP5bYFJAHrXQ.', 'Chawakorn', 'Rangun', '1977-05-17', 'O', 3908255788143, 'Chawakorn@mail.kmutt.ac.th', 'Chawakorn@yahoo.com', 'Kasetsart University', 'Master', 3),
(5315406218, '$2y$10$2a5tJJQNMoZc4O.hw9B4fej7n.ubAUfxiZkBXHZ8AmSJF4ZElBMma', 'Samarn', 'Susom', '1979-07-24', 'M', 6142364163744, 'Samarn@mail.kmutt.ac.th', 'Samarn@gmail.com', 'Carnegie Mellon University', 'Master', 3),
(5340646617, '$2y$10$aQ9TrHiObmXs9m11/IciM.WXTYaQ4XfTz4t7hJDzq3zCLOIvcQQNq', 'Sudee', 'Srisook', '1976-02-23', 'M', 5517271821909, 'sudee@mail.kmutt.ac.th', 'sudee@gmail.com', 'Stanford University', 'Doctor', 2),
(5381704530, '$2y$10$boEAolg3KuzVQ2Geubi5s.zGrmjS0Ob90W6I48IqS9ZDXZfnQoW/S', 'Kanokpitch', 'Kounong', '1982-09-21', 'F', 3444553094342, 'Kanokpitch@mail.kmutt.ac.th', 'Kanokpitch@gmail.com', 'Laval University', 'Master', 32),
(5387889394, '$2y$10$FbyHjBA/gOubLlxSOg5g.O/d4J1G/vjlmBukXTuspcGXXLzUi1fia', 'Kanyakorn', 'Thamnee', '1986-09-12', 'F', 7569991275787, 'Kanyakorn@mail.kmutt.ac.th', 'Kanyakorn@hotmail.com', 'Stanford University', 'Doctor', 3),
(5465055146, '$2y$10$.7U8JZzn2EAslAwNtmHDR.TUpqnqyEGJ8sCV3IuyZ6WNmd4YMz.ga', 'Jantharat', 'Oakprem', '1981-07-07', 'F', 2439067049046, 'Jantharat@mail.kmutt.ac.th', 'Jantharat@gmail.com', 'Indian Institute of Technology, Delhi', 'Master', 8),
(5674534025, '$2y$10$/rUBQT7GlqSO/uJQIPvlcOKrfPF5WyJyzoXy/2CQsEZ.Uj2h3nQ82', 'Kankorn', 'Gunarch', '1980-07-25', 'M', 6358693144087, 'Kankorn@mail.kmutt.ac.th', 'Kankorn@hotmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Master', 1),
(5824873127, '$2y$10$aaFhKFYDoDXlEmmsw1An2uUcakoVAPqvGdeErl.v6ATEBXI/AgIRe', 'Darin', 'Romjan', '1987-10-18', 'F', 9462912616680, 'Darin@mail.kmutt.ac.th', 'Darin@hotmail.com', 'Chiang Mai University', 'Master', 13),
(6003143048, '$2y$10$I.bxsk1BR46OS3ZO06mK/uWqLP/JJdcA8.2RbYGXhhXee2Qp98ghi', 'Korrawee', 'Rakcharernmon', '1963-09-21', 'F', 2385030634519, 'Korrawee@mail.kmutt.ac.th', 'Korrawee@gmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Bachelor', 3),
(6191984359, '$2y$10$.DHqaXZhTxcInI4N1fGxbObUkcT51IyGusE36b/t9z8wacMXNSvKC', 'Rongruetum', 'Srisai', '1971-06-28', 'M', 4776135291145, 'Rongruetum@mail.kmutt.ac.th', 'Rongruetuma@gmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Bachelor', 8),
(6456243333, '$2y$10$CR1.a9/CL2GmUbbw/eBXeu2J3ZAQcCUMQtYylU3Vz9DYe0YFMFCRS', 'Rongrueng', 'Sirimahaprom', '1981-06-03', 'M', 5557545528549, 'Rongrueng@mail.kmutt.ac.th', 'Rongrueng@gmail.com', 'Thammasat University', 'Master', 9),
(6486726257, '$2y$10$2qv2dmoXK9iqNRpdC2wEQ.6Iz44b8XOt/TbMZRkkh4Osaps.sQK/m', 'Jakkarachai', 'Bhunmee', '1976-03-22', 'M', 4531279967590, 'Jakkarachai@mail.kmutt.ac.th', 'Jakkarachai@gmail.com', 'Stanford University', 'Doctor', 26),
(6910179474, '$2y$10$Xxugekx5zy0FepTBoFStOeA7IuSjsvqCn2n4weYW7JsoNM.JlotwG', 'Radee', 'Bhrummi', '1989-01-19', 'F', 2648312155293, 'Radee@mail.kmutt.ac.th', 'Radee@hotmail.com', 'Mahidol University', 'Master', 3),
(6911426492, '$2y$10$YwEQznUL5kBeSzrfyuiP/ebFJUcPgwfnTiVHjEzl0YuAUco9lJY6a', 'Kirida', 'Chiranyu', '1986-06-30', 'F', 5994613835103, 'Kirida@mail.kmutt.ac.th', 'Kirida@hotmail.com', 'Chulalongkorn University', 'Doctor', 4),
(6916501495, '$2y$10$QxMT0hNF.AmCOR8RuA2T8.ocFhz4bnqpH49qTJVMTAURWJPnOC5n.', 'Supisa', 'Wrirai', '1987-08-26', 'O', 2688710211774, 'Supisa@mail.kmutt.ac.th', 'Supisa@gmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Bachelor', 3),
(6983479536, '$2y$10$XDzCPA83TmGHHS77AZMmSeqxSCYHEP/aexLskx3NegQyj1mKJbEWG', 'Nutwarun', 'Trinsan', '1984-04-27', 'F', 5853862263538, 'Nutwarun@mail.kmutt.ac.th', 'Nutwarun@gmail.com', 'Mahidol University', 'Master', 26),
(7128781178, '$2y$10$xtt6jdr5nBOEU0guQ02ypuwEFuZ.lZuKfNcM/BDEJ22nKaDqggDPy', 'Sukrit', 'Maneeroj', '1979-11-11', 'M', 8093386996421, 'Sukrit@mail.kmutt.ac.th', 'Sukrit@gmail.com', 'Wuhan University', 'Doctor', 3),
(7428493586, '$2y$10$xcvM7JdgeR1inH5XBvx4he3V5EtHxccwZPbdDvT5CajO2wYC.cXe.', 'Alisa', 'Rungrat', '1987-05-05', 'F', 4610419306899, 'Alisa@mail.kmutt.ac.th', 'Alisa@gmail.com', 'New York University', 'Master', 7),
(7496136414, '$2y$10$lISN6qcw0OdEEeNtJyoSmeTDUPkGFswN2iafH.ZidmVHIuIkg7Sr.', 'Thatpicha', 'Rakawin', '1975-10-21', 'F', 3622435991523, 'Thatpicha@mail.kmutt.ac.th', 'Thatpicha@hotmail.com', 'Kasetsart University', 'Doctor', 21),
(7715392902, '$2y$10$J1BLzC7/N5OIBC/g60RPtu9UYHybOZv0BauLj4BDaS4BnfWySfEcC', 'Chawakorn', 'Kiusta', '1965-10-09', 'M', 3310591672701, 'Chawakorn@mail.kmutt.ac.th', 'Chawakorn@gmail.com', 'University of Florida', 'Doctor', 30),
(7899297823, '$2y$10$OiyFgf6Tz9eCWmq/dez06eWFGS6dJmeGmrFINDRn92J2gzLdDLEFa', 'Thanchanok', 'Nondree', '1987-09-17', 'F', 9347722725025, 'Thanchanok@mail.kmutt.ac.th', 'Thanchanok@gmail.com', 'University of Cambridge', 'Bachelor', 28),
(7937809989, '$2y$10$LX1x3SfxR9fVNv49g2X10u1XegNOcQc/CIaEaCQPuvQZ6.memWAvW', 'Jakkrit', 'Waramai', '1985-07-12', 'M', 2108556742018, 'Jakkrit@mail.kmutt.ac.th', 'Jakkrit@gmail.com', 'Chulalongkorn University', 'Bachelor', 3),
(8167235011, '$2y$10$tMqzBjQ7usdgu3TprOPRXepShSqWKTkZ3JZipXgw33idomTy/6A02', 'Kathleen', 'Prakobkit', '1974-06-04', 'F', 4246467089115, 'Kethleen@mail.kmutt.ac.th', 'Kathleen@hotmail.com', 'King Mongkut\'s Institute of Technology Ladkrabang', 'Doctor', 14),
(8462599907, '$2y$10$1Z0vCc9XZxzWaaUrNXseAeyxsweUyEpJq9SokelAliF3ckGWfRUM2', 'Yahatai', 'Gondaran', '1987-06-28', 'F', 7751211795625, 'Yahatai@mail.kmutt.ac.th', 'Yahatai@gmail.com', 'Chulalongkorn University', 'Bachelor', 33),
(8685273146, '$2y$10$4ZauhwpIegGedMy86QwVAe4zQRR6hHZmzrFsCKYfIBMnOGuVdbFEm', 'Chawanlak', 'Loknong', '1969-04-25', 'F', 3591441755451, 'Chawanlak@mail.kmutt.ac.th', 'Chawanlak@gmail.com', 'Chulalongkorn University', 'Doctor', 33),
(8850859747, '$2y$10$2dNnsQCww8W4p527CciFLuwAnosSORDwRyX36uZCUIA87XX0oinx6', 'Kornpak', 'Panna', '1982-12-16', 'M', 5537427228945, 'Kornpak@mail.kmutt.ac.th', 'Kornpak@gmail.com', 'Thammasat University', 'Master', 29),
(8966142542, '$2y$10$nTTmYzZoVkquTfytLWbli.pPOgFFn//S48dOC0N1aXC8mBpof5HXO', 'Nisrine', 'Nongruk', '1988-12-31', 'F', 9355335346238, 'Nisrine@mail.kmutt.ac.th', 'Nisrine@yahoo.com', 'Boston University', 'Bachelor', 16),
(9099218755, '$2y$10$GXRyuVfKZ6DjG8JfaquN6uHlZ/wSIHDjPn1eNPCOa8W70vVWTYibS', 'Dechatorn', 'Fonnarin', '1976-08-21', 'M', 1075365250138, 'Dechatorn@mail.kmutt.ac.th', 'Dechatorn@gmail.com', 'King Mongkut\'s University of Technology North Bangkok', 'Master', 24),
(9570279803, '$2y$10$1aELsabaRkxDWcUejsdcV.1BpiYJt7K1pmWAXmUuXbHuqs94k9ZbS', 'Konrapee', 'Tongoru', '1974-05-23', 'M', 3803431405556, 'Konrapee@mail.kmutt.ac.th', 'Konrapee@gmail.com', 'King Mongkut\'s University of Technology North Bangkok', 'Master', 33),
(9586309017, '$2y$10$fvi7zB7jCfho6phjKn0Lmed1r3Jr.U0v2Z0GklyZI0RY.4zVYc.Jq', 'Chayathorn', 'Boongorn', '1989-08-16', 'M', 5997337998723, 'Chayathorn@mail.kmutt.ac.th', 'Chayathorn@gmail.com', 'King Mongkut\'s University of Technology Thonburi', 'Master', 25),
(9639746381, '$2y$10$e8VmlbLG6W3KES8ivpV8.urPhUrWgME21g.OIsk1dHehaxBeHuOHG', 'Nattawut', 'Premsak', '1976-10-16', 'M', 5918038607025, 'Nattawut@mail.kmutt.ac.th', 'Nattawut@gmail.com', 'China Agricultural University', 'Master', 3);

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

--
-- Table structure for table `TeacherInClass`
--

CREATE TABLE `TeacherInClass` (
  `SectionNo` int(11) NOT NULL,
  `ClassCode` varchar(7) CHARACTER SET utf8 NOT NULL,
  `tchID` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `TeacherInClass`
--

INSERT INTO `TeacherInClass` (`SectionNo`, `ClassCode`, `tchID`) VALUES
(1, 'CPE121', 12345),
(1, 'CPE231', 5059767071),
(1, 'CPE231', 5387889394),
(2, 'CPE121', 12345),
(2, 'CPE121', 5059767071),
(2, 'CPE223', 5059767071),
(2, 'CPE231', 5387889394),
(2, 'GEN101', 8685273146),
(2, 'GEN111', 9570279803),
(3, 'GEN101', 8685273146),
(99, 'CPE111', 12345);

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

--
-- Table structure for table `timetable`
--

CREATE TABLE `timetable` (
  `ClassCode` varchar(7) CHARACTER SET utf8 NOT NULL,
  `SectionNo` int(11) NOT NULL,
  `Day` varchar(5) CHARACTER SET utf8 NOT NULL,
  `TimeStart` time NOT NULL,
  `TimeEnd` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `timetable`
--

INSERT INTO `timetable` (`ClassCode`, `SectionNo`, `Day`, `TimeStart`, `TimeEnd`) VALUES
('ANI220', 1, 'Mon', '13:30:00', '15:30:00'),
('ANI221', 1, 'Mon', '16:30:00', '18:30:00'),
('APE111', 1, 'Mon', '08:30:00', '09:30:00'),
('APE111', 1, 'Tue', '08:30:00', '10:30:00'),
('APE121', 1, 'Thu', '14:30:00', '17:30:00'),
('APE121', 1, 'Tue', '13:30:00', '15:30:00'),
('APE211', 1, 'Mon', '09:30:00', '12:30:00'),
('APE231', 1, 'Wed', '09:30:00', '12:30:00'),
('APE241', 1, 'Fri', '08:30:00', '10:30:00'),
('APE321', 1, 'Thu', '08:30:00', '10:30:00'),
('APE321', 1, 'Wed', '15:30:00', '18:30:00'),
('APE324', 1, 'Thu', '13:30:00', '16:30:00'),
('APE443', 1, 'Fri', '13:30:00', '16:30:00'),
('APE447', 1, 'Wed', '12:30:00', '15:30:00'),
('APE471', 1, 'Sun', '09:30:00', '12:30:00'),
('ARC115', 1, 'Mon', '08:30:00', '10:30:00'),
('ARC117', 1, 'Mon', '10:30:00', '12:30:00'),
('ARC226', 1, 'Tue', '09:30:00', '12:30:00'),
('ARC241', 1, 'Tue', '13:30:00', '15:30:00'),
('ARC343', 1, 'Wed', '13:30:00', '16:30:00'),
('ARC354', 1, 'Thu', '08:30:00', '10:30:00'),
('ARC445', 1, 'Thu', '10:30:00', '11:30:00'),
('ARC494', 1, 'Thu', '13:30:00', '15:30:00'),
('ARC501', 1, 'Fri', '08:30:00', '10:30:00'),
('ARC591', 1, 'Fri', '10:30:00', '12:30:00'),
('CHE100', 1, 'Mon', '13:30:00', '15:00:00'),
('CHE210', 1, 'Mon', '08:30:00', '11:30:00'),
('CHE231', 1, 'Fri', '09:00:00', '13:00:00'),
('CHE241', 1, 'Wed', '13:30:00', '16:30:00'),
('CHE334', 1, 'Wed', '13:30:00', '17:30:00'),
('CHE343', 1, 'Tue', '09:30:00', '12:30:00'),
('CHE451', 1, 'Fri', '13:30:00', '16:30:00'),
('CHE471', 1, 'Thu', '13:30:00', '16:30:00'),
('CHE473', 1, 'Sat', '08:30:00', '11:30:00'),
('CHE482', 1, 'Wed', '16:30:00', '19:30:00'),
('CHE483', 1, 'Sat', '13:30:00', '16:30:00'),
('CHE484', 1, 'Wed', '08:30:00', '11:30:00'),
('CHE494', 1, 'Fri', '13:30:00', '17:30:00'),
('CHHD101', 1, 'Wed', '13:30:00', '16:30:00'),
('CHHD201', 1, 'Wed', '13:30:00', '16:30:00'),
('CHHD202', 1, 'Wed', '09:30:00', '12:30:00'),
('CHHD307', 1, 'Wed', '09:30:00', '12:30:00'),
('CHHD308', 1, 'Wed', '09:30:00', '12:30:00'),
('CHM101', 1, 'Mon', '13:30:00', '15:30:00'),
('CHM101', 1, 'Wed', '09:30:00', '11:30:00'),
('CHM103', 1, 'Fri', '08:30:00', '09:30:00'),
('CHM103', 1, 'Mon', '15:30:00', '13:30:00'),
('CHM160', 1, 'Tue', '08:30:00', '11:30:00'),
('CHM212', 1, 'Thu', '08:30:00', '10:30:00'),
('CHM214', 1, 'Thu', '10:30:00', '12:30:00'),
('CHM214', 1, 'Wed', '08:30:00', '09:30:00'),
('CHM215', 1, 'Tue', '09:30:00', '12:30:00'),
('CHM321', 1, 'Mon', '08:30:00', '10:30:00'),
('CHM332', 1, 'Fri', '15:30:00', '16:30:00'),
('CHM332', 1, 'Mon', '15:30:00', '16:30:00'),
('CHM332', 1, 'Wed', '11:30:00', '12:30:00'),
('CHM341', 1, 'Fri', '08:30:00', '10:30:00'),
('CHM341', 1, 'Wed', '11:30:00', '12:30:00'),
('CHM451', 1, 'Wed', '09:30:00', '10:30:00'),
('CHM495', 1, 'Mon', '17:30:00', '18:30:00'),
('CMD111', 1, 'Tue', '08:00:00', '10:00:00'),
('CMD212', 1, 'Mon', '08:30:00', '10:30:00'),
('CMD222', 1, 'Mon', '13:30:00', '15:30:00'),
('CMD314', 1, 'Tue', '13:30:00', '16:30:00'),
('CMD325', 1, 'Wed', '08:30:00', '10:30:00'),
('CMD401', 1, 'Thu', '13:30:00', '15:30:00'),
('CMD453', 1, 'Fri', '09:30:00', '12:30:00'),
('CMM110', 1, 'Fri', '09:30:00', '12:30:00'),
('CMM110', 1, 'Tue', '13:30:00', '18:30:00'),
('CMM133', 1, 'Wed', '13:30:00', '15:30:00'),
('CMM134', 1, 'Thu', '13:30:00', '16:30:00'),
('CMM210', 1, 'Thu', '15:30:00', '19:30:00'),
('CMM211', 1, 'Mon', '08:30:00', '11:30:00'),
('CMM215', 1, 'Thu', '08:30:00', '13:30:00'),
('CMM331', 1, 'Wed', '08:30:00', '10:30:00'),
('CMM332', 1, 'Tue', '13:30:00', '15:30:00'),
('CMM421', 1, 'Wed', '08:30:00', '11:30:00'),
('CMM463', 1, 'Tue', '13:00:00', '15:00:00'),
('CPE100', 1, 'Fri', '10:30:00', '12:30:00'),
('CPE100', 1, 'Thu', '08:30:00', '10:30:00'),
('CPE101', 1, 'Mon', '13:30:00', '15:30:00'),
('CPE102', 1, 'Thu', '08:30:00', '10:30:00'),
('CPE103', 1, 'Tue', '08:30:00', '10:30:00'),
('CPE121', 1, 'Wed', '08:30:00', '10:30:00'),
('CPE212', 1, 'Wed', '13:30:00', '17:30:00'),
('CPE223', 1, 'Thu', '10:30:00', '12:30:00'),
('CPE223', 1, 'Wed', '08:30:00', '10:30:00'),
('CPE231', 1, 'Mon', '13:30:00', '15:30:00'),
('CPE315', 1, 'Tue', '08:30:00', '12:30:00'),
('CPE326', 1, 'Mon', '13:30:00', '15:30:00'),
('CPE326', 1, 'Wed', '08:30:00', '10:30:00'),
('CPE327', 1, 'Mon', '10:30:00', '12:30:00'),
('CPE327', 1, 'Wed', '13:30:00', '15:30:00'),
('CPE332', 1, 'Tue', '18:00:00', '19:00:00'),
('CPE342', 1, 'Fri', '16:30:00', '19:30:00'),
('CPE352', 1, 'Mon', '13:30:00', '16:30:00'),
('CPE353', 1, 'Thu', '09:00:00', '12:00:00'),
('CPE374', 1, 'Thu', '09:30:00', '12:30:00'),
('CPE376', 1, 'Wed', '16:30:00', '20:30:00'),
('CPE381', 1, 'Wed', '09:00:00', '12:00:00'),
('CPE383', 1, 'Thu', '13:00:00', '16:00:00'),
('CPE393', 1, 'Tue', '09:30:00', '12:30:00'),
('CPE401', 1, 'Mon', '13:30:00', '15:30:00'),
('CPE467', 1, 'Thu', '13:30:00', '16:30:00'),
('CPE494', 1, 'Fri', '13:30:00', '16:30:00'),
('CSC101', 1, 'Mon', '13:30:00', '16:30:00'),
('CSC102', 1, 'Tue', '08:30:00', '10:30:00'),
('CSC210', 1, 'Wed', '13:30:00', '15:30:00'),
('CSC213', 1, 'Thu', '08:30:00', '10:30:00'),
('CSC319', 1, 'Thu', '13:30:00', '15:30:00'),
('CSC340', 1, 'Fri', '09:30:00', '12:30:00'),
('CSC490', 1, 'Fri', '13:30:00', '15:30:00'),
('CSS111', 1, 'Wed', '09:00:00', '12:00:00'),
('CSS112', 1, 'Thu', '08:30:00', '12:30:00'),
('CSS113', 1, 'Wed', '09:00:00', '12:00:00'),
('CSS114', 1, 'Tue', '08:30:00', '12:30:00'),
('CSS222', 1, 'Sat', '08:30:00', '12:30:00'),
('CSS223', 1, 'Thu', '09:30:00', '12:30:00'),
('CSS225', 1, 'Fri', '08:30:00', '12:30:00'),
('CSS321', 1, 'Mon', '09:00:00', '12:00:00'),
('CSS331', 1, 'Tue', '13:30:00', '16:30:00'),
('CSS341', 1, 'Fri', '09:00:00', '12:00:00'),
('CSS361', 1, 'Wed', '09:30:00', '12:30:00'),
('CSS421', 1, 'Fri', '13:30:00', '16:30:00'),
('CSS422', 1, 'Tue', '13:30:00', '16:30:00'),
('CSS461', 1, 'Tue', '09:00:00', '12:00:00'),
('CTE111', 1, 'Fri', '08:30:00', '13:30:00'),
('CTE112', 1, 'Wed', '13:30:00', '18:30:00'),
('CTE212', 1, 'Mon', '13:30:00', '18:30:00'),
('CTE220', 1, 'Fri', '14:30:00', '16:30:00'),
('CTE220', 1, 'Thu', '13:30:00', '16:30:00'),
('CTE241', 1, 'Fri', '08:30:00', '11:30:00'),
('CTE242', 1, 'Fri', '13:30:00', '16:30:00'),
('CTE304', 1, 'Thu', '14:30:00', '19:30:00'),
('CTE321', 1, 'Wed', '16:30:00', '20:30:00'),
('CTE322', 1, 'Wed', '08:30:00', '11:30:00'),
('CVE100', 1, 'Fri', '16:30:00', '18:30:00'),
('CVE100', 1, 'Wed', '13:30:00', '16:30:00'),
('CVE111', 1, 'Fri', '10:30:00', '12:30:00'),
('CVE111', 1, 'Mon', '13:30:00', '16:30:00'),
('CVE112', 1, 'Fri', '08:30:00', '11:30:00'),
('CVE221', 1, 'Fri', '12:30:00', '15:30:00'),
('CVE223', 1, 'Thu', '08:30:00', '10:30:00'),
('CVE232', 1, 'Mon', '08:30:00', '11:30:00'),
('CVE233', 1, 'Mon', '12:30:00', '14:30:00'),
('CVE233', 1, 'Thu', '12:30:00', '14:30:00'),
('CVE336', 1, 'Mon', '14:30:00', '17:30:00'),
('CVE338', 1, 'Wed', '08:30:00', '11:30:00'),
('CVE362', 1, 'Tue', '10:30:00', '12:30:00'),
('CVE363', 1, 'Tue', '14:30:00', '17:30:00'),
('CVE385', 1, 'Mon', '09:30:00', '12:30:00'),
('CVE394', 1, 'Tue', '09:30:00', '12:30:00'),
('CVE401', 1, 'Sat', '16:30:00', '19:30:00'),
('CVE414', 1, 'Fri', '09:30:00', '12:30:00'),
('CVE415', 1, 'Wed', '09:30:00', '12:30:00'),
('CVE448', 1, 'Mon', '09:30:00', '12:30:00'),
('DIP101', 1, 'Tue', '18:00:00', '19:00:00'),
('DIP111', 1, 'Mon', '08:30:00', '10:30:00'),
('DIP201', 1, 'Mon', '13:30:00', '15:30:00'),
('DIP211', 1, 'Tue', '13:30:00', '16:30:00'),
('DIP301', 1, 'Wed', '08:30:00', '10:30:00'),
('DIP311', 1, 'Thu', '13:30:00', '15:30:00'),
('DIP401', 1, 'Fri', '09:30:00', '12:30:00'),
('DIP431', 1, 'Fri', '13:30:00', '15:30:00'),
('ECE101', 1, 'Mon', '16:30:00', '20:30:00'),
('ECE260', 1, 'Tue', '16:30:00', '19:30:00'),
('ECE302', 1, 'Mon', '10:30:00', '13:30:00'),
('ECE386', 1, 'Wed', '13:30:00', '17:30:00'),
('ECE441', 1, 'Mon', '09:30:00', '12:30:00'),
('EEE100', 1, 'Tue', '09:30:00', '12:30:00'),
('EEE102', 1, 'Wed', '09:30:00', '12:30:00'),
('EEE111', 1, 'Fri', '09:30:00', '12:30:00'),
('EEE190', 1, 'Sat', '09:30:00', '12:30:00'),
('EEE260', 1, 'Fri', '13:30:00', '16:30:00'),
('EEE270', 1, 'Wed', '13:30:00', '16:30:00'),
('EEE321', 1, 'Fri', '09:30:00', '12:30:00'),
('EEE322', 1, 'Mon', '13:30:00', '16:30:00'),
('EEE361', 1, 'Mon', '13:30:00', '16:30:00'),
('EEE380', 1, 'Wed', '08:30:00', '11:30:00'),
('EEE401', 1, 'Wed', '13:30:00', '16:30:00'),
('EEE402', 1, 'Tue', '13:30:00', '16:30:00'),
('EEE424', 1, 'Tue', '09:30:00', '12:30:00'),
('ENV210', 1, 'Wed', '09:30:00', '11:30:00'),
('ENV213', 1, 'Thu', '12:30:00', '14:30:00'),
('ENV213', 1, 'Tue', '13:30:00', '16:30:00'),
('ENV341', 1, 'Thu', '13:30:00', '16:30:00'),
('ENV344', 1, 'Wed', '13:30:00', '16:30:00'),
('ENV401', 1, 'Thu', '12:30:00', '13:30:00'),
('ENV401', 1, 'Tue', '12:30:00', '13:30:00'),
('ENV401', 1, 'Wed', '12:30:00', '13:30:00'),
('ENV434', 1, 'Thu', '13:30:00', '16:30:00'),
('ENV442', 1, 'Tue', '13:30:00', '16:30:00'),
('ENV451', 1, 'Thu', '09:30:00', '12:30:00'),
('EPE200', 1, 'Tue', '13:30:00', '16:30:00'),
('ETM101', 1, 'Tue', '08:30:00', '11:30:00'),
('ETM102', 1, 'Mon', '08:30:00', '12:30:00'),
('ETM103', 1, 'Wed', '13:30:00', '17:30:00'),
('ETM104', 1, 'Wed', '08:30:00', '11:30:00'),
('ETM202', 1, 'Fri', '13:30:00', '16:30:00'),
('ETM211', 1, 'Thu', '13:30:00', '16:30:00'),
('ETM312', 1, 'Wed', '09:30:00', '12:30:00'),
('ETM361', 1, 'Wed', '13:30:00', '17:30:00'),
('ETM472', 1, 'Tue', '17:30:00', '19:30:00'),
('FMI220', 1, 'Mon', '08:30:00', '10:30:00'),
('FMI221', 1, 'Tue', '09:30:00', '12:30:00'),
('FMI350', 1, 'Thu', '08:30:00', '11:30:00'),
('FRA121', 1, 'Mon', '08:30:00', '10:30:00'),
('FRA141', 1, 'Tue', '08:30:00', '10:30:00'),
('FRA142', 1, 'Wed', '08:30:00', '10:30:00'),
('FRA261', 1, 'Mon', '10:30:00', '12:30:00'),
('FRA262', 1, 'Mon', '13:30:00', '15:30:00'),
('FRA300', 1, 'Wed', '13:30:00', '15:30:00'),
('FRA321', 1, 'Thu', '08:30:00', '10:30:00'),
('FRA451', 1, 'Fri', '09:30:00', '12:30:00'),
('FRA452', 1, 'Wed', '08:30:00', '10:30:00'),
('FST311', 1, 'Mon', '13:30:00', '15:30:00'),
('FST331', 1, 'Thu', '09:30:00', '12:30:00'),
('FST341', 1, 'Mon', '10:30:00', '12:30:00'),
('FST471', 1, 'Sat', '09:30:00', '12:30:00'),
('FST481', 1, 'Tue', '09:30:00', '12:30:00'),
('GEN101', 1, 'Mon', '08:30:00', '10:30:00'),
('GEN111', 1, 'Tue', '08:30:00', '11:30:00'),
('GEN121', 1, 'Tue', '08:30:00', '11:30:00'),
('GEN201', 1, 'Tue', '13:30:00', '16:30:00'),
('GEN211', 1, 'Wed', '08:30:00', '11:30:00'),
('GEN223', 1, 'Wed', '13:30:00', '16:30:00'),
('GEN224', 1, 'Mon', '08:30:00', '11:30:00'),
('GEN231', 1, 'Tue', '10:30:00', '13:30:00'),
('GEN232', 1, 'Sun', '12:30:00', '15:30:00'),
('GEN241', 1, 'Wed', '09:30:00', '12:30:00'),
('GEN242', 1, 'Sat', '09:30:00', '12:30:00'),
('GEN301', 1, 'Sat', '09:00:00', '12:00:00'),
('GEN311', 1, 'Sat', '09:30:00', '12:30:00'),
('GEN321', 1, 'Mon', '08:30:00', '11:30:00'),
('GEN331', 1, 'Thu', '13:30:00', '16:30:00'),
('GEN341', 1, 'Tue', '13:30:00', '16:30:00'),
('GEN351', 1, 'Wed', '08:30:00', '11:30:00'),
('GEN352', 1, 'Fri', '09:30:00', '12:30:00'),
('GEN353', 1, 'Tue', '08:30:00', '11:30:00'),
('GEN411', 1, 'Mon', '08:30:00', '12:30:00'),
('GEN412', 1, 'Mon', '08:30:00', '11:30:00'),
('GEN421', 1, 'Tue', '13:30:00', '16:30:00'),
('GEN441', 1, 'Mon', '09:30:00', '13:30:00'),
('GRD220', 1, 'Fri', '08:30:00', '10:30:00'),
('GRD221', 1, 'Wed', '13:30:00', '15:30:00'),
('INA211', 1, 'Tue', '18:00:00', '19:00:00'),
('INA241', 1, 'Mon', '08:30:00', '10:30:00'),
('INA242', 1, 'Mon', '13:30:00', '15:30:00'),
('INA435', 1, 'Tue', '13:30:00', '16:30:00'),
('INA445', 1, 'Wed', '08:30:00', '10:30:00'),
('INA446', 1, 'Thu', '13:30:00', '15:30:00'),
('INA464', 1, 'Fri', '09:30:00', '12:30:00'),
('INC102', 1, 'Tue', '10:30:00', '12:30:00'),
('INC102', 1, 'Wed', '13:30:00', '16:30:00'),
('INC111', 1, 'Sat', '13:00:00', '16:30:00'),
('INC121', 1, 'Thu', '10:30:00', '12:30:00'),
('INC171', 1, 'Mon', '13:30:00', '17:30:00'),
('INC221', 1, 'Thu', '13:30:00', '16:30:00'),
('INC222', 1, 'Fri', '09:30:00', '12:30:00'),
('INC331', 1, 'Tue', '13:30:00', '17:30:00'),
('INC401', 1, 'Mon', '13:30:00', '16:30:00'),
('INC402', 1, 'Tue', '13:30:00', '16:30:00'),
('INC403', 1, 'Wed', '13:30:00', '16:30:00'),
('INT100', 1, 'Mon', '08:30:00', '10:30:00'),
('INT101', 1, 'Mon', '13:30:00', '15:30:00'),
('INT201', 1, 'Tue', '08:30:00', '10:30:00'),
('INT202', 1, 'Tue', '14:30:00', '16:30:00'),
('INT308', 1, 'Thu', '08:30:00', '10:30:00'),
('INT319', 1, 'Thu', '13:30:00', '15:30:00'),
('INT366', 1, 'Fri', '13:30:00', '15:30:00'),
('LAN225', 1, 'Tue', '08:00:00', '10:00:00'),
('LAN241', 1, 'Mon', '08:30:00', '10:30:00'),
('LAN252', 1, 'Mon', '13:30:00', '15:30:00'),
('LAN332', 1, 'Tue', '13:30:00', '16:30:00'),
('LAN353', 1, 'Wed', '08:30:00', '10:30:00'),
('LAN445', 1, 'Thu', '13:30:00', '15:30:00'),
('LAN482', 1, 'Fri', '09:30:00', '12:30:00'),
('LAN501', 1, 'Thu', '16:30:00', '18:30:00'),
('LAN594', 1, 'Fri', '13:30:00', '15:30:00'),
('MDA110', 1, 'Tue', '13:30:00', '15:30:00'),
('MDA112', 1, 'Wed', '16:30:00', '17:30:00'),
('MDT110', 1, 'Mon', '08:30:00', '10:30:00'),
('MDT111', 1, 'Mon', '10:30:00', '12:30:00'),
('MDT210', 1, 'Mon', '13:30:00', '15:30:00'),
('MDT211', 1, 'Wed', '13:30:00', '15:30:00'),
('MDT311', 1, 'Thu', '08:30:00', '10:30:00'),
('MDT370', 1, 'Fri', '09:30:00', '12:30:00'),
('MDT470', 1, 'Tue', '08:30:00', '11:30:00'),
('MDT471', 1, 'Wed', '08:30:00', '10:30:00'),
('MEE101', 1, 'Thu', '14:30:00', '17:30:00'),
('MEE111', 1, 'Mon', '08:30:00', '10:30:00'),
('MEE111', 1, 'Wed', '15:30:00', '18:30:00'),
('MEE115', 1, 'Fri', '11:30:00', '12:30:00'),
('MEE211', 1, 'Thu', '13:30:00', '16:30:00'),
('MEE212', 1, 'Fri', '09:30:00', '12:30:00'),
('MEE213', 1, 'Wed', '14:30:00', '17:30:00'),
('MEE214', 1, 'Wed', '09:30:00', '12:30:00'),
('MEE216', 1, 'Fri', '08:30:00', '11:30:00'),
('MEE312', 1, 'Mon', '09:30:00', '12:30:00'),
('MEE313', 1, 'Mon', '08:30:00', '11:30:00'),
('MEE321', 1, 'Fri', '08:30:00', '11:30:00'),
('MEE461', 1, 'Tue', '08:30:00', '11:30:00'),
('MEE462', 1, 'Tue', '08:30:00', '11:30:00'),
('MIC191', 1, 'Tue', '13:30:00', '16:30:00'),
('MIC211', 1, 'Mon', '10:30:00', '12:30:00'),
('MIC321', 1, 'Mon', '08:30:00', '09:30:00'),
('MIC321', 1, 'Wed', '09:30:00', '10:30:00'),
('MIC324', 1, 'Wed', '10:30:00', '12:30:00'),
('MIC497', 1, 'Mon', '10:30:00', '12:30:00'),
('MIC498', 1, 'Sun', '09:30:00', '12:30:00'),
('MMD112', 1, 'Wed', '08:30:00', '10:30:00'),
('MMD142', 1, 'Tue', '08:30:00', '11:30:00'),
('MMD220', 1, 'Fri', '09:30:00', '12:30:00'),
('MMD233', 1, 'Thu', '08:30:00', '10:30:00'),
('MMD310', 1, 'Wed', '13:30:00', '15:30:00'),
('MMD321', 1, 'Mon', '13:30:00', '15:30:00'),
('MMD470', 1, 'Mon', '10:30:00', '12:30:00'),
('MMD480', 1, 'Mon', '08:30:00', '10:30:00'),
('MMD481', 1, 'Sat', '08:30:00', '10:30:00'),
('MNE422', 1, 'Tue', '08:30:00', '11:30:00'),
('MTA101', 1, 'Wed', '08:30:00', '12:30:00'),
('MTA202', 1, 'Thu', '13:30:00', '15:30:00'),
('MTA304', 1, 'Fri', '13:30:00', '15:30:00'),
('MTE111', 1, 'Fri', '08:30:00', '12:30:30'),
('MTE112', 1, 'Wed', '08:30:00', '12:30:30'),
('MTE171', 1, 'Fri', '13:30:00', '18:30:30'),
('MTE211', 1, 'Sat', '08:30:00', '12:30:30'),
('MTE231', 1, 'Thu', '13:30:00', '16:30:30'),
('MTE233', 1, 'Fri', '13:30:00', '16:30:30'),
('MTE241', 1, 'Tue', '13:30:00', '16:30:30'),
('MTE342', 1, 'Thu', '13:30:00', '16:30:30'),
('MTE351', 1, 'Tue', '08:30:00', '11:30:30'),
('MTE452', 1, 'Wed', '13:30:00', '16:30:30'),
('MTE461', 1, 'Fri', '13:30:00', '16:30:30'),
('PHY100', 1, 'Tue', '13:30:00', '16:30:00'),
('PHY101', 1, 'Thu', '08:30:00', '10:30:00'),
('PHY103', 1, 'Mon', '08:30:00', '10:30:00'),
('PHY191', 1, 'Mon', '10:30:00', '12:30:00'),
('PHY290', 1, 'Tue', '13:30:00', '16:30:00'),
('PHY301', 1, 'Fri', '09:30:00', '10:30:00'),
('PHY301', 1, 'Wed', '10:30:00', '12:30:00'),
('PHY302', 1, 'Fri', '10:30:00', '12:30:00'),
('PHY302', 1, 'Tue', '09:30:00', '10:30:00'),
('PHY423', 1, 'Thu', '10:30:00', '12:30:00'),
('PHY423', 1, 'Wed', '08:30:00', '09:30:00'),
('PHY431', 1, 'Fri', '13:30:00', '16:30:00'),
('PPT101', 1, 'Thu', '13:30:00', '16:30:00'),
('PPT111', 1, 'Fri', '08:30:00', '10:30:00'),
('PPT111', 1, 'Wed', '10:30:00', '12:30:00'),
('PPT201', 1, 'Tue', '15:30:00', '18:30:00'),
('PPT212', 1, 'Mon', '08:30:00', '10:30:00'),
('PPT212', 1, 'Thu', '10:30:00', '12:30:00'),
('PPT351', 1, 'Mon', '10:30:00', '12:30:00'),
('PPT354', 1, 'Wed', '08:30:00', '10:30:00'),
('PPT491', 1, 'Mon', '13:30:00', '16:30:00'),
('PPT492', 1, 'Mon', '08:30:00', '10:30:00'),
('PRE113', 1, 'Fri', '10:30:00', '12:30:00'),
('PRE113', 1, 'Tue', '16:30:00', '19:30:00'),
('PRE115', 1, 'Tue', '08:30:00', '10:30:00'),
('PRE133', 1, 'Fri', '13:30:00', '16:30:00'),
('PRE141', 1, 'Thu', '08:30:00', '10:30:00'),
('PRE141', 1, 'Tue', '12:30:00', '15:30:00'),
('PRE151', 1, 'Thu', '13:30:00', '16:30:00'),
('PRE211', 1, 'Thu', '08:30:00', '12:30:00'),
('PRE242', 1, 'Fri', '08:30:00', '10:30:00'),
('PRE242', 1, 'Mon', '12:30:00', '15:30:00'),
('PRE251', 1, 'Thu', '16:30:00', '18:30:00'),
('PRE315', 1, 'Wed', '13:30:00', '16:30:00'),
('PRE323', 1, 'Fri', '08:30:00', '10:30:00'),
('PRE323', 1, 'Thu', '09:30:00', '12:30:00'),
('PRE331', 1, 'Wed', '08:30:00', '11:30:00'),
('PRE332', 1, 'Tue', '12:30:00', '15:30:00'),
('PRE432', 1, 'Thu', '16:30:00', '18:30:00'),
('PRE454', 1, 'Thu', '13:30:00', '16:30:00'),
('PTE101', 1, 'Mon', '16:30:00', '19:30:00'),
('PTE101', 1, 'Thu', '16:30:00', '19:30:00'),
('PTE101', 1, 'Wed', '16:30:00', '19:30:00'),
('PTE111', 1, 'Thu', '15:30:00', '20:30:00'),
('PTE251', 1, 'Mon', '13:30:00', '16:30:00'),
('PTE261', 1, 'Fri', '08:30:00', '12:30:00'),
('PTE324', 1, 'Mon', '13:30:00', '20:30:00'),
('PTE344', 1, 'Mon', '13:30:00', '20:30:00'),
('PTE351', 1, 'Fri', '13:30:00', '16:30:00'),
('PTE406', 1, 'Sat', '08:30:00', '12:30:00'),
('PTE442', 1, 'Thu', '09:30:00', '12:30:00'),
('APE121', 2, 'Mon', '14:30:00', '17:30:00'),
('APE121', 2, 'Tue', '13:30:00', '15:30:00'),
('CHE473', 2, 'Sun', '08:30:00', '11:30:00'),
('CHE482', 2, 'Sun', '16:30:00', '19:30:00'),
('CHM101', 2, 'Thu', '10:30:00', '12:30:00'),
('CHM101', 2, 'Wed', '08:30:00', '10:30:00'),
('CHM103', 2, 'Fri', '08:30:00', '09:30:00'),
('CHM103', 2, 'Mon', '10:30:00', '12:30:00'),
('CHM160', 2, 'Tue', '08:30:00', '11:30:00'),
('CPE100', 2, 'Fri', '10:30:00', '12:30:00'),
('CPE100', 2, 'Thu', '08:30:00', '10:30:00'),
('CPE101', 2, 'Mon', '15:30:00', '17:30:00'),
('CPE121', 2, 'Wed', '10:30:00', '12:30:00'),
('CPE212', 2, 'Wed', '13:30:00', '17:30:00'),
('CPE223', 2, 'Fri', '10:30:00', '12:30:00'),
('CPE223', 2, 'Wed', '08:30:00', '10:30:00'),
('CPE231', 2, 'Mon', '15:30:00', '17:30:00'),
('CPE315', 2, 'Mon', '15:30:00', '17:30:00'),
('CPE326', 2, 'Mon', '13:30:00', '15:30:00'),
('CPE326', 2, 'Wed', '08:30:00', '10:30:00'),
('CPE327', 2, 'Mon', '10:30:00', '12:30:00'),
('CPE327', 2, 'Wed', '13:30:00', '15:30:00'),
('CPE332', 2, 'Tue', '18:00:00', '19:00:00'),
('CPE401', 2, 'Mon', '13:30:00', '15:30:00'),
('CPE999', 2, 'Tue', '13:30:00', '15:30:00'),
('CSC101', 2, 'Tue', '13:30:00', '16:30:00'),
('CSS111', 2, 'Mon', '10:30:00', '12:30:00'),
('CSS112', 2, 'Thu', '08:30:00', '12:30:00'),
('CSS114', 2, 'Tue', '08:30:00', '12:30:00'),
('CSS222', 2, 'Sat', '08:30:00', '12:30:00'),
('CVE100', 2, 'Fri', '16:30:00', '18:30:00'),
('CVE100', 2, 'Wed', '09:30:00', '12:30:00'),
('CVE111', 2, 'Fri', '10:30:00', '12:30:00'),
('CVE221', 2, 'Mon', '13:30:00', '16:30:00'),
('CVE223', 2, 'Mon', '08:30:00', '11:30:00'),
('CVE232', 2, 'Fri', '14:30:00', '17:30:00'),
('CVE233', 2, 'Fri', '12:30:00', '14:30:00'),
('CVE233', 2, 'Thu', '12:30:00', '14:30:00'),
('CVE336', 2, 'Fri', '08:30:00', '11:30:00'),
('CVE338', 2, 'Wed', '14:30:00', '17:30:00'),
('CVE363', 2, 'Fri', '09:30:00', '12:30:00'),
('CVE385', 2, 'Mon', '09:30:00', '12:30:00'),
('CVE394', 2, 'Fri', '13:30:00', '16:30:00'),
('EEE100', 2, 'Mon', '09:30:00', '12:30:00'),
('EEE102', 2, 'Mon', '09:30:00', '12:30:00'),
('EEE190', 2, 'Sat', '13:30:00', '16:30:00'),
('EEE321', 2, 'Tue', '13:30:00', '16:30:00'),
('EEE380', 2, 'Fri', '09:30:00', '12:30:00'),
('ENV210', 2, 'Fri', '13:30:00', '15:30:00'),
('ETM101', 2, 'Wed', '08:30:00', '11:30:00'),
('ETM102', 2, 'Thu', '13:30:00', '17:30:00'),
('ETM103', 2, 'Fri', '08:30:00', '12:30:00'),
('ETM104', 2, 'Tue', '08:30:00', '11:30:00'),
('ETM202', 2, 'Thu', '08:30:00', '11:30:00'),
('ETM211', 2, 'Tue', '08:30:00', '11:30:00'),
('ETM312', 2, 'Thu', '13:30:00', '16:30:00'),
('ETM472', 2, 'Wed', '17:30:00', '19:30:00'),
('FRA141', 2, 'Tue', '08:30:00', '10:30:00'),
('FRA451', 2, 'Tue', '08:30:00', '11:30:00'),
('GEN101', 2, 'Mon', '08:30:00', '10:30:00'),
('GEN111', 2, 'Tue', '08:30:00', '11:30:00'),
('GEN121', 2, 'Tue', '08:30:00', '11:30:00'),
('GEN201', 2, 'Tue', '13:30:00', '16:30:00'),
('GEN211', 2, 'Wed', '08:30:00', '11:30:00'),
('GEN223', 2, 'Wed', '13:30:00', '16:30:00'),
('GEN224', 2, 'Mon', '08:30:00', '11:30:00'),
('GEN231', 2, 'Tue', '10:30:00', '13:30:00'),
('GEN232', 2, 'Sun', '12:30:00', '15:30:00'),
('GEN241', 2, 'Wed', '09:30:00', '12:30:00'),
('GEN242', 2, 'Sat', '09:30:00', '12:30:00'),
('GEN301', 2, 'Sat', '09:00:00', '12:00:00'),
('GEN311', 2, 'Sat', '09:30:00', '12:30:00'),
('GEN321', 2, 'Mon', '08:30:00', '11:30:00'),
('GEN331', 2, 'Sat', '13:30:00', '16:30:00'),
('GEN341', 2, 'Tue', '13:30:00', '16:30:00'),
('GEN351', 2, 'Wed', '08:30:00', '11:30:00'),
('GEN352', 2, 'Fri', '09:30:00', '12:30:00'),
('GEN353', 2, 'Tue', '08:30:00', '11:30:00'),
('GEN411', 2, 'Mon', '08:30:00', '12:30:00'),
('GEN412', 2, 'Mon', '08:30:00', '11:30:00'),
('GEN421', 2, 'Tue', '13:30:00', '16:30:00'),
('GEN441', 2, 'Mon', '09:30:00', '13:30:00'),
('INC102', 2, 'Tue', '10:30:00', '15:30:00'),
('INC121', 2, 'Wed', '10:30:00', '12:30:00'),
('INC171', 2, 'Mon', '08:30:00', '12:30:00'),
('INC221', 2, 'Mon', '09:30:00', '12:30:00'),
('INC222', 2, 'Fri', '13:30:00', '16:30:00'),
('INC301', 2, 'Wed', '09:30:00', '12:30:00'),
('INC331', 2, 'Fri', '13:30:00', '17:30:00'),
('INT202', 2, 'Wed', '08:30:00', '10:30:00'),
('INT308', 2, 'Thu', '10:30:00', '12:30:00'),
('INT319', 2, 'Fri', '08:30:00', '10:30:00'),
('MEE101', 2, 'Wed', '15:30:00', '18:30:00'),
('MEE111', 2, 'Thu', '14:30:00', '17:30:00'),
('MEE111', 2, 'Wed', '13:30:00', '15:30:00'),
('MEE214', 2, 'Wed', '12:30:00', '15:30:00'),
('MEE216', 2, 'Fri', '13:30:00', '16:30:00'),
('MEE313', 2, 'Tue', '08:30:00', '11:30:00'),
('MEE321', 2, 'Fri', '08:30:00', '11:30:00'),
('MIC191', 2, 'Tue', '13:30:00', '16:30:00'),
('PHY101', 2, 'Wed', '13:30:00', '15:30:00'),
('PHY103', 2, 'Mon', '10:30:00', '12:30:00'),
('PHY191', 2, 'Wed', '08:30:00', '10:30:00'),
('PPT101', 2, 'Thu', '13:30:00', '16:30:00'),
('PPT111', 2, 'Fri', '10:30:00', '12:30:00'),
('PPT111', 2, 'Wed', '10:30:00', '12:30:00'),
('PPT201', 2, 'Tue', '15:30:00', '18:30:00'),
('PPT212', 2, 'Mon', '10:30:00', '12:30:00'),
('PPT212', 2, 'Thu', '10:30:00', '12:30:00'),
('PPT491', 2, 'Mon', '13:30:00', '16:30:00'),
('PPT492', 2, 'Mon', '08:30:00', '10:30:00'),
('PRE115', 2, 'Tue', '08:30:00', '10:30:00'),
('PRE141', 2, 'Thu', '08:30:00', '10:30:00'),
('PRE141', 2, 'Tue', '15:30:00', '18:30:00'),
('PRE211', 2, 'Thu', '12:30:00', '16:30:00'),
('PRE242', 2, 'Fri', '08:30:00', '10:30:00'),
('PRE242', 2, 'Mon', '15:30:00', '18:30:00'),
('PRE315', 2, 'Thu', '14:30:00', '17:30:00'),
('PRE323', 2, 'Fri', '08:30:00', '10:30:00'),
('PRE323', 2, 'Thu', '13:30:00', '16:30:00'),
('CHM103', 3, 'Mon', '08:30:00', '10:30:00'),
('CHM103', 3, 'Thu', '11:30:00', '12:30:00'),
('CHM160', 3, 'Tue', '08:30:00', '11:30:00'),
('CPE100', 3, 'Tue', '10:30:00', '12:30:00'),
('CPE100', 3, 'Wed', '08:30:00', '10:30:00'),
('CPE326', 3, 'Mon', '13:30:00', '15:30:00'),
('CPE326', 3, 'Wed', '08:30:00', '10:30:00'),
('CPE327', 3, 'Mon', '10:30:00', '12:30:00'),
('CPE327', 3, 'Wed', '13:30:00', '15:30:00'),
('CPE332', 3, 'Tue', '18:00:00', '19:00:00'),
('CVE336', 3, 'Wed', '14:30:00', '17:30:00'),
('EEE102', 3, 'Tue', '13:30:00', '16:30:00'),
('FRA141', 3, 'Tue', '08:30:00', '10:30:00'),
('GEN101', 3, 'Mon', '08:30:00', '10:30:00'),
('GEN111', 3, 'Tue', '08:30:00', '11:30:00'),
('GEN121', 3, 'Tue', '08:30:00', '11:30:00'),
('GEN201', 3, 'Tue', '13:30:00', '16:30:00'),
('GEN211', 3, 'Wed', '08:30:00', '11:30:00'),
('GEN223', 3, 'Wed', '13:30:00', '16:30:00'),
('GEN224', 3, 'Mon', '08:30:00', '11:30:00'),
('GEN231', 3, 'Tue', '10:30:00', '13:30:00'),
('GEN232', 3, 'Sun', '12:30:00', '15:30:00'),
('GEN241', 3, 'Wed', '09:30:00', '12:30:00'),
('GEN242', 3, 'Sat', '09:30:00', '12:30:00'),
('GEN301', 3, 'Sat', '09:00:00', '12:00:00'),
('GEN311', 3, 'Sat', '09:30:00', '12:30:00'),
('GEN321', 3, 'Mon', '08:30:00', '11:30:00'),
('GEN331', 3, 'Wed', '08:30:00', '11:30:00'),
('GEN341', 3, 'Tue', '13:30:00', '16:30:00'),
('GEN351', 3, 'Wed', '08:30:00', '11:30:00'),
('GEN352', 3, 'Fri', '09:30:00', '12:30:00'),
('GEN353', 3, 'Tue', '08:30:00', '11:30:00'),
('GEN411', 3, 'Mon', '08:30:00', '12:30:00'),
('GEN412', 3, 'Mon', '08:30:00', '11:30:00'),
('GEN421', 3, 'Tue', '13:30:00', '16:30:00'),
('GEN441', 3, 'Mon', '09:30:00', '13:30:00'),
('INC102', 3, 'Mon', '10:30:00', '12:30:00'),
('INC102', 3, 'Tue', '10:30:00', '12:30:00'),
('MEE111', 3, 'Mon', '10:30:00', '13:30:00'),
('MEE111', 3, 'Thu', '10:30:00', '13:30:00'),
('MEE214', 3, 'Thu', '10:30:00', '13:30:00'),
('MEE216', 3, 'Fri', '08:30:00', '11:30:00'),
('MEE313', 3, 'Tue', '08:30:00', '11:30:00'),
('MEE321', 3, 'Thu', '08:30:00', '11:30:00'),
('MIC191', 3, 'Tue', '13:30:00', '16:30:00'),
('PHY101', 3, 'Thu', '10:30:00', '12:30:00'),
('PHY103', 3, 'Thu', '10:30:00', '12:30:00'),
('PHY191', 3, 'Wed', '10:30:00', '12:30:00'),
('PRE115', 3, 'Mon', '13:30:00', '15:30:00'),
('PRE141', 3, 'Fri', '08:30:00', '10:30:00'),
('PRE141', 3, 'Wed', '08:30:00', '11:30:00'),
('PRE315', 3, 'Thu', '14:30:00', '17:30:00'),
('CHM160', 4, 'Tue', '08:30:00', '11:30:00'),
('CVE336', 4, 'Thu', '08:30:00', '11:30:00'),
('EEE102', 4, 'Fri', '13:30:00', '16:30:00'),
('MEE111', 4, 'Mon', '10:30:00', '13:30:00'),
('MEE111', 4, 'Tue', '10:30:00', '13:30:00'),
('MEE214', 4, 'Thu', '13:30:00', '16:30:00'),
('MIC191', 4, 'Wed', '09:30:00', '12:30:00'),
('PHY101', 4, 'Mon', '15:30:00', '17:30:00'),
('PHY103', 4, 'Thu', '08:30:00', '10:30:00'),
('PHY191', 4, 'Wed', '13:30:00', '15:30:00'),
('CHM160', 5, 'Tue', '13:30:00', '16:30:00'),
('EEE102', 5, 'Thu', '09:30:00', '12:30:00'),
('MEE214', 5, 'Fri', '09:30:00', '12:30:00'),
('MIC191', 5, 'Wed', '09:30:00', '12:30:00'),
('PHY101', 5, 'Fri', '13:30:00', '150:30:00'),
('PHY103', 5, 'Fri', '10:30:00', '12:30:00'),
('PHY191', 5, 'Wed', '08:30:00', '10:30:00'),
('CHE100', 31, 'Mon', '15:00:00', '16:30:00'),
('CHE210', 31, 'Thu', '08:30:00', '11:30:00'),
('CHE231', 31, 'Tue', '08:30:00', '10:30:00'),
('CHE231', 31, 'Wed', '10:30:00', '12:30:00'),
('CHE241', 31, 'Mon', '09:30:00', '12:30:00'),
('CHE334', 31, 'Wed', '13:30:00', '16:30:00'),
('CHE343', 31, 'Mon', '09:30:00', '12:30:00'),
('CHE451', 31, 'Fri', '13:30:00', '16:30:00'),
('CHE471', 31, 'Tue', '08:30:00', '11:30:00'),
('CHE473', 31, 'Sat', '13:30:00', '16:30:00'),
('CHE482', 31, 'Mon', '16:30:00', '19:30:00'),
('CHE483', 31, 'Sat', '08:30:00', '11:30:00'),
('CHE484', 31, 'Wed', '13:30:00', '16:30:00'),
('CHE494', 31, 'Thu', '13:30:00', '17:30:00'),
('CHM103', 31, 'Fri', '11:30:00', '12:30:00'),
('CHM103', 31, 'Thu', '08:30:00', '10:30:00'),
('CPE100', 31, 'Tue', '08:30:00', '10:30:00'),
('CPE100', 31, 'Wed', '14:30:00', '16:30:00'),
('CPE101', 31, 'Fri', '13:30:00', '15:30:00'),
('CPE121', 31, 'Fri', '10:30:00', '12:30:00'),
('CPE212', 31, 'Tue', '08:30:00', '12:30:00'),
('CPE223', 31, 'Fri', '13:30:00', '15:30:00'),
('CPE223', 31, 'Wed', '13:30:00', '15:30:00'),
('CPE325', 31, 'Fri', '13:30:00', '16:30:00'),
('CPE326', 31, 'Mon', '10:30:00', '12:30:00'),
('CPE326', 31, 'Tue', '15:30:00', '17:30:00'),
('CPE327', 31, 'Mon', '08:30:00', '10:30:00'),
('CPE327', 31, 'Tue', '13:30:00', '15:30:00'),
('CPE332', 31, 'Thu', '18:00:00', '19:00:00'),
('CPE341', 31, 'Mon', '09:00:00', '12:00:00'),
('CPE342', 31, 'Fri', '16:30:00', '19:30:00'),
('CPE374', 31, 'Thu', '09:30:00', '12:30:00'),
('CPE376', 31, 'Wed', '16:30:00', '20:30:00'),
('CPE381', 31, 'wed', '09:00:00', '12:00:00'),
('CPE393', 31, 'Tue', '09:30:00', '12:30:00'),
('CPE401', 31, 'Mon', '16:30:00', '18:30:00'),
('CPE403', 31, 'Mon', '16:30:00', '18:30:00'),
('CPE405', 31, 'Mon', '13:30:00', '15:30:00'),
('CPE467', 31, 'Thu', '13:30:00', '16:30:00'),
('CPE494', 31, 'Fri', '13:30:00', '16:30:00'),
('CVE101', 31, 'Thu', '08:30:00', '10:30:00'),
('CVE221', 31, 'Fri', '08:30:00', '10:30:00'),
('CVE221', 31, 'Tue', '10:30:00', '12:30:00'),
('CVE223', 31, 'Wed', '09:30:00', '12:30:00'),
('CVE231', 31, 'Thu', '10:30:00', '12:30:00'),
('CVE231', 31, 'Wed', '14:30:00', '16:30:00'),
('CVE236', 31, 'Thu', '13:30:00', '16:30:00'),
('CVE236', 31, 'Wed', '13:30:00', '14:30:00'),
('CVE335', 31, 'Sat', '09:30:00', '12:30:00'),
('CVE337', 31, 'Thu', '09:30:00', '10:30:00'),
('CVE337', 31, 'Tue', '09:30:00', '12:30:00'),
('CVE362', 31, 'Fri', '13:30:00', '16:30:00'),
('CVE363', 31, 'Mon', '09:30:00', '12:30:00'),
('CVE382', 31, 'Fri', '10:30:00', '12:30:00'),
('CVE385', 31, 'Thu', '09:30:00', '11:30:00'),
('CVE385', 31, 'Wed', '08:30:00', '10:30:00'),
('CVE394', 31, 'Mon', '13:30:00', '16:30:00'),
('CVE401', 31, 'Sat', '16:30:00', '19:30:00'),
('CVE414', 31, 'Sun', '13:30:00', '17:30:00'),
('CVE415', 31, 'Wed', '13:30:00', '17:30:00'),
('CVE448', 31, 'Tue', '09:30:00', '12:30:00'),
('EEE100', 31, 'Mon', '09:30:00', '12:30:00'),
('EIE105', 31, 'Mon', '09:30:00', '11:30:00'),
('EIE105', 31, 'Wed', '17:30:00', '19:30:00'),
('EIE205', 31, 'Wed', '13:30:00', '16:30:00'),
('EIE210', 31, 'Wed', '17:30:00', '20:30:00'),
('EIE301', 31, 'Tue', '13:30:00', '16:30:00'),
('EIE312', 31, 'Fri', '09:30:00', '12:30:00'),
('EIE325', 31, 'Fri', '13:30:00', '16:30:00'),
('EIE370', 31, 'Mon', '13:30:00', '15:30:00'),
('EIE422', 31, 'Thu', '13:30:00', '16:30:00'),
('ENV210', 31, 'Thu', '09:30:00', '11:30:00'),
('ENV213', 31, 'Wed', '16:30:00', '18:30:00'),
('ENV341', 31, 'Mon', '13:30:00', '16:30:00'),
('ENV344', 31, 'Tue', '13:30:00', '16:30:00'),
('ENV401', 31, 'Fri', '12:30:00', '13:30:00'),
('ENV401', 31, 'Thu', '12:30:00', '13:30:00'),
('ENV401', 31, 'Tue', '12:30:00', '13:30:00'),
('ENV434', 31, 'Wed', '10:30:00', '13:30:00'),
('ENV442', 31, 'Wed', '13:30:00', '16:30:00'),
('ENV451', 31, 'Fri', '09:30:00', '12:30:00'),
('INC222', 31, 'Fri', '13:30:00', '16:30:00'),
('INC223', 31, 'Thu', '09:30:00', '12:30:00'),
('INC311', 31, 'Tue', '09:30:00', '12:30:00'),
('INC331', 31, 'Thu', '08:30:00', '12:30:00'),
('MEE115', 31, 'Thu', '08:30:00', '12:30:00'),
('MIC101', 31, 'Fri', '09:30:00', '12:30:00'),
('PRE151', 31, 'Thu', '09:30:00', '12:30:00'),
('CHM103', 32, 'Fri', '08:30:00', '10:30:00'),
('CHM103', 32, 'Thu', '11:30:00', '12:30:00'),
('CPE100', 32, 'Tue', '08:30:00', '10:30:00'),
('CPE100', 32, 'Wed', '16:30:00', '18:30:00'),
('CPE101', 32, 'Fri', '15:30:00', '17:30:00'),
('CPE121', 32, 'Fri', '08:30:00', '10:30:00'),
('CPE212', 32, 'Tue', '08:30:00', '12:30:00'),
('CPE223', 32, 'Fri', '13:30:00', '15:30:00'),
('CPE223', 32, 'Wed', '13:30:00', '15:30:00'),
('CPE326', 32, 'Mon', '10:30:00', '12:30:00'),
('CPE326', 32, 'Tue', '15:30:00', '17:30:00'),
('CPE327', 32, 'Mon', '08:30:00', '10:30:00'),
('CPE327', 32, 'Tue', '13:30:00', '15:30:00'),
('CPE332', 32, 'Thu', '18:00:00', '19:00:00'),
('CPE401', 32, 'Mon', '16:30:00', '18:30:00'),
('CVE236', 32, 'Fri', '13:30:00', '16:30:00'),
('CVE236', 32, 'Wed', '13:30:00', '14:30:00'),
('CVE337', 32, 'Fri', '09:30:00', '10:30:00'),
('CVE337', 32, 'Tue', '09:30:00', '12:30:00'),
('CVE362', 32, 'Fri', '13:30:00', '16:30:00'),
('CVE363', 32, 'Mon', '13:30:00', '16:30:00'),
('CVE386', 32, 'Tue', '13:30:00', '15:30:00'),
('CVE394', 32, 'Mon', '09:30:00', '12:30:00'),
('EIE105', 32, 'Mon', '09:30:00', '11:30:00'),
('EIE105', 32, 'Wed', '17:30:00', '19:30:00'),
('CPE100', 33, 'Thu', '08:30:00', '10:30:00'),
('CPE100', 33, 'Wed', '16:30:00', '18:30:00'),
('CPE101', 33, 'Wed', '08:30:00', '10:30:00'),
('CVE111', 33, 'Fri', '08:30:00', '11:30:00'),
('CVE111', 33, 'Wed', '13:30:00', '15:30:00'),
('CVE394', 33, 'Wed', '13:30:00', '16:30:00'),
('CPE100', 34, 'Mon', '08:30:00', '10:30:00'),
('CPE100', 34, 'Wed', '16:30:00', '18:30:00'),
('CPE100', 99, 'Mon', '13:30:00', '17:30:00'),
('CPE111', 99, 'Wed', '08:30:00', '10:30:00'),
('CPE122', 99, 'Tue', '08:30:00', '10:30:00'),
('EEE111', 99, 'Thu', '08:30:00', '10:30:00'),
('MEE101', 99, 'Mon', '10:30:00', '12:30:00'),
('MEE214', 99, 'Wed', '08:30:00', '10:30:00'),
('PHY104', 99, 'Thu', '08:30:00', '10:30:00'),
('PRE103', 99, 'Thu', '13:30:00', '17:30:00'),
('PRE113', 99, 'Mon', '13:30:00', '17:30:00'),
('PRE133', 99, 'Mon', '10:30:00', '12:30:00'),
('PRE141', 99, 'Mon', '13:30:00', '15:30:00');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `FirstName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `LastName` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `BirthDate` date NOT NULL,
  `Gender` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `CitizenID` bigint(20) NOT NULL,
  `Email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Personal_email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `Degree` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ProgramID` int(11) NOT NULL,
  `Room` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `DateStarted` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `password`, `FirstName`, `LastName`, `BirthDate`, `Gender`, `CitizenID`, `Email`, `Personal_email`, `Degree`, `ProgramID`, `Room`, `DateStarted`) VALUES
(60030401003, '$2y$10$kmu2nUewu3BG6gh6gk1kdO0CG9mDPLeNPtYlroz1zbWKRzhjHcpE.', 'Saksiam', 'Damrong', '1998-03-04', 'M', 1234512456612, 'sak@mail.kmutt.ac.th', 'lnwsakZa@hotmail.com', 'Bachelor', 6, 'A', '2017-08-13'),
(60030402003, '$2y$10$LkZQsrewap/xHHWOJuIUUOupoFFUsp92.iVumKwHEcnOXNFf7ktT.', 'Kantapon', 'Sethapanee', '1998-06-08', 'M', 9066916747483, 'Kantapon@mail.kmutt.ac.th', 'Kantapon4856@hotmail.com', 'Bachelor', 6, 'A', '2017-08-13'),
(60030403003, '$2y$10$4Lmu2ngoivvYF6D.zlpi3uZQ9EZUX2XZjTkVCZTwMB7Z1TzekKnlC', 'Chayaphon', 'Bunyakan', '1998-03-05', 'M', 5999296920755, 'Chayaphon@mail.kmutt.ac.th', 'Chayaphon001@hotmail.com', 'Bachelor', 6, 'B', '2017-08-13'),
(60030404003, '$2y$10$yldOKMfGNvSDnsprOQIRC.Q2qVE75rUdCkoOAUN1owKUwvnuK5xaG', 'Natacha', 'Punyathanasub', '1998-05-07', 'F', 2949811687143, 'Natacha@mail.kmutt.ac.th', 'Natacha009@hotmail.com', 'Bachelor', 6, 'A', '2017-08-13'),
(60030405003, '$2y$10$Uk2SKz3AEc002SoA5pDuC.lG.ns7Y9mUE1g5QBrQD8ZXtw0fdj0su', 'Natsarun', 'Rooncharoen', '1998-04-09', 'F', 8906979247741, 'Natsarun@mail.kmutt.ac.th', 'Natsarun119@hotmail.com', 'Bachelor', 6, 'A', '2017-08-13'),
(60030406003, '$2y$10$WHKCbuVoosIvbFtv4TWSp.fXAQve.n3exhM.YXcyLCD49IPjBx/sy', 'Thipphawan', 'Naphom', '1998-06-10', 'F', 5022324189128, 'Thipphawan@mail.kmutt.ac.th', 'Thipphawan8874@hotmail.com', 'Bachelor', 6, 'B', '2017-08-13'),
(60030407003, '$2y$10$ZUt9lGxZQYrdHiN/VPMK9ee6oDX4ZhDb0nEN4GIxLlz817YRrhenW', 'Tanat', 'Punyasarn', '1998-07-09', 'M', 1513949304421, 'Tanat@mail.kmutt.ac.th', 'Tanat3354@hotmail.com', 'Bachelor', 6, 'B', '2017-08-13'),
(60030408003, '$2y$10$GoYYDXCsW4xNj6lykz3Qo.Dff3emXe23qnDSiDLKq/rj5bMj/tFjK', 'Prakasit', 'Issanapong', '1998-02-11', 'M', 7369066029182, 'Prakasit@mail.kmutt.ac.th', 'Prakasit412@hotmail.com', 'Bachelor', 5, 'C', '2017-08-13'),
(60030409003, '$2y$10$oUF4j41wp6ptHhiFYB4D5ujTnOQ1RJhbj1wevlfxjGmYPCSm/1IMe', 'Ploypapas', 'Pianchoopat', '1998-08-08', 'F', 9843712607527, 'Ploypapas@mail.kmutt.ac.th', 'Ploypapas3314@hotmail.com', 'Bachelor', 5, 'D', '2017-08-13'),
(60030501003, '$2y$10$f7eJ8fXl8Bp3ME/ti1pNf.sskvRCaEnG/k6ATyHl6XAFghDiv8.t2', 'Piriya', 'Chaigul', '1998-03-12', 'F', 6375452683760, 'Piriya@mail.kmutt.ac.th', 'Piriya1142@hotmail.com', 'Bachelor', 7, 'A', '2017-08-13'),
(60030502003, '$2y$10$SZXuUaxUV3U9M7IBYKCaOelEzK9H53hKtJDAFPt4Afj.RckuZKYjW', 'Romtam', 'Tanpituckpong', '1998-10-22', 'M', 6729964991684, 'Romtam@mail.kmutt.ac.th', 'Romtam1150@hotmail.com', 'Bachelor', 7, 'B', '2017-08-13'),
(60030503003, '$2y$10$tE5ImZMsFg/dwFG7kMGlze8tq81q2vT3F3uAjh5bdx.MEsFyZvqZC', 'Wiwat', 'Asawalertsak', '1998-01-04', 'M', 3218616285132, 'Wiwat@mail.kmutt.ac.th', 'Wiwat445@hotmail.com', 'Bachelor', 7, 'B', '2017-08-13'),
(60030504003, '$2y$10$mU.P.ivcUp5iNH4iAXDqiOGUqzBmkAy.7x0RASbZiVzyhqumD.bTq', 'Sirapop', 'Apananda', '1998-07-12', 'M', 9176178617952, 'Sirapop@mail.kmutt.ac.th', 'Sirapop116@hotmail.com', 'Bachelor', 7, 'B', '2017-08-13'),
(60030505003, '$2y$10$0OdI5Od5l4dL.XdPoiPASeP7pyGjfqgtSHsNiqBfCiHt4KV/j2PdS', 'Chatchapon', 'Sukitporn-udom', '1998-08-08', 'M', 1740473059071, 'Chatchapon@mail.kmutt.ac.th', 'Chatchapon1143@hotmail.com', 'Bachelor', 2, 'A', '2017-08-13'),
(60030506003, '$2y$10$ZVv9ZtIkaKRv1kfIqkLurO1jc4E3c6tVHAmhWi/7tcCBfIEe4Y21e', 'Peeradon', 'Joongjitdumrong', '1998-04-10', 'M', 3648365030682, 'Peeradon@mail.kmutt.ac.th', 'Peeradon4564@hotmail.com', 'Bachelor', 3, 'D', '2017-08-13'),
(60030507003, '$2y$10$tp4CrOCD.Kvu6jX7ple.Ne5RoLIh8sbxi5FpFB.uReFCRO/yGGaSy', 'Thanapatr', 'Amnuaywit', '1998-02-19', 'M', 2175985012757, 'Thanapatr@mail.kmutt.ac.th', 'Thanapatr1150@hotmail.com', 'Bachelor', 8, 'C', '2017-08-13'),
(60030508003, '$2y$10$cFUTBND4c.rBeYXWW7TrZeZuDrk0I2g.teyFewlxABKVPxOBUczQC', 'Saruch', 'Ubonkarn', '1998-04-09', 'M', 1804224208939, 'Saruch@mail.kmutt.ac.th', 'Saruch7741@hotmail.com', 'Bachelor', 9, 'B', '2017-08-13'),
(60030509003, '$2y$10$Pg87oKX3GGDM7wB5h1dFuunC7JsUk9mez57W7AndnGNMYoYEATYiS', 'Chutiratt', 'Arunrassamee', '1998-09-17', 'M', 7847745646561, 'Chutiratt@mail.kmutt.ac.th', 'Chutiratt1142@hotmail.com', 'Bachelor', 11, 'C', '2017-08-13'),
(60030601003, '$2y$10$dBbtc.duj5gtm6oACkxBW.3h/TZmIshfgF51kMjGS4TFqSC0nqoLe', 'Narapat', 'Chatacharoenying', '1998-12-19', 'M', 9826326497139, 'Narapat@mail.kmutt.ac.th', 'Narapat4512@hotmail.com', 'Bachelor', 12, 'B', '2017-08-13'),
(60030602003, '$2y$10$0yZXyovSP6nDQgARhj6iDOsHcJvkqJt0jIz8085q/gZC/o30GqYNO', 'Wachiraporn', 'Wankham', '1998-07-16', 'M', 5303128888840, 'Wachiraporn@mail.kmutt.ac.th', 'Wachiraporn1145@hotmail.com', 'Bachelor', 14, 'A', '2017-08-13'),
(60030603003, '$2y$10$I9sX3Ek8BANYerFm5Xq.L.EpLK3DK864hOAqFJFTiRNnbU7KsTQDG', 'Irin', 'Cheardsatiensak', '1998-04-10', 'F', 8851009378846, 'Irin@mail.kmutt.ac.th', 'Irin3351@hotmail.com', 'Bachelor', 15, 'B', '2017-08-13'),
(60030604003, '$2y$10$Lg4WzbvpamFgvVy.aeUfd.Qw3x8lPpuud/yE1wK5/8cT0GGsH01kG', 'Pisit', 'Phrettithananon', '1998-01-16', 'M', 4687851423390, 'Pisit@mail.kmutt.ac.th', 'Pisit5656@hotmail.com', 'Bachelor', 16, 'B', '2017-08-13'),
(60030605003, '$2y$10$RjHtE18D9MYCl0et.Gtw.eozPcg7WFou8V961MU5N2u83AjcYL3yK', 'Piyaphat', 'Suangsungwien', '1998-08-19', 'M', 6204588018920, 'Piyaphat@mail.kmutt.ac.th', 'Piyaphat5542@hotmail.com', 'Bachelor', 18, 'A', '2017-08-13'),
(60030606003, '$2y$10$wmxmWzJy8kvfiKOoxnG2SewhlcNknHWRrM/eTzae9nJ3dyPZSTszC', 'John', 'Wick', '1998-07-20', 'M', 3543777048798, 'John@mail.kmutt.ac.th', 'Johnwick@hotmail.com', 'Bachelor', 19, 'B', '2017-08-13'),
(60030607003, '$2y$10$L7q5LFaxf4pkl.wP5O6FAOWPMTyoNbuHVZj0eEo/zbCpZ2VYJOD7C', 'Aria', 'Adams', '1998-04-17', 'F', 1897196022689, 'Aria@mail.kmutt.ac.th', 'Aria4122@hotmail.com', 'Bachelor', 21, 'A', '2017-08-13'),
(60030608003, '$2y$10$V4rROzgs4osTKyzxLFBDxO8wGfas9eXUS7dqER6C0gpDXymLYNYNK', 'Angela', 'Beckham', '1998-05-13', 'F', 6950663038538, 'Angela@mail.kmutt.ac.th', 'Angela1140@hotmail.com', 'Bachelor', 22, 'B', '2017-08-13'),
(60030609003, '$2y$10$HiWCB1QSuxPV0pYwTCIMQeSOlIcCMrPYCemntWonxz3t3pCL.jEcu', 'Amelia', 'Carter', '1998-08-13', 'F', 2419353145204, 'Amelia@mail.kmutt.ac.th', 'Amelia555@hotmail.com', 'Bachelor', 24, 'A', '2017-08-13'),
(60030701003, '$2y$10$CR7kXDaPZxl/TqmMrtIKB.8RAeChtQnsacTvD/p5zY9dJ1wOAnvxW', 'Anne', 'Alexander', '1998-07-16', 'F', 7416995540411, 'Anne@mail.kmutt.ac.th', 'Anne1143@hotmail.com', 'Bachelor', 25, 'B', '2017-08-13'),
(60030702003, '$2y$10$1FzY3t8Kf.GoTiDWFG4VHe5oMcWh83SM/aPrsxVUF./gGS6ulROdm', 'Amada', 'Evans', '1998-07-23', 'F', 7305949993688, 'Amada@mail.kmutt.ac.th', 'Amada3315@hotmail.com', 'Bachelor', 29, 'A', '2017-08-13'),
(60030703003, '$2y$10$btWNxEtG.myKbf95WnX0J.3X583/Na76Le./uWYCxPws7/WODuz8e', 'Angelica', 'Howard', '1998-07-22', 'F', 1638485753766, 'Angelica@mail.kmutt.ac.th', 'Angelica5454@hotmail.com', 'Bachelor', 30, 'B', '2017-08-13'),
(60030704003, '$2y$10$RBEIv6CK/2qo.C5bdem0i.1HfYZKlebc1YamQYnUELxDRXpWTuxB.', 'Ashley', 'Kelly', '1998-02-11', 'F', 4111117200096, 'Ashley@mail.kmutt.ac.th', 'Ashley4545@hotmail.com', 'Bachelor', 32, 'A', '2017-08-13'),
(60030705003, '$2y$10$e891o9pMHCWu4/LEvX/MqOW8fTNZt3lsZzRD2dzxNLCNbrbFozrKq', 'Carmen', 'Lewis', '1998-08-21', 'M', 7721281123707, 'Carmen@mail.kmutt.ac.th', 'Carmen007@hotmail.com', 'Bachelor', 33, 'B', '2017-08-13'),
(60030706003, '$2y$10$ZFsXa8BMay5zYKRfVcdxFOrsu17CdlxR//fRPKSxy5kvCfwBtsoo.', 'Charlotte', 'Lopez', '1998-07-22', 'M', 1906624054808, 'Charlotte@mail.kmutt.ac.th', 'Charlotte1412@hotmail.com', 'Bachelor', 39, 'A', '2017-08-13'),
(60030707003, '$2y$10$nyDLldEGfsNC/yrHT8CCNe6k/J9u1NldK01CE3G8uK6FlyrrHhArC', 'Daisy', 'Morgan', '1998-07-17', 'M', 8729316694069, 'Daisy@mail.kmutt.ac.th', 'Daisy555@hotmail.com', 'Bachelor', 35, 'B', '2017-08-13'),
(60030708003, '$2y$10$WYmtdaCmVuq2x7A.r8GYyeqYOD6NzbTtWzNq2vXJgp7pilLx6sCOi', 'Ellie', 'Bennett', '1998-01-13', 'M', 7918428230080, 'Ellie@mail.kmutt.ac.th', 'Ellie5641@hotmail.com', 'Bachelor', 37, 'A', '2017-08-13'),
(60030709003, '$2y$10$XQNWsgenHbKjurMIj83xTezgeYS8XuRIUi3mn.Hn6IkDaTWjQ1kF2', 'Evie', 'Howard', '1998-02-04', 'M', 9889152158329, 'Evie@mail.kmutt.ac.th', 'Evie2518@hotmail.com', 'Bachelor', 38, 'B', '2017-08-13'),
(60030801003, '$2y$10$MblRMPx7n3v.tD4i0VUhFO6fNmDfU71UgyYQoWUSxzfF0Z2gyZjIu', 'Gracie', 'Martinez', '1998-03-12', 'F', 5750844068106, 'Gracie@mail.kmutt.ac.th', 'Gracie5298@hotmail.com', 'Bachelor', 41, 'A', '2017-08-13'),
(60030802003, '$2y$10$JAcZczNGhgWXDv2ITA/xueEH8bBSoiO3arBrCYu67F2G1MM30E5dC', 'Ginny', 'Morris', '1998-02-11', 'F', 1243491861612, 'Ginny@mail.kmutt.ac.th', 'Ginny3315@hotmail.com', 'Bachelor', 50, 'B', '2017-08-13'),
(60030803003, '$2y$10$XPdaprEcKuQgEenkJSYTJu7pnNmC8htLbFPJwwvDK6YLM8NuecdvS', 'Harmony', 'Parker', '1998-03-19', 'M', 4399732999993, 'Harmony@mail.kmutt.ac.th', 'Harmony888@hotmail.com', 'Bachelor', 43, 'C', '2017-08-13'),
(60030804003, '$2y$10$gjo76MrhOY/WRGBpmOmeJeAnxJ25pGRmhxywSX1KiFz4XR5m4PN6.', 'Irene', 'Peterson', '1998-03-05', 'F', 5199819843758, 'Irene@mail.kmutt.ac.th', 'Irene2188@hotmail.com', 'Bachelor', 44, 'D', '2017-08-13'),
(60030805003, '$2y$10$loujSrvpysYXzOvQ/.8SzuF4K2h4yfRtf3liX7Nn1wHSGUDlNpBGe', 'Jade', 'Roberts', '1998-02-11', 'M', 9610444322173, 'Jade@mail.kmutt.ac.th', 'Jade4512@hotmail.com', 'Bachelor', 46, 'C', '2017-08-13'),
(60030806003, '$2y$10$t9c3ydXzBBPteyoK5kfuPuukOx4oRLXdBgnqKta7zExkpBjNS2Gli', 'Jasmine', 'Stewart', '1998-02-11', 'F', 6881807486275, 'Jasmine@mail.kmutt.ac.th', 'Jasmine3312@hotmail.com', 'Bachelor', 47, 'D', '2017-08-13'),
(60030807003, '$2y$10$z8MuPejUM4oHfQOofmMw1.lK3LHetJVnXo9OVcM0dLS1pGmjF7FRO', 'Jolie', 'Thomson', '1998-07-15', 'F', 3268077998791, 'Jolie@mail.kmutt.ac.th', 'Jolie3368@hotmail.com', 'Bachelor', 49, 'A', '2017-08-13'),
(60030808003, '$2y$10$I27o1OxXt4IZqqL8i9/WYeQqG/3eAswQqZAJnAOzMMyfms4iBSCC.', 'Kate', 'Watson', '1998-03-20', 'F', 3268077998791, 'Kate@mail.kmutt.ac.th', 'Kate3310@hotmail.com', 'Bachelor', 26, 'B', '2017-08-13'),
(61030401003, '$2y$10$bjS6qkwSdc/SevXY3rPAG.0wIIf8I9sX767g36PrArIIk5X9juPqW', 'Rati', 'Chomsuwan', '1999-06-11', 'M', 2649494293071, 'rati@mail.kmutt.ac.th', 'ratizaza007@hotmail.com', 'Bachelor', 6, 'A', '2018-08-13'),
(61030402003, '$2y$10$GLXhnH0dqL9jTEU6M5jn2OZE9hHxhAz8QyppnLivYIMi8oMl7FkTa', 'Kulchaya', 'Songkwan', '1999-06-27', 'F', 1110498306647, 'Kulchaya@mail.kmutt.ac.th', 'Kulchayazeza007@hotmail.com', 'Bachelor', 6, 'A', '2018-08-13'),
(61030403003, '$2y$10$jaj8HouYkpaJ9ZuGi9bxPeONSLElomnwg102GZiy5o43cX/y/PE8W', 'Chotiya', 'Pertpring', '1999-03-11', 'F', 2780879491787, 'Chotiya@mail.kmutt.ac.th', 'Chotiya005@hotmail.com', 'Bachelor', 6, 'A', '2018-08-13'),
(61030404003, '$2y$10$djOeZrPbhNUhsg8/XEAtneg.6D5StT8Vzkcqn1HwttjWpNUin5qMG', 'Nattanon', 'Srijan', '1999-03-18', 'M', 3097845694821, 'Nattanon@mail.kmutt.ac.th', 'Nattanon004@hotmail.com', 'Bachelor', 6, 'B', '2018-08-13'),
(61030405003, '$2y$10$CWCa3EfTEeffnTPc4a47f./ZrTWOQsEZG2GrsfZLPwIgkR7OTzv2.', 'Nacha', 'Hirunyakarn', '1999-07-08', 'F', 1372052395429, 'Nacha@mail.kmutt.ac.th', 'Nacha8154@hotmail.com', 'Bachelor', 6, 'A', '2018-08-13'),
(61030406003, '$2y$10$XGbTN2Cf/BhLA6SG8v6q3ORyUd20qVZu98dPwkMy7wJ.yzrmRBoyy', 'Thanadol', 'Mattra', '1999-03-18', 'M', 6304666156611, 'Thanadol@mail.kmutt.ac.th', 'Thanadol3314@hotmail.com', 'Bachelor', 6, 'A', '2018-08-13'),
(61030407003, '$2y$10$JT1riMhsttacv9cAQVSqxezjsq/IjtIRRueUWcpKQZf.J1uIkC8n.', 'Teerat', 'Chansawang', '1999-08-17', 'M', 7939939341155, 'Teerat@mail.kmutt.ac.th', 'Teerat8845@hotmail.com', 'Bachelor', 6, 'B', '2018-08-13'),
(61030408003, '$2y$10$PMiKT08d.5n96tUc2juiwOzZ/KVYHcyvQDmDMSoj67/SoNd4PduFq', 'Patthachaput', 'Thanesmaneerat', '1999-07-16', 'M', 8958189171060, 'Patthachaput@mail.kmutt.ac.th', 'Patthachaput4523@hotmail.com', 'Bachelor', 5, 'D', '2018-08-13'),
(61030409003, '$2y$10$ZX2Mo/yUi/31xrrM6OB06uGBVlIE4qQ7yWdD5KVJevvhJOA8H1tS2', 'Pithawat', 'Limwiali', '1999-03-18', 'M', 7038009034221, 'Pithawat@mail.kmutt.ac.th', 'Pithawat001@hotmail.com', 'Bachelor', 5, 'C', '2018-08-13'),
(61030501003, '$2y$10$rMUCPnHg0O.gO/3OLh94g.ZvZudELPJa0DLma.cu/zgVO1ixk3tY.', 'Pavat', 'Poonpinij', '1999-06-17', 'M', 4101369528924, 'Pavat@mail.kmutt.ac.th', 'Pavat005@hotmail.com', 'Bachelor', 7, 'A', '2018-08-13'),
(61030502003, '$2y$10$cLAdUcbKcfRfmG4dHxc.p.d3VSuhcNBMTnFuGbymHG.scd.kziO8m', 'Wagee', 'Alex', '1999-06-09', 'F', 9384385854841, 'Wagee@mail.kmutt.ac.th', 'Wagee3310@hotmail.com', 'Bachelor', 7, 'A', '2018-08-13'),
(61030503003, '$2y$10$dDSG4pr7fy/V8bWWcu7PTujY1d7Bbs48ZZ/y6ttJ1iVf75LYKSVAS', 'Siriphorn', 'Jarisu', '1999-03-19', 'F', 3710755771026, 'Siriphorn@mail.kmutt.ac.th', 'Siriphorn3370@hotmail.com', 'Bachelor', 7, 'B', '2018-08-13'),
(61030504003, '$2y$10$WZoS2qrCS/A2snJZp5MQqOg240XbLXhDtiMFDDZl4Witl4512vqyK', 'Supavadee', 'Phusanam', '1999-03-11', 'F', 1082921474008, 'Supavadee@mail.kmutt.ac.th', 'Supavadee4410@hotmail.com', 'Bachelor', 1, 'C', '2018-08-13'),
(61030505003, '$2y$10$esIQkBQCR5YAFq3Zt3BEjOwmnJRXCQWB4R2L5tbfFApaKMUH554hG', 'Natthasit', 'Chunhaworawong', '1999-11-18', 'M', 8233263248221, 'Natthasit@mail.kmutt.ac.th', 'Natthasit8815@hotmail.com', 'Bachelor', 2, 'B', '2018-08-13'),
(61030506003, '$2y$10$xNEvqNCw2WcJkPXioAC12O46ftvU48qZQ1hGBP.9UyVol86mRDjwC', 'Pahsawee', 'Pansrithong', '1999-03-23', 'F', 3325472241304, 'Pahsawee@mail.kmutt.ac.th', 'Pahsawee1245@hotmail.com', 'Bachelor', 4, 'A', '2018-08-13'),
(61030507003, '$2y$10$lJCAuRm67bBr1bgbmVW8SeycSn2AWxINKPOtelUf2DhGb3sivqCVW', 'Narapathra', 'MorakrantMorakrant', '1999-03-24', 'F', 5710768850589, 'Narapathra@mail.kmutt.ac.th', 'Narapathra4562@hotmail.com', 'Bachelor', 8, 'D', '2018-08-13'),
(61030508003, '$2y$10$eFWaEl3uJkZlkU0VRDezY.8QQ92g5TMy4fBEnUTVmzAtz1knT52qC', 'Narapathra', 'MorakrantMorakrant', '1999-07-15', 'F', 5710768850589, 'Narapathra@mail.kmutt.ac.th', 'Narapathra4562@hotmail.com', 'Bachelor', 10, 'A', '2018-08-13'),
(61030509003, '$2y$10$cBb2ZvEedQnLPxW1etldDeaGd1Yks8KCT6g7zeE45wWSgOaHXORYa', 'Dawit', 'Jintaviriyasakul', '1999-02-16', 'F', 4501272228337, 'Dawit@mail.kmutt.ac.th', 'Dawit7715@hotmail.com', 'Bachelor', 11, 'D', '2018-08-13'),
(61030601003, '$2y$10$7.EngzITHsHzTfYI0w0JTuHo6TXTWWmF4h2BIxMDEzLEpgFv2pT7.', 'Pongsatorn', 'Watcharawanitwong', '1999-07-08', 'F', 4459407162795, 'Pongsatorn@mail.kmutt.ac.th', 'Pongsatorn9754@hotmail.com', 'Bachelor', 13, 'A', '2018-08-13'),
(61030602003, '$2y$10$izwg6fhYF4dkO3zqFyEQwO2Mbu3MB4/OWwhSLMZPR2L5KEjFmlIjq', 'Watcharapol', 'Chaiyachot', '1999-12-02', 'F', 1543643702161, 'Watcharapol@mail.kmutt.ac.th', 'Watcharapol555@hotmail.com', 'Bachelor', 14, 'B', '2018-08-13'),
(61030603003, '$2y$10$SItnBrjRRX8SkwURwZ.XwOinOS2B0.xHHysvUC1bQiPNh0TkWbZMq', 'Chalermsak', 'Pinwiset', '1999-07-08', 'M', 1389951230119, 'Chalermsak@mail.kmutt.ac.th', 'Chalermsak7842@hotmail.com', 'Bachelor', 16, 'A', '2018-08-13'),
(61030604003, '$2y$10$rSt7WTfl0eYm8CS.W3dSuet7f8XwuiAu90VQYlE8Pr0kMS.H21CJq', 'Thanaporn', 'Thanapornsombat', '1999-09-15', 'M', 9999781843395, 'Thanaporn@mail.kmutt.ac.th', 'Thanaporn3334@hotmail.com', 'Bachelor', 17, 'C', '2018-08-13'),
(61030605003, '$2y$10$3ZzdQdQQEkav.B1D5oUpIOa7G7YnVwWQTUotthfXu.p1m/k9y4wV6', 'Worakamol', 'Rerkbangplad', '1999-01-15', 'M', 7085811443321, 'Worakamol@mail.kmutt.ac.th', 'Worakamol3365@hotmail.com', 'Bachelor', 18, 'B', '2018-08-13'),
(61030606003, '$2y$10$2Tn2AlXHr1XiXb516YoMEezhSLMufUR1Qpg9/.sa273JNZf58omp6', 'Athena', 'Gray', '1999-10-13', 'F', 6345759645818, 'Athena@mail.kmutt.ac.th', 'Athena4456@hotmail.com', 'Bachelor', 20, 'A', '2018-08-13'),
(61030607003, '$2y$10$kqkfZmH0cnZg39n8jZZ.IeTyWlXFbDLdum7Ryxb9oomG4F8diDd26', 'Ammie', 'Anderson', '1999-05-11', 'F', 7067944030363, 'Ammie@mail.kmutt.ac.th', 'Ammie6580@hotmail.com', 'Bachelor', 21, 'B', '2018-08-13'),
(61030608003, '$2y$10$YYL/mVDkNolb9vBlYR937OVyzQ8xM7/soBO8jpRSDzdF0jO1Wxl6m', 'Abigail', 'Bennett', '1999-04-09', 'F', 6950663038538, 'Abigail@mail.kmutt.ac.th', 'Abigail1143@hotmail.com', 'Bachelor', 23, 'A', '2018-08-13'),
(61030609003, '$2y$10$UD0ZJHx/.mt98i2ByTuLveFb1tpWbglO7KKMoE2gw.oNHGraf.dPy', 'Amy', 'Carter', '1999-06-17', 'F', 3983319612359, 'Amy@mail.kmutt.ac.th', 'Amy1112@hotmail.com', 'Bachelor', 24, 'B', '2018-08-13'),
(61030701003, '$2y$10$CSplnoGAWzF/Twxi1.8xzearvb7PrhL6UXmN2Jw.TZSBacM1Iauia', 'Alexandra', 'Collins', '1999-08-12', 'M', 8071124220823, 'Alexandra@mail.kmutt.ac.th', 'Alexandra8874@hotmail.com', 'Bachelor', 28, 'A', '2018-08-13'),
(61030702003, '$2y$10$5CvCoeQeOhbjkgu0dP2N3ul6X3/OJmNL37PfGOcAjVEZ99ogG5GaC', 'Amity', 'Gonzalez', '1999-08-12', 'M', 7854683861712, 'Amity@mail.kmutt.ac.th', 'Amity3345@hotmail.com', 'Bachelor', 29, 'B', '2018-08-13'),
(61030703003, '$2y$10$rXIbHrwXMP7tvn8NQ7A6luQdZYyXJyaSfgFAYmAXJyBNFUoQfoX8O', 'Anissa', 'Jackson', '1999-07-15', 'M', 5385496584564, 'Anissa@mail.kmutt.ac.th', 'Anissa1563@hotmail.com', 'Bachelor', 31, 'A', '2018-08-13'),
(61030704003, '$2y$10$cakWhYIO59zaYLC1wyeDr.00GtX87D7T.Tv9A2RvOfBgjnQxaEpSO', 'Camilla', 'Lewis', '1999-06-16', 'F', 6610856955462, 'Camilla@mail.kmutt.ac.th', 'Camilla777@hotmail.com', 'Bachelor', 32, 'B', '2018-08-13'),
(61030705003, '$2y$10$fs0yWp.i6qhUM/lSQAuht.nE0ldgBsYbB0rFbJ1KFFhEvmbIjjWk.', 'Casey', 'Johnson', '1999-07-14', 'F', 6126199693637, 'Casey@mail.kmutt.ac.th', 'CaseyCasey777@hotmail.com', 'Bachelor', 34, 'A', '2018-08-13'),
(61030706003, '$2y$10$XLODeWmTAdEu0kzfKdZp1er12tAXX3Gu8eCTwmVpS..Cq4beqlRhy', 'Chloe', 'Martin', '1999-07-09', 'M', 6923494717592, 'Chloe@mail.kmutt.ac.th', 'Chloe3312@hotmail.com', 'Bachelor', 39, 'B', '2018-08-13'),
(61030707003, '$2y$10$3/22E7FBASPHoGvwe1JKhOMGnn1x2gr8EX0QiPB8CF.qVldOYgNOa', 'Darlene', 'Morris', '1999-08-12', 'F', 9102972082110, 'Darlene@mail.kmutt.ac.th', 'Darlene5512@hotmail.com', 'Bachelor', 36, 'A', '2018-08-13'),
(61030708003, '$2y$10$ZLZexhpQ.xlX2sN8vESxf.X9gY49n2RmEuBvz6PhSxENY1mIRV3ly', 'Emma', 'Edwards', '1999-11-18', 'F', 1893205430604, 'Emma@mail.kmutt.ac.th', 'Emma5513@hotmail.com', 'Bachelor', 37, 'B', '2018-08-13'),
(61030709003, '$2y$10$AmD1B22xKy1gFzDJuLiMruMiMxC8Mlu.NmPx112o.55Qk2hfbxYXi', 'Gabriella', 'Kelly', '1999-08-12', 'M', 9703908215606, 'Gabriella@mail.kmutt.ac.th', 'Gabriellazaza@hotmail.com', 'Bachelor', 40, 'A', '2018-08-13'),
(61030801003, '$2y$10$l7RLfsOpXqLVpPbD3uumUejIWyLOAH/sZ8XnuILxMDWDbZGK4XOr.', 'Genesis', 'Miller', '1999-08-12', 'M', 9216011631161, 'Genesis@mail.kmutt.ac.th', 'Genesis1186@hotmail.com', 'Bachelor', 41, 'B', '2018-08-13'),
(61030802003, '$2y$10$uiOR1mpXk48vWjbP2VCAFO0wToLNfxm9G15c2KK5qajEl7xOUAZzi', 'Hannah', 'Nelson', '1999-08-13', 'M', 2101824704882, 'Hannah@mail.kmutt.ac.th', 'Hannah5543@hotmail.com', 'Bachelor', 42, 'C', '2018-08-13'),
(61030803003, '$2y$10$NBPL5sIGZCBkobfU4qM5netzhnqLx/t5FEtPFuPXGRGjMnTurhWAC', 'Holly', 'Peretz', '1999-07-14', 'M', 2143181024924, 'Holly@mail.kmutt.ac.th', 'Holly@mail.kmutt.ac.th', 'Bachelor', 43, 'D', '2018-08-13'),
(61030804003, '$2y$10$13fttSYlNGjFiKrmp5QAGeoH.igXWGpMrtc08f6caRBWc8MQXLuFm', 'Iris', 'Peterson', '1999-07-08', 'M', 7315228145260, 'Iris@mail.kmutt.ac.th', 'Iris2623@hotmail.com', 'Bachelor', 45, 'C', '2018-08-13'),
(61030805003, '$2y$10$kdFxVqZ6P1xfVoDhXPo3YOlawJoBqti9XoEusH3fg5FSx151MElh2', 'Jamille', 'Robinson', '1999-07-15', 'M', 6710035590184, 'Jamille@mail.kmutt.ac.th', 'Jamille5415@hotmail.com', 'Bachelor', 46, 'D', '2018-08-13'),
(61030806003, '$2y$10$7LKIE1kPlidL88LyMJd5E.U6lS14mYtskEAwNTYpLQDNfe5JokvJm', 'Jennifer', 'Taylor', '1999-07-15', 'M', 7720207136034, 'Jennifer@mail.kmutt.ac.th', 'Jennifer3152@hotmail.com', 'Bachelor', 48, 'A', '2018-08-13'),
(61030807003, '$2y$10$420am.5v.Mckb5GAxJW.ruKY.GWPOORj7sk1eGyIw6szo88kCSvj.', 'Julia', 'Walker', '1999-03-18', 'F', 3010099297374, 'Julia@mail.kmutt.ac.th', 'Julia5153@hotmail.com', 'Bachelor', 49, 'A', '2018-08-13'),
(61030808003, '$2y$10$ZoiSDNXvrU7zoIyfcZSX2.W/UwKhVaG0uIN6mWjx60vypNccNFiFi', 'Katherine', 'Williams', '1999-07-08', 'M', 3010099297374, 'Katherine@mail.kmutt.ac.th', 'Katherine8485@hotmail.com', 'Bachelor', 27, 'A', '2018-08-13'),
(62070501003, '$2y$10$xrddXTEx/nbYptKQyQ90fOlYPxHZJLMK5wTsoqYNGHSQw14Uwn0bC', 'Kittipol', 'Srithong', '2000-06-15', 'M', 2514177738192, 'Kittipol@mail.kmutt.ac.th', 'dome4785@hotmail.com', 'Bachelor', 6, 'B', '2019-08-13'),
(62070502003, '$2y$10$ZzanrZQFzCzwKNDGlgL2auXIDwVvvOWVhiF4t459/IemexSgaPLfS', 'Jatnipat', 'Sawad', '2000-02-10', 'M', 6025381545745, 'Jatnipat@mail.kmutt.ac.th', 'Jatnipat1412@hotmail.com', 'Bachelor', 6, 'B', '2019-08-13'),
(62070503402, '$2y$10$CYORevZq75rlDb/stELwH.rLsuNt4LAeWseCZ9yw.JFFXkmVpUMRG', 'Krittin', 'Srithong', '2021-02-16', 'M', 1959900717546, 'krittin.srithong@mail.kmutt.ac.th', 'swd.xpong@gmail.com', 'Bachelor', 5, 'C', '2019-08-13'),
(62070503403, '$2y$10$P6bxrL2dSWam/AREJGj.seWuj4gv/MQgY0vzw.xH3aCJ8Y9lRPqqK', 'John', 'Cena', '2000-05-09', 'M', 12330192222, 'sad@mail.kmutt.ac.th', 'sad@gmail.com', 'Bachelor', 26, 'C', '2018-08-13'),
(62070503414, '$2y$10$i18vjvDrMADWCpWnt8YvEuc/yMrtInrA.3oFwY9vqFKkxLHk7CsUW', 'Thanasit', 'Suwanposri', '2000-10-25', 'M', 1102200172459, 'thanasit.cpe33@mail.kmutt.ac.th', 'menthanasit@gmail.com', 'Bachelor', 5, 'C', '2019-08-13'),
(62070503448, '$2y$10$L9d6xIIRTl.X1lRwcKsL3.ODetXAH567SEFzdtf82BiGmVOr7vA1a', 'Siriphorn', 'Jarisu', '2001-03-05', 'F', 1399900130176, 'siriphorn.jar@mail.kmutt.ac.th', 'sjnoolek@hotmail.com', 'Bachelor', 5, 'D', '2019-08-13'),
(62070504003, '$2y$10$2xTyPAP94k.a8M5k4H8sYumql/2AoKmWe6tq.x7hu8w/wbeS.iNq.', 'Nattawut', 'Suwanposri', '2000-01-14', 'M', 4928711038858, 'Nattawut@mail.kmutt.ac.th', 'Nattawut555@hotmail.com', 'Bachelor', 6, 'B', '2019-08-13'),
(62070505003, '$2y$10$8q8POBmgsYi6dlCh/g9/gejl1P9aVgPzquXg/9QdDjaLN.m5367kC', 'Doonlayatis', 'Kitsakulpaisan', '2000-09-14', 'M', 7684207690630, 'Doonlayatis@mail.kmutt.ac.th', 'Doonlayatis741@hotmail.com', 'Bachelor', 6, 'B', '2019-08-13'),
(62070506003, '$2y$10$d.1wnCzasli2NFbjO27XOehUt6rcRLEtbkh1.AIHAJMoTAXdq1bQO', 'Thanatip', 'Lertboonchu', '2000-09-08', 'M', 9710366853187, 'Thanatip@mail.kmutt.ac.th', 'Thanatip2287@hotmail.com', 'Bachelor', 6, 'A', '2019-08-13'),
(62070507003, '$2y$10$L8gpSlv.WUGnn0eIxAy1R.2fDCptYcrKMaICcH5p6uyWIgW0UeEVO', 'Nithi', 'Piyaphonnarinthon', '2000-03-08', 'M', 1306839749563, 'Nithi@mail.kmutt.ac.th', 'Nithi7741@hotmail.com', 'Bachelor', 5, 'C', '2019-08-13'),
(62070508003, '$2y$10$9tvj8wJhvEmnnj7CuFhzCez/t4LU7doTqt4GdtQOV/r/begU0g7rW', 'Pralaphat', 'Wattanachai', '2000-03-02', 'M', 5501671835570, 'Pralaphat@mail.kmutt.ac.th', 'Pralaphat4512@hotmail.com', 'Bachelor', 5, 'C', '2019-08-13'),
(62070509003, '$2y$10$NicHVh.Rgbjq00TNwifM4OeiNFHEgMHss2dpo/BJ/LN.YvFb.ay/.', 'Pirada', 'Amornprapawat', '2000-04-07', 'F', 3925707150788, 'Pirada@mail.kmutt.ac.th', 'Pirada4481@hotmail.com', 'Bachelor', 5, 'D', '2019-08-13'),
(62070601003, '$2y$10$yqX1RPwf2u3TVvTyzXGEcuF19JtZhmfagsElfT6SnuB5IwrBhoPs.', 'Phumiphat', 'Tatiyawongsoonthorn', '2000-07-18', 'M', 5241098209787, 'Phumiphat@mail.kmutt.ac.th', 'Phumiphat5514@hotmail.com', 'Bachelor', 7, 'B', '2019-08-13'),
(62070602003, '$2y$10$JEQ.wkfEp4DtZitZAtWCp.GmdnEg43IRr7r/HQCYj6lohASfrozDW', 'Worachot', 'Yuwamirt', '2000-07-11', 'M', 8823264537476, 'Worachot@mail.kmutt.ac.th', 'Worachot1146@hotmail.com', 'Bachelor', 7, 'A', '2019-08-13'),
(62070603003, '$2y$10$FI3dMJH6OZCrILWq3ZYtJuvDuQUGFypSlfnFepnqbkfPol/fGMa2e', 'Supakorn', 'Srisawas', '2000-07-12', 'M', 8646015053615, 'Supakorn@mail.kmutt.ac.th', 'Supakorn1150@hotmail.com', 'Bachelor', 7, 'A', '2019-08-13'),
(62070604003, '$2y$10$OFI2WV5kdTKwbEjM31j7GehN93PUAX2GDAyRJah1NXrbwqRHyL0N6', 'Annop', 'Pornsawatdipak', '2000-02-16', 'M', 9105321742645, 'Annop@mail.kmutt.ac.th', 'Annop9975@hotmail.com', 'Bachelor', 1, 'D', '2019-08-13'),
(62070605003, '$2y$10$lPxtf.1aNFZlo3kKcR21gelx5Z1v243Goy2326FQlyBQUeVHwiLvu', 'Kantawit', 'Chanan', '2000-02-10', 'M', 1153881159085, 'Kantawit@mail.kmutt.ac.th', 'Kantawit1145@hotmail.com', 'Bachelor', 3, 'C', '2019-08-13'),
(62070606003, '$2y$10$I3ZkD2izKBHW5ViP4CLAwudmmwT3/SxV6jU4/CCmEXc6WMf4Lyw.a', 'Thanapat', 'Jaipram', '2000-06-14', 'M', 2484296974125, 'Thanapat@mail.kmutt.ac.th', 'Thanapat1712@hotmail.com', 'Bachelor', 4, 'B', '2019-08-13'),
(62070607003, '$2y$10$xncmWqpkIveGzsV1hyDicuDoqGzAU8q5Y0sMeAybSxSiaGOJ9ORJ.', 'Tanapon', 'Jarernchaidee', '2000-05-17', 'M', 6992463717191, 'Tanapon@mail.kmutt.ac.th', 'Tanapon1143@hotmail.com', 'Bachelor', 9, 'A', '2019-08-13'),
(62070608003, '$2y$10$F4YYNXDt8as.kOQgeMo6Q.rFRbp0rzwUOUGtHs8T98V4cuELkg7z2', 'Kaivitch', 'Cainan', '2000-10-19', 'M', 9147953981991, 'Kaivitch@mail.kmutt.ac.th', 'Kaivitch4512@hotmail.com', 'Bachelor', 10, 'B', '2019-08-13'),
(62070609003, '$2y$10$niQ5wNZaQx0ZHa5MQQk4ae.A0/bg.Q.1F0/chBSYQXhVwdMlJYoWa', 'Thanachote', 'Angkalakkana', '2000-12-14', 'M', 1089001159093, 'Thanachote@mail.kmutt.ac.th', 'Thanachotezaza555@hotmail.com', 'Bachelor', 12, 'A', '2019-08-13'),
(62070701003, '$2y$10$c8396VQVkOtTsrSjBBSMO.0nyA2BBv0V6FVW2CFm7a7qtXfoRhGty', 'Monthonthong', 'Panrungsri', '2000-01-08', 'M', 4927664728775, 'Monthonthong@mail.kmutt.ac.th', 'Monthonthong3310@hotmail.com', 'Bachelor', 13, 'B', '2019-08-13'),
(62070702003, '$2y$10$fAjvWcPo0UFe1w/pN0gu5eCyuON3tRE49Xxgk5QMJAICSmlhxdOIm', 'Satita', 'Threeporn', '2000-08-17', 'F', 2994433673534, 'Satita@mail.kmutt.ac.th', 'Satita6678@hotmail.com', 'Bachelor', 15, 'A', '2019-08-13'),
(62070704003, '$2y$10$lMBTKNgA8XQ6kaQ7OUsE6.Rcsf.foBDevsdfgMZshOiAWx67KG.z.', 'Thanapat', 'Saelao', '2000-08-18', 'M', 2266428953425, 'Thanapat@mail.kmutt.ac.th', 'Thanapat1150@hotmail.com', 'Bachelor', 17, 'D', '2019-08-13'),
(62070705003, '$2y$10$XsXBzLWomoPXq8wCgo1ESerCIkIPId11.bPDtzTNZ//hRYOJSZi0S', 'Darunee', 'Sittichai', '2000-08-18', 'F', 8479186852690, 'Darunee@mail.kmutt.ac.th', 'Daruneezaza@hotmail.com', 'Bachelor', 19, 'A', '2019-08-13'),
(62070706003, '$2y$10$qXxrIyKFEsjo4REojEFECOqN8oSL0pzx.n1CKnL0RbAeazBwYxWum', 'Arista', 'Alexander', '2000-03-16', 'F', 6875638500342, 'Arista@mail.kmutt.ac.th', 'Arista4523@hotmail.com', 'Bachelor', 20, 'B', '2019-08-13'),
(62070707003, '$2y$10$u5yELlTPlJdo8OOaf5EncOJF7i1BzqnWpJKFvfiqUQJOHtnErHnzO', 'Alyssa', 'Baker', '2000-03-16', 'F', 8217228121108, 'Alyssa@mail.kmutt.ac.th', 'Alyssa1150@hotmail.com', 'Bachelor', 22, 'A', '2019-08-13'),
(62070708003, '$2y$10$Lu7or.tYVpv5oQC8W/aqZO4YmK3l.CyrmxK2n1esJVGqXSd39D1FG', 'Amber', 'Campbell', '2000-06-14', 'F', 4740521566612, 'Amber@mail.kmutt.ac.th', 'Amber1184@hotmail.com', 'Bachelor', 23, 'B', '2019-08-13'),
(62070709003, '$2y$10$rlmx/t3XAxpXnuG3fRN7guzUx7naMCnya.61divWOM41zPYq/ea6C', 'Ava', 'Adams', '2020-02-06', 'F', 3858641922161, 'Ava@mail.kmutt.ac.th', 'Ava45885@hotmail.com', 'Bachelor', 25, 'A', '2019-08-13'),
(62070801003, '$2y$10$V.RysL/wdjitmOXtnqvP6eltPiNj4wgohU5GLV0bwuC9hBVECUIqK', 'Alice', 'Edwards', '2000-11-16', 'F', 3656836245401, 'Alice@mail.kmutt.ac.th', 'Alice3385@hotmail.com', 'Bachelor', 28, 'B', '2019-08-13'),
(62070802003, '$2y$10$bNT1bIhzA0zdyB320bjqM.VXFrU3p/F1QFer1RL8aXrjTSzGTMEre', 'Andrea', 'Henderson', '2000-08-15', 'F', 7188684498450, 'Andrea@mail.kmutt.ac.th', 'Andrea9654@hotmail.com', 'Bachelor', 30, 'A', '2019-08-13'),
(62070803003, '$2y$10$GokOvSuFvED9oGNLieuf2.aKNDIs1ZI9jeudjUZD.FzPJwttDlDVe', 'Anna', 'Johnson', '2000-08-17', 'F', 8436051123506, 'Anna@mail.kmutt.ac.th', 'Anna3351@hotmail.com', 'Bachelor', 31, 'B', '2019-08-13'),
(62070804003, '$2y$10$2Ijam9vqc8xmTbo8uhsB2e9P3cIDnrAt8qvoHd8dYmG1nxvUrsxP.', 'Cara', 'Kelly', '2000-07-06', 'F', 5696169780962, 'Cara@mail.kmutt.ac.th', 'Cara8888@hotmail.com', 'Bachelor', 33, 'A', '2019-08-13'),
(62070805003, '$2y$10$LJB4ZBiis/p77bhZVciKous1ozOZjEl0TQZXggYe0FcbM7SlqLrMe', 'Cayla', 'Lewis', '2000-07-14', 'F', 8645952827314, 'Cayla@mail.kmutt.ac.th', 'Cayla8486@hotmail.com', 'Bachelor', 34, 'B', '2019-08-13'),
(62070806003, '$2y$10$Ck46SPP1YaPjBVBn4j8PS.mrsP7RhL7W4SfivYKbXAkfNrXuo5W.K', 'Claire', 'Miller', '2000-06-16', 'M', 4881788592839, 'Claire@mail.kmutt.ac.th', 'Claire3319@hotmail.com', 'Bachelor', 35, 'A', '2019-08-13'),
(62070807003, '$2y$10$jN7tkDlebWoPwgDOPwwEpe/KnHO42FCUnwTydiSO0IuEhHnK2t73G', 'Ella', 'Nelson', '2000-03-10', 'F', 6168139484740, 'Ella@mail.kmutt.ac.th', 'Ella777@hotmail.com', 'Bachelor', 36, 'B', '2019-08-13'),
(62070808003, '$2y$10$7cOsufZo0VrH.3FbQjcPHedqQW8hZTlwXruP6ToinnmQ0E.Q1lDae', 'Eva', 'Johnson', '2000-02-16', 'M', 4466887587032, 'Eva@mail.kmutt.ac.th', 'Eva3125@hotmail.com', 'Bachelor', 38, 'A', '2019-08-13'),
(62070809003, '$2y$10$ZOZVSkTZ6s6WSPTO6kwj3ejEhKL/.YQ25n7BTpQF9kjDGKMPVVDbW', 'Grace', 'Martin', '2000-07-19', 'M', 5266289181415, 'Grace@mail.kmutt.ac.th', 'Grace3310@hotmail.com', 'Bachelor', 40, 'B', '2019-08-13'),
(62070901003, '$2y$10$ksrwbAF4NgfSpmpTF0pyDukBahHhW.qOGGoy.lezRKIpbJoS4ugLW', 'Gianna', 'Morgan', '2000-06-14', 'F', 7355533839733, 'Gianna@mail.kmutt.ac.th', 'Gianna5582@hotmail.com', 'Bachelor', 50, 'A', '2019-08-13'),
(62070902003, '$2y$10$fxc0j5XZgSh52r6LF10pku/HbTrZCouP0sgM75w4oDxdw0HxEvdmG', 'Helena', 'Miller', '2000-03-10', 'M', 7387376015366, 'Helena@mail.kmutt.ac.th', 'Helena8486@hotmail.com', 'Bachelor', 42, 'D', '2019-08-13'),
(62070903003, '$2y$10$NaqDO8Qem8wD.Jy6xT0GbegLhpRKiP2o9sNbLjm6dFtc6pTLdX9UG', 'Honey', 'Perry', '2000-01-11', 'M', 1667929465899, 'Honey@mail.kmutt.ac.th', 'Honey333@hotmail.com', 'Bachelor', 44, 'C', '2019-08-13'),
(62070904003, '$2y$10$sw7kgUp7AoW1bVrr/72naucL0SWdUjOcR5nIxc8MmlMGsPj8fZVqi', 'Isabella', 'Powell', '2000-03-16', 'M', 4895489894607, 'Isabella@mail.kmutt.ac.th', 'Isabella222@hotmail.com', 'Bachelor', 45, 'D', '2019-08-13'),
(62070905003, '$2y$10$t1ZHwjr6yLCwi4NizfyIXuacZZeA4aH0Nulx2CfN5oS4ow2z/OWRK', 'Jane', 'Rogers', '2000-07-13', 'M', 4510506963959, 'Jane@mail.kmutt.ac.th', 'Jane4585@hotmail.com', 'Bachelor', 47, 'A', '2019-08-13'),
(62070906003, '$2y$10$QsCtM59XmdyLh3doSH9f7uIeZp8/AdTWgTUPna1hzZJzloOZYMHky', 'Jessica', 'Thomas', '2000-07-13', 'F', 5331704576961, 'Jessica@mail.kmutt.ac.th', 'Jessica2210@hotmail.com', 'Bachelor', 48, 'B', '2019-08-13'),
(62070907003, '$2y$10$CSu688tnmYjQoWerUrWkM.2icB/do3lkc19P/nL7x1gn30tQ.QxzC', 'Karishma', 'Washington', '2000-06-14', 'F', 3902268459825, 'Karishma@mail.kmutt.ac.th', 'Karishma5155@hotmail.com', 'Bachelor', 26, 'A', '2019-08-13'),
(62070908003, '$2y$10$FWuQ62Bj.nNWWkwZ3eVQGOMr2kujuEHsLsZ5FyRWZ6f.yP53PxF1i', 'Katie', 'Walker', '2000-08-18', 'M', 3902268459825, 'Katie@mail.kmutt.ac.th', 'Katie5623@hotmail.com', 'Bachelor', 27, 'B', '2019-08-13');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `advisor`
--
ALTER TABLE `advisor`
  ADD PRIMARY KEY (`std_id`,`tch_id`),
  ADD KEY `advisor_tch_id_foreign` (`tch_id`);

--
-- Indexes for table `classinfo`
--
ALTER TABLE `classinfo`
  ADD PRIMARY KEY (`ClassCode`),
  ADD KEY `DepartmentID` (`DepartmentID`);

--
-- Indexes for table `classSec`
--
ALTER TABLE `classSec`
  ADD PRIMARY KEY (`ClassCode`,`SectionNo`) USING BTREE,
  ADD KEY `ClassCode` (`ClassCode`);

--
-- Indexes for table `depInfo`
--
ALTER TABLE `depInfo`
  ADD PRIMARY KEY (`DepartmentID`),
  ADD KEY `FacultyID` (`FacultyID`);

--
-- Indexes for table `facInfo`
--
ALTER TABLE `facInfo`
  ADD PRIMARY KEY (`FacultyID`);

--
-- Indexes for table `programInfo`
--
ALTER TABLE `programInfo`
  ADD PRIMARY KEY (`ProgramID`),
  ADD KEY `DepartmentID` (`DepartmentID`);

--
-- Indexes for table `register`
--
ALTER TABLE `register`
  ADD PRIMARY KEY (`RegisterID`),
  ADD KEY `register_std_id_foreign` (`std_id`);

--
-- Indexes for table `registerDetail`
--
ALTER TABLE `registerDetail`
  ADD PRIMARY KEY (`RegisterID`,`ClassCode`) USING BTREE,
  ADD KEY `ClassCode` (`ClassCode`,`SectionNo`);

--
-- Indexes for table `tchUser`
--
ALTER TABLE `tchUser`
  ADD PRIMARY KEY (`id`),
  ADD KEY `DepartmentID` (`DepartmentID`);

--
-- Indexes for table `TeacherInClass`
--
ALTER TABLE `TeacherInClass`
  ADD PRIMARY KEY (`SectionNo`,`ClassCode`,`tchID`),
  ADD KEY `teacherinclass_ibfk_2` (`tchID`),
  ADD KEY `teacherinclass_ibfk_1` (`ClassCode`,`SectionNo`);

--
-- Indexes for table `timetable`
--
ALTER TABLE `timetable`
  ADD PRIMARY KEY (`SectionNo`,`ClassCode`,`Day`) USING BTREE,
  ADD KEY `ClassCode` (`ClassCode`,`SectionNo`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ProgramID` (`ProgramID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=988;

--
-- AUTO_INCREMENT for table `depInfo`
--
ALTER TABLE `depInfo`
  MODIFY `DepartmentID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `facInfo`
--
ALTER TABLE `facInfo`
  MODIFY `FacultyID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `programInfo`
--
ALTER TABLE `programInfo`
  MODIFY `ProgramID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `register`
--
ALTER TABLE `register`
  MODIFY `RegisterID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62222222223;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `advisor`
--
ALTER TABLE `advisor`
  ADD CONSTRAINT `advisor_std_id_foreign` FOREIGN KEY (`std_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `advisor_tch_id_foreign` FOREIGN KEY (`tch_id`) REFERENCES `tchUser` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `classinfo`
--
ALTER TABLE `classinfo`
  ADD CONSTRAINT `classinfo_ibfk_1` FOREIGN KEY (`DepartmentID`) REFERENCES `depInfo` (`DepartmentID`);

--
-- Constraints for table `classSec`
--
ALTER TABLE `classSec`
  ADD CONSTRAINT `classsec_ibfk_1` FOREIGN KEY (`ClassCode`) REFERENCES `classinfo` (`ClassCode`) ON DELETE CASCADE;

--
-- Constraints for table `depInfo`
--
ALTER TABLE `depInfo`
  ADD CONSTRAINT `depinfo_ibfk_1` FOREIGN KEY (`FacultyID`) REFERENCES `facInfo` (`FacultyID`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Constraints for table `programInfo`
--
ALTER TABLE `programInfo`
  ADD CONSTRAINT `programinfo_ibfk_1` FOREIGN KEY (`DepartmentID`) REFERENCES `depInfo` (`DepartmentID`);

--
-- Constraints for table `register`
--
ALTER TABLE `register`
  ADD CONSTRAINT `register_std_id_foreign` FOREIGN KEY (`std_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `registerDetail`
--
ALTER TABLE `registerDetail`
  ADD CONSTRAINT `registerdetail_ibfk_1` FOREIGN KEY (`ClassCode`,`SectionNo`) REFERENCES `classSec` (`ClassCode`, `SectionNo`),
  ADD CONSTRAINT `registerdetail_registerid_foreign` FOREIGN KEY (`RegisterID`) REFERENCES `register` (`RegisterID`) ON DELETE CASCADE;

--
-- Constraints for table `tchUser`
--
ALTER TABLE `tchUser`
  ADD CONSTRAINT `tchuser_ibfk_1` FOREIGN KEY (`DepartmentID`) REFERENCES `depInfo` (`DepartmentID`);

--
-- Constraints for table `TeacherInClass`
--
ALTER TABLE `TeacherInClass`
  ADD CONSTRAINT `teacherinclass_ibfk_1` FOREIGN KEY (`ClassCode`,`SectionNo`) REFERENCES `classSec` (`ClassCode`, `SectionNo`) ON DELETE CASCADE,
  ADD CONSTRAINT `teacherinclass_ibfk_2` FOREIGN KEY (`tchID`) REFERENCES `tchUser` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `timetable`
--
ALTER TABLE `timetable`
  ADD CONSTRAINT `timetable_ibfk_1` FOREIGN KEY (`ClassCode`,`SectionNo`) REFERENCES `classSec` (`ClassCode`, `SectionNo`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`ProgramID`) REFERENCES `programInfo` (`ProgramID`);
COMMIT;

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