chevrolet_catalogs_parts Chevrolet OEM Catalog: 26,642,148 Entries, 80,241 Assemblies

Chevrolet and GM OEM vehicle parts catalog covering series, models, years, systems, assemblies, parts, groupings, and associated assembly imagery. automotive-parts product-catalogs

  • DataBase

README

This automotive parts catalog organizes vehicle applications, assemblies, diagrams, and OEM parts across model series, models, and years. It contains 26,642,148 rows across 18 tables and occupies 4,263,362,560 bytes.

Catalog structure

The vehicle hierarchy begins with serie and model, where each model belongs to a series. Vehicle years are connected to models through a many-to-many relationship. The catalog contains 109 series, 302 models, and 2,024 years. The year table also stores multiple slug components used to identify catalog applications.

Vehicle applications connect to 4,120 systems, which in turn lead to 80,241 assemblies and 37,448 assembly groups. Slug fields such as system._yf_slug, assemble._yf_slug, and assemble_group._yf_slug support catalog navigation and matching.

Parts and images

Parts are associated with model, year, system, assembly, and assembly-group combinations through relationship tables. The primary part table contains 1,181,637 rows, while part_g contains 1,658,557 rows. These tables provide part numbers, codes, descriptions, and quantities; part.part_code is populated for 1,077,375 rows, and part_g.part_code for 1,658,090 rows.

Assembly image references are stored in assemble_images_slug, with 60,343 populated image URLs linked to assemblies. Image metadata is held in assemble_images, which currently contains one row. The related assemble_image_slug table is empty.

Key relationships include:

  • serie → model → model/year applications
  • model/year/system combinations → assemblies and assembly groups
  • assembly applications → parts, part_g records, and image references

The data was created on September 3, 2024.

Database Stats:

Size 3.97G
Tables 18
Columns 73
Rows 26,642,148

Database APIs:

  1. /chevrolet_parts_for_global/ Chevrolet Parts For Global( Series, Year, Model, System, Assemble, Part, Part Number, Image): Auto Parts of Chevrolet brand database with series, year, model, system, assemble, part name, part number, images and so on.
    Main: /main/list/
    Main: /main/assemble_image/