META TOPICPARENT |
name="LaptopPreorderSystem" |
Device Table
<-- SyntaxHighlightingPlugin -->
CREATE TABLE IF NOT EXISTS `mydb`.`Device` (
`idUser` INT NULL COMMENT 'CurrentOwner',
`SystemID` VARCHAR(45) NOT NULL,
`DateAquired` DATE NULL,
`Comments` TEXT NULL,
INDEX `fk_Device_User1_idx` (`idUser` ASC),
PRIMARY KEY (`SystemID`),
CONSTRAINT `fk_Device_User1`
FOREIGN KEY (`idUser`)
REFERENCES `mydb`.`User` (`idUser`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Each device has a record\n'
<-- end SyntaxHighlightingPlugin --> |