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