search

Noziro / MediaTracker

EXTREME ALPHA STATE. Track all of your media, from movies, to games, anime, books, and more. Official name TBD.
0 stars 0 forks source link

User activity / News feed #13

Open Noziro opened 3 years ago

Noziro commented 3 years ago

News feed can start with site-wide feed updates and later be updated to include friends-only updates and status posts. Ties into #12

Noziro commented 3 years ago

Proposed table structure:

ACTIVITY
========
user_id
type     (e.x began watching, dropped, comment)
media_id (if applicable)
content  (would probably only be used for comments)

You could possibly merge media_id and content, since if you only used media_id for status updates and content for comments, then you would have no overlap and could simply merge them into one. But, if you ever want comment updates that are linked with media, this is not an option.