The car parts of Subaru data contains 357,703 records with part code, sequence, modification, quantity, date of manufacture from and date of manufacture to in each. There are other 5 tables mostly related with these car parts, they are 270 models with series, year from, year to, body, engine, train, massion, grade and destinat in each; brand with 34 records; 191 assembles; 11 series with brand, year from and year to in each and system with 4 records for these car parts. There are 13 tables in the whole Subaru car parts database.
| Name | n3_lyz_7zap.com_en_cars_subaru |
|---|---|
| Data | 1.14G (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 70 (+ 0) |
| Table Rows | 6,659,836 (+ 0) |
| Media | 54.89M (+ 0B) |
| Files | 4,605 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 191 | assemble |
100%
|
| assemble_image_slug | 4,605 | assemble_id |
100%
|
| brand | 34 | brand |
100%
|
| model | 270 | model |
100%
|
| series_id |
100%
|
||
| year_from |
100%
|
||
| year_to |
100%
|
||
| body |
100%
|
||
| engine |
100%
|
||
| train |
100%
|
||
| massion |
100%
|
||
| grade |
100%
|
||
| destinat |
100%
|
||
| model_x_system | 1,032 | model_id |
100%
|
| system_id |
100%
|
||
| model_x_system_x_assemble | 48,638 | model_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_system_x_assemble_x_sub_assemble | 98,216 | model_x_system_x_assemble_id |
100%
|
| sub_assemble_id |
100%
|
||
| model_x_system_x_assemble_x_sub_assemble_x_part | 6,147,536 | model_x_system_x_assemble_x_sub_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 357,703 | part_code |
100%
|
| sequence |
100%
|
||
| modification |
100%
|
||
| quantity |
100%
|
||
| title |
100%
|
||
| date_of_manufacture_from |
100%
|
||
| date_of_manufacture_to |
100%
|
||
| series | 11 | series |
100%
|
| brand_id |
100%
|
||
| year_form |
100%
|
||
| year_to |
100%
|
||
| sub_assemble | 1,596 | sub_assemble |
99.62%
|
| mark |
100%
|
||
| year_from |
100%
|
||
| year_to |
100%
|
||
| system | 4 | system |
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 |
|---|---|
| 54.89M | 4,605 |
