-- 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_schenker_final`
--

DROP TABLE IF EXISTS `ds_schenker_final`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ds_schenker_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=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ds_schenker_final`
--

LOCK TABLES `ds_schenker_final` WRITE;
/*!40000 ALTER TABLE `ds_schenker_final` DISABLE KEYS */;
INSERT INTO `ds_schenker_final` VALUES (13,'ENERO','2021-01-01',22,20,0.5238,NULL,1,16,5,6,14,5.123015873015873,8,5,29,9.165674603174603,42,121.11199999999998,2.8836190476190473),(14,'FEBRERO','2021-02-01',38,7,0.8444,NULL,20,8,10,4,3,1.7,10,5,30,8.549074074074074,45,185.53500000000003,4.123),(15,'MARZO','2021-03-01',28,24,0.5385,NULL,10,10,8,22,2,2.454326923076923,11,6,35,8.924679487179487,52,208.486,4.0093461538461534),(16,'ABRIL','2021-04-01',44,13,0.7719,NULL,13,10,21,7,6,2.2426900584795324,11,6,40,8.203216374269006,57,310.7269999999999,5.451350877192981),(17,'MAYO','2021-05-01',41,12,0.7736,NULL,14,17,11,9,2,1.9591194968553458,6,11,35,7.72248427672956,53,250.45400000000006,4.725547169811322),(18,'JUNIO','2021-06-01',24,5,0.8276,NULL,4,8,12,4,1,2.1436781609195403,4,3,21,10.876436781609195,29,91.96200000000002,3.1711034482758627),(19,'JULIO','2021-07-01',35,6,0.8537,NULL,10,17,8,5,1,1.8089430894308942,6,6,25,8.299796747967479,41,218.92100000000002,5.339536585365854),(20,'AGOSTO','2021-08-01',33,16,0.6735,NULL,6,16,11,6,10,2.41921768707483,9,3,37,9.96343537414966,49,196.76300000000003,4.0155714285714295),(21,'SEPTIEMBRE','2021-09-01',23,10,0.697,NULL,2,15,6,6,4,2.3497474747474745,2,3,26,9.003787878787879,33,165.30200000000002,5.009151515151515),(22,'OCTUBRE','2021-10-01',34,18,0.6538,NULL,8,21,7,7,9,2.3221153846153846,4,16,31,9.076923076923077,52,194.32299999999995,3.7369807692307684),(23,'NOVIEMBRE','2021-11-01',22,9,0.7097,NULL,12,10,0,5,4,1.9811827956989247,8,3,17,7.009408602150537,31,117.76200000000004,3.7987741935483883),(24,'DICIEMBRE','2021-12-01',21,19,0.525,NULL,5,6,10,3,16,4.563541666666667,3,5,28,10.216666666666667,40,220.849,5.521224999999999),(25,'ENERO','2022-01-01',22,19,0.5366,NULL,15,4,3,8,11,2.6971544715447155,3,4,30,9.422764227642277,41,197.35500000000002,4.8135365853658545),(26,'FEBRERO','2022-02-01',13,10,0.5652,NULL,10,1,2,5,5,2.7119565217391304,2,1,17,9.134057971014492,23,115.51400000000001,5.022347826086957),(27,'MARZO','2022-03-01',26,10,0.7222,NULL,9,13,4,6,4,2.0949074074074074,4,3,24,8.597222222222223,36,175.77200000000002,4.882555555555556),(28,'ABRIL','2022-04-01',13,11,0.5417,NULL,7,1,5,3,8,2.904513888888889,3,2,18,9.065972222222223,24,141.76,5.906666666666666),(29,'MAYO','2022-05-01',39,9,0.8125,NULL,16,20,3,1,8,2.0182291666666665,7,7,32,7.043402777777778,48,283.272,5.9014999999999995),(30,'JUNIO','2022-06-01',26,9,0.7429,NULL,6,7,13,3,6,2.3833333333333333,1,4,29,9.463095238095239,35,180.764,5.1646857142857145),(31,'JULIO','2022-07-01',27,11,0.7105,NULL,9,11,8,6,4,2.2653508771929824,3,2,29,10.654605263157896,38,202.49600000000004,5.328842105263159),(32,'AGOSTO','2022-08-01',35,17,0.6731,NULL,12,12,11,15,2,2.2435897435897436,6,5,24,5.920673076923077,52,312.75199999999995,6.014461538461537),(33,'SEPTIEMBRE','2022-09-01',17,16,0.5152,NULL,0,8,9,12,4,3.066919191919192,0,2,27,9.210858585858587,33,162.87699999999995,4.935666666666665),(34,'OCTUBRE','2022-10-01',14,12,0.5385,NULL,5,5,4,7,3,2.219551282051282,1,2,5,2.4615384615384617,26,116.342,4.474692307692307),(35,'NOVIEMBRE','2022-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'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_schenker_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:16:18
