This is a car parts database having 2,336,292 records with part number, quality, sequence and price in each from 4 brands. There are 1,542 models from 571 series by 39 types for these car parts. In table assembly, it has 1,947,716 records and there are 2,336,292 part details with part number, rating, cms number and description in each. In this auto parts data, it also comes with 1,253,871 part images in the 253.46K media set and 46.47G assembly images. The whole car parts database totally has 17 tables.
| Name | n3_lyz_cmsnl.com |
|---|---|
| Data | 17.29G (+ 15.82G) |
| Tables | 17 (+ 0) |
| Columns | 76 (+ 0) |
| Table Rows | 94,539,896 (+ 0) |
| Media | 151.14G (+ 0B) |
| Files | 1,193,290 (+ 0) |
Data Samples
Database APIs
Media Files
- assembly_image Bytes: 132.31G / Files: 1,047,449
- part_image Bytes: 18.83G / Files: 145,841
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assembly | 1,947,716 | assembly |
99.99%
|
| assembly_x_part | 43,732,875 | assembly_id |
100%
|
| part_id |
100%
|
||
| assembly_x_part_detail | 42,155,095 | assembly_id |
100%
|
| part_detail_id |
100%
|
||
| brand | 4 | brand |
100%
|
| detail_model_m | 37,313 | model_id |
100%
|
| detail_model |
100%
|
||
| detail_model_m_x_assembly | 1,923,296 | detail_model_m_id |
100%
|
| assembly_id |
100%
|
||
| detail_model_s | 307 | detail_model |
100%
|
| series_id |
100%
|
||
| detail_model_s_x_assembly | 12,269 | detail_model_s_id |
100%
|
| assembly_id |
100%
|
||
| model | 1,542 | model |
100%
|
| series_id |
100%
|
||
| model_x_assembly | 12,151 | assembly_id |
100%
|
| model_id |
100%
|
||
| part | 2,336,292 | part_no |
100%
|
| part |
99.56%
|
||
| quality |
100%
|
||
| sequence |
92.78%
|
||
| price |
100%
|
||
| part_detail | 1,126,555 | part_no |
100%
|
| part |
99.23%
|
||
| rating |
0.85%
|
||
| cms_no |
96.1%
|
||
| description |
4.37%
|
||
| part_image_slug | 1,253,871 | part_detail_id |
100%
|
| series | 571 | series |
100%
|
| type_id |
100%
|
||
| type | 39 | 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
ASSEMBLY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 132.31G | 1,047,449 |
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 18.83G | 145,841 |
