| ID |
int(11)
|
|
|
|
| person_id |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| id_used |
int(20)
|
|
|
|
| PRName |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| NickName |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| Sex |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| PersonID |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| Birthday |
date
|
|
|
|
| Height |
decimal(5,2)
|
|
|
|
| Hobby |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Skill |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Evaluate |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Acq |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| AcqDate |
date
|
|
|
|
| Meet |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| MeetDate |
date
|
|
|
|
| Importance |
tinyint(4)
|
|
|
|
| Email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| WeChat |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| QQ |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| MSN |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| Telephone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| Fax |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| City |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| Address |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| PostCode |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| Company |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| MainBusi |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| preCompany |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| Dept |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Title |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Btel |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| Bfax |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| BWeb |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| CoAddress |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| CoPostCode |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| GroupID |
int(11)
|
|
|
|
| Profession |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Trade |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| CreateDate |
timestamp
|
|
|
|
| ModDate |
timestamp
|
|
|
|
| FBtimes |
int(11)
|
|
|
|
| RPLevel |
int(11)
|
|
|
|
| Relationship |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| TradeValue |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| Remark1 |
text
|
utf8mb4_unicode_ci
|
|
|
| Remark2 |
text
|
utf8mb4_unicode_ci
|
|
|
| Remark3 |
text
|
utf8mb4_unicode_ci
|
|
|
| Remark4 |
text
|
utf8mb4_unicode_ci
|
|
|
| Remark5 |
text
|
utf8mb4_unicode_ci
|
|
|
| PerTag |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| PerSta |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| PerCla |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| college |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| COMID |
int(11)
|
|
|
|
