Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote -1 down vote favorite

I have to make a simple "ToDo"-Application, based on PHP and MySQL. I use CodeIgniter as framework. I wanna do the following things:

  • Create ToDos
  • Show ToDos
  • Complete ToDos
  • Repeating Todos

I don't have problems with the first 3 points, but for the "repeating todos" I don't know how the database schema should look like. Can I handle this with only one table? Or do I need more tables?

share|improve this question
Read this first: martinfowler.com/apsupp/recurring.pdf – Neil McGuigan Feb 19 at 18:38

closed as not a real question by Mark Storey-Smith, RolandoMySQLDBA, Paul White, dezso, Jon Seigel Feb 20 at 14:13

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

I believe there are so many ways to the solution, for example you can add a repeat/recuring field to the tbl_todo table in your db.

Create another table and maybe call it tbl_todorepeat and add;

  • todoid => Unique ID for your todo's

  • tododays => The days you want to repeat the todo i.e (Monday, Wednesday)

  • todotime => The time you want the to do to repeat.

Give it try and see how it turns out and let me know if you have any problem.

Goodluck!

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.