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?
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users