In the car parts database, there are 566 parts with part code and part name in each for Toyota and for the markets of Japan, USA, Europe. In table part detail, it has 53 records with pnc sub, oem part no, no, required per car, production period, name, applicability and price in each for these parts.
Besides, there are 5 tables mostly related to these parts, they are 1,657 assemble records with system and code in each; 135 models; 244 complectation records with frame, engine, production period, body, grade, transm and option in each; 1,060 frame records with model and 200 systems. It also has 107 images of these assemble in the data.
The whole Toyota car parts data set has 12 tables.
| Name | n3_lyz_toyota_epc_jp |
|---|---|
| Data | 1.48M (+ 32K) |
| Tables | 12 (+ 0) |
| Columns | 73 (+ 0) |
| Table Rows | 4,817 (+ 0) |
| Media | 1.87M (+ 0B) |
| Files | 50 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 1,657 | assemble |
100%
|
| system_id |
100%
|
||
| code |
100%
|
||
| assemble_c | 60 | assemble_name |
100%
|
| assemble_code |
100%
|
||
| assemble_image_slug | 107 | assemble_id |
100%
|
| assemble_x_assemble_c | 169 | assemble_id |
100%
|
| assemble_c_id |
100%
|
||
| assemble_x_part | 566 | assemble_id |
100%
|
| part_id |
100%
|
||
| complectation | 244 | complectation |
100%
|
| frame_id |
100%
|
||
| engine |
100%
|
||
| production_period |
100%
|
||
| body |
18.44%
|
||
| grade |
59.43%
|
||
| transm |
58.61%
|
||
| option |
93.85%
|
||
| frame | 1,060 | frame |
100%
|
| model_id |
100%
|
||
| model | 135 | model |
100%
|
| part | 566 | part_code |
100%
|
| part_name |
100%
|
||
| part_detail | 53 | pnc_sub |
100%
|
| oem_part_no |
100%
|
||
| part_id |
100%
|
||
| no |
96.23%
|
||
| required_per_car |
100%
|
||
| production_period |
96.23%
|
||
| name |
96.23%
|
||
| applicability |
92.45%
|
||
| price |
100%
|
||
| system | 200 | system |
100%
|
| complectation_id |
100%
|
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
ASSEMBLE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.87M | 50 |
