| loanID | int(11) |
|
|
|
| TimeStamp | timestamp |
|
|
current_timestamp()
|
| UserName | varchar(20) |
|
|
|
| BranchOffice | varchar(20) |
|
|
|
| CustomerID | int(11) |
|
|
|
| LoanType | varchar(30) |
|
|
|
| LoanCycle | varchar(10) |
|
|
|
| Currency | varchar(10) |
|
|
|
| Loansize | double |
|
|
|
| InterestRate | double |
|
|
|
| Term | int(11) |
|
|
|
| TimePayment | varchar(20) |
|
|
|
| PaymentType | varchar(20) |
|
|
|
| DateDisbusement | date |
|
|
|
| DateCollect | date |
|
|
|
| DateClose | date |
|
|
|
| StaffID | int(11) |
|
|
|
| DepositRequire | double |
|
|
|
| AdminFee | double |
|
|
|
| OtherFee | double |
|
|
|
| OperationFee | double |
|
|
|
| Saving | double |
|
|
|
| GuaranteeID | int(11) |
|
|
|
| RalationShip | varchar(50) |
|
|
|
| LoanPurpose | varchar(50) |
|
|
|
| LoanStatus | varchar(10) |
|
|
|
| DateWriteOff | date |
|
|
|
| ComisionCo | double |
|
|
|
| ComisionID | int(11) |
|
|
|
| ComisionAgent | double |
|
|
|
| Amtfirstday | double |
|
|
|
| UserNTm | varchar(100) |
|
|
|
