shadiadiph Posted January 11, 2009 Share Posted January 11, 2009 Hi I am creating an email function so users can email each other I have been thinking about this for sometime. I would like peoples opinion on how to approach this is it better to use one table with field inbox sent trash or would it be better to make a table for each one inbox sent trash?? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 11, 2009 Share Posted January 11, 2009 A single table per user-anything is rarely a good idea. Quote Link to comment Share on other sites More sharing options...
shadiadiph Posted January 11, 2009 Author Share Posted January 11, 2009 yep you are right usually when you have almost finished something you realise it won't work and have to start again. Quote Link to comment Share on other sites More sharing options...
dclamp Posted January 11, 2009 Share Posted January 11, 2009 Here is how i set up my tables for messaging: messages (msgID, folderID, toID, fromID, subject, body, timestamp, status) folders (folderID, userID, foldername) Im assuming you already have a users table. Quote Link to comment Share on other sites More sharing options...
shadiadiph Posted January 12, 2009 Author Share Posted January 12, 2009 thanks dclamp i shall have a look into that Quote Link to comment 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.