This is a bikes database having 196 records with description, year from, year to, price, price from, price to and star in each from 3 brands. In table part, it has 1,014 records with option, upc, mpn and store sku in each. These bikes are categorized into 8 types, these types are road, triathlon, mountain, electric assist, cyclocross, town, kids and other. These brands are Trek, Electra and Sun Bicycles. There are 3,036 specifications for these bikes. The whole bikes database totally has 9 tables.
| Name | n3_lyz_trekchicago.com |
|---|---|
| Data | 2.08M (+ 16K) |
| Tables | 9 (+ 0) |
| Columns | 44 (+ 0) |
| Table Rows | 5,093 (+ 0) |
| Media | 53.51M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bike | 196 | title |
100%
|
| description |
100%
|
||
| year_from |
0%
|
||
| year_to |
100%
|
||
| price |
86.73%
|
||
| price_from |
4.59%
|
||
| price_to |
4.59%
|
||
| star |
20.92%
|
||
| bike_x_brand | 196 | bike_id |
100%
|
| brand_id |
100%
|
||
| brand | 3 | brand |
100%
|
| category | 8 | category |
100%
|
| category_x_bike | 200 | category_id |
100%
|
| bike_id |
100%
|
||
| image_slug | 440 | bike_id |
100%
|
| part | 1,014 | option |
100%
|
| upc |
100%
|
||
| mpn |
100%
|
||
| store_sku |
97.04%
|
||
| bike_id |
100%
|
||
| specification | 3,036 | 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 |
|---|---|
| 53.51M | 300 |
