aq5HQCih

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 divide_despesas
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema divide_despesas
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `divide_despesas` DEFAULT CHARACTER SET utf8 ;
15USE `divide_despesas` ;
16
17-- -----------------------------------------------------
18-- Table `divide_despesas`.`administrador`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `divide_despesas`.`administrador` (
21  `username` VARCHAR(45) NOT NULL,
22  `password` VARCHAR(45) NOT NULL,
23  PRIMARY KEY (`username`))
24ENGINE = InnoDB
25DEFAULT CHARACTER SET = utf8;
26
27
28-- -----------------------------------------------------
29-- Table `divide_despesas`.`morador`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `divide_despesas`.`morador` (
32  `username` VARCHAR(15) NOT NULL,
33  `password` VARCHAR(15) NOT NULL,
34  `nome` VARCHAR(45) NOT NULL,
35  `data_chegada` DATE NOT NULL,
36  `data_saida` DATE NULL,
37  `saldo` DOUBLE UNSIGNED NOT NULL,
38  PRIMARY KEY (`username`))
39ENGINE = InnoDB
40DEFAULT CHARACTER SET = utf8;
41
42
43-- -----------------------------------------------------
44-- Table `divide_despesas`.`despesa`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `divide_despesas`.`despesa` (
47  `id` INT(11) NOT NULL,
48  `info` VARCHAR(45) NOT NULL,
49  `valor` DECIMAL(5,2) UNSIGNED NOT NULL,
50  `data_emissao` DATE NOT NULL,
51  `data_limite` DATE NOT NULL,
52  `data_pagamento` DATE NULL DEFAULT NULL,
53  `tipo` VARCHAR(30) NOT NULL,
54  `morador` VARCHAR(15) NOT NULL,
55  PRIMARY KEY (`id`),
56  INDEX `morador_idx` (`morador` ASC),
57  CONSTRAINT `morador`
58    FOREIGN KEY (`morador`)
59    REFERENCES `divide_despesas`.`morador` (`username`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION)
62ENGINE = InnoDB
63DEFAULT CHARACTER SET = utf8;
64
65
66-- -----------------------------------------------------
67-- Table `divide_despesas`.`quarto`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `divide_despesas`.`quarto` (
70  `id` INT(10) UNSIGNED NOT NULL,
71  `preco` DECIMAL(5,2) UNSIGNED NOT NULL,
72  PRIMARY KEY (`id`))
73ENGINE = InnoDB
74DEFAULT CHARACTER SET = utf8;
75
76
77-- -----------------------------------------------------
78-- Table `divide_despesas`.`moradorquarto`
79-- -----------------------------------------------------
80CREATE TABLE IF NOT EXISTS `divide_despesas`.`moradorquarto` (
81  `quarto` INT(10) UNSIGNED NOT NULL,
82  `morador` VARCHAR(15) NOT NULL,
83  PRIMARY KEY (`quarto`, `morador`),
84  INDEX `quarto_idx` (`quarto` ASC),
85  INDEX `morador_quarto` (`morador` ASC),
86  CONSTRAINT `morador_quarto`
87    FOREIGN KEY (`morador`)
88    REFERENCES `divide_despesas`.`morador` (`username`)
89    ON DELETE NO ACTION
90    ON UPDATE NO ACTION,
91  CONSTRAINT `quarto`
92    FOREIGN KEY (`quarto`)
93    REFERENCES `divide_despesas`.`quarto` (`id`)
94    ON DELETE NO ACTION
95    ON UPDATE NO ACTION)
96ENGINE = InnoDB
97DEFAULT CHARACTER SET = utf8;
98
99
100-- -----------------------------------------------------
101-- Table `divide_despesas`.`senhorio`
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS `divide_despesas`.`senhorio` (
104  `username` VARCHAR(45) NOT NULL,
105  `password` VARCHAR(15) NOT NULL,
106  `nome` VARCHAR(50) NOT NULL,
107  PRIMARY KEY (`username`))
108ENGINE = InnoDB
109DEFAULT CHARACTER SET = utf8;
110
111
112SET SQL_MODE=@OLD_SQL_MODE;
113SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
114SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;