| id |
int(11)
|
|
|
|
| vend_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vend_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| vend_short_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| vend_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vend_level |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| industry |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| main_contact |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| main_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| main_email |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| business_license |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| tax_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| bank_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| bank_account |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| cooperation_years |
int(11)
|
|
|
|
| credit_rating |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| payment_terms |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| delivery_terms |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| purchaser |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| source |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vend_sta |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| vend_memo |
text
|
utf8mb4_unicode_ci
|
|
|
| cooperation_history |
text
|
utf8mb4_unicode_ci
|
|
|
| quality_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| create_date |
datetime
|
|
|
|
| create_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| last_modify_date |
datetime
|
|
|
|
| last_modify_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| tag_id |
int(11)
|
|
|
|
