identification_materials #17516

id
INTEGER
17516
job_id
INTEGER
143 → jobs
picker_id
INTEGER
24 → pickers
source_type
ENUM
NAMEPLATE
match_type
ENUM
AI_SPARE
match_status
ENUM
YELLOW
qr_code_string
VARCHAR
NiczRmbWcSNc5Q
storage_qr_string
VARCHAR
loc=V1-BY-ZN01-SZ10-RCK05-SLF04-BIN02;SRL=91
storage_label
VARCHAR
Bin: Bin 2
nameplate_image_path
VARCHAR
yard/143/images/nameplate_143_20260919054308708876_435.jpg
equipment_image_path
VARCHAR
yard/143/images/equipment_143_20260919054308710436_429.jpg
extraction_status
VARCHAR
completed
extraction_result
JSON
{"manufacturer": "HDI", "equipment_type": null, "model_number": null, "serial_number": "2-27142 SLAVE", "part_number": "208640000AA", "tag_number": null, "equipment_description": null, "visible_text": ["PH 713-688-8555", "HOUSTON, TEXAS 77041 U.S.A.", "WARNING: DO NOT RUB.", "To prevent static discharge clean / wipe with damp cloth only.", "AVERTISSEMENT: Pour eviter les decharges electrostatiques nettoyer avec un chiffon humide. NE PAS FROTTER.", "Intrinsically Safe / Securite Intrinseque Class 1, Groups A, B, C, D, T4", "A086-1", "WARNING: SUBSTITUTION OF COMPONENTS MAY IMPAIR INTRINSIC SAFETY", "AVERTISSEMENT: LA SUBSTITUTION DE COMPOSANTS PEUT COMPROMETTRE LA SECURITE INTRINSEQUE", "Max. Ambient 60\u00b0C", "intrinsically safe when powered with the respective HDI Power Pack E391, E392 or E280 and provides safe circuits for HDI290008 & HDI...", "NOTE The pressure gauge head and transducer, specifically when connecting the gauge head to the transducer, must be given to the data plate on the back of the gauge. A five or nine digit serial number is stamped on the data plate. If a 20479 or 1202 or 1279 connection is used, ensure that these numbers match. If not, follow calibration procedures to rematch gauge to sensor.", "CAUTION"]}
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
71963 → materials
cross_reference_id
VARCHAR
DE-71963
manual_selected_name
VARCHAR
Yard Equipment
notes
TEXT
null
created_at
TIMESTAMP
2026-09-19T05:43:08.711312
updated_at
TIMESTAMP
2026-09-19T05:43:21.966307
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/143/images/nameplate_143_20260919054308708876_435.jpg"]
equipment_image_paths
JSON
["yard/143/images/equipment_143_20260919054308710436_429.jpg"]
origin
VARCHAR
YARD