Use the user_email as the user_id evrywhere
Since we require emails to be unique, they're in fact a perfectly viable primary key. We should use users.email as a foreign key instead of users.id in table which requires a link to the user.
It would simplify the schema and some wueries, and it will makes more sense to do it this way.