728,534 Car, Auto Parts Database by Brands, Makes, Models and Years with Photo Images / Pictures

Database Description:

This package is the ultimate auto car parts database with 728,534 vehicle parts in 12 highly structural data tables. You can search or browse parts by:

Category (19) => Subcategory (463) => Brand (875) => Part (728,534)
Make (152) => Model (3,063) => Model+Year (21,777) => Part (728,534)
Make (152) => Model (3,063) => Model+Year (21,777) => Category (19) -> ...

Every auto car part has a thumbnail picture in the part images package with a total of 455,257 part images referenced by part id. Car parts data records in the database are organized by car makes, models, years, categories, subcategories and part brands.

19 top categories of all parts include: Accessory, Air Intake, Body Electrical, Body Mechanical & Trim, Brake, Car Care, Climate Control, Clutch, Cooling System, Driveshaft & Axle, Engine Electrical & Mechanical, Exhaust, Fuel Delivery, Interior Styling, Steering, Suspension, Tires & Wheels, and Transmission.

Database Meta:

• Size: 1332.1 + 1878.8 MB
• Images / Multi-media: 455,257 JPEG image files, 1878.8 MB. File name: images/{part.id}.jpg
• Last updated: Jan. 5th, 2011
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 12

Buy Now & Download: $489.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• brand

  Records:875

  All the car part brands.

  Data fields

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

• brand2subcategory

  Records:8,111

  There are multiple part brands under each part subcategory.

  Data fields

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

• brand2subcategory2part

  Records:729,030

  Part or parts under each brand of a specific subcategory.

  Data fields

  1. id: int(11)
  2. brand2subcategory_id: int(11)
  3. part_id: int(11)

• category

  Records:19

  Top categories of the car parts.

  Data fields

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

• make

  Records:152

  Car makes.

  Data fields

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

• model

  Records:3,063

  There are multiple auto car models under each make.

  Data fields

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

• model2year

  Records:21,777

  Cars of the same model are different by years.

  Data fields

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

• model2year2category

  Records:268,738

  Each model of a specific year has several categories of parts included.

  Data fields

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

• model2year2part

  Records:15,012,595

  Essential reference table for finding parts by make -> model -> year -> part.

  Data fields

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

• part

  Records:728,534

  Parts table containing part numbers, brand, vehicles and years that the part fits.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. brand_id: int(11)
  4. part_number: varchar(255)
  5. description: text
  6. full_description: text
  7. years_vehicles: text

• subcategory

  Records:463

  Part subcategories.

  Data fields

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

• year

  Records:110

  Independent table listing all possible years.

  Data fields

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

Buy Now & Download: $489.95 (USD)

Prospective Applications / Implementations:

• New & used auto parts online shopping store / affiliate 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)