deliverables


Description

{“what”:“A submitted file or artifact for an assignment, with path and optional review.”,“why”:“Without it, assignment submissions cannot be tracked or reviewed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.912049733+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('deliverables_id_seq'::regclass)

{“what”:“Unique integer assigned by sequence; primary key.”,“why”:“Without it, there is no stable way to reference a specific deliverable in other tables or in URLs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.943351209+00:00”}

assignment_id int8 19 null
assignments.id deliverables_assignment_id_fkey C

{“what”:“Foreign key to assignments table; the assignment this deliverable is for.”,“why”:“Without it, a deliverable cannot be associated with a specific assignment, making it impossible to know which assignment it fulfills.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.955191359+00:00”}

path text 2147483647 null

{“what”:“File system path or URL where the deliverable content is stored.”,“why”:“Without it, the actual submitted file cannot be located, so the deliverable is unusable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.970458300+00:00”}

summary text 2147483647 √ null

{“what”:“Optional short text describing the deliverable, such as a changelog or notes.”,“why”:“Without it, reviewers have no context about what the deliverable contains or changes made.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.986164107+00:00”}

self_review jsonb 2147483647 √ null

{“what”:“Optional JSON object containing the submitter’s self-assessment, structure not enforced.”,“why”:“Without it, there is no record of the submitter’s own evaluation, which may be required for grading or reflection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:22.005057638+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the deliverable was submitted, in UTC with time zone.”,“why”:“Without it, submission order and deadlines cannot be verified, making it impossible to enforce due dates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:22.017834457+00:00”}

Indexes

Constraint Name Type Sort Column(s)
deliverables_pkey Primary key Asc id
idx_deliverables_assignment Performance Asc assignment_id

Relationships