I have developed a reduced version Facebook posting database schema. I'm just wonder whether I am doing it correct or not. Could some help me take a look and give me some comments?
Condition:
1. Email address can be used for one registration.
2. Posting is composed of a text and images up to maximum 5.
3. User can reply to a comment or reply.
4. Comment can be liked but not be commented further.
5. A user can only like a comment once.
6. Post_id is unique.
Registered User (User id, User_name, User_email_address, password)
User Profile (User id, Picture id)
User’s friend (User id, User id)
Posting (Post id, Post_text_message, User_id, Post_date_time)
Image in post (Post Id, Image id, User_id)
Image (Image id, Image _link)
Comment (Comment id, Post id, User_id, Comment_date_time, Comment_text_message)
Reply to comment (Reply comment id, Comment id, Post id, User_id, Reply_comment_date_time, Reply_comment_text_message)
Reply to reply (Reply_id, Reply_comment_id, User_id, Reply_to_reply_date_time, Reply_to_reply_text_message)
Like a posting (Posting id, Like user id)
Like a comment (Posting id, Like user id)
Like a reply (Reply comment id, Like user id)
