· 8 years ago · May 29, 2018, 01:24 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: 127.0.0.1 Database: teleanestesia
4-- ------------------------------------------------------
5-- Server version 5.5.5-10.1.21-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `attached`
20--
21
22DROP TABLE IF EXISTS `attached`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `attached` (
26 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `created_at` timestamp NULL DEFAULT NULL,
28 `updated_at` timestamp NULL DEFAULT NULL,
29 `report_id` int(10) unsigned NOT NULL,
30 `url_file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
31 PRIMARY KEY (`id`),
32 KEY `attached_report_id_foreign` (`report_id`),
33 CONSTRAINT `attached_report_id_foreign` FOREIGN KEY (`report_id`) REFERENCES `reports` (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `attached`
39--
40
41LOCK TABLES `attached` WRITE;
42/*!40000 ALTER TABLE `attached` DISABLE KEYS */;
43/*!40000 ALTER TABLE `attached` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `cases`
48--
49
50DROP TABLE IF EXISTS `cases`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `cases` (
54 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
55 `diagnosis` text COLLATE utf8mb4_unicode_ci NOT NULL,
56 `intervention` text COLLATE utf8mb4_unicode_ci NOT NULL,
57 `health_center` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
58 `status` tinyint(1) NOT NULL DEFAULT '1',
59 `character` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
60 `language` tinyint(4) NOT NULL,
61 `patient_id` int(10) unsigned NOT NULL,
62 `surgical_service` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
63 `doctor_id` int(10) unsigned NOT NULL,
64 `created_at` timestamp NULL DEFAULT NULL,
65 `updated_at` timestamp NULL DEFAULT NULL,
66 PRIMARY KEY (`id`),
67 KEY `cases_patient_id_foreign` (`patient_id`),
68 KEY `cases_doctor_id_foreign` (`doctor_id`),
69 CONSTRAINT `cases_doctor_id_foreign` FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`),
70 CONSTRAINT `cases_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`)
71) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `cases`
76--
77
78LOCK TABLES `cases` WRITE;
79/*!40000 ALTER TABLE `cases` DISABLE KEYS */;
80INSERT INTO `cases` VALUES (1,'Pruebaaa','Intervención de prueba','Prueba 1',1,'Programada',1,1,'Prueba',1,'2018-01-15 10:21:53','2018-02-13 15:00:39'),(3,'dadadda editado','dadadada','Prueba 1',1,'Programada',1,6,'Prueba',1,'2018-01-25 16:24:13','2018-01-25 16:27:14'),(4,'NUevo Caso','dawdadada','Prueba 2',1,'Programada',1,6,'Prueba 2',1,'2018-01-25 16:29:56','2018-01-25 16:29:56'),(5,'Nuevo','Comprobar fecha','Prueba 1',1,'Programada',1,6,'dawdwada',1,'2018-02-08 14:35:30','2018-02-08 14:35:30'),(6,'esfeesf','fesfsfsfs','Prueba 1',1,'Programada',1,7,'Prueba',1,'2018-02-09 08:04:38','2018-02-13 15:03:30'),(7,'PDadaw','DWDawdwad','Prueba 1',1,'Programada',1,8,'Prueba',1,'2018-02-13 08:45:32','2018-02-13 08:45:32'),(8,'Nueva Cita','Nueva Cita','Nueva Cita',0,'Programada',1,8,'Nueva Cita',1,'2018-02-19 10:54:13','2018-03-14 09:35:06'),(9,'dwadwa','dadadada','Prueba 1',1,'Programada',1,8,'Prueba',1,'2018-02-19 17:26:40','2018-02-19 17:26:40'),(10,'dada','dadad','Prueba 1',1,'Programada',1,9,'Prueba',1,'2018-05-15 14:22:24','2018-05-15 14:22:24'),(11,'wdad','dad','Prueba 1',1,'Programada',1,6,'dadwa',1,'2018-05-15 14:24:33','2018-05-15 14:24:33');
81/*!40000 ALTER TABLE `cases` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `cities`
86--
87
88DROP TABLE IF EXISTS `cities`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `cities` (
92 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
93 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
94 `province_id` int(10) unsigned NOT NULL,
95 `created_at` timestamp NULL DEFAULT NULL,
96 `updated_at` timestamp NULL DEFAULT NULL,
97 PRIMARY KEY (`id`),
98 KEY `cities_province_id_foreign` (`province_id`),
99 CONSTRAINT `cities_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
100) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Dumping data for table `cities`
105--
106
107LOCK TABLES `cities` WRITE;
108/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
109INSERT INTO `cities` VALUES (1,'Cádiz',1,NULL,NULL),(2,'Sevilla',2,NULL,NULL),(3,'Jerez',1,NULL,NULL),(4,'Dos Hermanas',2,NULL,NULL);
110/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
111UNLOCK TABLES;
112
113--
114-- Table structure for table `doctor_patient`
115--
116
117DROP TABLE IF EXISTS `doctor_patient`;
118/*!40101 SET @saved_cs_client = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `doctor_patient` (
121 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
122 `created_at` timestamp NULL DEFAULT NULL,
123 `updated_at` timestamp NULL DEFAULT NULL,
124 `doctor_id` int(10) unsigned NOT NULL,
125 `patient_id` int(10) unsigned NOT NULL,
126 PRIMARY KEY (`id`),
127 KEY `doctor_patient_doctor_id_foreign` (`doctor_id`),
128 KEY `doctor_patient_patient_id_foreign` (`patient_id`),
129 CONSTRAINT `doctor_patient_doctor_id_foreign` FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`),
130 CONSTRAINT `doctor_patient_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`)
131) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `doctor_patient`
136--
137
138LOCK TABLES `doctor_patient` WRITE;
139/*!40000 ALTER TABLE `doctor_patient` DISABLE KEYS */;
140INSERT INTO `doctor_patient` VALUES (1,NULL,NULL,1,1),(2,NULL,NULL,2,2),(3,NULL,NULL,2,3),(4,NULL,NULL,1,4),(5,NULL,NULL,1,6),(6,NULL,NULL,1,7),(7,NULL,NULL,1,8),(8,NULL,NULL,1,9);
141/*!40000 ALTER TABLE `doctor_patient` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `doctors`
146--
147
148DROP TABLE IF EXISTS `doctors`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `doctors` (
152 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
153 `collegiate_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
154 `user_id` int(10) unsigned NOT NULL,
155 `calendar_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
156 `calendar_token` text COLLATE utf8mb4_unicode_ci,
157 `created_at` timestamp NULL DEFAULT NULL,
158 `updated_at` timestamp NULL DEFAULT NULL,
159 PRIMARY KEY (`id`),
160 KEY `doctors_user_id_foreign` (`user_id`),
161 CONSTRAINT `doctors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
162) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
163/*!40101 SET character_set_client = @saved_cs_client */;
164
165--
166-- Dumping data for table `doctors`
167--
168
169LOCK TABLES `doctors` WRITE;
170/*!40000 ALTER TABLE `doctors` DISABLE KEYS */;
171INSERT INTO `doctors` VALUES (1,'29/2908726',1,'aolmedobloonde@gmail.com',NULL,'2018-01-15 10:20:48','2018-02-19 11:12:51'),(2,'AAA',5,'gecaonomhhg5r0lfm1fv16fnnc@group.calendar.google.com',NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48');
172/*!40000 ALTER TABLE `doctors` ENABLE KEYS */;
173UNLOCK TABLES;
174
175--
176-- Table structure for table `doctors_patients`
177--
178
179DROP TABLE IF EXISTS `doctors_patients`;
180/*!40101 SET @saved_cs_client = @@character_set_client */;
181/*!40101 SET character_set_client = utf8 */;
182CREATE TABLE `doctors_patients` (
183 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
184 `created_at` timestamp NULL DEFAULT NULL,
185 `updated_at` timestamp NULL DEFAULT NULL,
186 `doctor_id` int(10) unsigned NOT NULL,
187 `patient_id` int(10) unsigned NOT NULL,
188 PRIMARY KEY (`id`),
189 KEY `doctors_patients_doctor_id_foreign` (`doctor_id`),
190 KEY `doctors_patients_patient_id_foreign` (`patient_id`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
192/*!40101 SET character_set_client = @saved_cs_client */;
193
194--
195-- Dumping data for table `doctors_patients`
196--
197
198LOCK TABLES `doctors_patients` WRITE;
199/*!40000 ALTER TABLE `doctors_patients` DISABLE KEYS */;
200/*!40000 ALTER TABLE `doctors_patients` ENABLE KEYS */;
201UNLOCK TABLES;
202
203--
204-- Table structure for table `failed_jobs`
205--
206
207DROP TABLE IF EXISTS `failed_jobs`;
208/*!40101 SET @saved_cs_client = @@character_set_client */;
209/*!40101 SET character_set_client = utf8 */;
210CREATE TABLE `failed_jobs` (
211 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
212 `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
213 `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
214 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
215 `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
216 `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
217 PRIMARY KEY (`id`)
218) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Dumping data for table `failed_jobs`
223--
224
225LOCK TABLES `failed_jobs` WRITE;
226/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
227/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
228UNLOCK TABLES;
229
230--
231-- Table structure for table `files`
232--
233
234DROP TABLE IF EXISTS `files`;
235/*!40101 SET @saved_cs_client = @@character_set_client */;
236/*!40101 SET character_set_client = utf8 */;
237CREATE TABLE `files` (
238 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
239 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
240 `patient_id` int(10) unsigned NOT NULL,
241 `created_at` timestamp NULL DEFAULT NULL,
242 `updated_at` timestamp NULL DEFAULT NULL,
243 PRIMARY KEY (`id`),
244 KEY `files_patient_id_foreign` (`patient_id`),
245 CONSTRAINT `files_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`)
246) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
247/*!40101 SET character_set_client = @saved_cs_client */;
248
249--
250-- Dumping data for table `files`
251--
252
253LOCK TABLES `files` WRITE;
254/*!40000 ALTER TABLE `files` DISABLE KEYS */;
255INSERT INTO `files` VALUES (1,'prueba subida.png',1,'2018-01-15 10:48:52','2018-01-15 10:48:58'),(2,'csv renombrado.csv',1,'2018-02-08 14:37:44','2018-02-08 14:37:56'),(3,'fondo1.png',8,'2018-02-19 17:18:33','2018-02-19 17:18:33'),(4,'Aceituna2.txt',8,'2018-02-19 17:23:09','2018-02-19 17:23:17');
256/*!40000 ALTER TABLE `files` ENABLE KEYS */;
257UNLOCK TABLES;
258
259--
260-- Table structure for table `forms`
261--
262
263DROP TABLE IF EXISTS `forms`;
264/*!40101 SET @saved_cs_client = @@character_set_client */;
265/*!40101 SET character_set_client = utf8 */;
266CREATE TABLE `forms` (
267 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
268 `created_at` timestamp NULL DEFAULT NULL,
269 `updated_at` timestamp NULL DEFAULT NULL,
270 `report_id` int(10) unsigned NOT NULL,
271 `alergias` tinyint(4) NOT NULL DEFAULT '0',
272 `alergias1` tinyint(4) NOT NULL DEFAULT '0',
273 `alergias2` tinyint(4) NOT NULL DEFAULT '0',
274 `alergias3` tinyint(4) NOT NULL DEFAULT '0',
275 `alergias_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
276 `fumador` tinyint(4) DEFAULT NULL,
277 `bebedor` tinyint(4) DEFAULT NULL,
278 `drogas` tinyint(4) DEFAULT NULL,
279 `drogas_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
280 `actividad` tinyint(4) DEFAULT NULL,
281 `amedicos1` tinyint(4) NOT NULL DEFAULT '0',
282 `amedicos2` tinyint(4) NOT NULL DEFAULT '0',
283 `amedicos3` tinyint(4) NOT NULL DEFAULT '0',
284 `amedicos4` tinyint(4) NOT NULL DEFAULT '0',
285 `amedicos5` tinyint(4) NOT NULL DEFAULT '0',
286 `amedicos6` tinyint(4) NOT NULL DEFAULT '0',
287 `amedicos7` tinyint(4) NOT NULL DEFAULT '0',
288 `amedicos8` tinyint(4) NOT NULL DEFAULT '0',
289 `amedicos9` tinyint(4) NOT NULL DEFAULT '0',
290 `amedicos10` tinyint(4) NOT NULL DEFAULT '0',
291 `radioamedicos10` tinyint(4) DEFAULT NULL,
292 `amedicos11` tinyint(4) NOT NULL DEFAULT '0',
293 `amedicos12` tinyint(4) NOT NULL DEFAULT '0',
294 `amedicos13` tinyint(4) NOT NULL DEFAULT '0',
295 `amedicos14` tinyint(4) NOT NULL DEFAULT '0',
296 `amedicos15` tinyint(4) NOT NULL DEFAULT '0',
297 `amedicos_otros` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
298 `aq1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
299 `aq2` tinyint(4) NOT NULL DEFAULT '0',
300 `aq3` tinyint(4) NOT NULL DEFAULT '0',
301 `aq4` tinyint(4) NOT NULL DEFAULT '0',
302 `aq5` tinyint(4) NOT NULL DEFAULT '0',
303 `aq6` tinyint(4) NOT NULL DEFAULT '0',
304 `aq7` tinyint(4) NOT NULL DEFAULT '0',
305 `aq8` tinyint(4) NOT NULL DEFAULT '0',
306 `aq8_otros` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
307 `aq9` tinyint(4) NOT NULL DEFAULT '0',
308 `aq9_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
309 `aq10` tinyint(4) DEFAULT NULL,
310 `mhabitual` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
311 `exploracion` tinyint(4) DEFAULT NULL,
312 `vaerea1` tinyint(4) NOT NULL DEFAULT '0',
313 `vaerea2` tinyint(4) DEFAULT NULL,
314 `vaerea3` tinyint(4) DEFAULT NULL,
315 `vaerea4` tinyint(4) DEFAULT NULL,
316 `vaerea5` tinyint(4) DEFAULT NULL,
317 `vaerea6` tinyint(4) DEFAULT NULL,
318 `vaerea7` tinyint(4) DEFAULT NULL,
319 `vaerea8` tinyint(4) DEFAULT NULL,
320 `vaerea9` tinyint(4) DEFAULT NULL,
321 `vaerea10` tinyint(4) DEFAULT NULL,
322 `vaerea11` tinyint(4) DEFAULT NULL,
323 `vaerea12` tinyint(4) DEFAULT NULL,
324 `vaerea13` tinyint(4) DEFAULT NULL,
325 `vaerea14` tinyint(4) DEFAULT NULL,
326 `iaerea1` tinyint(4) NOT NULL DEFAULT '0',
327 `iaerea2` tinyint(4) DEFAULT NULL,
328 `peso` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
329 `talla` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
330 `imc` double(8,2) DEFAULT NULL,
331 `examenes` text COLLATE utf8mb4_unicode_ci,
332 `vanestesica` text COLLATE utf8mb4_unicode_ci,
333 `vanestesica1` tinyint(4) NOT NULL DEFAULT '0',
334 `vanestesica2` tinyint(4) NOT NULL DEFAULT '0',
335 `vanestesica3` tinyint(4) NOT NULL DEFAULT '0',
336 `vanestesica4` tinyint(4) NOT NULL DEFAULT '0',
337 `vanestesica5` tinyint(4) NOT NULL DEFAULT '0',
338 `vanestesica6` tinyint(4) NOT NULL DEFAULT '0',
339 `vanestesica7` tinyint(4) NOT NULL DEFAULT '0',
340 `vanestesica8` tinyint(4) NOT NULL DEFAULT '0',
341 `vanestesica9` tinyint(4) NOT NULL DEFAULT '0',
342 `vanestesica10` tinyint(4) NOT NULL DEFAULT '0',
343 `vanestesica11` tinyint(4) NOT NULL DEFAULT '0',
344 `vanestesica11_otros` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
345 `preparacion_latex` text COLLATE utf8mb4_unicode_ci,
346 `preparacion1` tinyint(4) DEFAULT NULL,
347 `midazolam` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
348 `preparacion2` tinyint(4) DEFAULT NULL,
349 `preparacion5` tinyint(4) DEFAULT NULL,
350 `preparacion6` tinyint(4) DEFAULT NULL,
351 `preparacion6_1_0` tinyint(4) NOT NULL DEFAULT '0',
352 `preparacion7` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
353 `preparacion8` tinyint(4) NOT NULL DEFAULT '0',
354 `preparacion9` text COLLATE utf8mb4_unicode_ci,
355 `voluntades` tinyint(4) NOT NULL DEFAULT '0',
356 PRIMARY KEY (`id`),
357 KEY `forms_report_id_foreign` (`report_id`),
358 CONSTRAINT `forms_report_id_foreign` FOREIGN KEY (`report_id`) REFERENCES `reports` (`id`)
359) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
360/*!40101 SET character_set_client = @saved_cs_client */;
361
362--
363-- Dumping data for table `forms`
364--
365
366LOCK TABLES `forms` WRITE;
367/*!40000 ALTER TABLE `forms` DISABLE KEYS */;
368INSERT INTO `forms` VALUES (4,'2018-01-15 10:42:51','2018-03-14 12:23:34',4,1,1,1,1,'perros y gatos',NULL,1,0,NULL,0,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,'Prueba otros','Otras operaciones',1,1,1,1,1,1,1,'Prueba de otras incidencias',1,'Problemas con',1,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,2,NULL,NULL,NULL,NULL,'Prueba Slider\nNOMBRE Y APELLIDOS\nPRUEBA PÉREZ\nE-MAIL\nAOLMEDOBLOONDE@GMAIL.\nPrueba Slider\nNOMBRE Y APELLIDOS\nPRUEBA PÉREZ\nE-MAIL\nAOLMEDOBLOONDE@GMAIL.\nPrueba Slider\n%',NULL,1,0,0,0,1,0,1,1,1,1,0,NULL,NULL,0,NULL,2,0,NULL,0,NULL,0,NULL,0),(5,'2018-03-14 10:01:36','2018-03-14 10:01:36',5,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,NULL,NULL,0,0,0,0,0,0,0,NULL,0,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,0,1,0,0,0,0,0,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,0,NULL,0),(6,'2018-04-09 06:59:59','2018-05-29 11:47:31',6,1,0,0,1,NULL,2,1,1,'Ddadwadwa',1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,'Prueba de otros','Prueba de intervenciones previas',1,1,1,1,1,1,1,'Prueba de otras incidencias',0,NULL,0,'Prueba de medicación habitual',NULL,0,0,1,1,0,2,1,1,1,1,1,1,1,1,0,1,'150','1.76',48.42,'Prueba de indicación bioquÃmica','Esta es una prueba de comentarios de valoración anestésica',1,0,1,1,1,0,1,1,1,1,1,'Prueba otros','Prueba de indicaciones para látex',2,NULL,2,1,1,1,'Prueab de valoración social',1,'Prueba de profilaxis con fármacos',1);
369/*!40000 ALTER TABLE `forms` ENABLE KEYS */;
370UNLOCK TABLES;
371
372--
373-- Table structure for table `jobs`
374--
375
376DROP TABLE IF EXISTS `jobs`;
377/*!40101 SET @saved_cs_client = @@character_set_client */;
378/*!40101 SET character_set_client = utf8 */;
379CREATE TABLE `jobs` (
380 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
381 `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
382 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
383 `attempts` tinyint(3) unsigned NOT NULL,
384 `reserved_at` int(10) unsigned DEFAULT NULL,
385 `available_at` int(10) unsigned NOT NULL,
386 `created_at` int(10) unsigned NOT NULL,
387 PRIMARY KEY (`id`),
388 KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
389) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
390/*!40101 SET character_set_client = @saved_cs_client */;
391
392--
393-- Dumping data for table `jobs`
394--
395
396LOCK TABLES `jobs` WRITE;
397/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
398/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
399UNLOCK TABLES;
400
401--
402-- Table structure for table `migrations`
403--
404
405DROP TABLE IF EXISTS `migrations`;
406/*!40101 SET @saved_cs_client = @@character_set_client */;
407/*!40101 SET character_set_client = utf8 */;
408CREATE TABLE `migrations` (
409 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
410 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
411 `batch` int(11) NOT NULL,
412 PRIMARY KEY (`id`)
413) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
414/*!40101 SET character_set_client = @saved_cs_client */;
415
416--
417-- Dumping data for table `migrations`
418--
419
420LOCK TABLES `migrations` WRITE;
421/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
422INSERT INTO `migrations` VALUES (42,'2017_07_27_110443_create_doctors_patients_table',1),(106,'2014_10_12_000000_create_users_table',2),(107,'2014_10_12_100000_create_password_resets_table',2),(108,'2017_07_24_102109_create_cases_table',2),(109,'2017_07_24_102109_create_cities_table',2),(110,'2017_07_24_102109_create_doctors_table',2),(111,'2017_07_24_102109_create_files_table',2),(112,'2017_07_24_102109_create_patients_table',2),(113,'2017_07_24_102109_create_provinces_table',2),(114,'2017_07_24_102109_create_quotes_table',2),(115,'2017_07_24_102109_create_reports_table',2),(116,'2017_07_27_110443_create_attached_table',2),(117,'2017_07_27_110443_create_doctor_patient_table',2),(118,'2017_07_27_141847_create_jobs_table',2),(119,'2017_07_27_141859_create_failed_jobs_table',2),(120,'2017_07_31_082109_create_forms_table',2),(121,'2017_07_31_094558_create_foreign_keys',2);
423/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
424UNLOCK TABLES;
425
426--
427-- Table structure for table `password_resets`
428--
429
430DROP TABLE IF EXISTS `password_resets`;
431/*!40101 SET @saved_cs_client = @@character_set_client */;
432/*!40101 SET character_set_client = utf8 */;
433CREATE TABLE `password_resets` (
434 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
435 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
436 `created_at` timestamp NULL DEFAULT NULL,
437 KEY `password_resets_email_index` (`email`)
438) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
439/*!40101 SET character_set_client = @saved_cs_client */;
440
441--
442-- Dumping data for table `password_resets`
443--
444
445LOCK TABLES `password_resets` WRITE;
446/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
447INSERT INTO `password_resets` VALUES ('doctor@email.com','123456789',NULL),('aolmedo@bloonde.com','c06bbbf9701789b6df9218e14023fddade9f62195fc804bd5ca3ca997906b92f','2018-02-19 17:10:50');
448/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
449UNLOCK TABLES;
450
451--
452-- Table structure for table `patients`
453--
454
455DROP TABLE IF EXISTS `patients`;
456/*!40101 SET @saved_cs_client = @@character_set_client */;
457/*!40101 SET character_set_client = utf8 */;
458CREATE TABLE `patients` (
459 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
460 `birthday` date DEFAULT NULL,
461 `identification` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
462 `ss` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
463 `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
464 `passport` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
465 `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
466 `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
467 `phone1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
468 `insurance_company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
469 `policy_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
470 `city_id` int(10) unsigned DEFAULT NULL,
471 `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
472 `province` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
473 `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
474 `clinic_history` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
475 `user_id` int(10) unsigned NOT NULL,
476 `created_at` timestamp NULL DEFAULT NULL,
477 `updated_at` timestamp NULL DEFAULT NULL,
478 PRIMARY KEY (`id`),
479 UNIQUE KEY `patients_identification_unique` (`identification`),
480 UNIQUE KEY `patients_ss_unique` (`ss`),
481 UNIQUE KEY `patients_username_unique` (`username`),
482 KEY `patients_city_id_foreign` (`city_id`),
483 KEY `patients_user_id_foreign` (`user_id`),
484 CONSTRAINT `patients_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
485 CONSTRAINT `patients_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
486) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
487/*!40101 SET character_set_client = @saved_cs_client */;
488
489--
490-- Dumping data for table `patients`
491--
492
493LOCK TABLES `patients` WRITE;
494/*!40000 ALTER TABLE `patients` DISABLE KEYS */;
495INSERT INTO `patients` VALUES (1,'1991-10-10','12605304-L',NULL,NULL,NULL,'0','1234','123456789',NULL,NULL,NULL,NULL,NULL,'es','0101234',2,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(2,'1991-10-10','12605304N',NULL,NULL,NULL,'0','1234','123456789',NULL,NULL,NULL,NULL,NULL,'es','1101234',3,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(3,'1991-10-10','12605304D',NULL,NULL,NULL,'0','1234','123456789',NULL,NULL,NULL,NULL,NULL,'fn','20101234',4,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(4,'1991-10-10','12605304P',NULL,NULL,NULL,'0','1234','123456789',NULL,NULL,NULL,NULL,NULL,'es','3101234',6,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(6,NULL,'31325660M',NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,'Prueba','Castellón/Castelló','fn','HC0000000006',8,'2018-01-25 16:24:09','2018-02-12 12:52:09'),(7,'1988-05-29','69748291D',NULL,NULL,NULL,'0','41010',NULL,NULL,NULL,NULL,'Prueba','Castellón/Castelló','fn','HC0000000007',9,'2018-02-09 08:04:37','2018-02-12 12:36:30'),(8,'2018-04-07','15435876R','123456789120',NULL,NULL,'0','41010',NULL,NULL,NULL,1,NULL,NULL,'es','HC0000000008',10,'2018-02-13 08:45:31','2018-04-19 09:29:13'),(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HC0000000009',11,'2018-05-15 14:22:01','2018-05-15 14:22:06');
496/*!40000 ALTER TABLE `patients` ENABLE KEYS */;
497UNLOCK TABLES;
498
499--
500-- Table structure for table `provinces`
501--
502
503DROP TABLE IF EXISTS `provinces`;
504/*!40101 SET @saved_cs_client = @@character_set_client */;
505/*!40101 SET character_set_client = utf8 */;
506CREATE TABLE `provinces` (
507 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
508 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
509 `created_at` timestamp NULL DEFAULT NULL,
510 `updated_at` timestamp NULL DEFAULT NULL,
511 PRIMARY KEY (`id`)
512) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
513/*!40101 SET character_set_client = @saved_cs_client */;
514
515--
516-- Dumping data for table `provinces`
517--
518
519LOCK TABLES `provinces` WRITE;
520/*!40000 ALTER TABLE `provinces` DISABLE KEYS */;
521INSERT INTO `provinces` VALUES (1,'Cádiz',NULL,NULL),(2,'Sevilla',NULL,NULL);
522/*!40000 ALTER TABLE `provinces` ENABLE KEYS */;
523UNLOCK TABLES;
524
525--
526-- Table structure for table `quotes`
527--
528
529DROP TABLE IF EXISTS `quotes`;
530/*!40101 SET @saved_cs_client = @@character_set_client */;
531/*!40101 SET character_set_client = utf8 */;
532CREATE TABLE `quotes` (
533 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
534 `date` date NOT NULL,
535 `hour` time NOT NULL,
536 `additional_information` text COLLATE utf8mb4_unicode_ci,
537 `confirmed` tinyint(1) NOT NULL DEFAULT '0',
538 `calendar_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
539 `sync_date` datetime DEFAULT NULL,
540 `case_id` int(10) unsigned NOT NULL,
541 `videocall_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
542 `job_id` int(11) DEFAULT NULL,
543 `created_at` timestamp NULL DEFAULT NULL,
544 `updated_at` timestamp NULL DEFAULT NULL,
545 PRIMARY KEY (`id`),
546 KEY `quotes_case_id_foreign` (`case_id`),
547 CONSTRAINT `quotes_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `cases` (`id`)
548) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
549/*!40101 SET character_set_client = @saved_cs_client */;
550
551--
552-- Dumping data for table `quotes`
553--
554
555LOCK TABLES `quotes` WRITE;
556/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
557INSERT INTO `quotes` VALUES (1,'2018-01-15','11:45:00',NULL,1,NULL,NULL,1,NULL,1,'2018-01-15 10:21:53','2018-01-15 10:21:53'),(2,'2018-01-31','18:00:00',NULL,1,NULL,NULL,3,NULL,4,'2018-01-25 16:27:30','2018-01-25 16:27:30'),(3,'2018-02-16','13:00:00',NULL,1,NULL,NULL,7,NULL,23,'2018-02-13 08:45:32','2018-02-13 10:17:00'),(4,'2018-02-19','18:00:00','Nueva Cita',1,'u968tqkvr8n3o3ulv6m722qc2k',NULL,8,NULL,43,'2018-02-19 10:54:13','2018-02-19 11:16:13'),(5,'2018-02-19','19:30:00',NULL,1,NULL,NULL,9,NULL,58,'2018-02-19 17:26:40','2018-02-19 17:27:34'),(6,'2018-03-15','10:45:00',NULL,1,NULL,NULL,6,NULL,59,'2018-03-14 11:07:57','2018-03-14 11:07:57'),(7,'2018-05-02','15:25:00',NULL,1,NULL,NULL,4,NULL,62,'2018-05-02 13:24:31','2018-05-02 13:24:31'),(8,'2018-05-09','09:30:00',NULL,1,NULL,NULL,5,NULL,68,'2018-05-02 13:26:24','2018-05-09 07:27:10'),(9,'2018-05-15','16:25:00',NULL,1,NULL,NULL,10,NULL,72,'2018-05-15 14:22:24','2018-05-15 14:22:24');
558/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
559UNLOCK TABLES;
560
561--
562-- Table structure for table `reports`
563--
564
565DROP TABLE IF EXISTS `reports`;
566/*!40101 SET @saved_cs_client = @@character_set_client */;
567/*!40101 SET character_set_client = utf8 */;
568CREATE TABLE `reports` (
569 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
570 `date` datetime DEFAULT NULL,
571 `case_id` int(10) unsigned NOT NULL,
572 `validated` tinyint(1) NOT NULL DEFAULT '0',
573 `url_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
574 `created_at` timestamp NULL DEFAULT NULL,
575 `updated_at` timestamp NULL DEFAULT NULL,
576 PRIMARY KEY (`id`),
577 KEY `reports_case_id_foreign` (`case_id`),
578 CONSTRAINT `reports_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `cases` (`id`)
579) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
580/*!40101 SET character_set_client = @saved_cs_client */;
581
582--
583-- Dumping data for table `reports`
584--
585
586LOCK TABLES `reports` WRITE;
587/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
588INSERT INTO `reports` VALUES (4,NULL,1,0,NULL,'2018-01-15 10:42:51','2018-02-12 14:53:17'),(5,'2018-03-14 11:02:05',9,1,'informe.pdf','2018-03-14 10:01:36','2018-03-14 10:02:10'),(6,'2018-05-29 15:07:55',6,1,'informe.pdf','2018-04-09 06:59:59','2018-05-29 13:08:05');
589/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
590UNLOCK TABLES;
591
592--
593-- Table structure for table `users`
594--
595
596DROP TABLE IF EXISTS `users`;
597/*!40101 SET @saved_cs_client = @@character_set_client */;
598/*!40101 SET character_set_client = utf8 */;
599CREATE TABLE `users` (
600 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
601 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
602 `surname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
603 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
604 `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
605 `admin` tinyint(4) NOT NULL DEFAULT '0',
606 `activated` tinyint(1) NOT NULL DEFAULT '1',
607 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
608 `created_at` timestamp NULL DEFAULT NULL,
609 `updated_at` timestamp NULL DEFAULT NULL,
610 PRIMARY KEY (`id`),
611 UNIQUE KEY `users_email_unique` (`email`)
612) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
613/*!40101 SET character_set_client = @saved_cs_client */;
614
615--
616-- Dumping data for table `users`
617--
618
619LOCK TABLES `users` WRITE;
620/*!40000 ALTER TABLE `users` DISABLE KEYS */;
621INSERT INTO `users` VALUES (1,'John','Doe','doctor@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(2,'Paul','McGregor','paul@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-02-08 15:05:51'),(3,'William','Turner','william@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(4,'Ted','Cooper','ted@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(5,'Tim','Tom','tim@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(6,'Jim','Lorry','jim@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-01-15 10:20:48','2018-01-15 10:20:48'),(8,'Prueba','apellido Editado','aolmedobloonde@gmail.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,'JWUBgZfSDjn96X7sbkYYYCETBkkjp629Aakz4TwyzQEPvTknfEYyBmmno1Gv','2018-01-25 16:24:01','2018-02-12 12:53:07'),(9,'Prueba Editado','Correo','aolmedobenitez@gmail.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-02-09 08:04:37','2018-02-12 12:39:21'),(10,'Prueba eaeaw','apellido eaea','jimedddweewe@email.com','$2y$10$Ur6ecNbZYoRRjQKnh81wOe3niesiflm4.cwzCCY8l96STadDmLqne',0,1,NULL,'2018-02-13 08:45:31','2018-04-19 08:34:24'),(11,'Prueba','apellido','aolmedo@bloonde.com','$2y$10$x/ea.CvPFSv8r18ztggVte6D1F/4SEAmRp4mBt806OG4oNR4B/wDS',0,1,NULL,'2018-05-15 14:21:25','2018-05-15 14:21:57');
622/*!40000 ALTER TABLE `users` ENABLE KEYS */;
623UNLOCK TABLES;
624
625--
626-- Dumping routines for database 'teleanestesia'
627--
628/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
629
630/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
631/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
632/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
633/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
634/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
635/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
636/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
637
638-- Dump completed on 2018-05-29 15:19:03