| ID | int(11) |
|
|
|
| TimeStamp | timestamp |
|
|
current_timestamp()
|
| Username | varchar(50) |
|
|
|
| Branchoffice | varchar(50) |
|
|
|
| LoanID | int(11) |
|
|
|
| CustomerID | int(11) |
|
|
|
| DocType | varchar(50) |
|
|
|
| DateIssued | date |
|
|
|
| DocNum | varchar(50) |
|
|
|
| CollateralType | varchar(50) |
|
|
|
| Issuedby | varchar(50) |
|
|
|
| Size | varchar(50) |
|
|
|
| North | varchar(50) |
|
|
|
| South | varchar(50) |
|
|
|
| East | varchar(50) |
|
|
|
| West | varchar(50) |
|
|
|
| Note | varchar(150) |
|
|
|
| EstimatePrice | double |
|
|
|
| Pic | varchar(50) |
|
|
|