Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('assignments_id_seq'::regclass) |
|
|
{“what”:“Unique integer from a sequence; identifies this row.”,“why”:“Without it, rows cannot be referenced uniquely by foreign keys or updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.744590818+00:00”} |
|||||||
| application_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the application this assignment is for.”,“why”:“Without it, assignments cannot be linked to their parent application.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.759579475+00:00”} |
||||||||
| job_id | int8 | 19 | √ | null |
|
|
{“what”:“Identifier of the job associated with this assignment, if any.”,“why”:“Without it, the job context for the assignment is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.777008369+00:00”} |
|||||||
| business_id | int8 | 19 | √ | null |
|
|
{“what”:“Identifier of the business that owns the job or assignment.”,“why”:“Without it, the responsible business for this assignment is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.889856004+00:00”} |
|||||||
| kind | text | 2147483647 | null |
|
|
{“what”:“Category of assignment, such as coding or writing.”,“why”:“Without it, the format and expected output of the assignment are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.963993747+00:00”} |
||||||||
| brief | text | 2147483647 | null |
|
|
{“what”:“Full instructions or description of the assignment.”,“why”:“Without it, the assignee has no details on what to do.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.002656610+00:00”} |
||||||||
| attachments | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON array of file references or metadata attached to the assignment.”,“why”:“Without it, supporting files for the assignment are missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.026621877+00:00”} |
|||||||
| due_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Deadline for submission, in UTC with time zone.”,“why”:“Without it, there is no deadline to enforce or track.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.136330608+00:00”} |
|||||||
| status | text | 2147483647 | 'received'::text |
|
|
{“what”:“Current state of the assignment, e.g., received, in_progress, submitted.”,“why”:“Without it, you cannot know whether the assignment is pending, active, or done.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.262172544+00:00”} |
||||||||
| last_error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message from the last failed processing attempt.”,“why”:“Without it, the cause of a failed attempt is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.309648787+00:00”} |
|||||||
| last_solve_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp of the most recent automated solve attempt.”,“why”:“Without it, you cannot tell when the last attempt occurred.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.353528606+00:00”} |
|||||||
| solve_attempts | int4 | 10 | 0 |
|
|
{“what”:“Count of automated solve attempts made so far.”,“why”:“Without it, you cannot limit retries or detect repeated failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.413505240+00:00”} |
||||||||
| submission_path | text | 2147483647 | √ | null |
|
|
{“what”:“File path or URL where the final submission is stored.”,“why”:“Without it, the submitted work cannot be retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.427573306+00:00”} |
|||||||
| submitted_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the assignment was submitted.”,“why”:“Without it, submission timing and deadlines cannot be verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.493946254+00:00”} |
|||||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the assignment record was created.”,“why”:“Without it, the creation time and ordering of assignments is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:23.513078138+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| assignments_pkey | Primary key | Asc | id |
| idx_assignments_application | Performance | Asc | application_id |
| idx_assignments_business | Performance | Asc | business_id |
| idx_assignments_status | Performance | Asc | status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| assignments_kind_check | (kind = ANY (ARRAY['coding'::text, 'case_study'::text, 'design_doc'::text, 'data'::text, 'other'::text])) |
| assignments_status_check | (status = ANY (ARRAY['received'::text, 'in_progress'::text, 'review'::text, 'submitted'::text])) |