I just finished my bootcamp and started to do my own project.
My project is task managing app, that has monthly, weekly, daily goals.

I want users to set a monthly goal, and to achieve that, set weekly goals and to achieve them, daily goals. So for example, goals are as below:

1. monthly : Create a task management app
2. weekly : Week 1 – Complete BackEnd
3. daily : Day 1 – Define Problems/Target/Solution, Day 2 – Define DB schema routes, Day 3 – blah blah

I want the progress of daily goals are reflected in weekly and monthly progress as well, so relation between them are necessary.

In this case, I think there are two different ways to set db schema; one is having separated tables for monthly, weekly, daily goals. The other is having a single table with a self-referencing foreign key.

In terms of efficiency, I cannot judge which one is more efficient cause I am only at the beginner level. But I want to work in a efficient way.

Can somebody help me to know which one is more efficient ? (I will be working with ruby on rails for my project)

Thank you in advance.