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