Scribd
Upload
4 views2 pages

Database Schema for Social Media App

Easy memorizing mind maps

Uploaded by

dhirajporuri4321
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Database Schema for Social Media App

Easy memorizing mind maps

Uploaded by

dhirajporuri4321
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Users Likes

0..1
user_id int like_id int
Posts
*
username varchar 0..1 user_id int
post_id int
*
email varchar * post_id int
user_id int
created_at timestamp created_at timestamp
content text

created_at timestamp

like_count int Comments

comment_id int
*
user_id int
*
post_id int

comment_text text

created_at timestamp
Users Likes
0..1
user_id int like_id int
Posts
*
username varchar 0..1 user_id int
post_id int
*
email varchar * post_id int
user_id int
created_at timestamp created_at timestamp
content text

created_at timestamp

like_count int Comments

comment_id int
*
user_id int
*
post_id int

comment_text text

created_at timestamp

You might also like