· 6 years ago · May 30, 2019, 12:26 AM
1-- MySQL Script generated by MySQL Workbench
2-- Wed May 29 21:11:39 2019
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema dbdelivery
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema dbdelivery
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `dbdelivery` DEFAULT CHARACTER SET utf8 ;
18USE `dbdelivery` ;
19
20-- -----------------------------------------------------
21-- Table `dbdelivery`.`tbl_usuario`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_usuario` (
24 `usu_id` INT NOT NULL AUTO_INCREMENT,
25 `usu_nome` VARCHAR(255) NOT NULL,
26 `usu_login` VARCHAR(45) NOT NULL,
27 `usu_senha` VARCHAR(100) NOT NULL,
28 PRIMARY KEY (`usu_id`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `dbdelivery`.`tbl_cliente`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_cliente` (
36 `cli_id` INT NOT NULL AUTO_INCREMENT,
37 `cli_telefone` VARCHAR(15) NOT NULL,
38 `cli_nome` VARCHAR(255) NULL,
39 `cli_cpf_cnpj` VARCHAR(20) NULL,
40 `cli_email` VARCHAR(45) NULL,
41 `cli_observacao` VARCHAR(255) NULL,
42 `cli_endereco` VARCHAR(255) NOT NULL,
43 `cli_numero` VARCHAR(10) NOT NULL,
44 `cli_complemento` VARCHAR(20) NULL,
45 `cli_bairro` VARCHAR(255) NOT NULL,
46 `cli_cidade` VARCHAR(255) NOT NULL,
47 `cli_estado` VARCHAR(2) NOT NULL,
48 `cli_cep` VARCHAR(10) NULL,
49 `cli_taxa_entrega` DECIMAL(25,2) NULL,
50 PRIMARY KEY (`cli_id`))
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `dbdelivery`.`tbl_status_pedido`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_status_pedido` (
58 `sta_ped_id` INT NOT NULL,
59 `sta_ped_descricao` VARCHAR(100) NULL,
60 PRIMARY KEY (`sta_ped_id`))
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `dbdelivery`.`tbl_pagamento`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_pagamento` (
68 `pag_id_int` INT NOT NULL AUTO_INCREMENT,
69 `pag_descricao` VARCHAR(100) NULL,
70 PRIMARY KEY (`pag_id_int`))
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `dbdelivery`.`tbl_pedido`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_pedido` (
78 `ped_id` INT NOT NULL AUTO_INCREMENT,
79 `ped_data` DATE NOT NULL,
80 `ped_valor_produto` DECIMAL(25,2) NOT NULL,
81 `ped_desconto` DECIMAL(25,2) NULL,
82 `ped_cli_id` INT NOT NULL,
83 `ped_sta_ped_id` INT NOT NULL,
84 `ped_pag_id` INT NOT NULL,
85 `ped_usu_id` INT NOT NULL,
86 PRIMARY KEY (`ped_id`, `ped_cli_id`, `ped_sta_ped_id`, `ped_pag_id`, `ped_usu_id`),
87 INDEX `fk_tbl_pedido_tbl_cliente_idx` (`ped_cli_id` ASC) VISIBLE,
88 INDEX `fk_tbl_pedido_tbl_status_pedido1_idx` (`ped_sta_ped_id` ASC) VISIBLE,
89 INDEX `fk_tbl_pedido_tbl_pagamento1_idx` (`ped_pag_id` ASC) VISIBLE,
90 INDEX `fk_tbl_pedido_tbl_usuario1_idx` (`ped_usu_id` ASC) VISIBLE,
91 CONSTRAINT `fk_tbl_pedido_tbl_cliente`
92 FOREIGN KEY (`ped_cli_id`)
93 REFERENCES `dbdelivery`.`tbl_cliente` (`cli_id`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION,
96 CONSTRAINT `fk_tbl_pedido_tbl_status_pedido1`
97 FOREIGN KEY (`ped_sta_ped_id`)
98 REFERENCES `dbdelivery`.`tbl_status_pedido` (`sta_ped_id`)
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION,
101 CONSTRAINT `fk_tbl_pedido_tbl_pagamento1`
102 FOREIGN KEY (`ped_pag_id`)
103 REFERENCES `dbdelivery`.`tbl_pagamento` (`pag_id_int`)
104 ON DELETE NO ACTION
105 ON UPDATE NO ACTION,
106 CONSTRAINT `fk_tbl_pedido_tbl_usuario1`
107 FOREIGN KEY (`ped_usu_id`)
108 REFERENCES `dbdelivery`.`tbl_usuario` (`usu_id`)
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION)
111ENGINE = InnoDB;
112
113
114-- -----------------------------------------------------
115-- Table `dbdelivery`.`tbl_produto`
116-- -----------------------------------------------------
117CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_produto` (
118 `pro_id` INT NOT NULL AUTO_INCREMENT,
119 `pro_nome` VARCHAR(100) NOT NULL,
120 `pro_valor_custo` DECIMAL(25,2) NULL,
121 `pro_valor_venda` DECIMAL(25,2) NOT NULL,
122 `tbl_produtocol` VARCHAR(45) NULL,
123 `pro_estoque` INT(11) NOT NULL,
124 PRIMARY KEY (`pro_id`))
125ENGINE = InnoDB;
126
127
128-- -----------------------------------------------------
129-- Table `dbdelivery`.`tbl_produtos_pedido`
130-- -----------------------------------------------------
131CREATE TABLE IF NOT EXISTS `dbdelivery`.`tbl_produtos_pedido` (
132 `pr_pe_id` INT NOT NULL AUTO_INCREMENT,
133 `pro_ped_valor` DECIMAL(25,2) NOT NULL,
134 `pro_ped_quantidade` INT NOT NULL,
135 `pro_ped_ped_id` INT NOT NULL,
136 `` INT NOT NULL,
137 `pro_ped_pro_id` INT NOT NULL,
138 PRIMARY KEY (`pr_pe_id`, `pro_ped_ped_id`, ``, `pro_ped_pro_id`),
139 INDEX `fk_tbl_produtos_pedido_tbl_pedido1_idx` (`pro_ped_ped_id` ASC, `` ASC) VISIBLE,
140 INDEX `fk_tbl_produtos_pedido_tbl_produto1_idx` (`pro_ped_pro_id` ASC) VISIBLE,
141 CONSTRAINT `fk_tbl_produtos_pedido_tbl_pedido1`
142 FOREIGN KEY (`pro_ped_ped_id` , ``)
143 REFERENCES `dbdelivery`.`tbl_pedido` (`ped_id` , `ped_cli_id`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION,
146 CONSTRAINT `fk_tbl_produtos_pedido_tbl_produto1`
147 FOREIGN KEY (`pro_ped_pro_id`)
148 REFERENCES `dbdelivery`.`tbl_produto` (`pro_id`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB;
152
153
154SET SQL_MODE=@OLD_SQL_MODE;
155SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
156SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;