How should I design my database?
Posted: Mon Mar 24, 2008 9:56 pm
I need to be able to store transaction data, such as a deposit or a withdrawal. Both have 3 feilds, date, desciption, and amount.
Should I create two tables, a deposit table and a withdrawal table
Or have one table called transactions, that stores both, so it will have a fourth field called type(deposit or withdrawal)
What do I have to consider with going for one or the other?
Should I create two tables, a deposit table and a withdrawal table
Or have one table called transactions, that stores both, so it will have a fourth field called type(deposit or withdrawal)
What do I have to consider with going for one or the other?