Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| proposal_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the proposal this impact analysis belongs to.”,“why”:“Without it, the analysis cannot be linked to a specific proposal, making it useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.507193533+00:00”} |
||
| risk | text | 2147483647 | √ | null |
|
|
{“what”:“Risk level assigned to the proposal, e.g., low, medium, high.”,“why”:“Without it, reviewers cannot quickly triage which proposals need deeper inspection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.644093702+00:00”} |
|
| open_handles | int4 | 10 | √ | null |
|
|
{“what”:“Number of open file handles the proposal would affect.”,“why”:“Without it, the potential for resource leaks or lock conflicts is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.698229028+00:00”} |
|
| code_refs | int4 | 10 | √ | null |
|
|
{“what”:“Count of code references (e.g., function calls) impacted by the proposal.”,“why”:“Without it, the blast radius of the change on the codebase is not quantified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.915613659+00:00”} |
|
| service_configs | int4 | 10 | √ | null |
|
|
{“what”:“Number of service configuration files that would be modified.”,“why”:“Without it, the impact on runtime behavior across services is not assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:40.057123878+00:00”} |
|
| manifest_refs | int4 | 10 | √ | null |
|
|
{“what”:“Count of manifest file entries (e.g., dependencies) that reference the proposal’s changes.”,“why”:“Without it, dependency consistency after the change cannot be verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:40.259291345+00:00”} |
|
| dependent_symlinks | int4 | 10 | √ | null |
|
|
{“what”:“Number of symbolic links that depend on the proposal’s target paths.”,“why”:“Without it, broken symlinks or path resolution failures may go unnoticed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:40.850590036+00:00”} |
|
| dest_conflict | text | 2147483647 | √ | null |
|
|
{“what”:“Description of any conflict at the destination path, or null if none.”,“why”:“Without it, a proposal that overwrites existing files could be approved unknowingly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:40.963542643+00:00”} |
|
| required_changes | text | 2147483647 | √ | null |
|
|
{“what”:“Human-readable list of changes required to apply the proposal.”,“why”:“Without it, the effort and steps needed to implement the proposal are not documented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:41.006804999+00:00”} |
|
| summary | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text summary of the impact analysis findings.”,“why”:“Without it, the key takeaways of the scan are not available for quick review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:41.450913745+00:00”} |
|
| checked_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“UTC timestamp when the impact analysis was last run.”,“why”:“Without it, the freshness of the analysis is unknown, so stale results could be used for decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:42.188974569+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| proposal_impacts_pkey | Primary key | Asc | proposal_id |