--
-- Host: localhost    Database: cootrasaravitane_db
-- ------------------------------------------------------


--
-- Table structure for table `accidents`
--

CREATE TABLE `accidents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idmovil` int NOT NULL,
  `idPerson` int NOT NULL,
  `codePerson` varchar(255) NOT NULL,
  `placeAccident` varchar(255) NOT NULL,
  `accidentAddress` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `cause` varchar(255) NOT NULL,
  `idTypeAccidents` int NOT NULL,
  `dateAccident` datetime NOT NULL,
  `idTypeInjuries` int NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idmovil` (`idmovil`),
  KEY `idPerson` (`idPerson`),
  KEY `idTypeAccidents` (`idTypeAccidents`),
  KEY `idTypeInjuries` (`idTypeInjuries`),
  CONSTRAINT `accidents_ibfk_1` FOREIGN KEY (`idmovil`) REFERENCES `moviles` (`idmovil`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `accidents_ibfk_2` FOREIGN KEY (`idPerson`) REFERENCES `personas` (`idpersona`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `accidents_ibfk_3` FOREIGN KEY (`idTypeAccidents`) REFERENCES `types_accidents` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `accidents_ibfk_4` FOREIGN KEY (`idTypeInjuries`) REFERENCES `types_injuries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accidents`
--


--
-- Table structure for table `aspects`
--

CREATE TABLE `aspects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aspects`
--

INSERT INTO `aspects` VALUES (1,'DOCUMENTACIÓN'),(2,'ASPECTOS DE SEGURIDAD ACTIVA '),(3,'ASPECTOS DE SEGURIDAD PASIVA'),(4,'ASPECTOS DE CALIDAD PARA PRESTAR SERVICIO');

--
-- Table structure for table `availability`
--

CREATE TABLE `availability` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `availability`
--

INSERT INTO `availability` VALUES (1,'Libre'),(2,'Ocupado');

--
-- Table structure for table `barrios`
--

CREATE TABLE `barrios` (
  `idbarrio` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `mostrar` tinyint(1) NOT NULL,
  PRIMARY KEY (`idbarrio`),
  UNIQUE KEY `nombre` (`nombre`),
  UNIQUE KEY `nombre_2` (`nombre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `barrios`
--


--
-- Table structure for table `bases`
--

