This car parts database has 151,736 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,533 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. The whole car parts data set totally has 12 tables.
| Name | n3_chennan_PA_ES_yiparts_com_part |
|---|---|
| Data | 439.95M (+ 0B) |
| Tables | 12 (+ 0) |
| Columns | 60 (+ 0) |
| Table Rows | 3,393,794 (+ 0) |
| Media | 18.97M (+ 0B) |
| Files | 1,901 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car_part | 151,736 | title |
100%
|
| ref_no |
95.73%
|
||
| model |
100%
|
||
| parameter |
75.48%
|
||
| car_part_x_engine | 1,109,542 | car_part_id |
100%
|
| engine_id |
100%
|
||
| car_part_x_model | 566,908 | car_part_id |
100%
|
| model_id |
100%
|
||
| car_part_x_ref_no | 1,375,833 | 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,736 | category_3_id |
100%
|
| car_part_id |
100%
|
||
| engine | 12,892 | value |
100%
|
| model | 23,533 | title |
100%
|
| model |
99.88%
|
||
| engine |
99.88%
|
||
| cc |
99.88%
|
||
| kw |
99.88%
|
||
| cylinder |
99.32%
|
||
| type |
92.2%
|
||
| year |
99.79%
|
||
| engine_code |
11.42%
|
||
| ref_no | 1,222 | supplier |
100%
|
| haoma1 |
99.92%
|
||
| haoma2 |
58.27%
|
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 |
