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