In the car parts database, there are 151,597 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,889 engines, 23,514 model records with model, engine, cc, kw, cylinder, type, year and engine code in each and 1,222 ref number with number 1, number 2 and supplier in each for these car parts. It has 12 tables in the whole car parts data set.
| Name | n3_chennan_PA_DE_yiparts_com_part |
|---|---|
| Data | 439.30M (+ 0B) |
| Tables | 12 (+ 0) |
| Columns | 60 (+ 0) |
| Table Rows | 3,390,004 (+ 0) |
| Media | 28.75M (+ 0B) |
| Files | 2,897 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car_part | 151,597 | title |
100%
|
| ref_no |
95.73%
|
||
| model |
100%
|
||
| parameter |
75.48%
|
||
| car_part_x_engine | 1,107,864 | car_part_id |
100%
|
| engine_id |
100%
|
||
| car_part_x_model | 566,371 | car_part_id |
100%
|
| model_id |
100%
|
||
| car_part_x_ref_no | 1,374,558 | 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,597 | category_3_id |
100%
|
| car_part_id |
100%
|
||
| engine | 12,889 | value |
100%
|
| model | 23,514 | 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.44%
|
||
| 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 |
|---|---|
| 28.75M | 2,897 |
