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