again I basically know the minimum about databases and more or less punt on this stuff. It sounds like I have 2 options (I'm using the Mongoose ORM btw)
A collection where my schema looks like this
Code:
{
userNameWhoOwnsTheNote,
notedUser,
note
}
which of course results in multiple rows/entries or
Code:
{
userName'sNotes,
noteDetails: Array of objects/assoc. arrays that are userNameBeingingNoted: note
}
is one better than the other? does it matter?