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 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? 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) 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 >------------------------+ Link to comment https://forums.phpfreaks.com/topic/60526-help-in-db-design/#findComment-302663 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.