Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“UUID generated at insert; uniquely identifies this assessment.”,“why”:“Without it, rows cannot be referenced reliably by foreign keys or external systems.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.740125255+00:00”} |
|||||||||||||||||
| url | text | 2147483647 | null |
|
|
{“what”:“Full URL of the target website that was assessed.”,“why”:“Without it, the assessment cannot be tied to a specific target, making results meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.797151754+00:00”} |
|||||||||||||||||
| domain | text | 2147483647 | null |
|
|
{“what”:“Domain portion of the target URL, such as example.com.”,“why”:“Without it, grouping assessments by site requires parsing the URL each time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.831995385+00:00”} |
|||||||||||||||||
| phases_run | _text | 2147483647 | '{}'::text[] |
|
|
{“what”:“List of phase names executed during the scan, e.g. ‘recon’,‘fingerprint’.”,“why”:“Without it, it is unknown which steps were completed, so partial results cannot be interpreted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.877567913+00:00”} |
|||||||||||||||||
| protection_level | text | 2147483647 | √ | null |
|
|
{“what”:“Categorical value describing the target’s protection strength.”,“why”:“Without it, there is no quick way to compare protection across sites.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.916824904+00:00”} |
||||||||||||||||
| detected_waf | text | 2147483647 | √ | null |
|
|
{“what”:“Name of the Web Application Firewall detected, e.g. ‘Cloudflare’.”,“why”:“Without it, it is unknown whether a WAF is present and which one, affecting interpretation of other results.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.990010471+00:00”} |
||||||||||||||||
| rate_limit_exposed | bool | 1 | √ | null |
|
|
{“what”:“True if the target revealed rate limiting behavior during testing.”,“why”:“Without it, it is unknown whether the target is susceptible to brute force or scraping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.020510515+00:00”} |
||||||||||||||||
| estimated_safe_rate | text | 2147483647 | √ | null |
|
|
{“what”:“Estimated safe request rate per second, as a string like ‘10/s’.”,“why”:“Without it, there is no guidance on how fast to scan without triggering blocks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.042928089+00:00”} |
||||||||||||||||
| fingerprint_passes | bool | 1 | √ | null |
|
|
{“what”:“True if the target’s fingerprinting passed without detection.”,“why”:“Without it, it is unknown whether the scan was detected by the target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.083740678+00:00”} |
||||||||||||||||
| api_endpoints_found | int4 | 10 | √ | 0 |
|
|
{“what”:“Count of API endpoints discovered during the assessment.”,“why”:“Without it, the API attack surface size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.106457879+00:00”} |
||||||||||||||||
| summary_json | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON object containing the full structured summary of the assessment results.”,“why”:“Without it, detailed results are lost and cannot be programmatically processed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.201643488+00:00”} |
||||||||||||||||
| started_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the scan began.”,“why”:“Without it, the duration and ordering of assessments cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.225638051+00:00”} |
|||||||||||||||||
| completed_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the assessment finished, null if still running.”,“why”:“Without it, it is unknown whether the assessment is complete or how long it took.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.342749275+00:00”} |
||||||||||||||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the row was inserted, in UTC.”,“why”:“Without it, the record’s creation time is unknown, affecting audit and retention.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.359141523+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| assessments_pkey | Primary key | Asc | id |
| idx_assessments_created | Performance | Desc | created_at |
| idx_assessments_domain | Performance | Asc | domain |