waf_detections


Description

{“what”:“A row per WAF detection event, linked to an assessment.”,“why”:“Without it, WAF findings would be lost and cannot be correlated with assessment results.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:57.861768430+00:00”}

Columns

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

{“what”:“UUID primary key, auto-generated for each detection.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:57.880486296+00:00”}

assessment_id uuid 2147483647 null
assessments.id waf_detections_assessment_id_fkey R

{“what”:“UUID referencing the assessment under test.”,“why”:“Without it, detections cannot be linked to a specific assessment, making analysis per assessment impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:57.944984915+00:00”}

waf_name text 2147483647 null

{“what”:“Identifier of the WAF product that produced the detection.”,“why”:“Without it, the source WAF is unknown, preventing comparison across WAFs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:57.993783521+00:00”}

confidence float4 8,8 null

{“what”:“Numeric confidence score, higher means more likely a true positive.”,“why”:“Without it, the reliability of the detection cannot be assessed, leading to false positives being treated equally.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.368543294+00:00”}

evidence jsonb 2147483647 null

{“what”:“JSON object with raw request/response details from the WAF.”,“why”:“Without it, the detection cannot be investigated or reproduced, losing forensic value.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.489472462+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with timezone when the detection was logged.”,“why”:“Without it, the order and timing of detections is unknown, hindering temporal analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.685802568+00:00”}

Indexes

Constraint Name Type Sort Column(s)
waf_detections_pkey Primary key Asc id
idx_waf_assessment Performance Asc assessment_id

Relationships