--
-- Host: localhost    Database: partielspringboot
-- ------------------------------------------------------


--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `number_hours` int(11) NOT NULL,
  `theme_course` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (2,6,'JAVA'),(3,2,'Anglais'),(4,200,'Droit'),(5,200,'Espagnol');

--
-- Table structure for table `course_students`
--

CREATE TABLE `course_students` (
  `courses_id` bigint(20) NOT NULL,
  `students_id` bigint(20) NOT NULL,
  KEY `FK7mhqe7c7wdlfxa8adf5npc1h0` (`students_id`),
  KEY `FKh6irfl8rj4jgb3xrlyxsr2bdk` (`courses_id`),
  CONSTRAINT `FK7mhqe7c7wdlfxa8adf5npc1h0` FOREIGN KEY (`students_id`) REFERENCES `personne` (`id`),
  CONSTRAINT `FKh6irfl8rj4jgb3xrlyxsr2bdk` FOREIGN KEY (`courses_id`) REFERENCES `course` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_students`
--


--
-- Table structure for table `personne_courses`
--

CREATE TABLE `personne_courses` (
  `student_id` bigint(20) NOT NULL,
  `courses_id` bigint(20) NOT NULL,
  KEY `FKrr566akgbbu1psgm43cxemcpc` (`courses_id`),
  KEY `FK3gfwj6mm3boeqnd1jq9qkn8wl` (`student_id`),
  CONSTRAINT `FK3gfwj6mm3boeqnd1jq9qkn8wl` FOREIGN KEY (`student_id`) REFERENCES `personne` (`id`),
  CONSTRAINT `FKrr566akgbbu1psgm43cxemcpc` FOREIGN KEY (`courses_id`) REFERENCES `course` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personne_courses`
--

INSERT INTO `personne_courses` VALUES (1,2),(1,3),(1,4),(1,5);


