Unfortunately you’ll have to handle this on your own depending on your scenario.
There are some Pow guides that you may find useful though:
There is a thread I read long time ago on how to design user table and profile infos on the forum but I’m not finding it right now…
If I find it I will post it here. It was discussed many ways to store roles and account infos. For example One could even use an ecto migration
:map type to store them in the user table but it is not perfomant if you’re planning running queries against it…
In my case what I do is just adding a profile table per role and keep a role field in the user table. But this works only because i have few roles and each user has just one role. So if I have for example the roles
author I will have the profile tables of the same names to store role specific infos. If a role does not need specific additionnal infos apart from the common infos stored in the user table I won’t create a profile table for it. If another table need a user with a specific role as reference to a
foreign_key, I will also need a profile table. for example an
author_id for a blog post.
For now at least this works for my projects needs…