My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
SuggestedBudgetDBStructure  
Budget Tables Description
Updated Jun 19, 2007 by bibekshr...@gmail.com

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??)
Powered by Google Project Hosting