|
id
INTEGER
|
122 |
|
job_title
VARCHAR
|
02.09.26 |
|
description
TEXT
|
WRONGLY CREATED |
|
job_type
ENUM
|
RELOCATION |
|
material_id
INTEGER
|
null |
|
status
ENUM
|
JOB_COMPLETED |
|
created_by
INTEGER
|
13 |
|
created_at
TIMESTAMP
|
2026-09-01T13:32:47.212383 |
|
assigned_at
TIMESTAMP
|
2026-09-01T13:32:47.211481 |
|
updated_at
TIMESTAMP
|
2026-09-03T04:08:49.470110 |
|
is_active
BOOLEAN
|
Active |
|
assigned_user_id
INTEGER
|
null |
|
assigned_user_type
VARCHAR
|
picker |
|
assigned_user_name
VARCHAR
|
Solanki Mihir H, Samik Sandesh Jadav, Bhadresh Solanki +2 more |
|
vessel_id
INTEGER
|
null |
|
vessel_document_id
INTEGER
|
null |
|
surveyor_id
INTEGER
|
null |
|
surveyor_name
VARCHAR
|
null |
|
job_started_at
TIMESTAMP
|
2026-09-02T02:46:38.794788 |
|
prereq_completed_at
TIMESTAMP
|
null |
|
job_in_progress_at
TIMESTAMP
|
2026-09-02T02:46:38.794800 |
|
job_completed_at
TIMESTAMP
|
2026-09-03T04:08:02.737831 |
|
warehouse_id
INTEGER
|
9 → warehouses |
|
location_id
INTEGER
|
null |
|
is_archived
BOOLEAN
|
False |
|
completion_type
VARCHAR
|
ADMIN_FORCED |
|
force_completed_by
INTEGER
|
13 |
|
force_completed_at
TIMESTAMP
|
2026-09-03T04:08:02.737831 |
|
yard_target_classification
VARCHAR
|
null |