|
id
INTEGER
|
4987 |
|
job_id
INTEGER
|
63 → jobs |
|
picker_id
INTEGER
|
17 → pickers |
|
source_type
ENUM
|
NAMEPLATE |
|
match_type
ENUM
|
MISCELLANEOUS |
|
match_status
ENUM
|
GREEN |
|
qr_code_string
VARCHAR
|
O-dX1R8hhvm1FA |
|
storage_qr_string
VARCHAR
|
loc=V1-BY-ZN01-SZ07-RCK04-SLF02;SRL=108 |
|
storage_label
VARCHAR
|
Shelf: Shelf 2 |
|
nameplate_image_path
VARCHAR
|
yard/63/images/nameplate_63_20260722053006130392_fd2.jpg |
|
equipment_image_path
VARCHAR
|
yard/63/images/equipment_63_20260722053006131508_df6.jpg |
|
extraction_status
VARCHAR
|
completed |
|
extraction_result
JSON
|
{"manufacturer": "W\u00c4RTSIL\u00c4", "equipment_type": "PRESSURE REGULATING V/V", "model_number": "WWS-STP 94986-01", "serial_number": "66814250", "part_number": "90843-01", "tag_number": null, "equipment_description": "PRESSURE REGULATING V/V", "visible_text": ["ORIGINAL PARTS", "Description", "PRESSURE REGULATING V/V", "Code No", "90843-01", "Order No", "0042114959", "Customer Order No", "PO - 19012#ODF", "Product Type/ Number", "WWS-STP 94986-01", "ECDC00000:9353856", "Part No", "Origin", "GB", "Best Before Date", "Item No", "500/", "300005", "Quantity", "1,000", "UOM", "PC", "66814250", "W\u00c4RTSIL\u00c4"]}
|
|
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
|
29739 → materials |
|
cross_reference_id
VARCHAR
|
DE-29739 |
|
manual_selected_name
VARCHAR
|
PRESSURE REGULATING V/V |
|
notes
TEXT
|
null |
|
created_at
TIMESTAMP
|
2026-07-22T05:30:06.133480 |
|
updated_at
TIMESTAMP
|
2026-07-22T05:30:22.372977 |
|
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/63/images/nameplate_63_20260722053006130392_fd2.jpg"] |
|
equipment_image_paths
JSON
|
["yard/63/images/equipment_63_20260722053006131508_df6.jpg", "yard/63/images/equipment_63_20260722053006131803_e74.jpg"] |
|
origin
VARCHAR
|
YARD |