discovered_apis


Description

{“what”:“APIs discovered during an assessment; each row is one endpoint.”,“why”:“Without it, discovered endpoints are not persisted, so they cannot be reviewed or tested later.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:14.937001408+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()

{“what”:“UUID primary key, generated by gen_random_uuid() at insert.”,“why”:“Without it, no stable way to reference a specific discovered API record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:14.995306172+00:00”}

assessment_id uuid 2147483647 null
assessments.id discovered_apis_assessment_id_fkey R

{“what”:“UUID of the assessment that discovered this API.”,“why”:“Without it, discovered APIs cannot be linked to their source assessment, so results are orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:15.025417425+00:00”}

endpoint_url text 2147483647 null

{“what”:“Full URL of the API endpoint, including scheme and path.”,“why”:“Without it, the actual API location is unknown, making any testing or review impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:15.057106236+00:00”}

method text 2147483647 null

{“what”:“HTTP method (GET, POST, etc.) used to access the endpoint.”,“why”:“Without it, the same URL with different methods would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:15.083592785+00:00”}

request_type text 2147483647 null

{“what”:“Text label categorizing the request, e.g., by protocol or payload format.”,“why”:“Without it, the expected request format is unknown, so automated testing cannot prepare correct payloads.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:15.222611720+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the API record was inserted, in UTC.”,“why”:“Without it, there is no audit trail for when the discovery happened, so temporal analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:15.268661151+00:00”}

Indexes

Constraint Name Type Sort Column(s)
discovered_apis_pkey Primary key Asc id
idx_apis_assessment Performance Asc assessment_id

Relationships