In this car parts data, there are 336,850 records with sequence, part code, quantity, note and mark in each. There are 6 tables mostly related with these parts, they are 1,946 models with series in each; brand with 34 records; assembles with 192,675 records; series with 169 records; system with 43 records and 14 regions. The auto parts data also contains 208,827 assemble images in the 112.89K media set. The whole car parts database totally has 13 tables.
| Name | n3_lyz_7zap.com_en_cars_model |
|---|---|
| Data | 1.26G (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 59 (+ 0) |
| Table Rows | 7,442,218 (+ 0) |
| Media | 7.06G (+ 0B) |
| Files | 50,638 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 192,675 | assemble |
100%
|
| assemble_image_slug | 208,827 | assemble_id |
100%
|
| brand | 34 | brand |
100%
|
| model | 1,946 | series_id |
100%
|
| model |
100%
|
||
| model_x_region | 2,908 | model_id |
100%
|
| region_id |
100%
|
||
| model_x_region_x_system | 101,846 | model_x_region_id |
100%
|
| system_id |
100%
|
||
| model_x_region_x_system_x_assemble | 455,253 | model_x_region_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_region_x_system_x_assemble_x_part | 6,141,653 | model_x_region_x_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 336,850 | part |
100%
|
| sequence |
100%
|
||
| part_code |
100%
|
||
| quantity |
0%
|
||
| note |
55.81%
|
||
| mark |
16%
|
||
| quanlity |
100%
|
||
| region | 14 | region |
92.86%
|
| series | 169 | series |
100%
|
| brand_id |
100%
|
||
| system | 43 | 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 |
|---|---|
| 7.06G | 50,638 |
