SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; CREATE SCHEMA IF NOT EXISTS `ModeloFinanciero` DEFAULT
CHARACTER SET latin1 COLL ATE latin1_swedish_ci ; USE `ModeloFinanciero`; -- ------------------------------------------------------ Table `mydb`.`Branch` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Branch` ( `Branch_name` VARCHAR(20) NOT NULL , `Branch_city` VARCHAR(20) NULL , `Assets` VARCHAR(20) NULL , PRIMARY KEY (`Branch_name`) ) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Loan` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Loan` ( `Loan_number` INT NOT NULL , `amount` DOUBLE NULL , `Branch_Branch_name` VARCHAR(20) NULL , PRIMARY KEY (`Loan_number`) , INDEX `fk_Loan_Branch` (`Branch_Branch_name` ASC) , CONSTRAINT `fk_Loan_Branch` FOREIGN KEY (`Branch_Branch_name` ) REFERENCES `ModeloFinanciero`.`Branch` (`Branch_name` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Account` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Account` ( `Account_number` INT NOT NULL , `Balance` DOUBLE NULL , `Branch_Branch_name` VARCHAR(20) NULL , PRIMARY KEY (`Account_number`) , INDEX `fk_Account_Branch` (`Branch_Branch_name` ASC) , CONSTRAINT `fk_Account_Branch` FOREIGN KEY (`Branch_Branch_name` ) REFERENCES `ModeloFinanciero`.`Branch` (`Branch_name` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Customer` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Customer` ( `Customer_name` VARCHAR(20) NOT NULL , `Cutomer_street` VARCHAR(20) NULL ,
`Customer_city` VARCHAR(20) NULL , PRIMARY KEY (`Customer_name`) ) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Depositer` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Depositer` ( `Account_Account_number` INT NOT NULL , `Customer_Customer_name` VARCHAR(20) NOT NULL , PRIMARY KEY (`Account_Account_number`, `Customer_Customer_name`) , INDEX `fk_Depositer_Account` (`Account_Account_number` ASC) , INDEX `fk_Depositer_Customer` (`Customer_Customer_name` ASC) , `monto` int NULL , CONSTRAINT `fk_Depositer_Account` FOREIGN KEY (`Account_Account_number` ) REFERENCES `ModeloFinanciero`.`Account` (`Account_number` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_Depositer_Customer` FOREIGN KEY (`Customer_Customer_name` ) REFERENCES `ModeloFinanciero`.`Customer` (`Customer_name` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Borrower` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `ModeloFinanciero`.`Borrower` ( `Customer_Customer_name` VARCHAR(20) NOT NULL , `Loan_Loan_number` INT NOT NULL , `monto` int NULL , PRIMARY KEY (`Customer_Customer_name`, `Loan_Loan_number`) , INDEX `fk_Borrower_Customer` (`Customer_Customer_name` ASC) , INDEX `fk_Borrower_Loan` (`Loan_Loan_number` ASC) , CONSTRAINT `fk_Borrower_Customer` FOREIGN KEY (`Customer_Customer_name` ) REFERENCES `ModeloFinanciero`.`Customer` (`Customer_name` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_Borrower_Loan` FOREIGN KEY (`Loan_Loan_number` ) REFERENCES `ModeloFinanciero`.`Loan` (`Loan_number` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;