I have an expense management system for monthly expenses. Expenses are of two types: one-time monthly expenses, and daily expenses for each day of month. I have created the following tables:
setupExpenses (ExpenseID, Title, IsDaily) ExpenseMaster (ExpenseMasterID, Month, EmployeeID) ExpenseDetails (ExpDetID, ExpenseMasterID, ExpenseID, Date, Amount) ExpenseDetailsDaily(ID, ExpDetID, Date, Amount)
setupExpenses then an entry is made in the 3rd table otherwise I have entries in the other two transaction tables. Any better suggesstion is appreciated. This design doesn't feel right to me.