|
id
INTEGER
|
1 |
|
job_title
VARCHAR
|
TEST |
|
description
TEXT
|
null |
|
job_type
ENUM
|
PICK_DROP |
|
material_id
INTEGER
|
2273 → materials |
|
status
ENUM
|
ASSIGNED |
|
created_by
INTEGER
|
9 |
|
created_at
TIMESTAMP
|
2026-05-20T11:19:47.920126 |
|
assigned_at
TIMESTAMP
|
2026-05-20T11:20:03.159722 |
|
updated_at
TIMESTAMP
|
2026-05-20T11:20:15.758129 |
|
is_active
BOOLEAN
|
Inactive |
|
assigned_user_id
INTEGER
|
13 |
|
assigned_user_type
VARCHAR
|
picker |
|
assigned_user_name
VARCHAR
|
Carlos Rivera |
|
vessel_id
INTEGER
|
null |
|
vessel_document_id
INTEGER
|
null |
|
surveyor_id
INTEGER
|
null |
|
surveyor_name
VARCHAR
|
null |
|
job_started_at
TIMESTAMP
|
null |
|
prereq_completed_at
TIMESTAMP
|
null |
|
job_in_progress_at
TIMESTAMP
|
null |
|
job_completed_at
TIMESTAMP
|
null |
|
warehouse_id
INTEGER
|
null |