[Loan]
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| LoanID  | long        | NO   | PRI | AUTOINC |       |
| Name    | varchar(20) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+


[XAction]
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
|XActionID| long        | NO   | PRI | AUTOINC |       |
| Type    | varchar(20) | NO   |     | PAYMENT |       |
| Amount  | long        | YES  |     | 0       |       |
| LoanID  | varchar(20) | NO   | FOR | NULL    |       |
|                                                      |
| Various things that total transaction amounts....    |
|                                                      |
+---------+-------------+------+-----+---------+-------+