Hey,
I am working on a time tracking application. In the app the team can create entry’s in a calendar view and block the time they have worked. In a database that has all weeks inside I already show how much time they have worked this week and so on.
But I think the best approach is to work as a basis with a database that has all days inside. I am now not sure about the approach how to create a table with all days inside:
- it will be very huge at the end. So I choose a big table?
- Is there an option how it can grow automatically? Or how can I do it? For example that it is always 1 year from now and is adding the rows automatically? Or do I have to do that manually?
- Does anyone has any other suggestions for such a use case? I don’t need a tracking „time entries“ are ok. But it is important that it works without any failure also 1 year late
- This big table will then with user specific columns right? So that I can for example say vacation true in a user field, when someone is in vacation on a specific day
Thanks for your help
Andi