Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Tema: Implementacion de un Cubo BI con Pentaho
- -- Doc: Creacion de la Base De Datos
- -- Fecha: 09-12-2015
- -- Curso: Bases de Datos 2
- --
- CREATE database `Ultimate_FerreteriaAndres`;
- USE `Ultimate_FerreteriaAndres`;
- CREATE TABLE `table_Cliente` (
- `idCliente` INT NOT NULL,
- `Nombre_Cliente` VARCHAR(45) NOT NULL,
- `Apellido_Cliente` VARCHAR(45) NOT NULL,
- `Cedula_Cliente` DECIMAL(10) NOT NULL,
- PRIMARY KEY (`idCliente`),
- UNIQUE INDEX `idCliente_UNIQUE` (`idCliente` ASC))
- ENGINE = InnoDB;
- CREATE TABLE `table_Vendedor` (
- `idVendedor` INT NOT NULL,
- `nombreVendedor` VARCHAR(55) NOT NULL,
- PRIMARY KEY (`idVendedor`),
- UNIQUE INDEX `idVendedor_UNIQUE` (`idVendedor` ASC))
- ENGINE = InnoDB;
- CREATE TABLE `table_Facturas` (
- `No_Facturas` INT NOT NULL,
- `cliente` INT NOT NULL,
- `fecha` DATE NOT NULL,
- `vendedor` INT NOT NULL,
- `totals` INT NOT NULL,
- PRIMARY KEY (`No_Facturas`),
- UNIQUE INDEX `No_Facturas_UNIQUE` (`No_Facturas` ASC),
- INDEX `llavesForaneas_Vendedor_idx` (`vendedor` ASC),
- INDEX `llavesForaneas_Cliente_idx` (`cliente` ASC),
- CONSTRAINT `llavesForaneas_Vendedor`
- FOREIGN KEY (`vendedor`)
- REFERENCES `Ultimate_FerreteriaAndres`.`table_Vendedor` (`idVendedor`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `llavesForaneas_Cliente`
- FOREIGN KEY (`cliente`)
- REFERENCES `Ultimate_FerreteriaAndres`.`table_Cliente` (`idCliente`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- CREATE TABLE `table_Productos` (
- `idProductos` VARCHAR(45) NOT NULL,
- `nombreProductos` VARCHAR(45) NOT NULL,
- `preciosProductos` INT NOT NULL,
- PRIMARY KEY (`idProductos`),
- UNIQUE INDEX `idtProductos_UNIQUE` (`idProductos` ASC));
- CREATE TABLE `table_Ventas` (
- `idVentas` INT NOT NULL,
- `No_Facturas` INT NOT NULL,
- `Productos` VARCHAR(45) NOT NULL,
- `cantidad` INT NOT NULL,
- `importe` INT NOT NULL,
- PRIMARY KEY (`idVentas`),
- UNIQUE INDEX `idVentas_UNIQUE` (`idVentas` ASC),
- INDEX `llavesForaneas_Facturas_idx` (`No_Facturas` ASC),
- INDEX `llavesForaneas_Productos_idx` (`Productos` ASC),
- CONSTRAINT `llavesForaneas_Facturas`
- FOREIGN KEY (`No_Facturas`)
- REFERENCES `Ultimate_FerreteriaAndres`.`table_Facturas` (`No_Facturas`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `llavesForaneas_Productos`
- FOREIGN KEY (`Productos`)
- REFERENCES `Ultimate_FerreteriaAndres`.`table_Productos` (`idProductos`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement