proposals


Description

{“what”:“Code change proposals with analysis and review metadata.”,“why”:“Without it, proposed changes and their review status cannot be tracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:47.820662566+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
execution_log.proposal_id execution_log_proposal_id_fkey R

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

Relationships