...
| 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 |
| created_by | VARCHAR | 100 | app user name |
| created_on | DATE | ||
| modified_by | VARCHAR | 100 | |
| modified_on | DATE |
...