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