I feel like this must have been asked before, but I haven’t been able to find anything, so here is the question:
I am trying to determine the best way to build out a data structure where individual users can add new records based on a centralized “Master List”, but can then also add unique data that should only be seen by that user (or group of users).
For example, say I have a book club. The book club wants to add a book to their “reading list”, and to avoid a duplication of data, we want to have a master list of book (Goodreads for example). This will pull in details about the book (title, cover art, description, etc) however, the book club members then also want to be able to add their own commentary that shouldn’t be visible to anyone outside of the book club.
The way that I’ve thought of this so far is that I need make a ‘Book’ data type that would hold things like title, description, etc. for the individual books, then have another data type (such as ‘Our Books’) that then references those values and holds the additional unique data that only the members of the book club can see.
Is this the best way to go about this, or is there a way to permission scope data on a record not to a particular role (permission), but instead to a given group of users within the system (such as the book club in this example)?
Hope that makes sense.