Structure of a database


this database structure above allows me to follow the execution time of tasks by a set of freelancers
is it really suitable?
if I want to add up the time spent by each freelancer I have to survey each date can be in vain?

1 Like

Why not add the duration.

Now you have start and end, so before you save them, calculate the duration and store it with the other two. so for each entry you will have:

  • start
  • end
  • duration

When you want to see the total time spent, only add the duration for each entry.

1 Like

You could even save a list of just durations if that’s easier. Or, when adding a new time, add the duration to a running total for the user perhaps?

Depends on the use case as to a best solution.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.