#Sharing ID between models good or bad practice?

4 messages · Page 1 of 1 (latest)

chrome harbor
#

If you are sharing IDs, that indicates that it could all be 1 table

#

If you really want them separate, I supposed you could share IDs. I don't see a problem. No strong feeling on it.

neat folio
#

Hmm, well one example is the role specific tables.

I have 3 role specific tables: Student, Staff and Guardian. These all point to User table, but there will only be one of them attached to a user, as user can be only one role.

The rational is if I run a report on Users, and then want to get a list of Students that were in the list of users, I can just find students where ID is user id.

#

Do you think it would make sense to just keep all of that data in one table instead?