HhY38t2N

1-- MySQL Script generated by MySQL Workbench
2-- Seg 04 Dez 2017 15:29:12 -02
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Table `endereco`
16-- -----------------------------------------------------
17DROP TABLE IF EXISTS `endereco` ;
18
19CREATE TABLE IF NOT EXISTS `endereco` (
20  `id`  NOT NULL,
21  `numero` (255) NOT NULL,
22  `rua` VARCHAR(45) NULL,
23  `complemento` VARCHAR(45) NULL,
24  PRIMARY KEY (`id`));
25
26
27-- -----------------------------------------------------
28-- Table `cidade`
29-- -----------------------------------------------------
30DROP TABLE IF EXISTS `cidade` ;
31
32CREATE TABLE IF NOT EXISTS `cidade` (
33  `category_id`  NOT NULL,
34  `nome` (255) NOT NULL,
35  PRIMARY KEY (`category_id`));
36
37
38-- -----------------------------------------------------
39-- Table `bairro`
40-- -----------------------------------------------------
41DROP TABLE IF EXISTS `bairro` ;
42
43CREATE TABLE IF NOT EXISTS `bairro` (
44  `category_id`  NOT NULL,
45  `nome` (255) NOT NULL,
46  `endereco_id`  NOT NULL,
47  `cidade_category_id`  NOT NULL,
48  PRIMARY KEY (`category_id`, `endereco_id`, `cidade_category_id`));
49
50
51-- -----------------------------------------------------
52-- Table `category`
53-- -----------------------------------------------------
54DROP TABLE IF EXISTS `category` ;
55
56CREATE TABLE IF NOT EXISTS `category` (
57  `category_id`  NOT NULL,
58  `usuario` (255) NOT NULL,
59  PRIMARY KEY (`category_id`));
60
61
62-- -----------------------------------------------------
63-- Table `endereco_has_category`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `endereco_has_category` ;
66
67CREATE TABLE IF NOT EXISTS `endereco_has_category` (
68  `endereco_id`  NOT NULL,
69  `category_category_id`  NOT NULL,
70  PRIMARY KEY (`endereco_id`, `category_category_id`));
71
72
73SET SQL_MODE=@OLD_SQL_MODE;
74SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
75SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;