--
-- Host: localhost    Database: students
-- ------------------------------------------------------


--
-- Table structure for table `counts`
--

CREATE TABLE `counts` (
  `when` int NOT NULL,
  `which` int NOT NULL,
  `count` int NOT NULL,
  PRIMARY KEY (`when`,`which`),
  KEY `fk_classes_idx` (`which`),
  CONSTRAINT `fk_calendar` FOREIGN KEY (`when`) REFERENCES `calendar` (`key`),
  CONSTRAINT `fk_classes` FOREIGN KEY (`which`) REFERENCES `classes` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `counts`
--

INSERT INTO `counts` VALUES (1,1,35),(1,2,40),(1,3,28),(1,4,23),(1,5,26),(1,6,12),(1,7,15),(1,8,25),(1,9,22),(1,10,24),(1,11,17),(1,12,50),(1,13,35),(2,1,31),(2,2,36),(2,3,32),(2,4,27),(2,5,33),(2,6,14),(2,8,24),(2,9,27),(2,10,23),(2,11,15),(2,12,43),(2,13,39),(3,1,25),(3,2,20),(3,3,18),(3,4,19),(3,5,22),(3,6,26),(3,7,18),(3,8,15),(3,9,20),(3,10,21),(3,11,23),(3,12,24),(3,13,20);


