Edit #22273 — identification_materials

id

INTEGER · required

Auto-generated

job_id

INTEGER · required

picker_id

INTEGER · required

source_type

VARCHAR(13) · required

match_type

VARCHAR(13) · required

match_status

VARCHAR(6) · required

qr_code_string

VARCHAR(120) · required

storage_qr_string

VARCHAR(200) · required

storage_label

VARCHAR(200) · required

nameplate_image_path

VARCHAR(300)

equipment_image_path

VARCHAR(300)

extraction_status

VARCHAR(30)

extraction_result

JSON

{"manufacturer": "GE OIL & GAS", "equipment_type": "KIT", "model_number": null, "serial_number": null, "part_number": "20-504470", "tag_number": null, "equipment_description": "KIT, SL 1 3K SPM VLV, DBL PLTD", "visible_text": ["GE OIL & GAS", "REV.B", "* 20 - 50 447 0 *", "PLTD", "KIT,SL 1 3K SPM VLV, DBL PLTD", "2 EA. 19330307-32 T-SEAL, ROD .63 ID X .125 CS 2Q13 EXP: 2Q28", "2 EA. 19330307-35 T-SEAL, ROD 1.62 ID X .187 3Q12 EXP: 3Q27", "1 EA. 34-502022 ST, UPR 1 SPM VLV 3/5K", "1 EA. 19000002-228 O-RING 90 DURO 2-228 2Q11 EXP: 2Q26", "1 EA. 19000001-224 O-RING 70 DURO 2-224 1Q11 EXP: 1Q26", "1 EA. 34-502023 ST, LWR 1 SPM VLV 3/5K", "1 EA. 19000002-229 O-RING 90 DURO 2-229 2Q13 EXP: 2Q28", "2 EA. 19330307-27 T-SEAL, PISTON 1.19 OD X .125 CS 3Q12 EXP: 3Q27", "Please contact Customer Service for any discrepancies at 1-800-999-1601", "in USA/ Canada or contact your nearest GE Oil & Gas Sales Office.", "SELL BY: 1Q26", "REF# 500456", "PACKAGED BY: S.SWINDOLL(204076329)", "INSPECTED BY: Post m 00 7-10-13"]}

extraction_retries

INTEGER · required

matched_iadc_material_id

INTEGER

matched_spare_material_id

INTEGER

match_confidence

DOUBLE PRECISION

match_details

JSON

material_id

INTEGER

cross_reference_id

VARCHAR(50)

manual_selected_name

VARCHAR(200)

notes

TEXT

created_at

TIMESTAMP · required

updated_at

TIMESTAMP · required

is_active

BOOLEAN · required

disposition

VARCHAR(50) · required

admin_notes

TEXT

admin_status

VARCHAR(20) · required

reviewed_by

INTEGER

reviewed_at

TIMESTAMP

condition

VARCHAR(20)

grade

VARCHAR(30)

nameplate_image_paths

JSON

equipment_image_paths

JSON

origin

VARCHAR(20) · required

Edit row #22273 in identification_materials