Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Unique identifier for each visit log entry; generated UUID.”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.229947541+00:00”} |
||
| domain | text | 2147483647 | null |
|
|
{“what”:“Domain name of the visited site, e.g., example.com.”,“why”:“Identifies which site the visit pertains to; needed for per-domain analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.268621237+00:00”} |
||
| url | text | 2147483647 | null |
|
|
{“what”:“Full URL of the visited page, including scheme and path.”,“why”:“Distinguishes visits to different pages on the same domain; needed for page-level metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.283277493+00:00”} |
||
| source | text | 2147483647 | 'screenrhythm'::text |
|
|
{“what”:“Origin of the visit, e.g., ‘screenrhythm’ or other automation source.”,“why”:“Separates visits by automation context; without it, results from different sources mix.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.295600924+00:00”} |
||
| tier_applied | int2 | 5 | √ | null |
|
|
{“what”:“Numeric tier level (e.g., 1-3) assigned to the visit based on rules.”,“why”:“Records which tier’s settings were used; needed to correlate outcomes with tier.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.323463497+00:00”} |
|
| profile_used | text | 2147483647 | √ | null |
|
|
{“what”:“Name or identifier of the browser profile used for the visit.”,“why”:“Identifies which profile’s cookies and fingerprint were used; needed to reproduce or debug.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.339590031+00:00”} |
|
| status_code | int2 | 5 | √ | null |
|
|
{“what”:“HTTP status code returned by the server, e.g., 200, 403.”,“why”:“Indicates success or failure of the request; without it, cannot detect blocks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.363642297+00:00”} |
|
| was_challenged | bool | 1 | false |
|
|
{“what”:“Whether the visit encountered a challenge (e.g., CAPTCHA) during load.”,“why”:“Flags visits that may require manual intervention or retry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.400111890+00:00”} |
||
| challenge_type | text | 2147483647 | √ | null |
|
|
{“what”:“Type of challenge encountered, e.g., ‘captcha’, ‘turnstile’.”,“why”:“Specifies which challenge mechanism was triggered; needed to tailor bypass strategies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.431323800+00:00”} |
|
| int2 | 5 | 0 |
|
|
{“what”:“Number of cookies set after the visit.”,“why”:“Indicates tracking or session state; without it, cannot assess cookie-based fingerprinting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.453906485+00:00”} |
|||
| content_length | int4 | 10 | 0 |
|
|
{“what”:“Size of the response body in bytes.”,“why”:“Helps detect empty or blocked pages; zero may indicate a challenge page.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.482523028+00:00”} |
||
| has_content | bool | 1 | true |
|
|
{“what”:“Whether the page contained meaningful content beyond boilerplate.”,“why”:“Distinguishes successful loads from blank or error pages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.522692482+00:00”} |
||
| content_hash | text | 2147483647 | √ | null |
|
|
{“what”:“Hash (e.g., SHA-256) of the page content for deduplication.”,“why”:“Identifies identical pages across visits; needed to avoid reprocessing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.539752106+00:00”} |
|
| vendor_js_detected | _text | 2147483647 | '{}'::text[] |
|
|
{“what”:“List of JavaScript vendor names detected on the page, e.g., ‘cloudflare’.”,“why”:“Indicates which anti-bot vendors are present; needed to choose evasion tactics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.563778797+00:00”} |
||
| flagged | bool | 1 | false |
|
|
{“what”:“Whether the visit was flagged as suspicious or problematic.”,“why”:“Marks visits that need review; without it, anomalies go unnoticed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.661498180+00:00”} |
||
| flagging_signals | _text | 2147483647 | '{}'::text[] |
|
|
{“what”:“List of signals that triggered the flag, e.g., ‘high_stealth_score’.”,“why”:“Explains why a visit was flagged; needed for debugging and rule tuning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.674573443+00:00”} |
||
| stealth_score | int2 | 5 | √ | null |
|
|
{“what”:“Score (0-100) indicating how detectable the visit was.”,“why”:“Quantifies risk of detection; without it, cannot compare stealthiness across visits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.718387940+00:00”} |
|
| duration_ms | int4 | 10 | 0 |
|
|
{“what”:“Total time taken for the visit in milliseconds.”,“why”:“Measures performance; long durations may indicate timeouts or heavy challenges.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.734486736+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the visit log entry was created.”,“why”:“Provides chronological ordering; needed for time-based analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.755649997+00:00”} |
||
| outcome_known | bool | 1 | false |
|
|
{“what”:“Whether the final outcome (success/failure) has been determined.”,“why”:“Indicates if the visit is still pending or resolved; without it, incomplete records are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.803576711+00:00”} |
||
| correlation_id | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier linking this visit to a broader task or session.”,“why”:“Enables grouping of multiple visits under one operation; without it, related logs cannot be tied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.821408767+00:00”} |
|
| exit_ip | text | 2147483647 | √ | null |
|
|
{“what”:“IP address used when the visit ended.”,“why”:“Records the exit IP; needed to detect IP rotation or leaks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.838459319+00:00”} |
|
| instance_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the server or worker instance that executed the visit.”,“why”:“Identifies which machine handled the visit; needed for debugging distributed issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.860267358+00:00”} |
|
| detect_version | int4 | 10 | 1 |
|
|
{“what”:“Version number of the detection logic used for this visit.”,“why”:“Tracks changes in detection algorithms; without it, results across versions are incomparable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.883242775+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| visit_log_pkey | Primary key | Asc | id |
| idx_visit_log_correlation | Performance | Asc | correlation_id |
| idx_visit_log_created | Performance | Desc | created_at |
| idx_visit_log_detect_version | Performance | Asc | detect_version |
| idx_visit_log_domain | Performance | Asc | domain |
| idx_visit_log_flagged | Performance | Asc | flagged |