text: -- MySQL dump 10.16  Distrib 10.1.30-MariaDB, for Win32 (AMD64)
  --
  -- Host: 127.0.0.1    Database: medical_appointments
  -- ------------------------------------------------------
  -- Server version	10.1.30-MariaDB
  
  /*!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 */;
  /*!40101 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 `explorations`
  --
  
  DROP TABLE IF EXISTS `explorations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `explorations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `specialty_id` int(10) unsigned NOT NULL,
    `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `de` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `explorations_specialty_id_foreign` (`specialty_id`),
    CONSTRAINT `explorations_specialty_id_foreign` FOREIGN KEY (`specialty_id`) REFERENCES `specialties` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `explorations`
  --
  
  LOCK TABLES `explorations` WRITE;
  /*!40000 ALTER TABLE `explorations` DISABLE KEYS */;
  INSERT INTO `explorations` VALUES (1,9,'PEAK FLOW:          VN:     %','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(2,9,'FACIES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(3,9,'MUCOSA NASAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(4,9,'SECRECION NASAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(5,9,'HIPERTROFIA DE CORNETES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(6,9,'% OBSTRUCCION:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(7,9,'GOTEO POST NASAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(8,9,'AMIGDALAS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(9,9,'FARINGE:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(10,9,'OTOSCOPIA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(11,9,'CsPs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(12,9,'RsCs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(13,9,'ABDOMEN:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(14,9,'PIEL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(15,9,'PEAK FLOW:          VN:     %','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(16,9,'FACIES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(17,9,'MUCOSA NASAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(18,9,'SECRECION NASAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(19,9,'HIPERTROFIA DE CORNETES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(20,9,'% OBSTRUCCION:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(21,9,'GOTEO POST NASAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(22,9,'AMIGDALAS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(23,9,'FARINGE:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(24,9,'OTOSCOPIA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(25,9,'CsPs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(26,9,'RsCs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(27,9,'ABDOMEN:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(28,9,'PIEL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(29,8,'ESFERA MENTAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(30,8,'LENGUAJE:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(31,8,'PARES CRANEALES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(32,8,'FUERZA MUSCULAR:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(33,8,'REFLEJO MIOTATICOS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(34,8,'SENSIBILIDAD SUPERFICIAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(35,8,'SENSIBILIDAD PROFUNDA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(36,8,'SENSIBILIDAD PARIETO-CORTICAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(37,8,'COORDINACION Y MARCHA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(38,8,'ESFERA MENTAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(39,8,'LENGUAJE:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(40,8,'PARES CRANEALES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(41,8,'FUERZA MUSCULAR:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(42,8,'REFLEJO MIOTATICOS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(43,8,'SENSIBILIDAD SUPERFICIAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(44,8,'SENSIBILIDAD PROFUNDA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(45,8,'SENSIBILIDAD PARIETO-CORTICAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(46,8,'COORDINACION Y MARCHA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(47,3,'TA:                    FC:                    TEMP:                    HGT:                    IMC:                    CA:                    CC:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(48,3,'EXAMEN FISICO GENERAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(49,3,'CABEZA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(50,3,'REGION CERVICAL: TIROIDES','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(51,3,'TORAX:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(52,3,'CsPs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(53,3,'RsCs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(54,3,'ABDOMEN:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(55,3,'GENITALES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(56,3,'EXTREMIDADES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(57,3,'TA:                    FC:                    TEMP:                    HGT:                    IMC:                    CA:                    CC:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(58,3,'EXAMEN FISICO GENERAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(59,3,'CABEZA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(60,3,'REGION CERVICAL: TIROIDES','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(61,3,'TORAX:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(62,3,'CsPs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(63,3,'RsCs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(64,3,'ABDOMEN:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(65,3,'GENITALES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(66,3,'EXTREMIDADES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(67,1,'TA:                              FC:                              TEMP:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(68,1,'ESTADO DE CONCIENCIA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(69,1,'CABEZA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(70,1,'NARIZ:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(71,1,'OJOS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(72,1,'BOCA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(73,1,'PIEZAS DENTARIAS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(74,1,'OIDOS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(75,1,'CUELLO:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(76,1,'TORAX:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(77,1,'CsPs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(78,1,'RsCs:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(79,1,'ABDOMEN:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(80,1,'GENITALES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(81,1,'EXTREMIDADES:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(82,1,'PIEL Y FANERAS:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(83,1,'TACTO RECTAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(84,1,'TACTO VAGINAL:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(85,1,'TA:                              FC:                              TEMP:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(86,1,'ESTADO DE CONCIENCIA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(87,1,'CABEZA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(88,1,'NARIZ:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(89,1,'OJOS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(90,1,'BOCA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(91,1,'PIEZAS DENTARIAS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(92,1,'OIDOS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(93,1,'CUELLO:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(94,1,'TORAX:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(95,1,'CsPs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(96,1,'RsCs:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(97,1,'ABDOMEN:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(98,1,'GENITALES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(99,1,'EXTREMIDADES:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(100,1,'PIEL Y FANERAS:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(101,1,'TACTO RECTAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(102,1,'TACTO VAGINAL:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(103,5,'PA:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(104,5,'FUM:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(105,5,'PA:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(106,5,'FUM:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(107,6,'TOLERA EL DECÚBITO DORSAL, SIN EDEMAS, PULSOS REGULARES Y SIMÉTRICOS, ADECUADA PERFUSIÓN PERIFÉRICA. \r\nBUENA VENTILACIÓN PULMONAR BILATERAL SIN RUIDOS PATOLÓGICOS AGREGADOS.','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(108,6,'RS CS R1, R2 REGULARES, NO SOPLOS NI FROTES. CARÓTIDAS IMPRESIONAN SIN SOPLOS NATIVOS. NO PALPO NI AUSCULTO LATIDOS / SOPLOS VASCULARES PATOLÓGICOS ABDOMINALES, NO VISCEROMEGALIAS. PALPACIÓN TIROIDEA IMPRESIONA SIN ALTERACIONES.','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(109,6,'NO ADENOPATÍAS. DIALOGO COHERENTE, SIN DÉFICIT NEUROLÓGICO MOTOR / COGNOSCITIVO.\r\n\r\nPRESIÓN ARTERIAL SENTADA: \r\n\r\nPRESIÓN ARTERIAL ACOSTADA: \r\n\r\nFRECUENCIA CARDIACA: \r\n\r\nEKG:','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(110,6,'PRESIÓN ARTERIAL SENTADA: \r\n\r\nPRESIÓN ARTERIAL ACOSTADA: \r\n\r\nFRECUENCIA CARDIACA: \r\n\r\nEKG:','E',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(111,10,'OIDOS: NORMAL\r\n\r\nNARIZ: NORMAL\r\n\r\nS. P. N.: NORMAL\r\n\r\nBOCA: NORMAL\r\n\r\nNASOFARINGE: NORMAL\r\n\r\nVIDEOENDOSCOPIA: \r\n\r\nOROFARINGE: NORMAL\r\n\r\nHIPOFARINGE: NORMAL\r\n\r\nTIROIDES LINGUAL  (  )','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03'),(112,10,'\r\nQUISTE DE BASE DE LENGUA (  )\r\n\r\nLARINGE: NORMAL (  )\r\n\r\nSUPRAGLOTIS:\r\n\r\nGLOTIS:\r\n\r\nSUBGLOTIS:\r\n\r\nCUELLO: NORMAL\r\n\r\nGLANDULAS SALIVALES: NORMAL\r\n\r\nTIROIDES: NORMAL','D',1,'2018-11-25 16:47:03','2018-11-25 16:47:03');
  /*!40000 ALTER TABLE `explorations` 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 2018-11-25 13:13:26
  