I’m building a website for novels. Where each novel has chapters, but you can refresh the novel to get the latest chapters. There also a page to show the latest updates from your library novels.
When ever you view a novel, it get saved to the datebase with all the chapters metadata except the chapters content, so when you visit the saved novel again you get the saved novel without fetching for the novel.
The question is do I make a separate table updates for the the latest chapters? Or make an empty updated_at column in the chapters table that is null and only updated chapters has it as date?
the updates approach diagram: dbDiagram
the chapters updated_at approach diagram: dbDiagram