| loanID |
int(11)
|
|
|
|
| TimeStamp |
timestamp
|
|
|
|
| UserName |
varchar(20)
|
utf8_general_ci
|
|
|
| BranchOffice |
varchar(20)
|
utf8_general_ci
|
|
|
| CustomerID |
int(11)
|
|
|
|
| LoanType |
varchar(30)
|
utf8_general_ci
|
|
|
| LoanCycle |
varchar(10)
|
utf8_general_ci
|
|
|
| Currency |
varchar(10)
|
utf8_general_ci
|
|
|
| Loansize |
double
|
|
|
|
| InterestRate |
double
|
|
|
|
| Term |
int(11)
|
|
|
|
| TimePayment |
varchar(20)
|
utf8_general_ci
|
|
|
| PaymentType |
varchar(20)
|
utf8_general_ci
|
|
|
| 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)
|
utf8_general_ci
|
|
|
| LoanPurpose |
varchar(50)
|
utf8_general_ci
|
|
|
| LoanStatus |
varchar(10)
|
utf8_general_ci
|
|
|
| DateWriteOff |
date
|
|
|
|
| ComisionCo |
double
|
|
|
|
| ComisionID |
int(11)
|
|
|
|
| ComisionAgent |
double
|
|
|
|
| Amtfirstday |
double
|
|
|
|
| UserNTm |
varchar(100)
|
utf8_general_ci
|
|
|
