In the car parts database, there are 41,376 records with full part name, part number, description, price, price unit, msrp, msrp unit, save money, save money unit and part name in each by 324 models from 41 brands. These auto cars parts data has 5,776 assemblies; 156 types and from 35 years. In table assembly image, it has 41,376 assembly images in the 44.55M media set. The whole auto car parts data set totally has 13 tables.
| Name | n3_lyz_parts.com |
|---|---|
| Data | 253.28M (+ 146.14M) |
| Tables | 13 (+ 0) |
| Columns | 58 (+ 0) |
| Table Rows | 1,606,215 (+ 0) |
| Media | 44.55M (+ 0B) |
| Files | 3,094 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assembly | 5,776 | assembly |
100%
|
| assembly_image_slug | 3,094 | assembly_id |
100%
|
| brand | 41 | brand |
100%
|
| brand_x_year | 1,133 | brand_id |
100%
|
| year_id |
100%
|
||
| brand_x_year_x_type | 5,134 | type_id |
100%
|
| brand_x_year_id |
100%
|
||
| brand_x_year_x_type_x_model | 10,657 | model_id |
100%
|
| brand_x_year_x_type_id |
100%
|
||
| brand_x_year_x_type_x_model_x_assembly | 190,201 | assembly_id |
100%
|
| brand_x_year_x_type_x_model_id |
100%
|
||
| brand_x_year_x_type_x_model_x_assembly_x_part | 1,348,288 | brand_x_year_x_type_x_model_x_assembly_id |
100%
|
| part_id |
100%
|
||
| model | 324 | model |
100%
|
| part | 41,376 | full_part_name |
100%
|
| part_number |
100%
|
||
| description |
97.39%
|
||
| price |
100%
|
||
| price_unit |
100%
|
||
| msrp |
100%
|
||
| msrp_unit |
100%
|
||
| save_money |
100%
|
||
| save_money_unit |
100%
|
||
| part_name |
97.39%
|
||
| type | 156 | type |
100%
|
| year | 35 | 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
ASSEMBLY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 44.55M | 3,094 |
