CREATE DATABASE  IF NOT EXISTS `portalempleo_data_des` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `portalempleo_data_des`;
-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: SRVDESARROLLO    Database: portalempleo_data_des
-- ------------------------------------------------------
-- Server version	8.0.23

/*!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 `dbo_tribunalvaloracion`
--

DROP TABLE IF EXISTS `dbo_tribunalvaloracion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dbo_tribunalvaloracion` (
  `IdTribunalValoracion` int NOT NULL AUTO_INCREMENT,
  `CodigoConvocatoria` int DEFAULT NULL,
  `CodigoCandidato` int DEFAULT NULL,
  `CodigoTribunalConvocatoria` int DEFAULT NULL,
  `CodigoConvocatoriaRequisito` int DEFAULT NULL,
  `CodigoConvocatoriaMerito` int DEFAULT NULL,
  `Comentario` varchar(350) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Fecha` datetime NOT NULL,
  `Conclusion` varchar(350) COLLATE utf8_bin DEFAULT NULL,
  `Baja` tinyint(1) NOT NULL,
  PRIMARY KEY (`IdTribunalValoracion`),
  KEY `FK_tribunalvaloracion_candidato_idx` (`CodigoCandidato`) /*!80000 INVISIBLE */,
  KEY `FK_tribunalvaloracion_tribunalconvocatoria_idx` (`CodigoTribunalConvocatoria`),
  KEY `FK_tribunalvaloracion_convocatoriarequisito_idx` (`CodigoConvocatoriaRequisito`),
  KEY `FK_tribunalvaloracion_convocatoriamerito_idx` (`CodigoConvocatoriaMerito`),
  KEY `FK_tribunalvaloracion_convocatoria_idx` (`CodigoConvocatoria`),
  CONSTRAINT `FK_tribunalvaloracion_candidato` FOREIGN KEY (`CodigoCandidato`) REFERENCES `dbo_candidato` (`IdCandidato`),
  CONSTRAINT `FK_tribunalvaloracion_convocatoria` FOREIGN KEY (`CodigoConvocatoria`) REFERENCES `dbo_convocatoria` (`IdConvocatoria`),
  CONSTRAINT `FK_tribunalvaloracion_convocatoriamerito` FOREIGN KEY (`CodigoConvocatoriaMerito`) REFERENCES `dbo_convocatoriamerito` (`IdConvocatoriaMerito`),
  CONSTRAINT `FK_tribunalvaloracion_convocatoriarequisito` FOREIGN KEY (`CodigoConvocatoriaRequisito`) REFERENCES `dbo_convocatoriarequisito` (`IdConvocatoriaRequisito`),
  CONSTRAINT `FK_tribunalvaloracion_tribunalconvocatoria` FOREIGN KEY (`CodigoTribunalConvocatoria`) REFERENCES `dbo_tribunalconvocatoria` (`IdTribunalConvocatoria`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dbo_tribunalvaloracion`
--

LOCK TABLES `dbo_tribunalvaloracion` WRITE;
/*!40000 ALTER TABLE `dbo_tribunalvaloracion` DISABLE KEYS */;
INSERT INTO `dbo_tribunalvaloracion` VALUES (3,15,1,39,6,NULL,'Comentario Requisito 1','2021-04-29 08:47:09',NULL,0),(4,15,1,39,NULL,9,'Comentario Merito 1','2021-04-29 08:48:57',NULL,0),(5,15,1,40,6,NULL,'Comentario Requisito 2','2021-04-29 12:03:33',NULL,0),(6,15,3,68,NULL,9,'1234','2021-05-03 10:08:07',NULL,0),(9,15,3,68,NULL,9,'4321','2021-05-03 10:23:34',NULL,0),(10,15,1,68,NULL,9,'Comentario Merito 2','2021-05-03 10:24:04',NULL,0),(11,15,3,68,6,NULL,'111','2021-05-03 10:24:28',NULL,0),(12,15,1,68,6,NULL,'Comentario Requisito 3','2021-05-03 10:24:47',NULL,0),(13,15,3,68,6,NULL,'222','2021-05-03 11:38:29',NULL,0),(14,15,1,68,6,NULL,'Comentario Requisito 4','2021-05-03 11:39:01',NULL,0),(15,14,1,2,6,NULL,'aaa','2021-05-03 11:54:43',NULL,0),(16,14,1,2,6,NULL,'bbbb','2021-05-03 12:06:41',NULL,0),(17,15,1,68,NULL,9,'Comentario Merito 3','2021-05-03 12:40:16',NULL,0),(18,15,1,68,7,NULL,'Valoracion A','2021-05-03 13:23:00',NULL,0);
/*!40000 ALTER TABLE `dbo_tribunalvaloracion` 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 2021-05-06 14:13:06