RecoilUK Posted July 11, 2008 Share Posted July 11, 2008 Hi guys I,m trying to design a user management database schema but it really has gotta be one of the hardest subjects to get your head around, or atleast I find that. I,m looking for anything at all, that you think could help, this is subject that I keep coming back to because I just cant decide on whats best, what will work, what wont, so I keep falling at the first hurdle as it were. Any help you can give would be appreciated. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/114341-user-management-help/ Share on other sites More sharing options...
RecoilUK Posted July 12, 2008 Author Share Posted July 12, 2008 Hi Again This is what I have come up with so far. I think its going to need a group table also, because the roles are quickly going to become to numerous to manage even on a basic site, so I am going to need a way of grouping roles for easy maintenance. Suggestions always welcome. Thanks [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/114341-user-management-help/#findComment-588349 Share on other sites More sharing options...
Liquid Fire Posted July 12, 2008 Share Posted July 12, 2008 Just wondering, what tool did you use to make the diagram Quote Link to comment https://forums.phpfreaks.com/topic/114341-user-management-help/#findComment-588389 Share on other sites More sharing options...
RecoilUK Posted July 12, 2008 Author Share Posted July 12, 2008 Hi Its MySQL Workbench. http://www.mysql.com/products/workbench/. Click on LEARN MORE at the bottom of the page for download and version info. L8rs Quote Link to comment https://forums.phpfreaks.com/topic/114341-user-management-help/#findComment-588451 Share on other sites More sharing options...
RecoilUK Posted July 12, 2008 Author Share Posted July 12, 2008 Hi Here is version number 2. Now i,m not sure how workable this is, as my queries up until now, whilst I have been learning php, have been limited to single tables, no experience of writing join queries at all. Hence the reason I would like someone with some experience to comment. Thanks [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/114341-user-management-help/#findComment-588463 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.