assignments


Description

{“what”:“A unit of work tied to an application, with its own lifecycle and outcome.”,“why”:“Without it, the state and result of each application’s task would be untracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.714934767+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('assignments_id_seq'::regclass)
assignment_events.assignment_id assignment_events_assignment_id_fkey C
deliverables.assignment_id deliverables_assignment_id_fkey C

{“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]))

Relationships