In the car parts database, there are 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 engines with 12,892 records, 23,535 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 13 tables.
| Name | n3_chennan_PA_PY_yiparts_com_part |
|---|---|
| Data | 446.08M (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 62 (+ 0) |
| Table Rows | 3,393,767 (+ 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,603 | car_part_id |
100%
|
| engine_id |
100%
|
||
| car_part_x_model | 566,885 | car_part_id |
100%
|
| model_id |
100%
|
||
| car_part_x_ref_no | 1,375,766 | 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,535 | title |
100%
|
| model |
99.88%
|
||
| engine |
99.88%
|
||
| cc |
99.88%
|
||
| kw |
99.88%
|
||
| cylinder |
99.33%
|
||
| type |
92.19%
|
||
| year |
99.79%
|
||
| engine_code |
11.43%
|
||
| 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 |
