yDyMcGQm

1CREATE TABLE IF NOT EXISTS `QUBQML_CS`.`cylinders` (
2  `cylinder_id` INT NOT NULL AUTO_INCREMENT,
3  `make` INT NOT NULL,
4  `serialNo` VARCHAR(30) NOT NULL,
5  `thread` VARCHAR(10) NOT NULL,
6  `manufactureDate` DATETIME NOT NULL,
7  `usage` INT NOT NULL,
8  `equipment_equipment_id` INT NOT NULL,
9  PRIMARY KEY (`cylinder_id`, `equipment_equipment_id`),
10  INDEX `fk_cylinders_equipment_idx` (`equipment_equipment_id` ASC) VISIBLE,
11  CONSTRAINT `fk_cylinders_equipment`
12    FOREIGN KEY (`equipment_equipment_id`)
13    REFERENCES `QUBQML_CS`.`equipment` (`equipment_id`)
14    ON DELETE NO ACTION
15    ON UPDATE NO ACTION)
16ENGINE = InnoDB;