Social Network Schema and the Home Timeline Query

Social Network Schema and the Home Timeline Query An architecture diagram generated by Archify. users · PK user_id, name · Architecture component users PK user_id, name posts · PK post_id, FK sender_id, ts · Architecture component posts PK post_id, FK sender_id, ts follows · FK follower_id, FK followee_id · Architecture component · join table follows FK follower_id, FK followee_id join table Home Timeline · recent posts of followees · Architecture component · derived view Home Timeline recent posts of followees derived view 1..N writes 1..N follower N..1 followee JOIN follows JOIN posts Legend Database