DavidM
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.
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
al2o3cr
Does the column have to live on
users? It’s a lot easier to enforce constraints like “every profile must have a user” if it’s onprofilesinstead, and the dependency structure is better (users don’t know about profiles, but profiles know about users)DavidM
Thanks. Why do you think it is better? I see more conflicts down the line using your suggestion.
Your suggestion makes sense for user has many profiles, which is not the case.
For example, if you delete a user how would the DB know which user_profile to delete if there is no reference to the users_profile table at all?
Don’t get me wrong, but I would strongly prefer the “pointer to the profile” solution.
stefanchrobot
The whole point of
phx.gen.authand 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.