In the bikes database, there are 708 records with title, description, feature, price, price unit, msrp, msrp unit, review score and votes in each. It also has 82 colors, 58 size records, 3,019 images and 13,518 specifications of these bicycles by 24 popular makes. In the media set, there are 1.11G bike images. The whole bicycles database has 10 tables.
| Name | n3_lyz_performancebike.com/shop/ |
|---|---|
| Data | 8.28M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 42 (+ 0) |
| Table Rows | 20,268 (+ 0) |
| Media | 1.11G (+ 0B) |
| Files | 2,895 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bike | 708 | title |
100%
|
| description |
98.16%
|
||
| feature |
98.02%
|
||
| price |
100%
|
||
| price_unit |
100%
|
||
| msrp |
89.83%
|
||
| msrp_unit |
89.83%
|
||
| review_score |
43.5%
|
||
| votes |
43.5%
|
||
| bike_x_color | 617 | bike_id |
100%
|
| color_id |
100%
|
||
| bike_x_make | 695 | bike_id |
100%
|
| make_id |
100%
|
||
| bike_x_size | 1,547 | bike_id |
100%
|
| size_id |
100%
|
||
| color | 82 | color |
100%
|
| image_slug | 3,019 | bike_id |
100%
|
| make | 24 | make |
100%
|
| size | 58 | size |
100%
|
| specification | 13,518 | title |
100%
|
| value |
100%
|
||
| bike_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
BIKE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.11G | 2,895 |
