124,000 Car, Auto Parts Database with Brands, Makes and Photo Pictures

Database Description:

This package contains 2 distinct auto car parts databases:

1) 124,000 auto parts and 500 categories (2 layers).
2) 117,000 auto parts, 3,000 categories (3 layers), 279 brands, 120 auto makes and over 240,000 automotive parts pictures in .JPG. Each and every auto car part has a thumbnail picture in 2 versions, namely 100px and 200px.

Both of these car parts databases contain information and car parts data organized in multi-layer categories (e.g. Accessory, Air Intake, Body, Body Electrical, Body Mechanical & Trim, Brake, Car Care, Climate Control, Clutch, Cooling System, Driveshaft & Axle, EngineElectrical, Engine Mechanical, Exhaust, Fuel Delivery, Interior Styling, Steering, Suspension, Tires and Wheels, Transmission), brands and car makes.

Prospective Applications / Implementations:

• Automotive parts online shopping store
• Automobile / Automotive related site
• Automobile repair site
• Automobile information site / community enhancement
• Auto parts directory lookup and reference
• ...Order a custom build

Database Meta:

• Size: 94.0 + 802.0 MB
• Last updated: Sep. 19th, 2009
• Available Formats: MySQL 5 SQL text file, CSV for MS Excel
• Tables: 9

phpMyAdmin Screenshots:

Table Details:

• brand (v2)

  Records:279

  Auto car parts brands.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. count: mediumint(9)

• cat1 (v2)

  Records:9

  The primary categories.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

• cat2 (v2)

  Records:146

  The secondary categories, each referenced to table cat1 by the column cat1.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. cat1: smallint(6)

• cat3 (v2)

  Records:2649

  The tertiary categories, each referenced to table cat2 by the column cat2.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. cat2: smallint(6)

• make (v2)

  Records:120

  Singular table of 120 automotive makes.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

• part (v2)

  Records:117125

  Table that contains all the auto parts data. The fields id and brand_slug are combined for the path to the picture of the part.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. description: text
  5. cat3: smallint(6)
  6. brand_slug: varchar(255)
  7. brand: smallint(6)

• cat1 (v1)

  Records:20

  Top categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

• cat2 (v1)

  Records:486

  Second categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. cat1: smallint(6)
  5. count: mediumint(9)

• part (v1)

  Records:124640

  Data table of all the auto parts.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. code: varchar(255)
  5. description: text
  6. cat2: smallint(6)

Purchase: $489.95 (USD)

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 $400)