|
id
INTEGER
|
15061 |
|
job_id
INTEGER
|
135 → jobs |
|
picker_id
INTEGER
|
25 → pickers |
|
source_type
ENUM
|
NAMEPLATE |
|
match_type
ENUM
|
AI_SPARE |
|
match_status
ENUM
|
GREEN |
|
qr_code_string
VARCHAR
|
no_FUVzqX00GBg |
|
storage_qr_string
VARCHAR
|
loc=V1-BY-ZN01-SZ05-RCK04-SLF02-BIN01;SRL=294 |
|
storage_label
VARCHAR
|
Bin: Bin 1 |
|
nameplate_image_path
VARCHAR
|
yard/135/images/nameplate_135_20260912121555120861_0f7.jpg |
|
equipment_image_path
VARCHAR
|
yard/135/images/equipment_135_20260912121555121426_07b.jpg |
|
extraction_status
VARCHAR
|
completed |
|
extraction_result
JSON
|
{"manufacturer": "SIEMENS", "equipment_type": "CONTACT BREAKER SWITCH", "model_number": "NP35", "serial_number": null, "part_number": "3NY3035", "tag_number": null, "equipment_description": "NP35 SIEMENS TYPE MOVABLE, set of supplements", "visible_text": ["4/03/17", "ITEM: 30284707", "atalhes", "CONTATO P/CHAVE SECCIONADORA MODELO NP35 SIEMENS TIPO MOVEL /CONTACT BREAKER SWITCH SWITCH NP35 SIEMENS TYPE MOVABLE", "art Number: 31N3035", "Localiza\u00e7\u00e3o: TAILED", "APLICA\u00c7\u00c3O: REFORMA NO PAINEL DOS MOTORES AUXILIAR DAS BOMBAS DE LAMA DEGASAES, DESILER", "SIEMENS", "WARNUNG", "Gef\u00e4hrliche elektrische Spannung! Kann zu Tod oder schwerer K\u00f6rperverletzung f\u00fchren. Vor Arbeiten an diesem Ger\u00e4t die Versorgungsfreischaltung und Betriebsanleitung beachten.", "AVISO", "Tens\u00e3o el\u00e9trica perigosa!", "Pode causar morte ou les\u00f5es s\u00e9rias. Antes de executar qualquer trabalho no equipamento, certifique-se de que a unidade e o aparelho a consultar, bem como as instru\u00e7\u00f5es de servi\u00e7o.", "HAZARDOUS VOLTAGE", "Can cause death or serious injury. Disconnect power before proceeding with any work on this equipment and consult the operating instructions.", "\u8b66\u544a", "\u6709\u5371\u9669\u7684\u7535\u538b!\u6709\u5bfc\u81f4\u6b7b\u4ea1\u6216\u80a2\u4f53\u4f24\u5bb3\u7684\u5371\u9669\u3002\u5f00\u59cb\u5de5\u4f5c\u4e4b\u524d,\u8bf7\u5207\u65ad\u8bbe\u5907\u53ca\u4eea\u5668\u7684\u7535\u6e90\u5e76\u9605\u8bfb\u64cd\u4f5c\u6307\u5357\u3002", "ATTENTION", "Tension \u00e9lectrique dangereuse! Peut causer la mort ou des blessures graves. Avant d'intervenir pour travaux, mettre l'\u00e9quipement hors tension et se conformer aux directives des instructions de service.", "\u0412\u041d\u0418\u041c\u0410\u041d\u0418\u0415!", "\u0412\u042b\u0421\u041e\u041a\u041e\u0415 \u041d\u0410\u041f\u0420\u042f\u0416\u0415\u041d\u0418\u0415!", "\u041c\u043e\u0436\u0435\u0442 \u0441\u0442\u0430\u0442\u044c \u043f\u0440\u0438\u0447\u0438\u043d\u043e\u0439 \u0441\u043c\u0435\u0440\u0442\u0438 \u0438\u043b\u0438 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0442\u044f\u0436\u0435\u043b\u043e\u0439 \u0442\u0440\u0430\u0432\u043c\u044b. \u041f\u0435\u0440\u0435\u0434 \u043d\u0430\u0447\u0430\u043b\u043e\u043c \u0440\u0430\u0431\u043e\u0442 \u043e\u0442\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043f\u0438\u0442\u0430\u043d\u0438\u0435 \u0438 \u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435\u043c \u0443\u0441\u0442\u0440\u043e\u0439\u0441\u0442\u0432\u0430 \u0438 \u043f\u0440\u0438\u043d\u044f\u0442\u044c \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u043f\u043e \u044d\u043a\u0441\u043f\u043b\u0443\u0430\u0442\u0430\u0446\u0438\u0438.", "ATTENZIONE", "Tensione elettrica pericolosa! Rischio di shock e lesioni gravi. Prima di intraprendere qualsiasi tipo di lavoro, togliere l'alimentazione elettrica all'apparecchio e consultare le istruzioni per l'uso.", "ATENCI\u00d3N", "\u00a1Tensi\u00f3n peligrosa! Puede causar choque el\u00e9ctrico y lesiones graves. Antes de comenzar cualquier trabajo, desconectar y aislar de alimentaci\u00f3n la instalaci\u00f3n y el equipo, y consultar las instrucciones de funcionamiento.", "CE", "AR48", "Anbausatz / set of supplements / kit per accoppiamento / juego de accesorios / conjunto de montagem / \u041c\u043e\u043d\u0442\u0430\u0436\u043d\u044b\u0439 \u043a\u043e\u043c\u043f\u043b\u0435\u043a\u0442", "\u8fde\u63a5\u7ec4\u4ef6", "Instr.Ord.No. / \u041d\u041e\u041c\u0415\u0420 \u0414\u041b\u042f \u0420\u0423\u041a.\u041f\u041e \u042d\u041a. / \u64cd\u4f5c\u6307\u5357\u8ba2\u8d27\u53f7", "3ZX1012-0NP30-1AA2", "*01546720*", "Qty", "1", "4019120088047", "G / 14/0518", "392", "3NY3035", "Made in Germany"]}
|
|
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
|
70451 → materials |
|
cross_reference_id
VARCHAR
|
DE-70451 |
|
manual_selected_name
VARCHAR
|
CONTACT BREAKER SWITCH |
|
notes
TEXT
|
null |
|
created_at
TIMESTAMP
|
2026-09-12T12:15:55.122264 |
|
updated_at
TIMESTAMP
|
2026-09-12T12:16:14.721425 |
|
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/135/images/nameplate_135_20260912121555120861_0f7.jpg", "yard/135/images/nameplate_135_20260912121555121224_f1f.jpg"] |
|
equipment_image_paths
JSON
|
["yard/135/images/equipment_135_20260912121555121426_07b.jpg"] |
|
origin
VARCHAR
|
YARD |