User Tools

Site Tools


projects:digikey_partsdb:digikey_leds
CREATE TABLE IF NOT EXISTS `digikey_leds` (
  `DATASHEETS` varchar(255) NOT NULL,
  `IMAGE` varchar(255) NOT NULL,
  `DIGIKEY_PART_NUMBER` varchar(255) NOT NULL,
  `MANUFACTURER_PART_NUMBER` varchar(255) NOT NULL,
  `MANUFACTURER` varchar(255) NOT NULL,
  `DESCRIPTION` varchar(255) NOT NULL,
  `QUANTITY_AVAILABLE` int(11) unsigned NOT NULL,
  `FACTORY_STOCK` int(11) unsigned NOT NULL,
  `UNIT_PRICE_USD` varchar(11) NOT NULL,
  `QTY` int(11) unsigned NOT NULL,
  `MINIMUM_QUANTITY` int(11) unsigned NOT NULL,
  `PACKAGING` varchar(255) NOT NULL,
  `SERIES` varchar(255) NOT NULL,
  `COLOR` varchar(255) NOT NULL,
  `WAVELENGTH_DOMINANT` varchar(255) NOT NULL,
  `WAVELENGTH_PEAK` varchar(255) NOT NULL,
  `MILLICANDELA_RATING` varchar(255) NOT NULL,
  `VOLTAGE_FORWARD_TYP` varchar(255) NOT NULL,
  `CURRENT_TEST` varchar(255) NOT NULL,
  `VIEWING_ANGLE` varchar(255) NOT NULL,
  `LENS_TYPE` varchar(255) NOT NULL,
  `LENS_STYLE_SIZE` varchar(255) NOT NULL,
  `PACKAGE_CASE` varchar(255) NOT NULL,
  `SIZE_DIMENSION` varchar(255) NOT NULL,
  `HEIGHT` varchar(255) NOT NULL,
  `MOUNTING_TYPE` varchar(255) NOT NULL,
  PRIMARY KEY (`DIGIKEY_PART_NUMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
projects/digikey_partsdb/digikey_leds.txt · Last modified: 2013/10/12 11:01 by charliex