|
id
|
int(11)
|
|
|
|
|
cust_id
|
varchar(50)
|
|
|
|
|
cust_name
|
varchar(200)
|
|
|
|
|
cust_short_name
|
varchar(100)
|
|
|
|
|
cust_type
|
varchar(50)
|
|
|
|
|
cust_level
|
varchar(10)
|
|
|
|
|
industry
|
varchar(100)
|
|
|
|
|
main_contact_name
|
varchar(100)
|
|
|
|
|
main_contact_phone
|
varchar(50)
|
|
|
|
|
main_contact_email
|
varchar(200)
|
|
|
|
|
business_license
|
varchar(100)
|
|
|
|
|
tax_number
|
varchar(100)
|
|
|
|
|
sales_person
|
varchar(100)
|
|
|
|
|
sales_team
|
varchar(100)
|
|
|
|
|
cust_sta
|
varchar(50)
|
|
|
active
|
|
is_active
|
tinyint(4)
|
|
|
1
|
|
cust_memo
|
text
|
|
|
|
|
requirements
|
text
|
|
|
|
|
create_date
|
datetime
|
|
|
|
|
create_by
|
varchar(50)
|
|
|
|
|
last_modify_date
|
datetime
|
|
|
|
|
last_modify_by
|
varchar(50)
|
|
|
|
|
tag_id
|
int(11)
|
|
|
|