Support Multiple Emails per Account

[devstein]

Is your feature request related to a problem? Please describe. As a user, I connect multiple emails to a single SRC account, so that I can share my login and job opportunities across them.

Describe the solution you'd like From my account page, I can manage and add additional email accounts.

Describe alternatives you've considered The current 1:1 approach is the alternative.

Additional context Right now, there is a 1:1 relationship between a user_id and an email. We are going to have to create a new table (user_email) that maintains a 1:many relationship between a user and their connected emails.

We will also have to add an additional email column to user_oauth_token to account for multiple emails per (user_id, provider).

[devstein]

For now, we will add the settings as a jsonb column to the user_profile

{
    "[email protected]": {
        "is_active": true,
        "auto_contribute": true,
        "auto_archive": false,
        "enable_allow_list": false,
        "enable_block_list": false
    }
}

[devstein]

It may be better to add it to a separate table. This will help us support "dumb" emails #212

create or replace table user_email (
    user_id uuid,
    email string,
    -- email provider?
    provider string,
    -- sendings are dynamic by provider
    settings jsonb
)