projects:digikey_partsdb:digikey_leds
This is an old revision of the document!
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.1381600862.txt.gz · Last modified: 2013/10/12 11:01 by charliex