In this car parts database, there are 526 records for Nissan cars of Japan and Europe. Each record is comprised of part code, part name and url full. There are 8 tables mostly related to these parts, they are 49 part details with oem number, production period, part, required, spec code, exterior, interior, applies for models, note, replacements and price in each; 1,575 assemble; 213 complectation records with manufacture period and frame in each; 101 model records; 448 frame records with model in each; 34 assemble image slug records; 1,057 specs and 175 systems.
Important fields: model, frame, system, assemble, part code, part OEM number, spec code, replacements, price, note, image.
The whole Nissan cars parts data set has 11 tables.
| Name | n3_lyz_nissan.epc_Jp |
|---|---|
| Data | 1.42M (+ 16K) |
| Tables | 11 (+ 0) |
| Columns | 66 (+ 0) |
| Table Rows | 4,728 (+ 0) |
| Media | 1.58M (+ 0B) |
| Files | 34 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 1,575 | assemble |
100%
|
| system_id |
100%
|
||
| assemble_image_slug | 34 | assemble_id |
100%
|
| assemble_x_part | 550 | assemble_id |
100%
|
| part_id |
100%
|
||
| complectation | 213 | manufacture_period |
100%
|
| frame_id |
100%
|
||
| frame | 448 | frame |
100%
|
| model_id |
100%
|
||
| model | 101 | model |
100%
|
| part | 526 | part_code |
100%
|
| part_name |
99.81%
|
||
| url_full |
0%
|
||
| part_detail | 49 | oem_number |
100%
|
| production_period |
100%
|
||
| part_id |
100%
|
||
| required |
100%
|
||
| spec_code |
0%
|
||
| exterior |
0%
|
||
| interior |
0%
|
||
| applies_for_models |
100%
|
||
| note |
8.16%
|
||
| replacements |
0%
|
||
| price |
100%
|
||
| spec | 1,057 | title |
100%
|
| value |
100%
|
||
| complectation_id |
100%
|
||
| system | 175 | system |
100%
|
| complectation_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.58M | 34 |
