This is a database of Chevrolet cars parts with 1,181,637 records. Each record of part includes pnc, part code & quantity.
Database has total 80,241 assembles, 37,448 assemble groups, 302 models, 109 series and 4,120 systems. It also comes with 87.97K assemble images in the media set.
The whole Chevrolet cars parts database totally has 18 tables.
| Name | n3_lyz_chevrolet_catalogs-partscom_med |
|---|---|
| Data | 4.62G (+ 4.16G) |
| Tables | 18 (+ 0) |
| Columns | 71 (+ 0) |
| Table Rows | 26,642,147 (+ 0) |
| Media | 87.97K (+ 0B) |
| Files | 1 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 80,241 | assemble |
100%
|
| assemble_group | 37,448 | assemble_group |
100%
|
| assemble_image_slug | 0 | system_id |
0%
|
| assemble_images_slug | 60,343 | assemble_id |
100%
|
| model | 302 | model |
100%
|
| serie_id |
100%
|
||
| model_x_year | 2,513 | model_id |
100%
|
| year_id |
100%
|
||
| model_x_year_x_system | 40,956 | model_x_year_id |
100%
|
| system_id |
100%
|
||
| model_x_year_x_system_x_assemble | 702,552 | model_x_year_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_year_x_system_x_assemble_group | 966,252 | model_x_year_x_system_id |
100%
|
| assemble_group_id |
100%
|
||
| model_x_year_x_system_x_assemble_group_x_part_g | 6,525,370 | model_x_year_x_system_x_assemble_group_id |
100%
|
| part_g_id |
100%
|
||
| model_x_year_x_system_x_assemble_x_part | 15,379,723 | model_x_year_x_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 1,181,637 | pnc |
100%
|
| part_code |
91.18%
|
||
| title |
99.96%
|
||
| quantity |
83.67%
|
||
| part_g | 1,658,557 | pnc |
100%
|
| part_code |
99.97%
|
||
| title |
99.96%
|
||
| quantity |
99.15%
|
||
| serie | 109 | serie |
100%
|
| system | 4,120 | system |
100%
|
| year | 2,024 | year |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
ASSEMBLE_IMAGES
| Size (Bytes) | Files |
|---|---|
| 87.97K | 1 |
