I am creating below table , need your help with this
MemberId(Not sure if this should be here)
Scenario is that, there are multiple societies. Society 'A' may have some different income sources, society 'B' has some different income.
So I created SocietyIncome table. We need to give admin option to set Income sources for his society.
Now in some Income source, that Income is received by Member or as overall income.
e.g, Maintenance Fee is a memberwise income, need to track which member has paid maintenance
while Renting Society ground for Events is a income by society.
So how should be table formed?
Microsoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server
It helps to use an underscore (_) between the master tables in a relationship table.
Sorry, I don't have much time now, but here's a start:
Income ( IncomeId, Name, ... )
Society ( SocietyId, Name, Type?, ... )
Member ( MemberId, Name, ... )
-- identifies income sources and expected/scheduled payments, NOT payment details
Society_IncomeSource ( SourceId, SocietyId, IncomeId, CreateDate, PayDate, TotalAmount, ... )
-- identifies actual payment details ONLY, NOT income source nor schedule of payments
Society_IncomeDetails ( SourceId, ReceivedDate, MemberId (may be NULL if N/A), Amount, ... )