GuardBench

Tables (8)

assertion_result

  • id — BIGINT — Primary key — NOT NULL
  • snapshot_id — BIGINT — Foreign key → test_case_snapshot.id — NOT NULL
  • candidate_execution_id — BIGINT — Foreign key → test_execution.id — NOT NULL
  • assertion_status — VARCHAR(20) — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

comparison_result

  • id — BIGINT — Primary key — NOT NULL
  • snapshot_id — BIGINT — Foreign key → test_case_snapshot.id — NOT NULL
  • baseline_execution_id — BIGINT — Foreign key → test_execution.id — NOT NULL
  • candidate_execution_id — BIGINT — Foreign key → test_execution.id — NOT NULL
  • comparability_status — VARCHAR(30) — NOT NULL
  • change_type — VARCHAR(40)
  • created_at — TIMESTAMPTZ — NOT NULL

quality_gate_result

  • id — BIGINT — Primary key — NOT NULL
  • test_run_id — BIGINT — Foreign key → test_run.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • metrics — JSONB
  • reasons — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

test_case

  • id — BIGINT — Primary key — NOT NULL
  • test_suite_id — BIGINT — Foreign key → test_suite.id — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • input_payload — JSONB — NOT NULL
  • expected_action — VARCHAR(20) — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • category — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

test_case_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • test_run_id — BIGINT — Foreign key → test_run.id — NOT NULL
  • test_case_id — BIGINT — Foreign key → test_case.id — NOT NULL
  • input_payload — JSONB — NOT NULL
  • expected_action — VARCHAR(20) — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • category — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL

test_execution

  • id — BIGINT — Primary key — NOT NULL
  • snapshot_id — BIGINT — Foreign key → test_case_snapshot.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • execution_status — VARCHAR(20) — NOT NULL
  • normalized_result — JSONB
  • error_code — VARCHAR(100)
  • error_message — TEXT
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ

test_run

  • id — BIGINT — Primary key — NOT NULL
  • test_suite_id — BIGINT — Foreign key → test_suite.id — NOT NULL
  • baseline_target — JSONB — NOT NULL
  • candidate_target — JSONB — NOT NULL
  • execution_outcome — VARCHAR(30)
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

test_suite

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL