Enablement Registry (EN-01..19), Counts-Only Telemetry, V0–V4 Value Ledger & Zero-PII Slot-Validated AI Gateway (AI-01..12) (PACK B3 · EN-01..19 · AI-01..12 · VALUE-LEDGER V0..V4 · A507/A308 · BO-LEARN · BO-DEMO-USER · BO-BAKEBOT-SIDE · OVERLAP #5 CONSUMER)

-- PACK B3 DDL: ENABLEMENT REGISTRY, VALUE LEDGER & ZERO-PII AI GATEWAY
CREATE SCHEMA IF NOT EXISTS hop;

CREATE TABLE IF NOT EXISTS setup_registry_enablement (
    feature_key             VARCHAR(80) NOT NULL,
    role_code               VARCHAR(40) NOT NULL DEFAULT 'ALL',
    outlet_cohort           VARCHAR(40) NOT NULL DEFAULT 'ALL',
    ui_surface_enabled      BOOLEAN NOT NULL DEFAULT FALSE,
    event_pipeline_enabled  BOOLEAN NOT NULL DEFAULT TRUE,
    snapshot_valid_until    TIMESTAMPTZ NOT NULL DEFAULT (NOW() + INTERVAL '15 minutes'),
    PRIMARY KEY (feature_key, role_code, outlet_cohort)
);

CREATE TABLE IF NOT EXISTS kill_switch_action (
    id                  BIGSERIAL PRIMARY KEY,
    switch_name         VARCHAR(64) NOT NULL,
    requested_by        BIGINT NOT NULL REFERENCES users(id),
    requested_at        TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    co_signed_by        BIGINT NOT NULL REFERENCES users(id),
    co_signed_at        TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    active              BOOLEAN NOT NULL DEFAULT TRUE,
    CHECK (co_signed_by <> requested_by),
    CHECK (co_signed_at BETWEEN requested_at AND requested_at + INTERVAL '15 minutes')
);

CREATE TABLE IF NOT EXISTS ai_cost_counter (
    user_id             BIGINT NOT NULL REFERENCES users(id),
    day_ist             DATE NOT NULL DEFAULT ((NOW() AT TIME ZONE 'Asia/Kolkata')::DATE),
    calls_count         INTEGER NOT NULL DEFAULT 0 CHECK (calls_count BETWEEN 0 AND 20),
    spend_paise         INTEGER NOT NULL DEFAULT 0 CHECK (spend_paise BETWEEN 0 AND 5000),
    PRIMARY KEY (user_id, day_ist)
);

CREATE TABLE IF NOT EXISTS ai_response_fact (
    response_id                     UUID NOT NULL,
    slot_label                      VARCHAR(120) NOT NULL,
    number_value                    NUMERIC(14,2) NOT NULL,
    source_query_sha                BYTEA NOT NULL,
    source_row_pk                   JSONB NOT NULL,
    source_dimension_fingerprint    BYTEA NOT NULL,
    PRIMARY KEY (response_id, slot_label)
);

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.