proposal_impacts


Description

{“what”:“One row per proposal, holding the outcome of an automated impact scan.”,“why”:“Without it, there is no record of what a proposal touches, so approval cannot be based on risk.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.216823016+00:00”}

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

Relationships