Posts: 220
Name: Baris
|
Welcome to The Best Cars Model Specifications Database
This database is an awesome one which has lots of fields
Here the fields list which it includes:
1) ID
2) BASE PRICE
3) SUBMODEL
4) MAIN MODEL
5) TYPE OF BODY
6) MAXIMUM ltr BOOT SPACE
7) MINIMUM ltf BOOT SPACE
8) DRIVEN WHEELS
9) ENGINE AND TYPE (cc/type)
10) ENGINE POSITION
11) FRONT HEADROOM (mm)
12) FRONT LEGROOM (mm)
13) FUEL TYPE
14) HANDS FREE PHONE
15) HEIGHT (mm)
16) FULL WEIGHT (kg)
17) LENGHT (mm)
18) MAX POWER (BHP/RPM)
19) MAX TORQUE (lbft/rpm)
20) MULTI CD
21) NUMBER OF DOORS
22) NUMBER OF SEATS
23) RDS RADIO
24) REAR HEADROOM (mm)
25) REAR KNEEROOM (mm)
26) SATELLITE NAVIGATION
27) TOWING WEIGHT (kg)
28) TURNING CIRCLE (m)
29) UNIQUE FIT RADIO
30) WIDTH (mm)
31) ACCELERATION 0-60 MPH (secs)
32) TOPSPEED (mph)
33) CO2 RATING (g/km)
34) WARRANTY DURATION
35) PENCE PER MILE
36) SERVICE INTERVALS
37) SERVICING COST 3 YEAR
38) TANK CAPACITY (gallons)
39) CONTRACT HIRE RATE (pcm)
40) INSURANCE QUOTE
As you see, there're 40 different fields.
The database is uptodate and includes the last car models also.
Structure is here:
PHP Code:
CREATE TABLE `cars` (
`id` bigint(20) NOT NULL auto_increment,
`price` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`submodel` text character set utf8 collate utf8 NOT NULL,
`mainmodel` text character set utf8 collate utf8,
`typeofbody` text character set utf8 collate utf8,
`maxbootspace` text character set utf8 collate utf8,
`minbootspace` text character set utf8 collate utf8,
`drivenwheels` text character set utf8 collate utf8,
`engineandtype` text character set utf8 collate utf8,
`engineposition` text character set utf8 collate utf8,
`frontheadroom` text character set utf8 collate utf8,
`frontlegroom` text character set utf8 collate utf8,
`fueltype` text character set utf8 collate utf8,
`handsfreephone` text character set utf8 collate utf8,
`height` text character set utf8 collate utf8,
`kerbweight` text character set utf8 collate utf8,
`lenght` text character set utf8 collate utf8,
`maxpowerbhp2rpm` text character set utf8 collate utf8,
`maxtorquelbft2rpm` text character set utf8 collate utf8,
`multicd` text character set utf8 collate utf8,
`numberofdoors` text character set utf8 collate utf8,
`numberofseats` text character set utf8 collate utf8,
`rdsradio` text character set utf8 collate utf8,
`rearheadroom` text character set utf8 collate utf8,
`rearkneeroom` text character set utf8 collate utf8,
`satellitenavigation` text character set utf8 collate utf8,
`towingweight` text character set utf8 collate utf8,
`turningcircle` text character set utf8 collate utf8,
`uniquefitradio` text character set utf8 collate utf8,
`width` text character set utf8 collate utf8,
`acceleration060mph` text character set utf8 collate utf8,
`topspeed` text character set utf8 collate utf8,
`co2ratingg2km` text character set utf8 collate utf8,
`warranty` text character set utf8 collate utf8,
`pencepermile` text character set utf8 collate utf8,
`serviceintervals` text character set utf8 collate utf8,
`servicingcost3year` text character set utf8 collate utf8,
`tankcapacity` text character set utf8 collate utf8,
`typicalcontracthirerate` text character set utf8 collate utf8,
`insurancequote` text character set utf8 collate utf8,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3355 ;
Code:
INSERT INTO `cars` VALUES (272, '£37,285', '3.2 FSI Quattro S line ', 'Audi A6 5dr avant', 'Estate', '1660', '565', 'Four', '3123/6', 'F', '992', '1060', 'Unleaded', '400', '1463', '1610', '4933', '252/6500', '243/3250', '320', '5', '5', 'standard', '978', '860', '1250', '1900', '11.9', 'TBA', '1855', '7', '155', '257', '3yr/60k + 3yr Paint + 12yr Perforation + 3yr Breakdown', '84.5', '9,000-19,000', '965', '15.4', '739', '670');
Records: 3.354
Price: 49$
Filetype: sql
Regards
|
