i am designing a database for my php mysql application. Basically is a cashflow app in wich the user is adding transactions (currency amounts) to control his accounts. I am a newbie in designing databases and i need some help, i hope you can help me.
In the app is two types of transactions:
1. Puntual transactions.
2. Periodic transactions. (you can select the repeating period, each week day, each month day... etc)
The user can convert a puntual transaction into periodic one.
I don't know how to implement that periodic transactions, i was thinking and thinking about it but i don't find the right way to go. Do i need diferent tables? one for puntual transactions and another for periodic? Could you help me with the design? i would like some ideas to get into the right way.