NPfujDpn

1-- Table `Ropa`.`RopaVendida`
2-- -----------------------------------------------------
3CREATE TABLE IF NOT EXISTS `Ropa`.`RopaVendida` (<br/>
4  `claveRopEx` INT NOT NULL,<br/>
5  `No.Cliente1` INT NOT NULL,<br/>
6  `No.Emp` INT NOT NULL,<br/>
7  `FormaPago` VARCHAR(45) NOT NULL,<br/>
8  `Cantidad` VARCHAR(45) NOT NULL,<br/>
9  `PrecioTotal` VARCHAR(45) NOT NULL,<br/>
10  `RopaVendidacol` INT NOT NULL,<br/>
11  INDEX `No.Emp_idx` (`No.Emp` ASC),<br/>
12  INDEX `ClaveRopaExis_idx` (`claveRopEx` ASC),<br/>
13  INDEX `No.Cliente_idx` (`No.Cliente1` ASC),<br/>
14  CONSTRAINT `claveRopEx`<br/>
15    FOREIGN KEY (`claveRopEx`)<br/>
16    REFERENCES `Ropa`.`Exhibicion` (`claveRopExhi`)<br/>
17    ON DELETE NO ACTION<br/>
18    ON UPDATE NO ACTION,<br/>
19  CONSTRAINT `No.Emp`<br/>
20    FOREIGN KEY (`No.Emp`)<br/>
21    REFERENCES `Ropa`.`Vendedor` (`No.EmpVen`)<br/>
22    ON DELETE NO ACTION<br/>
23    ON UPDATE NO ACTION,<br/>
24  CONSTRAINT `No.Cliente1`<br/>
25    FOREIGN KEY (`No.Cliente1`)<br/>
26    REFERENCES `Ropa`.`Cliente` (`No.Cliente`)<br/>
27    ON DELETE NO ACTION<br/>
28    ON UPDATE NO ACTION)<br/>
29ENGINE = InnoDB;<br/>