Search the Community

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?