Designing Intranet Messaging system
Posted: Fri Aug 15, 2008 9:10 am
Hi,
I have to design an intranet messaging system. This is the design i have now.
pvt_msgs
private_message_id
pvt_msg_from_id
pvt_msg_to_id
private_message_subject
private_message
pvt_msg_date
Currently i am not able to messages if a person replies to the message (As it gets updated and the first message will be overwritten by the replied message). Should i have to make a seperate table for messages?
Thanks
I have to design an intranet messaging system. This is the design i have now.
pvt_msgs
private_message_id
pvt_msg_from_id
pvt_msg_to_id
private_message_subject
private_message
pvt_msg_date
Currently i am not able to messages if a person replies to the message (As it gets updated and the first message will be overwritten by the replied message). Should i have to make a seperate table for messages?
Thanks