nexarch/migrations/0020_user_migration_map.up.sql

-- COR-02: Referenztabelle fuer freigegebene Benutzer-Zusammenfuehrungen,
-- analog zu tenant_migration_map (COR-01). Nur genehmigte Zeilen
-- (approved_at gesetzt) werden von COR-02 uebernommen.
CREATE TABLE user_migration_map (
    id                   BIGSERIAL PRIMARY KEY,
    archivmail_user_id   BIGINT,
    archivdms_user_id    BIGINT,
    nexarch_tenant_id    UUID NOT NULL REFERENCES tenant_migration_map(nexarch_tenant_id),
    nexarch_user_id      UUID NOT NULL UNIQUE,
    email                TEXT NOT NULL,
    name                 TEXT NOT NULL,
    password_hash        TEXT NOT NULL,
    approved_by          TEXT,
    approved_at          TIMESTAMPTZ,
    created_at           TIMESTAMPTZ NOT NULL DEFAULT now(),
    CONSTRAINT user_migration_map_source_present
        CHECK (archivmail_user_id IS NOT NULL OR archivdms_user_id IS NOT NULL)
);