First Design
Please check db naming convention if the table names are singluar or plural??
table1(budgetaccount)
--------------------------------
id
accountname (stores like services, products, advertisements, labour)
accounttype (stores whether the account in income or expense, can be done in string)
table2(budgetentry)
--------------------------------
id
startdate
enddate
// remark let the interface handle whether its monthly bimonthly or yearly, doesnot matter to db
table3(budgetamount)
--------------------------------
id
budgetentry_id
budgetaccount_id
budgetamount
projectionamount
actualamount
yeartodateamount (should we put this or calculate automatically??)