You store the entire universe or whatever reporting requirement demand. You define the database structure based on the requirements of your business logic.

The frontend requirements can help define what api's are required but if you treat your database as dumping tables you limit what your data can do.

You add can add and remove indexes at any point. If you made a bad decision or no decision you would add those when more information is available.