Product Table

CREATE TABLE IF NOT EXISTS `mydb`.`Product` (
  `idProducts` INT NOT NULL,
  `Name` VARCHAR(45) NULL,
  `Description` TEXT NULL,
  `FeatureSet` VARCHAR(45) NULL,
  `PriceEstimate` DECIMAL(5,2) NULL,
  `Active` TINYINT(1) NULL,
  `Availability` ENUM('InStock','OnOrder','ByOrder','AsAvailable') NULL,
  UNIQUE INDEX `ProductName_UNIQUE` (`Name` ASC))
ENGINE = InnoDB
COMMENT = 'Products that can be ordered.  Some may be inactive\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