مخطط قواعد بيانات مجتمع حسوب

الهيكلة الأساسية ستكون على نحو كهذا:

users table
=============
id
name
email
password
created_at
updated_at
...

posts table
=============
id
type // link or post
title
link // link if type equal link or null if type equal post
body
user_id // foreign key form users table
created_at
updated_at
...

comments table
=============
id
comment
user_id // foreign key form users table
post_id // foreign key form posts table
created_at
updated_at
...

messages table
==============
id
title
body
sender_id // foreign key form users table
reciver_id // foreign key form users table
created_at
updated_at
...

message_replies
===============
id
body
status
message_id // foreign key form messages table
sender_id // foreign key form users table
reciver_id // foreign key form users table
created_at
updated_at
...

post_votes table
===============
id
voit
user_id // foreign key form users table
post_id // foreign key form posts table
...

comment_votes table
===============
id
voit
user_id // foreign key form users table
post_id // foreign key form posts table
...

notifations table
================
id
title
link
status
user_id // foreign key form users table
created_at
updated_at
...