This is a car parts database having 180,332 records with sequence, part code, quantity, note and data model in each. In this car parts data set, there are 5 tables mostly related with these parts, they are 13 models; brand with 34 records; 10,485 assembles with model and note in each; system with 10 records and 161 years for these parts. The auto parts api also comes with 72,065 assemble images in the 0.99G media set. The whole car parts database totally has 12 tables.
| Name | n3_lyz_7zap.com_en_cars_seat |
|---|---|
| Data | 554.72M (+ 0B) |
| Tables | 12 (+ 0) |
| Columns | 56 (+ 0) |
| Table Rows | 3,046,670 (+ 0) |
| Media | 3.68G (+ 0B) |
| Files | 71,496 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 10,485 | assemble |
100%
|
| model |
65.98%
|
||
| note |
44.36%
|
||
| assemble_image_slug | 72,065 | assemble_id |
100%
|
| brand | 34 | brand |
100%
|
| model | 13 | brand_id |
100%
|
| model |
100%
|
||
| model_short |
100%
|
||
| model_x_year | 173 | model_id |
100%
|
| year_id |
100%
|
||
| model_x_year_x_system | 1,408 | model_x_year_id |
100%
|
| system_id |
100%
|
||
| model_x_year_x_system_x_assemble | 72,262 | model_x_year_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_year_x_system_x_assemble_x_part | 2,709,727 | model_x_year_x_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 180,332 | part |
100%
|
| sequence |
87.44%
|
||
| part_code |
95.05%
|
||
| quantity |
65.89%
|
||
| note |
88.14%
|
||
| data_model |
32.42%
|
||
| system | 10 | system |
100%
|
| year | 161 | year |
92.55%
|
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.68G | 71,496 |
