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