| graduates | CREATE TABLE `graduates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text CHARACTER SET latin1 NOT NULL,
  `email` text CHARACTER SET latin1 NOT NULL,
  `pronunciation` text CHARACTER SET latin1,
  `degreeLevel` text CHARACTER SET latin1 NOT NULL,
  `honors` text CHARACTER SET latin1,
  `major` text CHARACTER SET latin1 NOT NULL,
  `seniorQuote` text CHARACTER SET latin1,
  `university` int(11) NOT NULL,
  `ceremony` int(11) NOT NULL,
  `uuid` varchar(38) CHARACTER SET latin1 DEFAULT NULL,
  `isHighSchool` tinyint(1) NOT NULL DEFAULT '0',
  `graduated` tinyint(1) NOT NULL DEFAULT '0',
  `timeslot` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_university` (`university`),
  KEY `fk_ceremony` (`ceremony`),
  CONSTRAINT `graduates_ibfk_1` FOREIGN KEY (`university`) REFERENCES `universities` (`id`),
  CONSTRAINT `graduates_ibfk_2` FOREIGN KEY (`ceremony`) REFERENCES `ceremonies` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 |