DavidM
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.
Most Liked
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 on profiles instead, and the dependency structure is better (users don’t know about profiles, but profiles know about users)
stefanchrobot
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.
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"