YELtm5gx

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema FinanciamentoImoveis
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema FinanciamentoImoveis
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `FinanciamentoImoveis` DEFAULT CHARACTER SET utf8 ;
15USE `FinanciamentoImoveis` ;
16
17-- -----------------------------------------------------
18-- Table `FinanciamentoImoveis`.`endereco`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`endereco` (
21  `idendereco` INT NOT NULL,
22  `logradouro` VARCHAR(45) NOT NULL,
23  `cep` VARCHAR(45) NOT NULL,
24  `uf` VARCHAR(2) NOT NULL,
25  `cidade` VARCHAR(45) NOT NULL,
26  `bairo` VARCHAR(45) NULL,
27  `complemento` VARCHAR(45) NULL,
28  PRIMARY KEY (`idendereco`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `FinanciamentoImoveis`.`cliente`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`cliente` (
36  `idcliente` INT NOT NULL,
37  `nome` VARCHAR(150) NOT NULL,
38  `cpf` VARCHAR(11) NOT NULL,
39  `rg` VARCHAR(20) NOT NULL,
40  `dataNascimento` DATE NOT NULL,
41  `tipoDePessoa` INT NOT NULL,
42  `email` VARCHAR(100) NULL,
43  `rendaBrutaFamiliar` DECIMAL(10) NOT NULL,
44  `endereco_idendereco` INT NOT NULL,
45  PRIMARY KEY (`idcliente`),
46  INDEX `fk_cliente_endereco_idx` (`endereco_idendereco` ASC),
47  CONSTRAINT `fk_cliente_endereco`
48    FOREIGN KEY (`endereco_idendereco`)
49    REFERENCES `FinanciamentoImoveis`.`endereco` (`idendereco`)
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION)
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `FinanciamentoImoveis`.`planos`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`planos` (
59  `idplanos` INT NOT NULL,
60  `taxaMinima` DECIMAL(5) NOT NULL,
61  `valorMinimo` DECIMAL(5) NOT NULL,
62  PRIMARY KEY (`idplanos`))
63ENGINE = InnoDB;
64
65
66-- -----------------------------------------------------
67-- Table `FinanciamentoImoveis`.`usuarioSistema`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`usuarioSistema` (
70  `idusuarioSistema` INT NOT NULL,
71  `nome` VARCHAR(150) NOT NULL,
72  `cpf` VARCHAR(11) NOT NULL,
73  `email` VARCHAR(45) NOT NULL,
74  `usuario` VARCHAR(45) NOT NULL,
75  `senha` VARCHAR(64) NOT NULL,
76  `perfil` INT NOT NULL,
77  PRIMARY KEY (`idusuarioSistema`))
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `FinanciamentoImoveis`.`financiamento`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`financiamento` (
85  `idfinanciamento` INT NOT NULL,
86  `valorDoImovel` DECIMAL(10) NOT NULL,
87  `entradaDoValor` DECIMAL(10) NOT NULL,
88  `numeroDeParcelas` INT NOT NULL,
89  `valorDasParcelas` DECIMAL(5) NOT NULL,
90  `planos_idplanos` INT NOT NULL,
91  `cliente_idcliente` INT NOT NULL,
92  `usuarioSistema_idusuarioSistema` INT NOT NULL,
93  PRIMARY KEY (`idfinanciamento`),
94  INDEX `fk_financiamento_planos1_idx` (`planos_idplanos` ASC),
95  INDEX `fk_financiamento_cliente1_idx` (`cliente_idcliente` ASC),
96  INDEX `fk_financiamento_usuarioSistema1_idx` (`usuarioSistema_idusuarioSistema` ASC),
97  CONSTRAINT `fk_financiamento_planos1`
98    FOREIGN KEY (`planos_idplanos`)
99    REFERENCES `FinanciamentoImoveis`.`planos` (`idplanos`)
100    ON DELETE NO ACTION
101    ON UPDATE NO ACTION,
102  CONSTRAINT `fk_financiamento_cliente1`
103    FOREIGN KEY (`cliente_idcliente`)
104    REFERENCES `FinanciamentoImoveis`.`cliente` (`idcliente`)
105    ON DELETE NO ACTION
106    ON UPDATE NO ACTION,
107  CONSTRAINT `fk_financiamento_usuarioSistema1`
108    FOREIGN KEY (`usuarioSistema_idusuarioSistema`)
109    REFERENCES `FinanciamentoImoveis`.`usuarioSistema` (`idusuarioSistema`)
110    ON DELETE NO ACTION
111    ON UPDATE NO ACTION)
112ENGINE = InnoDB;
113
114
115SET SQL_MODE=@OLD_SQL_MODE;
116SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
117SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;