This car parts database contains 151,771 records by 3 main types and further into 21 categories. Each car part is comprised of model, parameter and ref number. These main types are engine part, chassis part and body part. There are 12,892 engines, 23,532 model records with model, engine, cc, kw, cylinder, type, year and engine code in each and 1,222 reference number with number 1, number 2 and supplier in each for these car parts. There are 12 tables in the whole car parts API.
| Name | n3_chennan_PA_EN_yiparts_com_part |
|---|---|
| Data | 438.19M (+ 0B) |
| Tables | 12 (+ 0) |
| Columns | 61 (+ 0) |
| Table Rows | 3,394,006 (+ 0) |
| Media | 18.97M (+ 0B) |
| Files | 1,901 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car_part | 151,771 | title |
100%
|
| ref_no |
95.73%
|
||
| model |
100%
|
||
| parameter |
75.49%
|
||
| car_part_x_engine | 1,109,826 | car_part_id |
100%
|
| engine_id |
100%
|
||
| car_part_x_model | 566,930 | car_part_id |
100%
|
| model_id |
100%
|
||
| car_part_x_ref_no | 1,375,670 | car_part_id |
100%
|
| ref_no_id |
100%
|
||
| category_1 | 3 | title |
100%
|
| category_2 | 21 | title |
100%
|
| category_1_id |
100%
|
||
| category_3 | 368 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_3_x_car_part | 151,771 | category_3_id |
100%
|
| car_part_id |
100%
|
||
| engine | 12,892 | value |
100%
|
| model | 23,532 | title |
100%
|
| model |
99.88%
|
||
| engine |
99.88%
|
||
| cc |
99.88%
|
||
| kw |
99.88%
|
||
| cylinder |
99.33%
|
||
| type |
92.21%
|
||
| year |
99.79%
|
||
| engine_code |
11.43%
|
||
| ref_no | 1,222 | changshang |
100%
|
| haoma1 |
99.92%
|
||
| haoma2 |
58.27%
|
||
| supplier |
0%
|
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
CAR_PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 18.97M | 1,901 |
