| id |
int(11)
|
|
|
|
| cust_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| cust_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| cust_short_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| cust_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| cust_level |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| industry |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| main_contact_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| main_contact_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| main_contact_email |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| business_license |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| tax_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sales_person |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sales_team |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| cust_sta |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| cust_memo |
text
|
utf8mb4_unicode_ci
|
|
|
| requirements |
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)
|
|
|
|
