visit_log


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”}

cookie_count 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

Relationships