--
-- Host: localhost    Database: pr_api
-- ------------------------------------------------------


--
-- Table structure for table `feedbacks`
--

CREATE TABLE `feedbacks` (
  `turmaId` int(11) NOT NULL,
  `numeroSemana` int(11) NOT NULL,
  `nota` int(11) NOT NULL,
  `submitDate` datetime NOT NULL,
  KEY `turmaId` (`turmaId`),
  CONSTRAINT `feedbacks_ibfk_1` FOREIGN KEY (`turmaId`) REFERENCES `turmas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `feedbacks`
--

INSERT INTO `feedbacks` VALUES (1,1,10,'2018-06-25 03:25:23'),(1,1,6,'2018-06-25 03:16:33'),(1,1,8,'2018-06-25 02:54:13'),(1,1,9,'2018-06-25 02:15:36'),(1,1,8,'2018-06-25 02:06:20'),(1,1,9,'2018-06-25 00:36:17'),(1,1,8,'2018-06-25 00:02:23'),(1,1,8,'2018-06-24 23:43:20'),(1,1,5,'2018-06-24 19:23:07'),(1,1,9,'2018-06-24 18:31:21'),(1,1,9,'2018-06-24 16:07:43'),(1,1,9,'2018-06-23 21:11:10'),(1,2,8,'2018-06-18 18:28:26'),(1,2,8,'2018-06-18 03:04:15'),(1,2,8,'2018-06-17 20:42:44'),(1,2,6,'2018-06-17 01:22:32'),(1,2,8,'2018-06-16 14:33:28'),(1,2,9,'2018-06-16 13:00:15'),(1,3,0,'2018-06-11 02:50:25'),(1,3,7,'2018-06-11 01:25:20'),(1,3,3,'2018-06-11 00:09:54'),(1,3,5,'2018-06-10 23:18:50'),(1,3,1,'2018-06-10 22:57:23'),(1,3,5,'2018-06-10 22:32:22'),(1,3,4,'2018-06-10 14:37:53'),(1,3,3,'2018-06-09 14:29:32'),(1,3,5,'2018-06-09 12:55:42'),(1,3,6,'2018-06-09 12:54:42'),(1,4,2,'2018-06-04 03:20:09'),(1,4,5,'2018-06-04 02:19:39'),(1,4,7,'2018-06-04 01:59:24'),(1,4,6,'2018-06-03 22:40:43'),(1,4,3,'2018-06-03 21:15:28'),(1,4,5,'2018-06-03 19:44:47'),(1,4,1,'2018-06-03 19:41:46'),(1,4,4,'2018-06-03 19:09:25'),(1,4,7,'2018-06-03 15:05:30'),(1,4,7,'2018-06-03 14:59:23'),(1,4,3,'2018-06-03 03:11:36'),(1,4,7,'2018-06-02 14:20:37'),(1,4,3,'2018-06-01 21:43:33'),(1,5,8,'2018-05-28 03:49:58'),(1,5,3,'2018-05-28 01:54:21'),(1,5,8,'2018-05-28 01:50:14'),(1,5,4,'2018-05-28 01:29:22'),(1,5,7,'2018-05-27 20:30:07'),(1,5,6,'2018-05-27 18:13:35'),(1,5,9,'2018-05-26 20:15:38'),(1,5,10,'2018-05-26 16:33:37'),(1,5,6,'2018-05-26 02:34:31'),(1,5,6,'2018-05-26 00:20:21'),(1,6,5,'2018-05-21 02:28:55'),(1,6,8,'2018-05-21 02:23:12'),(1,6,9,'2018-05-21 01:34:38'),(1,6,2,'2018-05-21 00:32:14'),(1,6,1,'2018-05-20 23:59:37'),(1,6,8,'2018-05-20 23:02:47'),(1,6,8,'2018-05-20 22:12:58'),(1,6,6,'2018-05-20 17:43:11'),(1,6,6,'2018-05-19 23:28:59'),(1,6,9,'2018-05-19 17:03:34'),(1,6,10,'2018-05-19 17:00:35'),(1,6,6,'2018-05-19 01:08:13'),(1,6,7,'2018-05-19 00:13:56'),(1,7,9,'2018-05-14 03:19:37'),(1,7,10,'2018-05-14 02:50:24'),(1,7,5,'2018-05-14 02:48:27'),(1,7,1,'2018-05-14 02:10:13'),(1,7,8,'2018-05-14 02:09:49'),(1,7,10,'2018-05-14 01:53:38'),(1,7,9,'2018-05-14 01:11:16'),(1,7,5,'2018-05-14 01:10:46'),(1,7,7,'2018-05-14 01:08:18'),(1,7,8,'2018-05-14 00:42:04'),(1,7,8,'2018-05-13 23:15:22'),(1,7,10,'2018-05-13 22:53:40'),(1,7,10,'2018-05-13 21:33:10'),(1,7,9,'2018-05-13 15:20:40'),(1,7,10,'2018-05-12 21:16:10'),(1,7,10,'2018-05-12 01:55:36'),(1,8,9,'2018-05-07 02:59:53'),(1,8,8,'2018-05-07 02:38:07'),(1,8,9,'2018-05-07 02:24:58'),(1,8,7,'2018-05-07 02:23:34'),(1,8,10,'2018-05-07 01:59:29'),(1,8,8,'2018-05-07 00:31:02'),(1,8,2,'2018-05-06 23:00:59'),(1,8,10,'2018-05-06 22:30:30'),(1,8,8,'2018-05-06 22:09:40'),(1,8,9,'2018-05-06 21:36:33'),(1,8,7,'2018-05-06 21:00:26'),(1,8,7,'2018-05-06 20:06:11'),(1,8,9,'2018-05-06 19:22:57'),(1,8,9,'2018-05-06 18:49:35'),(1,8,8,'2018-05-06 17:44:46'),(1,8,3,'2018-05-06 16:29:47'),(1,8,8,'2018-05-06 00:00:16'),(1,8,8,'2018-05-05 21:02:24'),(1,8,10,'2018-05-05 20:11:13'),(1,8,6,'2018-05-05 16:46:34'),(1,9,7,'2018-05-02 08:29:16'),(1,9,9,'2018-05-02 01:41:55'),(1,9,8,'2018-05-01 23:17:46'),(1,9,9,'2018-05-01 21:33:29'),(1,9,10,'2018-05-01 21:06:42'),(1,9,9,'2018-05-01 20:46:49'),(1,9,2,'2018-05-01 20:09:16'),(1,9,8,'2018-05-01 15:58:46'),(1,9,9,'2018-05-01 01:38:40'),(1,9,5,'2018-04-30 21:39:42'),(1,9,8,'2018-04-30 17:08:19'),(1,9,8,'2018-04-30 15:41:41'),(1,9,7,'2018-04-29 21:13:16'),(1,9,8,'2018-04-29 15:38:56'),(1,9,8,'2018-04-29 01:41:52'),(1,9,6,'2018-04-28 19:15:54'),(1,10,7,'2018-04-23 02:27:37'),(1,10,9,'2018-04-23 01:16:37'),(1,10,8,'2018-04-23 00:01:20'),(1,10,8,'2018-04-22 23:40:52'),(1,10,10,'2018-04-22 21:44:25'),(1,10,8,'2018-04-22 21:35:21'),(1,10,9,'2018-04-22 20:29:36'),(1,10,8,'2018-04-22 16:15:42'),(1,10,9,'2018-04-22 13:36:11'),(1,10,8,'2018-04-21 20:01:05'),(1,10,8,'2018-04-21 02:11:30'),(1,10,9,'2018-04-21 01:51:55'),(1,11,5,'2018-04-16 03:03:35'),(1,11,5,'2018-04-16 02:58:28'),(1,11,8,'2018-04-16 02:35:27'),(1,11,6,'2018-04-16 02:25:50'),(1,11,2,'2018-04-16 02:08:56'),(1,11,4,'2018-04-16 01:23:03'),(1,11,5,'2018-04-16 01:14:31'),(1,11,2,'2018-04-16 01:14:02'),(1,11,10,'2018-04-16 00:53:58'),(1,11,3,'2018-04-16 00:46:00'),(1,11,6,'2018-04-16 00:43:28'),(1,11,4,'2018-04-16 00:20:46'),(1,11,2,'2018-04-15 23:54:52'),(1,11,4,'2018-04-15 20:02:46'),(1,11,8,'2018-04-15 17:49:06'),(1,11,4,'2018-04-15 15:43:34'),(1,11,8,'2018-04-15 15:26:30'),(1,11,4,'2018-04-15 14:51:12'),(1,11,3,'2018-04-15 02:06:19'),(1,11,5,'2018-04-15 01:50:30'),(1,11,1,'2018-04-14 12:11:12'),(1,12,8,'2018-04-09 02:58:00'),(1,12,7,'2018-04-09 02:18:07'),(1,12,8,'2018-04-09 01:26:36'),(1,12,7,'2018-04-09 01:24:20'),(1,12,6,'2018-04-09 01:10:47'),(1,12,7,'2018-04-09 00:50:10'),(1,12,8,'2018-04-09 00:36:59'),(1,12,7,'2018-04-08 23:38:00'),(1,12,7,'2018-04-08 23:34:10'),(1,12,8,'2018-04-08 23:25:49'),(1,12,7,'2018-04-08 23:14:32'),(1,12,5,'2018-04-08 20:51:08'),(1,12,10,'2018-04-08 20:32:26'),(1,12,8,'2018-04-08 20:02:03'),(1,12,6,'2018-04-08 19:24:58'),(1,12,7,'2018-04-08 18:30:55'),(1,12,7,'2018-04-08 14:28:45'),(1,12,10,'2018-04-08 13:57:05'),(1,12,6,'2018-04-08 11:44:08'),(1,12,4,'2018-04-07 23:14:19'),(1,12,5,'2018-04-07 20:28:24'),(1,12,6,'2018-04-07 19:06:18'),(1,12,8,'2018-04-07 14:58:18'),(1,12,8,'2018-04-07 14:45:52'),(1,13,5,'2018-04-02 11:03:32'),(1,13,8,'2018-04-02 03:02:06'),(1,13,8,'2018-04-02 02:41:26'),(1,13,8,'2018-04-02 02:27:46'),(1,13,9,'2018-04-02 01:20:32'),(1,13,9,'2018-04-02 00:46:41'),(1,13,8,'2018-04-02 00:23:29'),(1,13,7,'2018-04-01 23:23:43'),(1,13,9,'2018-04-01 23:15:06'),(1,13,8,'2018-04-01 23:13:12'),(1,13,8,'2018-04-01 23:07:04'),(1,13,9,'2018-04-01 23:05:11'),(1,13,5,'2018-04-01 23:04:41'),(1,13,8,'2018-03-31 21:31:09'),(1,13,7,'2018-03-31 03:03:25'),(1,13,5,'2018-03-31 02:52:05'),(1,13,8,'2018-03-29 20:59:36'),(1,13,8,'2018-03-29 20:17:09'),(1,13,8,'2018-03-29 17:43:32'),(1,13,9,'2018-03-29 15:24:04'),(1,13,10,'2018-03-29 14:00:08'),(1,13,7,'2018-03-29 13:01:39'),(1,14,7,'2018-03-26 02:52:34'),(1,14,5,'2018-03-26 01:50:33'),(1,14,8,'2018-03-26 01:40:23'),(1,14,9,'2018-03-26 01:37:16'),(1,14,9,'2018-03-26 01:19:26'),(1,14,8,'2018-03-26 01:02:15'),(1,14,10,'2018-03-26 01:00:02'),(1,14,8,'2018-03-26 00:18:22'),(1,14,9,'2018-03-26 00:11:56'),(1,14,8,'2018-03-26 00:09:17'),(1,14,6,'2018-03-26 00:07:38'),(1,14,9,'2018-03-25 23:36:20'),(1,14,9,'2018-03-25 23:32:15'),(1,14,9,'2018-03-25 22:55:56'),(1,14,9,'2018-03-25 22:49:46'),(1,14,9,'2018-03-25 22:43:44'),(1,14,7,'2018-03-25 22:11:44'),(1,14,7,'2018-03-25 17:27:29'),(1,14,8,'2018-03-25 16:52:09'),(1,14,10,'2018-03-25 15:25:15'),(1,14,5,'2018-03-24 23:37:09'),(1,14,9,'2018-03-24 21:31:00'),(1,14,10,'2018-03-24 17:05:55'),(1,14,7,'2018-03-24 12:36:01'),(1,14,5,'2018-03-24 12:07:49'),(1,15,5,'2018-03-19 03:42:41'),(1,15,8,'2018-03-19 02:31:56'),(1,15,8,'2018-03-19 02:03:46'),(1,15,7,'2018-03-19 02:02:17'),(1,15,8,'2018-03-19 01:41:52'),(1,15,9,'2018-03-19 01:29:48'),(1,15,10,'2018-03-19 01:28:04'),(1,15,6,'2018-03-19 00:57:31'),(1,15,7,'2018-03-18 23:30:12'),(1,15,9,'2018-03-18 22:57:18'),(1,15,8,'2018-03-18 22:38:52'),(1,15,7,'2018-03-18 22:07:49'),(1,15,9,'2018-03-18 21:34:59'),(1,15,6,'2018-03-18 20:50:34'),(1,15,6,'2018-03-18 17:57:06'),(1,15,8,'2018-03-18 17:28:01'),(1,15,8,'2018-03-18 13:36:50'),(1,15,6,'2018-03-17 20:55:27'),(1,15,7,'2018-03-17 17:04:47'),(1,15,7,'2018-03-17 05:24:08'),(1,15,7,'2018-03-17 04:29:09'),(1,15,8,'2018-03-17 02:45:36'),(1,15,5,'2018-03-17 01:28:27'),(1,15,8,'2018-03-17 01:15:14'),(1,15,4,'2018-03-16 23:41:03'),(1,15,9,'2018-03-16 23:39:18'),(1,15,10,'2018-03-16 23:38:59'),(1,16,7,'2018-03-12 02:55:03'),(1,16,6,'2018-03-12 02:51:36'),(1,16,10,'2018-03-12 01:26:24'),(1,16,9,'2018-03-12 00:56:17'),(1,16,9,'2018-03-11 23:46:42'),(1,16,6,'2018-03-11 22:55:27'),(1,16,9,'2018-03-11 22:12:28'),(1,16,4,'2018-03-11 21:57:58'),(1,16,9,'2018-03-11 17:27:18'),(1,16,6,'2018-03-11 17:25:06'),(1,16,5,'2018-03-11 17:08:48'),(1,16,6,'2018-03-11 16:43:21'),(1,16,10,'2018-03-11 14:32:08'),(1,16,7,'2018-03-11 13:21:04'),(1,16,6,'2018-03-10 20:48:45'),(1,16,8,'2018-03-10 20:33:55'),(1,16,8,'2018-03-10 20:19:44'),(1,16,10,'2018-03-10 18:57:17'),(1,16,7,'2018-03-10 11:41:55'),(1,16,6,'2018-03-10 11:16:11'),(1,16,9,'2018-03-10 04:40:28'),(1,16,7,'2018-03-10 02:31:13'),(1,16,8,'2018-03-10 02:02:00'),(1,16,5,'2018-03-10 01:19:55'),(1,16,6,'2018-03-09 23:09:00'),(1,16,8,'2018-03-09 22:15:46'),(1,16,7,'2018-03-09 21:32:55'),(1,16,4,'2018-03-09 20:48:39'),(1,16,7,'2018-03-09 20:35:13'),(1,16,8,'2018-03-09 20:27:43'),(1,16,8,'2018-03-09 20:24:12'),(1,17,10,'2018-03-05 02:23:41'),(1,17,7,'2018-03-04 23:35:42'),(1,17,9,'2018-03-04 23:32:55'),(1,17,7,'2018-03-04 23:23:12'),(1,17,8,'2018-03-04 22:34:53'),(1,17,10,'2018-03-04 12:28:34'),(1,17,9,'2018-03-04 01:01:29'),(1,17,8,'2018-03-04 00:22:15'),(1,17,9,'2018-03-03 23:27:11'),(1,17,4,'2018-03-03 22:06:20'),(1,17,8,'2018-03-03 17:10:50'),(1,17,10,'2018-03-03 12:59:59'),(1,17,7,'2018-03-03 12:23:10'),(1,17,7,'2018-03-02 22:43:12'),(1,17,8,'2018-03-02 22:06:41'),(1,18,8,'2018-02-27 22:30:15'),(1,18,8,'2018-02-27 02:58:17'),(1,18,8,'2018-02-26 23:15:44'),(1,18,8,'2018-02-26 15:57:27'),(1,18,9,'2018-02-26 12:27:24'),(1,18,7,'2018-02-26 02:23:52'),(1,18,8,'2018-02-26 00:31:45'),(1,18,8,'2018-02-25 18:23:14'),(1,18,7,'2018-02-25 16:19:40'),(1,18,8,'2018-02-25 13:47:34'),(1,18,8,'2018-02-25 12:29:36'),(1,18,10,'2018-02-25 00:32:50'),(1,18,8,'2018-02-24 21:09:41'),(1,18,10,'2018-02-24 19:56:57'),(1,18,8,'2018-02-24 15:33:32'),(1,18,9,'2018-02-24 15:31:15'),(1,18,6,'2018-02-24 05:49:54'),(1,18,9,'2018-02-24 02:05:14'),(1,18,8,'2018-02-24 01:23:42'),(1,18,10,'2018-02-24 00:31:34'),(1,18,8,'2018-02-23 22:58:29'),(1,18,9,'2018-02-23 21:29:50'),(1,18,9,'2018-02-23 20:36:13'),(2,1,8,'2018-10-01 01:53:25'),(2,1,9,'2018-10-01 00:19:33'),(2,1,9,'2018-09-30 23:56:05'),(2,1,9,'2018-09-30 23:54:35'),(2,1,6,'2018-09-30 23:39:38'),(2,1,6,'2018-09-30 21:04:11'),(2,1,9,'2018-09-30 20:36:44'),(2,1,9,'2018-09-30 20:07:57'),(2,1,8,'2018-09-30 19:01:06'),(2,1,9,'2018-09-30 18:19:43'),(2,1,9,'2018-09-30 17:35:48'),(2,1,6,'2018-09-30 17:34:08'),(2,1,8,'2018-09-30 16:42:15'),(2,1,9,'2018-09-30 16:22:18'),(2,1,8,'2018-09-30 16:22:14'),(2,1,9,'2018-09-30 16:10:28'),(2,1,8,'2018-09-30 15:47:20'),(2,1,8,'2018-09-30 15:30:27'),(2,1,8,'2018-09-30 14:35:53'),(2,1,6,'2018-09-30 14:29:41'),(2,1,6,'2018-09-30 14:20:08'),(2,1,9,'2018-09-30 14:15:07'),(2,1,7,'2018-09-30 13:52:16'),(2,1,8,'2018-09-29 22:09:16'),(2,1,6,'2018-09-29 14:00:17'),(2,1,9,'2018-09-29 11:35:43'),(2,1,3,'2018-09-29 00:23:20'),(2,1,9,'2018-09-29 00:18:54'),(2,1,7,'2018-09-29 00:13:56'),(2,2,10,'2018-09-24 00:29:21'),(2,2,9,'2018-09-23 22:19:18'),(2,2,8,'2018-09-23 22:16:51'),(2,2,9,'2018-09-23 21:10:15'),(2,2,5,'2018-09-23 21:07:17'),(2,2,5,'2018-09-23 20:33:39'),(2,2,8,'2018-09-23 20:15:35'),(2,2,8,'2018-09-23 20:09:31'),(2,2,7,'2018-09-23 20:07:31'),(2,2,10,'2018-09-23 18:27:56'),(2,2,9,'2018-09-23 18:22:34'),(2,2,9,'2018-09-23 16:45:11'),(2,2,9,'2018-09-23 15:10:11'),(2,2,7,'2018-09-23 14:36:00'),(2,2,7,'2018-09-23 14:31:34'),(2,2,5,'2018-09-23 13:17:22'),(2,2,7,'2018-09-23 13:14:34'),(2,2,8,'2018-09-23 12:37:29'),(2,2,9,'2018-09-23 03:36:16'),(2,2,9,'2018-09-23 00:12:58'),(2,2,7,'2018-09-22 21:38:01'),(2,2,7,'2018-09-22 15:59:18'),(2,2,8,'2018-09-22 13:39:08'),(2,2,10,'2018-09-22 13:38:24'),(2,2,7,'2018-09-22 12:55:54'),(2,2,9,'2018-09-22 12:42:54'),(2,2,9,'2018-09-22 12:02:11'),(2,2,9,'2018-09-22 11:42:22'),(2,2,7,'2018-09-22 10:31:35'),(2,3,9,'2018-09-17 01:38:34'),(2,3,4,'2018-09-17 01:18:46'),(2,3,8,'2018-09-17 00:36:35'),(2,3,8,'2018-09-17 00:33:02'),(2,3,9,'2018-09-17 00:29:52'),(2,3,9,'2018-09-16 21:55:44'),(2,3,7,'2018-09-16 21:00:17'),(2,3,8,'2018-09-16 20:36:15'),(2,3,6,'2018-09-16 18:17:00'),(2,3,4,'2018-09-16 18:07:26'),(2,3,6,'2018-09-16 17:51:29'),(2,3,8,'2018-09-16 16:13:21'),(2,3,8,'2018-09-16 16:01:07'),(2,3,8,'2018-09-16 15:12:17'),(2,3,9,'2018-09-16 14:29:14'),(2,3,9,'2018-09-16 14:23:55'),(2,3,9,'2018-09-16 12:34:38'),(2,3,10,'2018-09-16 12:21:02'),(2,3,9,'2018-09-16 12:10:16'),(2,3,6,'2018-09-15 15:09:04'),(2,3,7,'2018-09-15 15:05:16'),(2,3,9,'2018-09-15 14:39:52'),(2,3,6,'2018-09-15 12:53:57'),(2,3,7,'2018-09-15 12:07:56'),(2,3,6,'2018-09-15 11:37:04'),(2,3,6,'2018-09-15 11:04:57'),(2,3,9,'2018-09-15 01:31:46'),(2,3,7,'2018-09-15 01:30:37'),(2,4,3,'2018-09-10 00:54:49'),(2,4,10,'2018-09-09 21:42:21'),(2,4,9,'2018-09-09 21:00:12'),(2,4,10,'2018-09-09 20:40:30'),(2,4,5,'2018-09-09 20:04:06'),(2,4,5,'2018-09-09 19:25:56'),(2,4,8,'2018-09-09 16:35:04'),(2,4,7,'2018-09-09 15:45:45'),(2,4,10,'2018-09-09 11:31:41'),(2,4,9,'2018-09-09 11:15:53'),(2,4,9,'2018-09-08 22:16:00'),(2,4,9,'2018-09-08 20:22:20'),(2,4,4,'2018-09-08 18:27:49'),(2,4,4,'2018-09-08 16:09:16'),(2,4,1,'2018-09-08 15:20:30'),(2,4,9,'2018-09-07 23:58:58'),(2,4,10,'2018-09-07 22:47:39'),(2,4,7,'2018-09-07 21:50:45'),(2,4,7,'2018-09-07 17:03:30'),(2,4,5,'2018-09-07 15:40:10'),(2,4,8,'2018-09-07 14:20:55'),(2,4,6,'2018-09-07 13:08:45'),(2,4,10,'2018-09-07 12:33:20'),(2,4,5,'2018-09-07 12:15:54'),(2,4,10,'2018-09-07 01:55:03'),(2,4,7,'2018-09-07 01:54:22'),(2,4,9,'2018-09-06 23:46:03'),(2,4,8,'2018-09-06 22:35:37'),(2,4,3,'2018-09-06 21:37:09'),(2,4,8,'2018-09-06 20:55:10'),(2,5,10,'2018-09-03 00:04:37'),(2,5,10,'2018-09-02 22:47:34'),(2,5,9,'2018-09-02 21:54:24'),(2,5,10,'2018-09-02 20:01:46'),(2,5,10,'2018-09-02 19:56:42'),(2,5,9,'2018-09-02 19:34:15'),(2,5,10,'2018-09-02 16:58:30'),(2,5,8,'2018-09-02 16:55:46'),(2,5,8,'2018-09-02 16:26:32'),(2,5,9,'2018-09-02 13:25:25'),(2,5,9,'2018-09-02 11:19:04'),(2,5,10,'2018-09-02 01:46:19'),(2,5,8,'2018-09-02 01:31:46'),(2,5,9,'2018-09-01 23:18:19'),(2,5,9,'2018-09-01 22:46:04'),(2,5,8,'2018-09-01 22:28:02'),(2,5,9,'2018-09-01 22:25:03'),(2,5,9,'2018-09-01 22:16:33'),(2,5,6,'2018-09-01 22:05:15'),(2,5,10,'2018-09-01 19:34:15'),(2,5,10,'2018-09-01 17:59:32'),(2,5,10,'2018-09-01 01:41:56'),(2,5,9,'2018-09-01 01:12:22'),(2,5,9,'2018-09-01 00:51:22'),(2,5,10,'2018-08-31 23:10:08'),(2,5,9,'2018-08-31 22:36:05'),(2,5,8,'2018-08-31 21:50:14'),(2,5,9,'2018-08-31 21:40:33'),(2,5,10,'2018-08-31 21:26:54'),(2,5,8,'2018-08-31 21:19:54'),(2,6,5,'2018-08-26 18:44:12'),(2,6,7,'2018-08-26 17:46:44'),(2,6,9,'2018-08-26 17:24:26'),(2,6,9,'2018-08-26 15:37:19'),(2,6,9,'2018-08-26 14:15:31'),(2,6,6,'2018-08-26 13:41:11'),(2,6,8,'2018-08-26 09:24:25'),(2,6,8,'2018-08-26 03:22:46'),(2,6,8,'2018-08-26 01:01:05'),(2,6,9,'2018-08-26 00:27:38'),(2,6,7,'2018-08-25 19:42:47'),(2,6,6,'2018-08-25 19:04:43'),(2,6,7,'2018-08-25 18:53:08'),(2,6,10,'2018-08-25 15:42:11'),(2,6,4,'2018-08-25 15:10:07'),(2,6,10,'2018-08-25 14:56:30'),(2,6,6,'2018-08-25 14:43:48'),(2,6,7,'2018-08-25 11:07:53'),(2,6,9,'2018-08-25 10:49:33'),(2,6,9,'2018-08-25 10:45:33'),(2,6,10,'2018-08-25 04:07:58'),(2,6,7,'2018-08-24 22:42:32'),(2,6,8,'2018-08-24 22:42:26'),(2,6,7,'2018-08-24 22:36:28'),(2,6,6,'2018-08-24 21:59:47'),(2,6,9,'2018-08-24 21:54:11'),(2,6,7,'2018-08-24 21:48:55'),(2,6,6,'2018-08-24 21:43:55'),(2,6,7,'2018-08-24 21:25:22'),(2,6,6,'2018-08-24 21:17:46'),(2,7,6,'2018-08-19 16:07:28'),(2,7,4,'2018-08-19 15:47:37'),(2,7,9,'2018-08-19 12:57:02'),(2,7,8,'2018-08-19 04:24:55'),(2,7,7,'2018-08-19 00:51:45'),(2,7,7,'2018-08-18 23:47:57'),(2,7,8,'2018-08-18 22:33:20'),(2,7,9,'2018-08-18 22:17:02'),(2,7,10,'2018-08-18 20:49:56'),(2,7,10,'2018-08-18 18:40:38'),(2,7,8,'2018-08-18 16:51:45'),(2,7,6,'2018-08-18 16:14:41'),(2,7,9,'2018-08-18 16:11:53'),(2,7,9,'2018-08-18 16:07:20'),(2,7,7,'2018-08-18 13:25:34'),(2,7,8,'2018-08-18 11:48:48'),(2,7,8,'2018-08-18 11:44:23'),(2,7,6,'2018-08-18 03:07:39'),(2,7,8,'2018-08-18 02:10:41'),(2,7,8,'2018-08-18 02:06:30'),(2,7,8,'2018-08-18 01:25:08'),(2,7,8,'2018-08-18 01:14:33'),(2,7,10,'2018-08-18 01:01:17'),(2,7,10,'2018-08-18 00:58:59'),(2,7,10,'2018-08-18 00:56:38'),(2,7,9,'2018-08-17 23:39:05'),(2,7,9,'2018-08-17 22:15:01'),(2,7,9,'2018-08-17 22:11:10'),(2,7,10,'2018-08-17 21:59:13'),(2,7,6,'2018-08-17 21:57:13'),(2,8,9,'2018-08-12 15:30:33'),(2,8,9,'2018-08-12 00:44:45'),(2,8,9,'2018-08-11 14:35:45'),(2,8,8,'2018-08-11 14:12:10'),(2,8,10,'2018-08-11 14:09:58'),(2,8,9,'2018-08-11 14:03:46'),(2,8,8,'2018-08-11 13:41:39'),(2,8,10,'2018-08-11 13:34:22'),(2,8,9,'2018-08-11 12:36:51'),(2,8,9,'2018-08-11 11:18:37'),(2,8,8,'2018-08-11 02:27:16'),(2,8,9,'2018-08-11 02:25:42'),(2,8,8,'2018-08-11 02:24:52'),(2,8,8,'2018-08-11 01:36:38'),(2,8,9,'2018-08-11 01:32:08'),(2,8,10,'2018-08-11 01:19:48'),(2,8,10,'2018-08-11 01:08:25'),(2,8,9,'2018-08-11 01:07:29'),(2,8,9,'2018-08-10 23:59:35'),(2,8,9,'2018-08-10 23:45:09'),(2,8,9,'2018-08-10 23:19:56'),(2,8,7,'2018-08-10 22:08:49'),(2,8,9,'2018-08-10 22:06:25'),(2,8,9,'2018-08-10 21:56:55'),(2,8,9,'2018-08-10 21:11:48'),(2,8,8,'2018-08-10 21:08:17'),(2,8,9,'2018-08-10 20:59:04'),(2,8,9,'2018-08-10 20:37:19'),(2,8,9,'2018-08-10 20:27:30'),(2,8,8,'2018-08-10 20:07:40');

--
-- Table structure for table `presencas`
--

CREATE TABLE `presencas` (
  `turmaId` int(11) NOT NULL,
  `presencas` int(11) NOT NULL,
  `numeroSemana` int(11) NOT NULL,
  KEY `turmaId` (`turmaId`),
  CONSTRAINT `presencas_ibfk_1` FOREIGN KEY (`turmaId`) REFERENCES `turmas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `presencas`
--

INSERT INTO `presencas` VALUES (1,150,1),(1,141,2),(1,145,3),(1,142,4),(1,107,5),(1,136,6),(1,147,7),(1,141,8),(1,150,9),(1,141,10),(1,145,11),(1,142,12),(1,107,13),(1,136,14),(1,147,15),(1,141,16),(1,141,17),(1,141,18),(2,150,1),(2,141,2),(2,145,3),(2,142,4),(2,107,5),(2,136,6),(2,147,7),(2,141,8);

--
-- Table structure for table `temas`
--

CREATE TABLE `temas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(100) NOT NULL,
  `descricao` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nome` (`nome`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `temas`
--

INSERT INTO `temas` VALUES (1,'UX','Intro do Curso UX'),(2,'Loja','qqw'),(3,'HTML E CSS II','GitHub básico Web Design Responsivo'),(4,'PROJETO 1','M de Maravilhosas 2.0 - Individual e grupo'),(5,'LÓGICA + JS',''),(6,'JAVASCRIPT I',''),(7,'JAVASCRIPT II',''),(8,'PROJETO 2','Projeto JS - To do list'),(9,'SCSS','Pré-processadores tecnologias assistivas'),(10,'JS + Jquery',''),(11,'Bootstrap','Bootstrap GitHub'),(12,'PROJETO 3','Projeto com clientes reais - Equipe'),(13,'JAVASCRIPT III',''),(14,'JAVASCRIPT IV',''),(15,'REACT I',''),(16,'REACT II',''),(17,'CARREIRA','Intro projeto final Orientação Profissional Revisão Currículo Projeto prático de construir o curriculo (em html/css) Aula Orçamento/Salário'),(18,'PROJETO 4','Livre - Individual');

--
-- Table structure for table `temasemana`
--

CREATE TABLE `temasemana` (
  `numeroSemana` int(11) NOT NULL,
  `conteudoId` int(11) NOT NULL,
  `turmaId` int(11) NOT NULL,
  KEY `conteudoId` (`conteudoId`),
  KEY `turmaId` (`turmaId`),
  CONSTRAINT `temasemana_ibfk_1` FOREIGN KEY (`conteudoId`) REFERENCES `temas` (`id`),
  CONSTRAINT `temasemana_ibfk_2` FOREIGN KEY (`turmaId`) REFERENCES `turmas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `temasemana`
--

INSERT INTO `temasemana` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,5,1),(6,6,1),(7,7,1),(8,8,1),(9,9,1),(10,10,1),(11,11,1),(12,12,1),(13,13,1),(14,14,1),(15,15,1),(16,16,1),(17,17,1),(18,18,1),(1,1,2),(2,2,2),(3,3,2),(4,4,2),(5,5,2),(6,6,2),(7,7,2),(8,8,2),(9,9,2),(10,10,2),(11,11,2),(12,12,2),(13,13,2),(14,14,2),(15,15,2),(16,16,2),(17,17,2),(18,18,2);

--
-- Table structure for table `turmas`
--

CREATE TABLE `turmas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(100) NOT NULL,
  `quantidadeSemanas` int(11) DEFAULT NULL,
  `quantidadeAlunas` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `turmas`
--

INSERT INTO `turmas` VALUES (1,'T5',30,18),(2,'T6',30,18),(3,'Turma2',2,3),(4,'turma1',10,20);


