...
| NAME | Datatype | Length | Remarks |
|---|---|---|---|
| id | BIGINT | 20 | PRIMARY KEY & AUTOINCREMENT |
| loanproduct_id | BIGINT | 20 | FOREIGN KEY |
| category_id | BIGINT | 20 | FOREIGN KEY |
| min_age | BIGINT | 20 | NOT NULL |
| max_age | BIGINT | 20 | NOT NULL |
| provision_percentage | INT | 4 | DEFAULT 0 |
| debitliability_account | VARCHAR | 100 | NOT NULL |
| creditexpense_account | VARCHAR | 100 | NOT NULL |
| created_by | VARCHAR | 100 | app user name |
| created_on | DATE | ||
| modified_by | VARCHAR | 100 | |
| modified_on | DATE |
...
| id | loanproduct_id | category_id | min_age | max_age | provision_percentage | debitliability_account | creditexpense_account | created_by | created_on | modified_by | modified_by |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 10345 | 1 | 0 | 0 | 5 | abcd expenseaccount | provision assetdcba account | Nazeer | 31-Dec-2014 | Vishwas | 10-Jan-2015 |
| 2 | 10345 | 2 | 30 | 60 | 20 | abcd expenseaccount | provision assetdcba account | Nazeer | 31-Dec-2014 | Vishwas | 10-Jan-2015 |
| 3 | 10345 | 3 | 60 | 180 | 50 | abcd expenseaccount | provision assetdcba account | Nazeer | 31-Dec-2014 | Vishwas | 10-Jan-2015 |
| 4 | 10345 | 4 | 180 | 360 | 90 | abcd expenseaccount | provision assetdcba account | Nazeer | 31-Dec-2014 | Vishwas | 10-Jan-2015 |
...