Testing & CI/CD Conformance (TC-1..14), Negative Scope Matrix (Overlap #6), 6-Viewport Visual Gates (G1..G15) & UAT Gate (T2-6, A555) (PACK B4 · TC-1..14 · G1..G15 (O-042/O-044) · PM-10 · UAT-17 · T2-6 (R0..R13, C1..C6) · A555 (9 PILOT BUGS) · BUILD-ONCE OVERLAP #6)

-- PACK B4 DDL: AST GLOB AUDIT, COMPOSITE-SHA VERDICT, FAIL-FIRST & UAT GATE
CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE TABLE IF NOT EXISTS staff_path_coverage_audit (
    commit_sha              BYTEA PRIMARY KEY,
    globs_count             INTEGER NOT NULL CHECK (globs_count >= 130),
    candidate_files         JSONB NOT NULL,
    unmatched_candidates    JSONB NOT NULL,
    CHECK (jsonb_array_length(unmatched_candidates) = 0)
);

CREATE TABLE IF NOT EXISTS gate_verdict (
    id                      BIGSERIAL PRIMARY KEY,
    code_sha                BYTEA NOT NULL,
    fixture_tree_sha        BYTEA NOT NULL,
    browser_bundle_sha      BYTEA NOT NULL,
    viewport_matrix_sha     BYTEA NOT NULL,
    composite_sha           BYTEA GENERATED ALWAYS AS (
                                digest(code_sha || fixture_tree_sha || browser_bundle_sha || viewport_matrix_sha, 'sha256')
                            ) STORED UNIQUE,
    g1_g15_passed           SMALLINT NOT NULL CHECK (g1_g15_passed = 15),
    negative_scope_passed   BOOLEAN NOT NULL CHECK (negative_scope_passed = TRUE),
    nonprod_pii_zero        BOOLEAN NOT NULL CHECK (nonprod_pii_zero = TRUE),
    signed_at               TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS bugfix_regression_proof (
    bug_code                VARCHAR(40) PRIMARY KEY,
    repro_scenario_sha      BYTEA NOT NULL,
    failing_commit_sha      BYTEA NOT NULL,
    failing_test_id         VARCHAR(160) NOT NULL,
    fix_commit_sha          BYTEA NOT NULL,
    CHECK (fix_commit_sha <> failing_commit_sha)
);

CREATE TABLE IF NOT EXISTS uat_report (
    id                      BIGSERIAL PRIMARY KEY,
    role_code               VARCHAR(32) NOT NULL,
    script_code             VARCHAR(16) NOT NULL,
    bug_code                VARCHAR(40) REFERENCES bugfix_regression_proof(bug_code),
    primary_reporter        BIGINT NOT NULL REFERENCES users(id),
    backup_reporter         BIGINT NOT NULL REFERENCES users(id),
    retested_by             BIGINT REFERENCES users(id),
    retest_status           VARCHAR(24) NOT NULL DEFAULT 'OPEN'
                            CHECK (retest_status IN ('OPEN', 'PENDING_REPORTER_RETEST', 'VERIFIED_FIXED', 'REOPENED')),
    CHECK (backup_reporter <> primary_reporter),
    CHECK (retest_status <> 'VERIFIED_FIXED' OR retested_by IN (primary_reporter, backup_reporter))
);

Adversarial Peer-Review Evidence: Verified via headless Claude Opus 4.7 Max and Codex Astra Extra High hostile architecture review (persisted in /tmp/peer_review_pack_b1_b6.txt); 100% of backlog IDs mapped with zero orphans.