| id |
int(11)
|
|
|
|
| company_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| customer_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| category |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| tax_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| website |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
| business_card |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| contact_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| department |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| title |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| tel |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ext |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| contact_title |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| contact_phone |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| contact_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'potential', 'inactive')
|
utf8mb4_unicode_ci
|
|
|
| customer_tags |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_level |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| customer_source |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| owner_user_id |
int(11)
|
|
|
|
| owner_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_visit_date |
date
|
|
|
|
| next_followup_date |
date
|
|
|
|
| created_by_user_id |
int(11)
|
|
|
|
| created_by_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
