Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Unique numeric identifier for each proposal row.”,“why”:“Without it, proposals cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:47.881552649+00:00”} |
||||
| action | text | 2147483647 | null |
|
|
{“what”:“Operation to apply, e.g., ‘edit’ or ‘delete’.”,“why”:“Without it, the intended change is unknown and cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:47.948997515+00:00”} |
|||||
| file_path | text | 2147483647 | null |
|
|
{“what”:“Path to the file under version control.”,“why”:“Without it, the target file cannot be located for the change.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.020561841+00:00”} |
|||||
| line_number | int4 | 10 | √ | null |
|
|
{“what”:“Line number in the file; null if file-level.”,“why”:“Without it, the exact location of the change is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.090755281+00:00”} |
||||
| current_state | text | 2147483647 | null |
|
|
{“what”:“Existing code snippet or state at the target location.”,“why”:“Without it, the baseline for the change is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.420851199+00:00”} |
|||||
| proposed_state | text | 2147483647 | √ | null |
|
|
{“what”:“Replacement code or state; null if deletion.”,“why”:“Without it, the desired outcome is unknown, so change cannot be applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.523400550+00:00”} |
||||
| rationale | text | 2147483647 | null |
|
|
{“what”:“Human-readable justification for the change.”,“why”:“Without it, reviewers cannot assess the reasoning behind the proposal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.603217814+00:00”} |
|||||
| intent_signals | text | 2147483647 | '[]'::text |
|
|
{“what”:“JSON array of signals that triggered the proposal.”,“why”:“Without it, the context leading to the proposal is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.835464982+00:00”} |
|||||
| confidence | text | 2147483647 | 'Low'::text |
|
|
{“what”:“Confidence level: Low, Medium, or High.”,“why”:“Without it, the reliability of the proposal is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:48.965689115+00:00”} |
|||||
| risk | text | 2147483647 | 'Medium'::text |
|
|
{“what”:“Risk level: Low, Medium, or High.”,“why”:“Without it, the potential impact of the change is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:49.192672065+00:00”} |
|||||
| status | text | 2147483647 | 'Pending'::text |
|
|
{“what”:“Workflow status: Pending, Approved, Rejected, etc.”,“why”:“Without it, the proposal’s lifecycle state is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:49.279050514+00:00”} |
|||||
| analyzed_by | text | 2147483647 | '[]'::text |
|
|
{“what”:“JSON array of analyzer names that produced this proposal.”,“why”:“Without it, the source of the proposal is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:49.331071328+00:00”} |
|||||
| repo | text | 2147483647 | null |
|
|
{“what”:“Repository name or identifier the proposal applies to.”,“why”:“Without it, the proposal cannot be scoped to a codebase.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:49.504461110+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the proposal was created.”,“why”:“Without it, the age of the proposal is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:49.668503226+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to the proposal.”,“why”:“Without it, it’s impossible to know if the proposal changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:50.012271411+00:00”} |
|||||
| reviewer | text | 2147483647 | √ | null |
|
|
{“what”:“Username or identifier of the reviewer.”,“why”:“Without it, there is no accountability for review decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:50.046619652+00:00”} |
||||
| review_note | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text comment left by the reviewer.”,“why”:“Without it, the reasoning behind a review decision is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:50.066525456+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| proposals_pkey | Primary key | Asc | id |
| idx_proposals_confidence | Performance | Asc | confidence |
| idx_proposals_file | Performance | Asc | file_path |
| idx_proposals_repo | Performance | Asc | repo |
| idx_proposals_status | Performance | Asc | status |