dd_id_redirects

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

✎ View and edit SQL

This data as json

0 records

CREATE TABLE dd_id_redirects (
    old_dd_id        TEXT PRIMARY KEY,
    new_dd_id        TEXT,                  -- NULL allowed when reason='soft_delete'
    reason           TEXT NOT NULL,         -- 'merge' | 'soft_delete' | 'manual_correction'
    merged_at        TEXT NOT NULL,
    unmerged_at      TEXT,                  -- soft un-merge (reversibility)
    resolution_note  TEXT,                  -- 'MANUAL_OVERRIDE: <reason>' for audit
    CHECK (new_dd_id IS NULL OR old_dd_id != new_dd_id)
);
CREATE INDEX idx_redirects_new ON dd_id_redirects(new_dd_id)
    WHERE new_dd_id IS NOT NULL;