identification_materials #18637

id
INTEGER
18637
job_id
INTEGER
146 → jobs
picker_id
INTEGER
17 → pickers
source_type
ENUM
NAMEPLATE
match_type
ENUM
AI_SPARE
match_status
ENUM
GREEN
qr_code_string
VARCHAR
2WvhHGh_S5b9Tg
storage_qr_string
VARCHAR
loc=V1-BY-ZN01-SZ10-RCK05-SLF04-BIN03;SRL=92
storage_label
VARCHAR
Bin: Bin 3
nameplate_image_path
VARCHAR
yard/146/images/nameplate_146_20260921112756370336_6c8.jpg
equipment_image_path
VARCHAR
yard/146/images/equipment_146_20260921112756370864_262.jpg
extraction_status
VARCHAR
completed
extraction_result
JSON
{"manufacturer": "Green Instruments", "equipment_type": "Oxygen Sensor", "model_number": "SEN9", "serial_number": null, "part_number": "01258", "tag_number": null, "equipment_description": "SEN9 Oxygen Sensor", "visible_text": ["Green Instruments", "Quick installation guide for SEN9 Oxygen Sensor", "Part ID: 01258", "1. Disconnect the power to the analyzer.", "2. Remove the metal cover to access the sensor housing.", "3. Disconnect the cable and remove the used sensor.", "4. Unpack the new sensor found inside this carton tube.", "5. Remove the plastic cover on the sensor tip.", "6. Screw the sensor into the sensor housing using a spanner.", "7. Dependent on system configuration, connect the sensor cable directly to the analyzer or to the external sensor cable.", "8. Refit the metal cover and turn on the power to the analyzer.", "For more information, please read the instruction manual.", "Phone: +45 9845 4530", "www.greeninstruments.com", "service@greeninstruments.com"]}
extraction_retries
INTEGER
0
matched_iadc_material_id
INTEGER
null
matched_spare_material_id
INTEGER
null
match_confidence
DOUBLE_PRECISION
null
match_details
JSON
null
material_id
INTEGER
72668 → materials
cross_reference_id
VARCHAR
DE-72668
manual_selected_name
VARCHAR
Oxygen Sensor
notes
TEXT
null
created_at
TIMESTAMP
2026-09-21T11:27:56.372448
updated_at
TIMESTAMP
2026-09-21T11:28:03.104967
is_active
BOOLEAN
Active
disposition
VARCHAR
SHIFT_TO_STORAGE
admin_notes
TEXT
[auto-publish: new_material]
admin_status
VARCHAR
AUTO_PUBLISHED
reviewed_by
INTEGER
null
reviewed_at
TIMESTAMP
null
condition
VARCHAR
New
grade
VARCHAR
Excellent
nameplate_image_paths
JSON
["yard/146/images/nameplate_146_20260921112756370336_6c8.jpg", "yard/146/images/nameplate_146_20260921112756370690_e8b.jpg"]
equipment_image_paths
JSON
["yard/146/images/equipment_146_20260921112756370864_262.jpg"]
origin
VARCHAR
YARD