|
id
INTEGER
|
6 |
|
event_type
VARCHAR
|
PICKER_NOTE_MATERIAL_QR |
|
node_type
VARCHAR
|
null |
|
node_id
INTEGER
|
null |
|
node_name
VARCHAR
|
null |
|
warehouse_id
INTEGER
|
null |
|
material_id
INTEGER
|
null |
|
material_name
VARCHAR
|
null |
|
job_id
INTEGER
|
8 → jobs |
|
user_id
INTEGER
|
null |
|
user_scope
VARCHAR
|
picker |
|
user_name
VARCHAR
|
David Williams |
|
summary
VARCHAR
|
Material QR scanned: MAT-QR-001 |
|
details
JSON
|
{"job_type": "RELOCATION", "status": "JOB_IN_PROGRESS", "evidence_path": "jobs/8/material_qr/evidence_8_20260618104119196843_2a0.jpg"} |
|
notes
TEXT
|
null |
|
created_at
TIMESTAMP
|
2026-06-18T10:41:19.212232 |