This blog post series is an absolute classic read on the topic. https://ericlippert.com/2015/04/27/wizards-and-warriors-part...
Take your best guess at what you will need later, but know you're guaranteed to be wrong because different products have different needs at different times and code for the future version of you that has to rewrite your persistence later.