Hello everybody,
We have application which needs 4 kind of roles(manager, consumer, etc..). We already have user table, but now we need to have other fields which is specific to roles. For example user has 3 more fields but those fields are completely different from other roles fields.
Lets say
Manager Extra fields are SName, Phone, Fax. and Consumer Extra fields are imagePath, year, services, comments, phone and fax and other 2 roles has 3 more fields.
So i have a doubt that how should i create the tables in backend. shall i create one table and maintain all the role based profile and have roleID in this? or shall i create 4 table and maintain role based profile?
Please put your suggestion on this. Thanks to all.
...
Go to the complete details ...