need some ideas
Posted: Fri Aug 31, 2007 7:36 pm
I am creating a page where each user can sign in and check his/her email...
What is the best way to go about implementing this procedure? Obviously I cannot store all the messages sent between users in 1 table, because if 1 user delete his emails, it wont be available for the other user to view.
This is something normal that most websites have ..just sending messages to each other ...inbox, outbox etc..
question is...should i create 2 tables with identical tuples in both tables? or should i create 1 table with duplicated tuples? a tuple is a row in a DB by the way.
Any help will be gladly appreciated. Thanks!
What is the best way to go about implementing this procedure? Obviously I cannot store all the messages sent between users in 1 table, because if 1 user delete his emails, it wont be available for the other user to view.
This is something normal that most websites have ..just sending messages to each other ...inbox, outbox etc..
question is...should i create 2 tables with identical tuples in both tables? or should i create 1 table with duplicated tuples? a tuple is a row in a DB by the way.
Any help will be gladly appreciated. Thanks!