Untitled

DROP TABLE IF EXISTS `consultas`;

CREATE TABLE `consultas` (
  `idmedicos` int(10) unsigned NOT NULL,
  `idpacientes` int(10) unsigned NOT NULL,
  `idambulatorios` int(10) unsigned NOT NULL,
  `dia` date NOT NULL,
  `hora` time NOT NULL,
  `iddoencas` int(5) unsigned NOT NULL,
  KEY `fkIdx_53` (`idmedicos`),
  KEY `fkIdx_59` (`idpacientes`),
  CONSTRAINT `FK_53` FOREIGN KEY (`idmedicos`) REFERENCES `medicos` (`idmedicos`),
  CONSTRAINT `FK_59` FOREIGN KEY (`idpacientes`) REFERENCES `pacientes` (`idpacientes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `consultas`
--

LOCK TABLES `consultas` WRITE;
 ALTER TABLE `consultas` DISABLE KEYS;
INSERT INTO `consultas` VALUES (6,12,5,'2017-06-03','08:30:00',4),(12,12,2,'2016-08-05','17:00:00',1),(12,12,1,'2016-11-11','16:00:00',3),(6,12,5,'2016-11-03','08:30:00',3),(12,12,2,'2016-04-02','17:00:00',4),(12,12,1,'2016-12-21','16:00:00',3),(7,11,1,'2017-05-15','09:00:00',3),(11,11,3,'2016-04-05','17:30:00',6),(11,11,2,'2016-02-12','16:30:00',9),(7,11,1,'2017-06-02','09:00:00',9),(11,11,3,'2017-10-09','17:30:00',9),(11,11,2,'2016-03-20','16:30:00',8),(12,10,5,'2017-01-01','13:00:00',2),(7,10,2,'2017-11-09','09:30:00',4),(10,10,1,'2017-05-25','08:30:00',7),(10,10,3,'2016-03-23','17:00:00',2),(12,10,5,'2017-06-29','13:00:00',7),(7,10,2,'2016-10-15','09:30:00',2),(10,10,1,'2016-12-15','08:30:00',7),(10,10,3,'2017-12-15','17:00:00',9),(9,9,4,'2017-03-17','12:30:00',5),(6,9,4,'2016-01-09','17:30:00',6),(9,9,1,'2016-02-18','16:30:00',4),(9,9,3,'2017-08-10','15:30:00',5),(9,9,4,'2017-07-24','12:30:00',4),(6,9,4,'2016-02-22','17:30:00',1),(9,9,1,'2016-05-19','16:30:00',7),(9,9,3,'2017-04-24','15:30:00',9),(5,8,3,'2016-09-18','17:00:00',5),(8,8,3,'2016-03-17','16:00:00',9),(8,8,2,'2016-02-16','15:00:00',9),(5,8,3,'2016-08-16','17:00:00',8),(8,8,3,'2017-02-18','16:00:00',5),(8,8,2,'2016-08-06','15:00:00',1),(7,7,2,'2017-02-11','11:30:00',8),(5,7,2,'2016-01-14','16:30:00',9),(7,7,2,'2016-03-05','15:30:00',1),(7,7,1,'2017-04-27','14:30:00',8),(7,7,2,'2016-04-02','11:30:00',6),(5,7,2,'2016-01-23','16:30:00',8),(7,7,2,'2017-12-04','15:30:00',0),(7,7,1,'2016-11-16','14:30:00',7),(6,6,1,'2016-01-03','11:00:00',6),(4,6,1,'2016-09-01','16:00:00',9),(6,6,1,'2017-10-05','15:00:00',8),(6,6,3,'2017-11-21','14:00:00',1),(6,6,1,'2016-10-20','11:00:00',1),(4,6,1,'2016-11-27','16:00:00',4),(6,6,1,'2017-10-25','15:00:00',6),(6,6,3,'2016-03-18','14:00:00',9),(5,5,5,'2016-11-13','10:30:00',7),(3,5,5,'2017-07-11','15:30:00',8),(9,5,1,'2016-07-21','12:00:00',0),(5,5,3,'2016-03-05','14:30:00',6),(5,5,3,'2016-01-08','11:00:00',7),(5,5,2,'2017-12-26','13:30:00',10),(5,5,2,'2017-08-20','10:00:00',6),(5,5,5,'2016-06-13','10:30:00',3),(3,5,5,'2017-07-20','15:30:00',5),(9,5,1,'2017-09-08','12:00:00',6),(5,5,3,'2017-12-05','14:30:00',5),(5,5,3,'2017-09-08','11:00:00',6),(5,5,2,'2016-09-28','13:30:00',7),(5,5,2,'2016-06-29','10:00:00',6),(4,4,4,'2017-03-27','10:00:00',9),(8,4,3,'2017-03-24','12:00:00',5),(2,4,4,'2016-09-08','15:00:00',1),(9,4,3,'2017-07-12','11:30:00',10),(4,4,2,'2017-03-20','14:00:00',4),(4,4,2,'2017-07-08','10:30:00',4),(4,4,1,'2017-01-08','13:00:00',5),(4,4,1,'2016-02-17','09:30:00',3),(4,4,4,'2017-11-22','10:00:00',1),(8,4,3,'2017-06-04','12:00:00',5),(2,4,4,'2017-02-28','15:00:00',4),(9,4,3,'2016-01-05','11:30:00',3),(4,4,2,'2017-07-04','14:00:00',4),(4,4,2,'2017-12-22','10:30:00',1),(4,4,1,'2017-04-22','13:00:00',4),(4,4,1,'2017-07-29','09:30:00',7),(3,3,3,'2016-07-22','09:30:00',2),(1,3,3,'2016-04-27','14:30:00',9),(8,3,2,'2017-05-13','11:00:00',9),(3,3,1,'2017-12-22','13:30:00',8),(3,3,1,'2016-09-15','10:00:00',4),(3,3,3,'2017-10-24','12:30:00',4),(3,3,3,'2017-01-20','09:00:00',1),(3,3,3,'2016-11-28','09:30:00',0),(1,3,3,'2017-09-06','14:30:00',9),(8,3,2,'2016-01-02','11:00:00',5),(3,3,1,'2017-10-25','13:30:00',7),(3,3,1,'2016-08-01','10:00:00',2),(3,3,3,'2017-03-15','12:30:00',6),(3,3,3,'2016-08-01','09:00:00',5),(2,2,2,'2017-03-24','09:00:00',6),(10,2,2,'2016-10-18','14:00:00',6),(8,2,1,'2016-01-19','10:30:00',0),(2,2,3,'2017-03-14','13:00:00',4),(2,2,3,'2017-06-25','09:30:00',8),(2,2,2,'2017-03-20','12:00:00',10),(2,2,2,'2017-12-07','08:30:00',3),(2,2,2,'2017-08-24','09:00:00',8),(10,2,2,'2016-07-26','14:00:00',9),(8,2,1,'2016-06-13','10:30:00',1),(2,2,3,'2017-04-26','13:00:00',8),(2,2,3,'2016-02-05','09:30:00',6),(2,2,2,'2016-06-13','12:00:00',7),(2,2,2,'2017-01-18','08:30:00',7),(1,1,1,'2016-03-21','08:30:00',5),(11,1,1,'2016-03-08','13:30:00',1),(8,1,3,'2017-07-07','10:00:00',3),(1,1,2,'2017-07-14','12:30:00',2),(1,1,2,'2017-02-12','09:00:00',2),(1,1,1,'2017-02-12','11:30:00',2),(1,1,1,'2016-06-01','17:30:00',6),(1,1,1,'2016-09-18','08:30:00',1),(11,1,1,'2016-06-03','13:30:00',9),(8,1,3,'2017-11-28','10:00:00',2),(1,1,2,'2017-03-29','12:30:00',2),(1,1,2,'2016-03-22','09:00:00',4),(1,1,1,'2016-03-13','11:30:00',6),(1,1,1,'2017-12-07','17:30:00',6),(1,1,1,'2019-10-10','08:00:00',1);
ALTER TABLE `consultas` ENABLE KEYS;
UNLOCK TABLES;