assessments


Description

{“what”:“A single security assessment run against a target URL.”,“why”:“Without it, scan results have no persistent home and cannot be compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.685049921+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
discovered_apis.assessment_id discovered_apis_assessment_id_fkey R
fingerprint_results.assessment_id fingerprint_results_assessment_id_fkey R
header_probes.assessment_id header_probes_assessment_id_fkey R
ramp_steps.assessment_id ramp_steps_assessment_id_fkey R
waf_detections.assessment_id waf_detections_assessment_id_fkey R

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

Relationships