cxiw01Nx

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 ;
15-- -----------------------------------------------------
16-- Schema alura
17-- -----------------------------------------------------
18
19-- -----------------------------------------------------
20-- Schema alura
21-- -----------------------------------------------------
22CREATE SCHEMA IF NOT EXISTS `alura` DEFAULT CHARACTER SET utf8 ;
23USE `FinanciamentoImoveis` ;
24
25-- -----------------------------------------------------
26-- Table `FinanciamentoImoveis`.`endereco`
27-- -----------------------------------------------------
28CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`endereco` (
29  `idendereco` INT NOT NULL,
30  `logradouro` VARCHAR(45) NOT NULL,
31  `cep` VARCHAR(45) NOT NULL,
32  `uf` VARCHAR(2) NOT NULL,
33  `cidade` VARCHAR(45) NOT NULL,
34  `bairo` VARCHAR(45) NULL,
35  `complemento` VARCHAR(45) NULL,
36  PRIMARY KEY (`idendereco`))
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table `FinanciamentoImoveis`.`cliente`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`cliente` (
44  `idcliente` INT NOT NULL,
45  `nome` VARCHAR(150) NOT NULL,
46  `cpf` VARCHAR(11) NOT NULL,
47  `rg` VARCHAR(20) NOT NULL,
48  `dataNascimento` DATE NOT NULL,
49  `tipoDePessoa` INT NOT NULL,
50  `email` VARCHAR(100) NULL,
51  `rendaBrutaFamiliar` DECIMAL(10) NOT NULL,
52  `endereco_idendereco` INT NOT NULL,
53  PRIMARY KEY (`idcliente`),
54  INDEX `fk_cliente_endereco_idx` (`endereco_idendereco` ASC),
55  CONSTRAINT `fk_cliente_endereco`
56    FOREIGN KEY (`endereco_idendereco`)
57    REFERENCES `FinanciamentoImoveis`.`endereco` (`idendereco`)
58    ON DELETE NO ACTION
59    ON UPDATE NO ACTION)
60ENGINE = InnoDB;
61
62
63-- -----------------------------------------------------
64-- Table `FinanciamentoImoveis`.`planos`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`planos` (
67  `idplanos` INT NOT NULL,
68  `taxaMinima` DECIMAL(5) NOT NULL,
69  `valorMinimo` DECIMAL(5) NOT NULL,
70  PRIMARY KEY (`idplanos`))
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `FinanciamentoImoveis`.`usuarioSistema`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`usuarioSistema` (
78  `idusuarioSistema` INT NOT NULL,
79  `nome` VARCHAR(150) NOT NULL,
80  `cpf` VARCHAR(11) NOT NULL,
81  `email` VARCHAR(45) NOT NULL,
82  `usuario` VARCHAR(45) NOT NULL,
83  `senha` VARCHAR(64) NOT NULL,
84  `perfil` INT NOT NULL,
85  PRIMARY KEY (`idusuarioSistema`))
86ENGINE = InnoDB;
87
88
89-- -----------------------------------------------------
90-- Table `FinanciamentoImoveis`.`financiamento`
91-- -----------------------------------------------------
92CREATE TABLE IF NOT EXISTS `FinanciamentoImoveis`.`financiamento` (
93  `idfinanciamento` INT NOT NULL,
94  `valorDoImovel` DECIMAL(10) NOT NULL,
95  `entradaDoValor` DECIMAL(10) NOT NULL,
96  `numeroDeParcelas` INT NOT NULL,
97  `valorDasParcelas` DECIMAL(5) NOT NULL,
98  `planos_idplanos` INT NOT NULL,
99  `cliente_idcliente` INT NOT NULL,
100  `usuarioSistema_idusuarioSistema` INT NOT NULL,
101  PRIMARY KEY (`idfinanciamento`),
102  INDEX `fk_financiamento_planos1_idx` (`planos_idplanos` ASC),
103  INDEX `fk_financiamento_cliente1_idx` (`cliente_idcliente` ASC),
104  INDEX `fk_financiamento_usuarioSistema1_idx` (`usuarioSistema_idusuarioSistema` ASC),
105  CONSTRAINT `fk_financiamento_planos1`
106    FOREIGN KEY (`planos_idplanos`)
107    REFERENCES `FinanciamentoImoveis`.`planos` (`idplanos`)
108    ON DELETE NO ACTION
109    ON UPDATE NO ACTION,
110  CONSTRAINT `fk_financiamento_cliente1`
111    FOREIGN KEY (`cliente_idcliente`)
112    REFERENCES `FinanciamentoImoveis`.`cliente` (`idcliente`)
113    ON DELETE NO ACTION
114    ON UPDATE NO ACTION,
115  CONSTRAINT `fk_financiamento_usuarioSistema1`
116    FOREIGN KEY (`usuarioSistema_idusuarioSistema`)
117    REFERENCES `FinanciamentoImoveis`.`usuarioSistema` (`idusuarioSistema`)
118    ON DELETE NO ACTION
119    ON UPDATE NO ACTION)
120ENGINE = InnoDB;
121
122USE `alura` ;
123
124-- -----------------------------------------------------
125-- Table `alura`.`compras`
126-- -----------------------------------------------------
127CREATE TABLE IF NOT EXISTS `alura`.`compras` (
128  `valor` DECIMAL(18,2) NULL DEFAULT NULL,
129  `data` DATE NULL DEFAULT NULL,
130  `observacoes` VARCHAR(255) NULL DEFAULT NULL,
131  `recebida` TINYINT(4) NULL DEFAULT NULL)
132ENGINE = InnoDB
133DEFAULT CHARACTER SET = utf8;
134
135
136SET SQL_MODE=@OLD_SQL_MODE;
137SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
138SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;