Device Table

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'
Topic revision: r1 - 2013-10-10 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback