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
Bumble
Bumble8mo ago
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.
Want results from more Discord servers?
Add your server