drtanz Posted July 18, 2007 Share Posted July 18, 2007 hi i would appreciate some help in designing db tables for the following scenario as i am quite stuck at the moment: I am building this db for a university module reviewing system. There are many modules each having staff assigned to them in different roles, such as internal examiner, moderator, and other examiners. I would therefore want to represent these in tables so that i would be able to extract information about who are the staff members in a particular module and what role they have, or on the other hand display a staff member page featuring his roles in the modules. thanks for the help Quote Link to comment https://forums.phpfreaks.com/topic/60526-help-in-db-design/ Share on other sites More sharing options...
fenway Posted July 18, 2007 Share Posted July 18, 2007 What do you have so far? Quote Link to comment https://forums.phpfreaks.com/topic/60526-help-in-db-design/#findComment-301215 Share on other sites More sharing options...
anatak Posted July 19, 2007 Share Posted July 19, 2007 I would look into the bitwise tutorial http://www.phpfreaks.com/tutorials/151/0.php page 5 shows an example of permissions. This shows what is easily doable for a permission system (role) Quote Link to comment https://forums.phpfreaks.com/topic/60526-help-in-db-design/#findComment-302057 Share on other sites More sharing options...
Barand Posted July 19, 2007 Share Posted July 19, 2007 perhaps [pre] module role staff roletype ======== ========= ========== ============= mod_id ------< mod_id +----- staff_id +--- roletype mod_name staff_id >---+ staff_name | rolename roletype >------------------------+ Quote Link to comment https://forums.phpfreaks.com/topic/60526-help-in-db-design/#findComment-302663 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.