数据库设计-朋友活动

friendshipid, userid, friendid, confirmed

SELECT act.*
FROM Activities AS act
    INNER JOIN
    Friendships AS fs
    ON fs.friendid = act.userid
        AND fs.user_id = 'logon_user_id'
        AND confirmed = TRUE
ORDER BY act.dated DESC
LIMIT 50;

SELECT activities.* 
FROM Activities 
    INNER JOIN Friendships ON userid = friend1 OR userid = friend2 
WHERE activity.userid != [my own id]
    AND confirmed = TRUE
LIMIT 50;