How to share something from an user like FB

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Wed, 27 Feb 2019 09:33:53 +0100
Message-ID: <q55i1h$pjo$1_at_gioia.aioe.org>

I got these tables

USERS

---

id_user
name

HOBBIES

---

id_hobby
name
FK_id_user

SHARINGLISTS

---

id_sharinglist
name (Only_me,Crew,Public,Deny)

USERSHARES

---

[Quoted] id_usershare
FK_master_user (linked to USERS)
FK_slave_user (linked to USERS)
FK_id_sharinglist

I'd like to do something like what happen in Facebook so every user should be able to add his hobbies, he could share his page just with himself (Only_me), with a crew of friends (Crew) or to everyone (Public) and obviously deny his page to someone.

I don't understand what I should store in my tables or if I need other tables or different fields...

Regards.
^Bart Received on Wed Feb 27 2019 - 09:33:53 CET