Deployguard

Tables (13)

analysis_jobs

  • id — UUID
  • cluster_id — UUID — Foreign key → clusters.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

attack_path_edges

  • id — UUID
  • attack_path_id — UUID — Foreign key → attack_paths.id — NOT NULL
  • source_node — VARCHAR(500) — NOT NULL
  • target_node — VARCHAR(500) — NOT NULL

attack_path_nodes

  • id — UUID
  • attack_path_id — UUID — Foreign key → attack_paths.id — NOT NULL
  • node_id — VARCHAR(500) — NOT NULL
  • position — INTEGER — NOT NULL

attack_paths

  • id — UUID
  • graph_id — UUID — Foreign key → graph_snapshots.id — NOT NULL
  • risk_score — FLOAT — NOT NULL
  • length — INTEGER — NOT NULL
  • entry_node — VARCHAR(500)
  • target_node — VARCHAR(500)

clusters

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • cluster_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

facts

  • id — UUID
  • scan_record_id — UUID — Foreign key → scan_records.id — NOT NULL
  • fact_type — VARCHAR(100) — NOT NULL
  • subject_id — VARCHAR(500) — NOT NULL
  • subject_type — VARCHAR(100) — NOT NULL
  • object_id — VARCHAR(500) — NOT NULL
  • object_type — VARCHAR(100) — NOT NULL
  • metadata — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

graph_edges

  • id — UUID
  • graph_id — UUID — Foreign key → graph_snapshots.id — NOT NULL
  • source_node_id — VARCHAR(500) — NOT NULL
  • target_node_id — VARCHAR(500) — NOT NULL
  • edge_type — VARCHAR(100) — NOT NULL
  • metadata — JSONB — NOT NULL

graph_nodes

  • id — UUID
  • graph_id — UUID — Foreign key → graph_snapshots.id — NOT NULL
  • node_id — VARCHAR(500) — NOT NULL
  • node_type — VARCHAR(100) — NOT NULL
  • attributes — JSONB — NOT NULL

graph_snapshots

  • id — UUID
  • cluster_id — UUID — Foreign key → clusters.id — NOT NULL
  • k8s_scan_id — VARCHAR(255)
  • aws_scan_id — VARCHAR(255)
  • image_scan_id — VARCHAR(255)
  • node_count — INTEGER — NOT NULL
  • edge_count — INTEGER — NOT NULL
  • entry_point_count — INTEGER — NOT NULL
  • crown_jewel_count — INTEGER — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

recommendations

  • id — UUID
  • graph_id — UUID — Foreign key → graph_snapshots.id — NOT NULL
  • description — TEXT — NOT NULL
  • risk_reduction — FLOAT — NOT NULL

runtime_events

  • id — UUID
  • cluster_id — UUID — Foreign key → clusters.id — NOT NULL
  • event_type — VARCHAR(100)
  • source — VARCHAR(500)
  • target — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

scan_records

  • id — UUID
  • scan_id — VARCHAR(255) — NOT NULL
  • cluster_id — UUID — Foreign key → clusters.id — NOT NULL
  • analysis_run_id — UUID — Foreign key → analysis_jobs.id
  • scanner_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • s3_keys — JSONB — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

validation_reports

  • id — UUID
  • scan_record_id — UUID — Foreign key → scan_records.id — NOT NULL
  • severity — VARCHAR(50)
  • message — TEXT
  • resource_type — VARCHAR(100)
  • resource_id — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL