There are 12,057 parts of 28,008 cars in this auto parts database. These parts are classified into 32 categories.
Each part record consists of price, category, mpn, sku, vin, placement, color, part number, trivetrain, engine, exterior color and interior color. It has 81,742 image slug records and these car part images keeped in 8.29G media set.
The whole auto parts data set has 6 tables.
| Name | n3_lyz_partslinkent_com |
|---|---|
| Data | 50.58M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 34 (+ 0) |
| Table Rows | 171,859 (+ 0) |
| Media | 8.29G (+ 0B) |
| Files | 69,989 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car | 28,008 | car_model |
100%
|
| uniq |
100%
|
||
| category | 32 | category |
100%
|
| image_slug | 81,742 | part_id |
100%
|
| part | 12,057 | title |
100%
|
| price |
100%
|
||
| category |
100%
|
||
| mpn |
97.41%
|
||
| sku |
100%
|
||
| vin |
88.01%
|
||
| placement |
90.19%
|
||
| color |
83.74%
|
||
| part_number |
73.81%
|
||
| trivetrain |
88.01%
|
||
| engine |
0%
|
||
| exterior_color |
87.99%
|
||
| interior_color |
88.01%
|
||
| part_x_car | 50,020 | part_id |
100%
|
| car_id |
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
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 8.29G | 69,989 |
