CREATE DATABASE  IF NOT EXISTS `datawinter` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `datawinter`;
-- MySQL dump 10.13  Distrib 8.0.19, for macos10.15 (x86_64)
--
-- Host: localhost    Database: datawinter
-- ------------------------------------------------------
-- Server version	8.0.19

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `image`
--

DROP TABLE IF EXISTS `image`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `image` (
  `image_id` int NOT NULL,
  `location` varchar(25) NOT NULL,
  `type` enum('selfie','group','scape','interior','documentation') NOT NULL,
  `student_id` int NOT NULL,
  PRIMARY KEY (`image_id`),
  KEY `fk_image_student_idx` (`student_id`),
  CONSTRAINT `fk_image_student` FOREIGN KEY (`student_id`) REFERENCES `student` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `image`
--

LOCK TABLES `image` WRITE;
/*!40000 ALTER TABLE `image` DISABLE KEYS */;
INSERT INTO `image` VALUES (1,'School','documentation',1),(2,'School','documentation',1),(3,'School','documentation',1),(4,'School','documentation',1),(5,'School','documentation',1),(6,'School','documentation',1),(7,'School','documentation',1),(8,'School','documentation',1),(9,'School','documentation',1),(10,'School','documentation',1),(11,'School','documentation',1),(12,'School','documentation',1),(13,'School','documentation',1),(14,'Home','documentation',1),(15,'Home','documentation',1),(16,'Social Setting','group',1),(17,'Social Setting','group',1),(18,'Work','selfie',1),(19,'Work','selfie',1),(20,'Other','documentation',1),(21,'Social Setting','group',2),(22,'Social Setting','group',2),(23,'Social Setting','group',2),(24,'Social Setting','group',2),(25,'Social Setting','group',2),(26,'Social Setting','group',2),(27,'Social Setting','group',2),(28,'School','documentation',2),(29,'School','documentation',2),(30,'School','documentation',2),(31,'School','documentation',2),(32,'School','documentation',2),(33,'School','documentation',2),(34,'Home','documentation',2),(35,'Home','documentation',2),(36,'Outdoor','scape',2),(37,'Outdoor','scape',2),(38,'Outdoor','scape',2),(39,'School','interior',2),(40,'Social Setting','selfie',2),(41,'School','documentation',3),(42,'School','documentation',3),(43,'School','documentation',3),(44,'School','documentation',3),(45,'School','documentation',3),(46,'School','documentation',3),(47,'School','documentation',3),(48,'School','documentation',3),(49,'School','documentation',3),(50,'School','documentation',3),(51,'School','documentation',3),(52,'School','documentation',3),(53,'School','documentation',3),(54,'School','documentation',3),(55,'Work','documentation',3),(56,'Work','documentation',3),(57,'Outdoor','documentation',3),(58,'Outdoor','documentation',3),(59,'Interior','documentation',3),(60,'Interior','documentation',3),(61,'Social Setting','group',4),(62,'Social Setting','group',4),(63,'Social Setting','group',4),(64,'Social Setting','group',4),(65,'Social Setting','group',4),(66,'Social Setting','group',4),(67,'Social Setting','scape',4),(68,'Social Setting','scape',4),(69,'Work','documentation',4),(70,'Work','documentation',4),(71,'Work','documentation',4),(72,'School','documentation',4),(73,'School','documentation',4),(74,'School','documentation',4),(75,'School','documentation',4),(76,'School','documentation',4),(77,'School','documentation',4),(78,'Home','documentation',4),(79,'Home','documentation',4),(80,'Home','documentation',4),(81,'Home','selfie',1),(82,'house ','documentation',6),(83,'BYUI book store','interior',6),(84,'store','group',6),(85,'store','group',6),(86,'store','group',6),(87,'store','group',6),(88,'store','group',6),(89,'school','documentation',6),(90,'school','documentation',6),(91,'school','documentation',6),(92,'school','documentation',6),(93,'house ','group',6),(94,'car','scape',6),(95,'car','group',6),(96,'car','group',6),(97,'car','group',6),(98,'car','group',6),(99,'car','group',6),(100,'school','documentation',6),(101,'school','documentation',7),(102,'school','documentation',7),(103,'school','documentation',7),(104,'school','documentation',7),(105,'school','documentation',7),(106,'school','documentation',7),(107,'school','documentation',7),(108,'school','documentation',7),(109,'school','documentation',7),(110,'school','documentation',7),(111,'school','documentation',7),(112,'school','documentation',7),(113,'school','documentation',7),(114,'school','documentation',7),(115,'school','documentation',7),(116,'school','documentation',7),(117,'school','documentation',7),(118,'school','documentation',7),(119,'school','documentation',7),(120,'school','documentation',7),(121,'school','documentation',8),(122,'school','documentation',8),(123,'school','documentation',8),(124,'school','documentation',8),(125,'school','documentation',8),(126,'school','documentation',8),(127,'school','documentation',8),(128,'R mountin','scape',8),(129,'R mountin','scape',8),(130,'R mountin','scape',8),(131,'R mountin','scape',8),(132,'R mountin','scape',8),(133,'R mountin','scape',8),(134,'R mountin','scape',8),(135,'R mountin','scape',8),(136,'R mountin','scape',8),(137,'school','group',8),(138,'school','group',8),(139,'school','group',8),(140,'school','group',8),(141,'Salt Lake','group',9),(142,'Salt Lake','group',9),(143,'Salt Lake','group',9),(144,'Salt Lake','group',9),(145,'Salt Lake','group',9),(146,'Salt Lake','group',9),(147,'Salt Lake','group',9),(148,'Salt Lake','group',9),(149,'Salt Lake','group',9),(150,'Salt Lake','group',9),(151,'Salt Lake','group',9),(152,'Salt Lake','group',9),(153,'Salt Lake','group',9),(154,'online','documentation',9),(155,'online','documentation',9),(156,'online','documentation',9),(157,'online','documentation',9),(158,'car','group',9),(159,'car','group',9),(160,'car','group',9),(161,'Filmore Utah','scape',5),(162,'Filmore Utah','scape',5),(163,'Filmore Utah','scape',5),(164,'Filmore Utah','scape',5),(165,'Filmore Utah','scape',5),(166,'Filmore Utah','scape',5),(167,'Filmore Utah','scape',5),(168,'Filmore Utah','scape',5),(169,'Filmore Utah','scape',5),(170,'Filmore Utah','scape',5),(171,'school','documentation',5),(172,'school','documentation',5),(173,'school','documentation',5),(174,'school','documentation',5),(175,'school','documentation',5),(176,'school','documentation',5),(177,'school','documentation',5),(178,'school','documentation',5),(179,'school','documentation',5),(180,'school','documentation',5),(181,'home','interior',10),(182,'work','interior',10),(183,'home','scape',10),(184,'car','interior',10),(185,'car','interior',10),(186,'car','interior',10),(187,'car','interior',10),(188,'car','interior',10),(189,'school','documentation',10),(190,'outside','group',10),(191,'outside','group',10),(192,'outside','group',10),(193,'outside','group',10),(194,'outside','group',10),(195,'outside','documentation',10),(196,'outside','documentation',10),(197,'outside','documentation',10),(198,'work','interior',10),(199,'work','interior',10),(200,'work','interior',10),(201,'Outdoor','group',11),(202,'Outdoor','group',11),(203,'Outdoor','group',11),(212,'Work','documentation',11),(213,'Work','documentation',11),(214,'Work','documentation',11),(215,'Work','documentation',11),(216,'Work','documentation',11),(217,'Work','documentation',11),(218,'Work','documentation',11),(219,'Work','documentation',11),(220,'Work','documentation',11),(221,'Home','interior',12),(222,'Outdoors','selfie',12),(223,'Outdoors','selfie',12),(224,'Home','scape',12),(225,'Work','documentation',12),(226,'Work','documentation',12),(227,'Work','documentation',12),(228,'Work','documentation',12),(229,'Work','documentation',12),(230,'Work','documentation',12),(231,'Work','documentation',12),(232,'Work','documentation',12),(233,'Work','documentation',12),(234,'Work','documentation',12),(235,'Outdoors','scape',12),(236,'Outdoors','scape',12),(237,'Outdoors','scape',12),(238,'Outdoors','scape',12),(239,'Outdoors','scape',12),(240,'Home','documentation',12),(241,'Indoors','group',13),(242,'Work','documentation',13),(243,'Work','documentation',13),(244,'Outdoors','interior',13),(245,'Work','documentation',13),(246,'Indoors','selfie',13),(247,'Work','documentation',13),(248,'Home','interior',13),(249,'Home','interior',13),(250,'Home','interior',13),(251,'Indoors','documentation',13),(252,'Outdoors','scape',13),(253,'Work','group',13),(254,'Work','documentation',13),(255,'Home','documentation',13),(256,'Home','documentation',13),(257,'Outdoors','group',13),(258,'Work','documentation',13),(259,'Work','interior',13),(260,'Work','interior',13),(261,'home','interior',14),(262,'pets','group',14),(263,'pets','group',14),(264,'pets','group',14),(265,'pets','group',14),(266,'pets','interior',14),(267,'pets','interior',14),(268,'outdoors','interior',14),(269,'outdoors','interior',14),(270,'outdoors','group',14),(271,'outdoors','group',14),(272,'outdoors','group',14),(273,'outdoors','interior',14),(274,'outdoors','interior',14),(275,'outdoors','interior',14),(276,'pets','group',14),(277,'pets','interior',14),(278,'Social Setting','selfie',14),(279,'pets','interior',14),(280,'work','interior',14),(281,'Outdoors','selfie',15),(282,'Outdoors','selfie',15),(283,'Outdoors','selfie',15),(284,'Social Setting','group',15),(285,'Social Setting','group',15),(286,'Social Setting','group',15),(287,'Social Setting','group',15),(288,'Social Setting','group',15),(289,'Social Setting','group',15),(290,'Social Setting','group',15),(291,'Social Setting','interior',15),(292,'Recipes','documentation',15),(293,'Recipes','documentation',15),(294,'Recipes','documentation',15),(295,'Recipes','documentation',15),(296,'Recipes','documentation',15),(297,'Recipes','documentation',15),(298,'Recipes','documentation',15),(299,'Recipes','documentation',15),(300,'Recipes','documentation',15),(301,'Home','documentation',16),(302,'Home','documentation',16),(303,'Outdoors','group',16),(304,'Outdoors','scape',16),(305,'Note Taking','documentation',16),(306,'Note Taking','documentation',16),(307,'Note Taking','documentation',16),(308,'Note Taking','documentation',16),(309,'Note Taking','documentation',16),(310,'Landscape','documentation',16),(311,'Landscape','scape',16),(312,'Landscape','scape',16),(313,'Outdoors','selfie',16),(314,'Outdoors','selfie',16),(315,'Outdoors','selfie',16),(316,'Landscape','scape',16),(317,'Landscape','scape',16),(318,'Landscape','scape',16),(319,'Landscape','scape',16),(320,'Group Photo','scape',16),(321,'Landscape','scape',16),(322,'Landscape','scape',16),(323,'Note Taking','documentation',16),(324,'Note Taking','interior',17),(325,'Note Taking','interior',17),(326,'Note Taking','interior',17),(328,'Note Taking','interior',17),(329,'Note Taking','documentation',17),(330,'Note Taking','documentation',17),(331,'Note Taking','documentation',17),(332,'Note Taking','interior',17),(333,'Note Taking','documentation',17),(334,'Note Taking','interior',17),(335,'Note Taking','interior',17),(336,'Note Taking','interior',17),(337,'Note Taking','documentation',17),(338,'Note Taking','documentation',17),(339,'Note Taking','documentation',17),(340,'Note Taking','documentation',17),(341,'Note Taking','documentation',17),(342,'Note Taking','documentation',17),(343,'Note Taking','documentation',17),(344,'landscape','scape',17),(345,'Social Setting','group',19),(346,'Social Setting','group',19),(347,'Social Setting','group',19),(348,'Home','interior',19),(349,'Social Setting','group',19),(350,'Social Setting','group',19),(351,'Outdoors','group',19),(352,'Outdoors','group',19),(353,'Outdoors','group',19),(354,'Outdoors','group',19),(355,'Work','group',19),(356,'Work','group',19),(357,'Work','group',19),(358,'Work','group',19),(359,'Work','group',19),(360,'School','group',19),(361,'School','group',19),(362,'School','group',19),(363,'Outdoors','group',19),(364,'School','group',19),(365,'Other','documentation',18),(366,'Home','interior',18),(367,'Home','interior',18),(368,'Other','documentation',18),(369,'Home','group',18),(370,'Other','documentation',18),(371,'Outdoors','selfie',18),(372,'Outdoors','selfie',18),(373,'Outdoors','group',18),(374,'Home','group',18),(375,'Home','group',18),(376,'Home','group',18),(377,'Home','interior',18),(378,'Home','interior',18),(379,'Home','interior',18),(380,'Home','interior',18),(381,'Home','interior',18),(382,'Other','documentation',18),(383,'Social Setting','group',18),(384,'Social Setting','group',18),(385,'Social Setting','group',20),(386,'Social Setting','group',20),(387,'Social Setting','group',20),(388,'Social Setting','interior',20),(389,'Social Setting','group',20),(390,'Social Setting','group',20),(391,'Social Setting','group',20),(392,'Outdoors','interior',20),(393,'Home','interior',20),(394,'Home','interior',20),(395,'Home','interior',20),(396,'Home','documentation',20),(397,'Outdoors','interior',20),(398,'Social Setting','group',20),(399,'Social Setting','group',20),(400,'Home','interior',20),(401,'Social Setting','interior',20),(402,'Social Setting','interior',20),(403,'Home','group',20),(404,'Home','group',20),(405,'Home','group',21),(406,'Home','group',21),(407,'Home','group',21),(408,'Home','group',21),(409,'Home','group',21),(410,'Outdoors','scape',21),(411,'Outdoors','scape',21),(412,'Social Setting','group',21),(413,'Social Setting','group',21),(414,'Social Setting','group',21),(415,'Social Setting','group',21),(416,'Other','documentation',21),(417,'Other','documentation',21),(418,'Other','documentation',21),(419,'Other','documentation',21),(420,'Other','documentation',21),(421,'Other','documentation',21),(422,'Other','documentation',21),(423,'Other','documentation',21),(424,'Other','documentation',21),(425,'Outdoors','scape',22),(426,'Outdoors','scape',22),(427,'Outdoors','scape',22),(428,'Outdoors','scape',22),(429,'Outdoors','scape',22),(430,'Home','selfie',22),(431,'Home','selfie',22),(432,'Other','selfie',22),(433,'Other','selfie',22),(434,'Other','selfie',22),(435,'Other','selfie',22),(436,'Other','selfie',22),(437,'Other','selfie',22),(438,'Outdoors','group',22),(439,'Other','interior',22),(440,'Other','interior',22),(441,'Home','interior',22),(442,'Other','documentation',22),(443,'Other','documentation',22),(444,'Other','documentation',22),(445,'Outdoors','selfie',23),(446,'Outdoors','selfie',23),(447,'Outdoors','selfie',23),(448,'Outdoors','selfie',23),(449,'Home','group',23),(450,'Home','group',23),(451,'Home','group',23),(452,'Home','group',23),(453,'Outdoors','scape',23),(454,'Outdoors','scape',23),(455,'Outdoors','scape',23),(456,'Outdoors','scape',23),(457,'Home','interior',23),(458,'Home','interior',23),(459,'Home','interior',23),(460,'Home','interior',23),(461,'Outdoors','group',23),(462,'Outdoors','group',23),(463,'Outdoors','group',23),(464,'Outdoors','group',23),(465,'Outdoors','scape',25),(466,'Outdoors','scape',25),(467,'Outdoors','scape',25),(468,'Outdoors','scape',25),(469,'Outdoors','scape',25),(470,'Outdoors','scape',25),(471,'Outdoors','scape',25),(472,'Outdoors','scape',25),(473,'Outdoors','scape',25),(474,'Outdoors','scape',25),(475,'Outdoors','scape',25),(476,'Outdoors','scape',25),(477,'Outdoors','scape',25),(478,'Outdoors','scape',25),(479,'Outdoors','scape',25),(480,'Outdoors','scape',25),(481,'Outdoors','scape',25),(482,'Outdoors','scape',25),(483,'Outdoors','scape',25),(484,'Outdoors','scape',25),(485,'Home ','documentation',26),(486,'Home ','documentation',26),(487,'Home ','documentation',26),(488,'Home ','documentation',26),(489,'Home ','documentation',26),(490,'Home ','documentation',26),(491,'Home ','documentation',26),(492,'Home ','documentation',26),(493,'Home ','documentation',26),(494,'Home ','documentation',26),(495,'Home ','documentation',26),(496,'Home ','documentation',26),(497,'Home ','documentation',26),(498,'Home ','documentation',26),(499,'Home ','documentation',26),(500,'Home ','documentation',26),(501,'Home ','documentation',26),(502,'Home ','documentation',26),(503,'Home ','documentation',26),(504,'Home ','documentation',26),(505,'Work','documentation',26),(506,'Work','documentation',26),(507,'Work','documentation',26),(508,'Work','documentation',26),(509,'Home ','scape',26),(510,'Home ','scape',26),(511,'Home ','interior',26),(512,'Home ','interior',27),(513,'Work','interior',27),(514,'Work','interior',27),(515,'Work','interior',27),(516,'Work','interior',27),(517,'Work','interior',27),(518,'Work','interior',27),(519,'Work','documentation',27),(520,'Work','documentation',27),(521,'Work','documentation',27),(522,'Work','documentation',27),(523,'Work','documentation',27),(524,'Work','documentation',27),(525,'Work','documentation',27),(526,'Outdoors','scape',24),(527,'Outdoors','scape',24),(528,'Outdoors','scape',24),(529,'Outdoors','scape',24),(530,'Outdoors','scape',24),(531,'Outdoors','scape',24),(532,'Outdoors','scape',24),(533,'Outdoors','scape',24),(534,'Outdoors','scape',24),(535,'Outdoors','scape',24),(536,'Outdoors','scape',24),(537,'Outdoors','scape',24),(538,'Outdoors','scape',24),(539,'Outdoors','scape',24),(540,'Outdoors','scape',24),(541,'Outdoors','scape',24),(542,'Outdoors','scape',24),(543,'Outdoors','scape',24),(544,'Outdoors','scape',24),(545,'Outdoors','scape',24),(546,'Home ','documentation',29),(547,'Home ','documentation',29),(548,'Home ','documentation',29),(549,'Home ','documentation',29),(550,'Outdoors','interior',29),(551,'Work','documentation',29),(552,'Home ','documentation',29),(553,'Home ','documentation',29),(554,'Work','documentation',29),(555,'Outdoors','group',29),(556,'Outdoors','group',29),(557,'Outdoors','group',29),(558,'Outdoors','group',29),(559,'Outdoors','interior',29),(560,'Home ','documentation',29),(561,'Home ','documentation',29),(562,'Home ','documentation',29),(563,'Home ','documentation',29),(564,'Home ','documentation',29),(565,'Home ','documentation',29),(566,'Home ','documentation',28),(567,'Home ','documentation',28),(568,'Work','documentation',28),(569,'Work','documentation',28),(570,'Social Setting','group',28),(571,'Social Setting','group',28),(572,'Social Setting','group',28),(573,'Social Setting','group',28),(574,'Social Setting','group',28),(575,'Social Setting','group',28),(576,'Home ','documentation',28),(577,'Work','documentation',28),(578,'Other','documentation',28),(579,'Home ','documentation',28),(580,'Work','documentation',28),(581,'Work','documentation',28),(582,'Work','documentation',28),(583,'Work','documentation',28),(584,'Other','documentation',28),(585,'Other','documentation',28),(586,'Internet','documentation',30),(587,'Social ','interior',30),(588,'Internet ','documentation',30),(589,'Internet ','documentation',30),(590,'Internet','documentation',30),(591,'Home','interior',30),(592,'Home','interior',30),(593,'Outdoors','selfie',30),(594,'Outdoors','selfie',30),(595,'Internet','documentation',30),(596,'Social ','selfie',30),(597,'Home','documentation',30),(598,'Work','selfie',30),(599,'Internet','documentation',30),(600,'Work','documentation',30),(601,'Internet','documentation',30),(602,'Home','documentation',30),(603,'Home','documentation',30),(604,'Home','documentation',30),(605,'school','selfie',31),(606,'school','selfie',31),(607,'school','selfie',31),(608,'work','documentation',31),(609,'outdoors','selfie',31),(610,'outdoors','selfie',31),(611,'outdoors','selfie',31),(612,'outdoors','selfie',31),(613,'outdoors','selfie',31),(614,'outdoors','selfie',31),(615,'outdoors','selfie',31),(616,'outdoors','scape',31),(617,'outdoors','scape',31),(618,'outdoors','scape',31),(619,'outdoors','scape',31),(620,'outdoors','scape',31),(621,'outdoors','scape',31),(622,'home','selfie',31),(623,'work','scape',31),(624,'home','scape',31),(625,'outdoors','selfie',32),(626,'outdoors','selfie',32),(627,'outdoors','selfie',32),(628,'outdoors','selfie',32),(629,'outdoors','selfie',32),(630,'outdoors','selfie',32),(631,'outdoors','selfie',32),(632,'outdoors','selfie',32),(633,'indoor','selfie',32),(634,'indoor','selfie',32),(635,'indoor','selfie',32),(636,'indoor','selfie',32),(637,'indoor','selfie',32),(638,'indoor','selfie',32),(639,'home','documentation',32),(640,'home','documentation',32),(641,'home','documentation',32),(642,'home','documentation',32),(643,'home','documentation',32),(655,'school','documentation',33),(656,'school','documentation',33),(657,'school','documentation',33),(658,'school','documentation',33),(659,'school','documentation',33),(660,'school','documentation',33),(661,'school','documentation',33),(662,'school','documentation',33),(663,'school','documentation',33),(664,'school','documentation',33),(665,'outside','selfie',34),(666,'outside','selfie',34),(667,'outside','selfie',34),(668,'outside','selfie',34),(669,'outside','selfie',34),(670,'outside','selfie',34),(671,'outside','selfie',34),(672,'outside','selfie',34),(673,'outside','selfie',34),(674,'inside','interior',34),(675,'inside','interior',34),(676,'inside','interior',34),(677,'inside','interior',34),(678,'inside','interior',34),(679,'outside','scape',34),(680,'outside','scape',34),(681,'outside','scape',34),(682,'outside','scape',34),(683,'outside','scape',34),(684,'outside','scape',34),(685,'outside','scape',34),(686,'inside','interior',35),(687,'inside','interior',35),(688,'inside','interior',35),(689,'inside','interior',35),(690,'inside','interior',35),(691,'inside','interior',35),(692,'inside','interior',35),(693,'inside','interior',35),(694,'inside','interior',35),(695,'inside','interior',35),(696,'inside','interior',35),(697,'inside','documentation',35),(698,'inside','documentation',35),(699,'inside','documentation',35),(700,'inside','documentation',35),(701,'inside','scape',35),(702,'inside','selfie',35),(703,'inside','selfie',35),(704,'inside','scape',35),(705,'inside','scape',35),(706,'inside','scape',35),(707,'Outdoors','interior',36),(708,'Home','group',36),(709,'Home','group',36),(710,'Home','group',36),(711,'Home','group',36),(712,'Home','group',36),(713,'Home','group',36),(714,'Home','group',36),(715,'Home','group',36),(716,'Home','documentation',36),(717,'Home','documentation',36),(718,'Home','scape',36),(719,'Home','scape',36),(720,'Home','group',36),(721,'Home','group',36),(722,'Home','group',36),(723,'Home','group',36),(724,'Home','group',36),(725,'Home','group',36),(726,'Home','group',36),(727,'Outdoors','group',37),(728,'Outdoors','group',37),(729,'Outdoors','group',37),(730,'Outdoors','group',37),(731,'Outdoors','group',37),(732,'Outdoors','group',37),(733,'Outdoors','group',37),(734,'Outdoors','group',37),(735,'Outdoors','group',37),(736,'Outdoors','group',37),(737,'Outdoors','group',37),(738,'Outdoors','group',37),(739,'Outdoors','group',37),(740,'Outdoors','group',37),(741,'Outdoors','group',37),(742,'Social Setting','interior',37),(743,'Social Setting','interior',37),(744,'Social Setting','interior',37),(745,'Social Setting','group',37),(746,'Social Setting','interior',37),(747,'Social Setting','group',37),(748,'Social Setting','selfie',38),(749,'Social Setting','selfie',38),(750,'Social Setting','selfie',38),(751,'Social Setting','selfie',38),(752,'Social Setting','selfie',38),(753,'Social Setting','selfie',38),(754,'Social Setting','selfie',38),(755,'Social Setting','selfie',38),(756,'Social Setting','selfie',38),(757,'Social Setting','selfie',38),(758,'Social Setting','selfie',38),(759,'Social Setting','selfie',38),(760,'Social Setting','selfie',38),(761,'Social Setting','selfie',38),(762,'Social Setting','selfie',38),(763,'Social Setting','selfie',38),(764,'Social Setting','selfie',38),(765,'Social Setting','selfie',38),(766,'Social Setting','selfie',38),(767,'Social Setting','selfie',38),(768,'Home','group',39),(769,'Outdoors','scape',39),(770,'Outdoors','scape',39),(771,'Outdoors','scape',39),(772,'Outdoors','scape',39),(773,'Outdoors','scape',39),(774,'Outdoors','scape',39),(775,'Outdoors','scape',39),(776,'Outdoors','scape',39),(777,'Outdoors','scape',39),(778,'Outdoors','scape',39),(779,'Outdoors','scape',39),(780,'Outdoors','scape',39),(781,'Outdoors','scape',39),(782,'Outdoors','scape',39),(783,'Outdoors','scape',39),(784,'Outdoors','scape',39),(785,'Outdoors','scape',39),(786,'Outdoors','scape',39),(787,'Outdoors','scape',39),(788,'Home','documentation',40),(789,'Home','documentation',40),(790,'Home','documentation',40),(791,'Home','documentation',40),(792,'Home','documentation',40),(793,'Home','documentation',40),(794,'Home','documentation',40),(795,'Home','documentation',40),(796,'Home','documentation',40),(797,'Home','documentation',40),(798,'Home','documentation',40),(799,'Home','documentation',40),(800,'Home','documentation',40),(801,'Home','documentation',40),(802,'Home','documentation',40),(803,'Home','documentation',40),(804,'Home','documentation',40),(805,'Home','documentation',40),(806,'Home','documentation',40),(807,'Home','documentation',40),(808,'school','interior',41),(809,'social','interior',41),(810,'social','interior',41),(811,'social','interior',41),(812,'outdoor','interior',41),(813,'school','scape',41),(814,'school','interior',41),(815,'school','interior',41),(816,'school','interior',41),(817,'school','interior',41),(818,'school','documentation',41),(819,'school','documentation',41),(820,'school','documentation',41),(821,'home','interior',41),(822,'home','interior',41),(823,'home','group',41),(824,'home','group',41),(825,'grandparents','group',41),(826,'grandparents','group',41),(827,'grandparents','interior',41),(828,'outdoor','scape',42),(829,'outdoor','group',42),(830,'home','group',42),(831,'home','selfie',42),(832,'home','selfie',42),(833,'social','group',42),(834,'social','group',42),(835,'social','group',42),(836,'home','group',42),(837,'home','group',42),(838,'home','group',42),(839,'outdoor','group',42),(840,'outdoor','group',42),(841,'outdoor','group',42),(842,'social','interior',42),(843,'social','interior',42),(844,'social','interior',42),(845,'social','interior',42),(846,'social','interior',42),(847,'social','interior',42),(848,'work','selfie',43),(849,'outdoor','scape',43),(850,'outdoor','scape',43),(851,'family','group',43),(852,'family','group',43),(853,'family','group',43),(854,'home','interior',43),(855,'social','interior',43),(856,'family','selfie',43),(857,'school','documentation',43),(858,'school','documentation',43),(859,'school','documentation',43),(860,'school','documentation',43),(861,'family','selfie',43),(862,'school','documentation',43),(863,'school','documentation',43),(864,'school','documentation',43),(865,'family','group',43),(866,'school','interior',43),(867,'school','interior',43),(868,'meme','documentation',44),(869,'meme','documentation',44),(870,'home','selfie',44),(871,'home','selfie',44),(872,'home','selfie',44),(873,'home','selfie',44),(874,'home','selfie',44),(875,'home','selfie',44),(876,'home','selfie',44),(877,'home','selfie',44),(878,'home','selfie',44),(879,'home','selfie',44),(880,'social','selfie',44),(881,'meme','selfie',44),(882,'social','selfie',44),(883,'outdoor','selfie',44),(884,'outdoor','selfie',44),(885,'meme','documentation',44),(886,'outdoor','selfie',44),(887,'meme','documentation',44),(888,'social','group',45),(889,'social','group',45),(890,'social','group',45),(891,'social','group',45),(892,'social','group',45),(893,'social','group',45),(894,'social','group',45),(895,'social','group',45),(896,'social','group',45),(897,'social','group',45),(898,'social','group',45),(908,'school','documentation',46),(909,'school','documentation',46),(910,'school','documentation',46),(911,'school','documentation',46),(912,'school','documentation',46),(914,'work','selfie',46),(915,'work','selfie',46),(916,'work','selfie',46),(917,'work','selfie',46),(918,'work','selfie',46),(919,'work','selfie',46),(920,'work','selfie',46),(921,'work','selfie',46),(922,'work','selfie',46),(923,'work','selfie',46),(924,'work','selfie',46),(925,'work','selfie',46),(926,'work','selfie',46),(927,'work','selfie',46),(928,'School','documentation',48),(929,'Home','documentation',48),(930,'Social','group',48),(931,'Social','group',48),(932,'Home','documentation',48),(933,'Home','documentation',48),(934,'Home','documentation',48),(935,'Home','documentation',48),(936,'Social','group',48),(937,'Social','group',48),(938,'Social','group',48),(939,'Social','group',48),(940,'Social','group',48),(941,'Social','group',48),(942,'School','documentation',48),(943,'School','documentation',48),(944,'School','documentation',48),(945,'School','documentation',48),(946,'School','documentation',48),(947,'Outdoors','scape',48),(948,'Home','selfie',49),(949,'Home','group',49),(950,'Class Teaching','documentation',49),(951,'Class Teaching','documentation',49),(952,'Class Teaching','documentation',49),(953,'Class Teaching','documentation',49),(954,'Class Teaching','documentation',49),(955,'Class Teaching','documentation',49),(956,'Class Teaching','documentation',49),(957,'Class Teaching','documentation',49),(958,'Class Teaching','documentation',49),(959,'Social','scape',49),(960,'Social','selfie',49),(961,'Social','group',49),(962,'Social','interior',49),(963,'Outdoors','selfie',49),(964,'Outdoors','scape',49),(965,'Outdoors','scape',49),(966,'Outdoors','group',49),(967,'Outdoors','scape',49),(968,'School','documentation',50),(976,'Social','group',50),(977,'School','documentation',50),(978,'School','documentation',50),(980,'School','documentation',50),(981,'School','documentation',50),(982,'Outdoors','scape',50),(983,'Outdoors','scape',50),(984,'Outdoors','scape',50),(985,'Outdoors','scape',50),(986,'Outdoors','group',50),(987,'Outdoors','group',50),(988,'Other','documentation',51),(989,'Other','documentation',51),(990,'Other','documentation',51),(991,'Other','documentation',51),(992,'Other','documentation',51),(993,'Other','documentation',51),(994,'Other','documentation',51),(995,'Other','documentation',51),(996,'Other','documentation',51),(997,'Other','documentation',51),(998,'Home','interior',51),(999,'Home','interior',51),(1000,'Social','group',51),(1001,'Social','group',51),(1002,'Social','group',51),(1003,'Social','group',51),(1004,'Home','interior',51),(1005,'Home','interior',51),(1006,'Other','documentation',51),(1007,'Other','documentation',51),(1008,'Home','documentation',47),(1009,'School','documentation',47),(1010,'School','documentation',47),(1011,'School','documentation',47),(1012,'School','documentation',47),(1013,'School','documentation',47),(1014,'School','documentation',47),(1015,'School','documentation',47),(1016,'School','documentation',47),(1017,'School','documentation',47),(1018,'School','documentation',47),(1019,'Outdoors','selfie',47),(1020,'School','documentation',47),(1021,'School','documentation',47),(1022,'School','documentation',47),(1023,'School','documentation',47),(1024,'School','documentation',47),(1025,'Home','documentation',47),(1026,'School','documentation',47),(1027,'Social','group',47),(1028,'Home','group',52),(1029,'Home','group',52),(1030,'Home','group',52),(1031,'Home','group',52),(1032,'Home','group',52),(1033,'Home','group',52),(1034,'Home','group',52),(1035,'Outdoors','group',52),(1036,'Outdoors','group',52),(1037,'Outdoors','group',52),(1038,'Outdoors','selfie',52),(1039,'Outdoors','selfie',52),(1040,'Work','selfie',52),(1041,'Work','selfie',52),(1042,'School','documentation',52),(1043,'School','documentation',52),(1044,'School','documentation',52),(1045,'Outdoors','group',52),(1046,'Outdoors','group',52),(1047,'Outdoors','group',52);
/*!40000 ALTER TABLE `image` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student` (
  `student_id` int NOT NULL,
  `lname` varchar(35) NOT NULL,
  `fname` varchar(25) NOT NULL,
  `gender` enum('M','F') DEFAULT NULL,
  `major` varchar(25) NOT NULL,
  `dist_category` enum('internet','someone','something','social media','digital','other') NOT NULL,
  `worry_category` varchar(45) NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`student_id`),
  KEY `fk_student_group1_idx` (`group_id`),
  CONSTRAINT `fk_student_group1` FOREIGN KEY (`group_id`) REFERENCES `student_group` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES (1,'Spencer','Sam','M','Data Science','someone','Work/Study',1),(2,'Jones','Joshua','M','Data Science','someone','My Partner',1),(3,'Larsen','Lincoln','M','Accounting','digital','Work/Study',1),(4,'Adams','Andrew','M','Finance','social media','Work/Study',1),(5,'Victor','Vivian','F','Bioinformatics','someone','Work',2),(6,'Hector','Jose','M','Business Management','social media','Family ',2),(7,'Daniels','Drew','M','CIT','internet','Finances',2),(8,'Michaels','Matthew','M','Bussiness Management','internet','School',2),(9,'Kearns','Kien','M','Software Engineering','internet','Future',2),(10,'Andersen','Austin ','M','CIT','other','Finances',2),(11,'Butler','Buck','M','Finance','digital','World issues',1),(12,'Taylor','Trevor','M','Economics','internet','Work/Study',3),(13,'Andrews','Addison','M','Business Analytics','someone','Work/Study',3),(14,'Kelly','Kaelan','M','Data Science','social media','My Partner',3),(15,'Cornelison','Connor','M','Economics','internet','Myself',3),(16,'Thompson','Thomas','M','Financial Economics','other','Work/Study',3),(17,'Madsen','Matthew','M','Geology','someone','Work/Study',3),(18,'Hall','Halla','F','Business Management','social media','Photo/Media',4),(19,'Smith','Sarah','F','Business Management','digital','Notes/Tracking',4),(20,'Hansen','Henry','M','Software Engineering','social media','Games',4),(21,'Stanley','Seth','M','Data Science','digital','Streaming',4),(22,'Ellison','Eria','F','Computer Science','internet','Unused',4),(23,'Dye','Dev','M','CIT','internet','Social Media',4),(24,'Nathaniel','Natalie','F','Financial Economics','someone','Work/Study',5),(25,'Stevenson','Steven','M','Business Analytics','someone','Family',5),(26,'Carter','Conner','M','CIT','someone','Family',5),(27,'Dahal','Dora','F','Accounting','someone','Work/Study',5),(28,'Monson','Matt','M','Accounting','digital','Work/Study',5),(29,'Chutley','Chuck','M','Accounting','social media','Work/Study',5),(30,'Halsberg','Hayden','M','Supply Chain','internet','self',6),(31,'Alder','Ammon','M','Business Analytics','someone','World Events',6),(32,'Jensen','Joshua ','M','Accounting','internet','self',6),(33,'Johnson','Jacob','M','Economica','social media','school',6),(34,'Brown','Brandon','M','Accounting','internet','wife',6),(35,'Johansen','Joshua ','M','Computer Systems','internet','school',6),(36,'Mau','Moon','M','Data Science','social media','Finance',7),(37,'Henderson','Hunter','M','Data Science','internet','Finance',7),(38,'Austins','Andrew','M','Supply Chain Management','social media','Finance',7),(39,'Daniels','David','M','DATA Science','social media','Finance',7),(40,'Neuman','Nathan','M','CIT','digital','work/study',7),(41,'Burke','Brandon','M','GeoBusiness & DA','other','Study',8),(42,'Andresen','Andrew','M','Software Engineering','digital','Family',8),(43,'Gong','Garrett','M','Business Finance','other','Family',8),(44,'Velasquez','Vance','M','CIT','digital','Myself',8),(45,'Duarta','David','M','Supply Chain','digital','work/syudy',8),(46,'Angola','Angie','F','Business Management','other','other',8),(47,'Alono','Ayeh','M','Finance','social media','Work/Study',9),(48,'Sharmin','Schult','M','Accounting','something','Work/Study',9),(49,'Shmitt','Sharma','M','Business Analytics','social media','Work/Study',9),(50,'Eliason','Elizabeth','F','Accounting','someone','Friends',9),(51,'Jackson','Jack','M','CIT','internet','Work/Study',9),(52,'Autman','Assan','M','Business Operations','something','Work/Study',9);
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student_group`
--

DROP TABLE IF EXISTS `student_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student_group` (
  `group_id` int NOT NULL,
  `group_name` varchar(25) NOT NULL,
  `location` varchar(25) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_group`
--

LOCK TABLES `student_group` WRITE;
/*!40000 ALTER TABLE `student_group` DISABLE KEYS */;
INSERT INTO `student_group` VALUES (1,'Zac','back_middle_1'),(2,'Name','middle_right_2'),(3,'The Great Emu War','middle_left_2'),(4,'MIDR','middle_right_1'),(5,'DATA YO-YO','front_left_2'),(6,'The Snacks','front_middle_2'),(7,'Group','back_right_2'),(8,'Uno Players','front_left_1'),(9,'Team Legit','middle_middle_1');
/*!40000 ALTER TABLE `student_group` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2020-05-06  6:55:24
