Suppose I have a site about books and authors, and users can leave
comments on either a book or an author.
I’d want to have a table called “comments”, which could belong to either
an author OR a book.
In my structure I wouldn’t be sure whether to include an “author_id” or
a “book_id”, or both.
What would be the best way to handle this relationship?
Thanks in advance for any help,