|
id
|
int(10) unsigned
|
|
|
|
|
vin
|
varchar(32)
|
|
|
|
|
requested_part_name
|
varchar(190)
|
|
|
|
|
normalized_part_name
|
varchar(190)
|
|
|
|
|
vehicle_family
|
varchar(120)
|
|
|
|
|
vehicle_variant
|
varchar(190)
|
|
|
|
|
matched_part_name
|
varchar(190)
|
|
|
|
|
matched_part_number
|
varchar(120)
|
|
|
|
|
confidence
|
varchar(20)
|
|
|
|
|
source_type
|
varchar(20)
|
|
|
local
|
|
needs_manual_verification
|
tinyint(1)
|
|
|
1
|
|
was_saved_to_parts
|
tinyint(1)
|
|
|
0
|
|
reason
|
text
|
|
|
|
|
raw_json
|
longtext
|
|
|
|
|
created_at
|
datetime
|
|
|
|
|
updated_at
|
datetime
|
|
|
|