In this Opel parts database, there are 153,623 records with sequence, part code and quantity in each. It has other 6 tables mostly related with these parts, they are 34 models with type, year from and year to in each; 34 brands; assembles with 12,966 record; system with 28 records and 4 types for these parts. The Opel parts data also comes with 20,803 assemble images in the media set. The whole Opel parts data set has 15 tables in total.
| Name | n3_lyz_7zap.com_en_cars_opel |
|---|---|
| Data | 135.03M (+ 0B) |
| Tables | 15 (+ 0) |
| Columns | 65 (+ 0) |
| Table Rows | 530,599 (+ 0) |
| Media | 3.24G (+ 0B) |
| Files | 20,753 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 12,966 | assemble |
100%
|
| assemble_image_slug | 20,803 | assemble_id |
100%
|
| brand | 34 | brand |
100%
|
| model | 34 | type_id |
100%
|
| model |
100%
|
||
| year_from |
100%
|
||
| year_to |
47.06%
|
||
| model_x_system | 582 | model_id |
100%
|
| system_id |
100%
|
||
| model_x_system_x_assemble | 5,165 | model_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_system_x_assemble_x_part | 50,016 | model_x_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| model_x_system_x_sub_system | 3,220 | model_x_system_id |
100%
|
| sub_system_id |
100%
|
||
| model_x_system_x_sub_system_x_assemble | 31,014 | model_x_system_x_sub_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_system_x_sub_system_x_assemble_x_part | 252,136 | model_x_system_x_sub_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 153,623 | part |
99.93%
|
| sequence |
100%
|
||
| part_code |
96.58%
|
||
| quantity |
99.4%
|
||
| sub_system | 974 | sub_system |
100%
|
| system | 28 | system |
100%
|
| type | 4 | type |
100%
|
| brand_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 |
|---|---|
| 3.24G | 20,753 |
