title: Payments Database Design
body: <p>I am currently trying to design a membership type database design that can keep track of monthly payments. I have a couple tables one for keeping track of MEMBERS another to keep track of PLANTYPES(ex. individualmembership plus cost $25.00) or employeemembership plus cost $15.00) which includes a Cost field. </p>
  
  <p>I also have a DUES table where I am trying to keep track of Membership Fees depending on the plan type that is assigned to each member. So the question I have is, so far I have the following fields</p>
  
  <pre><code>DUAAMT, PAID(YES OR NO), DESC(COMMENTS),MEMID(LINKED FIELD TO MEMBERS TABLE),
  PID(LINKED FIELD TO THE PLANTYPES TABLE)
  </code></pre>
  
  <p>I am having trouble figuring out the proper way to keep track of how much the member owes for that month, also what if they paid extra how would I keep track of that?</p>
  
  <p>My idea was to have a Credit a field where any extra money paid would sit in this field and once the month is due I would check if the member had any existing credit first if not they would owe the full amount due that month.</p>