-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_impo
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!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 */;
/*!50503 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 `ds_nac_usi_final`
--

DROP TABLE IF EXISTS `ds_nac_usi_final`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ds_nac_usi_final` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `periodo` varchar(45) DEFAULT NULL,
  `mes` date DEFAULT NULL,
  `kpi_si` int(11) DEFAULT NULL,
  `kpi_no` int(11) DEFAULT NULL,
  `kpi_cumplimiento` double DEFAULT NULL,
  `kpi_objetivo` double DEFAULT NULL,
  `desconsolidacion_hasta_24h` int(11) DEFAULT NULL,
  `desconsolidacion_entre_24h_y_48h` int(11) DEFAULT NULL,
  `desconsolidacion_entre_48h_y_72h` int(11) DEFAULT NULL,
  `desconsolidacion_entre_72h_y_96h` int(11) DEFAULT NULL,
  `desconsol_arriba_de_96h` int(11) DEFAULT NULL,
  `desconsol_promedio_dias` double DEFAULT NULL,
  `salida_hasta_96h_4dias` int(11) DEFAULT NULL,
  `salida_entre_96h_y_144h_5_6dias` int(11) DEFAULT NULL,
  `salida_arriba_de_144h_7dias` int(11) DEFAULT NULL,
  `salida_promedio_dias` double DEFAULT NULL,
  `embarques` int(11) DEFAULT NULL,
  `volumen` double DEFAULT NULL,
  `promedio` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ds_nac_usi_final`
--

LOCK TABLES `ds_nac_usi_final` WRITE;
/*!40000 ALTER TABLE `ds_nac_usi_final` DISABLE KEYS */;
INSERT INTO `ds_nac_usi_final` VALUES (1,'ENERO','2021-01-01',21,12,0.6364,0.7,5,7,10,5,6,2.9305555555555554,10,17,6,4.536616161616162,33,231.71899999999994,7.021787878787877),(2,'FEBRERO','2021-02-01',14,17,0.4516,0.7,1,11,2,8,9,2.9086021505376345,8,7,16,5.834677419354839,31,204.337,6.591516129032258),(3,'MARZO','2021-03-01',26,2,0.9286,0.7,3,13,10,1,1,1.9970238095238095,4,9,15,6.434523809523809,28,185.732,6.633285714285714),(4,'ABRIL','2021-04-01',23,8,0.7419,0.75,8,10,6,5,2,1.907258064516129,11,12,8,4.986559139784946,31,184.979,5.9670645161290325),(5,'MAYO','2021-05-01',19,10,0.6552,0.75,5,4,11,7,2,2.535919540229885,11,13,5,4.847701149425287,29,234.41799999999998,8.083379310344826),(6,'JUNIO','2021-06-01',25,17,0.5952,0.75,7,9,9,6,11,2.698412698412698,12,20,9,4.597222222222222,42,272.704,6.4929523809523815),(7,'JULIO','2021-07-01',34,10,0.7727,0.8,7,6,21,6,4,2.428030303030303,18,18,8,4.761363636363636,44,313.445,7.12375),(8,'AGOSTO','2021-08-01',31,17,0.6458,0.8,1,16,14,12,5,2.6597222222222223,21,19,8,4.440104166666667,48,318.7,6.639583333333333),(9,'SEPTIEMBRE','2021-09-01',17,29,0.3696,0.8,0,12,5,10,19,3.4393115942028984,8,14,24,5.942934782608695,46,389.00200000000007,8.456565217391306),(10,'OCTUBRE','2021-10-01',18,16,0.5294,0.75,1,11,7,10,3,2.545343137254902,16,4,12,7.080882352941177,34,245.25800000000004,7.213470588235295),(11,'NOVIEMBRE','2021-11-01',22,23,0.4889,0.75,2,9,11,3,20,3.9583333333333335,5,2,38,17.418518518518518,45,291.16700000000003,6.470377777777778),(12,'DICIEMBRE','2021-12-01',11,43,0.2037,0.75,2,7,2,15,28,4.320216049382716,4,3,37,11.925925925925926,54,480.3209999999998,8.89483333333333),(13,'ENERO','2022-01-01',16,32,0.3333,NULL,2,4,11,16,15,3.613715277777778,6,4,38,15.946180555555555,48,309.569,6.449354166666667),(14,'FEBRERO','2022-02-01',37,22,0.6271,NULL,7,23,7,0,22,3.464689265536723,4,5,47,9.876412429378531,59,406.0000000000001,6.881355932203392),(15,'MARZO','2022-03-01',11,15,0.4231,NULL,1,1,9,7,8,3.5368589743589745,10,2,4,3.4855769230769234,26,135.326,5.2048461538461535),(16,'ABRIL','2022-04-01',19,39,0.3276,NULL,6,6,7,24,15,3.15948275862069,19,24,6,4.13433908045977,58,349.1969999999999,6.02063793103448),(17,'MAYO','2022-05-01',25,8,0.7576,NULL,1,14,10,5,3,2.342171717171717,6,15,12,5.763888888888889,33,154.78699999999998,4.690515151515151),(18,'JUNIO','2022-06-01',14,9,0.6087,NULL,2,2,10,5,4,2.903985507246377,1,3,18,7.08695652173913,23,91.558,3.9807826086956526),(19,'JULIO','2022-07-01',1,0,1,NULL,0,0,1,0,0,2.1666666666666665,0,0,1,14.166666666666666,1,7.73,7.73),(20,'AGOSTO','2022-08-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'SEPTIEMBRE','2022-09-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'OCTUBRE','2022-10-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'NOVIEMBRE','2022-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'DICIEMBRE','2022-12-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ds_nac_usi_final` 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 2025-07-25 20:17:39
