Credit To Help for Developers

When a registration is cancelled (within the limit) the person gets a credit. The process of giving a credit entails setting an amount. Credits are no longer valid one year after the program start date.

Table: credit

amount
in dollars
date_expires
date after which the credit is no longer available
date_given
self-explanatory
date_used
self-explanatory
id
unique id
person_id
foreign key to person
reg_id
foreign key to registration for which the credit was given
used_reg_id
foreign key to registration for which the credit was taken

Relations

personpersonbelongs_to
reg_givenregistrationbelongs_to
reg_usedregistrationbelongs_to