CREATE TABLE `bases` (
  `idbase` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(10) NOT NULL,
  `latitud` varchar(100) NOT NULL,
  `longitud` varchar(100) NOT NULL,
  `descripcion` varchar(50) NOT NULL,
  `maximo` int NOT NULL,
  `showBase` int DEFAULT '1',
  PRIMARY KEY (`idbase`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bases`
--

INSERT INTO `bases` VALUES (1,'1','123123','33123','PARQUE PRINCIPAL',3,1),(2,'2','0','0','TERMINAL DE TRANSPORTES',3,1),(3,'3','0','0','HOSPITAL',3,1),(4,'4','0','0','PARQUE DEL CEMENTERIO-CRA 8 ENTRE CALLE 19 Y 19a',3,1),(5,'5','0','0','PUENTE PRINCIPAL-ENTRE CALLES 9 Y 10',4,1),(6,'6','0','0','PARQUE SANTANDER ESQUINA CALLE 26',3,1),(7,'7','0','0','CRA 7 CON 15-UNIVERSIDAD',3,1),(8,'8','0','0','SENA',3,1),(9,'9','0','0','CLÍNICA SANTA CRUZ DE LA LOMA',3,1),(10,'10','0','0','VILLA OLÍMPICA-CEIBA',3,1),(11,'11','0','0','BELLA ISLA-RELOJ',3,1),(12,'12','0','0','JOSÉ ANTONIO GALÁN-FRENTE A LA ESCUELA',3,1),(13,'13','0','0','COOVIP CARRERA 7 CALLE 27',3,1),(14,'14','0','0','SAN GIL PLAZA',3,1),(15,'15','0','0','UNIVERSIDAD UNISANGIL',3,1);

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `idempresa` int NOT NULL DEFAULT '3',
  `nmovil` varchar(20) NOT NULL,
  `de` varchar(100) NOT NULL,
  `para` varchar(100) NOT NULL,
  `texto` varchar(500) NOT NULL,
  `hora` time NOT NULL,
  `tipo` varchar(10) NOT NULL,
  `mostrar` int NOT NULL DEFAULT '1',
  `fecha` date NOT NULL,
  KEY `hora` (`hora`),
  KEY `mostrar` (`mostrar`),
  KEY `nmovil` (`nmovil`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `chat`
--


--
-- Table structure for table `cola`
--

CREATE TABLE `cola` (
  `idcola` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `idmovil` int NOT NULL,
  `idservicio` int NOT NULL,
  `base` varchar(10) NOT NULL,
  PRIMARY KEY (`idcola`),
  UNIQUE KEY `idmovil` (`idmovil`),
  KEY `idservicio` (`idservicio`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cola`
--


--
-- Table structure for table `datos`
--

CREATE TABLE `datos` (
  `idempresa` int NOT NULL,
  `base_servicio` int DEFAULT NULL,
  `base_recaudo` int DEFAULT NULL,
  `apertura` time DEFAULT NULL,
  `cierre` time DEFAULT NULL,
  `lapso` int DEFAULT NULL,
  `rechazo` int DEFAULT NULL,
  `expulsion` time DEFAULT NULL,
  `findia` time DEFAULT NULL,
  `appTime` int DEFAULT NULL,
  `validateDocuments` int DEFAULT NULL,
  PRIMARY KEY (`idempresa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `datos`
--

INSERT INTO `datos` VALUES (3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);

--
-- Table structure for table `historial`
--

CREATE TABLE `historial` (
  `idhistorial` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `idmovil` int DEFAULT NULL,
  `idpersona` int DEFAULT NULL,
  `fecha` datetime NOT NULL,
  `estado` varchar(100) NOT NULL,
  `novedad` varchar(300) NOT NULL,
  PRIMARY KEY (`idhistorial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `historial`
--


--
-- Table structure for table `llaves`
--

CREATE TABLE `llaves` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `idusuario` int NOT NULL,
  `ip` varchar(20) NOT NULL,
  `activo` int NOT NULL,
  `val` varchar(100) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `val` (`val`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llaves`
--

INSERT INTO `llaves` VALUES (1,3,1,'',0,'2ea78c7d6ef865d51ffa2fe3fbb62687','2019-06-17'),(2,3,1,'',0,'df77ca456d84d41ba086185c9c37e507','2019-06-17');

--
-- Table structure for table `maintenance`
--

CREATE TABLE `maintenance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `idPerson` int NOT NULL,
  `idTypeMaintenance` int NOT NULL,
  `dateMaintenance` date NOT NULL,
  `nameWorkshop` varchar(255) NOT NULL,
  `fix` varchar(255) NOT NULL,
  `dateScheduling` date DEFAULT NULL,
  `evidence` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idMovil` (`idMovil`),
  KEY `idPerson` (`idPerson`),
  KEY `idTypeMaintenance` (`idTypeMaintenance`),
  CONSTRAINT `maintenance_ibfk_1` FOREIGN KEY (`idMovil`) REFERENCES `moviles` (`idmovil`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `maintenance_ibfk_2` FOREIGN KEY (`idPerson`) REFERENCES `personas` (`idpersona`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `maintenance_ibfk_3` FOREIGN KEY (`idTypeMaintenance`) REFERENCES `maintenance_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `maintenance`
--


--
-- Table structure for table `maintenance_type`
--

CREATE TABLE `maintenance_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `maintenance_type`
--

INSERT INTO `maintenance_type` VALUES (1,'Preventido','preventido'),(2,'Correctivo','correctivo');

--
-- Table structure for table `mobile_airconditioning`
--

CREATE TABLE `mobile_airconditioning` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `hasAirConditioning` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idMovil` (`idMovil`),
  CONSTRAINT `mobile_AirConditioning_ibfk_1` FOREIGN KEY (`idMovil`) REFERENCES `moviles` (`idmovil`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mobile_airconditioning`
--


--
-- Table structure for table `mobile_mileage`
--

CREATE TABLE `mobile_mileage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `date` date NOT NULL,
  `mileage` varchar(255) NOT NULL,
  `idPersona` int DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idMovil` (`idMovil`),
  KEY `idPersona` (`idPersona`),
  CONSTRAINT `mobile_mileage_ibfk_1` FOREIGN KEY (`idMovil`) REFERENCES `moviles` (`idmovil`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `mobile_mileage_ibfk_2` FOREIGN KEY (`idPersona`) REFERENCES `personas` (`idpersona`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mobile_mileage`
--


--
-- Table structure for table `mobile_no_tachometer`
--

CREATE TABLE `mobile_no_tachometer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `mileageInitial` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mobile_no_tachometer`
--


--
-- Table structure for table `mobilenews`
--

CREATE TABLE `mobilenews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int DEFAULT NULL,
  `dateInitial` date DEFAULT NULL,
  `dateEnd` date DEFAULT NULL,
  `new` text,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `mobilenews`
--

INSERT INTO `mobilenews` VALUES (1,113,'2025-10-01','2025-10-28','Móvil para uso de la Play Store','2025-10-28 23:03:44',7),(2,113,'2025-10-29','2025-10-29','Prueba de novedad produccion','2025-10-29 15:16:36',7);

--
-- Table structure for table `movil_time_day`
--

CREATE TABLE `movil_time_day` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `idPersona` int NOT NULL,
  `codigo` varchar(100) NOT NULL,
  `date` datetime NOT NULL,
  `hoursWorked` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idMovil` (`idMovil`),
  KEY `idPersona` (`idPersona`),
  CONSTRAINT `movil_time_day_ibfk_1` FOREIGN KEY (`idPersona`) REFERENCES `personas` (`idpersona`),
  CONSTRAINT `movil_time_day_ibfk_2` FOREIGN KEY (`idMovil`) REFERENCES `moviles` (`idmovil`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `movil_time_day`
--


--
-- Table structure for table `movilmicrobus`
--

CREATE TABLE `movilmicrobus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `isMicroBus` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `movilmicrobus`
--


--
-- Table structure for table `pagos`
--

CREATE TABLE `pagos` (
  `idpagos` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `idmovil` int NOT NULL,
  `fecha` date NOT NULL,
  `stotal` int NOT NULL,
  `srecaudo` int NOT NULL,
  `dtotal` int NOT NULL,
  `drecaudo` int NOT NULL,
  `estado` varchar(10) NOT NULL DEFAULT 'Debe',
  `pagado` int NOT NULL DEFAULT '0',
  `ponderado` int NOT NULL,
  PRIMARY KEY (`idpagos`),
  KEY `idmovil` (`idmovil`),
  KEY `fecha` (`fecha`),
  KEY `estado` (`estado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pagos`
--


--
-- Table structure for table `personas`
--

CREATE TABLE `personas` (
  `idpersona` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `nmovil` varchar(20) NOT NULL,
  `finge` varchar(10) NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `cedula` varchar(20) NOT NULL,
  `direccion` varchar(200) DEFAULT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `clave` varchar(100) NOT NULL,
  `idShowMobilePerson` int NOT NULL,
  `hora` time NOT NULL,
  `url` varchar(100) NOT NULL DEFAULT '',
  `tipo` varchar(100) NOT NULL,
  `cumple` date DEFAULT NULL,
  `licencia` varchar(50) NOT NULL,
  `flicencia` date DEFAULT NULL,
  `sangre` varchar(10) NOT NULL,
  `categoria` varchar(10) NOT NULL,
  `codigo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `setsancion` varchar(20) NOT NULL,
  `hisancion` datetime NOT NULL,
  `hfsancion` datetime NOT NULL,
  `conductor` int DEFAULT NULL,
  `fechaExamenesOcupa` date DEFAULT NULL,
  `telFamiliar` varchar(255) DEFAULT NULL,
  `fechaRetiro` date DEFAULT NULL,
  `fechacorporacion` date DEFAULT NULL,
  `userLogindelete` varchar(255) DEFAULT NULL,
  `nomtelfamil` varchar(250) DEFAULT NULL,
  `pdfCedula` varchar(255) DEFAULT NULL,
  `pdfLicense` varchar(255) DEFAULT NULL,
  `pdfExamOcup` varchar(255) DEFAULT NULL,
  `disconnection_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `personwithoutphone` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`idpersona`),
  UNIQUE KEY `cedula` (`cedula`),
  KEY `codigo` (`codigo`),
  KEY `clave` (`clave`),
  KEY `mostrar` (`idShowMobilePerson`),
  CONSTRAINT `idShowMobilePerson` FOREIGN KEY (`idShowMobilePerson`) REFERENCES `show_mobile_person` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=540 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `personas`
--


--
-- Table structure for table `preoperational_answers_audit`
--

CREATE TABLE `preoperational_answers_audit` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idPreoperationalReport` int NOT NULL,
  `idQuestionAspect` int NOT NULL,
  `auditor_id` int NOT NULL,
  `auditor_indicator_id` int NOT NULL,
  `auditor_comments` text,
  `auditor_agreement` text NOT NULL,
  `createdAt` datetime DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `preoperational_answers_audit`
--


--
-- Table structure for table `preoperational_report`
--

CREATE TABLE `preoperational_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `idPerson` int NOT NULL,
  `idQuestionAspect` int NOT NULL,
  `indicator_id` int NOT NULL,
  `createdAt` timestamp NOT NULL,
  `updatedAt` timestamp NOT NULL,
  `auditor_agreement` tinyint(1) DEFAULT NULL,
  `auditor_comments` text,
  PRIMARY KEY (`id`),
  KEY `idMovil` (`idMovil`),
  KEY `idPerson` (`idPerson`),
  KEY `idQuestionAspect` (`idQuestionAspect`),
  KEY `indicator_id` (`indicator_id`),
  CONSTRAINT `preoperational_report_ibfk_1` FOREIGN KEY (`idMovil`) REFERENCES `moviles` (`idmovil`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `preoperational_report_ibfk_2` FOREIGN KEY (`idPerson`) REFERENCES `personas` (`idpersona`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `preoperational_report_ibfk_3` FOREIGN KEY (`idQuestionAspect`) REFERENCES `questions_aspects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `preoperational_report_ibfk_4` FOREIGN KEY (`indicator_id`) REFERENCES `type_indicators` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preoperational_report`
--


--
-- Table structure for table `preoperational_report_temp`
--

CREATE TABLE `preoperational_report_temp` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idMovil` int NOT NULL,
  `idPerson` int NOT NULL,
  `reportDoc` varchar(255) DEFAULT NULL,
  `reportAct` varchar(255) DEFAULT NULL,
  `reportPas` varchar(255) DEFAULT NULL,
  `reportCal` varchar(255) DEFAULT NULL,
  `fechReport` date DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `preoperational_report_temp`
--


--
-- Table structure for table `question_indicator`
--

CREATE TABLE `question_indicator` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idQuestion` int NOT NULL,
  `idIndicator` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idQuestion` (`idQuestion`),
  KEY `idIndicator` (`idIndicator`),
  CONSTRAINT `question_indicator_ibfk_1` FOREIGN KEY (`idQuestion`) REFERENCES `questions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `question_indicator_ibfk_2` FOREIGN KEY (`idIndicator`) REFERENCES `type_indicators` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `question_indicator`
--

INSERT INTO `question_indicator` VALUES (1,1,5),(2,1,6),(3,2,5),(4,2,6),(5,3,5),(6,3,6),(7,4,5),(8,4,6),(9,5,5),(10,5,6),(11,6,5),(12,6,6),(13,7,1),(14,7,2),(15,8,1),(16,8,2),(17,9,1),(18,9,2),(19,10,1),(20,10,2),(21,11,1),(22,11,2),(23,12,1),(24,12,2),(25,13,1),(26,13,2),(27,14,1),(28,14,2),(29,15,1),(30,15,2),(31,16,1),(32,16,2),(33,17,1),(34,17,2),(35,18,1),(36,18,2),(37,19,1),(38,19,2),(39,20,1),(40,20,2),(41,21,1),(42,21,2),(43,22,1),(44,22,2),(45,23,1),(46,23,2),(47,24,1),(48,24,2),(49,25,1),(50,25,2),(51,26,1),(52,26,2),(53,26,3),(54,27,1),(55,27,2),(56,27,3),(57,28,1),(58,28,2),(59,28,3),(60,29,1),(61,29,2),(62,29,3),(63,30,1),(64,30,2),(65,30,3),(66,31,1),(67,31,2),(68,31,3),(69,32,1),(70,32,2),(71,32,3),(72,33,1),(73,33,2),(74,33,3),(75,34,1),(76,34,2),(77,34,3),(78,35,1),(79,35,2),(80,35,3),(81,36,1),(82,36,2),(83,36,3),(84,37,1),(85,37,2),(86,37,3),(87,38,1),(88,38,2),(89,38,3),(90,39,1),(91,39,2),(92,39,3),(93,40,1),(94,40,2),(95,40,3),(96,40,4),(97,41,1),(98,41,2),(99,42,1),(100,42,2),(101,43,1),(102,43,2),(103,44,1),(104,44,2),(105,45,1),(106,45,2),(107,46,1),(108,46,2),(109,47,1),(110,47,2),(111,5,4);

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `questionsName` varchar(255) NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  CONSTRAINT `questions_ibfk_1` FOREIGN KEY (`status`) REFERENCES `status_questions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` VALUES (1,'SOAT',1),(2,'Técnomecnica',1),(3,'Tarjeta de Operación',1),(4,'Tarjeta de Propiedad',1),(5,'Tarjeta de Control o tarjeta Amarilla',1),(6,'Licencia de Conducción',1),(7,'Estado de llantas, profundidad, presión.',1),(8,'Luz de freno-STOP',1),(9,'luces de Tablero',1),(10,'Luces estacionarias',1),(11,'Luces Delanteras (Altas y Bajas)',1),(12,'Luces Direccionales',1),(13,'Luz de Reversa.',1),(14,'Nivel de Aceite',1),(15,'Ajuste de Bornes y Sulfatación de Bornes-Batería',1),(16,'Nivel de liquidos de batería',1),(17,'Nivel de Líquidos de frenos',1),(18,'Freno',1),(19,'Freno de Emergencia (De Mano)',1),(20,'Limpia Parabrisas',1),(21,'Bocina o Pito',1),(22,'Espejos Retrovisores',1),(23,'Vidrio Panorámico',1),(24,'Velocímetro',1),(25,'Transmisión y/o Dirección',1),(26,'Alarma de Reversa',1),(27,'Cámara',1),(28,'Sensor',1),(29,'Extintor (Recargado Último Año)',1),(30,'Triángulos y/o Conos (Mínimo 2)',1),(31,'Tacos (Mínimo dos)',1),(32,'Botiquín primeros auxilios',1),(33,'Gato',1),(34,'Llanta de Repuesto (2.5mm de Labrado)',1),(35,'Cruceta',1),(36,'Cajas de Herramientas Básicas',1),(37,'Linterna',1),(38,'Paleta de Aviso',1),(39,'Cinturones de seguridad (3 puntos de apoyo)',1),(40,'Salida de emergencia (Señalizada)',1),(41,'Estado de Latonería y Pintura',1),(42,'Estado de Sillas y Cojinería',1),(43,'Estado de Ventanas y Puertas',1),(44,'Aseo del Motor',1),(45,'Aseo Exterior e Interior',1),(46,'Presentación personal del conductor',1),(47,'Distintivos',1);

--
-- Table structure for table `questions_aspects`
--

CREATE TABLE `questions_aspects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idAspect` int NOT NULL,
  `idQuestion` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idQuestion` (`idQuestion`),
  KEY `idAspect` (`idAspect`),
  CONSTRAINT `questions_aspects_ibfk_1` FOREIGN KEY (`idQuestion`) REFERENCES `questions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `questions_aspects_ibfk_2` FOREIGN KEY (`idAspect`) REFERENCES `aspects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questions_aspects`
--

INSERT INTO `questions_aspects` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,2,7),(8,2,8),(9,2,9),(10,2,10),(11,2,11),(12,2,12),(13,2,13),(14,2,14),(15,2,15),(16,2,16),(17,2,17),(18,2,18),(19,2,19),(20,2,20),(21,2,21),(22,2,22),(23,2,23),(24,2,24),(25,2,25),(26,2,26),(27,2,27),(28,2,28),(29,3,29),(30,3,30),(31,3,31),(32,3,32),(33,3,33),(34,3,34),(35,3,35),(36,3,36),(37,3,37),(38,3,38),(39,3,39),(40,3,40),(41,4,41),(42,4,42),(43,4,43),(44,4,44),(45,4,45),(46,4,46),(47,4,47);

--
-- Table structure for table `registrousers`
--

CREATE TABLE `registrousers` (
  `fechaEntrada` datetime DEFAULT NULL,
  `fechaSalida` datetime DEFAULT NULL,
  `idregistro` int NOT NULL AUTO_INCREMENT,
  `idusuario` int NOT NULL,
  PRIMARY KEY (`idregistro`),
  KEY `registrousers_FK` (`idusuario`),
  CONSTRAINT `registrousers_FK` FOREIGN KEY (`idusuario`) REFERENCES `usuarios` (`idusuario`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `registrousers`
--


--
-- Table structure for table `servicios`
--

CREATE TABLE `servicios` (
  `idservicio` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL DEFAULT '3',
  `idmovil` int DEFAULT NULL,
  `idpersona` int NOT NULL,
  `idcliente` int DEFAULT NULL,
  `direccion` varchar(1000) NOT NULL,
  `fecha` datetime NOT NULL,
  `idStateService` int NOT NULL,
  `calificacion` int NOT NULL,
  `tipo` varchar(100) DEFAULT NULL,
  `idbarrio` int NOT NULL,
  `motivo` varchar(300) NOT NULL,
  `ponderado` int NOT NULL DEFAULT '1',
  `asignacion` varchar(100) DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `usuario` varchar(50) NOT NULL,
  `accion` varchar(50) NOT NULL,
  `movil` int NOT NULL DEFAULT '0',
  `cliente` varchar(20) NOT NULL DEFAULT '0',
  `tipocli` int NOT NULL DEFAULT '0',
  `send` int NOT NULL DEFAULT '0',
  `latitud` varchar(100) NOT NULL DEFAULT '0',
  `longitud` varchar(100) NOT NULL DEFAULT '0',
  `idbase` int NOT NULL,
  `ignorado` varchar(1) NOT NULL,
  `setfrom` varchar(20) NOT NULL DEFAULT 'operaciones',
  PRIMARY KEY (`idservicio`),
  KEY `idmovil` (`idmovil`),
  KEY `idcliente` (`idcliente`),
  KEY `cliente` (`cliente`),
  KEY `movil` (`movil`),
  KEY `usuario` (`usuario`),
  KEY `hora` (`hora`),
  KEY `asignacion` (`asignacion`),
  KEY `estado` (`idStateService`),
  KEY `fecha` (`fecha`),
  CONSTRAINT `fk_idmovil` FOREIGN KEY (`idmovil`) REFERENCES `moviles` (`idmovil`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `idmovil_fk` FOREIGN KEY (`idmovil`) REFERENCES `moviles` (`idmovil`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `servicios`
--


--
-- Table structure for table `show_mobile_person`
--

CREATE TABLE `show_mobile_person` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `show_mobile_person`
--

INSERT INTO `show_mobile_person` VALUES (1,'Activo'),(2,'Inactivo');

--
-- Table structure for table `state_mobile`
--

CREATE TABLE `state_mobile` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `state_mobile`
--

INSERT INTO `state_mobile` VALUES (1,'Activo'),(2,'Descanso'),(3,'Inactivo');

--
-- Table structure for table `state_service`
--

CREATE TABLE `state_service` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `showState` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `state_service`
--

INSERT INTO `state_service` VALUES (1,'Cancelado',1),(2,'Eliminado',0),(3,'En espera',0),(4,'Finalizado',1),(5,'En proceso',0),(6,'No disponible',1);

--
-- Table structure for table `status_questions`
--

CREATE TABLE `status_questions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status_questions`
--

INSERT INTO `status_questions` VALUES (1,'Activo'),(2,'Inactivo');

--
-- Table structure for table `tarifas`
--

CREATE TABLE `tarifas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `ciudad` varchar(255) NOT NULL,
  `precio` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=399 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tarifas`
--

INSERT INTO `tarifas` VALUES (1,'1','VALOR HORA MOVIL',53500),(4,'4','TRAPICHE',17500),(8,'8','HOTEL TERRAZAS - PROVIVIENDA',12000),(9,'9','CAJASAN GUARIGUA - POSADA CAMPESTRE ',21500),(13,'13','CAJASAN GUARIGUA - SECTOR GUASCA',15500),(14,'14','CONDOMINIO CASTILLA REAL',20500),(15,'15','BARRIO MARSELLA - CENTRO',14000),(16,'16','BARRIO MARSELLA - PERIFERICAS',13700),(17,'17','DOS QUEBRADAS-  POSADA CAMPESTRE',17500),(20,'20','GASAN CABRERA',10500),(21,'21','MARSELLA - CAJASAN PISCINA',22000),(22,'22','LA CORRALEJA VIA AEROPUERTO',9000),(388,'467','HOTEL FONDA EL RETIRO',10000),(24,'24','CANCHA SINTETICA SAN MIGUEL-SAN GIL',10000),(25,'25','CLINICA DE SALUD MENTAL - VILLA MARIA',11000),(26,'26','BARRIO BELLAVISTA',11000),(27,'27','BARRIO BELLAVISTA - EDS  LA ISLA ',13000),(28,'181','IBAGUE',2092000),(29,'500','BARICHARA ',66000),(30,'501',' LOS MEDIOS CABRERA',39500),(31,'502','AEROPUERTO LOS POZOS SAN GIL',43000),(32,'503','RESTAURANTE FOGAO VIA AL 500',27000),(33,'504','ANTENA RCN',56000),(34,'505','CABAÑAS VILLA CAMARGO ',25000),(35,'506','EDS BRISAS DEL LLANO KM 4 VIA AL 500',55000),(36,'507','FINCA HERMANAS VICENTINAS RAMAL FRENTE AL HOTEL MAJAM´S VIA AL 500',26500),(37,'508','BALNEARIO LA LAJA BARICHARA',29000),(38,'509','FINCA CONDOMINIO VILLA ESPERANZA ',26500),(39,'510','FINCA ARCILLAS GUANENTA VIA AL AEROPUERTO',23000),(40,'511','HOTEL ALTA GRACIA',25500),(41,'512','HOTEL MAJAM´S ANTIGUO ALEJANDRIA VIA AL 500',23000),(42,'513','ESCUELA MONTESITOS (VIRGEN LEGUA)',19500),(43,'514','CABRERA ',133500),(44,'515','ESCUELA LA LAJA',48000),(45,'516','RESTAURANTE GOLONDRINO VIA AL 500',20500),(46,'517','RESTAURANTE PORTAL DE GUARIGUA',23000),(47,'518','ESCUELA CHORO ALTO',64000),(48,'519','ESCUELA MONTESITOS BAJO',19500),(49,'520','ESCUELA CHORO BAJO',59500),(50,'521','CHAPALA',61500),(51,'522','EL VOLADOR',55500),(52,'523','LLANO CABRERA',67000),(53,'524','GUANE',96500),(54,'525','EL AVENTINO',24500),(55,'526','ESCUELA OJO DE AGUA',45500),(56,'527','EL COMUN',50000),(57,'528','HOTEL PUERTA DEL SOL',31500),(58,'529','ESCUELA LAS JOYAS',100000),(59,'530','ESCUELA GUAYABAL',41500),(60,'531',' HOTEL SAN JERONIMO',17000),(61,'532','RESTAURANTE LA FLORA',23000),(62,'533','ESCUELA CUCHARO',78500),(63,'534','LADRILLERA BARICHARA',39000),(64,'535','ESCUELA GUARIGUA BAJO',51000),(65,'536','PARAMITO',103000),(66,'537','RESTAURANTE ROCABAR',23000),(67,'538','RESTAURANTE EL MAMÓN',20500),(68,'539','ESCUELA GUARIGUA ALTO',48000),(69,'540','SANTA ELENA (COOPERATIVA)',116000),(70,'541','MACANILLO TELECOM SANGIL',123000),(71,'542','VILLANUEVA',67000),(72,'543','LLANADA VIA CABRERA',101000),(73,'544','ZAPATOCA',667000),(74,'545','CHORO LA YE',41500),(75,'546','ESCUELA LOS POZOS ',48000),(76,'547','ESCUELA REGADERO GUANE',103000),(77,'548','MONTEMALVA',25500),(78,'549','ESCUELA PROMOCION SOCIAL',58500),(79,'567','CANEY ANDINO BARICHARA',43500),(80,'584','CUEVA LA ANTIGUA',19000),(81,'586','PARQUE PEÑON GUANE',15500),(82,'587','CARAQUITAS VIA A BARICHARA',59500),(389,'000','RESTAURANTE PAELLA',11300),(84,'591','CUCHARO CABRERA',73500),(85,'598','GLAMPIN OASIS VIA A BARICHARA',40000),(86,'599','HOSTAL PACHA VIA BARICHARA',41000),(87,'600','ARATOCA ',138000),(88,'601','CAÑAVERAL VIA ARATOCA',82000),(89,'602','EDS LA Y RAMAL VIA AL 616',34500),(90,'603','HOTEL LAS PALMAS (ZAMORANO)',25000),(91,'604','BUCARAMANGA',427000),(92,'605','FINCA LAS VEGAS PROFESORES',26500),(93,'606','CALIZAS DE COLOMBIA',26500),(94,'607','ALTO DE ARATOCA',143000),(95,'608','FINCA ZAMORANO',25500),(96,'609','ALTO ENCINAL',55000),(97,'610','CASA GRANDE',19000),(98,'611','BRIGADIER',76500),(99,'612','CEPITA',331000),(100,'613','FINCA LA AFANADORA',8500),(101,'614','CHIFLAS',171000),(102,'615','BARRANCA',814000),(103,'616','CURITI',40500),(104,'617','EL PLAYON',696500),(105,'618','CUROS',339500),(106,'619','PUERTO WILCHES',983000),(107,'620','FINCA LA PALMITA (BELLA ISLA)',12000),(108,'621','FINCA LOS ALAMOS SUBIENDO EL DERRUMBE VIA A 616',7500),(109,'622','UVO ARATOCA',77500),(110,'623','MESA DE LOS SANTOS',449500),(111,'624','AEROHOTEL VIA A 616',23000),(112,'625','LA TOMA ARATOCA',96500),(113,'626','HOTEL KIMBALA VIA A 616',57500),(114,'627','SABANA DE TORRES',741000),(115,'628','CARTAGENA',2700000),(116,'629','RECODO ARENERA',15000),(117,'630','BARRANQUILLA',3014000),(118,'631','HOTEL UMPALA ANT RUITOQUE VIA A 616',9000),(119,'632','RESTAURANTE MATA DE PLATANO',20500),(120,'633','HOTEL ASTURIAS VIA A 616',20500),(121,'634','PALOBLANCO BAJO',56500),(122,'635','HOTEL DAVILEJAS VIA A 616',13000),(123,'636','PEAJE',40500),(124,'637','HOTEL TERRAZAS',9500),(125,'638','PESCADERITO',59500),(126,'639','LAS VUELTAS CURITI',60500),(127,'640','PESCADERO',294000),(128,'641','HOGAR GERIATRICO VIA A SAN PEDRO',26500),(129,'642','PIEDECUESTA',390000),(130,'643','HOSTAL SANTUARIO PASANDO 616 VIA AL COMUN',50000),(131,'644','RESTAURANTE PEÑA FLOR',13000),(132,'645','HOTEL CAMINO REAL',9500),(133,'646','HOTEL MAREL VIA AL 616',7600),(134,'647','HOTEL EL CONDE DE MONTERREY VIA A 616',7600),(135,'648','UNION CURITI',39000),(136,'649','ZAMORANO ALTO',74500),(137,'650','CIENAGA',2256000),(138,'651','EL JARAL SAN PEDRO',39000),(139,'652','HOTEL DE LA MONTAÑA',10000),(140,'653','HOTEL ACAPULCO VIA A 616',24000),(141,'654','RESTAURANTE DEL MAR',13000),(142,'655','RESTAURANTE EL HACHÓN',80000),(143,'656','RESTAURANTE EUSTAQUIA',15000),(144,'657','ESCUELA ACACIAS',26500),(145,'658','ESCUELA VOLADOR',73500),(146,'659','BALNEARIO POZO AZUL',7500),(147,'660','BALNEARIO LA CULEBRA  (CURITI)',10000),(148,'661','PARQUE PANACHI',237500),(149,'662','CORRONCHOSA',30000),(150,'663','SOL Y SOMBRA',15000),(151,'664','SAN PEDRO',49000),(152,'665','ESCUELA SAN JOSE ',74500),(153,'666','PALOBLANCO ALTO',70000),(154,'667','MEDELLIN',2566000),(155,'668','GALPONES IRAPIRE',119000),(156,'669','HOTEL VERDE MENTA',27000),(157,'670','JORDAN SUBE',307500),(158,'671','HOTEL PORTON DE SANGIL',7600),(159,'672','OCAÑA',1060000),(160,'673','PAMPLONA',878000),(161,'675','PAIPA',718000),(162,'676','PUEBLO ARRECHO',20500),(163,'678','EDS LA PALOBLANCA',18500),(164,'680','AEROPUERTO BUCARAMANGA',505000),(165,'682','BOSCONIA',1869000),(166,'683','SAN ALBERTO',650000),(167,'685','AGUACHICA',856000),(168,'690','PUENTE NACIONAL',493000),(169,'691','LEBRIJA',558000),(170,'694','LAJA ARATOCA',96500),(171,'695','LADRILLERA CURITI',34000),(172,'696','PALMAR CURITI',455000),(173,'697','PEÑA BLANCA',27500),(174,'700','MOGOTES ',119000),(175,'701','SANTA MARTA',2566000),(176,'702','ALTO ESPERANZA',48000),(177,'703','HOYO DE LOS PAJAROS',237500),(178,'704','ANTENA RADIO RELOJ',59000),(179,'705','ESCUELA ALTO DEL ENCINAL VIA AL 700',57500),(180,'706','BAMBU ( MOGOTES)',25500),(181,'707','TUNJA',737000),(182,'708','ESCUELA VERSALLES',36000),(183,'709','CAÑAVERAL VIA A MOGOTES',54000),(184,'710','LADRILLERA VERSALLES',40500),(185,'711','VALLEDUPAR',2344000),(186,'712','ESCUELA CAMPO HERMOSO',57500),(187,'713','VILLA DE LEYVA (ARCABUCO)',538000),(188,'714','ONZAGA',540500),(189,'715','MOTAVITA',632000),(190,'716','PUENTE GOMEZ NIÑO',125000),(191,'717','FINCA HOGAR PASTORIN',15000),(192,'718','RESUMIDERO',79500),(193,'719','CUATRO ESQUINAS',50000),(194,'720','SAN JOAQUIN',407000),(195,'721',' BOQUERON',50000),(196,'722','AFRODITA VIA AL 700',9000),(197,'723','PARQUE PANAVER',78500),(199,'725','BIORGANICOS',77500),(200,'726','ALTO DE SAN SEBASTIAN',112000),(201,'727','BUENOS AIRES ',29000),(202,'728','ARENERA VIA A MOGOTES',103000),(203,'729','HOTEL DOSQUEBRADAS VIA AL 700',9500),(204,'730','CAGUANOQUE',51000),(205,'733','EL TABOR ',48000),(206,'734','PALMAIRE ( MOGOTES)',25000),(207,'735','PALMAIRE PISCINA',26500),(208,'740','HONDA VIA MOGOTES',55500),(209,'746','PITIGUAO',182500),(210,'749','ESCUELA SAN JOSÈ VIA MOGOTES',70000),(211,'783','VEJARANAS ALTO',74500),(212,'790','FUNDACION',2242000),(213,'800','CHARALA',113500),(214,'801','RIACHUELO',241000),(215,'802','BALNEARIO MONAS',32000),(216,'803','EDS LA MIEL VIA AL 836',28000),(217,'804','EDS LAS VEGAS DEL FONCE VIA AL 836',31500),(218,'805','FINCA LA PALESTINA ',34000),(219,'806','FINCA UCC',12500),(220,'807','CINCELADA',238500),(221,'808','COROMORO ',280000),(222,'809','RESTAURANTE LAS ESTERAS 2',17500),(223,'810','VILLAVICENCIO',2308000),(224,'811','EL ALTILLO VALLE',98000),(225,'812','FINCA MARILLAC',19000),(226,'813','YOPAL',2309000),(227,'814','HOTEL POSADA CAMPESTRE',14000),(228,'815','HOTEL SANTA BARBARA  VALLE',71000),(229,'816','HOTEL SAN MARCOS VIA A 836',14000),(230,'817','CASCADAS JUAN CURY    (CHARALA)',59500),(231,'818','HOTEL YARIGUI ( CONVENIO CENTRO) VIA A 836',15500),(232,'819','HOTEL VERANO VIA A 836',14000),(233,'820','MORRO VALLE',79500),(234,'821','ENCINO',301000),(235,'822','PARAMO',67000),(236,'823','HOTEL NATURAL SEA VIA 836',13000),(237,'824','RESTAURANTE PESCA Y COMA',29000),(238,'825','LA PLAYA VIA 836',24000),(239,'826','OCAMONTE',113500),(240,'827','RESTAURANTE MATEGUADUA',17500),(241,'828','PUENTE TIERRA',74500),(242,'829','ESCUELA MORAL VALLE ',56500),(243,'830','AIRES DEL FONCE',15000),(244,'831','ESCUELA VEJARANAS',10000),(245,'832','SANTA RITA ',78500),(246,'833','PUENTE DE ARCO',79500),(247,'834','MONTE BELLO - VALLE',45500),(249,'836','VALLE DE SAN JOSE',39500),(250,'837','CASETA VIA AL VALLE',88000),(251,'839','ALTO DEL VALLE',112000),(252,'840','HOTEL QUINTA DEL MUELLE',27000),(254,'842','FINCA FONDA DEL RETIRO',11500),(255,'843','ARENERA CANOTAJE',27500),(257,'856','PEDREGAL PARAMO',73500),(258,'863','PUENTE PALENQUE',55000),(259,'865','PUENTE GALAN',80500),(260,'871','AGUA FRIA OCAMONTE',69000),(261,'873','ALTO DE OCAMONTE',88000),(262,'874','EL ATILLO VIA AL VALLE ',104000),(263,'889','PUENTE MIRANDA',28500),(264,'892','GALPONES JUAN CURI',125000),(265,'894','VIROLIN',292000),(266,'900','SOCORRO',78500),(267,'901','CONGUAL',39500),(268,'902','ARCABUCO ',491000),(269,'903','FINCA SAN FRANCISCO ',17000),(270,'904','BARAYA',105000),(271,'905','LAS ACACIAS VIA A SOCORRO',31000),(272,'906','BARBOSA ',427000),(273,'907','CUCUTA',1014000),(274,'908','BOGOTA',940000),(275,'909','HOTEL EL ROCIO VIA 950',19300),(276,'910','BOSQUE PINCHOTE',74000),(277,'911','CAI PINCHOTE',74000),(278,'912','CALI',2695000),(279,'913','HOTEL SANTA BARBARA VIA A 950',46500),(280,'914','CHARCA',135500),(281,'915','CALARCA',2279000),(282,'916','CHIQUINQUIRA',57000),(283,'917','ZIPAQUIRA',845000),(284,'918','CONFINES',113500),(285,'919','HOTEL WUASIKI A 950',19000),(286,'920','HOTEL SAN GIL DEL CAMPO VIA A 950',17500),(287,'921','SOGAMOSO',786000),(288,'922','DUITAMA',742000),(289,'923','ESCUELA LA VEGA PINCHOTE',44500),(290,'924','EXPLORER PARQUE - RESTAURANTE',23000),(291,'925','EDS EL LAGO',17000),(292,'926','EDS LA RECTA VIA AL 900',29000),(293,'927','EDS COMUNEROS VIA AL 900',52500),(294,'928','GALAN',307500),(295,'929','GAMBITA',398500),(296,'930','GRANJA CUCHARO',34000),(297,'401',' FINCA CAPELLANIA ',17500),(298,'932','GUAPOTA',182500),(299,'933','PATINODROMO EL JOVITO',39000),(300,'934','FINCA DEL DR DUARTE Ó CASA VASCA',14000),(301,'935','COMUNEROS VIA SOCORRO',45000),(302,'936','FINCA LAS HORTENCIAS ',49000),(303,'937','FINCA LAS ACACIAS VIA AL 900',39000),(304,'938','LLANO GRANDE PINCHOTE',73500),(305,'939','LUCHADERO',51000),(306,'940','MACANILLO SOCORRO',103000),(307,'941','HOTEL CAMPESTRE LA TRINIDAD VIA A 950',14000),(308,'942','MONIQUIRA',493000),(309,'943','FUSAGASUGA',1283000),(310,'944','OLIVAL',182500),(311,'945','BERLIN',60500),(312,'946','CARROCERIA HERNANDEZ',10000),(313,'947','PALMAS DEL SOCORRO',105000),(314,'948','PISCINA VILLA MARCELA (PINCHOTE)',22000),(315,'949','BODEGAS DE POSTOBON PINCHOTE',18500),(316,'950','PINCHOTE',21500),(317,'951','OIBA',140000),(318,'952','RESTAURANTE MI TIERRA LLANERA -PINCHOTE',23600),(319,'953','COOPERATIVA DE PINCHOTE',54000),(320,'954','RAIZON',23000),(321,'955','GUEPSA',338500),(322,'956','RECTA DEL CUCHARO',29000),(323,'957','ESCUELA MACANILLO ',89000),(324,'958','AVIFONCE CUCHARO',29000),(325,'959','TOLOTA (MAS ALLA DE OIBA - OLIVAL- TOLOTA',195000),(326,'960','SANTANA',276000),(327,'961','SORACA',775000),(328,'962','SIMACOTA',118000),(329,'964','GALPONES STA BARBARA PINCHOTE',45500),(330,'965','GALPONES EL BOSQUE',91500),(331,'966','SUAITA',265000),(332,'967','VELEZ',516000),(333,'968','VADO REAL',255000),(334,'970','GUADALUPE',382000),(335,'973','NEIVA',2245000),(336,'980','HATO MUNICIPIO',226000),(337,'981','GARCES',94500),(338,'982','ALTO DE PINCHOTE',68000),(339,'983','ALTO DE GUAPOTA',121000),(340,'C2','HOTEL CAJASAN',14000),(341,'C2P','CAJASAN PISCINA',15000),(342,'M010','AQUA DREAMS',20500),(344,'M012','LA FORTUNA (BARICHARA)',26500),(345,'M4','EL DORADO',26500),(346,'M6','BURBUJAS',20500),(347,'M7','BRISAS',16000),(348,'M8','ARABIA',20500),(349,'M9','BARILOCHE',15000),(350,'PB','PORTOBELLO',7100),(351,'00','ESCUELA PIEDRA DEL SOL',39000),(352,'402',' FINCA DR CARDENAS',35000),(353,'404','FINCA LA CASTAÑETA',19000),(354,'0','LAS HORTENCIAS',49000),(392,'','ALTO DE LA ESPERANZA ',51000),(356,'413',' FINCA TEJA ISABEL',15000),(357,'984','ANTENA COMETA ',20000),(358,'985','ANTENA TV',68000),(359,'01','ESCUELA LA CAÑADA',50000),(360,'E3','ESCUELA LA CHARCA',168500),(361,'0000','CUCHICUTE',95500),(362,'001','LA MESETA',48000),(363,'K16','LA PIÑUELA ',102000),(364,'02','POSADA SANTA CLARA',24000),(365,'0002','PROFONCE ',32000),(366,'0003','SAN ISIDRO ',133500),(367,'0001','LLANITO',40500),(368,'784','REPRESA VIA A PINCHOTE',68500),(369,'L36','VENTOLERO',103000),(371,'002','VALOR HORA ESTATICA',38500),(372,'019','HOTEL POSADA CAMP - PORTAL DEL CONDE',16000),(373,'018','ANTIGUA TALANQUERA ',9400),(374,'003','FINCA LA TRINIDAD',7500),(376,'005','CAJASAN GUARIGUA - J.A.G',17500),(377,'006','HOTEL POSADA CAMP - HOTEL MONCHUELO',15500),(378,'007','HOTEL TERRAZAS - COOVIP',13000),(379,'008','HOTEL TERRAZAS - J.A.G',14000),(381,'010',' HOTE RIELES DE SANTA ANA CAMPESTRE',10000),(382,'011','CASA DEL GALLERO EN EL BELLA ISLA ',9000),(383,'012','CAJASAN GUARIGUA - COOVIP',17500),(384,'013','CAJASAN GUARIGUA - GUASCA ',18500),(387,'229','ESCUELA LOS MANGOS ',56500),(390,'04','CIMITARRA',1000000),(391,'679','CAFE SANTANDER',23000),(393,'301','CERRO DEL VALLE',77500),(394,'302','EL BOLO',51000),(395,'303','EL LLANO BARICHARA',48000),(396,'304','LLANO DE NAVAS',42500),(397,'305','AGUA SEMBRADA',20000),(398,'560','HOUSE TACUARA VIA AL 500',55000);

--
-- Table structure for table `type_indicators`
--

CREATE TABLE `type_indicators` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `type_indicators`
--

INSERT INTO `type_indicators` VALUES (1,'good','Bueno'),(2,'bad','Malo'),(3,'doesnotHave','No tiene'),(4,'doesNotApply','No aplica'),(5,'yes','Si'),(6,'no','No');

--
-- Table structure for table `types_accidents`
--

CREATE TABLE `types_accidents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `types_accidents`
--

INSERT INTO `types_accidents` VALUES (1,'collision','Colisión'),(2,'runOver','Atropello'),(3,'overturning','Volcamiento'),(4,'fire','Incendio');

--
-- Table structure for table `types_injuries`
--

CREATE TABLE `types_injuries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `types_injuries`
--

INSERT INTO `types_injuries` VALUES (1,'materialDamageOnly','Solo Daños Materiales'),(2,'minorInjuries','Heridos Leves'),(3,'seriousInjuries','Heridos Graves'),(4,'death','Muerte');

--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `idusuario` int NOT NULL AUTO_INCREMENT,
  `idempresa` int NOT NULL,
  `nombre` varchar(50) NOT NULL,
  `clave` varchar(100) NOT NULL,
  `estado` varchar(10) NOT NULL,
  `rol` varchar(50) NOT NULL,
  `empresa` varchar(10) NOT NULL,
  `stateUser` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`idusuario`),
  UNIQUE KEY `nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES (1,0,'root','25f9e794323b453885f5181f1b624d0b','open','Administrador','',1);

--
-- Dumping routines for database 'cootrasaravitane_db'
--


