In this KIA car parts database, there are 455,657 records of 8 systems (body, engine, transmission, chassis, trim, electrical, accessory and no category) for Middle East.
Each record is comprised of pnc, part number, part name, start date and end data. There are 5 tables mostly related with these KIA car parts, they are 3,092 assembles; 589,874 part assemble records with pnc, part number, part name, quantity and model description in each; 75 model records with model, serie and year in each; serie with 30 records and 8 systems. This KIA car parts data also comes with 17,913 images of assembles.
The whole kia parts api totaly has 11 tables.
| Name | n3_lyz_kia.catalogs-parts.com_med |
|---|---|
| Data | 752.84M (+ 363.22M) |
| Tables | 11 (+ 0) |
| Columns | 51 (+ 0) |
| Table Rows | 1,796,519 (+ 0) |
| Media | 1.96G (+ 0B) |
| Files | 17,897 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 3,092 | assemble |
100%
|
| pre_assemble |
100%
|
||
| assemble_image_slug | 17,913 | assemble_id |
100%
|
| model | 75 | model |
100%
|
| serie_id |
100%
|
||
| year |
100%
|
||
| model_x_system | 481 | model_id |
100%
|
| system_id |
100%
|
||
| model_x_system_x_assemble | 17,915 | model_x_system_id |
100%
|
| assemble_id |
100%
|
||
| model_x_system_x_assemble_x_part | 711,474 | model_x_system_x_assemble_id |
100%
|
| part_id |
100%
|
||
| part | 455,657 | pnc |
100%
|
| part_number |
100%
|
||
| part_name |
100%
|
||
| start_date |
95.11%
|
||
| end_date |
88.34%
|
||
| part_assemble | 589,874 | pnc |
100%
|
| part_number |
100%
|
||
| part_name |
100%
|
||
| qty |
99.63%
|
||
| model_description |
43.26%
|
||
| assemble_id |
100%
|
||
| serie | 30 | serie |
100%
|
| system | 8 | system |
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.96G | 17,897 |
