9ubKg4G4

1-- -----------------------------------------------------
2-- Table `my_schema_1`.`Phone`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `my_schema_1`.`Phone` (
5  `phone_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
6  `vendor_fk` INT UNSIGNED NOT NULL,
7  `ram_fk` INT UNSIGNED NOT NULL,
8  PRIMARY KEY (`phone_id`, `vendor_fk`, `ram_fk`, `vendor_fk`, `ram_fk`),
9  UNIQUE INDEX `phone_id_UNIQUE` (`phone_id` ASC),
10  INDEX `fk_Phone_Vendor_idx` (`vendor_fk` ASC),
11  INDEX `fk_Phone_RAM_idx` (`ram_fk` ASC),
12  CONSTRAINT `fk_Phone_Vendor`
13    FOREIGN KEY (`vendor_fk`)
14    REFERENCES `my_schema_1`.`Vendor` (`vendor_id`)
15    ON DELETE NO ACTION
16    ON UPDATE NO ACTION,
17  CONSTRAINT `fk_Phone_RAM`
18    FOREIGN KEY (`ram_fk`)
19    REFERENCES `my_schema_1`.`RAM` (`ram_id`)
20    ON DELETE NO ACTION
21    ON UPDATE NO ACTION)
22ENGINE = InnoDB