| GuaranteeID |
int(11)
|
|
|
|
| Timestamp |
timestamp
|
|
|
|
| UserName |
varchar(20)
|
utf8_general_ci
|
|
|
| BranchOffice |
varchar(20)
|
utf8_general_ci
|
|
|
| Khmername |
varchar(20)
|
utf8_general_ci
|
|
|
| LatinName |
varchar(20)
|
utf8_general_ci
|
|
|
| Sex |
varchar(10)
|
utf8_general_ci
|
|
|
| Nationality |
varchar(10)
|
utf8_general_ci
|
|
|
| Dob |
date
|
|
|
|
| IDCard |
varchar(20)
|
utf8_general_ci
|
|
|
| NoCard |
varchar(20)
|
utf8_general_ci
|
|
|
| DateIssue |
varchar(20)
|
utf8_general_ci
|
|
|
| DateExpir |
varchar(20)
|
utf8_general_ci
|
|
|
| Issued By |
varchar(20)
|
utf8_general_ci
|
|
|
| NoStreet |
varchar(20)
|
utf8_general_ci
|
|
|
| NoHouse |
varchar(10)
|
utf8_general_ci
|
|
|
| Addgroup |
varchar(10)
|
utf8_general_ci
|
|
|
| Village |
varchar(20)
|
utf8_general_ci
|
|
|
| Commune |
varchar(20)
|
utf8_general_ci
|
|
|
| District |
varchar(20)
|
utf8_general_ci
|
|
|
| City |
varchar(20)
|
utf8_general_ci
|
|
|
| Job |
varchar(30)
|
utf8_general_ci
|
|
|
| WorkPlace |
varchar(50)
|
utf8_general_ci
|
|
|
| Role |
varchar(30)
|
utf8_general_ci
|
|
|
| CellPhone |
varchar(20)
|
utf8_general_ci
|
|
|
| HomePhone |
varchar(20)
|
utf8_general_ci
|
|
|
| WorkPhone |
varchar(20)
|
utf8_general_ci
|
|
|
| Email |
varchar(50)
|
utf8_general_ci
|
|
|
| Facebook |
varchar(50)
|
utf8_general_ci
|
|
|
| GuarPhoto |
varchar(20)
|
utf8_general_ci
|
|
|
| Address_Map |
varchar(50)
|
utf8_general_ci
|
|
|
| Relationship |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_KhmerName |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_LatinName |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_Sex |
varchar(10)
|
utf8_general_ci
|
|
|
| Co_Nationality |
varchar(10)
|
utf8_general_ci
|
|
|
| Co_Dob |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_IDCard |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_NoCard |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_DateIssue |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_DateExpir |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_Issued By |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_NoStreet |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_NoHouse |
varchar(10)
|
utf8_general_ci
|
|
|
| Co_Group |
varchar(10)
|
utf8_general_ci
|
|
|
| Co_Village |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_Commune |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_District |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_City |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_Job |
varchar(30)
|
utf8_general_ci
|
|
|
| Co_WorkPlace |
varchar(50)
|
utf8_general_ci
|
|
|
| Co_Role |
varchar(30)
|
utf8_general_ci
|
|
|
| Co_CellPhone |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_HomePhone |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_WorkPhone |
varchar(20)
|
utf8_general_ci
|
|
|
| Co_Email |
varchar(50)
|
utf8_general_ci
|
|
|
| Co_Facebook |
varchar(50)
|
utf8_general_ci
|
|
|
| Co_GuarPhoto |
varchar(20)
|
utf8_general_ci
|
|
|
| Status |
varchar(10)
|
utf8_general_ci
|
|
|
| UserNTm |
varchar(100)
|
utf8_general_ci
|
|
|