fingerprint_results


Description

{“what”:“A record of a fingerprinting assessment result, including browser and TLS details.”,“why”:“Without it, there is no persistent record of which fingerprints passed or failed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.229841931+00:00”}

Columns

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

{“what”:“Unique identifier for this fingerprint result, generated randomly.”,“why”:“Without it, rows cannot be referenced or updated reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.260741105+00:00”}

assessment_id uuid 2147483647 null
assessments.id fingerprint_results_assessment_id_fkey R

{“what”:“UUID of the assessment this result belongs to.”,“why”:“Without it, results cannot be linked to their parent assessment.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.456177549+00:00”}

webdriver_flag bool 1 √ null

{“what”:“True if the fingerprint was collected under a webdriver automation session.”,“why”:“Without it, automated vs. human sessions are indistinguishable, skewing pass/fail analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.472134779+00:00”}

user_agent text 2147483647 √ null

{“what”:“User-Agent string sent by the client during fingerprinting.”,“why”:“Without it, browser identity cannot be compared to TLS fingerprint or platform.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.538652678+00:00”}

platform text 2147483647 √ null

{“what”:“Operating system or device platform reported by the client.”,“why”:“Without it, platform-specific fingerprint patterns cannot be analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.550773136+00:00”}

tls_ja3_hash text 2147483647 √ null

{“what”:“JA3 hash of the TLS ClientHello packet, a 32-character hex string.”,“why”:“Without it, TLS fingerprint uniqueness cannot be assessed or matched to known browsers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.567706207+00:00”}

tls_matches_firefox bool 1 √ null

{“what”:“True if the TLS fingerprint matches a known Firefox profile.”,“why”:“Without it, Firefox-specific TLS behavior cannot be verified or flagged.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.600647485+00:00”}

browser_data jsonb 2147483647 √ null

{“what”:“JSON object with browser fingerprint attributes such as canvas, WebGL, and fonts.”,“why”:“Without it, browser-level fingerprint details are unavailable for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.616611987+00:00”}

tls_data jsonb 2147483647 √ null

{“what”:“JSON object with TLS handshake details like cipher suites and extensions.”,“why”:“Without it, TLS fingerprint composition cannot be inspected beyond the JA3 hash.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.645422656+00:00”}

passes bool 1 null

{“what”:“True if the fingerprint passed the assessment’s criteria, false otherwise.”,“why”:“Without it, the assessment outcome is unknown, making pass/fail decisions impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.680088276+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this result was recorded, in UTC.”,“why”:“Without it, result timing cannot be audited or correlated with other events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.709759707+00:00”}

Indexes

Constraint Name Type Sort Column(s)
fingerprint_results_pkey Primary key Asc id
idx_fingerprint_assessment Performance Asc assessment_id

Relationships