Database car models and modifications

Contains a database dump into MySQL format and is a

a set of tables with a list of brands of cars (including Russian), their models and

modifications. Also specify the data type of the engine, gearbox, drive and years of manufacture.

Data Format: SQL queries to create and populate tables.

Tables:

[Auto_brands] - brand cars (fields id, name)

[Auto_models] - model cars (fields id, name, brand_id)

[Auto_submodels] - (optional) modification of the body and different generation of cars.

If the name field is empty, then for this model there is only one modification.

[Auto_modify] - vehicle modifications. Contains the fields:

id

name - information about CAT, engine size and power.

brand_id, model_id, submodel_id - to communicate with auto_brands, auto_models, auto_submodels

longname - similarly to the field name, but additionally contains information about the modifications

from the table auto_submodels (that´s why is not auto_submodels

necessary tables)

engine_type - type of engine (gasoline / diesel / hybrid)

drive_type - drive (front, rear, complete)

release_from - the start year of release

release_to - end of year issue

In all tables:

Field [url] you can safely remove, as it refers to the description on the website-donor (auto.ru).

The work is not required

Field [updated] contains the date of the update data in the field (in the format of UNIX). It is safe to delete.

Version from 06.2014:

* Fixed bugs and expanded database more relevant and complete data

Manufacturer: 210

Models: 2218 (5143 options generations and modifications)

Modifications: 36162

Version from 04.2014: Records: 31232.