Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each error record.”,“why”:“Enables referencing a specific error row for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.682864048+00:00”} |
|
| analyzed_entity_type | varchar | 254 | null |
|
|
{“what”:“Kind of entity being analyzed, e.g., ‘module’ or ‘file’.”,“why”:“Distinguishes error handling and lookup across different entity types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.698481586+00:00”} |
||
| analyzed_entity_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the specific entity being analyzed, within its type.”,“why”:“Links the error to the exact entity that failed, enabling targeted retry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.713886174+00:00”} |
||
| error_type | varchar | 254 | null |
|
|
{“what”:“Category of error, e.g., ‘timeout’ or ‘parse_error’.”,“why”:“Allows grouping and filtering by error kind for monitoring and alerting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.731244598+00:00”} |
||
| error_detail | varchar | 254 | √ | null |
|
|
{“what”:“Optional human-readable description of the error.”,“why”:“Provides debugging context when error_type alone is insufficient.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.748484420+00:00”} |
|
| source_entity_type | varchar | 254 | √ | null |
|
|
{“what”:“Kind of entity that served as input to the analysis, if any.”,“why”:“Identifies which source type contributed to the error, aiding root cause analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.762183175+00:00”} |
|
| source_entity_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the source entity within its type, if applicable.”,“why”:“Pinpoints the exact source that triggered the error, enabling targeted fixes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.776063488+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| analysis_finding_error_pkey | Primary key | Asc | id |
| idx_analysis_finding_error_analyzed | Performance | Asc/Asc | analyzed_entity_type + analyzed_entity_id |
| idx_analysis_finding_error_source | Performance | Asc/Asc | source_entity_type + source_entity_id |
| idx_analysis_finding_error_type | Performance | Asc | error_type |