Database of Auto Car Makes / Models / Years and Part Categories / Brands

Database Description:

This automobiles database is comprised of 152 vehicle / car makes and 3,063 car models by years.

This is also an auto parts categories database with 19 vehicle part categories and 463 sub-categories, in addition to 875 different auto part manufacturer brands.

Basically, this is the skeleton of the Auto Parts DB.

Database Meta:

• Size: 15.3 MB
• Last updated: Mar. 15th, 2011
• Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 9

Buy Now & Download: $49.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• brand

  Records:875

  The table containing all auto part brands.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• brand2subcategory

  Records:8,111

  Manufacturer brands under each part sub-categories.

  Data fields

  1. id: int(11)
  2. brand_id: int(11)
  3. subcategory_id: int(11)

• category

  Records:19

  Top categories of auto parts.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• make

  Records:152

  All auto car makes.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• model

  Records:3,063

  All auto car models, each model is under a make.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. make_id: int(11)

• model2year

  Records:21,777

  Years of a certain car model.

  Data fields

  1. id: int(11)
  2. model_id: int(11)
  3. year: varchar(255)

• model2year2category

  Records:268,738

  Part categories for each model of a certain year.

  Data fields

  1. id: int(11)
  2. model2year_id: int(11)
  3. category_id: int(11)

• subcategory

  Records:463

  All sub-categories of auto parts.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. category_id: int(11)

• year

  Records:110

  Independent table of 110 years that have autos produced.

  Data fields

  1. id: int(11)
  2. title: varchar(255)

Buy Now & Download: $49.95 (USD)

Prospective Applications / Implementations:

• New & used auto parts online shopping store / affiliate site / dealer site
• Aftermarket automobile / automotive related website / wholesale manufacturer
• Automobile repair service site
• Automobile information site / community enhancement
• Auto body parts directory lookup and reference
• ...Order a custom build

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $175)
• Single Table Format (Extra $100)