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