--
-- Host: localhost    Database: covoit2025
-- ------------------------------------------------------


--
-- Table structure for table `OfficeCovoit`
--

CREATE TABLE `OfficeCovoit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jour` enum('lundi','mardi','mercredi','jeudi','vendredi') NOT NULL,
  `heure` time NOT NULL,
  `date` date NOT NULL,
  `lieu` varchar(40) NOT NULL,
  `chauffeur` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `chauffeur` (`chauffeur`),
  CONSTRAINT `OfficeCovoit_ibfk_1` FOREIGN KEY (`chauffeur`) REFERENCES `CovoItUser` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `OfficeCovoit`
--

INSERT INTO `OfficeCovoit` VALUES (1,'lundi','08:30:00','2024-01-15','Paris Gare de Lyon',1),(2,'mardi','09:00:00','2024-01-16','Paris Opéra',2),(3,'mercredi','08:45:00','2024-01-17','Paris Châtelet',3),(4,'jeudi','08:15:00','2024-01-18','Paris Montparnasse',4),(5,'vendredi','09:30:00','2024-01-19','Paris République',5),(6,'lundi','08:00:00','2024-01-22','Paris Bastille',1),(7,'mardi','08:45:00','2024-01-23','Paris Nation',2);


