In this car parts database, there are 103,195 records of 7 brands. Each record is comprised of description, part, price, mark, star, review count, part number, sub name, fcp euro number, quality, made in and mfg number. There are 7 tables mostly related with these parts, they are 335 assemblies; fit car with 423,828 records; 2,311,199 fit model records with model and content in each; 138,302 OE numbers; 270 part brands with description in each; sub assembly with 2,721 records and 16 systems. This auto parts data also comes with 97,248 images of these parts. The whole car parts api totally has 17 tables.
| Name | n3_lyz_fcpeuro.com |
|---|---|
| Data | 1.08G (+ 784.20M) |
| Tables | 17 (+ 0) |
| Columns | 76 (+ 0) |
| Table Rows | 3,484,001 (+ 0) |
| Media | 7.27G (+ 0B) |
| Files | 96,956 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assembly | 335 | assembly |
100%
|
| brand | 7 | brand |
100%
|
| brand_x_system | 112 | brand_id |
100%
|
| system_id |
100%
|
||
| brand_x_system_x_assembly | 1,626 | brand_x_system_id |
100%
|
| assembly_id |
100%
|
||
| brand_x_system_x_assembly_x_sub_assembly | 8,288 | brand_x_system_x_assembly_id |
100%
|
| sub_assembly_id |
100%
|
||
| brand_x_system_x_assembly_x_sub_assembly_x_part | 115,521 | brand_x_system_x_assembly_x_sub_assembly_id |
100%
|
| part_id |
100%
|
||
| fit_car | 423,828 | car |
100%
|
| part_id |
100%
|
||
| fit_model | 2,311,199 | model |
100%
|
| content |
62.72%
|
||
| fit_car_id |
100%
|
||
| image_slug | 97,248 | part_id |
100%
|
| oe_number | 138,302 | oe_number |
100%
|
| part | 103,195 | description |
79.66%
|
| part |
100%
|
||
| price |
89.57%
|
||
| mark |
20.07%
|
||
| star |
10.8%
|
||
| review_count |
10.8%
|
||
| part_number |
99.85%
|
||
| sub_name |
95.32%
|
||
| fcp_euro_number |
99.85%
|
||
| quality |
99.85%
|
||
| made_in |
21.2%
|
||
| mfg_numerbr |
12.81%
|
||
| part_brand | 270 | part_brand |
100%
|
| description |
77.41%
|
||
| part_x_oe_number | 181,836 | part_id |
100%
|
| oe_number_id |
100%
|
||
| part_x_part_brand | 99,497 | part_id |
100%
|
| part_brand_id |
100%
|
||
| sub_assembly | 2,721 | sub_assembly |
100%
|
| system | 16 | system |
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 |
|---|---|
| 7.27G | 96,956 |
