MySQL Forums
Forum List  »  General

Re: Help with table design
Posted by: RecoilUK
Date: November 30, 2004 10:51AM

Here is what I have so far....


Modules

module_id *
module_name
module_description


Groups

group_id *
group_name
group_decription


Permissions

permission_id *
permission_name


ModulePermissions

module_id *^
permission_id *^





* = PK
^ = FK



Everything is how it should be, now i,m stuck, how would join the tables to allow a group to have a choice of permissions for a specific module?

I just cant do it.

Thankyou.

Options: ReplyQuote


Subject
Written By
Posted
November 30, 2004 09:35AM
Re: Help with table design
November 30, 2004 10:51AM
November 30, 2004 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.