One ha
Tables (5)
pentest_session
- id — uuid — Primary key — NOT NULL
- run_id — varchar — NOT NULL
- target_url — varchar — NOT NULL
- model — varchar — NOT NULL
- backend — varchar — NOT NULL
- write_mode — varchar — NOT NULL
- evidence_disclosure_mode — varchar — NOT NULL
- max_turns — int4 — NOT NULL
- cost_limit — float8 — NOT NULL
- status — varchar — NOT NULL
- created_at — timestamptz — NOT NULL
- started_at — timestamptz
- finished_at — timestamptz
- error — text
- success — bool
- total_turns — int4
- total_cost_usd — float8
- session_stats — jsonb
- run_manifest — jsonb
- errors — jsonb
- ptg_summary — jsonb
- request_json — jsonb — NOT NULL
- result_json — jsonb
recon_endpoint
- id — uuid — Primary key — NOT NULL
- session_id — uuid — NOT NULL
- seq — int4 — NOT NULL
- url — varchar — NOT NULL
- method — varchar — NOT NULL
- function_type — varchar
- auth_required — varchar
- technology — varchar
- discovered_by — varchar
- response_status — int4
- raw — jsonb — NOT NULL
recon_evidence
- id — uuid — Primary key — NOT NULL
- session_id — uuid — NOT NULL
- seq — int4 — NOT NULL
- type — varchar — NOT NULL
- vuln_type — varchar
- confidence — float8 — NOT NULL
- source_action — varchar
- evidence_state — varchar
- raw — jsonb — NOT NULL
recon_state
- id — uuid — Primary key — NOT NULL
- session_id — uuid — NOT NULL
- technology_stack — _text — NOT NULL
- security_headers — jsonb — NOT NULL
- recon_discoveries — jsonb — NOT NULL
- nmap_completed — bool — NOT NULL
- recon_completed — bool — NOT NULL
report
- id — uuid — Primary key — NOT NULL
- session_id — uuid — Foreign key → pentest_session.id — NOT NULL
- format — varchar — NOT NULL
- content — text — NOT NULL
- created_at — timestamptz — NOT NULL