table schema admins table
Is it better to have a table for admins a table for moderators and a tabble for users, or have just one table "users" and an enum type with User, admin and moderator ?
1 Reply
I would actually make both. Having a separate table for each role makes it flexible to add more columns to each role individually. Also having one large table means you could share common columns like name, image, etc.
In the end, it depends on your app and what it requires.