Tables


SchemaSpy Analysis of botrhythm.public

Generated on Tue Sep 22 22:49 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 19
VIEWS 0
COLUMNS 188
Constraints 6
Anomalies 1
Routines 0

Database Properties

Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
waf_detections 0 1 6 Table

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

fingerprint_results 0 1 11 Table

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

evasion_tests 0 0 11 Table

{“what”:“One row per evasion test run against a target URL, with outcome flags and timing.”,“why”:“Without it, no history of evasion attempts exists, making effectiveness tracking impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:25.744648248+00:00”}

webhook_deliveries 0 1 10 Table
visit_log 0 0 24 Table
header_probes 0 1 13 Table

{“what”:“One row per HTTP probe request, holding response headers and timing.”,“why”:“Enables per-request analysis of rate-limit headers, server identity, and latency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.123210855+00:00”}

discovered_apis 0 1 6 Table

{“what”:“APIs discovered during an assessment; each row is one endpoint.”,“why”:“Without it, discovered endpoints are not persisted, so they cannot be reviewed or tested later.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:14.937001408+00:00”}

ramp_steps 0 1 13 Table

{“what”:“A single load-test step within an assessment, with request counts and response status tallies.”,“why”:“Without it, per-step progress and status breakdowns for an assessment are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:43.204002791+00:00”}

proxy_pool 0 0 10 Table

{“what”:“Registry of proxy servers with connection details and status.”,“why”:“Without it, the system lacks a source of proxy endpoints for routing traffic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:41.579463214+00:00”}

webhooks 1 0 6 Table

{“what”:“HTTP endpoint configurations that receive callbacks for assessment events.”,“why”:“External services would have no way to subscribe to assessment events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:11.860461811+00:00”}

dns_resolutions 0 0 13 Table
stealth_profiles 0 1 7 Table

{“what”:“Profiles that define stealth behavior for a domain at a given tier.”,“why”:“Without it, stealth configurations cannot be stored or retrieved per domain and tier.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.358613341+00:00”}

assessments 5 0 14 Table

{“what”:“A single security assessment run against a target URL.”,“why”:“Without it, scan results have no persistent home and cannot be compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:05.685049921+00:00”}

phase2_done 0 0 3 Table

{“what”:“One row per domain that has completed the phase2 processing step.”,“why”:“Without it, there is no record of which domains have been processed, risking duplicate work.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:22.783242246+00:00”}

tier_costs 1 0 14 Table

{“what”:“Cost and behavior settings for each load-test tier.”,“why”:“Defines the tier parameters used to compute expected resource usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.396670385+00:00”}

needs_browser 0 0 2 Table

{“what”:“Domains that require a browser to access; a registry for browser-dependent sites.”,“why”:“Without it, there is no record of which domains need browser-based access, making routing or proxy decisions ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:49.003315388+00:00”}

cert_run_log 0 0 7 Table

{“what”:“Log of certificate operation runs, one row per attempt.”,“why”:“Without it, no history of certificate checks or failures for auditing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.791320984+00:00”}

execution_log 0 0 9 Table

{“what”:“Log of each execution attempt for an assessment, with phase and outcome.”,“why”:“Without it, there is no audit trail to debug failures or measure performance across runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.263920782+00:00”}

schedules 0 0 9 Table

{“what”:“A recurring job that scans a URL through a sequence of phases.”,“why”:“Without it, there is no definition of periodic scanning tasks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.444659236+00:00”}