Create a relation between the users table and the characters table using matching data (email or userID). Create a user specific “notes” column that will allow any user to have their own notes for any character. Point a notes component to this column.
If you’re not familiar with relations, this video will help: