In this BMW car parts database, there are 1,363 records from 1984 to 2020 years.
Each record is comprised of seq, part number, assemble, list price, sale price, sku, position, other name and description. There are 6 tables mostly related with these parts, they are 68 assembles; 526 fit car records with make, body trim and engine in each; 224 model records with series in each; series with 11 records; 1,428 system records with mark, model, year, series and system in each and 1,737 year records with model, year, series and system in each.
This BMW auto parts data also comes with assemble images & parts images, they are all keeped in the media files. The whole BMW car parts database totally has 19 tables.
| Name | n3_lyz_bmwofsouthatlanta.com |
|---|---|
| Data | 7.66M (+ 288K) |
| Tables | 19 (+ 0) |
| Columns | 109 (+ 0) |
| Table Rows | 18,569 (+ 0) |
| Media | 1.20M (+ 0B) |
| Files | 51 (+ 0) |
Data Samples
Database APIs
Media Files
- assemble_image Bytes: 1.19M / Files: 50
- part_image Bytes: 6.64K / Files: 1
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 68 | assemble |
100%
|
| sub_system_id |
100%
|
||
| fit_car | 526 | make |
100%
|
| body_trim |
100%
|
||
| engine |
100%
|
||
| model | 224 | model |
100%
|
| series_id |
100%
|
||
| series |
100%
|
||
| model_m | 128 | model |
100%
|
| series |
100%
|
||
| year |
100%
|
||
| year_m_id |
100%
|
||
| part | 1,363 | seq |
100%
|
| title |
100%
|
||
| part_number |
100%
|
||
| assemble_id |
100%
|
||
| list_price |
6.6%
|
||
| sale_price |
6.6%
|
||
| sku |
6.6%
|
||
| sku_2 |
6.75%
|
||
| position |
3.6%
|
||
| other_name |
6.75%
|
||
| description |
6.68%
|
||
| part2_image_slug | 0 | title |
0%
|
| city |
0%
|
||
| votes |
0%
|
||
| description |
0%
|
||
| part_2_id |
0%
|
||
| part_2 | 9 | title |
77.78%
|
| part_number |
100%
|
||
| sub_system_id |
100%
|
||
| list_price |
88.89%
|
||
| sale_price |
88.89%
|
||
| sku |
88.89%
|
||
| sku_2 |
88.89%
|
||
| position |
22.22%
|
||
| other_name |
88.89%
|
||
| description |
88.89%
|
||
| part_2_x_fit_car | 337 | part_2_id |
100%
|
| fit_car_id |
100%
|
||
| part_image_slug | 1 | part_id |
100%
|
| part_x_fit_car | 2,817 | part_id |
100%
|
| fit_car_id |
100%
|
||
| series | 11 | series |
100%
|
| series_m | 4 | series |
100%
|
| sub_system | 9,890 | sub_system |
100%
|
| system_id |
100%
|
||
| mark |
0%
|
||
| system | 1,428 | system |
100%
|
| mark |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| series |
100%
|
||
| year | 1,737 | year |
99.14%
|
| model_id |
100%
|
||
| model |
100%
|
||
| series |
100%
|
||
| system |
0.86%
|
||
| year_m | 26 | year |
100%
|
| series |
100%
|
||
| series_m_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 |
|---|---|
| 1.19M | 50 |
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 6.64K | 1 |
