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