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