When an item is created and owned by a user, but can be shared with other users; what would be the best way to do that?
I was thinking:
posts - id - owner_id - etc. post_user - id - post_id - user_id
posts to save the owner of the post, and users the post is shared with are stored in the
post_user pivot table.
I think storing a record for the owner in
post_user too, would be helpful in keeping querying easier.