This is a motors parts database having 35,795 products of apparel, riding gear, accessories and 344,446 parts of motors. Each product record is comprised of title, price and description and the part record consists of part number, aliase and price in each. All these production are categorized into 780 classifications and there are 100 brands for these categories. In table fitment, it has 49,843 records. It also includes 82,793 images of these part, accessories of motors and these images are stored in the 4.11G media file. The whole motor parts, apparel, riding gear & accessories database totally has 14 tables.
| Name | n3_lyz_shop.kwcycle.com |
|---|---|
| Data | 452M (- 9.50M) |
| Tables | 14 (+ 0) |
| Columns | 55 (+ 0) |
| Table Rows | 2,533,696 (+ 0) |
| Media | 4.11G (+ 0B) |
| Files | 82,792 (+ 0) |
Data Samples
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/parts_and_apparel_and_accessories_of_motor_and_riding_gear_4/ (By Table)
Media Files
- production_image Bytes: 4.11G / Files: 82,792
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| attribute | 16,276 | key |
100%
|
| production_id_id |
100%
|
||
| attribute_value | 78,854 | value |
100%
|
| attribute_id |
100%
|
||
| category | 780 | category_sup |
100%
|
| category_sub |
100%
|
||
| category_brand | 100 | brand |
100%
|
| fitment | 49,843 | title |
100%
|
| image_slug | 82,793 | production_id_id |
100%
|
| part | 344,446 | part_no |
100%
|
| aliase |
65.82%
|
||
| price |
98.77%
|
||
| production_id_id |
100%
|
||
| part_detail | 547,643 | key |
100%
|
| value |
100%
|
||
| part_middle_id |
100%
|
||
| part_middle | 272,828 | middle_no |
100%
|
| part_id |
100%
|
||
| part_middle_x_fitment | 1,032,523 | fitment_id |
100%
|
| part_middle_id |
100%
|
||
| production | 35,795 | title |
100%
|
| price |
98.65%
|
||
| description |
96.43%
|
||
| production_id_id |
100%
|
||
| production_id | 36,020 | category_brand_id |
100%
|
| production_x_category | 35,795 | production_id |
100%
|
| category_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
PRODUCTION_IMAGE
| Size (Bytes) | Files |
|---|---|
| 4.11G | 82,792 |
