You can simply drop `NOT NULL`

    ALTER TABLE app_client_users ALTER COLUMN client_id DROP NOT NULL;