|
id
|
int(11)
|
|
|
|
|
vend_id
|
varchar(50)
|
|
|
|
|
contact_type
|
varchar(30)
|
|
|
business
|
|
is_primary
|
tinyint(4)
|
|
|
0
|
|
name
|
varchar(100)
|
|
|
|
|
gender
|
varchar(10)
|
|
|
|
|
position
|
varchar(100)
|
|
|
|
|
department
|
varchar(100)
|
|
|
|
|
phone
|
varchar(50)
|
|
|
|
|
mobile
|
varchar(50)
|
|
|
|
|
email
|
varchar(200)
|
|
|
|
|
fax
|
varchar(50)
|
|
|
|
|
qq
|
varchar(20)
|
|
|
|
|
wechat
|
varchar(50)
|
|
|
|
|
birthday
|
date
|
|
|
|
|
remarks
|
varchar(500)
|
|
|
|
|
sort_order
|
int(11)
|
|
|
0
|
|
is_active
|
tinyint(4)
|
|
|
1
|
|
create_date
|
datetime
|
|
|
|
|
create_by
|
varchar(50)
|
|
|
|
|
last_modify_date
|
datetime
|
|
|
|