Database of car parts contains 154,958 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,535 model records with model, engine, cc, kw, cylinder, type, year and engine code in each and 1,221 reference number with number 1, number 2 and supplier in each for these car parts. The whole car parts database totally has 12 tables.
| Name | n3_chennan_PA_FR_yiparts_com_part |
|---|---|
| Data | 457.03M (+ 0B) |
| Tables | 12 (+ 0) |
| Columns | 60 (+ 0) |
| Table Rows | 3,484,411 (+ 0) |
| Media | 18.97M (+ 0B) |
| Files | 1,901 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car_part | 154,958 | title |
100%
|
| ref_no |
95.78%
|
||
| model |
100%
|
||
| parameter |
74.82%
|
||
| car_part_x_engine | 1,153,829 | car_part_id |
100%
|
| engine_id |
100%
|
||
| car_part_x_model | 587,710 | car_part_id |
100%
|
| model_id |
100%
|
||
| car_part_x_ref_no | 1,394,916 | 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 | 154,958 | 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.83%
|
||
| ref_no | 1,221 | supplier |
100%
|
| haoma1 |
99.92%
|
||
| haoma2 |
59.54%
|
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 |
