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

The whole point of phx.gen.auth and other generators is that they provide a starting point. After running the command, you can and should edit the code to fit your needs. The drawback is that you’ll have to manually backport any modifications to the generators that you’d like to bring to the already generated code - re-running the generators most probably won’t work.

Regarding the design - it depends on your app, I guess. But you can delete profiles which will cascade to users, if that makes sense.