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