Edit #15061 — 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": "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 · 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 #15061 in identification_materials