What flaws might be present in my chat database design?
I have designed a chat(in .net) database design(in mysql) and i am not too
sure if its gonna survive in long run. This is meant for a chat which has
features same as facebook have.
My tables and column would be like this: Each table consists 7 default
columns other than the ones mentioned below, and the default columns are
present in all tables, the default column are: 1>timestamp column
2>active/inactive column 3>added by/ modified by 4>added by
datetime/modified by datetime 5>ip_address 6>mac_address 7>identity column
and the tables are
Tables Columns
Chat_session_detail Session_id (Remarks:1 session means when the 1st user
sends the 1st message and the session ends when the user exit the chat
box)
Chat_session_user_detail Session_id member_id(Remarks:all members tagged
in the chat session)
chat_message_detail Session_id message_id message
Chat_attachment_detail message_id attachment_file_type(Remarks:if message
is smiley or audio file or any other files) attachment_path
chat_receiver_detail message_id receiver_id
No comments:
Post a Comment