/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 8.0.31 : Database - jacob
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jacob` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `jacob`;

/*Table structure for table `global_banco` */

DROP TABLE IF EXISTS `global_banco`;

CREATE TABLE `global_banco` (
  `idinstituicao_banco` int DEFAULT NULL,
  `id_banco` int NOT NULL AUTO_INCREMENT,
  `nome_banco` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `codigo_banco` int DEFAULT NULL,
  `agencia_banco` varchar(20) DEFAULT NULL,
  `conta_banco` varchar(20) DEFAULT NULL,
  `sigla_banco` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `site_banco` varbinary(200) DEFAULT NULL,
  `token_banco` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `key_banco` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `access_banco` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `taxa_banco` double(15,2) DEFAULT NULL,
  `andamento_banco` varchar(30) DEFAULT NULL,
  `criacao_banco` timestamp NULL DEFAULT NULL,
  `idcriacao_banco` int DEFAULT NULL,
  `modificacao_banco` timestamp NULL DEFAULT NULL,
  `idmodificao_banco` int DEFAULT NULL,
  `delete_banco` int DEFAULT '0',
  `iddelete_banco` int DEFAULT NULL,
  PRIMARY KEY (`id_banco`),
  KEY `fk_grauinstrucao_banco` (`idinstituicao_banco`),
  CONSTRAINT `fk_grauinstrucao_banco` FOREIGN KEY (`idinstituicao_banco`) REFERENCES `global_instituicao` (`id_instituicao`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;