Posts: 220
Name: Baris
|
Welcome to The Best Digital Cameras Specifications Database
Please pay attention that there're lots of "new technological features" fields, for example "auto focus", "self timer"...etc. There can be some old digital cameras that don't have these kinds of new technologies, so if you see "n/a" cells in this db, it means that this camera doesn't have this new technology.
This database is an awesome one which has lots of fields!!!
Here the fields list which it includes:
1) ID
2) CAT
3) BRAND
4) MODEL
5) RESOLUTION
6) MAXRESOLUTION
7) SENSOR SIZE
8) SENSOR TYPE
9) OPTICAL ZOOM
10) ZOOM WIDE
11) ZOOM TELE
12) DIGITAL ZOOM
13) AUTO FOCUS
14) MANUEL FOCUS
15) FOCUS RANGE
16) MACRO FOCUS RANGE
17) FLASH MODES
18) STORAGE TYPES
19) ISO RATINGS
20) APERTURE PRIORITY
21) SHUTTER PRIORITY
22) MINIMUM SHUTTER
23) MAXIMUM SHUTTER
24) BUILT-IN FLASH
25) EXTERNAL FLASH
26) METERING
27) EXPOSURE COMPENSATION
28) WHITE BALANCE
29) VIDEO FUNCTION
30) VIDEO SOUND
31) MAXIMUM VIDEO RESOLUTION
32) MINIMUM VIDEO RESOLUTION
33) FRAMES PER SECOND
34) VOICE RECORDING
35) OPTICAL VIEW FINDER
36) ELECTRONIC VIEW FINDER
37) LCD DISPLAY
38) LCD SIZE
39) LCD RESOLUTION
40) SELF TIMER
41) USB
42) VIDEO OUT
43) FIREWIRE
44) BLUETOOTH
45) FILE FORMAT
46) ENERGY
47) WEIGHT
48) SIZES
As you see, there're 48 different fields.
Structure is here:
PHP Code:
CREATE TABLE `site_data` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`brand` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`model` text character set utf8 collate utf8 NOT NULL,
`resolution` text character set utf8 collate utf8,
`maxresolution` text character set utf8 collate utf8,
`minresolution` text character set utf8 collate utf8,
`sensorsize` text character set utf8 collate utf8,
`sensortype` text character set utf8 collate utf8,
`opticalzoom` text character set utf8 collate utf8,
`zoomwide` text character set utf8 collate utf8,
`zoomtele` text character set utf8 collate utf8,
`digitalzoom` text character set utf8 collate utf8,
`autofocus` text character set utf8 collate utf8,
`manuelfocus` text character set utf8 collate utf8,
`focusrange` text character set utf8 collate utf8,
`macrofocusrange` text character set utf8 collate utf8,
`flashmodes` text character set utf8 collate utf8,
`storagetypes` text character set utf8 collate utf8,
`ISOratings` text character set utf8 collate utf8,
`aperturepriority` text character set utf8 collate utf8,
`shutterpriority` text character set utf8 collate utf8,
`minshutter` text character set utf8 collate utf8,
`maxshutter` text character set utf8 collate utf8,
`builtinflash` text character set utf8 collate utf8,
`externalflash` text character set utf8 collate utf8,
`metering` text character set utf8 collate utf8,
`exposurecompensation` text character set utf8 collate utf8,
`whitebalance` text character set utf8 collate utf8,
`videofunction` text character set utf8 collate utf8,
`videosound` text character set utf8 collate utf8,
`maximumvideoresolution` text character set utf8 collate utf8,
`minimumvideoresolution` text character set utf8 collate utf8,
`framespersecond` text character set utf8 collate utf8,
`voicerecording` text character set utf8 collate utf8,
`opticalviewfinder` text character set utf8 collate utf8,
`electronicviewfinder` text character set utf8 collate utf8,
`LCDdisplay` text character set utf8 collate utf8,
`LCDsize` text character set utf8 collate utf8,
`LCDresolution` text character set utf8 collate utf8,
`selftimer` text character set utf8 collate utf8,
`usb` text character set utf8 collate utf8,
`videoout` text character set utf8 collate utf8,
`firewire` text character set utf8 collate utf8,
`bluetooth` text character set utf8 collate utf8,
`fileformat` text character set utf8 collate utf8,
`energy` text character set utf8 collate utf8,
`weight` text character set utf8 collate utf8,
`sizes` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1458 ;
Sample from the db:
PHP Code:
INSERT INTO `site_data` VALUES (6, 'P', 'Panasonic', 'Panasonic Lumix DMC LS60', '6.00 Mpixel', '2816x2112', '640x480', '1/2.5-inch', 'CCD', 'Yes', '35', '105', 'Yes', 'Yes', 'No', '505', '5', 'anti red-eye\nauto\nfill in\noff\nslow flash', 'Secure Digital', 'auto, 100, 200, 400, 800, 1250, 3200', 'No', 'No', '60', '1/2000', 'Yes', 'No', 'multi-segment', '-2EV - +2EV with 1/3EV step', 'auto\ncloudy\ndaylight\nfluorescent\nincandescent\nmanual\nshadow', 'Yes', 'Yes', '848x480', '320x240', '30', 'No', 'No', 'No', 'Yes', '2-inch', '86,000', 'Yes', 'USB 2.0', 'Yes', 'No', 'No', 'JPEG', '2x AA', '135g.', '93.7x62.0x29.7');
Records: 1.457
Price: 49$
Regards
|
