Simple Cakephp App To Manage Expenses With Recurring Expenses

[malaiko]

Hi phpFreaks!

I'm starting to learn CakePHP, and for it i decided to build a simple app, and i want your advice.

 

I want to create a simple system to manage my savings and my expenses.

 

I have not done anything, I'm at the stage of designing the database.

The problem is that I want to enter an expense and have the option to repeat this expense (month to month /year to year / etc).

 

I was thinking about doing something like this:

 

Table Types (id_type, str_type)

Table Categories (id_Categories, str_Categories)

Table Records (id_Record, id_type, id_Categories, value, situation (paid / unpaid), date)

 

Now if for example if i add an expense that will be repeated 3 in 3 months, I did not want to save in the database the repeated records because the repeated records dont have a end date to stop repeat.

And for example in 3rd month I want to change the value of this expense, I wanted to have several opinions(change the value only in the current month, change the value for all the next repeat records or change the value in all repeat records).

 

I thought creating an auxiliary table:

Record_Repeat (id_recRep, id_record, repeat (yes / no), repeat_value)

 

In the App, when you see the a month first is shown if are repeated records and the situation is unpaid, then records of the table records. Only when the Records.situation changes to "Paid" or i edit the value this record is saved into the database.

 

I make myself clear?