This car parts database has 3,880 records with part number and sub assemble part in each. All these parts are for brand Toyota and for the markets of Europe, ASIA, Middle East, Japan, USA. There are 5 tables mostly related to these parts, they are 3,437 assemble records with system; 10 part prices; 3,437 model records with model, serie, modifications and date in each; 73 series and 1,700 systems. It also comes with 100 images of these assemble.
The whole Toyota cars parts data set has 17 tables.
| Name | n3_lyz_toyota.catalogs-parts.com_med |
|---|---|
| Data | 9.67M (+ 1.19M) |
| Tables | 17 (+ 0) |
| Columns | 92 (+ 0) |
| Table Rows | 23,914 (+ 0) |
| Media | 552.77K (+ 0B) |
| Files | 10 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 3,437 | assemble |
100%
|
| system_id |
100%
|
||
| assemble_image_slug | 100 | assemble_id |
100%
|
| model | 277 | model |
100%
|
| serie_id |
100%
|
||
| modifications |
100%
|
||
| date |
100%
|
||
| part | 3,880 | part_number |
100%
|
| sub_assemble_part_id |
100%
|
||
| part_2 | 0 | part_number |
0%
|
| s_sub_assemble_part_id |
0%
|
||
| part_price | 10 | price |
100%
|
| part_x_part_price | 10 | part_id |
100%
|
| part_price_id |
100%
|
||
| s_assemble_image_slug | 0 | sub_assemble_id |
0%
|
| s_sub_assemble_part | 0 | sub_assembly_number |
0%
|
| part_number |
0%
|
||
| sub_assemble_id |
0%
|
||
| s_sub_assemble_part_x_part_2 | 0 | s_sub_assemble_part_id |
0%
|
| part_2_id |
0%
|
||
| serie | 73 | serie |
100%
|
| sub_assemble | 0 | sub_assemble |
0%
|
| assemble_id |
0%
|
||
| sub_assemble_part | 2,066 | sub_assembly_number |
76.38%
|
| part_number |
23.62%
|
||
| assemble_id |
100%
|
||
| sub_assembly_name |
75.17%
|
||
| part_name |
23.62%
|
||
| price |
0.1%
|
||
| sub_model | 10,295 | model_detail |
100%
|
| model_id |
100%
|
||
| system | 1,700 | system |
100%
|
| sub_model_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 |
|---|---|
| 552.77K | 10 |
