rendered paste body[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.... |
| |
+---------+-------------+------+-----+---------+-------+