User Tools

Site Tools


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