-- MySQL Script generated by MySQL Workbench

11/22/16 12:29:58
-- Model: New Model Version: 1.0
MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

-- -----------------------------------------------------
-- Company Schema
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Company Schema
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `Company` DEFAULT CHARACTER SET utf8;
USE `Company` ;

-- -----------------------------------------------------
--Table `Company`.`Client`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Client` (
clientId VARCHAR(10) NOT NULL
`Nombre` VARCHAR(20) NULL,
`Apellido` VARCHAR(20) NULL,
`Direccion` VARCHAR(45) NULL,
`Cedula` VARCHAR(10) NULL,
 `Teefono` VARCHAR(10) NULL,
`E-mail` VARCHAR(25) NULL,
PRIMARY KEY (`idCliente`)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Supplier`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Supplier` (
idProvider VARCHAR(10) NOT NULL
`CodigoProvedor` VARCHAR(10) NULL,
`CodigoCiudad` VARCHAR(6) NULL,
`Nombre` VARCHAR(45) NULL,
`Ruc` VARCHAR(13) NULL,
`Direccion` VARCHAR(45) NULL,
`Telefono` VARCHAR(10) NULL,
`E-mail` VARCHAR(25) NULL,
`Producto` VARCHAR(20) NULL,
PRIMARY KEY (`idProveedor`)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Employee`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Employee` (
`idEmpleado` INT NOT NULL,
`Salario` DECIMAL(6) NULL,
`Tipo` VARCHAR(15) NULL,
 PRIMARY KEY (`idEmployee`))
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Business`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Business` (
businessId INT NOT NULL
`Ciudad` VARCHAR(15) NOT NULL,
`Sucursal` VARCHAR(20) NOT NULL,
PRIMARY KEY (`idNegocio`)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Product-Supplier`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Product-Supplier` (
`idProducto` INT NOT NULL,
`Provedor` VARCHAR(45) NULL,
`CodigoArticulo` VARCHAR(45) NULL,
Section VARCHAR(45) NULL,
`NombreArticulo` VARCHAR(45) NULL,
`Ciudad` VARCHAR(45) NULL,
`Precio` VARCHAR(45) NULL,
`Fecha` VARCHAR(45) NULL,
`Importado` VARCHAR(45) NULL,
`PaizOrigen` VARCHAR(45) NULL,
`Iva` VARCHAR(45) NULL,
 `Marca` VARCHAR(45) NULL,
Provider_idProvider VARCHAR(10) NOT NULL
PRIMARY KEY (`idProducto`),
INDEX `fk_Product_Provider_idx` (`Provider_idProvider` ASC),
CONSTRAINT `fk_Product_Supplier`
FOREIGN KEY (`Supplier_idSupplier`)
REFERENCES `Company`.`Provider` (`idProvider`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Client_Phone`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Client_Phone` (
Customer_Phone_ID INT NOT NULL
`telefono celular` VARCHAR(10) NULL,
Fixed phone
Client_idClient VARCHAR(10) NOT NULL
PRIMARY KEY (`idTelefonp_Cliente`),
INDEX `fk_Telefonp_Cliente_Cliente1_idx` (`Cliente_idCliente` ASC),
CONSTRAINT `fk_Telefonp_Cliente_Cliente1`
FOREIGN KEY (`Cliente_idCliente`)
REFERENCES `Company`.`Client` (`idClient`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
Table `Company`.`Processed Product`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Processed Product` (
processedProductId INT NOT NULL
`Nombre Producto` VARCHAR(45) NULL,
`Tipo de Producto` VARCHAR(45) NULL,
`Cantidad Producto` VARCHAR(45) NULL,
Product Price VARCHAR(45) NULL,
`Stock Producto` VARCHAR(45) NULL,
PRIMARY KEY (`processed product id`)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`sales`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`sales` (
Client_idClient VARCHAR(10) NOT NULL
`cliente` VARCHAR(45) NULL,
`Empleado_idEmpleado` INT NOT NULL,
Processed Product_idProcessed Product INT NOT NULL
INDEX `fk_sales_Client1_idx` (`Client_idClient` ASC),
INDEX `fk_sales_Employee1_idx` (`Employee_idEmployee` ASC)
INDEX `fk_sales_Product processed1_idx` (`Product processed_idProduct
processed ASC
CONSTRAINT `fk_sales_Client1`
FOREIGN KEY (`Cliente_idCliente`)
REFERENCES `Company`.`Client` (`clientId`)
ON DELETE NO ACTION
 ON UPDATE NO ACTION,
CONSTRAINT `fk_sales_Employee1`
FOREIGN KEY (`Employee_idEmployee`)
REFERENCES `Company`.`Employee` (`EmployeeId`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_sales_Processed_Product1`
FOREIGN KEY (`Processed product_idProcessed product`)
REFERENCES `Company`.`Processed Product` (`idProcessed Product`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Processed Product Inventory`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Processed Product Inventory` (
Processed Product Inventory ID INT NOT NULL
Product name VARCHAR(45) NULL,
Cantida VARCHAR(45) NULL
Stck VARCHAR(45) NULL
Processed product_idProcessed product INT NOT NULL
PRIMARY KEY (`Processed Product Inventory ID`, `Product`
processed_productId processed
INDEX `fk_Inventory Product Processed_Processed product1_idx` (`Product
processed_productId processed ASC)
CONSTRAINT `fk_Inventory Processed Product_Processed product1`
FOREIGN KEY (`Processed product_idProcessed product`)
REFERENCES `Company`.`Processed Product` (`idProcessed Product`)
 ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
--Table `Company`.`Processed product_has_Processed product`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Processed_Product_has_Product`
processed
Processed product_idProcessed product INT NOT NULL
Processed product_idProcessed product1 INT NOT NULL
Inventory Processed Product_idInventory Processed Product INT NOT NULL
Inventory Product Processed_Product processed_idProcessed product INT
NOT NULL
PRIMARY KEY (`Processed product_idProcessed product`, `Product
processed_product_id processed1`, `Processed Product Inventory_idInventory
Processed Product, Processed Product Inventory_Product
processed_productId processed
INDEX `fk_Processed_Product_has_Processed_Product_Inventory_Prod_idx`
(`Processed Product Inventory_idProcessed Product Inventory` ASC, `Inventory
Processed Product_Processed product_idProcessed product ASC)
CONSTRAINT `fk_Processed Product_has_Processed Product_Inventory`
Produc1`
FOREIGN KEY (`Processed Product Inventory_idProcessed Product
Processed, Processed Product Inventory_Product processed_product_id
processed)
REFERENCES `Company`.`Processed Product Inventory` (`idInventory
Processed Product, Processed Product_idProcessed Product
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
--Table `Company`.`Inventory`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Company`.`Inventory` (
Product-Supplier_productId INT NOT NULL
Product Code VARCHAR(45) NULL
`Fecha Ingreso` VARCHAR(45) NULL,
`Fecha de salida` VARCHAR(45) NULL,
`Stock` VARCHAR(45) NULL,
Processed product_has_Processed product_Processed product_idProduct
processed INT NOT NULL
Processed product_has_Processed product_Processed product_idProduct
processed1 INT NOT NULL,
INDEX `fk_Inventario_Producto-Proveedor1_idx` (`Product-
Supplier_idProduct ASC
PRIMARY KEY (`Processed product_has_Processed product_Product
processed_productId processed`, `Product processed_has_Product
processed_Product processed_productId processed1
CONSTRAINT `fk_Inventory_Product-Supplier1`
FOREIGN KEY (`Product-Supplier_idProduct`)
REFERENCES `Company`.`Product-Supplier` (`idProduct`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Inventory_Processed_Product_has_Product_Processed1`
FOREIGN KEY (`Processed product_has_Processed product_Product
processed_product_id processed, processed_Product processed_has_Product
processed_Product processed_productId processed1
REFERENCES `Company`.`Processed Product_has_Processed Product`
(Processed product_idProcessed product, Processed product_idProcessed
processed1`
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;