-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 29, 2025 at 10:21 AM
-- Server version: 5.7.44
-- PHP Version: 8.1.31

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: `avsagar_schedule`
--

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

--
-- Table structure for table `classTypeID`
--

CREATE TABLE `classTypeID` (
  `ID` int(11) NOT NULL,
  `classType` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `classTypeID`
--

INSERT INTO `classTypeID` (`ID`, `classType`) VALUES
(1, 'Lecture'),
(2, 'Lab'),
(3, 'Lecture/Lab');

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

--
-- Table structure for table `courseID`
--

CREATE TABLE `courseID` (
  `ID` int(11) NOT NULL,
  `courseName` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courseID`
--

INSERT INTO `courseID` (`ID`, `courseName`) VALUES
(1, 'ACAD 245: Product I'),
(2, 'ACAD 276: Dev II'),
(3, 'ACAD 324: PoD'),
(4, 'DES 313: Graphic Design in Fashion'),
(5, 'COMM 396: Fashion, Media, and Culture');

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

--
-- Table structure for table `locationID`
--

CREATE TABLE `locationID` (
  `ID` int(11) NOT NULL,
  `LocationName` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `locationID`
--

INSERT INTO `locationID` (`ID`, `LocationName`) VALUES
(1, 'IYH 110'),
(2, 'IYH 210'),
(3, 'IYH 212/213'),
(4, 'ANNL 105A'),
(5, 'IFT 122');

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

--
-- Table structure for table `Schedule`
--

CREATE TABLE `Schedule` (
  `ID` int(11) NOT NULL,
  `courseID` int(11) NOT NULL,
  `locationID` int(11) NOT NULL,
  `date` date NOT NULL,
  `startTime` time NOT NULL,
  `endTime` time NOT NULL,
  `classTypeID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Schedule`
--

INSERT INTO `Schedule` (`ID`, `courseID`, `locationID`, `date`, `startTime`, `endTime`, `classTypeID`) VALUES
(1, 3, 3, '2025-09-15', '10:00:00', '11:50:00', 3),
(2, 1, 1, '2025-09-15', '12:00:00', '13:50:00', 3),
(3, 4, 5, '2025-09-15', '15:00:00', '17:40:00', 3),
(4, 5, 4, '2025-09-16', '12:30:00', '13:50:00', 1),
(5, 2, 2, '2025-09-16', '14:00:00', '15:50:00', 3),
(6, 3, 3, '2025-09-17', '10:00:00', '11:50:00', 3),
(7, 1, 1, '2025-09-17', '12:00:00', '13:50:00', 3),
(8, 4, 5, '2025-09-17', '15:00:00', '17:40:00', 3),
(9, 5, 4, '2025-09-18', '12:30:00', '13:50:00', 1),
(10, 2, 2, '2025-09-18', '14:00:00', '15:50:00', 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `classTypeID`
--
ALTER TABLE `classTypeID`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `courseID`
--
ALTER TABLE `courseID`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `locationID`
--
ALTER TABLE `locationID`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Schedule`
--
ALTER TABLE `Schedule`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `courseID` (`courseID`),
  ADD KEY `locationID` (`locationID`),
  ADD KEY `classTypeID` (`classTypeID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `classTypeID`
--
ALTER TABLE `classTypeID`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `courseID`
--
ALTER TABLE `courseID`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `locationID`
--
ALTER TABLE `locationID`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `Schedule`
--
ALTER TABLE `Schedule`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `Schedule`
--
ALTER TABLE `Schedule`
  ADD CONSTRAINT `Schedule_ibfk_1` FOREIGN KEY (`courseID`) REFERENCES `courseID` (`ID`),
  ADD CONSTRAINT `Schedule_ibfk_2` FOREIGN KEY (`locationID`) REFERENCES `locationID` (`ID`),
  ADD CONSTRAINT `Schedule_ibfk_3` FOREIGN KEY (`classTypeID`) REFERENCES `classTypeID` (`ID`);
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 */;
