The correct way to add additional columns into `users` table

I have used phx.gen.auth to create User schema and the Accounts context. The table is the standard: users.

I would like to add one additional column user_profile_id (integer) into the users table to link to the users_profile table with additional user info.

My question is what is the standard/official suggested way to do it. Can it be done via manually editing files only using the mix command? Perhaps making sure of taking care of the orphans in users_profile when deleting the user?

Thanks in advance.