samedi 14 décembre 2019

users with multiple roles and naming convention in database design

I have a users table with multiple roles like students and teachers. What should I call the users in other tables, user or student?

For example in programs table which is better:

create programs table
int teacher_id

OR

create programs table
int user_id     // That user id means teacher's user id!

Aucun commentaire:

Enregistrer un commentaire